[DB2-L] DB2 TS with Extended definition

Walter Janißen

[DB2-L] DB2 TS with Extended definition
Hi Nick

We only have two tablespace defined with DSSIZE 8G, but we haven't experienced any problems, when we migrated two years or so to V8 NFM.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40198 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrats: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Nicola Nur
Gesendet: Donnerstag, 11. Dezember 2008 20:49
An: [login to unmask email]
Betreff: Re: [DB2-L] DB2 TS with Extended definition

Hi colleagues

Does anybody have experience or think there will be an issue for us when migration from DB2 z/OS v7 to v8 because of the following situation:
1) We have in production several compressed tablespaces that are defined as DSSIZE 64G. Our DFSMS level is 1.9.0.

Is there any issue that I should be aware of or watch for or test or worry about it during the v8 migration because of this definition ?

thanks for your help in advance.

Nick Nur





__________________________________________________________________
Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA * ______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Roger Miller

Re: DB2 TS with Extended definition
(in response to Walter Janißen)
That's not an area where we have seen any problems. If you think of the
items where your shop is unique, those are great items to check. If you set
zparms or have processes that the books indicate don't work. If you use
unique products and have settings like no one else in the world, then only you
can test them. If your DBAs and application programmers have chosen
options no one else has thought or heard of, then that's what you need to
test. If this is the most unique item on your list, then the shop tastes pretty
vanilla to me. Migrating half a year after end of service is pretty late, but
you're not alone there.

Almost every customer has large compressed table spaces. Using a large
DSSIZE is fairly common. Since you have used 64GB, then you don't get to
increase the number of partitions much if you have 4K pages.

Roger Miller, DB2 for z/OS

On Thu, 11 Dec 2008 11:49:16 -0800, Nicola Nur <[login to unmask email]>
wrote:

>Hi colleagues
>
>Does anybody have experience or think there will be an issue for us when
migration from DB2 z/OS v7 to v8 because of the following situation:
>1) We have in production several compressed tablespaces that are defined
as DSSIZE 64G. Our DFSMS level is 1.9.0.
>
>Is there any issue that I should be aware of or watch for or test or worry
about it during the v8 migration because of this definition ?
>
>thanks for your help in advance.
>
>Nick Nur
>
>
>
>
>
>
__________________________________________________________________
>Connect with friends from any web browser - no download required. Try the
new Yahoo! Canada Messenger for the Web BETA at
http://ca.messenger.yahoo.com/webmessengerpromo.php
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms