我的DB2 数据库版本是9.5 的,当前有一个表空间USERSPACE1是DMS 自动扩展管理,但当前使用率已经95%了还没自动扩展,请大家帮给各建议。
收起$ 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;
$