arsdoc get

[Steve Lance]

I am using arsdoc get to retrieve line data documents.  These documents are 133 characters.  When I use arsdoc get, it is creating a 80 character output file.  When I try to load the 80 character file, it is giving me an error.  Any suggestions?

[Justin Derrick]

Can you give us more information about what you're doing?  Some insight into the Application definition and which arsdoc command you're using would help. 

-JD.

[Steve Lance]

Attached is the arsdoc commands and results.

Application/Indexer statement


/* Migrated from CA - OS/390 */
CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
FILEFORMAT=RECORD,133
GROUPMAXPAGES=9999
INDEXOBJ=ALL
INDEXSTYLE=NODX
TRC=NO
TRIGGER1=*,1,'1',(TYPE=GROUP)
FIELD1=0,2,8,(TRIGGER=1,BASE=0)
INDEX1='SEGMENT_NUMBER',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX2='REPORT_DATE',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX3='PAGE_NO',FIELD1,(TYPE=GROUPRANGE)

Folder to use in arsdoc get

IT635P01-R19

 Document to use in arsdoc get

Arsdoc get statement

/XA1/od/alt/V10R5M0/bin/arsdoc get -h ARCHIVE -u xxxxxxx -p xxxxxxxx -a -c -g -v -d /u/s61288l/tmp -o ldITR19 -i "where OD_RID_TITLE = 'IT635P01-R19-V02'" -f 'IT635P01-R19' -N

OUT file

BROWSE    /u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635 Line 0000002002 Col 001 080
 Command ===>                                                  Scroll ===> CSR 
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
****                                                1 RUN DATE :01/22/22       
                     FACETS/ITS RF PRE-BALANCE PROCESSING                       
             PAGE      1   RUN TIME :23.18.00                                 TE
NNCARE MISMATCH DETAIL                                               IT637R12   
                                                                               
                                                                               
            CLAIMS NOT RELEASED - INVALID DUMMY PROVIDER NUMBER                 
                                                                               
                                                                               
                                                                               
                                                            GROUP        CLAIM #
              SCCF #                     PAID AMT      ACCESS FEE       ADMIN FE
E     AUTH/DEN DT                                                               
                                                                            -   
                                                                               
                                                   RF      000125000    F8156376


Arsload command
/XA5/od/alt/V10R5M0/bin/arsload -h ARCHIVE -u xxxxxxx -p xxxxxxxx -g NIDX05Y2 -a IT635P01-R19-V02 -f -v -n /u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02


Error message after load:

