Unable to index JES2 Spool files using ARSYSPIN

[Ricardo]

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?

[Nolan]

This looks like your first problem.

ARS1130E 22 fields submitted by the indexer, 23 expected                       

You need to give a default value if have 23 items in the AG.  Put a blank or 0 depending on the field type.

[Ricardo]

Hi J;

Thank you for your answer.

I really have defined 23 index fields to AG. The problem is as manual description, the INDEX3 is reserved to define the page number count and should be defined as TYPE=GROUPRANGE

With this definition is supposed that the indexer put the value of last page into fourth index of AG. As the page-number is discarded during index processing, one index field is missing

Best Regards;

[Greg Ira]

Clearly something is wrong with the Page_Number index.  Double check your definitions for that particular field.  To use page number I think I recall having to check off the "page count" box for the page number field in your application group.  Was that done?

[Nolan]

On the Load Information tab you need to have PAGE_NUMBER in both of the Load Id Names for index3 and index4 for it to work...don't leave it blank or you will continue to get the missing index error message.

We have
INDEX3='PAGE_NO',FIELD1,(TYPE=GROUPRANGE)

AG Name              Load ID Name
PAGE_NO             PAGE_NO
PAGE_NO_END    PAGE_NO

Try that and let us know

[Ricardo]

Hi J.

Great now it's working fine.


Thank you