Is Reorg table & Bind pgm will help to improve performan

kalaikala · New User Joined: 21 Jul 2007 Posts: 27 Location: Chennai

Hi,

My program (DB2 + BMC) does huge number of insert & update operation. Its not partitioned tablespace. Its daily job its taking nearly 1 hour.

How can I improve the performance.

Is Reorg table & then Bind pgm will help to improve performance. If it improve performance how frequently we need to do this reorg & Bind?.

dick scherrer · Posted: Fri Mar 13, 2009 7:16 pm

Hello,

The performance is most likely due to the design of the tables and code, the volume of work to be done, and the competition with other tasks on the system when it is run.

A reorg and bind will most likely not provide significantly better performance.

Sometimes things take a long time to run because they are doing a huge amount of real work. More and more often, things take a long time because of poor design of the database and/or the code.