Below are some life saver commands for DB2 admin for reorg and subsequent runstat – Reorganising tables:: This process helps in bringing together of widely separated data of a big table of DB2 where we running a OLTP intrinsic database. This process has to be done once a week. The following command in db2 will…
Below is a tuned DB config for a heavily loaded workflow application – [db2inst1@intranet db2inst1]$ db2 get db cfg for wf Database Configuration for Database wf Database configuration release level = 0x0900 Database release level = 0x0900 Database territory = US Database code page = 819 Database code set = ISO8859-1 Database country code =…
Lets see how back up policy was important for a typical IT company and how did it implement the same. Background: As we progress in our path way towards higher levels of Enterprise Management Systems, the number of critical Intranet Systems will also increased, and this is going to increase in the years to come. Recently…