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