DSXchange

Can anyone help us with ways to deal with hanging DB2 threads. It's as if DataStage is not cleaning up it's resources after an abort. The only way we can kill these threads is to bring db2 down. Is there a better way? Why do threads hang when using DataStage? UNIX 5.3 DB2 Version 8 DataStage 7.5.1 T...

What do you mean by pseudo column?

I am trying to combine input from a transformer stage along with a max id value from a db2 table in datastage. The information in the two inputs is not related to do a lookup on a key value. Has anyone ever done this?

You mentioned px conversions. Can you please elaborate? If you wish to take a date and see if it is a valid one, you have some Px conversions that will return an empty or null value when converting invalid inputs; this can be used as a type of validation. The Server variant of DataStage has two very...

If we have a date field that has a date value of 01/44/2005, how can I ask datastage to check the date and let me know if it's invalid? I'm looking for something that is similar to COBOL's 'DATE DATA.'

Hi!!

Is there a way to validate dates using DataStage?

Hello and thanks for reading :D How can I do a db2 roll back? I'm using DataStage 7.5.1 PX EE, Unix. I have a job that reads in a dataset (dataset stage) and sends the data to a udb/db2 stage for a table load. If the job bombs, DataStage does not terminate and roll back the load. How do I terminate ...

We use a star schema table structure. Once we load the "child" table, it gets put into check pending status. Right now one of our DBA's has to submit a DB2 command "set integrity" to get it out of check pending status. Is there a way in Datastage to get out of this check pending ...

Hello to everyone!! Thanks for reading this post!! Parallel - 7.0 - Unix This is the most difficult error I have tried to debug. Any help would be greatly appreciated. I get this error when I try to use a udb stage on server A and remotely connect to server B to read a table. We are able to remotley...

Hi, I have an error, but the log doesn't point out what the error is. Actually I don't get a fatal message at all, the job simply aborts. The job is a sequence job. I'm wondering if the phantom dir will provide more info. I can get drill down to the PH directory, but don't know what to do or how to ...

To compare two files from two different servers or lpars I use the ftp stage. The file are created by the same process, but different lpars (we do this to test upgrades and installs). Via the DS client I log into the test lpar and create a job that will bring the test file using a seq stage and the ...

Hi, how can I use the compare stage to compare files from 2 different lpars (same server box)? I currently have Datastage PX 7.0 installed on 2 laprs and access both lpars using the same client.

Thanks for your time!!!

Hello everyone

Thanks for your time.


Behind the scenes is the Datastage repository a file structure or is it DB2 tables? I'm not talking about the client side. I need to know the behind the scenes technical stuff.

Hello, thanks to all for answering my original post. My problem all along is due to a bug. I just found this out from Ascential. Below is the description from Ascential. The fix for the problem was something that required fixes in many different modules (That is why it could not be back ported to 7....

Hello to all that answered my original post. I think I have what I need for now. Thanks for your time and answers, it's greatly appreciated.



Thanks :D