I seguenti valori sono per le versioni di DB2 antecedenti alla 9
db2 update dbm cfg using QUERY_HEAP_SZ 1000
db2 update db cfg for DITTA1 using APPLHEAPSZ 512
db2 update db cfg for DITTA1 using PCKCACHESZ 128
db2 update db cfg for DITTA1 using BUFFPAGE 1024
db2 update db cfg for DITTA1 using NUM_IOCLEANERS 3
db2 update db cfg for DITTA1 using NUM_IOSERVERS 9
db2 update db cfg for DITTA1 using LOCKLIST 150
db2 update db cfg for DITTA1 using MAXAPPLS
db2 update db cfg for DITTA1 using AVG_APPLS
db2 update db cfg for DITTA1 using LOGFILSIZ 256
db2 update db cfg for DITTA1 using LOGPRIMARY
db2 update db cfg for DITTA1 using LOGSECOND
I seguenti valori sono per le versioni di DB2 uguali o superiori alla 9
db2 update dbm cfg using QUERY_HEAP_SZ 1000
db2 update db cfg for DITTA1 using APPLHEAPSZ 2048
db2 update db cfg for DITTA1 using APPL_MEMORY 40016
db2 update db cfg for DITTA1 using BUFFPAGE 16384
db2 update db cfg for DITTA1 using DBHEAP 600
db2 update db cfg for DITTA1 using NUM_IOCLEANERS 3
db2 update db cfg for DITTA1 using NUM_IOSERVERS 9
db2 update db cfg for DITTA1 using LOCKLIST 300
db2 update db cfg for DITTA1 using SORTHEAP 1024
db2 update db cfg for DITTA1 using AVG_APPLS
db2 update db cfg for DITTA1 using LOGFILSIZ 256
db2 update db cfg for DITTA1 using LOGPRIMARY
db2 update db cfg for DITTA1 using LOGSECOND
db2 update db cfg for DITTA1 using PCKCACHESZ 128
db2 update db cfg for DITTA1 using MAXAPPLS
Nessun commento:
Posta un commento