DSXchange

Hi ,

Can any one please let me know which environment variable can be used to make the DataStage job log display the amount of time a particular stage consumes during a job run ?

Thanks and Regards

Avik Dasgupta

Hi , I am having a job where a table is being updated in a Oracle connector stage. The error the job is throwing : ORA-00060 dead lock detected while waiting resource The oracle connector stage is run in sequential mode and the array size is set 1 to avoid the duplicate delete key problem.Even after...

Hi , In my job I am inserting some records to a oracle table using Oracle connector stage.Requirement is that either all records are inserted successfully or the the entire transaction is rolled back.For example : I have 4 records to insert ,one of them violates unique constrain.In this case the ent...

Hi , In the job we are using sequential file stage to read data.Number of readers per node is defined as 24. Now it is throwing the error message : Cannnot use multiple readers :The file lentgh is not a multiple of record length. Should I make "Number of readers per node " =1 ? Please let ...

In addition to that :

When I ran the same command as dsadm user ,it worked perfectly

Hi , I set the value of APT_CONFIG_FILE variable to apt file for the project. I also sourced the dsenv file.I followed the same process while working in Datastage 8.1 environment and that worked perfectly there.I am facing the problem in the 8.5 environment only which is newly set up.Is there any po...

Hi , I am trying to read a dataset from command line using orchadmin utility. I am able to successfully execute the "describe" command .But whenver I am using the orchadmin utility to dump the content of the dataset I getting error. This is the command I am executing : orchadmin dump /u/In...

Hi , I have a job where there are two input datasets which act as before and after dataset for a change capture stage.Output of the change capture stage is stored in a dataset.The two input links of change capture stage are sorted and hash partitioned on the key column. The job is part of a sequence...

Hi Roland ,

Thanks a lot

Regards

Avik

Hi Roland, Thanks for your explanation .I got your point. There is another similar scenario ,the only difference is the second stage is aggregator stage.That means the remove duplicate and aggregator stage are placed side by side .The key for the first stage is A,B columns and for second stage is B....

Hi , In my job two stages - remove duplicate and join stage are placed side by side. I have done key based hash partitioning for the first stage (remove duplicate).The key for the first stage(remove duplicate) is columns A and B.For the next join stage the key is B. My query is do I need to again re...

Hi , We have a job which reads data from a dataset and writes to DB2 table.We have used DB2 connector stage.The number of records is bit high ,more than 3000000. The job is running for more than half an hour before it is aborting .Following is error message it is throwing : Str_Item_Fcst_Parm_DBCon:...

Hi , I am having a job which consists of 5 lookup stages ,5 transformer stages,2 input datasets and one output dataset.One of the input datasets is having 5049590records and another one is having 0 records. The job is throwing following run time error ; Failure during execution of operator logic Sho...

Hi , We developed datastage jobs in Datastage Release 8.1 in development environment.Now we are are planning to export the jobs to QA environment which is Datastage Release 8.5. By general rule it should be backward compatible.I need to know if there are any aspects which we need to take care of . T...

Hi all, previously my data stage server was connecting to a db2 8 server.Recently new db2 database(version 9) have been installed with the seperate db2 instance in the same machine where db2 8 was installed.So currently 2 database instances running in the same machine. The db2 client which is instal...