Performance Control for DB2

Joel Goldstein

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

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***


----------------------------------------------------------------------------



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


------------------------------------------------------------------------------



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