1.DB2 list tables-Displays all tables for the current user. &NBSP;2.DB2 List application-View connections for all databases. 3.db2move < database name > export--Export Database Data. 4.db2move MASDB8 export-tn tbl_smresult_0213/>>ac.txt--Export the table in the database &NBSP;5.DB2 select * FROM biaoming Fetch First-n Rows only-Branch query data. &NBSP;6.DB2 ' Select Table name 1.destaddr, table name 2.messageid from table name 1 LEFT OUTER JOIN table name 2 on table name 1.messageid= table name 2.messageid '--Query the same word in two days table Paragraph 7. db2mtrk-i-d-v--View the instance shared memory. The &NBSP;8.DB2 describe table name/DB2 ' select * FROM table name-describes the structure of a table. 9.update tbl_smresult_0314 set recv_status= ' 0 ' where left (subtime,16) = ' 2013-03-14-09.21 '--modifies the data in the table. 10. " Delete from tbl_groupmemberrelation where groupcode= ' $ ' "," delete from Tbl_member where Membercode not in (select Memberc Ode from Tbl_groupmemberrelation)--delete the ungrouped numbers in the Personal Address Book. &NBSP;11.DB2 get dbm cfg--View the DB2 service name. 12.taskkill/f/im--ends the Java process. &NBSP;13.QM list 14. db2 "Select Destaddr,replace (replace (SM_CONTENT,CHR (+), ' a '), Chr (+), ' B ') From tbl_smresult_0726 where Destaddr = ' 13237294963 '--query space.
DB2 Database Common commands