2022-01-27 12:52:16.799295: ARS4315I Processing file >/u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02<
2022-01-27 12:52:16.799332: ARS4334I Load Version <10.5.0.0>  Operating System <z/OS> <04.27.00>  OS Userid <ADMIN>  Install Location </XA5/od/alt/V10R5M0/> Data(unlimited KB) Stack(unlimited KB) Core(8192 512-blocks
2022-01-27 12:52:16.799343: ARS4335I Server Version <10.5.0.0>  Operating System <z/OS> <04.27.00>  Database <DB2> <12.01.0005>
2022-01-27 12:52:16.808556: ARS4339I Application Group >NIDX05Y2<
2022-01-27 12:52:16.808576: ARS4340I Application >IT635P01-R19-V02<
2022-01-27 12:52:16.808584: ARS4341I Storage Set >SGTEST01.MCRDTST<
2022-01-27 12:52:16.808591: ARS4342I Storage Node >TOD.V7.SGTEST01.MCRDTST<
2022-01-27 12:52:16.808599: ARS4347I Encryption >None<
2022-01-27 12:52:16.808859: ARS4312I Loading started, --UNKNOWN-- bytes to process
2022-01-27 12:52:16.820437: ARS5481I /* Migrated from CA - OS/390 */
2022-01-27 12:52:16.820461: ARS5481I CC=YES
2022-01-27 12:52:16.820472: ARS5481I CCTYPE=A
2022-01-27 12:52:16.820480: ARS5481I CONVERT=NO
2022-01-27 12:52:16.820487: ARS5481I CPGID=500
2022-01-27 12:52:16.820496: ARS5481I FILEFORMAT=RECORD,133
2022-01-27 12:52:16.820505: ARS5481I GROUPMAXPAGES=9999
2022-01-27 12:52:16.820512: ARS5481I INDEXOBJ=ALL
2022-01-27 12:52:16.820520: ARS5481I INDEXSTYLE=NODX
2022-01-27 12:52:16.820528: ARS5481I TRC=NO
2022-01-27 12:52:16.820535: ARS5481I TRIGGER1=*,1,'1',(TYPE=GROUP)
2022-01-27 12:52:16.820544: ARS5481I FIELD1=0,2,8,(TRIGGER=1,BASE=0)
2022-01-27 12:52:16.820554: ARS5481I INDEX1='SEGMENT_NUMBER',FIELD1,(TYPE=GROUP,BREAK=NO)
2022-01-27 12:52:16.820564: ARS5481I INDEX2='REPORT_DATE',FIELD1,(TYPE=GROUP,BREAK=NO)
2022-01-27 12:52:16.820573: ARS5481I INDEX3='PAGE_NO',FIELD1,(TYPE=GROUPRANGE)
2022-01-27 12:52:16.820807: ARS5441E Open failed for input file - /u/s61288l/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02
2022-01-27 12:52:16.820826: ARS5476E The 390 indexer failed with the specified return code. (RC = 6).
2022-01-27 12:52:16.820849: ARS1146I Loaded 0 rows into the database
2022-01-27 12:52:16.820857: ARS4311E Loading failed
2022-01-27 12:52:16.820865: ARS4318E Processing failed for file >/u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P
Application/Indexer statement

/* Migrated from CA - OS/390 */
CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
FILEFORMAT=RECORD,133
GROUPMAXPAGES=9999
INDEXOBJ=ALL
INDEXSTYLE=NODX
TRC=NO
TRIGGER1=*,1,'1',(TYPE=GROUP)
FIELD1=0,2,8,(TRIGGER=1,BASE=0)
INDEX1='SEGMENT_NUMBER',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX2='REPORT_DATE',FIELD1,(TYPE=GROUP,BREAK=NO)
INDEX3='PAGE_NO',FIELD1,(TYPE=GROUPRANGE)


Folder to use in arsdoc get

Document to use in arsdoc get

Arsdoc get statement

/XA1/od/alt/V10R5M0/bin/arsdoc get -h ARCHIVE -u xxxxxxx -p xxxxxxxx -a -c -g -v -d /u/s61288l/tmp -o ldITR19 -i "where OD_RID_TITLE = 'IT635P01-R19-V02'" -f 'IT635P01-R19' -N

OUT file

BROWSE    /u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635 Line 0000002002 Col 001 080
 Command ===>                                                  Scroll ===> CSR 
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
****                                                1 RUN DATE :01/22/22       
                     FACETS/ITS RF PRE-BALANCE PROCESSING                       
             PAGE      1   RUN TIME :23.18.00                                 TE
NNCARE MISMATCH DETAIL                                               IT637R12   
                                                                               
                                                                               
            CLAIMS NOT RELEASED - INVALID DUMMY PROVIDER NUMBER                 
                                                                               
                                                                               
                                                                               
                                                            GROUP        CLAIM #
              SCCF #                     PAID AMT      ACCESS FEE       ADMIN FE
E     AUTH/DEN DT                                                               
                                                                            -   
                                                                               
                                                   RF      000125000    F8156376




Arsload command
/XA5/od/alt/V10R5M0/bin/arsload -h ARCHIVE -u xxxxxxx -p xxxxxxxx -g NIDX05Y2 -a IT635P01-R19-V02 -f -v -n /u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02

Error message after load:

2022-01-27 12:52:16.799295: ARS4315I Processing file >/u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02<
2022-01-27 12:52:16.799332: ARS4334I Load Version <10.5.0.0>  Operating System <z/OS> <04.27.00>  OS Userid <ADMIN>  Install Location </XA5/od/alt/V10R5M0/> Data(unlimited KB) Stack(unlimited KB) Core(8192 512-blocks
2022-01-27 12:52:16.799343: ARS4335I Server Version <10.5.0.0>  Operating System <z/OS> <04.27.00>  Database <DB2> <12.01.0005>
2022-01-27 12:52:16.808556: ARS4339I Application Group >NIDX05Y2<
2022-01-27 12:52:16.808576: ARS4340I Application >IT635P01-R19-V02<
2022-01-27 12:52:16.808584: ARS4341I Storage Set >SGTEST01.MCRDTST<
2022-01-27 12:52:16.808591: ARS4342I Storage Node >TOD.V7.SGTEST01.MCRDTST<
2022-01-27 12:52:16.808599: ARS4347I Encryption >None<
2022-01-27 12:52:16.808859: ARS4312I Loading started, --UNKNOWN-- bytes to process
2022-01-27 12:52:16.820437: ARS5481I /* Migrated from CA - OS/390 */
2022-01-27 12:52:16.820461: ARS5481I CC=YES
2022-01-27 12:52:16.820472: ARS5481I CCTYPE=A
2022-01-27 12:52:16.820480: ARS5481I CONVERT=NO
2022-01-27 12:52:16.820487: ARS5481I CPGID=500
2022-01-27 12:52:16.820496: ARS5481I FILEFORMAT=RECORD,133
2022-01-27 12:52:16.820505: ARS5481I GROUPMAXPAGES=9999
2022-01-27 12:52:16.820512: ARS5481I INDEXOBJ=ALL
2022-01-27 12:52:16.820520: ARS5481I INDEXSTYLE=NODX
2022-01-27 12:52:16.820528: ARS5481I TRC=NO
2022-01-27 12:52:16.820535: ARS5481I TRIGGER1=*,1,'1',(TYPE=GROUP)
2022-01-27 12:52:16.820544: ARS5481I FIELD1=0,2,8,(TRIGGER=1,BASE=0)
2022-01-27 12:52:16.820554: ARS5481I INDEX1='SEGMENT_NUMBER',FIELD1,(TYPE=GROUP,BREAK=NO)
2022-01-27 12:52:16.820564: ARS5481I INDEX2='REPORT_DATE',FIELD1,(TYPE=GROUP,BREAK=NO)
2022-01-27 12:52:16.820573: ARS5481I INDEX3='PAGE_NO',FIELD1,(TYPE=GROUPRANGE)
2022-01-27 12:52:16.820807: ARS5441E Open failed for input file - /u/s61288l/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02
2022-01-27 12:52:16.820826: ARS5476E The 390 indexer failed with the specified return code. (RC = 6).
2022-01-27 12:52:16.820849: ARS1146I Loaded 0 rows into the database
2022-01-27 12:52:16.820857: ARS4311E Loading failed
2022-01-27 12:52:16.820865: ARS4318E Processing failed for file >/u/xxxxxxx/tmp/ldITR19.0.NIDX90D21.IT635P

[Justin Derrick]

It simply looks like you aren't able to open a specific file: 

    ARS5441E Open failed for input file - /u/s61288l/tmp/ldITR19.0.NIDX90D21.IT635P01-R19-V02

You might need to remove the directory path from the generic index file if you've moved the data to a different system for loading.

-JD.

[Darrell Bryant]

The arsdoc get command created generic indexer files.  On the arsload command, should the indexer be overridden from the 390 indexer to the generic indexer since the data is already indexed?  The -X G parameter would do that.