jsapp建表语句和重要表数据（备20160825）.rar

---------创建数据库和缓冲池--------- 1. db2 -tvf jsapp_1.sql ------------------------------------ --创建数据库开始-- ------------------------------------ --创建表空间开始-- --数据表表空间-- CREATE LARGE TABLESPACE "TSTABLE" IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP" PAGESIZE 8K MANAGED BY DATABASE USING (File '/home/db2iszyc/db2iszyc/NODE0000/SQL00001/TSTABLE/C0000000.LRG' 500000 ) EXTENTSIZE 64 PREFETCHSIZE 32 BUFFERPOOL "BPTABLE" OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY ON; --临时表空间-- CREATE REGULAR TABLESPACE "TSUSERTEMP" IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP" PAGESIZE 8K MANAGED BY SYSTEM USING ('/home/db2iszyc/db2iszyc/NODE0000/SQL00001/TSUSERTEMP' ) EXTENTSIZE 64 PREFETCHSIZE 32 BUFFERPOOL "BPUSERTEMP" OVERHEAD 6.72 TRANSFERRATE 0.08 DROPPED TABLE RECOVERY ON; --大数据表空间-- CREATE LARGE TABLESPACE "TSBIGTABLE" IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP" PAGESIZE 32K MANAGED BY DATABASE USING (File '/home/db2iszyc/db2iszyc/NODE0000/SQL00001/TSBIGTABLE/C0000000.LRG' 500000 ) EXTENTSIZE 64 PREFETCHSIZE 32 BUFFERPOOL "BPBIGTABLE" OVERHEAD 24.10 TRANSFERRATE 0.90 DROPPED TABLE RECOVERY ON; --大数据系统临时表空间-- CREATE USER TEMPORARY TABLESPACE "TSBIGSYSTEMP" IN DATABASE PARTITION GROUP "IBMDEFAULTGROUP" PAGESIZE 32K MANAGED BY SYSTEM USING ('/home/db2iszyc/db2iszyc/NODE0000/SQL00001/TSBIGSYSTEMP' ) EXTENTSIZE 64 PREFETCHSIZE AUTOMATIC BUFFERPOOL "BPBIGTABLE" OVERHEAD 6.72 TRANSFERRATE 0.08 DROPPED TABLE RECOVERY OFF; --创建表空间结束-- ------------------------------------ ---------创建表和给重表插入数据--------- 6. db2 -tvf jsapp_2.sql