DB2入门操作之一

来源：互联网发布：格式化的数据恢复编辑：程序博客网时间：2024/06/06 18:39

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

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

1.DB2启动关闭

--关闭db2
[db2inst1@xifenfei ~]$ db2stop
03/28/201209:23:39     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
 
--开启db2
[db2inst1@xifenfei ~]$ db2start
03/28/201209: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 entriesinthe directory = 1
 
Database 1 entry:
 
 Databasealias                      = TOOLSDB
 Database name                        = TOOLSDB
 Local database directory             =/home/db2inst1
 Database release level               = d.00
 Comment                              =
 Directory entrytype                = Indirect
 Catalog database partition number    = 0
 Alternate serverhostname           =
 Alternate server port number         =

3.连接DB2数据库

[db2inst1@xifenfei ~]$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line ProcessorforDB2 Client 9.7.4
 
You can issue database manager commands and SQL statements from thecommand
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd
 
For general help,type: ?.
For commandhelp,type: ?command, wherecommandcan be
the first few keywords of a database managercommand. For example:
 ? CATALOG DATABASEforhelp on the CATALOG DATABASEcommand
 ? CATALOG         forhelp on all of the CATALOG commands.
 
To exitdb2 interactive mode,typeQUIT at thecommandprompt. Outside
interactive mode, all commands must be prefixed with'db2'.
To list the currentcommandoption settings,typeLIST COMMAND OPTIONS.
 
For moredetailed help, refer to the Online Reference Manual.
 
db2 => connect to TOOLSDB
 
   Database Connection Information
 
 Database server        = DB2/LINUX9.7.4
 SQL authorization ID   = DB2INST1
 Local databasealias  = TOOLSDB

4.查看数据库中包含包

db2 => list tables
 
Table/View                     Schema          Type  Creationtime            
------------------------------- --------------- ----- --------------------------
 
  0 record(s) selected.
 
db2 => create table t_xff (idint,name varchar(100))
DB20000I  The SQL command completed successfully.
db2 => list tables
 
Table/View                     Schema          Type  Creationtime            
------------------------------- --------------- ----- --------------------------
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 whereid=1
DB20000I  The SQLcommandcompleted successfully.
db2 => select* from t_xff
 
ID          NAME                                       
----------- -----------------------------------------
          2 www.xifenfei                            
 
  1 record(s) selected.
 
db2 => quit
DB20000I  The QUITcommandcompleted successfully.

0 0