[DB2 V8 z/OS] SYSSTAT (again)

Lockwood Lyon

[DB2 V8 z/OS] SYSSTAT (again)
Dear Esteemed List:

I've got the same issue that Lisa did back in '06 ... I'm supporting a
Websphere-based vendor package that is heavily dependent on accessing
DB2 z/OS data thru Stored Procedures. We see a large percentage of
elapsed time and a large # of GetPages associated with the
NULLID.SYSSTAT package.

Could someone please remind me what this thing does, and what our tuning
options are?

As always, thanks in advance for any info you can provide.

Lock Lyon
Fifth Third Bancorp


Subject: SYSSTAT package - What am I seeing?
From: Lisa Ouellette
Reply-To: DB2 Database Discussion list at IDUG
Date: Tue, 15 Aug 2006 09:20:16 -0500
Content-Type: text/plain

Help me understand what I am seeing in DB2PM reports. It appears as if
SYSSTAT is a major CPU consumer (42% of my application). I'm thinking
this
is the IBM package that is used to call a stored procedure in the
distributed address space. Is this all it does? Is there a way to tune
this? I'm seeing lots of getpages for the SYSSTAT package too.

[...snip...]




This e-mail transmission contains information that is confidential and may be privileged.
It is intended only for the addressee(s) named above. If you receive this e-mail in error,
please do not read, copy or disseminate it in any manner. If you are not the intended
recipient, any disclosure, copying, distribution or use of the contents of this information
is prohibited. Please reply to the message immediately by informing the sender that the
message was misdirected. After replying, please erase it from your computer system. Your
assistance in correcting this error is appreciated.




The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Avram Friedman

Re: [DB2 V8 z/OS] SYSSTAT (again)
(in response to Lockwood Lyon)
Lock
Below is a recent (this year) Q&A from IBMlink on this topic.
Hope I am not abusing IBM's copyrights, some times its hard to figure out.
Happy Holidays

Av

Source..........: CA CA
Last updated....: 20070329
Abstract........: What is DB2 Object NULLID.SYSSTAT?

SUMMARY: What is DB2 Object NULLID.SYSSTAT?

Product Name Version/Release Maintenance Level
DB2 for z/OS and OS/390 Ver7.1

SOLUTION: See the "Answer:" section below

DETAILS:

Question:
What is NULLID.SYSSTAT and when is it invoked. We have an OEM
monitor product that showed it had over 2 minutes in TCB wait time for
a stored procedure. I don't know if that is cumulative or one occurance.

Answer:
NULLID.SYSSTAT is a DB2 Connect package. In particular, it is
used by Connect's Call Level Interface (CLI) layer when CLI needs
to do some static SQL (such as SQLGetLength). There are some internal
SQL statements that CLI does statically in order to improve performance.






S e a r c h - k e y w o r d s:
DB2 NULLID.SYSSTAT Connect



On Thu, 27 Dec 2007 13:12:23 -0500, Lyon, Lockwood
<[login to unmask email]> wrote:

>Dear Esteemed List:
>
>I've got the same issue that Lisa did back in '06 ... I'm supporting a
>Websphere-based vendor package that is heavily dependent on accessing
>DB2 z/OS data thru Stored Procedures. We see a large percentage of
>elapsed time and a large # of GetPages associated with the
>NULLID.SYSSTAT package.
>
>Could someone please remind me what this thing does, and what our tuning
>options are?
>
>As always, thanks in advance for any info you can provide.
>
>Lock Lyon
>Fifth Third Bancorp
>
>
>Subject: SYSSTAT package - What am I seeing?
>From: Lisa Ouellette
>Reply-To: DB2 Database Discussion list at IDUG
>Date: Tue, 15 Aug 2006 09:20:16 -0500
>Content-Type: text/plain
>
>Help me understand what I am seeing in DB2PM reports. It appears as if
>SYSSTAT is a major CPU consumer (42% of my application). I'm thinking
>this
>is the IBM package that is used to call a stored procedure in the
>distributed address space. Is this all it does? Is there a way to tune
>this? I'm seeing lots of getpages for the SYSSTAT package too.
>
>[...snip...]
>
>
>
>
>This e-mail transmission contains information that is confidential and may be
privileged.
>It is intended only for the addressee(s) named above. If you receive this e-
mail in error,
>please do not read, copy or disseminate it in any manner. If you are not the
intended
>recipient, any disclosure, copying, distribution or use of the contents of this
information
>is prohibited. Please reply to the message immediately by informing the
sender that the
>message was misdirected. After replying, please erase it from your computer
system. Your
>assistance in correcting this error is appreciated.
>
>
>
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the 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
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Myron Miller

Re: [DB2 V8 z/OS] SYSSTAT (again)
(in response to Avram Friedman)
From a tuning point of view, there's not much you can do other than ensuring
capturing the SQL issued and making sure that the catalog has indexes to
support that SQL. IBM is in the process of rewriting some of these procedures,
PTF to be released sometime late in Jan. 2008.

Myron
--- "Lyon, Lockwood" <[login to unmask email]> wrote:

> Dear Esteemed List:
>
> I've got the same issue that Lisa did back in '06 ... I'm supporting a
> Websphere-based vendor package that is heavily dependent on accessing
> DB2 z/OS data thru Stored Procedures. We see a large percentage of
> elapsed time and a large # of GetPages associated with the
> NULLID.SYSSTAT package.
>
> Could someone please remind me what this thing does, and what our tuning
> options are?
>
> As always, thanks in advance for any info you can provide.
>
> Lock Lyon
> Fifth Third Bancorp
>
>
> Subject: SYSSTAT package - What am I seeing?
> From: Lisa Ouellette
> Reply-To: DB2 Database Discussion list at IDUG
> Date: Tue, 15 Aug 2006 09:20:16 -0500
> Content-Type: text/plain
>
> Help me understand what I am seeing in DB2PM reports. It appears as if
> SYSSTAT is a major CPU consumer (42% of my application). I'm thinking
> this
> is the IBM package that is used to call a stored procedure in the
> distributed address space. Is this all it does? Is there a way to tune
> this? I'm seeing lots of getpages for the SYSSTAT package too.
>
> [...snip...]
>
>
>
>
> This e-mail transmission contains information that is confidential and may be
> privileged.
> It is intended only for the addressee(s) named above. If you receive this
> e-mail in error,
> please do not read, copy or disseminate it in any manner. If you are not the
> intended
> recipient, any disclosure, copying, distribution or use of the contents of
> this information
> is prohibited. Please reply to the message immediately by informing the
> sender that the
> message was misdirected. After replying, please erase it from your computer
> system. Your
> assistance in correcting this error is appreciated.
>
>
>
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the 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
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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