LoveUnix » DB2 & Informix » 不解，db2备份历史信息的删除问题
2006-8-9 08:29
aixstudy
不解，db2备份历史信息的删除问题
前几天为了测试，用TSM备份了db2 ese v8，备份工作很正常，同时也可以用db2adutl query查看到所备份的信息，后来采用了db2adutl delete删除了备份信息，但log没有删除掉，我用db2 prune history XXXXXX就是删除不掉，删除提示成功，但回头查一下，还是一样，如下：
$ db2 prune history 20060807
DB20000I The PRUNE command completed successfully.
$
$ db2adutl query
Warning: There are no file spaces created by DB2 on the ADSM server
Warning: No DB2 backup images found in ADSM for any alias.
$ db2 list history backup all for sample
List History File for sample
Number of matching file entries = 18
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807091410000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807091410
End Time: 20060807091411
Status: A
----------------------------------------------------------------------------
EID: 30 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2071 sqlerrml: 37
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�1
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807093628001 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807093628
End Time: 20060807093701
Status: A
----------------------------------------------------------------------------
EID: 31 Location: /home/db2inst1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807100122000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807100122
End Time: 20060807100123
Status: A
----------------------------------------------------------------------------
EID: 32 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807101309000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807101309
End Time: 20060807101310
Status: A
----------------------------------------------------------------------------
EID: 33 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807101957000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807101957
End Time: 20060807101958
Status: A
----------------------------------------------------------------------------
EID: 34 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807102413000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807102413
End Time: 20060807102414
Status: A
----------------------------------------------------------------------------
EID: 35 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105533000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105533
End Time: 20060807105534
Status: A
----------------------------------------------------------------------------
EID: 36 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2032
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105714000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105714
End Time: 20060807105715
Status: A
----------------------------------------------------------------------------
EID: 37 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2033
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105802000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105802
End Time: 20060807105803
Status: A
----------------------------------------------------------------------------
EID: 38 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2033
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105906000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105906
End Time: 20060807105907
Status: A
----------------------------------------------------------------------------
EID: 39 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807111648000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807111648
End Time: 20060807111649
Status: A
----------------------------------------------------------------------------
EID: 40 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807114332000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807114332
End Time: 20060807114333
Status: A
----------------------------------------------------------------------------
EID: 41 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807123915001 F A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807123915
End Time: 20060807123947
Status: A
----------------------------------------------------------------------------
EID: 42 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807131045001 N A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807131045
End Time: 20060807131123
Status: A
----------------------------------------------------------------------------
EID: 44 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807131045002 N A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807131045
End Time: 20060807131123
Status: A
----------------------------------------------------------------------------
EID: 45 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B P 20060807133718000 N S0000001.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 SYSTOOLSPACE
00003 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807133718
End Time: 20060807133719
Status: A
----------------------------------------------------------------------------
EID: 48 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2009 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubcka
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B P 20060807133809001 N A S0000001.LOG S0000001.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 SYSTOOLSPACE
00003 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807133809
End Time: 20060807133839
Status: A
----------------------------------------------------------------------------
EID: 49 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807145014001 N A S0000003.LOG S0000003.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807145014
End Time: 20060807145048
Status: A
----------------------------------------------------------------------------
EID: 52 Location: adsm/libtsm.a
$
前几天为了测试，用TSM备份了db2 ese v8，备份工作很正常，同时也可以用db2adutl query查看到所备份的信息，后来采用了db2adutl delete删除了备份信息，但log没有删除掉，我用db2 prune history XXXXXX就是删除不掉，删除提示成功，但回头查一下，还是一样，如下：
$ db2 prune history 20060807
DB20000I The PRUNE command completed successfully.
$
$ db2adutl query
Warning: There are no file spaces created by DB2 on the ADSM server
Warning: No DB2 backup images found in ADSM for any alias.
$ db2 list history backup all for sample
List History File for sample
Number of matching file entries = 18
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807091410000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807091410
End Time: 20060807091411
Status: A
----------------------------------------------------------------------------
EID: 30 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2071 sqlerrml: 37
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�1
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807093628001 F D S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807093628
End Time: 20060807093701
Status: A
----------------------------------------------------------------------------
EID: 31 Location: /home/db2inst1
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807100122000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807100122
End Time: 20060807100123
Status: A
----------------------------------------------------------------------------
EID: 32 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807101309000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807101309
End Time: 20060807101310
Status: A
----------------------------------------------------------------------------
EID: 33 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807101957000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807101957
End Time: 20060807101958
Status: A
----------------------------------------------------------------------------
EID: 34 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807102413000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807102413
End Time: 20060807102414
Status: A
----------------------------------------------------------------------------
EID: 35 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�137
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105533000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105533
End Time: 20060807105534
Status: A
----------------------------------------------------------------------------
EID: 36 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2032
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105714000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105714
End Time: 20060807105715
Status: A
----------------------------------------------------------------------------
EID: 37 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2033
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105802000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105802
End Time: 20060807105803
Status: A
----------------------------------------------------------------------------
EID: 38 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 40
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�2033
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807105906000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807105906
End Time: 20060807105907
Status: A
----------------------------------------------------------------------------
EID: 39 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807111648000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807111648
End Time: 20060807111649
Status: A
----------------------------------------------------------------------------
EID: 40 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807114332000 F S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807114332
End Time: 20060807114333
Status: A
----------------------------------------------------------------------------
EID: 41 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2062 sqlerrml: 39
sqlerrmc: /home/db2inst1/sqllib/adsm/libtsm.a�138
sqlerrp : sqlubMWR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807123915001 F A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE OFFLINE
Start Time: 20060807123915
End Time: 20060807123947
Status: A
----------------------------------------------------------------------------
EID: 42 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807131045001 N A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807131045
End Time: 20060807131123
Status: A
----------------------------------------------------------------------------
EID: 44 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807131045002 N A S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
Contains 2 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807131045
End Time: 20060807131123
Status: A
----------------------------------------------------------------------------
EID: 45 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B P 20060807133718000 N S0000001.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 SYSTOOLSPACE
00003 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807133718
End Time: 20060807133719
Status: A
----------------------------------------------------------------------------
EID: 48 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2009 sqlerrml: 0
sqlerrmc:
sqlerrp : sqlubcka
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B P 20060807133809001 N A S0000001.LOG S0000001.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 SYSTOOLSPACE
00003 USERSPACE1
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807133809
End Time: 20060807133839
Status: A
----------------------------------------------------------------------------
EID: 49 Location: adsm/libtsm.a
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20060807145014001 N A S0000003.LOG S0000003.LOG
----------------------------------------------------------------------------
Contains 3 tablespace(s):
00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE
----------------------------------------------------------------------------
Comment: DB2 BACKUP SAMPLE ONLINE
Start Time: 20060807145014
End Time: 20060807145048
Status: A
----------------------------------------------------------------------------
EID: 52 Location: adsm/libtsm.a
$
2006-11-22 16:03
漂浮的沙尘
我有些不明白，db2adutl query db 和 db2 list history backup all for db 命令的查询结果有什么区别吗？
我在运行 db2adutl时，系统提示如下
WARNING！Current buffer size exceeded. only 1023 backup/sequence images will be displayed。
只能看到很久以前的备份信息，最近的都看不到，应该怎么处理呢？
我在运行 db2adutl时，系统提示如下
WARNING！Current buffer size exceeded. only 1023 backup/sequence images will be displayed。
只能看到很久以前的备份信息，最近的都看不到，应该怎么处理呢？
2006-11-23 09:40
beginner-bj
[quote]原帖由 [i]aixstudy[/i] 于 2006-8-9 08:29 发表
前几天为了测试，用TSM备份了db2 ese v8，备份工作很正常，同时也可以用db2adutl query查看到所备份的信息，后来采用了db2adutl delete删除了备份信息，但log没有删除掉，我用db2 prune history XXXXXX就是删除 ... [/quote]
db2 prune history XXXXXX不是删log的。
PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]
PRUNE LOGFILE PRIOR TO log-file-name
前几天为了测试，用TSM备份了db2 ese v8，备份工作很正常，同时也可以用db2adutl query查看到所备份的信息，后来采用了db2adutl delete删除了备份信息，但log没有删除掉，我用db2 prune history XXXXXX就是删除 ... [/quote]
db2 prune history XXXXXX不是删log的。
PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]
PRUNE LOGFILE PRIOR TO log-file-name
页: [1]
查看完整版本: 不解，db2备份历史信息的删除问题
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.