db2创建数据库

最新推荐文章于 2024-09-05 18:37:46 发布

feier7501

最新推荐文章于 2024-09-05 18:37:46 发布

阅读量977

点赞数

CC 4.0 BY-SA版权

分类专栏： DB2

本文链接：https://blog.youkuaiyun.com/feier7501/article/details/19435959

DB2 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了如何使用DB2客户端创建、连接、列出表并退出交互模式的基本操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[db2inst1@localhost ~]$ db2 create database testdb
DB20000I  The CREATE DATABASE command completed successfully.
[db2inst1@localhost ~]$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.6

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 testdb         

   Database Connection Information

 Database server        = DB2/LINUX 9.7.6
 SQL authorization ID   = DB2INST1
 Local database alias   = TESTDB

db2 => list tables

Table/View                      Schema          Type  Creation time             
------------------------------- --------------- ----- --------------------------

  0 record(s) selected.

db2 => quit 
DB20000I  The QUIT command completed successfully.
[db2inst1@localhost ~]$