Informatica Data Quality
- Informatica Data Quality 10.4.0
- Todos os produtos
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
Nome do Parâmetro
| Valor
| Descrição do IBM DB2
|
---|---|---|
LOCKLIST
| 8192
| Armazenamento máximo para lista de bloqueio (4 KB)
|
MAXLOCKS
| 10
| Percentual de listas de bloqueio por aplicativo
|
LOCKTIMEOUT
| 300
| Tempo de espera de bloqueio (s)
|
DLCHKTIME
| 10000
| Intervalo para verificar se há deadlock (ms)
|