[Fluff] Performance Control for DB2

Nick CIANCI

[Fluff] Performance Control for DB2
Oh what the heck ... are they running a "v8"? ... :-)

Regards,
  Nick CIANCI

                Database Administration
                IBM Australia ~ Canberra
                Phone:   +61 2) 6212-1214 (Barton)
                Mobile: 0408- 64 06 01
                MailTo:[login to unmask email]







Joel Goldstein -
Responsive
Systems To
<[login to unmask email] [login to unmask email]
YSTEMS.COM> cc
Sent by: IDUG
DB2-L Subject
<[login to unmask email] [DB2-L] Performance Control for DB2
ORG>


08/12/09 11:59 AM


Please respond to
IDUG DB2-L
<[login to unmask email]
2-L.ORG>






It may only be Monday, but what the heck... Friday is never far away.

Was doing some general websurfing, and saw something about DB2 performance
on the JC Whitney website - they're auto parts.
Or course I clicked to see what it was... snake oil. Like chrome
muffler bearings.

Performance Control & Engine Management for your Aston Martin DB2.
Check out our great selection of Performance Control & Engine Management
products for your Aston Martin DB2. We offer an industry leading ONE YEAR
GUARANTEE so that you can Shop with confidence! Select from the products or
categories below to narrow the selection in Performance Control & Engine
Management for your Aston Martin DB2.

Need a sense of humor .....

Regards,
Joel

Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
The Performance Wizard is in Beta...
www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at:
www.responsivesystems.com/Movie1

tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Robert Catterall
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Monday, December 07, 2009 11:53 AM
Subject: Re: [DB2-L] DB2 People Soft Compare issue

If the PeopleSoft process is using dynamic SQL, and if dynamic statement
caching is being utilized, is it possible that the ALTER TABLESPACE
LOCKSIZE change has had no effect because the statements in question are
cached and have not been re-prepared since the execution of the ALTER
TABLESPACE statement? If so, you could try invalidating the cached
statements by way of a RUNSTATS job with UPDATE NONE and REPORT NO. Then,
when the statements are re-prepared, the new LOCKSIZE specification should
be honored.

Also, does the compare involve just SELECT statements against the target
objects? If so, why are so many locks being held? Was the associated
package bound with an isolation level of repeatable read?

Robert


On Mon, Dec 7, 2009 at 9:57 AM, SrinivasG <[login to unmask email]> wrote:
Hi,





The user is running compare reports in People Soft that is accessing DB2
V9 Database.


Consistently we are getting the below error :





- DSNILMCL RESOURCE UNAVAILABLE 776


CORRELATION-ID=pside.exe


CONNECTION-ID=SERVER


LUW-ID=AC15670A.G1BE.C5334BCE40ED=6


REASON 00C90096


TYPE 00000304


NAME PSHRDMO .PTPRJWK .X'0009C9' '.X'0A'








I have Altered the Tablespaces to have lock size Table or Tablespace. In
addition I have reset NUMLKUS to 0.


Earlier NUMLKUS was 10000 and then 30000. Out of desperation I have set
it to 0.





We have a Z800 Dual CPU System. The memory allocated to this LPAR that
only runs DB2 is 3.2 GB.





But still this error persists.





Regards,


Srinivas G






**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely
for the use of the addressee(s). If you are not the intended recipient,
please
notify the sender by e-mail and delete the original message. Further, you
are not
to copy, disclose, or distribute this e-mail or its contents to any other
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken
every reasonable precaution to minimize this risk, but is not liable for
any damage
you may sustain as a result of any virus in this e-mail. You should carry
out your
own virus checks before opening the e-mail or attachment. Infosys reserves
the
right to monitor and review the content of all messages sent to or from
this e-mail
address. Messages sent to or from this e-mail address may be stored on the

Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***







IDUG - The Worldwide DB2 User Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.





--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com




(Embedded image moved to file: pic04451.jpg)IDUG - The Worldwide DB2 User
Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.






(Embedded image moved to file: pic21481.jpg)IDUG - The Worldwide DB2 User
Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.


_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Joel Goldstein

Re: [Fluff] Performance Control for DB2
(in response to Nick CIANCI)
Hi Nick,

6 actually a dual overhead cam straight 6... so we can't say V6

Regards,
Joel

Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
Performance Wizard is in Beta..
..www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1

tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: "Nick Cianci" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Monday, December 07, 2009 8:20 PM
Subject: Re: [DB2-L] [Fluff] Performance Control for DB2


Oh what the heck ... are they running a "v8"? ... :-)

Regards,
Nick CIANCI

Database Administration
IBM Australia ~ Canberra
Phone: +61 2) 6212-1214 (Barton)
Mobile: 0408- 64 06 01
MailTo:[login to unmask email]







Joel Goldstein -
Responsive
Systems To
<[login to unmask email] [login to unmask email]
YSTEMS.COM> cc
Sent by: IDUG
DB2-L Subject
<[login to unmask email] [DB2-L] Performance Control for DB2
ORG>


08/12/09 11:59 AM


Please respond to
IDUG DB2-L
<[login to unmask email]
2-L.ORG>






It may only be Monday, but what the heck... Friday is never far away.

Was doing some general websurfing, and saw something about DB2 performance
on the JC Whitney website - they're auto parts.
Or course I clicked to see what it was... snake oil. Like chrome
muffler bearings.

Performance Control & Engine Management for your Aston Martin DB2.
Check out our great selection of Performance Control & Engine Management
products for your Aston Martin DB2. We offer an industry leading ONE YEAR
GUARANTEE so that you can Shop with confidence! Select from the products or
categories below to narrow the selection in Performance Control & Engine
Management for your Aston Martin DB2.

Need a sense of humor .....

Regards,
Joel

Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too
The Performance Wizard is in Beta...
www.responsivesystems.com

Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at:
www.responsivesystems.com/Movie1

tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Robert Catterall
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Monday, December 07, 2009 11:53 AM
Subject: Re: [DB2-L] DB2 People Soft Compare issue

If the PeopleSoft process is using dynamic SQL, and if dynamic statement
caching is being utilized, is it possible that the ALTER TABLESPACE
LOCKSIZE change has had no effect because the statements in question are
cached and have not been re-prepared since the execution of the ALTER
TABLESPACE statement? If so, you could try invalidating the cached
statements by way of a RUNSTATS job with UPDATE NONE and REPORT NO. Then,
when the statements are re-prepared, the new LOCKSIZE specification should
be honored.

Also, does the compare involve just SELECT statements against the target
objects? If so, why are so many locks being held? Was the associated
package bound with an isolation level of repeatable read?

Robert


On Mon, Dec 7, 2009 at 9:57 AM, SrinivasG <[login to unmask email]> wrote:
Hi,





The user is running compare reports in People Soft that is accessing DB2
V9 Database.


Consistently we are getting the below error :





- DSNILMCL RESOURCE UNAVAILABLE 776


CORRELATION-ID=pside.exe


CONNECTION-ID=SERVER


LUW-ID=AC15670A.G1BE.C5334BCE40ED=6


REASON 00C90096


TYPE 00000304


NAME PSHRDMO .PTPRJWK .X'0009C9' '.X'0A'








I have Altered the Tablespaces to have lock size Table or Tablespace. In
addition I have reset NUMLKUS to 0.


Earlier NUMLKUS was 10000 and then 30000. Out of desperation I have set
it to 0.





We have a Z800 Dual CPU System. The memory allocated to this LPAR that
only runs DB2 is 3.2 GB.





But still this error persists.





Regards,


Srinivas G






**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely
for the use of the addressee(s). If you are not the intended recipient,
please
notify the sender by e-mail and delete the original message. Further, you
are not
to copy, disclose, or distribute this e-mail or its contents to any other
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken
every reasonable precaution to minimize this risk, but is not liable for
any damage
you may sustain as a result of any virus in this e-mail. You should carry
out your
own virus checks before opening the e-mail or attachment. Infosys reserves
the
right to monitor and review the content of all messages sent to or from
this e-mail
address. Messages sent to or from this e-mail address may be stored on the

Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***







IDUG - The Worldwide DB2 User Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.





--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com




(Embedded image moved to file: pic04451.jpg)IDUG - The Worldwide DB2 User
Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.






(Embedded image moved to file: pic21481.jpg)IDUG - The Worldwide DB2 User
Community!


The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.


_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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


_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Sam Orner

Re: Performance Control for DB2
(in response to Joel Goldstein)
JC Whitney. Now there's a blast from the past! They were a cost saver for
many a replacement part for my '74 Camaro and subsequent '76 Monte Carlo!

