REPRO COPY failed with RC 12

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

HI All

I have a query.

One one my test job failed with RC 12. The setp just do a REPRO COPY.
In he job jog i find two thing

SEQ NON-UPD READS and SEQ INSERTS.

And the value for both fields is same.
I just want to confirm that the copy is sucessful or not.

0d311 · Guest

RC 12 will mean that the repro job failed (I think

)

Can you provide the JCL and the SYSOUT?

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

//PGCFN031 JOB (0000,0002),'FALF0031 DEFINE',
// MSGLEVEL=(1,1),
// NOTIFY=&SYSUID,
// REGION=6M,
// MSGCLASS=H,
// CLASS=P,
// USER=CTLMPFN

//STEP040 EXEC PGM=IDCAMS,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//INPUT DD DSN=PGCFLFN.FALCON.FALF0031.PREV.KE,DISP=SHR
//OUTPUT DD DSN=PGCFLFN.FALCON.FALF0031.KE,DISP=SHR
//SYSIN DD DSN=PGCFLFN.GE.PARMLIB(REPRO),DISP=SHR

SYSOUT is

1IDCAMS SYSTEM SERVICES TIME: 02:48:
0
REPRO -
INFILE(INPUT) -
OUTFILE(OUTPUT) -
REUSE
0IDC3302I ACTION ERROR ON PGCFLFN.FALCON.FALF0031.KE
IDC3351I ** VSAM I/O RETURN CODE IS 28 - RPLFDBWD = X'2908001C'
IDC31467I MAXIMUM ERROR LIMIT REACHED.
0IDC0005I NUMBER OF RECORDS PROCESSED WAS 2188800
0IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12
0
0IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12

07/29/2007 02:59:46 MAINVIEW DATA OPTIMIZER

********************** DATA OPTIMIZER PERFORMANCE REPORT *********************
* JOBNAME : PGCFN031 STEPNAME : FALF0031 PROCSTEPNAME: STEP040
* JOBCLASS : P USERID : CTLMPFN GROUP : $RESGRP
* JOBCLASS : P USERID : CTLMPFN GROUP : $RESGRP
* ADSPC TYPE: JOB PGMNAME : IDCAMS OPEN TIME : 02:48
* DDNAME : INPUT DSTYPE : VSAM SUBSYSTEM : MBOS
* DATACLASS : DCVS1113 STORCLASS: SCSTAND MGMTCLASS : MCEMIGNB
* DSNAME : PGCFLFN.FALCON.FALF0031.PREV.KE
*
* INTERCEPTED BY DATAPOLICY(DATPOLP6) POLICYLINE(00227)
*
* RND NON-UPD READS................. 0 RND UPDATE READS................ 0
* SEQ NON-UPD READS......... 2,188,801 SEQ UPDATE READS................ 0
* RND INSERTS....................... 0 RND UPDATES..................... 0
* SEQ INSERTS....................... 0 SEQ UPDATES..................... 0
* SKIP SEQUENTIAL................... 0 POINTS.......................... 0
* ENDREQS........................... 0 ERASES.......................... 0
*
* INDEX BUFFERS................... 255 DATA BUFFERS................... 90
*
* INDEX PHYSICAL I/O'S.......... 7,625 DATA PHYSICAL I/O'S......... 7,625
* ESTIMATED I/O SAVINGS.......... 0.00%
*
LINE 608 OF 724 COLS 1:79
* ACCESS.......................... ADR RESET TO EMPTY................. NO
* INPUT........................... YES OUTPUT......................... NO
* SEQUENTIAL...................... YES DIRECT......................... NO
* SKIP SEQUENTIAL.................. NO RLS............................ NO
* SEQUENTIAL INSERT STRATEGY...... YES DEFER WRITES.................. YES
* LSR.............................. NO GSR............................ NO
* LSR POOL ID....................... 0 EXCLUSIVE CONTROL WAIT......... NO
* 31-BIT BUFFERS.................. YES 31-BIT CONTROL BLOCKS.......... NO
* USER BUFFERING................... NO FIXED BUFFERS.................. NO
* STRINGS........................... 1 BASE STRINGS.................... 0
* AIX.............................. NO DSN SHARING.................... NO
* EXIT LIST....................... YES EODAD......................... YES
* JRNAD............................ NO UPAD........................... NO
* LERAD........................... YES SYNAD......................... YES
* ACBOFLGS......................... 96 ACBMACR.................. 54008C00
* ACBINFLG....................... 0000 ACBERFLG....................... 00
******************************************************************************

