DB2入门操作之一

联系： 手机(13429648788) QQ(107644445)

链接：http://www.xifenfei.com/2776.html

1.DB2启动关闭

--关闭db2 [db2inst1@xifenfei ~]$ db2stop 03 /28/2012 09:23:39     0   0   SQL1064N  DB2STOP processing was successful. SQL1064N  DB2STOP processing was successful.   --开启db2 [db2inst1@xifenfei ~]$ db2start 03 /28/2012 09:23:55     0   0   SQL1063N  DB2START processing was successful. SQL1063N  DB2START processing was successful.

2.查看DB2数据库

[db2inst1@xifenfei ~]$ db2 list db directory     System Database Directory     Number of entries in the directory = 1   Database 1 entry:     Database alias                       = TOOLSDB   Database name                        = TOOLSDB   Local database directory             = /home/db2inst1   Database release level               = d.00   Comment                              =   Directory entry type                 = Indirect   Catalog database partition number    = 0   Alternate server hostname            =   Alternate server port number         =

3.连接DB2数据库

[db2inst1@xifenfei ~]$ db2 (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 9.7.4   You can issue database manager commands and SQL statements from the command prompt. For example:      db2 => connect to sample      db2 => bind sample.bnd   For general help, type : ?. For command help, type : ? command , where command can be the first few keywords of a database manager command . For example:   ? CATALOG DATABASE for help on the CATALOG DATABASE command   ? CATALOG          for help on all of the CATALOG commands.   To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prefixed with 'db2' . To list the current command option settings, type LIST COMMAND OPTIONS.   For more detailed help, refer to the Online Reference Manual.   db2 => connect to TOOLSDB       Database Connection Information     Database server        = DB2 /LINUX 9.7.4   SQL authorization ID   = DB2INST1   Local database alias   = TOOLSDB

4.查看数据库中包含包

db2 => list tables   Table /View                      Schema          Type  Creation time             ------------------------------- --------------- ----- --------------------------      0 record(s) selected.   db2 => create table t_xff ( id int,name varchar(100)) DB20000I  The SQL command completed successfully. db2 => list tables   Table /View                      Schema          Type  Creation time             ------------------------------- --------------- ----- -------------------------- T_XFF                           DB2INST1        T     2012-03-28-09.29.54.572395      1 record(s) selected.

5.常见DML操作

db2 =>  insert into t_xff values(1, 'xifenfei' ) DB20000I  The SQL command completed successfully. db2 => insert into t_xff values(2, 'www.xifenfei' ) DB20000I  The SQL command completed successfully. db2 => select * from t_xff   ID          NAME                ----------- ---------------------------------------            1 xifenfei                      2 www.xifenfei            2 record(s) selected.   db2 => delete from t_xff where id =1 DB20000I  The SQL command completed successfully. db2 => select * from t_xff   ID          NAME                                        ----------- -----------------------------------------            2 www.xifenfei                                  1 record(s) selected.   db2 => quit DB20000I  The QUIT command completed successfully.