Author Topic: ARSLOAD JCL Input from OMVS/USS  (Read 916 times)

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
ARSLOAD JCL Input from OMVS/USS
« 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 

maw

  • Jr. Member
  • **
  • Posts: 15
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #1 on: June 30, 2023, 11:04:40 AM »
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

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #2 on: June 30, 2023, 12:27:47 PM »
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.

                                     

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #3 on: July 04, 2023, 11:08:39 AM »
I also tried to Add Different XML declarations  ,All of them are failed with Same error .
Any One have suggestions 

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #4 on: July 05, 2023, 10:56:13 AM »
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.
                       

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #5 on: July 06, 2023, 10:32:18 AM »
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
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #6 on: July 07, 2023, 08:33:29 AM »
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
#zOS #ODF

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #7 on: July 11, 2023, 01:10:04 AM »
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  ?>

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #8 on: July 11, 2023, 10:32:22 AM »
> 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
#zOS #ODF

New-Z/osCMODuser

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #9 on: July 13, 2023, 05:17:27 AM »
Thank you Ed  ,
By Any chance Field value length can be extended or supported Until 50 to 75K  length ?

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #10 on: July 17, 2023, 10:12:35 AM »
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
#zOS #ODF

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: ARSLOAD JCL Input from OMVS/USS
« Reply #11 on: July 19, 2023, 10:44:04 AM »
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
#zOS #ODF