heavy sequential insert activity & response time

ÖZGÜR ÖZEN

heavy sequential insert activity & response time
Hi all,
I had asked about pagelatch time of our inserts and I will try to use
member cluster and trackmod no options,
bu we have also seen that we have high update commit time for our inserts.

CLASS 3 SUSPENSIONS AVERAGE TIME AV.EVENT
-------------------- ------------ --------
SER.TASK SWTCH 0.022681 1.02
UPDATE COMMIT 0.022681 1.02

What is this time and anyway to minimize it?

thanks in advance.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Janißen

Re: heavy sequential insert activity & response time
(in response to ÖZGÜR ÖZEN)
Hi

I am not sure about that, but I think the time arose, because the updated
pages have to be written to the group buffer pool. May be, to minimize
that, you can do the writing as the updates occur by using the BIND-
Parameter IMMEDWRITE YES for the package in question.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: heavy sequential insert activity & response time
(in response to Walter Janißen)
What GBPCACHE value do you have ?

Just curious

Max Scarpa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

ÖZGÜR ÖZEN

Re: heavy sequential insert activity & response time
(in response to Max Scarpa)
we use GBPCACHE CHANGED

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

ÖZGÜR ÖZEN

Re: heavy sequential insert activity & response time
(in response to ÖZGÜR ÖZEN)
sorry but can you explain more detailly the effects of immediate write for
my case?Does it have any other bad consequences?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm