建站
咨詢
售后
建站咨詢
新聞中心
此文章主要講述的是在DB2數(shù)據(jù)庫中安裝sample數(shù)據(jù)庫與TOLLSDB數(shù)據(jù)庫的正確操作步驟，以及對安裝sample數(shù)據(jù)庫與TOLLSDB數(shù)據(jù)庫是我的小的細節(jié)操作的介紹，以下就是文章的主要內(nèi)容講述。
成都創(chuàng)新互聯(lián)公司專注于企業(yè)成都全網(wǎng)營銷推廣、網(wǎng)站重做改版、振興網(wǎng)站定制設(shè)計、自適應(yīng)品牌網(wǎng)站建設(shè)、H5高端網(wǎng)站建設(shè)、成都商城網(wǎng)站開發(fā)、集團公司官網(wǎng)建設(shè)、外貿(mào)營銷網(wǎng)站建設(shè)、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁設(shè)計等建站業(yè)務(wù)，價格優(yōu)惠性價比高，為振興等各大城市提供網(wǎng)站開發(fā)制作服務(wù)。
數(shù)據(jù)庫, sample, TOLLSDB數(shù)據(jù)庫, sample, TOLLSDB
安裝示例數(shù)據(jù)庫和TOOLSDB數(shù)據(jù)庫：
安裝完成后，欲登陸sample數(shù)據(jù)庫和toolsdb，發(fā)現(xiàn)出錯：
- db2 => connect to sample
- SQL1031N The database directory cannot be found on the indicated file system.
- db2 => connect to toolsdb
- SQL1031N The database directory cannot be found on the indicated file system.
1、 猜想DB2數(shù)據(jù)庫未安裝，查看/hom/db2inst1目錄下的，僅有sqllib文件夾：
- [db2inst1@localhost ~]$ ls
- sqllib
對比下其他學(xué)員的情況，發(fā)現(xiàn)本人的服務(wù)器上少了一個db2inst1目錄：
- [db2inst1@localhost ~]$ ls
- db2inst1 sqllib
2、下面手動對兩個數(shù)據(jù)庫進行創(chuàng)建：
2.1、創(chuàng)建示例數(shù)據(jù)庫：
- [db2inst1@localhost ~]$ 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.2、創(chuàng)建toolsbd數(shù)據(jù)庫：
- [db2inst1@localhost NODE0000]$ db2 create tools catalog systools create new database toolsdb
- DB20000I The CREATE TOOLS CATALOG command completed successfully.
2.3、確認相應(yīng)DB2數(shù)據(jù)庫文件創(chuàng)建的情況：
- [db2inst1@localhost NODE0000]$ cd
- [db2inst1@localhost ~]$ ls
- db2inst1 sqllib
- [db2inst1@localhost ~]$ cd db2inst1/
- [db2inst1@localhost db2inst1]$ ls
- NODE0000
- [db2inst1@localhost db2inst1]$ cd NODE0000/
- [db2inst1@localhost NODE0000]$ ls
- SAMPLE SQL00001 SQL00002 sqldbdir TOOLSDB
2.4、登陸數(shù)據(jù)庫。首先登陸到sample，然后斷開與該數(shù)據(jù)庫的連接，再連接到toolsdb：
- [db2inst1@localhost NODE0000]$ db2
- (c) Copyright IBM Corporation 1993,2007
- Command Line Processor for DB2 Client 9.7.1
- 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 sample
- Database Connection Information
- Database server = DB2/LINUX 9.7.1
- SQL authorization ID = DB2INST1
- Local database alias = SAMPLE
- db2 => disconnect sample
- DB20000I The SQL DISCONNECT command completed successfully.
- db2 => connect to toolsdb
- Database Connection Information
- Database server = DB2/LINUX 9.7.1
- SQL authorization ID = DB2INST1
- Local database alias = TOOLSDB
以上的相關(guān)內(nèi)容就是對DB2數(shù)據(jù)庫中安裝sample數(shù)據(jù)庫和TOLLSDB數(shù)據(jù)庫的介紹，望你能有所收獲。
本文標(biāo)題：DB2數(shù)據(jù)庫中安裝sample數(shù)據(jù)庫與TOLLSDB的步驟描述
當(dāng)前URL：http://www.5511xx.com/article/dhoihdh.html
