(taoewang@bugdbug) /home/taoewang/sqllib $ db2start

03/27/2008 14:15:25     1   0   SQL1063N  DB2START processing was successful.

03/27/2008 14:15:25     0   0   SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

SQL1063N  DB2START processing was successful.

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 create db sample

db2 "DB20000I  The CREATE DATABASE command completed successfully.

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 "create database partition group part1 on dbpartitionnum (0)"

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL1024N  A database connection does not exist.  SQLSTATE=08003

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 connect to sample

Database Connection Information

Database server        = DB2/6000 8.2.6

SQL authorization ID   = TAOEWANG

Local database alias   = SAMPLE

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 "create database partition group part1 on dbpartitionnum (0)"

DB20000I  The SQL command completed successfully.

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 "create tablespace tbspcs1 in part1 managed by system using ('/TMP/taoewang/temp/sms1')"

DB20000I  The SQL command completed successfully.

(taoewang@bugdbug) /home/taoewang/sqllib $ db2 "create table t1 (c1 int, c2 char(10)) in tbspcs1"

DB20000I  The SQL command completed successfully.

(taoewang@bugdbug) /home/taoewang/sqllib $ cd /TMP/taoewang/temp

(taoewang@bugdbug) /TMP/taoewang/temp $ ls

sms1      test.ixf

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 "load from test.ixf of ixf insert into t1"

SQL3004N  The filetype parameter is not valid.

(taoewang@bugdbug) /TMP/taoewang/temp $ db2set DB2_PARTITIONEDLOAD_DEFAULT=NO

(taoewang@bugdbug) /TMP/taoewang/temp $ db2stop force

db2start

03/27/2008 15:13:01     0   0   SQL1064N  DB2STOP processing was successful.

03/27/2008 15:13:02     1   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

(taoewang@bugdbug) /TMP/taoewang/temp $ db2start

03/27/2008 15:13:11     1   0   SQL1063N  DB2START processing was successful.

03/27/2008 15:13:12     0   0   SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.

SQL1063N  DB2START processing was successful.

(taoewang@bugdbug) /TMP/taoewang/temp $ export DB2NODE=1

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 terminate

dDB20000I  The TERMINATE command completed successfully.

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 connect to sample

Database Connection Information

Database server        = DB2/6000 8.2.6

SQL authorization ID   = TAOEWANG

Local database alias   = SAMPLE

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 list tablespaces

Tablespaces for Current Database

Tablespace ID                        = 1

Name                                 = TEMPSPACE1

Type                                 = System managed space

Contents                             = System Temporary data

State                                = 0x0000

Detailed explanation:

Normal

Tablespace ID                        = 2

Name                                 = USERSPACE1

Type                                 = System managed space

Contents                             = Any data

State                                = 0x0000

Detailed explanation:

Normal

DB21011I  In a partitioned database server environment, only the table spaces

on the current node are listed.

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 terminate

DB20000I  The TERMINATE command completed successfully.

(taoewang@bugdbug) /TMP/taoewang/temp $ export DB2NODE=0

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 connect to sample

db2 list

Database Connection Information

Database server        = DB2/6000 8.2.6

SQL authorization ID   = TAOEWANG

Local database alias   = SAMPLE

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 list tablespace

SQL0104N  An unexpected token "END-OF-STATEMENT" was found following

"TABLESPACE".  Expected tokens may include:  "CONTAINERS".  SQLSTATE=42601

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 list tablespaces

Tablespaces for Current Database

Tablespace ID                        = 0

Name                                 = SYSCATSPACE

Type                                 = System managed space

Contents                             = Any data

State                                = 0x0000

Detailed explanation:

Normal

Tablespace ID                        = 1

Name                                 = TEMPSPACE1

Type                                 = System managed space

Contents                             = System Temporary data

State                                = 0x0000

Detailed explanation:

Normal

Tablespace ID                        = 2

Name                                 = USERSPACE1

Type                                 = System managed space

Contents                             = Any data

State                                = 0x0000

Detailed explanation:

Normal

Tablespace ID                        = 3

Name                                 = TBSPCS1

Type                                 = System managed space

Contents                             = Any data

State                                = 0x0000

Detailed explanation:

Normal

DB21011I  In a partitioned database server environment, only the table spaces

on the current node are listed.

(taoewang@bugdbug) /TMP/taoewang/temp $ db2 "load from test.ixf of ixf modified by noheader insert into t1"

SQL3501W  The table space(s) in which the table resides will not be placed in

backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file

"/net2/d_TMP/TMP/taoewang/temp/test.ixf".

SQL3500W  The utility is beginning the "LOAD" phase at time "03/27/2008

15:56:22.804502".

SQL3150N  The H record in the PC/IXF file has product "DB2    02.00", date

"20080327", and time "140956".

SQL3153N  The T record in the PC/IXF file has name "test.ixf", qualifier "",

and source "            ".

SQL3519W  Begin Load Consistency Point. Input record count = "0".

SQL3520W  Load Consistency Point was successful.

SQL3110N  The utility has completed processing.  "18" rows were read from the

input file.

SQL3519W  Begin Load Consistency Point. Input record count = "18".

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "03/27/2008

15:56:22.847239".

Number of rows read         = 18

Number of rows skipped      = 0

Number of rows loaded       = 18

Number of rows rejected     = 0

Number of rows deleted      = 0

Number of rows committed    = 18

(taoewang@bugdbug) /home/taoewang/sqllib $ db2start03/27/2008 14:15:25 1 0 SQL1063NDB2START processing was successful.03/27/2008 14:15:25 0 0 SQL5043NSupport for one or more commun... com.ibm. db2 .jcc.b.nm: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= DB2 ADMIN.SOFT_VERSION, DRIVER=3.50.152 原因是：表SOFT_VERSION不是直接在 DB2 ADMIN下面，应在 DB2 命令编辑器查看SOFT_VERSION在那个目录下面。