Loads on Separate Partitions (Reply)

Mike Ockenfels

Loads on Separate Partitions (Reply)
Richard,

I checked my jcl and which is very similar with one noteable exception; no
"resume(yes)". Take that off and try it again.

Mike Ockenfels
DB2 DBA
Worldcom






BARCLAY RICHARD
<[login to unmask email] To: [login to unmask email]
SBANK.COM> cc: (bcc: Mike Ockenfels/CDR/BSM/MCI)
Subject: Loads on Separate Partitions
01/11/02 07:55 AM
Please respond to DB2
Data Base Discussion
List







Hi,

I'm having some difficulty running two load jobs on separate partitions of
a tablespace. The load cards are as follows.

LOAD INDDN SYSREC RESUME YES
LOG NO
ERRDDN SYSERR
WORKDDN(SYSUT1,SORTOUT)
INTO TABLE table.name PART 10 REPLACE
(table/data layout etc .......)

Each time I run them together one job fails with.....

DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
UTILID = LOAD.PTnn, OBJECT = dbname.tsname

At first I thought it was down to the NPI's (though I didn't understand
why) but I have dropped the NPI's and I still get the same message.

I've also tried it with BMC's Load Plus (rather than think about it too
much!) and it still fails when there are NPI's defined,
(BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID
='abc.zyx' )
But, (and here's the spooky part) it works using BMC load when you drop the
NPI's

Please tell me (while I still have some hair) that I have some crazy
installation parm set wrong cos then I can pass it to someone else.

Thanks.


Richard Barclay
database administrator
Fortis Bank
Application Design / 1GA3F
Tel. +32 (0)2 228 3621
mailto: [login to unmask email]


This email and any attached files are confidential and may be legally
privileged.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this communication
is strictly prohibited.
If you have received this transmission in error please notify the sender
immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or
incomplete, or contain viruses.
The sender therefore is in no way liable for any errors or omissions in the
content of this message, which may arise as a result of email transmission.
If verification is required, please request a hard copy.








Larry Jardine

Re: Loads on Separate Partitions
(in response to Mike Ockenfels)
Get rid of the RESUME YES.

RESUME YES will add qualified data to other partitions, which it sounds like
you don't want to do.

-----Original Message-----
From: BARCLAY RICHARD [mailto:[login to unmask email]
Sent: Friday, January 11, 2002 8:55 AM
To: [login to unmask email]
Subject: Loads on Separate Partitions


Hi,

I'm having some difficulty running two load jobs on separate partitions of a
tablespace. The load cards are as follows.

LOAD INDDN SYSREC RESUME YES
LOG NO
ERRDDN SYSERR
WORKDDN(SYSUT1,SORTOUT)
INTO TABLE table.name PART 10 REPLACE
(table/data layout etc .......)

Each time I run them together one job fails with.....

DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
UTILID = LOAD.PTnn, OBJECT = dbname.tsname

At first I thought it was down to the NPI's (though I didn't understand why)
but I have dropped the NPI's and I still get the same message.

I've also tried it with BMC's Load Plus (rather than think about it too
much!) and it still fails when there are NPI's defined,
(BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID
='abc.zyx' )
But, (and here's the spooky part) it works using BMC load when you drop the
NPI's

Please tell me (while I still have some hair) that I have some crazy
installation parm set wrong cos then I can pass it to someone else.

Thanks.


Richard Barclay
database administrator
Fortis Bank
Application Design / 1GA3F
Tel. +32 (0)2 228 3621
mailto: [login to unmask email]


This email and any attached files are confidential and may be legally
privileged.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this communication
is strictly prohibited.
If you have received this transmission in error please notify the sender
immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.
The sender therefore is in no way liable for any errors or omissions in the
content of this message, which may arise as a result of email transmission.
If verification is required, please request a hard copy.








BARCLAY RICHARD

Re: Loads on Separate Partitions
(in response to Larry Jardine)
No. I let the BMC load default to SHRLEVEL NONE and it failed with the error I described. I tried with SHRLEVEL REFERENCE but its not allowed with LOAD RESUME YES.....PART nn REPLACE.

Regards

Richard Barclay

> -----Original Message-----
> From: Pearson, Eric L, [SMTP:[login to unmask email]
> Sent: vrijdag 11 januari 2002 15:44
> To: [login to unmask email]
> Subject: Re: Loads on Separate Partitions
>
> Do you have SHRLEVEL CHANGE specified on the LOAD?
>
> Regards,
> eric pearson
> NS ITO Database Support
>
>
> -----Original Message-----
> From: BARCLAY RICHARD [mailto:[login to unmask email]
> Sent: Friday, January 11, 2002 8:55 AM
> To: [login to unmask email]
> Subject: Loads on Separate Partitions
>
>
> Hi,
>
> I'm having some difficulty running two load jobs on separate partitions of a
> tablespace. The load cards are as follows.
>
> LOAD INDDN SYSREC RESUME YES
> LOG NO
> ERRDDN SYSERR
> WORKDDN(SYSUT1,SORTOUT)
> INTO TABLE table.name PART 10 REPLACE
> (table/data layout etc .......)
>
> Each time I run them together one job fails with.....
>
> DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
> UTILID = LOAD.PTnn, OBJECT = dbname.tsname
>
> At first I thought it was down to the NPI's (though I didn't understand why)
> but I have dropped the NPI's and I still get the same message.
>
> I've also tried it with BMC's Load Plus (rather than think about it too
> much!) and it still fails when there are NPI's defined,
> (BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID
> ='abc.zyx' )
> But, (and here's the spooky part) it works using BMC load when you drop the
> NPI's
>
> Please tell me (while I still have some hair) that I have some crazy
> installation parm set wrong cos then I can pass it to someone else.
>
> Thanks.
>
>
> Richard Barclay
> database administrator
> Fortis Bank
> Application Design / 1GA3F
> Tel. +32 (0)2 228 3621
> mailto: [login to unmask email]
>
>
> This email and any attached files are confidential and may be legally
> privileged.
> If you are not the intended recipient, any disclosure, reproduction,
> copying, distribution, or other dissemination or use of this communication
> is strictly prohibited.
> If you have received this transmission in error please notify the sender
> immediately and then delete this email.
> Email transmission cannot be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.
> The sender therefore is in no way liable for any errors or omissions in the
> content of this message, which may arise as a result of email transmission.
> If verification is required, please request a hard copy.
>
>
>
>
>
>
>
>

This email and any attached files are confidential and may be legally privileged.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this communication
is strictly prohibited.
If you have received this transmission in error please notify the sender
immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.
The sender therefore is in no way liable for any errors or omissions in the
content of this message, which may arise as a result of email transmission.
If verification is required, please request a hard copy.



Bill Brown

Re: Loads on Separate Partitions
(in response to Dil Pratheek)
Did you specify LOCKPART YES on the tablespace definition. This would enable selective partition locking and multiple loads can run concurently.
>
> From: BARCLAY RICHARD <[login to unmask email]>
> Date: 2002/01/11 Fri AM 08:55:05 EST
> To: [login to unmask email]
> Subject: Loads on Separate Partitions
>
> Hi,
>
> I'm having some difficulty running two load jobs on separate partitions of a tablespace. The load cards are as follows.
>
> LOAD INDDN SYSREC RESUME YES
> LOG NO
> ERRDDN SYSERR
> WORKDDN(SYSUT1,SORTOUT)
> INTO TABLE table.name PART 10 REPLACE
> (table/data layout etc .......)
>
> Each time I run them together one job fails with.....
>
> DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
> UTILID = LOAD.PTnn, OBJECT = dbname.tsname
>
> At first I thought it was down to the NPI's (though I didn't understand why) but I have dropped the NPI's and I still get the same message.
>
> I've also tried it with BMC's Load Plus (rather than think about it too much!) and it still fails when there are NPI's defined,
> (BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID ='abc.zyx' )
> But, (and here's the spooky part) it works using BMC load when you drop the NPI's
>
> Please tell me (while I still have some hair) that I have some crazy installation parm set wrong cos then I can pass it to someone else.
>
> Thanks.
>
>
> Richard Barclay
> database administrator
> Fortis Bank
> Application Design / 1GA3F
> Tel. +32 (0)2 228 3621
> mailto: [login to unmask email]
>
>
> This email and any attached files are confidential and may be legally privileged.
> If you are not the intended recipient, any disclosure, reproduction,
> copying, distribution, or other dissemination or use of this communication
> is strictly prohibited.
> If you have received this transmission in error please notify the sender
> immediately and then delete this email.
> Email transmission cannot be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.
> The sender therefore is in no way liable for any errors or omissions in the
> content of this message, which may arise as a result of email transmission.
> If verification is required, please request a hard copy.
>
>
>
>



Dil Pratheek

Re: Loads on Separate Partitions
(in response to BARCLAY RICHARD)
Hello -

Please take out the RESUME YES from before the INTO TABLE
portion.... When you are doing partitions ....You need specify these
options after the INTO TABLE only...!

If you specify RESUME YES the way you have coded(beofre the into
table section), it will lock up the NPI.

Eg: The below one replaces only part 10. If you put RESUME YES
instead of REPLACE it would append to the Part 10. None of the
partiions get affected.

LOAD INDDN SYSREC
LOG NO
ERRDDN SYSERR
WORKDDN(SYSUT1,SORTOUT)
INTO TABLE table.name PART 10 REPLACE
(table/data layout etc .......)

I was able to load the partitions in parallel. One thing I noticed was even though I had SORTKEYS specified in both the jobs, the parallel subtasks were initiated only for the first job
submitted. The second one did not initiate parallel subtasks. Has anyone else on this list come across such a situation?

Hope this helps
Cheers,
Dil



BARCLAY RICHARD wrote:

> Hi,
>
> I'm having some difficulty running two load jobs on separate partitions of a tablespace. The load cards are as follows.
>
> LOAD INDDN SYSREC RESUME YES
> LOG NO
> ERRDDN SYSERR
> WORKDDN(SYSUT1,SORTOUT)
> INTO TABLE table.name PART 10 REPLACE
> (table/data layout etc .......)
>
> Each time I run them together one job fails with.....
>
> DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
> UTILID = LOAD.PTnn, OBJECT = dbname.tsname
>
> At first I thought it was down to the NPI's (though I didn't understand why) but I have dropped the NPI's and I still get the same message.
>
> I've also tried it with BMC's Load Plus (rather than think about it too much!) and it still fails when there are NPI's defined,
> (BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID ='abc.zyx' )
> But, (and here's the spooky part) it works using BMC load when you drop the NPI's
>
> Please tell me (while I still have some hair) that I have some crazy installation parm set wrong cos then I can pass it to someone else.
>
> Thanks.
>
> Richard Barclay
> database administrator
> Fortis Bank
> Application Design / 1GA3F
> Tel. +32 (0)2 228 3621
> mailto: [login to unmask email]
>
> This email and any attached files are confidential and may be legally privileged.
> If you are not the intended recipient, any disclosure, reproduction,
> copying, distribution, or other dissemination or use of this communication
> is strictly prohibited.
> If you have received this transmission in error please notify the sender
> immediately and then delete this email.
> Email transmission cannot be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.
> The sender therefore is in no way liable for any errors or omissions in the
> content of this message, which may arise as a result of email transmission.
> If verification is required, please request a hard copy.
>
>
>



BARCLAY RICHARD

Re: Loads on Separate Partitions
(in response to Bill Brown)
Mike, Lawrence,

Bingo! That works great.... Many thanks.

regards

Richard


> -----Original Message-----
> From: Jardine, Lawrence J [SMTP:[login to unmask email]
> Sent: vrijdag 11 januari 2002 16:03
> To: [login to unmask email]
> Subject: Re: Loads on Separate Partitions
>
> Get rid of the RESUME YES.
>
> RESUME YES will add qualified data to other partitions, which it sounds like
> you don't want to do.
>
> -----Original Message-----
> From: BARCLAY RICHARD [mailto:[login to unmask email]
> Sent: Friday, January 11, 2002 8:55 AM
> To: [login to unmask email]
> Subject: Loads on Separate Partitions
>
>
> Hi,
>
> I'm having some difficulty running two load jobs on separate partitions of a
> tablespace. The load cards are as follows.
>
> LOAD INDDN SYSREC RESUME YES
> LOG NO
> ERRDDN SYSERR
> WORKDDN(SYSUT1,SORTOUT)
> INTO TABLE table.name PART 10 REPLACE
> (table/data layout etc .......)
>
> Each time I run them together one job fails with.....
>
> DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
> UTILID = LOAD.PTnn, OBJECT = dbname.tsname
>
> At first I thought it was down to the NPI's (though I didn't understand why)
> but I have dropped the NPI's and I still get the same message.
>
> I've also tried it with BMC's Load Plus (rather than think about it too
> much!) and it still fails when there are NPI's defined,
> (BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID
> ='abc.zyx' )
> But, (and here's the spooky part) it works using BMC load when you drop the
> NPI's
>
> Please tell me (while I still have some hair) that I have some crazy
> installation parm set wrong cos then I can pass it to someone else.
>
> Thanks.
>
>
> Richard Barclay
> database administrator
> Fortis Bank
> Application Design / 1GA3F
> Tel. +32 (0)2 228 3621
> mailto: [login to unmask email]
>
>
> This email and any attached files are confidential and may be legally
> privileged.
> If you are not the intended recipient, any disclosure, reproduction,
> copying, distribution, or other dissemination or use of this communication
> is strictly prohibited.
> If you have received this transmission in error please notify the sender
> immediately and then delete this email.
> Email transmission cannot be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.
> The sender therefore is in no way liable for any errors or omissions in the
> content of this message, which may arise as a result of email transmission.
> If verification is required, please request a hard copy.
>
>
>
>
>
>
>
>

This email and any attached files are confidential and may be legally privileged.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this communication
is strictly prohibited.
If you have received this transmission in error please notify the sender
immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.
The sender therefore is in no way liable for any errors or omissions in the
content of this message, which may arise as a result of email transmission.
If verification is required, please request a hard copy.



A. J. Zobjeck

Re: Loads on Separate Partitions
(in response to BARCLAY RICHARD)
call BMC 1-800-537-1813

-----Original Message-----
From: BARCLAY RICHARD [mailto:[login to unmask email]
Sent: Friday, January 11, 2002 9:09 AM
To: [login to unmask email]
Subject: Re: Loads on Separate Partitions


No. I let the BMC load default to SHRLEVEL NONE and it failed with the
error I described. I tried with SHRLEVEL REFERENCE but its not allowed with
LOAD RESUME YES.....PART nn REPLACE.

Regards

Richard Barclay

> -----Original Message-----
> From: Pearson, Eric L, [SMTP:[login to unmask email]
> Sent: vrijdag 11 januari 2002 15:44
> To: [login to unmask email]
> Subject: Re: Loads on Separate Partitions
>
> Do you have SHRLEVEL CHANGE specified on the LOAD?
>
> Regards,
> eric pearson
> NS ITO Database Support
>
>
> -----Original Message-----
> From: BARCLAY RICHARD [mailto:[login to unmask email]
> Sent: Friday, January 11, 2002 8:55 AM
> To: [login to unmask email]
> Subject: Loads on Separate Partitions
>
>
> Hi,
>
> I'm having some difficulty running two load jobs on separate partitions of
a
> tablespace. The load cards are as follows.
>
> LOAD INDDN SYSREC RESUME YES
> LOG NO
> ERRDDN SYSERR
> WORKDDN(SYSUT1,SORTOUT)
> INTO TABLE table.name PART 10 REPLACE
> (table/data layout etc .......)
>
> Each time I run them together one job fails with.....
>
> DSNU180I -DBD1 DSNUGUCC - UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
> UTILID = LOAD.PTnn, OBJECT = dbname.tsname
>
> At first I thought it was down to the NPI's (though I didn't understand
why)
> but I have dropped the NPI's and I still get the same message.
>
> I've also tried it with BMC's Load Plus (rather than think about it too
> much!) and it still fails when there are NPI's defined,
> (BMC50262E SPACE 'dbname.npixname' ALREADY IN USE BY A BMC UTILITY, UTILID
> ='abc.zyx' )
> But, (and here's the spooky part) it works using BMC load when you drop
the
> NPI's
>
> Please tell me (while I still have some hair) that I have some crazy
> installation parm set wrong cos then I can pass it to someone else.
>
> Thanks.
>
>
> Richard Barclay
> database administrator
> Fortis Bank
> Application Design / 1GA3F
> Tel. +32 (0)2 228 3621
> mailto: [login to unmask email]
>
>
> This email and any attached files are confidential and may be legally
> privileged.
> If you are not the intended recipient, any disclosure, reproduction,
> copying, distribution, or other dissemination or use of this communication
> is strictly prohibited.
> If you have received this transmission in error please notify the sender
> immediately and then delete this email.
> Email transmission cannot be guaranteed to be secure or error free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
or
> incomplete, or contain viruses.
> The sender therefore is in no way liable for any errors or omissions in
the
> content of this message, which may arise as a result of email
transmission.
> If verification is required, please request a hard copy.
>
>
>
the
>
>
>
>
>



This email and any attached files are confidential and may be legally
privileged.
If you are not the intended recipient, any disclosure, reproduction,
copying, distribution, or other dissemination or use of this communication
is strictly prohibited.
If you have received this transmission in error please notify the sender
immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.
The sender therefore is in no way liable for any errors or omissions in the
content of this message, which may arise as a result of email transmission.
If verification is required, please request a hard copy.