********************** DATA OPTIMIZER PERFORMANCE REPORT *********************
LINE 627 OF 724 COLS 1:79
********************** DATA OPTIMIZER PERFORMANCE REPORT *********************
* JOBNAME : PGCFN031 STEPNAME : FALF0031 PROCSTEPNAME: STEP040
* JOBCLASS : P USERID : CTLMPFN GROUP : $RESGRP
* ADSPC TYPE: JOB PGMNAME : IDCAMS OPEN TIME : 02:48
* DDNAME : OUTPUT DSTYPE : VSAM SUBSYSTEM : MBOS
* DATACLASS : DCVS1113 STORCLASS: SCSTAND MGMTCLASS : MCEMIGNB
* DSNAME : PGCFLFN.FALCON.FALF0031.KE
*
* INTERCEPTED BY DATAPOLICY(DATPOLP6) POLICYLINE(00227)
*
* RND NON-UPD READS................. 0 RND UPDATE READS................ 0
* SEQ NON-UPD READS................. 0 SEQ UPDATE READS................ 0
* RND INSERTS....................... 0 RND UPDATES..................... 0
* SEQ INSERTS............... 2,188,801 SEQ UPDATES..................... 0
* SKIP SEQUENTIAL................... 0 POINTS.......................... 0
* ENDREQS........................... 0 ERASES.......................... 0
*
* INDEX BUFFERS..................... 8 DATA BUFFERS.................. 255
*
* INDEX PHYSICAL I/O'S......... 38,510 DATA PHYSICAL I/O'S........ 22,832
* ESTIMATED I/O SAVINGS.......... 27.1%
*
* ACCESS.......................... ADR RESET TO EMPTY................ YES
* INPUT............................ NO OUTPUT........................ YES
* SEQUENTIAL...................... YES DIRECT......................... NO
* SKIP SEQUENTIAL.................. NO RLS............................ NO
* SEQUENTIAL INSERT STRATEGY...... YES DEFER WRITES.................. YES
* LSR.............................. NO GSR............................ NO
* LSR POOL ID....................... 0 EXCLUSIVE CONTROL WAIT......... NO
* 31-BIT BUFFERS.................. YES 31-BIT CONTROL BLOCKS.......... NO
* USER BUFFERING................... NO FIXED BUFFERS.................. NO
* STRINGS........................... 1 BASE STRINGS.................... 0
* AIX.............................. NO DSN SHARING.................... NO
* EXIT LIST....................... YES EODAD......................... YES
* JRNAD............................ NO UPAD........................... NO
* LERAD........................... YES SYNAD......................... YES
* ACBOFLGS......................... 96 ACBMACR.................. 52048C00
* ACBINFLG....................... 0000 ACBERFLG....................... 00
******************************************************************************

********************** DATA OPTIMIZER PERFORMANCE REPORT *********************
* JOBNAME : PGCFN031 STEPNAME : FALF0031 PROCSTEPNAME: STEP040
* JOBCLASS : P USERID : CTLMPFN GROUP : $RESGRP
* ADSPC TYPE: JOB PGMNAME : IDCAMS OPEN TIME : 02:48
* DDNAME : SYSIN DSTYPE : NON-VSAM SUBSYSTEM : MBOS
* DATACLASS : **NONE** STORCLASS: SCSTAND MGMTCLASS : MCEMIGNB
* DSNAME : PGCFLFN.GE.PARMLIB
*
* INTERCEPTED BY DATAPOLICY(DATPOLP6) POLICYLINE(00232)
*
* I/O SAVINGS................... 37.50% ADDITIONAL BUFFERS.............. 3
*
* DSORG............................ PS RECFM.......................... FB
* LRECL............................ 80 BLOCKSIZE.................. 27,920
* VOLSER....................... PGC002 DEVICE TYPE.................. 3390
* VOLUME COUNT...................... 1 DCBE........................... NO
* ACCESS METHOD.................. QSAM OPEN OPTION................. INPUT
* MACRO OPTION..................... GL DCBMACRF..................... 4800
* BUFNO............................. 8 NCP........................... N/A
LINE 687 OF 724 COLS 1:79
* DCBOPTCD......................... 00 ERROR OPTION................. SKIP
* EODAD........................... YES SYNAD......................... YES
* DCB OPEN EXIT................... YES DCB ABEND EXIT................ YES
* JFCB EXIT........................ NO JFCBE EXIT..................... NO
* EOV EXIT......................... NO
******************************************************************************

