Running REORG on Partitions Concurrently if NPI

Barbara Nigh

Running REORG on Partitions Concurrently if NPI
I would like to split a REORG utility which reorgs a large tablespace by
part into two jobs to save elapsed time but am concerned about the NPI. Is
it possible to run two REORG jobs concurrently against a partitioned
tablespace it there is an NPI?

Barbara J Nigh
CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS)
1441 Schilling Place
Salinas, CA 93901
______________________________________________________

Phone. 831 754 1400 2048
Fax. 831-759-7073
Mobile. 831-776-6194 Pager [login to unmask email]
Email. [login to unmask email]
Internet. http://www.hsbc.com
______________________________________________________


-----------------------------------------
******************************************************************
This E-mail is confidential. It may also be legally privileged. If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Donald E Bufford

Re: Running REORG on Partitions Concurrently if NPI
(in response to Barbara Nigh)
I ran two online reorgs (SHRLEVEL CHANGE) yesterday on the same
partitioned tablespace with one NPI.


Donald Bufford
Database Administrator
Lockheed Martin
410-496-9550




________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
Sent: Tuesday, January 19, 2010 1:29 PM
To: [login to unmask email]
Subject: [DB2-L] Running REORG on Partitions Concurrently if NPI



I would like to split a REORG utility which reorgs a large
tablespace by part into two jobs to save elapsed time but am concerned
about the NPI. Is it possible to run two REORG jobs concurrently
against a partitioned tablespace it there is an NPI?

Barbara J Nigh
CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS)
1441 Schilling Place
Salinas, CA 93901
______________________________________________________

Phone. 831 754 1400 2048
Fax. 831-759-7073
Mobile. 831-776-6194 Pager [login to unmask email]
Email. [login to unmask email]
<mailto:[login to unmask email]>
Internet. http://www.hsbc.com < http://www.hsbc.com/ >
______________________________________________________



________________________________





******************************************************************
This E-mail is confidential. It may also be legally privileged.
If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely,
secure,
error or virus-free. The sender does not accept liability for
any
errors or omissions.

******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!


________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
If you are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Steen Rasmussen

Re: Running REORG on Partitions Concurrently if NPI
(in response to Donald E Bufford)
Hi Don, are the columns in the NPI a subset of the partitioning scheme ?



Steen Rasmussen
CA





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bufford,
Donald E.
Sent: Tuesday, January 19, 2010 1:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Running REORG on Partitions Concurrently if NPI



I ran two online reorgs (SHRLEVEL CHANGE) yesterday on the same
partitioned tablespace with one NPI.



Donald Bufford
Database Administrator
Lockheed Martin
410-496-9550





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
Sent: Tuesday, January 19, 2010 1:29 PM
To: [login to unmask email]
Subject: [DB2-L] Running REORG on Partitions Concurrently if NPI


I would like to split a REORG utility which reorgs a large
tablespace by part into two jobs to save elapsed time but am concerned
about the NPI. Is it possible to run two REORG jobs concurrently
against a partitioned tablespace it there is an NPI?

Barbara J Nigh
CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS)
1441 Schilling Place
Salinas, CA 93901

______________________________________________________

Phone. 831 754 1400 2048
Fax. 831-759-7073
Mobile. 831-776-6194 Pager [login to unmask email]
Email. [login to unmask email]
<mailto:[login to unmask email]>
Internet. http://www.hsbc.com < http://www.hsbc.com/ >

______________________________________________________



________________________________


******************************************************************
This E-mail is confidential. It may also be legally privileged.
If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely,
secure,
error or virus-free. The sender does not accept liability for
any
errors or omissions.

******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!



________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
If you are not already an IDUG member, please register here.
< http://www.idug.org/register >



________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Donald E Bufford

Re: Running REORG on Partitions Concurrently if NPI
(in response to Steen Rasmussen)
Steen,

The NPI is a unique index for the table's primary key and couldn't be
explicitly dropped. Three other NPI's were dropped and rebuilt after the
reorgs completed. The tablespace is partitioned by another column that
isn't part of the primary key.


Donald Bufford
Database Administrator
Lockheed Martin
410-496-9550




________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
Rasmussen, Steen
Sent: Tuesday, January 19, 2010 2:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Running REORG on Partitions Concurrently if
NPI



Hi Don, are the columns in the NPI a subset of the partitioning
scheme ?



Steen Rasmussen
CA





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
Bufford, Donald E.
Sent: Tuesday, January 19, 2010 1:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Running REORG on Partitions Concurrently if
NPI



I ran two online reorgs (SHRLEVEL CHANGE) yesterday on the same
partitioned tablespace with one NPI.



Donald Bufford
Database Administrator
Lockheed Martin
410-496-9550





________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf
Of [login to unmask email]
Sent: Tuesday, January 19, 2010 1:29 PM
To: [login to unmask email]
Subject: [DB2-L] Running REORG on Partitions
Concurrently if NPI


I would like to split a REORG utility which reorgs a
large tablespace by part into two jobs to save elapsed time but am
concerned about the NPI. Is it possible to run two REORG jobs
concurrently against a partitioned tablespace it there is an NPI?

Barbara J Nigh
CONSULTANT DATABASE MGMT | HSBC Technology Services
(HTS)
1441 Schilling Place
Salinas, CA 93901

______________________________________________________

Phone. 831 754 1400 2048
Fax. 831-759-7073
Mobile. 831-776-6194 Pager [login to unmask email]
Email. [login to unmask email]
<mailto:[login to unmask email]>
Internet. http://www.hsbc.com < http://www.hsbc.com/ >

______________________________________________________



________________________________


******************************************************************
This E-mail is confidential. It may also be legally
privileged. If
you are not the addressee you may not copy, forward,
disclose or
use any part of it. If you have received this message in
error,
please delete it and all copies from your system and
notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be
timely, secure,
error or virus-free. The sender does not accept
liability for any
errors or omissions.

******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!



________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership
in IDUG. If you are not already an IDUG member, please register here.
< http://www.idug.org/register >



________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
If you are not already an IDUG member, please register here.
< http://www.idug.org/register >


________________________________

IDUG - The Worldwide DB2 User Community!
< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG.
If you are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L