11.1 ִ˫ڵϵͳϴ

CREATE TABLESPACE TS1 MANAGED BY DATABASE
USING
(device /dev/rcont $N 20000)


11.2 ִĽڵϵͳϴ

CREATE TABLESPACE TS2 MANAGED BY DATABASE
USING
(file /DB2/containers/TS2/container $N+100 10000)


11.3 ִ˫ڵϵͳϴ

CREATE TABLESPACE TS3 MANAGED BY SYSTEM
USING
(/TS3/cont $N%2, /TS3/cont $N%2+2)

11.7 db2ckbkpUNIXƽ̨ϵʵ

db2ckbkp SAMPLE.0.krodger.NODE0000.CATN0000.19990817150714.001

SAMPLE.0.krodger.NODE0000.CATN0000.19990817150714.002
SAMPLE.0.krodger.NODE0000.CATN0000.19990817150714.003
[1] Buffers processed: ##
[2] Buffers processed: ##
[3] Buffers processed: ##

Уdb2ckbkp߳ɹӳȷϡ
11.8 db2ckbkpWindowsƽ̨ϵʵ
db2ckbkp SAMPLE.0\krodger\NODE0000\CATN0000\19990817\150714.001

SAMPLE.0\krodger\NODE0000\CATN0000\19990817\150714.002
SAMPLE.0\krodger\NODE0000\CATN0000\19990817\150714.003
[1] Buffers processed: ##
[2] Buffers processed: ##
[3] Buffers processed: ##

Уdb2ckbkp߳ɹӳȷϡ
11.9 db2ckbkpWindowsƽ̨ϵһʵ

db2ckbkp -h SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909.001

=====================
MEDIA HEADER REACHED:
=====================
Server Database Name -- SAMPLE2
Server Database Alias -- SAMPLE2
Client Database Alias -- SAMPLE2
Timestamp -- 19990818122909
Database Partition Number -- 0
Instance -- krodger
Sequence Number-- 1
Release ID -- 900
Database Seed -- 65E0B395
DB Comments Codepage (Volume) -- 0
DB Comment (Volume) --
DB Comments Codepage (System) -- 0
DB Comment (System) --
Authentication Value -- 255
Backup Mode -- 0
Backup Type -- 0
Backup Gran. -- 0
Status Flags -- 11
System Cats inc -- 1
Catalog Database Partition No. -- 0
DB Codeset -- ISO8859-1
DB Territory --
Backup BufferSize -- 4194304
Numberof Sessions -- 1
Platform -- 0
The proper image file name would be:
SAMPLE2.0.krodger.NODE0000.CATN0000.19990818122909.001
[1] Buffers processed: ####
Уdb2ckbkp߳ɹӳȷϡ

11.10
db2ckrst -d mr-t 20001015193455 -rdatabase
db2ckrst -d mr-t 20001015193455 -rtablespace
db2ckrst -d mr-t 20001015193455 -rtablespace -n tbsp1 tbsp2
> db2 backup db mr

Backup successful. The timestamp forthis backup image is : 20001016001426
> db2 backup db mrincr emental

Backup successful. The timestamp forthis backup image is : 20001016001445
> db2ckrst -d mr -t 20001016001445

Suggested restore order of images using timestamp 20001016001445 for database mr.
=================================================================
db2 restore db mr incremental taken at 20001016001445
db2 restore db mr incremental taken at 20001016001426
db2 restore db mr incremental taken at 20001016001445
=================================================================
> db2ckrst -d mr-t 20001016001445 -rtablespace -n userspace1

Suggested restore order of images using timestamp 20001016001445 for
database mr.
=================================================================
db2 restore db mr tablespace ( USERSPACE1 ) incremental taken at
20001016001445
db2 restore db mr tablespace ( USERSPACE1 ) incremental taken at
20001016001426
db2 restore db mr tablespace ( USERSPACE1 ) incremental taken at
20001016001445
=================================================================

11.11
db2flsn 000000BF0030
Given LSN is contained in log file S0000002.LOG
db2flsn -q 000000BF0030
S0000002.LOG
db2flsn 000000BE0030

