Search found 14 matches
- Tue Nov 03, 2009 3:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To get loaded count in DB2 table
- Replies: 10
- Views: 3569
You didn't say what version of DB2 you're using but in DB2 LUW you should be able to specify an EXCEPTION table to capture rows that are not loaded (because they are duplicates for example). (Or in DB2 z/OS you can specify a DISCARD file which captures rows which are not loaded) You would need anoth...
- Wed Aug 12, 2009 4:52 am
- Forum: General
- Topic: DB2 on z/OS - Most Efficient Database Stage to Use
- Replies: 8
- Views: 6530
- Fri Jun 19, 2009 2:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job remote deployment - changing deployment target
- Replies: 1
- Views: 1619
Found out that a script called OshRemote.sh is written to the appropriate RT_SCxxx project directory on the DataStage server. This script contains the rsh command to run the job. The target hostname for the rsh command is in there. You have to recompile to regenerate this script. (Or you can edit th...
- Tue Jun 02, 2009 7:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Output Load Command to Log
- Replies: 3
- Views: 2098
You could try adding user defined variables:
I'm not too sure if they will help. They let us see the load instructions sent when loading DB2 z/os tables, don't know about DB2 UDB. Worth a try?
Code: Select all
APT_DB2LOADER_DEBUG=True
APT_DEBUG_DB2=True
- Tue May 26, 2009 4:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise Stage - Truncate Option
- Replies: 4
- Views: 3259
- Fri May 22, 2009 3:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job remote deployment - changing deployment target
- Replies: 1
- Views: 1619
Parallel job remote deployment - changing deployment target
We have a project configured for remote deployment of parallel jobs (through the "Remote" tab in Administrator). We're deploying jobs to USS on a mainframe. In development I'd like to be able to run parallel jobs on a different lpar on the mainframe from time to time. (for example we norma...
- Mon Apr 20, 2009 5:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference stage working
- Replies: 4
- Views: 3222
I know this thread is a few months old but thought I'd post what I have found out, having come up against a very similar issue. IBM support told me: when using the diff operator values from duplicate field names including key and value fields are copied from the before data set only. They also refer...
- Thu Jan 08, 2009 2:31 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Passing password parameter to DB2 Stage via Sequence
- Replies: 8
- Views: 9178
If you set the OSH_ECHO environment variable to true you will get a message in the Director log that shows the Orchestrate script for your parallel job. The password for your DB2 stages will appear as plain text (at least it does for me), which might help work out what is being passed when the job i...
- Thu Oct 09, 2008 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problems importing PxDB2 stage type
- Replies: 1
- Views: 1287
Re: Problems importing PxDB2 stage type
Got to the bottom of it, eventually. When I have exported the PxDB2 stage type from my production project, to try to apply it to development, the .dsx file has some missing fields. ... BEGIN DSSUBRECORD Name "operator" Description "Write to INSERT; Load uses fast DB2 loader technology...
- Thu Sep 18, 2008 5:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problems importing PxDB2 stage type
- Replies: 1
- Views: 1287
Problems importing PxDB2 stage type
Got a problem importing a stage type, the PxDB2. I discovered that the PxDB2 stage in a production project on a production server has extra options when compared to my dev project on the dev server. It looks like a patch was applied to production, but not dev. I've located the patch that delivered t...
- Fri Sep 28, 2007 2:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job design for n-way outer join??
- Replies: 7
- Views: 3244
- Thu Sep 27, 2007 7:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job design for n-way outer join??
- Replies: 7
- Views: 3244
I don't think I've explained myself very well :( . ...Since it is a full outer join, If there is a match then the both the values will be same. If one is null then there wont be a corresponding record from the second stream. Say Leftkey is null, no corresponding value from right stream, so rightkey ...
- Thu Sep 27, 2007 5:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job design for n-way outer join??
- Replies: 7
- Views: 3244
- Thu Sep 27, 2007 5:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job design for n-way outer join??
- Replies: 7
- Views: 3244
Job design for n-way outer join??
Hi there DSXCHANGE :D , Can anyone offer any advice on a job design to perform a n-way outer join? I have a job to build a datamart FACT table using various other tables. It does an 8-way outer join like this: DB2 UDB --> -> JOIN -->XFORM --> DB2 UDB --> > JOIN --> XFORM -- > DB2 UDB --> > JOIN --> ...