SER.TASK SWTCH high

Jose Antonio

SER.TASK SWTCH high
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

< http://www.cam.es/ >

__________________________






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 www.cam.es , 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 www.cam.es , in the Legal Disclaimer section

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org 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, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L