Computer and IT knowledge - things to know
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 :: © 2024