DB2 V9 CM in z/OS 1.10

Carol Anne Sutfin

DB2 V9 CM in z/OS 1.10
We just converted to V9 CM and I am getting messages

DSNT715E -DB2T ERROR 00C90004 READING 572
SYSIBM.DSNRLMT01.

We do use RLF but have it turned off right now.
DSNRLMT01 has been built

If I do start it then the subsystem abends with a S04F.

Has anyone else encountered this problem.

TIA
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

_____________________________________________________________________

* 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

Jeff Kram

Re: DB2 V9 CM in z/OS 1.10
(in response to Carol Anne Sutfin)
What level of maint are you on?
DB2 DBS
Office: 612-316-0634
Cell: 612-708-7860

This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.

----- Original Message -----
From: IDUG DB2-L <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Mon Nov 16 18:34:37 2009
Subject: [DB2-L] DB2 V9 CM in z/OS 1.10

We just converted to V9 CM and I am getting messages

DSNT715E -DB2T ERROR 00C90004 READING 572
SYSIBM.DSNRLMT01.

We do use RLF but have it turned off right now.
DSNRLMT01 has been built

If I do start it then the subsystem abends with a S04F.

Has anyone else encountered this problem.

TIA
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

_____________________________________________________________________

* 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

Carol Anne Sutfin

Re: DB2 V9 CM in z/OS 1.10
(in response to Jeff Kram)
Details, details

RSU0811. That may be the problem there.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



Jeff Kram
<[login to unmask email]
ARGO.COM> To
Sent by: IDUG [login to unmask email]
DB2-L cc
<[login to unmask email]
ORG> Subject
Re: [DB2-L] DB2 V9 CM in z/OS 1.10

11/16/2009 09:16
PM


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






What level of maint are you on?
DB2 DBS
Office: 612-316-0634
Cell: 612-708-7860

This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the addressee,
you must not use, copy, disclose, or take any action based on this message
or any information herein. If you have received this message in error,
please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.

----- Original Message -----
From: IDUG DB2-L <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Mon Nov 16 18:34:37 2009
Subject: [DB2-L] DB2 V9 CM in z/OS 1.10

We just converted to V9 CM and I am getting messages

DSNT715E -DB2T ERROR 00C90004 READING 572
SYSIBM.DSNRLMT01.

We do use RLF but have it turned off right now.
DSNRLMT01 has been built

If I do start it then the subsystem abends with a S04F.

Has anyone else encountered this problem.

TIA
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

_____________________________________________________________________

* 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

_____________________________________________________________________

* 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

Jeff Kram

Re: DB2 V9 CM in z/OS 1.10
(in response to Carol Anne Sutfin)
Check out PK75926 / UK44440, we had a similar issue with DSNRLMT01 until this fix was applied. Closed on 3/14/09.


DB2 DBS
Office: 612-316-0634
Cell: 612-708-7860
http://ds.wellsfargo.com/db2zos/
http://ds.wellsfargo.com/

>This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Tuesday, November 17, 2009 10:07 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V9 CM in z/OS 1.10

Details, details

RSU0811. That may be the problem there.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



Jeff Kram
<[login to unmask email]
ARGO.COM> To
Sent by: IDUG [login to unmask email]
DB2-L cc
<[login to unmask email]
ORG> Subject
Re: [DB2-L] DB2 V9 CM in z/OS 1.10

11/16/2009 09:16
PM


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






What level of maint are you on?
DB2 DBS
Office: 612-316-0634
Cell: 612-708-7860

This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.

----- Original Message -----
From: IDUG DB2-L <[login to unmask email]>
To: [login to unmask email] <[login to unmask email]>
Sent: Mon Nov 16 18:34:37 2009
Subject: [DB2-L] DB2 V9 CM in z/OS 1.10

We just converted to V9 CM and I am getting messages

DSNT715E -DB2T ERROR 00C90004 READING 572
SYSIBM.DSNRLMT01.

We do use RLF but have it turned off right now.
DSNRLMT01 has been built

If I do start it then the subsystem abends with a S04F.

Has anyone else encountered this problem.

TIA
Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]

_____________________________________________________________________

* 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

_____________________________________________________________________

* 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

_____________________________________________________________________

* 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

Nenad Vidak

Re: DB2 V9 CM in z/OS 1.10
(in response to Jeff Kram)
Can also have a look at PM00162 :
http://www-01.ibm.com/support/search.wss?q=DSNRLMT01&ibm-search.x=0&ibm-search.y=0&ibm-search=Search&apar=include&lang=en+en&spc=&stc=&rs=0&loc=en_US&from=tss&cs=utf-8&cc=us

Regards, Nenad

On Tue, 17 Nov 2009 10:24:43 -0600, Jeff Kram <[login to unmask email]> wrote:

>Check out PK75926 / UK44440, we had a similar issue with DSNRLMT01 until
this fix was applied. Closed on 3/14/09.
>
>
>DB2 DBS
>Office: 612-316-0634
>Cell: 612-708-7860
>http://ds.wellsfargo.com/db2zos/
>http://ds.wellsfargo.com/
>
>>This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the addressee,
you must not use, copy, disclose, or take any action based on this message
or any information herein. If you have received this message in error,
please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.
>
>-----Original Message-----
>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
>Sent: Tuesday, November 17, 2009 10:07 AM
>To: [login to unmask email]
>Subject: Re: [DB2-L] DB2 V9 CM in z/OS 1.10
>
>Details, details
>
>RSU0811. That may be the problem there.
>
>Carol Sutfin
>Corporate DBA
>Regions Financial Corp.
>(205)261-5214
>[login to unmask email]
>
>
>
> Jeff Kram
> <[login to unmask email]
> ARGO.COM> To
> Sent by: IDUG [login to unmask email]
> DB2-L cc
> <[login to unmask email]
> ORG> Subject
> Re: [DB2-L] DB2 V9 CM in z/OS 1.10
>
> 11/16/2009 09:16
> PM
>
>
> Please respond to
> IDUG DB2-L
> <[login to unmask email]
> 2-L.ORG>
>
>
>
>
>
>
>What level of maint are you on?
>DB2 DBS
>Office: 612-316-0634
>Cell: 612-708-7860
>
>This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the addressee,
you must not use, copy, disclose, or take any action based on this message
or any information herein. If you have received this message in error,
please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.
>
>----- Original Message -----
>From: IDUG DB2-L <[login to unmask email]>
>To: [login to unmask email] <[login to unmask email]>
>Sent: Mon Nov 16 18:34:37 2009
>Subject: [DB2-L] DB2 V9 CM in z/OS 1.10
>
>We just converted to V9 CM and I am getting messages
>
> DSNT715E -DB2T ERROR 00C90004 READING 572
> SYSIBM.DSNRLMT01.
>
>We do use RLF but have it turned off right now.
>DSNRLMT01 has been built
>
>If I do start it then the subsystem abends with a S04F.
>
>Has anyone else encountered this problem.
>
>TIA
>Carol Sutfin
>Corporate DBA
>Regions Financial Corp.
>(205)261-5214
>[login to unmask email]
>
>_____________________________________________________________________
>
>* 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
>
>_____________________________________________________________________
>
>* 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
>
>_____________________________________________________________________
>
>* 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

_____________________________________________________________________

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

http://www.IDUG.org membership is now open and free for all.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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

Bob Jeandron

DB2 V9 z/os
(in response to Nenad Vidak)
Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have
significantly been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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

Phil Grainger

Re: DB2 V9 z/os
(in response to Bob Jeandron)
One BIG gotcha that I've seen far too many people fall foul of concerns the
new algorithm to choose which work file table spaces DB2 uses

In DB2 V8 (and prior) Db2 will ALWAYS sort in 4K work files unless the sort
record won't fit, which causes DB2 to switch to 32K work files

In DB2 9, because potentially 8 times as many rows fit onto a 32K page as a
4K one, DB2 will prefer to sort in 32K work files, only using 4K work files
where the sort record is very short OR where there ARE no 32K work files

The pain point is when you have carefully sized BIG 4K work files, but have
one (or a few) small 32K ones to "catch" any extra-long sorts. Suddenly, and
this happens in CM too by the way, you will experience many sort failures as
your previously OK sort activity starts to run out of space in your
undersized 32K work files

SO

PLEASE be VERY careful to review the sizing of your work table spaces
between 4K and 32K allocations

Also, there is a relatively new PTF (PK70060) which further modifies work
file selection depending on whether the work files have secondary
allocations (or not)

Phil G
Grainger Database Solutions Ltd

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bob Jeandron
Sent: 11 December 2009 18:33
To: [login to unmask email]
Subject: [DB2-L] DB2 V9 z/os

Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have
significantly been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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

_____________________________________________________________________

* 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

Barbara Koenen

Re: DB2 V9 z/os
(in response to Phil Grainger)
Watch your workfile allocations. It uses tons more 32K.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bob Jeandron
Sent: Friday, December 11, 2009 12:33 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V9 z/os

Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have
significantly been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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

William Favero

Re: DB2 V9 z/os
(in response to Barbara Koenen)
If you have storage concerns, the good news, IMHO, is that DB2 9 has
automatic warning message to alert of some storage conditions. I
blogged it last week...

**http://it.toolbox.com/blogs/db2zos/look-out-youre-running-out-of-storage-35437

Willie

Bob Jeandron wrote:
> Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
> anything bit your shop)?
>
> .....Heard from somewhere, that that the memory management of V9 is not as
> forgiving as V8, anyone know what that means? Ie. may get hard crashes if
> not careful with memory alocations, more so than in V8.
>
> Also, found that DSNTINST calculated values for EDM sizes have
> significantly been reduced. In Particular:
> EDM STATEMENT CACHE
> EDM DBD CACHE
>
> And the
> EDM SKELETON POOL SIZE seems small as well.
>
> Any comments are greatly appreciated.
>
> _____________________________________________________________________
>
> * 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
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA


_____________________________________________________________________

* 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

David Simpson

Re: DB2 V9 z/os
(in response to William Favero)
Also pay attention to the APARs associated with re-ordered row format.

Build2 phase elimination may also require changes to your reorg schedule.

______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | [login to unmask email]
For more information about Themis, visit www.themisinc.com


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Barbara Koenen
Sent: Friday, December 11, 2009 3:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V9 z/os

Watch your workfile allocations. It uses tons more 32K.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bob Jeandron
Sent: Friday, December 11, 2009 12:33 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V9 z/os

Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have
significantly been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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

Edward Long

Re: DB2 V9 z/os
(in response to David Simpson)
One other caution I would offer is to be very aware of access path changes.
In our recent user group meetings here in sunny New England several attendees noted they had seen - to them  signficant - changes, not all for the better.
I remember the ancient, (1980), proverb, one aw crap wipes out all previous atta boys.
Same applies here, if one access path regresses in a material way, no one will remember that 10 improved.
Moral of story, test access paths and performance across the v8 v9 boundary.
Edward Long




________________________________
From: Willie Favero <[login to unmask email]>
To: [login to unmask email]
Sent: Fri, December 11, 2009 5:17:20 PM
Subject: Re: [DB2-L] DB2 V9 z/os

If you have storage concerns, the good news, IMHO, is that DB2 9 has automatic warning message to alert of some storage conditions.  I blogged it last week... 

http://it.toolbox.com/blogs/db2zos/look-out-youre-running-out-of-storage-35437

Willie

Bob Jeandron wrote:
Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
>anything bit your shop)?
>
>.....Heard from somewhere, that that the memory management of V9 is not as
>forgiving as V8, anyone know what that means? Ie. may get hard crashes if
>not careful with memory alocations, more so than in V8.
>
>Also, found that DSNTINST calculated values for EDM sizes have
>significantly been reduced. In Particular:
>EDM STATEMENT CACHE
>EDM DBD CACHE
>
>And the
>EDM SKELETON POOL SIZE seems small as well.
>
>Any comments are greatly appreciated.
>
>_____________________________________________________________________
>
>* 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
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos
Houston, TX, USA

________________________________

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

Cathy Taddei

Re: DB2 V9 z/os
(in response to Edward Long)
I kept increasing my 32K work space until it was the same size as the 4K space. We had a few headaches with RRF because we use CA's PFR to recover from prod to test, and if one is in RRF and the other isn't, recover won't work. We also found a lot more stuff being put into advisory reorg status from simple things like adding columns. We reorg a lot more often than we used to.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David Simpson
Sent: Friday, December 11, 2009 2:28 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V9 z/os

Also pay attention to the APARs associated with re-ordered row format.

Build2 phase elimination may also require changes to your reorg schedule.

______________________________________________________________________________
David Simpson | Senior Technical Advisor | Themis Education
123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | [login to unmask email]
For more information about Themis, visit www.themisinc.com


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Barbara Koenen
Sent: Friday, December 11, 2009 3:30 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 V9 z/os

Watch your workfile allocations. It uses tons more 32K.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bob Jeandron
Sent: Friday, December 11, 2009 12:33 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 V9 z/os

Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have
significantly been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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

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

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

Leslie

Re: DB2 V9 z/os
(in response to Cathy Taddei)
Hi Bob

- sort works config is super important (have apar / doc on this if you need
it) - ensure 32K files have cisize of 32k too, get ready for 7 and 8
messages in mstr, and the odd 84, also convert to segmented as soon as poss
using the supplied rexx (segsize 16 default), we have seen a quirk where all
use of the tempdb ends up on one vsam file and a stop/start of the db is
needed to free it up. As we have not taken dumps yet (long story) when we
see this we have nothing to give the labs problem seen 3 times now - again
don't ask why no dumps :-(
- get the zparm correct for EDM pool and SKEL - have some SQL which sort of
helps calculate based on stats from a history db (like pm/pe/xe)
- get currrent on maintenance ( e.g ptfs out there for OPTHINTs which you
must get on (recent ones) if you use OTPHINTs, incorrouts etc
- review the incorrout apar regularly (will supply when I find it on my work
laptop)
- collect and explain dynamic SQL so you have an access path (good one) at
DB2 8 - or use a product to do it
- memory management is fine
- 3/4/5 Rs important (Runstats, Reorg, Runstats, Rebind, download OSC and
use it. But OSC is not the only thing to get you out of trouble - know how
to fix SQL .. Surprising how many people do not know what to do with SQL.
I'm no expert but have learnt a lot from the likes of Terry P and John C
(system) over the years.
- you do not say if you are datasharing - type 3 locking I am told is a
great move forward (like type 2 was)
- DIS UTIL (forget fix number but can supply) was blowing up a week or so
back.
- do you use CTE hints? If you do take care as they can cause DB2 99 to dump
- few people use them for that very reason before people ask me about them.
- Some ptfs out there for OPTHINTs which you must get on (recent ones) if
you use OTPHINTS

DB2 9 is not all bad, it is fine, it just comes with the odd quirk here and
there.

Personally having seen 100s of them in now I'm happy with DB2 9.

Not exhaustive but a quick brain dump on a Saturday night, email me direct
for some more info on Monday.

Leslie

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bob Jeandron
Sent: 11 December 2009 18:33
To: [login to unmask email]
Subject: [DB2-L] DB2 V9 z/os

Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
anything bit your shop)?

.....Heard from somewhere, that that the memory management of V9 is not as
forgiving as V8, anyone know what that means? Ie. may get hard crashes if
not careful with memory alocations, more so than in V8.

Also, found that DSNTINST calculated values for EDM sizes have significantly
been reduced. In Particular:
EDM STATEMENT CACHE
EDM DBD CACHE

And the
EDM SKELETON POOL SIZE seems small as well.

Any comments are greatly appreciated.

_____________________________________________________________________

* 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 No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.709 / Virus Database: 270.14.102/2556 - Release Date: 12/11/09
10:06:00

_____________________________________________________________________

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

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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

Robert Catterall

Re: DB2 V9 z/os
(in response to Leslie)
Do you use SQL procedures (stored procedures for which the source is
included in the CREATE PROCEDURE statement)? If so, be aware of a change in
the way that DB2 V9 treats an unqualified variable or parameter name in such
a procedure, versus the way this is handled in a DB2 V8 environment (a
parameter name can be qualified with the associated stored procedure name, a
variable can be qualified with the label of the compound statement in which
it was declared, and a column name can be qualified by the name of the table
of which its a part). You might have, for example, an unqualified variable
name in a SQL procedure that's the same as the name of a column of a table
referenced by the stored procedure.

In a V8 environment, DB2 first checks to see if an unqualified name is that
of a variable declared in the SQL procedure (if it isn't, DB2 then checks to
see of it's the name of one of the SQL procedure's parameters, and if it's
not, it's assumed to be a column name).

In a V9 environment, DB2 first checks to see if an unqualified name in a SQL
procedure is the name of a column in a table (at the local server)
referenced by SQL procedure.

Because of this change (V8 first checks to see if an unqualified name is
that of a variable, while V9 will first check to see if the unqualified name
is that of a column), you could get unexpected results from a SQL procedure
going from V8 to V9 if a variable name (unqualified) is the same as a column
name (unqualified). I heard from a person who, as part of a migration to V9,
had to change variable names in over 200 SQL procedures to ensure that they
were not equal to column names. He did this by prefixing the variable names
with a "v". My personal preference regarding variable naming conventions is
very close to that: I like prefixing variable names with "v_".

Robert


On Fri, Dec 11, 2009 at 1:32 PM, Bob Jeandron <[login to unmask email]> wrote:

> Migrating to V9 fairly soon, are there any gotchas to be aware of (what, if
> anything bit your shop)?
>
> .....Heard from somewhere, that that the memory management of V9 is not as
> forgiving as V8, anyone know what that means? Ie. may get hard crashes if
> not careful with memory alocations, more so than in V8.
>
> Also, found that DSNTINST calculated values for EDM sizes have
> significantly been reduced. In Particular:
> EDM STATEMENT CACHE
> EDM DBD CACHE
>
> And the
> EDM SKELETON POOL SIZE seems small as well.
>
> Any comments are greatly appreciated.
>
> _____________________________________________________________________
>
> * 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
>



--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com

_____________________________________________________________________

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

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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