ted successfully.
#su - db2inst1
$db2 www.2cto.com
db2 => Connect to test user db2inst1
Enter current password for db2inst1:
Database Connection Information
Database server = DB2/LINUX 9.7.5
SQLauthorization ID = DB2INST1
Local database alias = TEST
db2 =>
附录：
#su - db2inst1
$ $cd /opt/ibm/db2/V9.7/bin
$ ./db2sampl
Creating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema"DB2INST1"...
'db2sampl' processing complete.
2、访问刚创建的数据库
$ db2
www.2cto.com
db2 => connect to sample
Database Connection Information
Database server = DB2/LINUX 9.7.5
SQLauthorization ID = DB2INST1
Local database alias = SAMPLE
db2 =>
3、常用操作命令
db2 =>connect to sample ---连接到sample数据库
db2 =>list tables ---查看库下面的所有表
db2 => select * from staff wheredept=10 ---查询某张表dept等于10的所有记录
db2 => quit www.2cto.com ---退出db2
DB20000I The QUIT command completed successfully.
$ db2ilist; ---查看实例列表
db2inst1
$ db2 get instance ---查看当前所运行的实例
Thecurrent database manager instance is: db2inst1
作者 吴伟龙