DSXchange

You can call me dumb :D
But why do orchadmin command require APT_CONFIG_FILE set with the appropriate config file name, when the dataset descriptor file having the entire node configuration information?

Is it necessary that the exact configuration file name used to create dataset is set to APT_CONFIG_FILE, while deleting that dataset using orchadmin command? What will happen if any other file name is set?

Ouch.......
I thought it would be just a simple command that would return the needed. Anyways, thanks a bunch to you.

Hello, We are developing a shell script in our project to capture the latest value for a job parameter. We tried the command dsjob -paraminfo but it just returns the default value set in parameters section. How to find the latest value of a parameter through dsjob or any other shell commands? Your h...

You can use XML input stages to read the XML data and write into flat files. For that you would need to know the data present in the XML file thoroughly. Ample documentation also provided in the 'Help'.

Hi We have an issue in a parallel job that purges the records from a DB2 UDB table. We extract key columns from table1 and deleting records from table2. table1 and table2 have the same set of key columns. When the job is run, it is not deleting all the records in table2. It means that for each run, ...

Hi Thanks for all your inputs. I want the output to be displayed to stdout as it should be displayed in the system output log of the scheduler. But per Bland, it looks like we cannot do it straight forward as both stdout and stderr are controlled in a.ksh. I think we have to bypass using a 3rd scrip...

Hi, How to achieve this? Let us assume the following: There are 2 scripts a.ksh and b.ksh $ cat a.ksh sh b.sh 2>&1 >> /work/log/a_log.txt $ cat b.sh echo "abcd" My requirement is, is there a way to display this abcd in standard output also alongside of writing into a_log.txt? The catch...

Hi,

If the event ID cannot be resetted to zero , then is there any workaround using command line itself (dsjob) or do we need to develop a dummy job to call dsgetlogsummary() routine or to query DS repository?

Hi We too will encounter this problem. We are using this approach to capture the latest log information through shell scripts but when the event id exceeds 2,147,483,647, we suspect it will automatically get reset and we will end up getting some weird numbers. Is there any workaround for this like o...

Ray,

We need to schedule through Control-M scheduler and get the report once in every 15 minutes to find which job is occupying lot of ETL and database resources at that instance. Can it be done using Director Client?

Hi everyone

Is there any way to get a report in file format which has a list of all the jobs presently running in a particular DataStage server along with their project name and other details?

Hi We have a performance issue with a job. The job design is like this. This job reads a sequential file of 30 columns and a transformer assigns System Date and Time for two columns and also assigns a string constant for another column. Then a look-up is done on the table TABLE1 (where the records a...

Yes. It is very much possible because this error happens only during the weekends when all the schedules run simultaneously to load different data marts. But the error message in director conveys a different meaning. That is why I was confused a bit. Thanks to Ray and Arnd for their replies.

Hi Arnd

DB2 and ETL servers are installed in separate unix machines but all the users are given a read permission to that file. Also, job abends not happening always. They happen only occasionally and on rerun they finish successfully. That's why I am a bit confused.