DSXchange

Yes I understand this. My problem is that due to the Stage variable being reset by partition, I can't keep an incremental value from 1 through ~. I am looking for a possible solution on this. I assume there must be a way to increment a value from start to end record of a file.

I am trying to create a DB2 commit incremental value of 2000. Every 2000 records processed, I write a commit transaction to a temp file. I tried the @INROWNUM, Stage Variables and simple Var + 1 mechanism only to be shut out due to partitioning. Every time a new partition is hit, the @INROWNUM, Stag...

If we know that DB2 commits every 2000 records, do you think it's possible to keep the 2000th record in a temp file and replace it every commit. If the system aborts, DB2 will rollback to the last commit, we now have the committed record in a temp file, could we not move forward from there. Just a t...

We are loading a DB2 on the mainframe. It is not loaded in parallel, it is loaded sequentially. I don't know if this make a difference. I hope another client has faced the same dilemma and does have a solution because i can't find a documented answer.

If a DS job is inserting records into a DB2 table and the DB2 Connect suddenly aborts causing records to get thrown out back to the last commit. Is there a way to restart the job, starting from the last commit and how can I determine where the job should restart from. Some posts tell me to keep trac...

I have searched and read all articles related to this, even the Leakage article and still I can't find an example on how to capture rejects due to duplicate entries. As I am still learning the product, I can't find any good examples on how to set this rejectlogic up. I create a test job where I read...

We are using the Enterprise stage.

Cleanup and Re-installation of the product fixed the problem. We think it was corrupt files that cause the error.

The process reads a DB2 table and creates a dataset file. That all. When viewing the DB2 table, we can see the input. The transformer stage substrings the data and it passes the data for dataset creation. This job worked previously. We are currently re-install the software.

We re-installed DataStage PX and cannot get any jobs to run. We get the following error (which is not much). Could someone please explain what the problem may be. Thanks Starting Job IBQ_Create_Seq_TIAXSCT. PASSWORD = ******** Attempting to Cleanup after ABORT raised in stage IBQ_Create_Seq_TIAXSCT....

Is there a way to default the input DB2 reads to "Uncommitted Read"? I looked the environment variables and couldn't find the settings.

Thanks

Yes read... We went over the documentation numerous times. Just like the compiler. If your using the .NET 2003 version, the docs tell you to add extra code to the environment variables. When we added the code, the compiler aborted. We removed the extra code and everything work fine. Yes, documentati...

Hi all, The answer for DB2 was a port issue. The default that the Information Server install provides is 50001. This did not work because our limit was 50000. We used another port 33... and the install worked. We also made sure that we did not use the same port as the DB2 Connect port. This was a pr...

We have been trying to upgrade to version 8.0 with no success so far. Maybe someone has had the same issue and could help. We contacted IBM but the issue still exist. Problem: When we run the installation, we receive errors from the creation of the DB2 metadata repository. We currently have version ...

Thanks, I am extracting from a DB2 table. I searched more posts and used a previous solution. Stage variable did the trick.