DB2 load utility failing for no apparent reason

Dee Reins

DB2 load utility failing for no apparent reason

I am the DBA for this database. this was working before I went on vacation.

I try to load data in to the tables, and get this message.

- LOAD DATA LOG NO REPLACE NOCOPYPEND STATISTICS
- TABLE INDEX (ALL KEYCARD) INDDN SYSIN394
- INTO TABLE CTMR61.VMR904VM_CUST_GR
- ( "CCF_CD"
- POSITION( 00003:00007) CHAR(00005)
- , "PROV_ST_CD"
- POSITION( 00008:00009) CHAR(00002)
- , "VM_CUST_GR"
- POSITION( 00010:00024) CHAR(00015)
- )
-
- UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
There are 7,351 load control statements.

I have a proc that has DD statements that match the SYSIN394.
I have looked in the DB2 Job log and see ;

18.40.51 STC14766 DSN3201I -DB2X ABNORMAL EOT IN PROGRESS FOR 826
826 USER=TSXVHDR CONNECTION-ID=UTILITY CORRELATION-ID=TDB2MR61
826 JOBNAME=TDB2MR61 ASID=023C TCB=008FF050

does anyone have any idea's about what may cause this?
I suspect security.
Thanks
Dee Reins

“Coming together is a beginning. Keeping together is progress. Working together is success"


_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Roy Boxwell

Re: DB2 load utility failing for no apparent reason
(in response to Dee Reins)
we actually need the failing message to help on this one!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert



Dee Reins <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
29.12.2010 02:43
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
[DB2-L] DB2 load utility failing for no apparent reason







I am the DBA for this database. this was working before I went on
vacation.

I try to load data in to the tables, and get this message.

- LOAD DATA LOG NO REPLACE NOCOPYPEND STATISTICS
- TABLE INDEX (ALL KEYCARD) INDDN SYSIN394
- INTO TABLE CTMR61.VMR904VM_CUST_GR
- ( "CCF_CD"
- POSITION( 00003:00007) CHAR(00005)
- , "PROV_ST_CD"
- POSITION( 00008:00009) CHAR(00002)
- , "VM_CUST_GR"
- POSITION( 00010:00024) CHAR(00015)
- )
-
- UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
There are 7,351 load control statements.

I have a proc that has DD statements that match the SYSIN394.
I have looked in the DB2 Job log and see ;

18.40.51 STC14766 DSN3201I -DB2X ABNORMAL EOT IN PROGRESS FOR 826
826 USER=TSXVHDR CONNECTION-ID=UTILITY
CORRELATION-ID=TDB2MR61
826 JOBNAME=TDB2MR61 ASID=023C TCB=008FF050

does anyone have any idea's about what may cause this?
I suspect security.
Thanks
Dee Reins

“Coming together is a beginning. Keeping together is progress. Working
together is success"




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Dee Reins

Re: DB2 load utility failing for no apparent reason
(in response to Roy Boxwell)

I found the error.

OPERAND 'SYSIN292B' EXCEEDS KEYWORD 'INDDN'

It was on line 6875 out of 7380 lines.

Not a friendly utility to debug.

Thanks
Dee


“Coming together is a beginning. Keeping together is progress. Working together is success"



----- Original Message -----
From: "Roy Boxwell" <[login to unmask email]>
To: [login to unmask email]
Sent: Tuesday, December 28, 2010 10:41:54 PM
Subject: Re: [DB2-L] DB2 load utility failing for no apparent reason


we actually need the failing message to help on this one!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert


Dee Reins < [login to unmask email] >
Gesendet von: IDUG DB2-L < [login to unmask email] >

29.12.2010 02:43
Bitte antworten an
IDUG DB2-L < [login to unmask email] >

An [login to unmask email]

Kopie

Thema [DB2-L] DB2 load utility failing for no apparent reason





I am the DBA for this database. this was working before I went on vacation.

I try to load data in to the tables, and get this message.

- LOAD DATA LOG NO REPLACE NOCOPYPEND STATISTICS
- TABLE INDEX (ALL KEYCARD) INDDN SYSIN394
- INTO TABLE CTMR61.VMR904VM_CUST_GR
- ( "CCF_CD"
- POSITION( 00003:00007) CHAR(00005)
- , "PROV_ST_CD"
- POSITION( 00008:00009) CHAR(00002)
- , "VM_CUST_GR"
- POSITION( 00010:00024) CHAR(00015)
- )
-
- UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
There are 7,351 load control statements.

