PowerCenter
- PowerCenter 10.5.1
- All Products
SQL 1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048
CREATE Bufferpool RBF IMMEDIATE SIZE 1000 PAGESIZE 32 K EXTENDED STORAGE ; CREATE Bufferpool STBF IMMEDIATE SIZE 2000 PAGESIZE 32 K EXTENDED STORAGE ; CREATE REGULAR TABLESPACE REGTS32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('C:\DB2\NODE0000\reg32' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.33 BUFFERPOOL RBF; CREATE SYSTEM TEMPORARY TABLESPACE TEMP32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('C:\DB2\NODE0000\temp32' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16 TRANSFERRATE 0.33 BUFFERPOOL STBF; GRANT USE OF TABLESPACE REGTS32 TO USER <USERNAME>; UPDATE DB CFG FOR <DB NAME> USING APP_CTL_HEAP_SZ 16384 UPDATE DB CFG FOR <DB NAME> USING APPLHEAPSZ 16384 UPDATE DBM CFG USING QUERY_HEAP_SZ 8000 UPDATE DB CFG FOR <DB NAME> USING LOGPRIMARY 100 UPDATE DB CFG FOR <DB NAME> USING LOGFILSIZ 2000 UPDATE DB CFG FOR <DB NAME> USING LOCKLIST 1000 UPDATE DB CFG FOR <DB NAME> USING DBHEAP 2400 "FORCE APPLICATIONS ALL" DB2STOP DB2START
Parameter Name
| Value
| IBM DB2 Description
|
---|---|---|
LOCKLIST
| 8192
| Max storage for lock list (4KB)
|
MAXLOCKS
| 10
| Percent of lock lists per application
|
LOCKTIMEOUT
| 300
| Lock timeout (sec)
|
DLCHKTIME
| 10000
| Interval for checking deadlock (ms)
|