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??
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
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
"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.
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..?
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.