Please advise how to create table.

[m***@hotmail.com]

Hi,

I have some question about creation table script.

I have free disk space 163 GB. RAM is 3.00GB.
I need to create one database.

My Script :

DB2 CREATE DATABASE TEST ON E:
DB2 CREATE BUFFERPOOL TESTBUFF IMMEDIATE SIZE 256 PAGESIZE 8 K EXTENDED STORAGE

DB2 CREATE REGULAR TABLESPACE TESTTBS PAGESIZE 8 K MANAGED BY SYSTEM USING ('E:\TESTDB\Container') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.33 BUFFERPOOL TESTBUFF DROPPED TABLE RECOVERY ON

DB2 CREATE BUFFERPOOL TESTBUFF_TMP IMMEDIATE SIZE 512 PAGESIZE 8 K

DB2 CREATE SYSTEM TEMPORARY TABLESPACE TESTTBS_TMP PAGESIZE 8 K MANAGED BY SYSTEM USING ('E:\TESTDB\Container_TMP') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.33 BUFFERPOOL TESTBUFF_TMP

DB2 update dbm cfg using drda_heap_sz 8096
DB2 update database configuration for TEST using stmtheap 8096
DB2 update database configuration for TEST using applheapsz 8096
DB2 update database configuration for TEST using app_ctl_heap_sz 8096

Please help to advise above script.
Thank you.
Apinya W.

[Knut Stolze]

Post by m***@hotmail.com
Hi,
I have some question about creation table script.
I have free disk space 163 GB. RAM is 3.00GB.
I need to create one database.
DB2 CREATE BUFFERPOOL TESTBUFF IMMEDIATE SIZE 256 PAGESIZE 8 K EXTENDED STORAGE
DB2 CREATE REGULAR TABLESPACE TESTTBS PAGESIZE 8 K MANAGED BY SYSTEM USING
('E:\TESTDB\Container') EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.33 BUFFERPOOL TESTBUFF DROPPED TABLE RECOVERY ON
DB2 CREATE BUFFERPOOL TESTBUFF_TMP IMMEDIATE SIZE 512 PAGESIZE 8 K
DB2 CREATE SYSTEM TEMPORARY TABLESPACE TESTTBS_TMP PAGESIZE 8 K MANAGED BY
SYSTEM USING ('E:\TESTDB\Container_TMP') EXTENTSIZE 16 OVERHEAD 10.5
PREFETCHSIZE 16 TRANSFERRATE 0.33 BUFFERPOOL TESTBUFF_TMP
DB2 update dbm cfg using drda_heap_sz 8096
DB2 update database configuration for TEST using stmtheap 8096
DB2 update database configuration for TEST using applheapsz 8096
DB2 update database configuration for TEST using app_ctl_heap_sz 8096
Please help to advise above script.

What's the problem?

[m***@hotmail.com]

Hi,

No. I don't have any problem. I just need to share and get a comment about my script. I mean, how about the performance when I create table with this script ?

Thank you.
Apinya W.