ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> DB2 >> DB2入门(1)--安装、启动、连接

DB2入门(1)--安装、启动、连接(3/4)

来源:网络整理     时间:2017-04-06     关键词:

本篇文章主要介绍了" DB2入门(1)--安装、启动、连接",主要涉及到方面的内容,对于DB2感兴趣的同学可以参考一下: 1.安装数据库windows下的安装软件下载直接是从官网下载的, 下载免费试用版学习一下: 1. 进入官网,点击“Free DB2 trials” 2. 然后...

$ db2admin start  ----启动DB2管理服务器
$su - db2inst1
[db2inst1@bogon adm]$ db2start    ----启动数据库实例
SQL1063N  DB2START processing was successful.
[db2inst1@bogon adm]$ db2 createdatabase test   ----创建数据库实例
DB20000I  The CREATEDATABASE command completed successfully.
[db2inst1@bogon adm]$ db2   ----连接数据库
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 11.1.1.1You can issue database manager commands andSQL statements from the command 
prompt. For example:
    db2 => connectto 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:
 ? CATALOGDATABASEfor help on the CATALOGDATABASE command
 ? CATALOGfor help onallof 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 => 
一些概念

管理服务器:
DAS(Database Administration Server):数据库管理服务器。
DAS与实例是一对多的关系,DAS可以同时管理多个实例。
DAS允许使用DB2工具对服务器上的数据库进行本地和远程管理。事实上,为了利用这些工具,DAS服务器必须存在并被启动。

相关图片

相关文章