ALTER PARTITION ROTATE FIRST TO LAST - V8

Sally Mir

ALTER PARTITION ROTATE FIRST TO LAST - V8
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

Phil Grainger

Re: ALTER PARTITION ROTATE FIRST TO LAST - V8
(in response to Sally Mir)
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....

Phil Grainger

-----Original Message-----
From: DB2 Data Base Discussion List on behalf of [login to unmask email]
Sent: Fri 10/12/2004 14:32
To: [login to unmask email]
Cc:
Subject: ALTER PARTITION ROTATE FIRST TO LAST - V8



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



William Favero

Re: ALTER PARTITION ROTATE FIRST TO LAST - V8
(in response to Phil Grainger)
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
>
>
>

--
Willie
http://www.Red-Corvettes.com
62 Maroon, 98 Carmine, 99 MagRed (MTI 422), 03 Anniversary
I just love dark red.. LOL

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

Isaac Yassin

Re: ALTER PARTITION ROTATE FIRST TO LAST - V8
(in response to William Favero)
The only work-around is not to have the NPI while you do it :-( (DROP/CREATE comes to mind...)

Isaac Yassin




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Friday, December 10, 2004 4:32 PM
To: [login to unmask email]
Subject: ALTER PARTITION ROTATE FIRST TO LAST - V8


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

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