linux下启动db2数据库命令（国外英文资料）.docVIP

linux下启动db2数据库命令（国外英文资料）DB2 related database commandsStart the database instanceTo start the instance of the database, switch to the db2inst1 user (note: db2inst1 user is an instance of the current database), and then execute the instance of db2start to start the database[root @localhost instance] # su-db2inst1[db2inst1 @localhost ~] $db2startSQL1063N DB2START processing was successful.[db2inst1 @localhost ~] $The shutdown of the database instanceStart by forcing all the applications on the instance under db2inst1 user and then close the database instance[db2inst1 @localhost ~] $db2 force application allDB20000I The FORCE APPLICATION command completed successfully.The DB21024I This command is asynchronous and may not be effective immediately.[db2inst1 @localhost ~] $db2stopSQL1064N DB2STOP processing was successful.[db2inst1 @localhost ~] $Forced to stop[db2inst1 @localhost DB2] $db2stop forceSQL1064N DB2STOP processing was successful.[db2inst1 @ localhost DB2] $Display all instances[db2inst1 @localhost ~] $db2ilistdb2inst1[db2inst1 @localhost ~] $Show the current instance[db2inst1 @localhost ~] $db2 get instanceThe current database manager instance is: db2inst1[db2inst1 @localhost ~] $Remove an instance (note: switch to root user rights)[root @ localhost ~] # CD/opt/IBM/db2 / V9.7 / instance[root @localhost instance] # PWD/ opt/IBM/db2 / V9.7 / instance[root @ localhost instance] #. / db2idrop db2inst1DBI1070I Program db2idrop completed successfully.[root @ localhost instance] #List the databases in the current instance[root @localhost instance] # su-db2inst1[db2inst1 @localhost ~] $db2 list db directorySQL1031N The database directory cannot be found on The indicated file system.SQLSTATE = 58031,[db2inst1 @localhost ~] $Note: the above information indicates that there is no database in the instanceCreate a database[root @localhost instance] # su-db2inst1[db2inst1 @localhost ~] $db2 create database testSQL1032N No start database manager command was issued. SQLSTATE