Wednesday, July 7, 2021

Db2 commands

To catalog a Node  
   db2 "catalog TCPIP Node <<nodename>> REMOTE <<REMOTE SERVER IP>> SERVER <<PORT NUMBER>> SECURITY SSL"

To catalog  a database
   db2 "catalog Database <<database_name>> as <<alias_name>> at Node <<node_name>>

To view the configuration of database management like SSL 

db2 get dbm cfg

To set the configuration of database management like SSL 

db2 update dbm cfg using SSL_CLIENT_KEYDB <<path>> 

to list the databases 

db2 list database directory

to list the nodes 

db2 list node directory

To know the database backup status use the below queries

SELECT COORD_MEMBER, APPLICATION_HANDLE AS APPHDL,
   SUBSTR(APPLICATION_NAME, 1, 10) AS APPNAME,
   SUBSTR(SESSION_AUTH_ID, 1, 10) AS USER,
   SUBSTR(UTILITY_DETAIL, 1, 150) AS CMD
FROM TABLE(MON_GET_UTILITY(-2)) AS T

SELECT UTILITY_ID, UTILITY_TYPE, UTILITY_STATE, *   FROM TABLE(SNAP_GET_UTIL(-1)) AS T


select  PROGRESS_COMPLETED_UNITS, PROGRESS_TOTAL_UNITS  FROM TABLE(SNAP_GET_UTIL_PROGRESS(-1)) AS T 


No comments:

Post a Comment