安裝示例資料庫和TOOLSDB資料庫：

         安裝完成後，欲登陸sample資料庫和toolsdb，發現出錯：

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、  猜想資料庫未安裝，檢視/hom/db2inst1目錄下的，僅有sqllib資料夾：

[db2inst1@localhost ~]$ ls

sqllib

         對比下其他學員的情況，發現本人的伺服器上少了一個db2inst1目錄：

 [db2inst1@localhost ~]$ ls

db2inst1  sqllib

2、下面手動對兩個資料庫進行建立：

         2.1、建立示例資料庫：

[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、建立toolsbd資料庫：

[db2inst1@localhost NODE0000]$ db2 create tools catalog systools create new database toolsdb

DB20000I  The CREATE TOOLS CATALOG command completed successfully.

         2.3、確認相應資料庫檔案建立的情況：

 [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、登陸資料庫。首先登陸到sample，然後斷開與該資料庫的連線，再連線到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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/14600958/viewspace-668553/，如需轉載，請註明出處，否則將追究法律責任。