DSXchange

We would like to migrate from version 7.5.1a to DataStage to 8.1. The IBM installation guide mention that the earlier than Version 7.5.2, you must upgrade DataStage to IBM Information Server Version 7.5.3, and then you must upgrade to 8.1. But other IBM documention said that only version older 7.0 h...

Thank Ray, but the proplem is not related to the system resource.

My script can run normally outside DataStage. My problem is probablement related with the db2bp but I can't not found where it is.

Bonjour, I create a job that write data to a temporary DB2 table. For the performance reason, I create the table without index. To create the INDEX and make a RUNSTATS I tried to run an After Job with ExecSH but this is not working because I got the following DB2 error. *** Output from command was: ...

Thank !

How I can change the project configuration from monitore time base to size base monitoring.

Bonjour,

I was checked the TEMPORARY and SCRACH during the run with Unix command df -k.

Both directory are used only to 20%.

Thank !

When I used WRITE instead of LOAD. Is working fine.

I can't not check before or after the error, because the problem occur at different row on each run.

I tried to run with the @INROWNUM < 5000 and I got any problem !

Thank !

I do that,

First, I remove all stage and keep only a DS dataset and DB2 table.

I got the same problem.

Whem I write on to DS instead of DB2, everything is working fine.

This is relared when I tried to used the LOAD in the DB2 Stage!!!!.

Thank for your help !

I suspect a DB2 Deadlock because I can't found anything else.

My job fail with writing to pipe error or stock in DataStage and never ending.

This is a strange problem.

In test, where the volume was around 500 K I never got this problem.

Are you an idea, what should cause this problem ?????

Bonjour, I used the DB2 AIX V8 version with the DataStage 7.5. When I tried to LOAD a large volume of rows (more than 5 millions) in my DB2 table and I got this error "Error writing to pipe". I suspect a problem with the partition LOCK. I tried to used a .DS and .SEQ file but I got the sam...

Bonjour, I would like to use a STRING comparaison in a WHERE clause of FILTER stage but the result is always empties. The comparaison field is CHAR(10). When I use a numeric field every thing is working fine, but with a CHAR I got anything. ACTY_TYP='FLIGHT' (ACTY_TYP is CHAR) does't work but MKTG_P...

Yes I understand I can collect error to the reject file but in my stream if this condition will happen, I want to stop the processing with a ABORT.

Thank fro your quick reply !!!

Thank !

But When I call from command prompt I recieive a code 2, this mean a warning !

How I can know, if my job got this error if the return code is a warning ?

Bonjour, I run the DataStage PX with DB2 in the UNIX system. I create a job that insert to a DB2 table. When I ran my job twice I got the followed error from DB2 --> DB2 Driver Embedded SQL: -803; sqlcode = 23505; sqlstate = SQL0803N One or more values in the INSERT statement, UPDATE statement, or f...

Bonjour Amitava, Thank for your help. I already do that, but since the file name I receive every day contain the month and day (xx.xx.#MONTHDAY#.xx) in the file name, I have to change the name every day. So my question is how I can AUTOMATICALLY change this parameters before my job run on the daily ...

Bonjour, First of all, I'm just want to precise, I'm a new in the DataStage and Unix world, mainly I'm an OLD MVS COBOL programmer. :shock: I wrote a Parallel job that read in Daily input file from other system with the month and day as part of the name. I created a input parameter (xx.xx.#PROCESS_D...