Performance Control for DB2 Fluff

Jeff Frazier

Performance Control for DB2 Fluff
Does it come with an 'OOOGA Horn'. How Cool!!



"Seibert, Dave" <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
12/08/2009 08:34 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Performance Control for DB2






I get google news alerts and every once in awhile, one of these pops up.
Thanks for sharing Joel

Dave

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

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


Error! Filename not specified.
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.



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




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

<span style="font-size:78%;"><span style="font-family:arial;"><strong>Notice:</strong> This e-mail message and its attachments are the property of Wendy's/Arby's Group Inc. </span>
<span style="font-family:arial;">or one of its subsidiaries and may contain confidential or legally privileged information intended</span>
<span style="font-family:arial;">solely for the use of the addressee(s). If you are not an intended recipient, then any use, copying or</span>
<span style="font-family:arial;">distribution of this message or its attachments is strictly prohibited. If you received this message in</span>
<span style="font-family:arial;">error, please notify the sender and delete this message entirely from your system.</span></span>

_____________________________________________________________________

* 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