db2-getcfg.howto.md

db2 query cfg

get dbm cfg show detail

db2 get snapshot for db on DAD
db2 get snapshot for bufferpools on DAD
db2 get snapshot for locks on DAD
db2 list active databases

CATALOG TCPIP NODE Command

• http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/start/t0005621.htm

Adds a Transmission Control Protocol/Internet Protocol (TCP/IP) node entry to the node directory. The TCP/IP communications protocol is used to access the remote node. The CATALOG TCPIP NODE command is run on a client. Authorization

One of the following:

* sysadm
* sysctrl 

Required connection

None. Directory operations affect the local directory only. Command syntax

Read syntax diagramSkip visual syntax diagram>>-CATALOG--+-------+--TCPIP NODE--nodename--------------------->
            '-ADMIN-'

                            (1)
>--REMOTE--+-hostname---+---------SERVER--service-name---------->
           '-IP address-'

>--+----------------+--+--------------------------------+------->
   '-SECURITY SOCKS-'  '-REMOTE_INSTANCE--instance-name-'

>--+---------------------+--+-------------------------------+--->
   '-SYSTEM--system-name-'  '-OSTYPE--operating-system-type-'

>--+------------------------+----------------------------------><
   '-WITH--"comment-string"-'

other / i don't know

attach to NDEB7AA0  user db2admin using PASSWORD