互联网服务文件系统数据库

容器占用空间持续增加

各位大大,    小弟有一个数据库, userspace1 建在文件系统上,之前增长趋势正常,最近这个 userspace1的容器狂涨,给多少空间不到半天就撑满了,求问如何定位容器需求量大增的原因?(数据量不大)MESSAGE : ADM6101W  While attempting to extend table space "USERSPA...显示全部
各位大大,

    小弟有一个数据库, userspace1 建在文件系统上,之前增长趋势正常,最近这个 userspace1的容器狂涨,给多少空间不到半天就撑满了,求问如何定位容器需求量大增的原因?(数据量不大)


MESSAGE : ADM6101W  While attempting to extend table space "USERSPACE1" (ID
          "2"), there were less than "67108864" bytes free on
          "/db2space/db2inst1/db2inst1/NODE0000/SQL00001/".  This space is
          reserved for use by DB2 and/or the operating system.

MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
          DIA8312C Disk was full.
DATA #1 : String, 108 bytes
An error caused the allocation of a new stripe set of containers to an automatic storage tablespace to fail.
MESSAGE : ADM6044E  The DMS table space "USERSPACE1" (ID "2") is full.  If this
          is an autoresize or automatic storage DMS tablespace, the maximum
          table space size may have been reached or the existing containers or
          storage paths cannot grow any more. Additional space can be added to
          the table space by either adding new containers or extending existing
          ones using the ALTER TABLESPACE SQL statement. If this is an
          autoresize or automatic storage DMS table space, additional space can
          be added by adding containers to an autoresize table space or by
          adding new storage paths to an automatic storage database.收起
参与6

查看其它 4 个回答charles_boc的回答

charles_boccharles_boc数据库管理员BOCOM
db2pd -d dbname -tcbstats
政府机关 · 2012-04-20
浏览725

回答者

charles_boc
数据库管理员BOCOM
擅长领域: 数据库

charles_boc 最近回答过的问题

回答状态

  • 发布时间:2012-04-20
  • 关注会员:1 人
  • 回答浏览:725
  • X社区推广