The database used by the company is Kanakura and DB2
To open the DB2 directly with the command window, you need to enter it in CMD: db2cmd
1: start DB2 database: Db2start
2: Connect to Database: DB2 connect to database name
3:: Create DATABASE: DB2 Create DB database name
4: Delete database: DB2 drop DB database name
5: View table Spatial structure: DB2 list tablespaces
6: View the physical path of the system tablespace DB2 list tablespaces container For 0
7: Backup DATABASE: DB2 backup DB database name to D: here D: refers to the drive letter
8: Restore DATABASE: DB2 RESTORE database name from D:\ taken at time symbol on D:\
9: Append database restore: DB2 restore database name from the D:\taken at time symbol into SX without rolling forward
10. Copy the current file to a remote server scp/home/xxx.txt [email protected]:/home/root
Version query for 11:DB2: Su-db2insta1 db2level
12: Add column: ALTER TABLE name add column name type
13; Delete column: ALTER TABLE table name drop column name
14: Create user input command useradd-d/home/-M phis enter passwd phis Enter password Confirm password OK gppasswd-a phis Test add phis user to test user group
15: Database repair: 1>:cmd input db2cmd-c DB2 2>:d B2 Connect to user username using password (login database). 3>:reorg table name This is a table fix
16: Deal with DB2 database state inconsistency 1>: db2stop Force stop database .2>:d b2start start database 3>:d B2 connect to database name 4>:d b2 Terminate disconnect
5>: Backup operation command: DB2 backup DB database name to drive letter:
17:DB2 server to modify the computer name can not start the problem in the Server C disk to find the Db2diag.log file, open it has the original computer name, modified back to restart the computer.
18:DB2 Error query DB2 list DB diretory DB2 terminate DB2 Force application DB2 Restore DB database name On/home/db2inst1 redir ECT generate script RHIO2.CLP rolling forward DB2-TVF RHIO2.CLP
About the use of DB2 (DB2 data command)