DBA 管理技巧

新增多個 auto resized Tablespace

CREATE REGULAR TABLESPACE RPTTBS9 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE
         USING (FILE '/home/STORAGE/devrpt/DEVRPTDB/rpttbs9-c1' 1024 M,
                FILE '/home/STORAGE/devrpt/DEVRPTDB/rpttbs9-c2' 1024 M)
         AUTORESIZE YES MAXSIZE 51200 M
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL RPT8KBP1
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         FILE SYSTEM CACHING
         DROPPED TABLE RECOVERY ON;

TIP:

AUTORESIZE YES MAXSIZE 51200 M ，每個 data file 可以自動擴充至 50GB