db2 数据恢复linux,DB2V8.2数据恢复到v9.5 ONAIX

bash-3.2$ db2 restore database BPFDB from /db2/back/ taken at 20110221030637 to /db2/bpfdb with 3 buffers buffer 1024 replace existing redirect WITHOUT ROLLING FORWARD

SQL2523W  Warning!  Restoring to an existing database that is different from

the database on the backup image, but have matching names. The target database

will be overwritten by the backup version.  The Roll-forward recovery logs

associated with the target database will be deleted.

SQL1277W  A redirected restore operation is being performed.  Table space

configuration can now be viewed and table spaces that do not use automatic

storage can have their containers reconfigured.

DB20000I  The RESTORE DATABASE command completed successfully.

bash-3.2$ db2 list tablespaces

Tablespaces for Current Database

Tablespace ID                        = 0

Name                                 = SYSCATSPACE

Type                                 = System managed space

Contents                             = All permanent data. Regular table space.

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined

Tablespace ID                        = 1

Name                                 = TEMPSPACE1

Type                                 = System managed space

Contents                             = System Temporary data

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined

Tablespace ID                        = 2

Name                                 = USERSPACE1

Type                                 = System managed space

Contents                             = All permanent data. Regular table space.

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined

Tablespace ID                        = 3

Name                                 = UTMTP32

Type                                 = System managed space

Contents                             = User Temporary data

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined

Tablespace ID                        = 4

Name                                 = SYSTOOLSPACE

Type                                 = System managed space

Contents                             = All permanent data. Regular table space.

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined

Tablespace ID                        = 5

Name                                 = QCTEMPTSbash-3.2$ pwd

/db2/bpfdb

bash-3.2$ mkdir 0

bash-3.2$ db2 "set tablespace containers for 0 using (path '/db2/bpfdb/0')"

DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.

bash-3.2$ db2 "set tablespace containers for 1 using (path '/db2/bpfdb/1')"

SQL0299N  Container is already assigned to the table space.  SQLSTATE=42731

bash-3.2$ db2 "set tablespace containers for 2 using (path '/db2/bpfdb/2')"

db2 "set tablespace containers for 3 using (path '/db2/bpfdb/3')"

db2 "set tablespace containers for 4 using (path '/db2/bpfdb/4')"

db2 "set tablespace containers for 5 using (path '/db2/bpfdb/5')"

SQL0299N  Container is already assigned to the table space.  SQLSTATE=42731

bash-3.2$ db2 "set tablespace containers for 3 using (path '/db2/bpfdb/3')"

SQL0299N  Container is already assigned to the table space.  SQLSTATE=42731

bash-3.2$ db2 "set tablespace containers for 4 using (path '/db2/bpfdb/4')"

SQL0299N  Container is already assigned to the table space.  SQLSTATE=42731

bash-3.2$ db2 "set tablespace containers for 5 using (path '/db2/bpfdb/5')"

SQL0299N  Container is already assigned to the table space.  SQLSTATE=42731

bash-3.2$

Type                                 = System managed space

Contents                             = User Temporary data

State                                = 0x2001100

Detailed explanation:

Restore pending

Storage must be defined

Storage may be defined