DSXchange

uvsh is used to run UV queries (Please correct if wrong) Well i am getting the following error ==> uvsh DataStage Command Language 7.5 Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved bin logged on: Wed Dec 16 03:37:41 2009 >SELECT * FROM DS_JOBS WHERE NAME LIKE 'djpLODD...

Does orchadmin copy command create a new data file? or just duplicates the descriptor file?

Is there any function to abort the job from within a transformer stage, if not then how can this be best achieved?

I am trying to perform Upsert using DB2 enterprize stage over a table which has 3 Primary key columns (Composite primary key) but while performing the upsert i have specified ony 2 out of the 3 key columns. It is aborting with a message that the third columns is missing in the input data set. How ca...

this is an error message which is causing the job to abort

"Aggregator_91,0: The current soft limit on the data segment (heap) size (2147483645) is less than the hard limit (2147483647), consider increasing the heap size limit"
This is the error i am getting.... Please advice how to overcome this.

Hi, I am using DB2 Enterprise Stage and want to create temporary tables and load them with some data before my actual query runs, i tried it using the Open command but no luck..... Can any one help??? and also if a job contains more than one DB2 stage, i guess a seperate session is created for each ...

Hi,

If i need to open a job which has been opened by some one else how to do it? If the other person has changed the content then how to save it and then open at my end?

How are NULL values stored in Hash files?

Is it possible to see the performance statistics of earlier run????

Is it possible to see the performance statistics of a previous run (the one before the current one) ???

I have logged into DS using one id and trying to connect to DB2 using different id. The job aborts saying Section Leader died after the max number of retries are made to the database.

Why is this so???

I am doing a look up on a hashfile and in log i can see that it is Private caching.....
What is the difference between Private caching and public caching???

the default size is 128 mb, how can i change this setting to a higher value for better performance?

What happens when a join is performed on pair of keys which donot have the same metadata, i think for a join to be performed only the column name should be the same and the metadata of the keys can be different. For Example a join is performed on column "KEY" which is char 10 in left link ...