Topic
2 replies Latest Post - ‏2012-05-03T06:56:25Z by SystemAdmin
SystemAdmin
SystemAdmin
228 Posts
ACCEPTED ANSWER

Pinned topic DB2 Table entry after setting server unavailable

‏2012-04-27T11:04:55Z |
Hello,

does anybody know in which db2 table the settings change when i set the Ressourcemanager to offline in the System Administration Client ?

We habe two Ressource Manager, each with a TSM Server an a Centera Storage.
My ambition is that, if one TSM Server or one Centera isn't online, i can set the entry and the Content Manager becomes offline.
The Content Manager cant't do that himself if a TSM Server or Centera fails.

Somebody told me that we must change the db2 entry on an table and the Server becomes offline.

thank you for your help.

Frank
Updated on 2012-05-03T06:56:25Z at 2012-05-03T06:56:25Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    228 Posts
    ACCEPTED ANSWER

    Re: DB2 Table entry after setting server unavailable

    ‏2012-04-27T16:49:30Z  in response to SystemAdmin
    The official way is
    1. logon to SysAdmin client
    2. expand RM tree
    3. right client on the RM server you want to set offline and select properties
    4. check the checkbox of setting offline in the properties panel

    Or you can write a Java program:
    com.ibm.mm.sdk.common
    Class DKResourceMgrDefICM
    isServerAvailable

    public boolean isServerAvailable( boolean fromAdmin)

    Checks to see whether this resource manager is currently online
    Parameters:
    fromAdmin - if the administrator is setting or runtime client
    Returns:
    true if resource manager is available, false if resource manager has been marked as offline

    setServerAvailable

    public void setServerAvailable( boolean serverAvail,
    boolean fromAdmin)

    Sets to whether this resource manager is currently online
    Parameters:
    serverAvail - - true if want to set the resource manager offline, false otherwise
    fromAdmin - - if the administrator is setting or runtime client
    It is strongly NOT recommended to change the table value directly because it is not a supported behavior by IBM.

    For your information,
    http://publib.boulder.ibm.com/infocenter/cmgmt/v8r4m0/topic/com.ibm.systemtables.doc/icmstresourcemgr.htm

    RMFlags
    Resource Manager flags. The settings are interpreted in a bitwise mode, starting from right to left:

    Bit 0
    Indicates that the LAN CACHE for the resource manager is on. 1 indicates that the LAN CACHE is on. 0 indicates that the LAN CACHE is off.
    Bit 1
    Resource manager is unavailable (set by the library server watchdog).
    Bit 2
    Resource manager is offline (set by the SysAdmin).
    • SystemAdmin
      SystemAdmin
      228 Posts
      ACCEPTED ANSWER

      Re: DB2 Table entry after setting server unavailable

      ‏2012-05-03T06:56:25Z  in response to SystemAdmin
      Hello mangrongho,

      thank you for your help, i will carefully read this .......