Db2start starting the database
Db2stop Stop Database
DB2 Connect to dbname user username using pwd Connection Database
DB2 get dbm CFG view Database Manager configuration
DB2 update dbm CFG using SVCENAME 55000 change listening port
Db2ilist viewing a DB instance
DB2 list Tables list all user tables
DB2 describe table tablename display tables structure
DB2 List DB directory lists all databases
DB2 list node directory lists database nodes
DB2 list Active databases lists all active databases
DB2 terminate closing the database connection
Db2set Db2comm=tcpip to open DB2 TCP service
Db2set db2codepage=1386 Set Database code page for Simplified Chinese
DB2 catalog TCPIP node db2node remote hostname Server service_port add nodes Catalog
DB2 Catalog Database db_name as alias_name at node db2node . Increasing the cataloging of databases
DB2 Common Commands