Jose Antonio

Hello everyone again!

After running an accounting report we have an average time of:

SER.TASK SWTCH 1.850374 and almost everything is UPDATE COMMIT 1.845896

Reading Administration Guide it suggests:

Wait for phase 2 commit processing for updates, inserts, and deletes (UPDATE

COMMIT). You can reduce this wait time by allocating the DB2 primary log on a

faster disk. You can also help to reduce the wait time by reducing the number of

commits per unit of work.

My DBA mate says that DB2 primary log is located in a faster disk already.

Any ideas apart from the ones in the Administration Guide!?!??!?!?!

Thanks a lot!!!!!!!!!

José A Morcillo Valenciano
Tfno.: +34 965 90 51 43
747-Producción Informática

< >


Este correo electrónico es confidencial. Si lo ha recibido por error, por favor
contacte con el remitente y destruya su contenido. Toda la información relativa a
la Protección de Datos de Carácter Personal, se encuentra a su disposición en la
página web , en el apartado Aviso legal

This e-mail is confidential. If you have received this e-mail in error, please contact
the sender and delete it from your system. All information about Personal Data
Protection can be found on the website , in the Legal Disclaimer section


* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________ membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!

If you need to change settings, is the home of IDUG's DB2-L