[DB2-L] Performance Control for DB2 Fluff

Georg Peter

[DB2-L] Performance Control for DB2 Fluff
Joel,



it seems Aston Martin really had a car with DB2 in the name:

1950-1953 Aston Martin DB2
1953-1957 Aston Martin DB2/4 ....

(found under www.myvrl.com/group/astonmartinownersgroup)

So do we really have do rewrite the history of DB2 ??????

SCNR ;-)

Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
P Think before you print.

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Jeff Frazier
Gesendet: Dienstag, 8. Dezember 2009 14:39
An: [login to unmask email]
Betreff: Re: [DB2-L] 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 < http://www.responsivesystems.com/ >

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

tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Robert Catterall <mailto:[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: [login to unmask email] <mailto:[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] <mailto:[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 < http://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 - 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 >


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


________________________________




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

David Seibert

Re: Performance Control for DB2 Fluff
(in response to Georg Peter)
Here's another:



Last week, I was walking through one of the floors here that are pretty
much entrenched in Oracle DB work and I noticed the word DB2 on a white
board in a cubicle. I got excited for a moment and thought, as the
Corporate DB2 bigot here, I needed to go find out what's going on and
encourage it. But then I noticed the rest of the diagram where it
showed connections to and from DB1, DB2, & DB3 and I realized these were
entity diagrams.



Dave

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jeff Frazier
Sent: Tuesday, December 08, 2009 8:39 AM
To: [login to unmask email]
Subject: Re: [DB2-L] 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 < http://www.responsivesystems.com/ >

Buffer Pool Tool for DB2 on www.LinkedIn.com
< http://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 <mailto:[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: [login to unmask email] <mailto:[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 < http://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 - 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 >

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







________________________________






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

Lockwood Lyon

Re: Performance Control for DB2 Fluff
(in response to David Seibert)
This shows the craftiness of IBM Marketing.

After all, I doubt that when walking through the floor where everyone is
entrenched in DB2 that you'd see diagrams labelled ORACLE1, ORACLE2,
etc.

Lock Lyon
Fifth Third Bancorp


________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
Seibert, Dave
Sent: Tuesday, December 08, 2009 10:10 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Performance Control for DB2 Fluff



Here's another:



Last week, I was walking through one of the floors here that are
pretty much entrenched in Oracle DB work and I noticed the word DB2 on a
white board in a cubicle. I got excited for a moment and thought, as the
Corporate DB2 bigot here, I needed to go find out what's going on and
encourage it. But then I noticed the rest of the diagram where it
showed connections to and from DB1, DB2, & DB3 and I realized these were
entity diagrams.



Dave

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.




_____________________________________________________________________

* 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

Kirk Hampton

Re: Performance Control for DB2 Fluff
(in response to Lockwood Lyon)
We once had a client who was balking at converting their in-house
written application to DB2, because it had been prototyped in dBase III,
and they did not want to take a step backwards.



J Kirk Hampton

Sr. Specialist - Mainframe

HCL Technologies America

Mesquite Data Center

972-216-3119



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lyon,
Lockwood
Sent: Tuesday, December 08, 2009 9:57 AM
To: Hampton, Kirk
Subject: Re: Performance Control for DB2 Fluff



This shows the craftiness of IBM Marketing.



After all, I doubt that when walking through the floor where everyone is
entrenched in DB2 that you'd see diagrams labelled ORACLE1, ORACLE2,
etc.



Lock Lyon

Fifth Third Bancorp




________________________________


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
Seibert, Dave
Sent: Tuesday, December 08, 2009 10:10 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Performance Control for DB2 Fluff

Here's another:



Last week, I was walking through one of the floors here that are
pretty much entrenched in Oracle DB work and I noticed the word DB2 on a
white board in a cubicle. I got excited for a moment and thought, as the
Corporate DB2 bigot here, I needed to go find out what's going on and
encourage it. But then I noticed the rest of the diagram where it
showed connections to and from DB1, DB2, & DB3 and I realized these were
entity diagrams.



Dave

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.




________________________________


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 >


Confidentiality Notice: This email message, including any attachments,
contains or may contain confidential information intended only for the
addressee. If you are not an intended recipient of this message, be
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its attachments is strictly prohibited. If
you have received this message in error, please notify the sender
immediately by reply message and delete this email message and any
attachments from your system.

_____________________________________________________________________

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

Re: Performance Control for DB2 Fluff
(in response to Kirk Hampton)
Wouldn't they be labeled URK-1, URK-2, URK-3...???

You know, as in Urkel (I mean Oracle!!)

David


Please note: message attached

From: "Lyon, Lockwood" <[login to unmask email]>
To: [login to unmask email]
Subject: Re: [DB2-L] Performance Control for DB2 Fluff
Date: Tue, 8 Dec 2009 10:57:04 -0500


____________________________________________________________
Nutrition
Improve your career health. Click now to study nutrition!
http://thirdpartyoffers.juno.com/TGL2131/c?cp=_2dEHRRzmveEdY_v9HTNYQAAJz2i9R_j_Y5ef6WP9NxqQ2yLAAYAAAAAAAAAAAAAAAAAAADNAAAAAAAAAAAAAAAAAAASQwAAAAA=

_____________________________________________________________________

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

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

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

  • import1 (13.9k)

Peter Suhner

Re: AW: [DB2-L] Performance Control for DB2 Fluff
(in response to David S Waugh)


...and of course James Bond would use DB2 if he needed a database to save the world once again. Maybe IBM should talk to EON Productions about product placement for the next 007 movie (before URKL does)...

Here's what the "other" DB2 looks like: http://wheels.blogs.nytimes.com/2009/10/30/1950-aston-martin-sells-for-record-900000/. Check out the plate, saying "VMF 64" -> these guys ran a "Virtual MainFrame, 64bit" version back in the fifties already! Famous thingy, won several racings. Also didn't come for free, though...


Date: Tue, 8 Dec 2009 15:03:41 +0100
From: [login to unmask email]
To: [login to unmask email]
Subject: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff




Nachricht




Joel,

it seems
Aston Martin really had a car with DB2 in the name:

1950–1953
Aston
Martin DB2
1953–1957 Aston
Martin DB2/4 ....

(found under www.myvrl.com/group/astonmartinownersgroup)

So do
we really have do rewrite the history
of DB2 ??????

SCNR
;-)

Any info that anybody can
provide on the above would be greatly appreciated.

With kind regards -
mit freundlichen Gruessen,
G e o r g H . P e t e
r
-------------------------------------------------------------------
Datenzentrale
Baden-Wuerttemberg
Development and Product Support
(E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany,
Europe
e:mail [login to unmask email]
Phone
0049-711-8108-271
PC-Fax 004971189696071
Internet (only in
german language):http://www.dzbw.de
----------------------------------------------------------------------
P
Think before
you print.


-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L
[mailto:[login to unmask email] Im Auftrag von Jeff
Frazier
Gesendet: Dienstag, 8. Dezember 2009 14:39
An:
[login to unmask email]
Betreff: Re: [DB2-L] 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.


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






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.


_________________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010
_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Chris Tee

Re: AW: [DB2-L] Performance Control for DB2 Fluff
(in response to Peter Suhner)

Yes, we wouldn't want URKL in the Bond movies, they've already had their 15 minutes of fame in the Matrix trilogy

Date: Fri, 11 Dec 2009 13:52:08 +0100
From: [login to unmask email]
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff









...and of course James Bond would use DB2 if he needed a database to save the world once again. Maybe IBM should talk to EON Productions about product placement for the next 007 movie (before URKL does)...

Here's what the "other" DB2 looks like: http://wheels.blogs.nytimes.com/2009/10/30/1950-aston-martin-sells-for-record-900000/. Check out the plate, saying "VMF 64" -> these guys ran a "Virtual MainFrame, 64bit" version back in the fifties already! Famous thingy, won several racings. Also didn't come for free, though...


Date: Tue, 8 Dec 2009 15:03:41 +0100
From: [login to unmask email]
To: [login to unmask email]
Subject: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff




Nachricht




Joel,

it seems
Aston Martin really had a car with DB2 in the name:

1950–1953
Aston
Martin DB2
1953–1957 Aston
Martin DB2/4 ....

(found under www.myvrl.com/group/astonmartinownersgroup)

So do
we really have do rewrite the history
of DB2 ??????

SCNR
;-)

Any info that anybody can
provide on the above would be greatly appreciated.

With kind regards -
mit freundlichen Gruessen,
G e o r g H . P e t e
r
-------------------------------------------------------------------
Datenzentrale
Baden-Wuerttemberg
Development and Product Support
(E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany,
Europe
e:mail [login to unmask email]
Phone
0049-711-8108-271
PC-Fax 004971189696071
Internet (only in
german language):http://www.dzbw.de
----------------------------------------------------------------------
P
Think before
you print.


-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L
[mailto:[login to unmask email] Im Auftrag von Jeff
Frazier
Gesendet: Dienstag, 8. Dezember 2009 14:39
An:
[login to unmask email]
Betreff: Re: [DB2-L] 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.


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






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.


Windows Live: Keep your friends up to date with what you do online.






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


_________________________________________________________________
Be one of the first to try Windows Live Mail.
http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Patrick Steurs

Re: AW: [DB2-L] Performance Control for DB2 Fluff
(in response to Chris Tee)
I thougth they run on Zion Mainframes....



greetings,



Patrick Steurs



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Tee
Sent: vrijdag 11 december 2009 14:39
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff



Yes, we wouldn't want URKL in the Bond movies, they've already had their 15 minutes of fame in the Matrix trilogy

________________________________

Date: Fri, 11 Dec 2009 13:52:08 +0100
From: [login to unmask email]
To: [login to unmask email]
Subject: Re: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff


...and of course James Bond would use DB2 if he needed a database to save the world once again. Maybe IBM should talk to EON Productions about product placement for the next 007 movie (before URKL does)...

Here's what the "other" DB2 looks like: http://wheels.blogs.nytimes.com/2009/10/30/1950-aston-martin-sells-for-record-900000/. Check out the plate, saying "VMF 64" -> these guys ran a "Virtual MainFrame, 64bit" version back in the fifties already! Famous thingy, won several racings. Also didn't come for free, though...



________________________________

Date: Tue, 8 Dec 2009 15:03:41 +0100
From: [login to unmask email]
To: [login to unmask email]
Subject: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff

Joel,



it seems Aston Martin really had a car with DB2 in the name:

1950-1953 Aston Martin DB2
1953-1957 Aston Martin DB2/4 ....

(found under www.myvrl.com/group/astonmartinownersgroup)

So do we really have do rewrite the history of DB2 ??????

SCNR ;-)

Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
P Think before you print.

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Jeff Frazier
Gesendet: Dienstag, 8. Dezember 2009 14:39
An: [login to unmask email]
Betreff: Re: [DB2-L] 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 < http://www.responsivesystems.com/ >

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

tel. (732) 972-1261
fax.(732) 972-9416
----- Original Message -----
From: Robert Catterall <mailto:[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: [login to unmask email] <mailto:[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] <mailto:[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 < http://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 - 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 >

Notice: This e-mail message and its attachments are the property of Wendy's/Arby's Group Inc.

or one of its subsidiaries and may contain confidential or legally privileged information intended

solely for the use of the addressee(s). If you are not an intended recipient, then any use, copying or

distribution of this message or its attachments is strictly prohibited. If you received this message in

error, please notify the sender and delete this message entirely from your system.






________________________________




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

________________________________

Windows Live: Keep your friends up to date with what you do online. < http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010 >

________________________________

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 >

________________________________

Be one of the first to try Windows Live Mail. < http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d >



________________________________

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 >




-----------------------------------------
Visit our website! http://www.nbb.be

"DISCLAIMER: The content of this e-mail message should not be
construed as binding on the part of the National Bank of Belgium
(NBB) unless otherwise and previously stated. The opinions
expressed in this message are solely those of the author and do not
necessarily reflect NBB viewpoints, particularly when the content
of this message, or part thereof, is private by nature or does not
fall within the professional scope of its author."

_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Troy L Coleman

Re: AW: [DB2-L] Performance Control for DB2 Fluff
(in response to Patrick Steurs)
I feature the 1950 Aston Martin DB2 car on my web site www.troylcoleman.com with a note about the power and performance just as DB2 for z/OS has. J





< http://www.ca.com/mainframe2 >

Troy Coleman

CA, Inc.

Principal Product Manager

Office: +1630 505 6025

Mobile: +1224 343 0073

Blog: http://ibmsystemsmag.blogs.com/db2utor/

Twitter: http://twitter.com/DB2utor

Twitter: http://twitter.com/troycoleman

Linkedin: http://www.linkedin.com/in/troylcoleman



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Peter, Georg
Sent: Tuesday, December 08, 2009 8:04 AM
To: [login to unmask email]
Subject: [DB2-L] AW: [DB2-L] Performance Control for DB2 Fluff



Joel,



it seems Aston Martin really had a car with DB2 in the name:

1950-1953 Aston Martin DB2
1953-1957 Aston Martin DB2/4 ....

(found under www.myvrl.com/group/astonmartinownersgroup)

So do we really have do rewrite the history of DB2 ??????

SCNR ;-)

Any info that anybody can provide on the above would be greatly appreciated.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de < http://www.dzbw.de/ >
----------------------------------------------------------------------
P Think before you print.

-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Jeff Frazier
Gesendet: Dienstag, 8. Dezember 2009 14:39
An: [login to unmask email]
Betreff: Re: [DB2-L] 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 < http://www.responsivesystems.com/ >

Buffer Pool Tool for DB2 on www.LinkedIn.com < http://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 <mailto:[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: [login to unmask email] <mailto:[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 < http://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 - 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 >

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







________________________________






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