NOT ACCOUNT

Renzo Razzetti

NOT ACCOUNT
Hi all

We are running DB2 V8 datasharing.
We found in production two package with a high Not Account Time. Only
two packages, special packages.They perform a high insert workload.
Make linsert in the journal table.
We already checked all the possible cause that are in the book: CPU
is ok, paging is ok, not online monitoring, is not DRDA, SERV TASK
SWITCH is ok.

The corious is one day have a high not account time, and the following
day have a low not account time. Every day the table is re-define.

So,, we think the not account time maybe have any relation with the
physical definition of the table. But we are not sure.

Any idea ?



Thank you
RR

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms