OnDemand User Group
Support Forums => z/OS Server => Topic started by: New-Z/osCMODuser on June 30, 2023, 09:05:00 AM
-
HI team ,
WE have XML data which is Bigger than 250K in length and trying to store in CMOD for arching , Since we cant get this in mainframe PS file .we have delivered to OMVS and Expectation is to load directly from OMVS/USS Instead of copying to MVS ,
Any one have suggestions Script /JCL needs to used to load data from OMVS
-
look at member arsivpj1 in the SARSINST library created with the instal. It does what you are requesting with AFP and should work with XML. Or execute the arsload command directly from an omvs prompt it one time. If it is reocurring put within a shell script
JCL
//STEP1 EXEC PGM=ARSLOAD,REGION=0M,
// PARM=('/-u ADMIN -p <password> -h ARCHIVE -n -v -s OBJINPT
// -Z ivp -g "ARSIVPR1" tempname')
//STEPLIB DD DISP=SHR,DSN=&ARS..SARSLOAD
// DD DISP=SHR,DSN=&DB2..&DB2NAME..SDSNEXIT
// DD DISP=SHR,DSN=&DB2..SDSNLOAD
// DD DISP=SHR,DSN=&DB2..SDSNLOD2
//ARSBIN DD PATH='/usr/lpp/ars/V10R1M0/bin'
//SYSPRINT DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=134,BLKSIZE=134)
//OBJINPT DD PATH='/usr/lpp/ars/V10R1M0/samples/ARSIVPR1.out',
// LRECL=133,RECFM=FBA,
// FILEDATA=TEXT,PATHOPTS=(ORDONLY),
// PATHDISP=(KEEP,KEEP)
//INPSTATS DD SYSOUT=*
//INDSTATS DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
Script with arsload command that could have v]been executed at omvs prompt
cd /PRODUCTS/ars/V10R5M0/bin
export STEPLIB=SYS22.CMOD.V10R5M0.SARSLOAD
export DSNAOINI='/etc/ars/cli.ini'
arsload -I ARCHIVE -u xxxx - p xxxx -G AGNAME -a APPNAME -d /DIRNAME filetolaodname
-
thank you Maw , Here is OBJINPT DD statement is refers to Xml file .But it get failed with RC 06. Not sure why it is tryign tot ake temp file different every time different even after providing path and file name .
// PARM=('/-h ARSDBASE -g FP -a FP -nfvE
// -s INPUT /tmp/arsload.temp')
//DSNAOINI DD PATH='/ondemand/x1/parms/cli.ini'
//ARSBIN DD PATH='/usr/lpp1/ars/d2/bin'
//INPUT DD PATH='/BOX/temp1/OnDemand-Outgoing.xml.in',
// PATHOPTS=(ORDONLY),
// PATHDISP=(KEEP,KEEP)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//INPSTATS DD SYSOUT=*
//INDSTATS DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
SYSOUT :
2023-06-30 18:49:20.860013: ARS7732E A parsing error occurred in file /tmp//1717 1355.000001890DAFDEA5, Line 0, Column 0:
unable to open primary document entity '/tmp//17171355.000001890DAFDEA5'
2023-06-30 18:49:20.860378: ARS4311E Loading failed
2023-06-30 18:49:20.860384: ARS4318E Processing failed for file >/tmp//17171355. .000001890DAFDEA5 (DD:INPUT-...PATH=.SPECIFIED...)<
2023-06-30 18:49:20.866356: ARS4327E Processing has stopped. The remaining files will NOT be processed.
-
I also tried to Add Different XML declarations ,All of them are failed with Same error .
Any One have suggestions
-
Changed parms and got below error ,
removed -S option as it is not taking USS path ,instead used -V .gave different error. hope fully will get fixed .
//STEP1 EXEC PGM=ARSLOAD,REGION=0M,
// PARM=('/-h ARSDBASE -g BMH-PMT -a BMH-PMT -nfE
// -v /tmp/temp1/OnDemand-Outgoing.xml.in')
//DSNAOINI DD PATH='/ondemand/CPUG/parms/cli.ini'
//ARSBIN DD PATH='/usr/lpp1/ars/d2/bin'
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//INPSTATS DD SYSOUT=*
//INDSTATS DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
2023-07-05 17:47:17.204960: ARS7732E A parsing error occurred in file /tmp/temp 1/OnDemand-Outgoing.xml.in, Line 2, Column 1:
invalid document structure
2023-07-05 17:47:17.205192: ARS4311E Loading failed
2023-07-05 17:47:17.205200: ARS4318E Processing failed for file >/tmp/temp1/OnD emand-Outgoing.xml.in<
2023-07-05 17:47:17.210905: ARS4327E Processing has stopped. The remaining fil es will NOT be processed.
-
Here's my JCL for loading the ODF IVP:
//STEP1 EXEC PGM=ARSLOAD,REGION=0M,
// PARM=('/-h ARCHIV3 -u odv733 -p /ars/stash -nfv
// -g "Daily sales invoices" /tmp/salesinvoice')
//STEPLIB DD DISP=SHR,DSN=ARS.ARSV1050.SARSLOAD
// DD DISP=SHR,DSN=DB2.V12R1M0.SDSNEXIT
// DD DISP=SHR,DSN=DB2.V12R1M0.SDSNLOAD
// DD DISP=SHR,DSN=DB2.V12R1M0.SDSNLOD2
//ARSBIN DD PATH='/usr/lpp/ars/V10R5M0/bin'
//SYSPRINT DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=134,BLKSIZE=134)
//*YSTCPT DD SYSOUT=* /* 2/23/19 debug parm */
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
Ed
-
If you go to this directory...
/usr/lpp/ars/V10R5M0/bin/xml/samples/
...you can look at samples of xml that will load.
The files with ebcdic in their name are easily viewable.
I see that your load has a capital E in the parms:
https://www.ibm.com/docs/en/cmofm/9.5.0?topic=arsload-parameters
Could that be getting in the way?
Ed
-
thank you , Identified issue . UTF-8 is Not accepted properly , We need to give IBM 1047 code page only when Index file is build using xml indexer .
One last question , What is max length of filed that can be defined in Application group ?>
-
> What is max length of filed that can be defined in Application group ?>
Are you asking the max length of a text field in the Application Group definitions?
I think if you go to the Administrative Client and look at the HELP for any field it'll tell you what the max is.
Ed
-
Thank you Ed ,
By Any chance Field value length can be extended or supported Until 50 to 75K length ?
-
No.
If you want it changed you need to submit an enhancement request via IBM Ideas:
https://ibm-data-and-ai.ideas.ibm.com/ideas
Ed
-
Also recommend you add the enhancement request here on the Enhancement Requests board:
http://www.odusergroup.org/forums/index.php/board,2.0.html
Ed