DB2 offline备份后，DB2会宕掉，有人知道原因吗？

penny61

我的ＳＡＰ系统使用的是ＤＢ２数据库，我在做online备份后，一切正常，但每当我做offline备份后，数据库就会宕掉，日志里记录的信息如下：
MESSAGE : ADM6017E  The table space "KTX#BTABD" (ID "9") is full. Detected on
          container "/db2/KTX/sapdata2/NODE0000/KTX#BTABD.container001" (ID
          "1").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

MESSAGE : ADM6017E  The table space "KTX#STABD" (ID "14") is full. Detected on
          container "/db2/KTX/sapdata4/NODE0000/KTX#STABD.container001" (ID
          "1").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

MESSAGE : ADM6017E  The table space "KTX#STABD" (ID "14") is full. Detected on
          container "/db2/KTX/sapdata3/NODE0000/KTX#STABD.container000" (ID
          "0").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

MESSAGE : ADM6017E  The table space "KTX#BTABD" (ID "9") is full. Detected on
          container "/db2/KTX/sapdata1/NODE0000/KTX#BTABD.container000" (ID
          "0").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

MESSAGE : ADM6017E  The table space "KTX#BTABI" (ID "10") is full. Detected on
          container "/db2/KTX/sapdata2/NODE0000/KTX#BTABI.container000" (ID
          "0").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

MESSAGE : ADM6017E  The table space "KTX#STABI" (ID "15") is full. Detected on
          container "/db2/KTX/sapdata3/NODE0000/KTX#STABI.container001" (ID
          "1").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.


MESSAGE : ADM6017E  The table space "KTX#BTABI" (ID "10") is full. Detected on
          container "/db2/KTX/sapdata1/NODE0000/KTX#BTABI.container001" (ID
          "1").  The underlying file system is full or the maximum allowed
          space usage for the file system has been reached. It is also possible
          that there are user limits in place with respect to maximum file size
          and these limits have been reached.

我在重新启数据库后，一切正常，我再查看table spaces空间时，记录如下
KTX#BTABD　　大小：142,626,816　　使用百分比：80.87％　空闲空间：27,288,064
KTX#BTABI　　大小：52,146,176　　　使用百分比：60.66　　空闲空间：20,511,744
KTX#STABD　　大小：44,169,216　　　使用百分比：55.18　　空闲空间：19,795,712
KTX#STABI　　大小：16,144,384　　　使用百分比：73.84　　空闲空间：4,222,976
所有的page size都是16K

AIX里的文件系统也有大量的空间，命令 df -m
/dev/datalv4   51200.00  18669.83   64%        8     1% /db2/KTX/sapdata4
/dev/datalv3   51200.00  19693.83   62%        8     1% /db2/KTX/sapdata3
/dev/datalv2  102400.00   7280.01   93%        7     1% /db2/KTX/sapdata2
/dev/datalv1  102400.00   6380.01   94%        8     1% /db2/KTX/sapdata1

请问哪位大侠知道原因吗？

iamtubie

lv1,and lv2 is near full
so container is on which lv ？
offline backup cmd is what , i must know detailed
and what is your offline backup steps?

lizhuo

某个表空间容器已满

大梦

有点奇怪！
看来真正原因不是因为表空间满，重启就一切正常！

db2level看看你的版本信息！

psc2001

都是file or path类型的TBS么
备份的FS是哪个
df出来的好像都是DBfs

tony_hjy211

出现这个问题,并不一定说空间已经满了,可能是表空间的High water mark (pages) 已经接近表空间
的大小.也会出现上述的情况.建议减低High water mark (pages) .

tony_hjy211

出现这个问题,并不一定说空间已经满了,可能是表空间的High water mark (pages) 已经接近表空间
的大小.也会出现上述的情况.建议减低High water mark (pages) .

psc2001

原帖由 tony_hjy211 于 2007-1-31 13:48 发表
出现这个问题,并不一定说空间已经满了,可能是表空间的High water mark (pages) 已经接近表空间
的大小.也会出现上述的情况.建议减低High water mark (pages) .

有这个说法么
上次TBS　HWM到95％也没有这个问题么

tony_hjy211

我也许对high water 概念有些误解,但是有种情况不是很理解
我在生产环境中,导入一些数据到数据库,日志提示空间已经满了(可是我的表空间是足够大的)
我查看表空间状态,没有可用page,high water也接近space size 的大小,
我增加表空间的大小,大概10G,在查看表空间状态,free page is 0 ,high water 接近space size
数据也不能导入(导入数据5000条).我觉得high  water对表空间使用大小有影响

psc2001

原帖由 tony_hjy211 于 2007-2-1 12:12 发表
我也许对high water 概念有些误解,但是有种情况不是很理解
我在生产环境中,导入一些数据到数据库,日志提示空间已经满了(可是我的表空间是足够大的)
我查看表空间状态,没有可用page,high water也接近space size  ...

增加TBS容量 要过一点时间才会加上去
DB2会自动平衡各个表空间的数据量

你增加了空间后还是0 free好像不太可能吧