V7 z/OS, any trick to convert from non-large TS to large TS?

[login to unmask email]

V7 z/OS, any trick to convert from non-large TS to large TS?
Hi, DB2 gurus

This is a DB2 V7 on z/OS 1.4 site. Some partitioned tablesapces created
long time ago are within NON-LARGE format, so it's impossible to beyond 2G
dataset size limit, which has made a lot of troubles.
The only solution I know is to drop and re-create the whole tablesapce,
which means availability impact,package rebind, and lots of data
migration. Oops, sounds like nightmare!
So, I'm very interested in any tricks, what can convert this kind of
NON-LARGE tablespace to LARGE format(4G is enough for me), online !

Thanks!





---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to hhuang@DCCSH.ICBC.COM.CN)
Hi

you cannot ALTER from not-large to large (or better modify DSSIZE, as
recommended, via ALTER) , you've to drop and recreate (or to clone the
tablespace renaming the table) the pageset.

But before be sure that your SMS guy enabled these pageset to EA so they
can go beyond 2 Gb (and be current with SMS level) . I assume that for
these tablespace you enabled compression to limit the used space.

HTH

Max Scarpa

Certified 'Merry Xmas and a New Happy Year 2006 to all DB2-Listerz'

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Janißen

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to Max Scarpa)
Hi Max

It is not true, that a pageset of a partitioned tablespace has be EA, if it
grows beyond 2G. You have to look for EA, if it is bigger than 4G.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to Walter Janißen)
True, but for NUMPARTS from 1 to 16 and from 65 to 254 (if I remember
well), in the range between 17-31 and 33-64 it's different (2 Gb and 1 Gb
for V6, have to check)

Cheers

Max

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Janißen

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to Max Scarpa)
Yes, you aer right.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to Walter Janißen)
Thanks, Max and Walter

So there is no tricks or so-called undocumented skills to convert this
kind of TS. I think the most reason
is that LARGE TS using 5 bit RID while NON-LARGE is 4, right?
OK, I have to face to the data migration plan. No SMS EA, No tricks, and
we are running V7. For the future
plan, I would use DSSIZE parameter...

Anyway, thanks!







---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Trovijo Jr

Re: V7 z/OS, any trick to convert from non-large TS to large TS?
(in response to hhuang@DCCSH.ICBC.COM.CN)
I´ve lost the beginning of this thread, and this was probably mentioned,
but it happened to me once changing a partitioned tablespace to large, I
didn´t pay
attention to the partitioning index accepting NULLs, which caused several
rows to be deleted from the tablespace, because null indicator is
physically stored as x'FF' on the left side of the column which makes it
bigger than any limit you can specify to the last partition. This is not
enforced for non-large ts, but the behavior changes for large ts.

HTH,
Walter Trovijo.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm