不解，db2备份历史信息的删除问题 - DB2 & Informix - LoveUnix -- 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理 -- 蓝色的IBM技术天堂 --bbs.LoveUnix.net

aixstudy

LU幼天使

UID 36727
精华 3
积分 176
帖子 268
活跃指数 123
LU金币 2779 个
LU金条 0 个
阅读权限 20
注册 2005-11-19

#1

大中小

使用道具

发表于 2006-8-9 08:29 资料个人空间短消息加为好友

不解，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

$

漂浮的沙尘

LU新生

UID 58933
精华 0
积分 4
帖子 8
活跃指数 1
LU金币 9 个
LU金条 0 个
阅读权限 10
注册 2006-11-17

#2

大中小

使用道具

发表于 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。

只能看到很久以前的备份信息，最近的都看不到，应该怎么处理呢？

beginner-bj

版主

UID 9471
精华 15
积分 1400
帖子 2409
活跃指数 186
LU金币 4404 个
LU金条 0 个
阅读权限 210
注册 2004-1-16

#3

大中小

使用道具

发表于 2006-11-23 09:40 资料个人空间短消息加为好友

QUOTE:

原帖由 aixstudy 于 2006-8-9 08:29 发表
前几天为了测试，用TSM备份了db2 ese v8，备份工作很正常，同时也可以用db2adutl query查看到所备份的信息，后来采用了db2adutl delete删除了备份信息，但log没有删除掉，我用db2 prune history XXXXXX就是删除 ...

db2 prune history XXXXXX不是删log的。

PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]
PRUNE LOGFILE PRIOR TO log-file-name

我的博客：http://blog.chinaunix.net/index.php?blogId=739欢迎访问，并请多多批评指正。