DB2 z/os V9 workfiles

Bob Jeandron

DB2 z/os V9 workfiles
Trying to get a handle on what to do for V9 workfiles. It seems from a
previous post (thanks) that at least additional 32K spaces are
required/strongly suggested for V9.1.
What is the recommended procedure for converting to the new WorkFile
Tbsps? Is it recommended to convert?
Drop old 4k and 32k tbsps and delete user defined files then recreate using
the new Stogroup defined tbsps (DSNTWFG)?

Keep old 4k and 32k tbsps and just create additional 32k in sg tbsps?

Are there any benefits to dropping the old and using the new workfile tbsps?

What are the best practices here?

Thanks in advance.

_____________________________________________________________________

* 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

Roy Boxwell

Re: DB2 z/os V9 workfiles
(in response to Bob Jeandron)
lots of good stuff in the archives and you will need two ts's with extents
allowed. The last ROT I heard was "flip the numbers". Allocate as many
32k's as you had 4Ks but at 8x the space. reduce the 4ks in size and qty -
monitor usage and "adjust where needed"...better than "it depends" but not
a lot better!!!



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Bob Jeandron <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
14.12.2009 15:53
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
[DB2-L] DB2 z/os V9 workfiles






Trying to get a handle on what to do for V9 workfiles. It seems from a
previous post (thanks) that at least additional 32K spaces are
required/strongly suggested for V9.1.
What is the recommended procedure for converting to the new WorkFile
Tbsps? Is it recommended to convert?
Drop old 4k and 32k tbsps and delete user defined files then recreate
using
the new Stogroup defined tbsps (DSNTWFG)?

Keep old 4k and 32k tbsps and just create additional 32k in sg tbsps?

Are there any benefits to dropping the old and using the new workfile
tbsps?

What are the best practices here?

Thanks in advance.

_____________________________________________________________________

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

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

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


_____________________________________________________________________

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

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

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

Phil Grainger

Re: DB2 z/os V9 workfiles
(in response to Roy Boxwell)
With regard to Roys “with extents allowed” comment, this sort of depends on
what you are using your temp table spaces for



Normal practice is NOT to have secondary allocations for SORT work files,
but to HAVE secondary allocations for TEMP work files (such as DGTTs and
static scrollable cursors)



Of course, now that both of these activities are contained within the sort
work database (as opposed to having a separate TEMP database a la DB2 V8),
you can’t both HAVE and NOT HAVE secondaries at the same time



Step forward PK70060 (and thanks to John Campbell for drawing my attention
to this one at European IDUG in Rome)



With this APAR:

- Work files with SECQTY = 0 will be preferred for sort work data

- Work files with SECQTY > 0 will be preferred for DGTTs and static
scrollable cursors



Phil Grainger

Grainger Database Solutions Ltd

_____

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Boxwell
Sent: 14 December 2009 15:31
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/os V9 workfiles




lots of good stuff in the archives and you will need two ts's with extents
allowed. The last ROT I heard was "flip the numbers". Allocate as many 32k's
as you had 4Ks but at 8x the space. reduce the 4ks in size and qty - monitor
usage and "adjust where needed"...better than "it depends" but not a lot
better!!!



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert





Bob Jeandron <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>

14.12.2009 15:53


Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An

[login to unmask email]


Kopie




Thema

[DB2-L] DB2 z/os V9 workfiles











Trying to get a handle on what to do for V9 workfiles. It seems from a
previous post (thanks) that at least additional 32K spaces are
required/strongly suggested for V9.1.
What is the recommended procedure for converting to the new WorkFile
Tbsps? Is it recommended to convert?
Drop old 4k and 32k tbsps and delete user defined files then recreate using
the new Stogroup defined tbsps (DSNTWFG)?

Keep old 4k and 32k tbsps and just create additional 32k in sg tbsps?

Are there any benefits to dropping the old and using the new workfile tbsps?

What are the best practices here?

Thanks in advance.

_____________________________________________________________________

* 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



_____

< http://www.idug.org/db2-north-america-conference/index.html > IDUG - The
Worldwide DB2 User Community!

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are
not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* 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