ALTER PARTITION ROTATE FIRST TO LAST - V8

Sally Mir

ALTER PARTITION ROTATE FIRST TO LAST - V8

December 10, 2004 08:32 AM

Does anyone have any information on what effect the new V8
statement ALTER
PARTITION ROTATE FIRST TO LAST would have on any NPIs? I can see
that it
would be a breeze with DPSIs, but if we have an old-fashioned NPI
(I guess
now it would be called a NPSI) I'd like to know what happens in
detail when
this statement is used.

Phil Grainger

If you haven't "arranged" for Part 1 to be empty when you do the
rotate, it will delete the rows one-by-one. So, the normal
recomendation is to do a LOAD REPLACE PART 1 with a dummy uinput
file, but if you have NPIs, you will then get a BUILD2 phase whilst
DB2 sorts out the NPI....

Does anyone have any information on what effect the new V8
statement ALTER
PARTITION ROTATE FIRST TO LAST would have on any NPIs? I can see
that it
would be a breeze with DPSIs, but if we have an old-fashioned NPI
(I guess
now it would be called a NPSI) I'd like to know what happens in
detail when
this statement is used.

William Favero

Other than having to delete all the corresponding rows from the
NPSI,
which could be time consuming, none.

The Version 8 Redbook "SG24-6079 - DB2 V8 for z/OS - Everything You
Ever
Wanted to Know and More" on around page 171 has a very nice
discussion
on using this command, including some of the "gotchas" and how to
get
around them.

Willie

[login to unmask email] wrote:

>Does anyone have any information on what effect the new V8
statement ALTER
>PARTITION ROTATE FIRST TO LAST would have on any NPIs? I can
see that it
>would be a breeze with DPSIs, but if we have an old-fashioned
NPI (I guess
>now it would be called a NPSI) I'd like to know what happens in
detail when
>this statement is used.
>
>Thanks,
>
>
>Sally A. Mir, AVP
>IBM Certified Database Administrator
>DB2 Universal Database V8.1 for Z/OS
>(336) 773-4011
>
>---------------------------------------------------------------------------------
>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
>
>
>

Does anyone have any information on what effect the new V8
statement ALTER PARTITION ROTATE FIRST TO LAST would have on any
NPIs? I
can see that it would be a breeze with DPSIs, but if we have an
old-fashioned NPI (I guess now it would be called a NPSI) I'd
like
to know what happens in detail when this statement is used.