db2 storage group的用法举例

---------------------------------------
-- DDL Statements for STORAGE GROUPS --
---------------------------------------
 
CREATE STOGROUP "IBMSTOGROUP" ON '/db2/db8sr003/db/CTMPREFS/AUTO'
         OVERHEAD 6.725000
         DEVICE READ RATE 100.000000
         DATA TAG NONE
         SET AS DEFAULT;

CREATE REGULAR TABLESPACE "CDTS" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
         PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE
         USING STOGROUP "IBMSTOGROUP"
         AUTORESIZE YES
         INITIALSIZE 768 K
         MAXSIZE NONE
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL "IBMDEFAULTBP"
         DATA TAG NONE
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         FILE SYSTEM CACHING  
         DROPPED TABLE RECOVERY ON;        
请使用浏览器的分享功能分享到微信等