Tips to Improve DB2 Performance!

Improve DB2 PerformanceDatabase recovery is one of the biggest nightmares in this age of Internet, where information are captured and stored for the analytical purposes. Databases are growing in size with the time each day and the pressure to deliver the response are becoming more critical day after day. So failures in it can results to huge loss of data and important and critical information. Further failure and corruption can result to serious consequences. So in order to protect and recover the data, there are huge numbers of database recovery software overflowing in market. Among which DB2 File Repair Tool is one of the best recovery tool.  It efficiently repairs the corrupted or inaccessible db2 file without losing any data from it.  Along with many issues of data recovery and this software even helps you to enhance the performance of your Database.

There are many issues that lead to performance issues which is one of the major concerns for DB2 users. And if you are Database Administrator (DBA) then here are some problems that you carefully need to measure for rectifying it. This means being a DBA you need to look for all possible areas of changes and improvements. Here are some tips that can help you to get back the performance of the DB2 database files:

  • Firstly turn on the Monitor Switches: It is always suggested to turn on the monitor switches If it is not then there is no information regarding the performance that you require then here are commands top turn-on the monitor switches:

db2 “update monitor switches using
lock ON sort ON bufferpool ON uow ON
table ON statement ON”

  • Then you need to ensure the sufficient DB2 Agents: Then you need to make sure that you have sufficient DB2 agents for handling your workload. There are many issues find the number of agents:

 db2 “get snapshot for database manager”

  • Then so through the following lines:

High water mark for agents registered = 7
High water mark for agents waiting for a token = 0
Agents registered= 7
Agents waiting for a token= 0
Idle agents= 5
Agents assigned from pool= 158
Agents created from empty Pool = 7
Agents stolen from another application= 0
High water mark for coordinating agents= 7
Max agents overflow= 0

In these commands you can find the agents are waiting or stolen from the application such as agents that are waiting for token or agents stolen from other applications, then these increasing numbers of agents available for database manager.

  • Then see the maximum Open files: The DB2 is designed in the way that the manager can open up multiple files at a time. With the help of MAXFILOP command you can get to0 know about the upper limit and the DB2 starts closing and opening tablespace files. This can lead to slow down the performance. This issue can be find when the DB2 is closing files or not: db2 “get snapshot for database on DBNAME”. Then after you look for the line which reads: Database files closed=0. If you find that the files are being closed then you can increase the value of “MAXFILOP” since the closing and then opening of the database stops. There are many issues of the following commands for the same:

 db2 “update db cfg for DBNAME using MAXFILOP N”

downloadnow buynow learn-more-button-orange

Keeping these things in mind you need to frequently, check the database on regular basis for improving the performance of DB2.  So that it can work more efficiently and quickly.

Steps to Improve DB2 Performance:

Step 1:  Download, Install and Run DB2 File Repair software. It will provides two options to repair db2 file, first option is for if the database is attached to DB2, then you can select the option ‘Repair the database stored at default location‘, and if the database is not attached to DB2 then choose the manual selection of database.

1 (3)

Step 2: It will provide you the list of database attached to DB2. Select the particular database you want to repair and recover corresponding database objects.

2 (2)

Step 3: In this step this tool provide the list of recoverable database files. You can see the preview by clicking on it.

3 (2)

Step 4: Give the path location for the recoverable database and its object to be saved. Click on ‘Ok’ button.

4 (2)