分类： DB2/Informix
2013-07-21 09:20:08
$ db2 backup db sample PARALLELISM 4
Backup successful. The timestamp for this backup image is : 20130715092132
$ ls
SAMPLE.0.db2test.NODE0000.CATN0000.20130715092132.001
db2 list history backup all for sample
List History File for sample
Number of matching file entries = 2
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715090440001 F N S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715090440
End Time: 20130715090443
Status: A
----------------------------------------------------------------------------
EID: 5 Location: /dev/null
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092132001 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092132
End Time: 20130715092135
Status: A
----------------------------------------------------------------------------
EID: 6 Location: /home/db2test/backup_data/offline_backup
并行备份，只生成一条备份记录；使用并行的方式，提升备份效率
$ mkdir 1 2 3 4
$ ls
1 4
2 SAMPLE.0.db2test.NODE0000.CATN0000.20130715092132.001
3
db2 "backup db sample to /home/db2test/backup_data/offline_backup/1, /home/db2test/backup_data/offline_backp/2, /home/db2test/backup_data/offline_backup/3, /home/db2test/backup_data/offline_backup/4"
Backup successful. The timestamp for this backup image is : 20130715092717
$ ls
1 4
2 SAMPLE.0.db2test.NODE0000.CATN0000.20130715092132.001
3
$ ls ./1
SAMPLE.0.db2test.NODE0000.CATN0000.20130715092717.001
$ db2 list history backup all for sample
List History File for sample
Number of matching file entries = 6
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715090440001 F N S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715090440
End Time: 20130715090443
Status: A
----------------------------------------------------------------------------
EID: 5 Location: /dev/null
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092132001 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092132
End Time: 20130715092135
Status: A
----------------------------------------------------------------------------
EID: 6 Location: /home/db2test/backup_data/offline_backup
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092717001 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092717
End Time: 20130715092721
Status: A
----------------------------------------------------------------------------
EID: 7 Location: /home/db2test/backup_data/offline_backup/1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092717002 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092717
End Time: 20130715092721
Status: A
----------------------------------------------------------------------------
EID: 8 Location: /home/db2test/backup_data/offline_backup/2
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092717003 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092717
End Time: 20130715092721
Status: A
----------------------------------------------------------------------------
EID: 9 Location: /home/db2test/backup_data/offline_backup/3
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130715092717004 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 5 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 IBMDB2SAMPLEREL
00004 IBMDB2SAMPLEXML
00005 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20130715092717
End Time: 20130715092721
Status: A
----------------------------------------------------------------------------
EID: 10 Location: /home/db2test/backup_data/offline_backup/4
可以看到，有四份备份文件分布在四个文件夹上。这个是与备份到nbu上是类似的，但是，区别在于，往NBU上进行备份，备份位置，都是nbu路径，且需要nbu进行配置（相当于使用了nbu的并行配置）
如下：
stdin Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
stdin -- --- ------------------ ---- --- ------------ ------------ --------------
stdin B D 20130705204603001 N O S1506374.LOG S1506396.LOG
stdin ----------------------------------------------------------------------------
stdin Contains 85 tablespace(s):
stdin
stdin 00001 SYSCATSPACE
stdin 00002 PSAPBTABD4
stdin 00003 PSAPBTABI4
stdin 00004 PSAPPOOLD2
stdin 00005 PSAPPOOLI2
stdin 00006 PSAPDDICD
stdin 00007 PSAPDDICI
stdin 00008 PSAPDOCUD
stdin 00009 PSAPDOCUI
stdin 00010 PSAPBTABD12
stdin 00011 PSAPBTABI12
stdin 00012 DBASTATS
stdin 00013 PSAPBTABD16
stdin 00014 PSAPLOADD
stdin 00015 PSAPLOADI
stdin 00016 PSAPPOOLD
stdin 00017 PSAPPOOLI
stdin 00018 PSAPPROTD
stdin 00019 PSAPPROTI
stdin 00020 PSAPSOURCED
stdin 00021 PSAPSOURCEI
stdin 00022 PSAPSTABD
stdin 00023 PSAPSTABI
stdin 00024 PSAPUSER1D
stdin 00025 PSAPUSER1I
stdin 00026 PSAPBTABD23
stdin 00027 PSAPBTABI23
stdin 00028 PSAPBTABD15
stdin 00029 PSAPBTABI15
stdin 00030 PSAPBTABI16
stdin 00031 PSAPBTABD17
stdin 00032 PSAPBTABD14
stdin 00033 PSAPBTABI14
stdin 00034 PSAPBTABI17
stdin 00035 PSAPBTABD18
stdin 00036 PSAPBTABI18
stdin 00037 PSAPBTABD21
stdin 00038 PSAPBTABI21
stdin 00039 PSAPBTABD22
stdin 00040 PSAPBTABI22
stdin 00041 PSAPEL702D
stdin 00042 PSAPES702D
stdin 00043 PSAPPOOLD_NEW
stdin 00044 PSAPPOOLI_NEW
stdin 00045 SYSTOOLSPACE
stdin 00046 PSAPBTABD3
stdin 00047 PSAPBTABI3
stdin 00048 PSAPBTABD5
stdin 00049 PSAPBTABI5
stdin 00050 PSAPEL702I
stdin 00051 PSAPES702I
stdin 00052 PSAPBTABD2
stdin 00053 PSAPBTABI2
stdin 00054 PSAPBTABD
stdin 00055 PSAPBTABD13
stdin 00056 PSAPBTABI
stdin 00057 PSAPCLUD2
stdin 00058 PSAPBTABI13
stdin 00059 PSAPBTABD11
stdin 00060 PSAPBTABI11
stdin 00061 PSAPBTABD19
stdin 00062 PSAPBTABI19
stdin 00063 PSAPDIMI
stdin 00064 PSAPODSI
stdin 00065 PSAPFACTI
stdin 00066 PSAPEL700I
stdin 00067 PSAPES700I
stdin 00068 PSAPDIMD
stdin 00069 PSAPODSD
stdin 00070 PSAPFACTD
stdin 00071 PSAPEL700D
stdin 00072 PSAPES700D
stdin 00073 PSAPCLUD
stdin 00074 PSAPCLUI
stdin 00075 PSAPBTABD8
stdin 00076 PSAPBTABI8
stdin 00077 PSAPCLUI2
stdin 00078 PSAPBTABD20
stdin 00079 PSAPBTABI20
stdin 00080 PSAPBTABD10
stdin 00081 PSAPBTABI10
stdin 00082 PSAPBTABD6
stdin 00083 PSAPBTABI6
stdin 00084 PSAPBTABD9
stdin 00085 PSAPBTABI9
stdin ----------------------------------------------------------------------------
stdinComment: DB2 BACKUP QSA ONLINE
stdin Start Time: 20130705204603
stdin End Time: 20130706123941
stdin Status: A
stdin ----------------------------------------------------------------------------
stdin EID: 1621683 Location: /usr/openv/netbackup/bin/nbdb2.sl64
stdin
stdin
stdin Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
stdin -- --- ------------------ ---- --- ------------ ------------ --------------
stdin B D 20130705204603002 N O S1506374.LOG S1506396.LOG
stdin ----------------------------------------------------------------------------
stdin Contains 85 tablespace(s):
stdin
stdin 00001 SYSCATSPACE
stdin 00002 PSAPBTABD4
stdin 00003 PSAPBTABI4
stdin 00004 PSAPPOOLD2
stdin 00005 PSAPPOOLI2
stdin 00006 PSAPDDICD
stdin 00007 PSAPDDICI
stdin 00008 PSAPDOCUD
stdin 00009 PSAPDOCUI
stdin 00010 PSAPBTABD12
stdin 00011 PSAPBTABI12
stdin 00012 DBASTATS
stdin 00013 PSAPBTABD16
stdin 00014 PSAPLOADD
stdin 00015 PSAPLOADI
stdin 00016 PSAPPOOLD
stdin 00017 PSAPPOOLI
stdin 00018 PSAPPROTD
stdin 00019 PSAPPROTI
stdin 00020 PSAPSOURCED
stdin 00021 PSAPSOURCEI
stdin 00022 PSAPSTABD
stdin 00023 PSAPSTABI
stdin 00024 PSAPUSER1D
stdin 00025 PSAPUSER1I
stdin 00026 PSAPBTABD23
stdin 00027 PSAPBTABI23
stdin 00028 PSAPBTABD15
stdin 00029 PSAPBTABI15
stdin 00030 PSAPBTABI16
stdin 00031 PSAPBTABD17
stdin 00032 PSAPBTABD14
stdin 00033 PSAPBTABI14
stdin 00034 PSAPBTABI17
stdin 00035 PSAPBTABD18
stdin 00036 PSAPBTABI18
stdin 00037 PSAPBTABD21
stdin 00038 PSAPBTABI21
stdin 00039 PSAPBTABD22
stdin 00040 PSAPBTABI22
stdin 00041 PSAPEL702D
stdin 00042 PSAPES702D
stdin 00043 PSAPPOOLD_NEW
stdin 00044 PSAPPOOLI_NEW
stdin 00045 SYSTOOLSPACE
stdin 00046 PSAPBTABD3
stdin 00047 PSAPBTABI3
stdin 00048 PSAPBTABD5
stdin 00049 PSAPBTABI5
stdin 00050 PSAPEL702I
stdin 00051 PSAPES702I
stdin 00052 PSAPBTABD2
stdin 00053 PSAPBTABI2
stdin 00054 PSAPBTABD
stdin 00055 PSAPBTABD13
stdin 00056 PSAPBTABI
stdin 00057 PSAPCLUD2
stdin 00058 PSAPBTABI13
stdin 00059 PSAPBTABD11
stdin 00060 PSAPBTABI11
stdin 00061 PSAPBTABD19
stdin 00062 PSAPBTABI19
stdin 00063 PSAPDIMI
stdin 00064 PSAPODSI
stdin 00065 PSAPFACTI
stdin 00066 PSAPEL700I
stdin 00067 PSAPES700I
stdin 00068 PSAPDIMD
stdin 00069 PSAPODSD
stdin 00070 PSAPFACTD
stdin 00071 PSAPEL700D
stdin 00072 PSAPES700D
stdin 00073 PSAPCLUD
stdin 00074 PSAPCLUI
stdin 00075 PSAPBTABD8
stdin 00076 PSAPBTABI8
stdin 00077 PSAPCLUI2
stdin 00078 PSAPBTABD20
stdin 00079 PSAPBTABI20
stdin 00080 PSAPBTABD10
stdin 00081 PSAPBTABI10
stdin 00082 PSAPBTABD6
stdin 00083 PSAPBTABI6
stdin 00084 PSAPBTABD9
stdin 00085 PSAPBTABI9
stdin ----------------------------------------------------------------------------
stdinComment: DB2 BACKUP QSA ONLINE
stdin Start Time: 20130705204603
stdin End Time: 20130706123941
stdin Status: A
stdin ----------------------------------------------------------------------------
stdin EID: 1621684 Location: /usr/openv/netbackup/bin/nbdb2.sl64
stdin
stdin
stdin Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
stdin -- --- ------------------ ---- --- ------------ ------------ --------------
stdin B D 20130705204603003 N O S1506374.LOG S1506396.LOG
stdin ----------------------------------------------------------------------------
stdin Contains 85 tablespace(s):
stdin
stdin 00001 SYSCATSPACE
stdin 00002 PSAPBTABD4
stdin 00003 PSAPBTABI4
stdin 00004 PSAPPOOLD2
stdin 00005 PSAPPOOLI2
stdin 00006 PSAPDDICD
stdin 00007 PSAPDDICI
stdin 00008 PSAPDOCUD
stdin 00009 PSAPDOCUI
stdin 00010 PSAPBTABD12
stdin 00011 PSAPBTABI12
stdin 00012 DBASTATS
stdin 00013 PSAPBTABD16
stdin 00014 PSAPLOADD
stdin 00015 PSAPLOADI
stdin 00016 PSAPPOOLD
stdin 00017 PSAPPOOLI
stdin 00018 PSAPPROTD
stdin 00019 PSAPPROTI
stdin 00020 PSAPSOURCED
stdin 00021 PSAPSOURCEI
stdin 00022 PSAPSTABD
stdin 00023 PSAPSTABI
stdin 00024 PSAPUSER1D
stdin 00025 PSAPUSER1I
stdin 00026 PSAPBTABD23
stdin 00027 PSAPBTABI23
stdin 00028 PSAPBTABD15
stdin 00029 PSAPBTABI15
stdin 00030 PSAPBTABI16
stdin 00031 PSAPBTABD17
stdin 00032 PSAPBTABD14
stdin 00033 PSAPBTABI14
stdin 00034 PSAPBTABI17
stdin 00035 PSAPBTABD18
stdin 00036 PSAPBTABI18
stdin 00037 PSAPBTABD21
stdin 00038 PSAPBTABI21
stdin 00039 PSAPBTABD22
stdin 00040 PSAPBTABI22
stdin 00041 PSAPEL702D
stdin 00042 PSAPES702D
stdin 00043 PSAPPOOLD_NEW
stdin 00044 PSAPPOOLI_NEW
stdin 00045 SYSTOOLSPACE
stdin 00046 PSAPBTABD3
stdin 00047 PSAPBTABI3
stdin 00048 PSAPBTABD5
stdin 00049 PSAPBTABI5
stdin 00050 PSAPEL702I
stdin 00051 PSAPES702I
stdin 00052 PSAPBTABD2
stdin 00053 PSAPBTABI2
stdin 00054 PSAPBTABD
stdin 00055 PSAPBTABD13
stdin 00056 PSAPBTABI
stdin 00057 PSAPCLUD2
stdin 00058 PSAPBTABI13
stdin 00059 PSAPBTABD11
stdin 00060 PSAPBTABI11
stdin 00061 PSAPBTABD19
stdin 00062 PSAPBTABI19
stdin 00063 PSAPDIMI
stdin 00064 PSAPODSI
stdin 00065 PSAPFACTI
stdin 00066 PSAPEL700I
stdin 00067 PSAPES700I
stdin 00068 PSAPDIMD
stdin 00069 PSAPODSD
stdin 00070 PSAPFACTD
stdin 00071 PSAPEL700D
stdin 00072 PSAPES700D
stdin 00073 PSAPCLUD
stdin 00074 PSAPCLUI
stdin 00075 PSAPBTABD8
stdin 00076 PSAPBTABI8
stdin 00077 PSAPCLUI2
stdin 00078 PSAPBTABD20
stdin 00079 PSAPBTABI20
stdin 00080 PSAPBTABD10
stdin 00081 PSAPBTABI10
stdin 00082 PSAPBTABD6
stdin 00083 PSAPBTABI6
stdin 00084 PSAPBTABD9
stdin 00085 PSAPBTABI9
stdin ----------------------------------------------------------------------------
stdinComment: DB2 BACKUP QSA ONLINE
stdin Start Time: 20130705204603
stdin End Time: 20130706123941
stdin Status: A
stdin ----------------------------------------------------------------------------
stdin EID: 1621685 Location: /usr/openv/netbackup/bin/nbdb2.sl64
stdin
stdin
stdin Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
stdin -- --- ------------------ ---- --- ------------ ------------ --------------
stdin B D 20130705204603004 N O S1506374.LOG S1506396.LOG
stdin ----------------------------------------------------------------------------
stdin Contains 85 tablespace(s):
stdin
stdin 00001 SYSCATSPACE
stdin 00002 PSAPBTABD4
stdin 00003 PSAPBTABI4
stdin 00004 PSAPPOOLD2
stdin 00005 PSAPPOOLI2
stdin 00006 PSAPDDICD
stdin 00007 PSAPDDICI
stdin 00008 PSAPDOCUD
stdin 00009 PSAPDOCUI
stdin 00010 PSAPBTABD12
stdin 00011 PSAPBTABI12
stdin 00012 DBASTATS
stdin 00013 PSAPBTABD16
stdin 00014 PSAPLOADD
stdin 00015 PSAPLOADI
stdin 00016 PSAPPOOLD
stdin 00017 PSAPPOOLI
stdin 00018 PSAPPROTD
stdin 00019 PSAPPROTI
stdin 00020 PSAPSOURCED
stdin 00021 PSAPSOURCEI
stdin 00022 PSAPSTABD
stdin 00023 PSAPSTABI
stdin 00024 PSAPUSER1D
stdin 00025 PSAPUSER1I
stdin 00026 PSAPBTABD23
stdin 00027 PSAPBTABI23
stdin 00028 PSAPBTABD15
stdin 00029 PSAPBTABI15
stdin 00030 PSAPBTABI16
stdin 00031 PSAPBTABD17
stdin 00032 PSAPBTABD14
stdin 00033 PSAPBTABI14
stdin 00034 PSAPBTABI17
stdin 00035 PSAPBTABD18
stdin 00036 PSAPBTABI18
stdin 00037 PSAPBTABD21
stdin 00038 PSAPBTABI21
stdin 00039 PSAPBTABD22
stdin 00040 PSAPBTABI22
stdin 00041 PSAPEL702D
stdin 00042 PSAPES702D
stdin 00043 PSAPPOOLD_NEW
stdin 00044 PSAPPOOLI_NEW
stdin 00045 SYSTOOLSPACE
stdin 00046 PSAPBTABD3
stdin 00047 PSAPBTABI3
stdin 00048 PSAPBTABD5
stdin 00049 PSAPBTABI5
stdin 00050 PSAPEL702I
stdin 00051 PSAPES702I
stdin 00052 PSAPBTABD2
stdin 00053 PSAPBTABI2
stdin 00054 PSAPBTABD
stdin 00055 PSAPBTABD13
stdin 00056 PSAPBTABI
stdin 00057 PSAPCLUD2
stdin 00058 PSAPBTABI13
stdin 00059 PSAPBTABD11
stdin 00060 PSAPBTABI11
stdin 00061 PSAPBTABD19
stdin 00062 PSAPBTABI19
stdin 00063 PSAPDIMI
stdin 00064 PSAPODSI
stdin 00065 PSAPFACTI
stdin 00066 PSAPEL700I
stdin 00067 PSAPES700I
stdin 00068 PSAPDIMD
stdin 00069 PSAPODSD
stdin 00070 PSAPFACTD
stdin 00071 PSAPEL700D
stdin 00072 PSAPES700D
stdin 00073 PSAPCLUD
stdin 00074 PSAPCLUI
stdin 00075 PSAPBTABD8
stdin 00076 PSAPBTABI8
stdin 00077 PSAPCLUI2
stdin 00078 PSAPBTABD20
stdin 00079 PSAPBTABI20
stdin 00080 PSAPBTABD10
stdin 00081 PSAPBTABI10
stdin 00082 PSAPBTABD6
stdin 00083 PSAPBTABI6
stdin 00084 PSAPBTABD9
stdin 00085 PSAPBTABI9
stdin ----------------------------------------------------------------------------
stdinComment: DB2 BACKUP QSA ONLINE
stdin Start Time: 20130705204603
stdin End Time: 20130706123941
stdin Status: A
stdin ----------------------------------------------------------------------------
stdin EID: 1621686 Location: /usr/openv/netbackup/bin/nbdb2.sl64
Stdin
这样，通过nbu的并行备份机制，将数据库的备份保存到了nbu上。命令如下：
db2 “backup db
这里的4表示由nbu启动4个会话进行并行备份，如果不加，查看备份历史，是这个样子的：
arlqsap01:db2qsa 7> db2 list history backup since 20130717 for qsa
List History File for qsa
Number of matching file entries = 1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20130717114542001 N O S1506887.LOG S1506917.LOG
----------------------------------------------------------------------------
Contains 85 tablespace(s):
00001 SYSCATSPACE
00002 PSAPBTABD4
00003 PSAPBTABI4
00004 PSAPPOOLD2
00005 PSAPPOOLI2
00006 PSAPDDICD
00007 PSAPDDICI
00008 PSAPDOCUD
00009 PSAPDOCUI
00010 PSAPBTABD12
00011 PSAPBTABI12
00012 DBASTATS
00013 PSAPBTABD16
00014 PSAPLOADD
00015 PSAPLOADI
00016 PSAPPOOLD
00017 PSAPPOOLI
00018 PSAPPROTD
00019 PSAPPROTI
00020 PSAPSOURCED
00021 PSAPSOURCEI
00022 PSAPSTABD
00023 PSAPSTABI
00024 PSAPUSER1D
00025 PSAPUSER1I
00026 PSAPBTABD23
00027 PSAPBTABI23
00028 PSAPBTABD15
00029 PSAPBTABI15
00030 PSAPBTABI16
00031 PSAPBTABD17
00032 PSAPBTABD14
00033 PSAPBTABI14
00034 PSAPBTABI17
00035 PSAPBTABD18
00036 PSAPBTABI18
00037 PSAPBTABD21
00038 PSAPBTABI21
00039 PSAPBTABD22
00040 PSAPBTABI22
00041 PSAPEL702D
00042 PSAPES702D
00043 PSAPPOOLD_NEW
00044 PSAPPOOLI_NEW
00045 SYSTOOLSPACE
00046 PSAPBTABD3
00047 PSAPBTABI3
00048 PSAPBTABD5
00049 PSAPBTABI5
00050 PSAPEL702I
00051 PSAPES702I
00052 PSAPBTABD2
00053 PSAPBTABI2
00054 PSAPBTABD
00055 PSAPBTABD13
00056 PSAPBTABI
00057 PSAPCLUD2
00058 PSAPBTABI13
00059 PSAPBTABD11
00060 PSAPBTABI11
00061 PSAPBTABD19
00062 PSAPBTABI19
00063 PSAPDIMI
00064 PSAPODSI
00065 PSAPFACTI
00066 PSAPEL700I
00067 PSAPES700I
00068 PSAPDIMD
00069 PSAPODSD
00070 PSAPFACTD
00071 PSAPEL700D
00072 PSAPES700D
00073 PSAPCLUD
00074 PSAPCLUI
00075 PSAPBTABD8
00076 PSAPBTABI8
00077 PSAPCLUI2
00078 PSAPBTABD20
00079 PSAPBTABI20
00080 PSAPBTABD10
00081 PSAPBTABI10
00082 PSAPBTABD6
00083 PSAPBTABI6
00084 PSAPBTABD9
00085 PSAPBTABI9
----------------------------------------------------------------------------
Comment: DB2 BACKUP QSA ONLINE
Start Time: 20130717114542
End Time: 20130718153355
Status: A
----------------------------------------------------------------------------
EID: 1622503 Location: /usr/openv/netbackup/bin/nbdb2.sl64
arlqsap01:db2qsa 8>
只有一条备份记录，即没有采用并发。
同样，恢复的时候
Db2 "restore db
Db2 "rollforward db
