db2 commands:

db2 "connect to report user user1"
db2 select name from sysibm.systables #show systables
db2 select * from COMPINFO



db2 LIST DATABASE DIRECTORY #show tables
db2 list applications for database IBMSECW #show connected processes
db2 force application ( <enter here list of application-ids form previous command separated by commas>)
db2 force application "ALL"

db2 use database name
db2 list tables

db2 get dbm cfg ##get database manager configuration

db2log:
/opt/ldap/db2cli.log

select * from stddat where XEORF = 'X' Fetch First 5 Rows Only

computer2know :: thank you for your visit :: have a nice day :: © 2018