How can I index file based on the input filenam?

Previous topic - Next topic

abdeshpa

Hi,

Is there a way in OnDemand where I can index a file with the fields that are in the input filename.
Ex.
BT.REPORT.<REPORTTITLE>.<RPTDATE>.DATE.TIME.ARD

So based on the above filename, the ondemand should be able to index the file based on the information provided in <REPORTTITLE> & <RPTDATE>.

Thanks
Abhi

abdeshpa

Also, 1) if possible what would be the exact filename?
how will ondemand identify which nodes to take as the indexes.

2) Is there a way ondemand can create a .ind file based on the input filename?

rick

This could be accomplished by -b and -B options of arsload command.

abdeshpa

Why am I getting this error.

arsload -b RPTDATE -B APP.AG.IDXDT.IGN.EXT -fnv YYYYYY.XXXXXX.20140916.ARD.Failed
arsload: Processing file >YYYYYY.XXXXXX.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: Unable to add another index field to the data.  Data may be fully-composed or otherwise already indexed.
arsload: Processing failed for file >YYYYYY.XXXXXX.20140916.ARD.Failed<
arsload: Processing has stopped.  The remaining files will NOT be processed.

Justin Derrick

Are you sure you're using the -B option correctly?  I see four 'parameters' in your -B option, and three parameters in your file name.

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

abdeshpa

See below -

While using the Generic indexer.

arsload -b "RPTDATE" -B "APP.AG.IDXDT.IGN.EXT" -fnv XXX.YYY.20140916.ARD.Failed
arsload: Processing file >XXX.YYY.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: Unable to add another index field to the data.  Data may be fully-composed or otherwise already indexed.
arsload: Processing failed for file >xxx.yyy.20140916.ARD.Failed<
arsload: Processing has stopped.  The remaining files will NOT be processed.


after setting the PDF indexer in app.

arsload -b RPTDATE -B APP.AG.IDX.IGN.EXT -fnv xxx.yyy.20140916.ARD.Failed
arsload: Processing file >xxx.yyy.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: 09/17/14 17:45:20 -- Indexing started, 48225 bytes to process
ARS4901 FIELD1='Dummy'
ARS4901 INDEX1='DUMMY',FIELD1,(TYPE=GROUP,BREAK=YES)
ARS4905 INDEX1 parameter syntax incorrect
ARS4901 FIELD128 = '20140916'
ARS4901 INDEX128 = 'RPTDATE',FIELD128,(TYPE=GROUP)
ARS4901 parmdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.parm
ARS4901 inputdd=/edms/coolload/XXXXX01.YYYYYYY.20140916.ARD.Failed
ARS4901 outputdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.out
ARS4901 indexdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.ind
ARS4901 resobjdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.res
ARS4922 ARSPDOCI completed code 1
arsload: 09/17/14 17:45:20 Indexing failed
arsload: Processing failed for file >XXXXX01.YYYYYYY.20140916.ARD.Failed<
arsload: Processing has stopped.  The remaining files will NOT be processed.