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.
This topic has been locked.
Pinned topic DB2 Table entry after setting server unavailable
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Re: DB2 Table entry after setting server unavailable2012-04-27T16:49:30ZThis is the accepted answer. This is the accepted answer.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:
public boolean isServerAvailable( boolean fromAdmin)
Checks to see whether this resource manager is currently online
fromAdmin - if the administrator is setting or runtime client
true if resource manager is available, false if resource manager has been marked as offline
public void setServerAvailable( boolean serverAvail,
Sets to whether this resource manager is currently online
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,
Resource Manager flags. The settings are interpreted in a bitwise mode, starting from right to left:
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.
Resource manager is unavailable (set by the library server watchdog).
Resource manager is offline (set by the SysAdmin).