- DB2 instance names should contain alphanumeric characters only.
- DB2 clients should be configured to connect to the database via a LifeKeeper protected IP address. Users can define:
DB2SYSTEM=<Floating IP>” in $instancehome/sqllib/profile.env
and catalog the floating IP address on the clients.
- The /etc/services file for each server in your configuration protecting a DB2 resource hierarchy must have identical service entries for the protected instance. Additionally, the User ID, Group ID and instance home directory for the protected DB2 instance must be the same on all servers where the resource will be protected.
DB2 adds the following entries as default in /etc/services:
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
db2c_db2inst1 50001/tcp
- A recovery is what takes place after DB2 is terminated abruptly, as with a system crash. Following are tips that will significantly reduce the amount of time it takes for DB2 to recover from a failure.
º Limit the log records that DB2 will process. You can accomplish this by properly configuring the
db2 UPDATE DB CFG FOR <dbname> USING SOFTMAX 25
db2 UPDATE DB CFG FOR <dbname> USING LOGFILSIZ 1000
º Ensure that there is a sufficient number of page cleaners to accommodate your work load:
db2 UPDATE DB CFG FOR <dbname> USING NUM_IOCLEANERS <num>
- DB2 Fault Monitor should be disabled in all servers.
- DB2 should be installed in all servers.
Post your comment on this topic.