DB2 数据库表空间USERSPACE1 自动扩展问题

我的DB2 数据库版本是9.5 的,当前有一个表空间USERSPACE1是DMS 自动扩展管理,但当前使用率已经95%了还没自动扩展,请大家帮给各建议。

参与23

7同行回答

db2look -d dbname -l把结果贴出来显示全部

db2look -d dbname -l

把结果贴出来

收起
证券 · 2015-10-21
浏览2542
  • [此评论已删除]
    2015-10-21
  • [此评论已删除]
    2015-10-21
  • 评论里面信息台乱,我发布到下面了,您帮看看
    2015-10-21
  • 在吗,您帮看看下面的信息,谢谢!
    2015-10-22
  • 表空间使用情况 1 TBSP_TYPE TBSP_FREE_SIZE_KB TBSP_UTILIZATION_PERCENT ------------------ ---------- -------------------- ------------------------ SYSCATSPACE SMS 0 -1.00 TEMPSPACE1 SMS 0 -1.00 USERSPACE1 DMS 13568 95.39 LDAPSPACE DMS 356352 31.89 SYSTOOLSPACE DMS 32032 2.19 SYSTOOLSTMPSPACE SMS 0 -1.00
    2015-10-22
  • $ db2 connect to DB2DB Database Connection Information Database server = DB2/AIX64 9.1.6 SQL authorization ID = IDSLDAP Local database alias = DB2DB $ db2look -d DB2DB -l -- No userid was specified, db2look tries to use Environment variable USER -- USER is: IDSLDAP -- This CLP file was created using DB2LOOK Version 9.1 -- Timestamp: 公元2015年10月21日 星期三 17时04分31秒 -- Database Name: DB2DB -- Database Manager Version: DB2/AIX64 Version 9.1.6 -- Database Codepage: 1208 -- Database Collating Sequence is: IDENTITY -- Binding package automatically ... -- Bind is successful -- Binding package automatically ... -- Bind is successful CONNECT TO DB2DB; ------------------------------------ -- DDL Statements for BUFFERPOOLS -- ------------------------------------ CREATE BUFFERPOOL "LDAPBP" SIZE AUTOMATIC PAGESIZE 32768 NOT EXTENDED STORAGE; CONNECT RESET; CONNECT TO DB2DB; ------------------------------------ -- DDL Statements for TABLESPACES -- ------------------------------------ CREATE LARGE TABLESPACE "LDAPSPACE" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE USING (FILE '/webseal01/user/idsldap/ldap32kcont_DB2DB/ldapspace'16384) EXTENTSIZE 32 PREFETCHSIZE AUTOMATIC BUFFERPOOL LDAPBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 AUTORESIZE YES INCREASESIZE 256 M MAXSIZE NONE NO FILE SYSTEM CACHING DROPPED TABLE RECOVERY ON; CREATE LARGE TABLESPACE "SYSTOOLSPACE" IN DATABASE PARTITION GROUP IBMCATGROUP PAGESIZE 4096 MANAGED BY DATABASE USING (FILE '/webseal01/user/idsldap/idsldap/NODE0000/SQL00001/SYSTOOLSPACE'8192) EXTENTSIZE 4 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 AUTORESIZE YES MAXSIZE NONE FILE SYSTEM CACHING DROPPED TABLE RECOVERY ON; CREATE USER TEMPORARY TABLESPACE "SYSTOOLSTMPSPACE" IN DATABASE PARTITION GROUP IBMCATGROUP PAGESIZE 4096 MANAGED BY SYSTEM USING ('/webseal01/user/idsldap/idsldap/NODE0000/SQL00001/SYSTOOLSTMPSPACE') EXTENTSIZE 4 PREFETCHSIZE AUTOMATIC BUFFERPOOL IBMDEFAULTBP OVERHEAD 7.500000 TRANSFERRATE 0.060000 FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF; -- Mimic tablespace ALTER TABLESPACE SYSCATSPACE PREFETCHSIZE AUTOMATIC OVERHEAD 7.500000 FILE SYSTEM CACHING TRANSFERRATE 0.060000; ALTER TABLESPACE TEMPSPACE1 PREFETCHSIZE AUTOMATIC OVERHEAD 7.500000 FILE SYSTEM CACHING TRANSFERRATE 0.060000; ALTER TABLESPACE USERSPACE1 PREFETCHSIZE AUTOMATIC OVERHEAD 7.500000 NO FILE SYSTEM CACHING TRANSFERRATE 0.060000; COMMIT WORK; CONNECT RESET; TERMINATE;
    2015-10-22
  • 太乱了看不清
    2015-10-23

提问者

Haoword_wang
数据库运维工程师东方龙马

相关问题

问题状态

  • 发布时间:2015-10-20
  • 关注会员:5 人
  • 问题浏览:10304
  • 最近回答:2015-10-23
  • X社区推广