Answered question
This question has been answered.
Unanswered question
This question has not been answered yet.
Can anyone please give the command to run a column analysis using command line..by using iaJob as well as iaadmin,
In the documentation from what I understood they are asking to use the command -runbundle bundleNAme. If so can you please mention how to go about creating the bundlename and run bundle.
can you explain the same with an example...............
This is the accepted answer.
This is the accepted answer.
First for using IAAdmin here is the command to run column Analysis jobs.
C:/IBM/InformationServer/ASBNode/bin/IAAdmin.bat -user <userName> -password <password> -host <HostName> -port <portNo> -runTasks -content <locationOfXMLfile>
Now the contents of the xml file is explained in the docuement
<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi"
name="
projectName">
<Tasks>
<RunColumnAnalysis>
<Column name="BANK.BANK1.*.*"/>
<Column name="BANK.BANK2.TABLE1.*"/>
<SampleOptions type="every_nth" size="1000" nthvalue="10"/>
<Schedule startDate="2010-02-09T18:56:31+01:00"
runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10">
<ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*"
month="*" dayOfWeek="?" year="*"/>
</Schedule>
</RunColumnAnalysis>
</Tasks>
</iaapi:Project>
The following options are not mandatory if we don't want to schedule.
<SampleOptions type="every_nth" size="1000" nthvalue="10"/>
<Schedule startDate="2010-02-09T18:56:31+01:00"
runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10">
<ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*"
month="*" dayOfWeek="?" year="*"/>
</Schedule>
If we want run column analysis for just once column.
following is the syntax for column name
<Column name="BANK.BANK2.TABLE1.COLUMN1"/>
By using these we can run column analysis from command line.
Now for iaJob.bat
following link has information on how to use it
Now the command to run is
iaJob -user
username -password
password -isHost
hostname -port
port_number
-runBundle locationOfBundle
and the following link has some more information for creation of bundle.
It is given for data rule bundle. You can follow the same steps for column analysis as well.
Scheduling remains same for column analysis and data rules as well.
thanks,
Satyanandam
This is the accepted answer.
This is the accepted answer.
- SatyanandamKotha
- 2013-05-08T05:43:11Z
First for using IAAdmin here is the command to run column Analysis jobs.
C:/IBM/InformationServer/ASBNode/bin/IAAdmin.bat -user <userName> -password <password> -host <HostName> -port <portNo> -runTasks -content <locationOfXMLfile>
Now the contents of the xml file is explained in the docuement
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<?xml version="1.0" encoding="UTF-8"?> <iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name=" projectName"> <Tasks> <RunColumnAnalysis> <Column name="BANK.BANK1.*.*"/> <Column name="BANK.BANK2.TABLE1.*"/> <SampleOptions type="every_nth" size="1000" nthvalue="10"/> <Schedule startDate="2010-02-09T18:56:31+01:00" runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10"> <ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*" month="*" dayOfWeek="?" year="*"/> </Schedule> </RunColumnAnalysis> </Tasks> </iaapi:Project></pre>
The following options are not mandatory if we don't want to schedule.
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<SampleOptions type="every_nth" size="1000" nthvalue="10"/> <Schedule startDate="2010-02-09T18:56:31+01:00" runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10"> <ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*" month="*" dayOfWeek="?" year="*"/> </Schedule></pre>If we want run column analysis for just once column.
following is the syntax for column name
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<Column name="BANK.BANK2.TABLE1.COLUMN1"/></pre>By using these we can run column analysis from command line.
Now for iaJob.bat
following link has information on how to use it
Now the command to run is
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_65" tabindex="26">
iaJob -user username -password password -isHost hostname -port port_number -runBundle locationOfBundle</pre>
and the following link has some more information for creation of bundle.It is given for data rule bundle. You can follow the same steps for column analysis as well.
Scheduling remains same for column analysis and data rules as well.
thanks,
Satyanandam
Hi,
Thank you so much
This is the accepted answer.
This is the accepted answer.
- SatyanandamKotha
- 2013-05-08T05:43:11Z
First for using IAAdmin here is the command to run column Analysis jobs.
C:/IBM/InformationServer/ASBNode/bin/IAAdmin.bat -user <userName> -password <password> -host <HostName> -port <portNo> -runTasks -content <locationOfXMLfile>
Now the contents of the xml file is explained in the docuement
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<?xml version="1.0" encoding="UTF-8"?> <iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name=" projectName"> <Tasks> <RunColumnAnalysis> <Column name="BANK.BANK1.*.*"/> <Column name="BANK.BANK2.TABLE1.*"/> <SampleOptions type="every_nth" size="1000" nthvalue="10"/> <Schedule startDate="2010-02-09T18:56:31+01:00" runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10"> <ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*" month="*" dayOfWeek="?" year="*"/> </Schedule> </RunColumnAnalysis> </Tasks> </iaapi:Project></pre>
The following options are not mandatory if we don't want to schedule.
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<SampleOptions type="every_nth" size="1000" nthvalue="10"/> <Schedule startDate="2010-02-09T18:56:31+01:00" runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10"> <ScheduleRepeat second="0" minute="0" hour="12" dayOfMonth="*" month="*" dayOfWeek="?" year="*"/> </Schedule></pre>If we want run column analysis for just once column.
following is the syntax for column name
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_92" style="background-color: rgb(218, 218, 218); padding: 5px; white-space: pre-wrap; word-wrap: break-word; color: rgb(0, 0, 0);" tabindex="47">
<Column name="BANK.BANK2.TABLE1.COLUMN1"/></pre>By using these we can run column analysis from command line.
Now for iaJob.bat
following link has information on how to use it
Now the command to run is
<pre class="pre codeblock" dir="ltr" id="vcc_sp_pre_65" tabindex="26">
iaJob -user username -password password -isHost hostname -port port_number -runBundle locationOfBundle</pre>
and the following link has some more information for creation of bundle.It is given for data rule bundle. You can follow the same steps for column analysis as well.
Scheduling remains same for column analysis and data rules as well.
thanks,
Satyanandam
Hi,
I am using IA 9.1.2. Can you please let me know the order of the column name?
<Column name="BANK.BANK2.TABLE1.COLUMN1"/>
Am using - "DataStoreName.DatabaseName.Schema.Table.ColumnName " on the XML file and running using the CLI.
The error is: "Resource not found.
Please let me know what the correct format is.
Thanks,
Visa
