Segmented Tablespace 4 gig, v7?

Hayden Jones

Segmented Tablespace 4 gig, v7?
Looking at the DB2-L archives it seems like this subject has been pretty
well beaten to death. But I haven't been able to find an answer in there
to this question.

If you have a 3 gig segmented tablespace in version 5 (two datasets) and
you migrate to version 7, can you then fit it into a single dataset by
simply reorging it?

OS/390 2.10
SMS managed
Stogroups
volumes( "*" )


Hayden Jones

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

Philip Sevetson

Re: Segmented Tablespace 4 gig, v7?
(in response to Hayden Jones)
DSSIZE is a clause of CREATE, but not of ALTER. If you can figure out a
way to change the DSSIZE without dropping the tablespace, unload a copy of
the data (just to be safe) and go for it.

Personally, I think the syntax is pretty conclusive evidence that you
can't get there from here.

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]






[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/19/2004 02:29 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: [DB2-L] Segmented Tablespace 4 gig, v7?


Looking at the DB2-L archives it seems like this subject has been pretty
well beaten to death. But I haven't been able to find an answer in there
to this question.

If you have a 3 gig segmented tablespace in version 5 (two datasets) and
you migrate to version 7, can you then fit it into a single dataset by
simply reorging it?

OS/390 2.10
SMS managed
Stogroups
volumes( "*" )


Hayden Jones

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



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