Site Tools
Home
Blog
About
Database administration
Operating systems
Development
Links
Following require login:
ScratchPad
2013-02-15
SAP DB2 9.7 recommended parameters
SAP Note 1329179 documents the parameter settings SAP recommend for DB2 9.7.
Alexander Seelert has put together a useful tool that will take these recommendations along with a few inputs (like database ID) and generate all the required DB2 update statements.
See also SAP IBM DB2 for LUW Parameter Check Tool - An Automated Check of IBM DB2 for LUW Parameters in SAP System Landscape.
Requires installation of code via SNOTE.
2013-02-07
IBM - DB2 IC80476 and IC70265
IC80476 - AUTOMATIC STATISTICS COLLECTIONS CAN BE FORCED DUE TO LOCK CONFLICT WITH THE LASTUSED DAEMON.
Automatic statistics collections, enabled via AUTO_RUNSTATS and AUTO_STMT_STATS database configuration parameters, can be forced due to lock conflict with the LASTUSED daemon.
First fixed in DB2 9.7 FP6.
IC70265 - LASTUSED column of SYSCAT.INDEXES is not updated in case when the table and index are not created in the same tablespace.
For me this manifested itself as explain plans clearly showing indexes as being used yet LASTUSED column was set to 01/01/0001.
First fixed in DB2 9.7 FP4.