SV: SER.TASK SWTCH high

Olle Brostrom

SV: SER.TASK SWTCH high
I assume this is a batch job. Can be too frequent commits, check number of commits/checkpoints vs elapsed time.

regards, Olle


________________________________
Från: IDUG DB2-L [mailto:[login to unmask email] För Jose Antonio
Skickat: den 18 december 2009 14:20
Till: [login to unmask email]
Ämne: [DB2-L] 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
[cid:[login to unmask email] ] < 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


________________________________

[ http://www.idug.org/images/M_images/idug%20na3.jpg ] < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

* 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

Jose Antonio

Re: SV: SER.TASK SWTCH high
(in response to Olle Brostrom)
Hi Olle!



No, no it was a problem with a transaction



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

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

__________________________





________________________________

De: IDUG DB2-L [mailto:[login to unmask email] En nombre de Olle Brostrom
Enviado el: viernes, 18 de diciembre de 2009 15:23
Para: [login to unmask email]
Asunto: [DB2-L] SV: SER.TASK SWTCH high



I assume this is a batch job. Can be too frequent commits, check number of commits/checkpoints vs elapsed time.



regards, Olle





________________________________

Från: IDUG DB2-L [mailto:[login to unmask email] För Jose Antonio
Skickat: den 18 december 2009 14:20
Till: [login to unmask email]
Ämne: [DB2-L] 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 - The Worldwide DB2 User Community! < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


________________________________

IDUG - The Worldwide DB2 User Community! < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


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/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Olle Brostrom

Re: SV: SER.TASK SWTCH high
(in response to Jose Antonio)
Hi again,
In a DB2 Statistic Report You should check for:

UNAVAILABLE OUTPUT LOG BUFF 0.00
OUTPUT LOG BUFFER PAGED IN 0.00

Theese values should always be zero otherwise you have to increase the
Log Buffer and/or check if you are contstrained on memory.
And even if you have your logs on fast devices you should check the
response times for the logs. Disk writes used to be fast because they are
just written to the disk controller chache which normally is non volatile.

Good luck and have a happy new Year!
Cheers!
//Olle



_____________________________________________________________________

* 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