The DB2 tutorial being looked at is: DB2 Programming Tips (ix). 4.8 See what database is available under this instance
DB2 LIST DATABASE DIRECTORY [On/home/db2inst1]
4.9 View and change the configuration of the database head
Note that in most cases, when you change the configuration of your data, it will not take effect until all the connections have been broken.
To view the configuration of the database head
DB2 get DB CFG for head
Change the value of a setting for the database head
4.9.1 the size of the sorted heap
DB2 Update DB CFG for head using SORTHEAP 2048
To change the size of the sort heap to 2048 pages, it is best to set the value larger for more applications.
4.9.2 change the size of the things log
DB2 Update DB CFG for head using logfilsiz 40000
The size of the item to the database and the processing of things to adapt, if things are larger, you should change the value of a bit larger. Otherwise, it is easy to handle log file full errors.
4.9.3 to modify the heap memory size when there is not enough heap memory in the program
DB2 Update DB CFG for head using APPLHEAPSZ 40000
The value cannot be too small, otherwise there will not be enough memory to run the application.
4.10 View and change the configuration of a database instance
View database Instance Configuration
DB2 get dbm CFG
Change database Instance Compounding
4.10.1 turns on lock monitoring.
DB2 update dbm CFG using Dft_mon_lock on
4.10.2 Change Diagnostics Error capture level
DB2 update dbm CFG using Diaglevel 3
0 to not record information
1 for logging errors only
2 Logging service and non-service errors
The default is 3, logging DB2 errors and warnings
4 is to record all the information, including the successful execution of the information
In general, please do not use 4, will cause DB2 to run very slowly.
<
