ITM6 query node info with KDSTSNS command in a shell script

iKnow-IT banner

Be very carefull with the use of "kdstsns" command. If you do not understand this, do not use it!!!!

# more NODE_status.sql
SELECT O4ONLINE, NODE, PRODUCT FROM O4SRV.INODESTS;

In the following example the settings can be different in your environment! see an example in you (agent) configuration files (e.g. KDC_FAMILIES can be different).

# more NodeStatus.ksh

CheckNodeStatus()
{
       export SQLLIB=.
       export KDC_FAMILIES='ip.spipe port:3660 ip use:n ip.pipe use:n sna use:n HTTP:1920'
       export LIBPATH=$CANDLEHOME/tmaitm6/aix526/lib
       export KDEBE_KEYRING_FILE=$CANDLEHOME/keyfiles/keyfile.kdb
       export KDEBE_KEYRING_STASH=$CANDLEHOME/keyfiles/keyfile.sth
       $CANDLEHOME/aix536/ms/bin/kdstsns NODE_status.sql '*HUB'
}

CheckNodeStatus