monaco
Beginner
Joined: 20 May 2004
Posts: 77
Topics: 31
|
 Posted: Thu Oct 21, 2004 6:12 am Post subject: Abend While Loading the DB2 table |
 |
|
Hi all,
we are trying to load dato using SYSPUNCH but we find an error:
| Code: |
IEA705I ERROR DURING GETMAIN SYS CODE = 878-10 RSA076A CUADRE 00
IEA705I 00F5ED00 008FB2C0 008FB2C0 00001600 00088540
IEA995I SYMPTOM DUMP OUTPUT 515
SYSTEM COMPLETION CODE=878 REASON CODE=00000010
TIME=12.38.54 SEQ=00571 CPU=0000 ASID=003A
PSW AT TIME OF ERROR 070C1000 81296B68 ILC 2 INTC 0D
NO ACTIVE MODULE FOUND
NAME=UNKNOWN
DATA AT PSW 01296B62 - 902C18F8 0A0D98DC D0088910
GR 0: 81296B56 1: 84878000
2: 00000004 3: 00F5ED00
4: 7FF16000 5: 00000005
6: 00000000 7: 00000878
8: 00000010 9: 01296BA4
A: 00000000 B: 00000000
C: 81296B56 D: 7FF16008
E: 81296B56 F: 00000010
END OF SYMPTOM DUMP
IEA848I DUMP SUPPRESSED - ABDUMP MAY NOT DUMP STORAGE FOR KEY 0-7 JOB RSA076A
IEF450I RSA076A CUADRE - ABEND=S878 U0000 REASON=00000010 518
TIME=12.38.56
- --TIMINGS (MINS.)--
-JOBNAME STEPNAME PROCSTEP RC EXCP CONN TCB SRB CLOCK SERV P
-RSA076A CUADRE *S878 126 221 .00 .00 .0 315
|
The JCL we use for dowloading is:
| Code: |
//RSA0761 JOB (PD0,6),'DESCAR1',NOTIFY=RSA076,
// CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1)
//********************************
//* UNLOAD PROMOTION DATA *
//* KTPM94T FROM ORIGIN *
//********************************
//STEP3 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(AISE)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB61) PARM('SQL')-
LIB('AISE.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=Z
//SYSREC00 DD DSN=AISUK.AIS3PRO.D041020.CUADRE,
// UNIT=SYSDA,SPACE=(CYL,(1,1),RLSE),
// DISP=(NEW,CATLG,DELETE),VOL=SER=AIS001
//SYSPUNCH DD DSN=AISUK.AIS3PRO.D041020.CUADRE.SYSPUNCH,
// UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
// DISP=(NEW,CATLG,DELETE),VOL=SER=AIS001
//SYSIN DD *
SELECT * FROM AIS3PRO.CUADRE ;
/*
And the JCL for loading is:
//RSA076A JOB (PD0,6),'KAETEAT',NOTIFY=RSA076,
// CLASS=A,MSGCLASS=A,MSGLEVEL=(1,1)
//CUADRE EXEC PGM=DSNUTILB,PARM='AISE,TR1,',COND=(4,LT)
//STEPLIB DD DSN=DB2N.CECN.DSNLOAD,DISP=SHR
//SORTOUT DD UNIT=3390,SPACE=(CYL,(100,10),,,ROUND)
//SORTWK01 DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SORTWK02 DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SORTWK03 DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SORTWK04 DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SYSDISC DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SYSERR DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SYSMAP DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SYSUT1 DD UNIT=3390,SPACE=(CYL,(1,1),,,ROUND)
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=Z
//SYSTSPRT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSREC00 DD DSN=AISUK.AIS3PRO.D041020.CUADRE,DISP=(OLD,KEEP)
//SYSIN DD DSN=AISUK.AIS3PRO.D041020.CUADRE.SYSPUNCH,
// DISP=SHR
/* /*
|
It seems a problems with the format of SYSPUNCH by the DB2 utilities is the one who dicides its format.
Could you help me? |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
