日期:2014-05-16  浏览次数:20617 次

DB2表空间管理详解(原创)

create tablespace语法树

>>-CREATE
--+-----------------------+---------------------------->
?????????? +-LARGE-----------------+??
?????????? +-REGULAR---------------+??
?????????? | .-SYSTEM-.??????????? |??
?????????? '-+--------+--TEMPORARY-'??
???????????? '-USER---'???????????????


>--TABLESPACE--tablespace-name---------------------------------->

>--+-----------------------+-->
?? |???? .-DATABASE PARTITION GROUP-.????????????????????????? |??
?? '-IN--+--------------------------+--db-partition-group-name-'??

>--+--------------------------+--------------------------------->
?? '-PAGESIZE--integer--+---+-'??
?????????????????????? '-K-'????
?? .-MANAGED BY--AUTOMATIC STORAGE--| size-attributes |---------------------.??

>--+------------------------------------+-->
?? '-MANAGED BY--+-SYSTEM--| system-containers |--------------------------+-'??
???????????????? '-DATABASE--| database-containers |--| size-attributes |-'????

>--+---------------------------------+-------------------------->
?? '-EXTENTSIZE--+-number-of-pages-+-'??
???????????????? '-integer--+-K-+--'????
??????????????????????????? '-M-'???????

>--+-----------------------------------+------------------------>
?? '-PREFETCHSIZE--+-AUTOMATIC-------+-'??
?????????????????? +-number-of-pages-+????
?????????????????? '-integer--+-K-+--'????
????????????????????????????? +-M-+???????
????????????????????????????? '-G-'???????
>--+-----------------------------+------------------------------>
?? '-BUFFERPOOL--bufferpool-name-'??

>--+----------------------------------+------------------------->
?? '-OVERHEAD--number-of-milliseconds-'??

>--+------------------------+----------------------------------->
?? +-NO FILE SYSTEM CACHING-+??
?? '-FILE SYSTEM CACHING----'??

>--+--------------------------------------+--------------------->
?? '-TRANSFERRATE--number-of-milliseconds-'??

>--+---------------------------------+-------------------------><
?? '-DROPPED TABLE RECOVERY--+-ON--+-'??
???????????????????????????? '-OFF-'????
size-attributes

|--+---------------------+--+-----------------------------+----->
?? '-AUTORESIZE--+-NO--+-'? '-INITIALSIZE--integer--+-K-+-'??
???????????????? '-YES-'??????????????????????????? +-M-+????
??????????????????????????????????????????????????? '-G-'????

>--+------------------------------------+----------------------->
?? '-INCREASESIZE--integer--+-PERCENT-+-'??
??????????????????????????? '-+-K-+---'????
????????????????????????????? +-M-+????????
????????????????????????????? '-G-'????????

>--+-----------------------------+------------------------------|
?? '-MAXSIZE--+-integer--+-K-+-+-'??
????????????? |????????? +-M-+ |????
????????????? |????????? '-G-' |????
????????????? '-NONE-----------'????

system-containers
?? .----------------------------------.??
?? |?????????? .-,------------------.???????????????????????????????????? |??
?? V?????????? V??????????????????? |???????????????????????????????????? |??
|----USING--(----'container-string'-+--)--+-----------------------------+-+--|
????????????????????????????????????????? '-| on-db-partitions-clause |-'????

database-containers
?? .--------------------------.??
?? V????????????????????????????????????????????????????????????? |??
|----US