Db2 learning instruction (2)

21. check the local node db2 list node direcotry 22. node deserialization db2 uncatalog node node_name www.2cto.com 23. database cataloguing db2 catalog db db_name as db_alias at node node_name 24. view the database catalog db2 list db directory 25. connect to the database db2 connect to db_alias user user_name using user_password 26. database deserialization db2 uncatalog db db_alias 27. export data db2 export to myfile of ixf messages msg select * from tb1 28. import Data db2 import from myfile of ixf messages msg replace into tb1 29. export all table data of the database db2move test export 30. generate database definition www.2cto.com db2look-d db_alias-a-e-m-l-x-f-o db2look. SQL 31. create Database db2 create db test1 32. generate the definition db2-tvf db2look. SQL 33. import all database data db2move db_alias import 34. reorganizations check db2 reorgchk 35. restructured the table tb1 db2 reorg table tb1 36. update statistical information db2 runstats on table tb1 37. backup database test db2 backup db test 38. recover database test db2 restore db test 39. list the container information db2 list tablespace containers for tbs_id show detail www.2cto.com 40. create a table: db2 ceate table tb1 (id integer not null, name char (10) create table tb1 like tb2 in tablespace partitioning key (kpi_id) using hashing; view the snapshot select * from tb1 with ur; by manULinux