DSXchange

I recently installed Information Server and Information Analyzer - I configured .odbc.ini file to point to database. Logging thru IA i was able to create a project and able to import metadata, schema and one sample table. When i try to submit to do Column analysis for profiling, datastage jobs are f...

cwong,

Were you able to resolve the issue. We installed IA but ANALYZEPROJECT is not created during install process. Are there any scripts which could be run to create the Project or can we create the project manually?
Or do we need to un-install and re-install?

Thanks

Thanks for the information.

Are there any scripts to create the IADB ? If so, where are they located?

During our v8.1 installation we did not install Information analyzer.

Can someone tell us the process to add a component e.g. Information Analyzer? Do we need to create IADB before we install IA?

What are the steps?

Thanks

Thanks Craig !!

Hi, We have around 2500 jobs in our DataStage project and would like to set purge settings for all jobs. right now we do not have any kind of auto purge setting enforced. If we set the auto-purge setting now, it would not affect the old jobs and they would still require auto-purge enabled. What is t...

This behaviour usually occurs because the job is still receiving and logging warnings from, for example, a connected database server. I also thought of the same thing and ran the logsum command to find out if any Warnings were being generated for this job. $DSHOME/bin/dsjob -logsum -type WARNING -m...

Sometimes it does that but to remove that running status go to director under the job tab click on cleanup resources select your job under that and kill it.Then click on clear status file under job tab and it would reset the status from running to compiled. Okay, issue was resolved , thanks. we log...

One of the parallel job is showing weird status in director. It shows Running status, in logs it shows this message: main_program: Step execution finished with status = OK. From unix it also shows as running when I grep for the PID. But when I ran this command from Unix I get some weird results $DSH...

Hi Ravindra,

I have also pretty much same kind of requirement you had.
I hope you might build a solution for your requirement, if so can you share how you did ?

Thanks,

Hi Pattemk,

I have same kind of requirement, is it possible for you to share your dsx file reference?
Apprecaite

HI Ray,

I looked at Schema File in PX developer guide, it doesn't provide a sample job.

Does any one have a sample jobs?

Thanks,

13 records listed
13 record copied
1 records DELETEd.

Thanks Ray. You are great.

1 records listed.


Output Format
----------------

15T

First Insert statement entered
Command Output: Please advise.