Messages

1

z/OS Server / Remove the Begin Separator Page from ARSYSPIN

« on: January 03, 2018, 09:25:52 AM »

Hi All;

I'm using ARSYSPIN started task to capture sysout files from JES2 Spool then load into CMOD 9.5.

The index type used is OS/390 where I have the information from Begin Separator page generated by ARSYSPIN used to index the report.

I'm using the ARSYSPIN exit (06) to remove the End Separator page but the Begin Separator page still on report after the load.

How can I remove the Begin Separator page after the indexer processing?

Best Regards;

Ricardo

2

z/OS Server / Re: Unable to index JES2 Spool files using ARSYSPIN

« on: December 21, 2017, 04:04:31 PM »

Hi J.

Great now it's working fine.


Thank you

3

z/OS Server / Re: Unable to index JES2 Spool files using ARSYSPIN

« on: December 19, 2017, 06:03:28 PM »

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;

4

z/OS Server / Unable to index JES2 Spool files using ARSYSPIN

« on: December 18, 2017, 07:01:10 PM »

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?