ARSLOAD DAEMON QUESTION.

[jeffs42885]

Currently, our arsload deamon runs as follows:

/usr/lpp/ars/bin/arsload -v -f -G DATASET -A MVS -d /Odfolder -c /Odfolder -h database -u oduser -t 120 &

our files come off of a custom dual loading process into the /Odfolder loading directory named as followed:

APPLICATION.1359147240519.APPLICATIONGROUP.APPLICATION_0.0.0.ARD

files get indexed based on whatever is defined in the index settings, mostly pdf/graphical indexer, or xenos. my question is this..

Is there any way I can modify the ARSLOAD daemon to accept files such as:

APPLICATION.ARD.out
APPLICATION.ARD.ind
APPLICATION.ARD

I have tried this once before but need to revisit. Any suggestions??

[sisusteve]

You can specify the format of your input file in ARSLOAD by using the following option:

        -B <filename_format> Format of input filename for parsing
                    WRI               WRITER
                    MVS               MVS
                    JOB               JOBNAME
                    DAT               DATASET
                    FOR               FORMS
                    YY                YYDDD
                    HH                HHMMM
                    AG                Application Group
                    APP               Application
                    IDX               Index [Note: can prepend to one field
                                                   above to identify for load
                                                   indexing]
                    IGN               Ignore
                    .EXT              Extension
           Example: For files in the default format
              MVS.JOBNAME.DATASET.FORMS.YYDDD.HHMMM.ARD
           format could be written as
              MVS.JOB.DAT.FOR.YY.HH.EXT
           or format could be written as
              MVS.JOB.IDXDAT.FOR.YY.HH.EXT


In your case I believe you would use -B AG.EXT or -B APP.EXT

[jeffs42885]

thanks mike. my question is..will arsload be able to specify the OnDemand application group via the app name? Also, can you provide a sample syntax..heres what I am thinking..Here is how our files come in currently..There is a java process that monitors the directory and does this.

APP.1360908996781.APP.AG_0.0.0.ARD

-B <filename_format>

-B APPNAME.HHHMMMYYDDD.AG.APP_0.0.0.ARD

[Greg Ira]

 "my question is..will arsload be able to specify the OnDemand application group via the app name?"
If you have a one to one relationship between application group and application you can get away with just specifying the application group but I don't think you can just specify application.

[jeffs42885]

Hey all, revisiting this again. I think I can script it, though my KSH scripting skills are still somewhat novice.

1) Can I query the database using the filename to determine the application group..example..AFPFILE.ARD...select AG from ARSAPP where AGID = ..... (Like I said..I am not good at this.. I know what I want to do but im having a hard time typing it!!)

once I have that, wouldnt it be a simple shell script to rename the file into something that the daemon can read..?

[pankaj.puranik]

Hi Jeff

Looking at your previous posts, it looks to me that the filename that you get from the upstream systems already has the AG name in it.

Going by your example, the file name is APP.1360908996781.APP.AG_0.0.0.ARD

So I would run the arsload as below as you already mentioned.

/usr/lpp/ars/bin/arsload -v -f -G DATASET -A MVS -d /Odfolder -c /Odfolder -h database -u oduser -t 120 &


" Can I query the database using the filename to determine the application group..example..AFPFILE.ARD...select AG from ARSAPP where AGID ="

Could you clarify on how would you get the AG name from the AFPFILE.ARD?
I am sorry but I didn't understand the approach you are trying to follow.
Please elaborate.

THanks
Pankaj.