Off Topic > General
arsdoc get
(1/1)
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.
Navigation
[0] Message Index
Go to full version