1------------------------------------------------------------------------------
OMCXW209I PGCFN031 J09885 OMCSDBSE DBSE PGCFN031 J09885 H LOCAL JES2.JOB09885.PS000002 STD STD LOCAL H : 0000,DBASFALC
OMCXW330I PGCFN031 J09885 02:59:46 SUN 29JUL 07210 SDS=#0000209 JPR=* DAY#=6418
OMCXW209I PGCFN031 J09885 EXIT0 LAST PGCFN031 J09885 . LOCAL JES2.JOB09885.PS000002 STD STD LOCAL H : 0000,
OMCXW507I PGCFN031 J09885 BASIC CHECKING LOG--------------------------
MSGU 247 IEF380I PGCFN031 STEP040 FALF0031 INPUT - VOLUME COUNT FOR DD EXCEEDED: SPECIFIC- 9 NON-SPECIFIC- 109
MSGU 248 IEF380I PGCFN031 STEP040 FALF0031 OUTPUT - VOLUME COUNT FOR DD EXCEEDED: SPECIFIC- 1 NON-SPECIFIC- 117
MSGU 261 IEC070I 211(8,17273)-221,PGCFN031,STEP040 FALF0031,OUTPUT,37C9,
MSGU 262 IEC070I PGC007,PGCFLFN.FALCON.FALF0031.KE,
MSGU 263 IEC070I PGCFLFN.FALCON.FALF0031.KE.DATA,UCAT.XSYS6.APPL.GC

0d311 · Guest

Is the output file a VSAM?

VSAM return code 28 is "No space on device"

0d311 · Guest

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

Yeah that true that the VSAM file is not bale to extend to other volume or the DASD is not enough.

My question is that in the SYSOUT

SEQ NON-UPD READS......... 2,188,801
SEQ INSERTS............... 2,188,801

are same.

Does it meas that the no of records (2188801) is read from PGCFLFN.FALCON.FALF0031.PREV.KE and records 2188801 inserted to PGCFLFN.FALCON.FALF0031.KE ???

ksk · Posted: Thu Aug 16, 2007 3:38 pm

Just browse the output file and see howmany records are present.

CICS Guy · Posted: Thu Aug 16, 2007 3:40 pm

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

We cant count the no of record. as this file is being update daily. and this job failed on 10th aug.

the output file is containg some 2218889 records now.

so what does these parametars signifies.
SEQ NON-UPD READS......... 2,188,801
SEQ INSERTS............... 2,188,801

and how the repro copy works.?

is it 1st read the whole input file ( say 2,188,801 records)and then insert in to output file ?

or it 1st read one records and then insert into output file. and this process continue till the end (is the input file has no more records to read)

William Thompson · Posted: Thu Aug 16, 2007 4:06 pm

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

so REPRO follows the 2nd approch to copy the files from one to other.

if this is the case then

0IDC0005I NUMBER OF RECORDS PROCESSED WAS 2188800

and when it tried to read the record no 2188801 and tried to insert to output file it failed...
correct me on this.....

Let consider we have 2188805 records in input file, if copy file failed that means the last 5 records did not copied to out file( ie the record no # 2188801,2188802,2188803,2188804,2188805). am i right??

this job was not rerun...after this job failed we manually copied the input file to output file thru FILE AID

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

HI Guys
Any update??

dbzTHEdinosauer · Posted: Fri Aug 17, 2007 12:03 pm

you are asking someone to say, "yes, you fixed the file with your silly File-Aid fix". Now, howmany people are going to do that?

riju_luvjust · New User Joined: 04 Oct 2006 Posts: 18

i did the File aid fix as this job was an production job and i need to fix it ASAP..

Please correct me what i asked in my previous post

William Thompson · Posted: Fri Aug 17, 2007 2:09 pm

dick scherrer · Posted: Fri Aug 17, 2007 6:34 pm

Hello,

To possibly get an answer you can use, please clearly post your current question or doubt.

The better clarification yo providfe, the better responses you will receive.