LOAD Partition parallelism in V7

Ken Michalik

LOAD Partition parallelism in V7
Dear List:

I am attempting to run 2 parallel jobs loading different partitions of the
same table. According to the Utility Guide, it's better to have 2 LOADs
running rather than 1 LOAD using partition parallelism with when there are
no NPIs.

LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN DDIN

All the partitions of the table go into UTUT restrictive state when a load
is running, and only 1 load can be running simultaneously. The second load
gets an DSNU180I incompatibility error.This goes against everything I've
read...the partitions should operate independently.

Any help you could provide would be appreciated.

Thanks in advance.

Ken Michalik
Kraft Foods

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

Chris Tee

Re: LOAD Partition parallelism in V7
(in response to Ken Michalik)
Have you got SHRLEVEL CHANGE?

-----Original Message-----
From: Michalik, Ken [mailto:[login to unmask email]
Sent: Thursday, January 06, 2005 3:50 PM
To: [login to unmask email]
Subject: [DB2-L] LOAD Partition parallelism in V7



Dear List:

I am attempting to run 2 parallel jobs loading different partitions of the
same table. According to the Utility Guide, it's better to have 2 LOADs
running rather than 1 LOAD using partition parallelism with when there are
no NPIs.

LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN DDIN

All the partitions of the table go into UTUT restrictive state when a load
is running, and only 1 load can be running simultaneously. The second load
gets an DSNU180I incompatibility error.This goes against everything I've
read...the partitions should operate independently.

Any help you could provide would be appreciated.

Thanks in advance.

Ken Michalik
Kraft Foods

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


**********************************************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony United Kingdom Limited.
(05)
**********************************************************************************************

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

Larry Jardine

Re: LOAD Partition parallelism in V7
(in response to Chris Tee)
Remove the "RESUME YES" -- that is what is putting ALL partitions in UT
status. Do you want PART xx REPLACE?

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Michalik, Ken
Sent: Thursday, January 06, 2005 10:50 AM
To: [login to unmask email]
Subject: [DB2-L] LOAD Partition parallelism in V7

Dear List:

I am attempting to run 2 parallel jobs loading different partitions of
the
same table. According to the Utility Guide, it's better to have 2 LOADs
running rather than 1 LOAD using partition parallelism with when there
are
no NPIs.

LOAD DATA LOG NO RESUME YES INTO TABLE CREATOR.TBNAME PART xx INDDN
DDIN

All the partitions of the table go into UTUT restrictive state when a
load
is running, and only 1 load can be running simultaneously. The second
load
gets an DSNU180I incompatibility error.This goes against everything I've
read...the partitions should operate independently.

Any help you could provide would be appreciated.

Thanks in advance.

Ken Michalik
Kraft Foods

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

-----------------------------------------
This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender by
reply e-mail and then delete this e-mail immediately. Thank you. Aetna


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