Hi All;
I had defined a Application group to be used to receive reports captured from JES2 using ARSYSPIN started task. I did a lot of tests but none are clear when using the values in Begin header to index a file.
I'm using OS/390 indexer with INDEXSTYLE=NODX as below:
CC=YES
CCTYPE=A
FILEFORMAT=RECORD
CPGID=37
CONVERT=NO
GROUPMAXPAGES=9999
TRIGGER1=*,206,X'E0E07A50C2E2D7C9D5C2507AE0E0',(TYPE=GROUP)
/********************************************************/
/* Identify the fields from report used as indexer */
/********************************************************/
FIELD1=0,3,8,(TRIGGER=1,BASE=0) /* ARSYSEP_REPTID */
FIELD2=0,11,8,(TRIGGER=1,BASE=0) /* ARSYSEP_JOBNAME */
FIELD3=0,20,8,(TRIGGER=1,BASE=0) /* ARSYSEP_JOBID */
FIELD4=0,28,8,(TRIGGER=1,BASE=0) /* ARSYSEP_PROCSTEP */
FIELD5=0,36,8,(TRIGGER=1,BASE=0) /* ARSYSEP_STEP */
FIELD6=0,44,8,(TRIGGER=1,BASE=0) /* ARSYSEP_DDNAME */
FIELD7=0,52,8,(TRIGGER=1,BASE=0) /* ARSYSEP_WRITER */
FIELD8=0,60,8,(TRIGGER=1,BASE=0) /* ARSYSEP_FORM */
FIELD9=0,68,1,(TRIGGER=1,BASE=0) /* ARSYSEP_CLASS */
FIELD10=0,69,44,(TRIGGER=1,BASE=0) /* ARSYSEP_JESDSN */
FIELD11=0,113,10,(TRIGGER=1,BASE=0) /* ARSYSEP_CRTDATE *
FIELD12=0,123,15,(TRIGGER=1,BASE=0) /* ARSYSEP_CRTTIME */
FIELD13=0,138,10,(TRIGGER=1,BASE=0) /* ARSYSEP_JMRDATE */
FIELD14=0,148,15,(TRIGGER=1,BASE=0) /* ARSYSEP_JMRTIME */
FIELD15=0,163,16,(TRIGGER=1,BASE=0) /* ARSYSEP_RECCNT */
FIELD16=0,179,16,(TRIGGER=1,BASE=0) /* ARSYSEP_FILESZ */
FIELD17=0,195,8,(TRIGGER=1,BASE=0) /* ARSYSEP_JENDSTAT */
FIELD18=0,220,10,(TRIGGER=1,BASE=0) /* ARSYSEP_JENDCC */
/********************************************************/
/* Define the Indexer fields to report */
/********************************************************/
INDEX1='SEGMENT_NUMBER',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX2='REPORT_DATE',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX3='PAGE_NUMBER',FIELD1,(TYPE=GROUPRANGE)
INDEX4='POSTING_DATE',FIELD11,(TYPE=GROUP,BREAK=NO)
INDEX5='ARSYSEP_REPTID',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX6='ARSYSEP_JOBNAME',FIELD2,(TYPE=GROUP,BREAK=NO)
INDEX7='ARSYSEP_JOBID',FIELD3,(TYPE=GROUP,BREAK=NO)
INDEX8='ARSYSEP_PROCSTEP',FIELD4,(TYPE=GROUP,BREAK=NO)
INDEX9='ARSYSEP_STEP',FIELD5,(TYPE=GROUP,BREAK=NO)
INDEX10='ARSYSEP_DDNAME',FIELD6,(TYPE=GROUP,BREAK=NO)
INDEX11='ARSYSEP_WRITER',FIELD7,(TYPE=GROUP,BREAK=NO)
INDEX12='ARSYSEP_FORM',FIELD8,(TYPE=GROUP,BREAK=NO)
INDEX13='ARSYSEP_CLASS',FIELD9,(TYPE=GROUP,BREAK=NO)
INDEX14='ARSYSEP_JESDSN',FIELD10,(TYPE=GROUP,BREAK=NO)
INDEX15='ARSYSEP_CRTDATE',FIELD11,(TYPE=GROUP,BREAK=NO)
INDEX16='ARSYSEP_CRTTIME',FIELD12,(TYPE=GROUP,BREAK=NO)
INDEX17='ARSYSEP_JMRDATE',FIELD13,(TYPE=GROUP,BREAK=NO)
INDEX18='ARSYSEP_JMRTIME',FIELD14,(TYPE=GROUP,BREAK=NO)
INDEX19='ARSYSEP_RECCNT',FIELD15,(TYPE=GROUP,BREAK=NO)
INDEX20='ARSYSEP_FILESZ',FIELD16,(TYPE=GROUP,BREAK=NO)
INDEX21='ARSYSEP_JENDSTAT',FIELD17,(TYPE=GROUP,BREAK=NO)
INDEX22='ARSYSEP_JENDCC',FIELD18,(TYPE=GROUP,BREAK=NO)
INDEXSTYLE=NODX
All fields listed on index file are defined to Application Group. Additionally I have defined a index name called PAGE_END_NUMBER as the fourth index to receive the end page number from GROUPRANGE INDEX3
The ARSYSPIN have the following error message:
From SYSPRINT file
11:00:29.880160: ARS1143I The field name 'PAGE_NUMBER' found in the index file does not match any expected field will be ignored.
11:00:29.892106: ARS1146I Loaded 0 rows into the database
From SYSOUT file
ARS1130E 22 fields submitted by the indexer, 23 expected
ARS5476E The OS/390 indexer failed with the specified return code. (Arsl390 retu
ARS4311E Loading failed
ARS4318E Processing failed for file >/tmp//67110795.000001606C508A98 (DD:SYS0000
ARS4327E Processing has stopped. The remaining files will NOT be processed.
Please, any ideas?