4GB partition

[login to unmask email]

4GB partition
Friends,
Here is my problem. A partition of a V5.1 tablespace is going to exceed
4gb and I have no time to re-engineer. I thought I could create a new
segmented TS to replace the partition in quesstion and create a new view to
Union the new table with a select subset of the existing Table such as..

Select col1, col2, col3 from oldtab where partnum <> 2
Union All col1, col2, col3 from newtab;

This resulted in a -154 sqlcode, as a view can't contain a union.

Does anyone have any suggestions as to how I can create a view that will
return my desired result set ( all of the new table, some rows of the old)
OR a quick workaround of my 4gb problem?

Thanks


Kenneth M. Kane



Michael Ebert

Re: 4GB partition
(in response to kkane@PAINEWEBBER.COM)
Compress the TS partition, if it isn't already....

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany


From: [login to unmask email] on 29/12/2000 11:34 GMT

Please respond to DB2 Data Base Discussion List <[login to unmask email]>
|--------->
| |
|--------->
>--------------------------------------------------------------------------->
| |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|
|--------->
|To: |
|--------->
>--------------------------------------------------------------------------->
|[login to unmask email] |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
| |
>-------------------------------------------|
|--------->
|cc: |
|--------->
>--------------------------------------------------------------------------->
| (bcc: Michael Ebert/MUC/AMADEUS) |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
| |
>-------------------------------------------|
|--------->
| |
|--------->
>--------------------------------------------------------------------------->
| |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|
|--------->
|Subject: |
|--------->
>--------------------------------------------------------------------------->
|4GB partition |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|



Friends,
Here is my problem. A partition of a V5.1 tablespace is going to exceed
4gb and I have no time to re-engineer. I thought I could create a new
segmented TS to replace the partition in quesstion and create a new view to
Union the new table with a select subset of the existing Table such as..

Select col1, col2, col3 from oldtab where partnum <> 2
Union All col1, col2, col3 from newtab;

This resulted in a -154 sqlcode, as a view can't contain a union.

Does anyone have any suggestions as to how I can create a view that will
return my desired result set ( all of the new table, some rows of the old)
OR a quick workaround of my 4gb problem?

Thanks

Kenneth M. Kane



Alan Smith

4GB partition
(in response to Michael Ebert)
How about turning on compression?

Alan Smith


> Date: Fri, 29 Dec 2000 06:34:49 -0500
> From: [login to unmask email]
> Subject: 4GB partition
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0010_01C07162.57979720
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Friends,
> Here is my problem. A partition of a V5.1 tablespace is going to exceed
> 4gb and I have no time to re-engineer. I thought I could create a new
> segmented TS to replace the partition in quesstion and create a new view to
> Union the new table with a select subset of the existing Table such as..
>
> Select col1, col2, col3 from oldtab where partnum <> 2
> Union All col1, col2, col3 from newtab;
>
> This resulted in a -154 sqlcode, as a view can't contain a union.
>
> Does anyone have any suggestions as to how I can create a view that will
> return my desired result set ( all of the new table, some rows of the old)
> OR a quick workaround of my 4gb problem?
>
> Thanks
>
>
> Kenneth M. Kane
>