Home > database >  How to change the database parameters
How to change the database parameters

Time:09-21

As follows:
 
The Self tuning memory (the SELF_TUNING_MEM)=OFF
The Size of the database Shared memory (4 KB) (DATABASE_MEMORY)=AUTOMATIC (2733072)
The Database memory threshold (DB_MEM_THRESH)=10
Max storage for the lock list (4 KB) (LOCKLIST)=102400
Percent) of the lock lists per application (MAXLOCKS)=60
Package cache size (4 KB) (PCKCACHESZ)=MAXAPPLS * (8)
The Sort heap thres for Shared sorts (4 KB) (SHEAPTHRES_SHR)=26200
Sort the list heap (4 KB) (SORTHEAP)=13100

Request bosses question, (DATABASE_MEMORY)=AUTOMATIC (2733072) and (PCKCACHESZ)=MAXAPPLS * (8) is to use what statements to modify, I use the
 db2 update db CFG for "misdb using PCKCACHESZ AUTOMATIC"; 
Db2 update db CFG for misdb using PCKCACHESZ MAXAPPLS * 9
has been an error

CodePudding user response:

  •  Tags:  
  • DB2
  • Related