(Embedded image moved to file: pic09881.jpg)
=====
This message contains privileged and confidential information intended for the above addressees only. If you
receive this message in error please delete or destroy this message and/or attachments.

The sender of this message will fully cooperate in the civil and criminal prosecution of any individual engaging
in the unauthorized use of this message.
=====

_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

David Seibert

Re: Performance Control for DB2
(in response to Sam Orner)
I get google news alerts and every once in awhile, one of these pops up.

Thanks for sharing Joel



Dave

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Joel
Goldstein - Responsive Systems
Sent: Monday, December 07, 2009 7:59 PM
To: [login to unmask email]
Subject: [DB2-L] Performance Control for DB2



It may only be Monday, but what the heck... Friday is never far away.



Was doing some general websurfing, and saw something about DB2
performance on the JC Whitney website - they're auto parts.

Or course I clicked to see what it was... snake oil. Like chrome
muffler bearings.



Performance Control & Engine Management for your Aston Martin DB2.

Check out our great selection of Performance Control & Engine Management
products for your Aston Martin DB2. We offer an industry leading ONE
YEAR GUARANTEE so that you can Shop with confidence! Select from the
products or categories below to narrow the selection in Performance
Control & Engine Management for your Aston Martin DB2.



Need a sense of humor .....



Regards,

Joel



Joel Goldstein
Responsive Systems
IBM Gold Consultant
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works...... Predicts IO Rate !!
Predicts Group Buffer Pool performance too

The Performance Wizard is in Beta...
www.responsivesystems.com < http://www.responsivesystems.com >



Buffer Pool Tool for DB2 on www.LinkedIn.com
Watch the 3-Minute Buffer Pool Tool Movie at:
www.responsivesystems.com/Movie1



tel. (732) 972-1261
fax.(732) 972-9416


The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.


From: Robert Catterall <mailto:[login to unmask email]>

Newsgroups: bit.listserv.db2-l

To: [login to unmask email]

Sent: Monday, December 07, 2009 11:53 AM

Subject: Re: [DB2-L] DB2 People Soft Compare issue



If the PeopleSoft process is using dynamic SQL, and if dynamic
statement caching is being utilized, is it possible that the ALTER
TABLESPACE LOCKSIZE change has had no effect because the statements in
question are cached and have not been re-prepared since the execution of
the ALTER TABLESPACE statement? If so, you could try invalidating the
cached statements by way of a RUNSTATS job with UPDATE NONE and REPORT
NO. Then, when the statements are re-prepared, the new LOCKSIZE
specification should be honored.

Also, does the compare involve just SELECT statements against
the target objects? If so, why are so many locks being held? Was the
associated package bound with an isolation level of repeatable read?

Robert


On Mon, Dec 7, 2009 at 9:57 AM, SrinivasG
<[login to unmask email]> wrote:

Hi,



The user is running compare reports in People Soft that is
accessing DB2 V9 Database.

Consistently we are getting the below error :



- DSNILMCL RESOURCE UNAVAILABLE 776

CORRELATION-ID=pside.exe

CONNECTION-ID=SERVER

LUW-ID=AC15670A.G1BE.C5334BCE40ED=6

REASON 00C90096

TYPE 00000304

NAME PSHRDMO .PTPRJWK .X'0009C9' '.X'0A'





I have Altered the Tablespaces to have lock size Table or
Tablespace. In addition I have reset NUMLKUS to 0.

Earlier NUMLKUS was 10000 and then 30000. Out of desperation I
have set it to 0.



We have a Z800 Dual CPU System. The memory allocated to this
LPAR that only runs DB2 is 3.2 GB.



But still this error persists.



Regards,

Srinivas G



**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely
for the use of the addressee(s). If you are not the intended recipient,
please
notify the sender by e-mail and delete the original message. Further,
you are not
to copy, disclose, or distribute this e-mail or its contents to any
other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken
every reasonable precaution to minimize this risk, but is not liable for
any damage
you may sustain as a result of any virus in this e-mail. You should
carry out your
own virus checks before opening the e-mail or attachment. Infosys
reserves the
right to monitor and review the content of all messages sent to or from
this e-mail
address. Messages sent to or from this e-mail address may be stored on
the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***



________________________________

Error! Filename not specified. < http://www.idug.org >

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 >




--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com

________________________________

IDUG - The Worldwide DB2 User Community! < http://www.idug.org >

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 >



_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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