I have a proc that has DD statements that match the SYSIN394.
I have looked in the DB2 Job log and see ;

18.40.51 STC14766 DSN3201I -DB2X ABNORMAL EOT IN PROGRESS FOR 826
826 USER=TSXVHDR CONNECTION-ID=UTILITY CORRELATION-ID=TDB2MR61
826 JOBNAME=TDB2MR61 ASID=023C TCB=008FF050

does anyone have any idea's about what may cause this?
I suspect security.
Thanks
Dee Reins

“Coming together is a beginning. Keeping together is progress. Working together is success"






The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.




Introducing IBM® DB2® 10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Dave Petronella

Re: DB2 load utility failing for no apparent reason
(in response to Dee Reins)
Using what you originally provided as a sample, the identifier following
the "INDDN" keyword is the name of a DD statement in the JCL that is
executing the LOAD utility. In your example "SYSIN394" appears somewhere
in your JCL./PROC. DD names can not be greater than 8 characters and
"SYSIN292B" in your error message is 9 characters so you need to find out
what the actual DD name in the JCL is coded as - perhaps "SYSIN292" if it
follows the same format?

- LOAD DATA LOG NO REPLACE NOCOPYPEND STATISTICS
- TABLE INDEX (ALL KEYCARD) INDDN SYSIN394

________________________
David Petronella
Vice President
Data Resource Management / DB2 Database Administration
Pershing LLC, a BNY Mellon company
www.pershing.com
Office: (973) 360-7747
Fax: (973) 360-3121
Email: [login to unmask email]

Go Green. Think before you print.



From: Dee Reins <[login to unmask email]>
To: [login to unmask email]
Date: 12/29/2010 07:07 PM
Subject: Re: [DB2-L] DB2 load utility failing for no apparent
reason
Sent by: IDUG DB2-L <[login to unmask email]>




I found the error.

OPERAND 'SYSIN292B' EXCEEDS KEYWORD 'INDDN'

It was on line 6875 out of 7380 lines.

Not a friendly utility to debug.

Thanks
Dee


?Coming together is a beginning. Keeping together is progress. Working
together is success"



----- Original Message -----
From: "Roy Boxwell" <[login to unmask email]>
To: [login to unmask email]
Sent: Tuesday, December 28, 2010 10:41:54 PM
Subject: Re: [DB2-L] DB2 load utility failing for no apparent reason


we actually need the failing message to help on this one!

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert


Dee Reins <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
29.12.2010 02:43

Bitte antworten an
IDUG DB2-L <[login to unmask email]>



An
[login to unmask email]
Kopie

Thema
[DB2-L] DB2 load utility failing for no apparent reason









I am the DBA for this database. this was working before I went on
vacation.

I try to load data in to the tables, and get this message.

- LOAD DATA LOG NO REPLACE NOCOPYPEND STATISTICS
- TABLE INDEX (ALL KEYCARD) INDDN SYSIN394
- INTO TABLE CTMR61.VMR904VM_CUST_GR
- ( "CCF_CD"
- POSITION( 00003:00007) CHAR(00005)
- , "PROV_ST_CD"
- POSITION( 00008:00009) CHAR(00002)
- , "VM_CUST_GR"
- POSITION( 00010:00024) CHAR(00015)
- )
-
- UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
There are 7,351 load control statements.

I have a proc that has DD statements that match the SYSIN394.
I have looked in the DB2 Job log and see ;

18.40.51 STC14766 DSN3201I -DB2X ABNORMAL EOT IN PROGRESS FOR 826
826 USER=TSXVHDR CONNECTION-ID=UTILITY
CORRELATION-ID=TDB2MR61
826 JOBNAME=TDB2MR61 ASID=023C TCB=008FF050

does anyone have any idea's about what may cause this?
I suspect security.
Thanks
Dee Reins

?Coming together is a beginning. Keeping together is progress. Working
together is success"






The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.

******************************************************
IMPORTANT: Any information contained in this communication is intended for the use of the named individual or entity. All information contained in this communication is not intended or construed as an offer, solicitation, or a recommendation to purchase any security. Advice, suggestions or views presented in this communication are not necessarily those of Pershing LLC nor do they warrant a complete or accurate statement.

If you are not an intended party to this communication, please notify the sender and delete/destroy any and all copies of this communication. Unintended recipients shall not review, reproduce, disseminate nor disclose any information contained in this communication. Pershing LLC reserves the right to monitor and retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not accept liability nor does it warrant that email communications are virus or defect free.
******************************************************

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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