DB2表空间相信大家都有一定的了解，下面就为您介绍在aix下面创建DB2表空间的方法步骤，如果您对DB2表空间方面感兴趣的话，不妨一看。
db2setdb2codepage=819db2createdatabaseeasyteston/home/db2inst1 db2connecttotest04userdb2inst1usingdb2 db2CREATEBufferpoolUSER8SIZE100000PAGESIZE8K db2CREATEBufferpoolUSER16SIZE1000PAGESIZE16K db2CREATEBufferpoolUSER32SIZE1000PAGESIZE32K db2stopforce db2start db2connecttotest04userdb2inst1usingdb2 db2"CREATEREGULARTABLESPACETS_USER8PAGESIZE8KMANAGEDBYSYSTEMUSING('FSMS_8K_1')BUFFERPOOLUSER8" db2"CREATEREGULARTABLESPACETS_USER16PAGESIZE16KMANAGEDBYSYSTEMUSING('FSMS_16K_1')BUFFERPOOLUSER16" db2"CREATEREGULARTABLESPACETS_USER32PAGESIZE32KMANAGEDBYSYSTEMUSING('FSMS_32K_1')BUFFERPOOLUSER32" db2CREATEBufferpoolTMPBUF8SIZE10000PAGESIZE8K db2"CREATETEMPORARYTABLESPACETempTS_USER8PAGESIZE8KMANAGEDBYSYSTEMUSING('/home/db2inst1/db2inst1/TEMPNODE0004')EXTENTSIZE16OVERHEAD10.5PREFETCHSIZE16TRANSFERRATE0.14BUFFERPOOL"TMPBUF8"DROPPEDTABLERECOVERYOFF" db2GRANTDBADM,CREATETAB,BINDADD,CONNECT,LOADONDATABASETOUSEREASYMIS db2GRANTUSEOFTABLESPACETS_USER8TOeasymis db2GRANTUSEOFTABLESPACETS_USER16TOeasymis db2GRANTUSEOFTABLESPACETS_USER32TOeasymis db2connecttotest04usereasymisusingeasymis db2-fdbstruct.sql>kk.log
【编辑推荐】
带您学习DB2字符集和MySql字符集
同表内记录间的DB2更新语句
db2扩充表空间和字段长度的方法
带您了解DB2数据库中DB2字符串
六类常见的DB2命令行