4GB partition

Sanjeev (CTS) S

4GB partition
1) Change the UNION ALL query to FULL OUTER JOIN with value clause.
2) Wait for V7 for UNION ALL in view to come.(Raised in end 1999 or begining
2000). If archive is there, check out Richard Yevich's reply of my mail)
3) Compress the TS as suggested by Dr. Michael.

For your query :
Select value(a.col1,b.col1), value(a.col2,b.col2) ,
value(a.col3,b.col3) from
( ( Select col1, col2, col3 from oldtab a where partnum <> 2)
as v1 full outer join
newtab b
on "all conditions" like a.col1 = b.col1 ...........etc )
v2;

Please check the syntax.

HTH
Regards,
Sanjeev

> -----Original Message-----
> From: [login to unmask email] [SMTP:[login to unmask email]
> Sent: Friday, December 29, 2000 6:02 PM
> To: [login to unmask email]
> Subject: Re: 4GB partition
>
> 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
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------