DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 290 matches
Author Message
Workaround Reported
 Topic: Multiple records based on value in column
UCDI

Replies: 9
Views: 164

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 14, 2018 9:53 am   Subject: Multiple records based on value in column
Im open to C if you need it, but I would personally attack this one in excel if at all possible (to the point that I might even consider elimination of datastage entirely depending on the circumstanc ...
 Topic: How to prevent CHECKSUM stage to re-arrange column names
UCDI

Replies: 5
Views: 376

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 12, 2018 10:05 am   Subject: How to prevent CHECKSUM stage to re-arrange column names
can you DIY?

if you explicitly concat your data into a single column the checksum will be in the order you specify with any delimiters you specify (or not).

You can also toss the internal check ...
 Topic: DataStage w/ Linux CIFS Mounts
UCDI

Replies: 2
Views: 98

PostForum: General   Posted: Tue Feb 06, 2018 9:09 am   Subject: DataStage w/ Linux CIFS Mounts
you can do something cheezy like put a static text file out on the mount point in a shared location and all your jobs that touch that mount point can use a wait for file until it can see that, then p ...
 Topic: Error connecting to Big SQL
UCDI

Replies: 2
Views: 194

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 05, 2018 10:54 am   Subject: Error connecting to Big SQL
It does say why Smile The error code can be tapped online to see what the root causes and resolutions might be. This almost always leads back to a DBA, though, but at least you can see what is happen ...
 Topic: Unstructured Data Stage - X11 error
UCDI

Replies: 5
Views: 1710

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 05, 2018 10:49 am   Subject: Unstructured Data Stage - X11 error
We had similar problems with java issues and errors like this until we patched. this was for 11.5. Once patched, the problems just went away. Make sure you are up to date?

We are also on redhat ...
Resolved
 Topic: Fix pack install fails with error
UCDI

Replies: 2
Views: 105

PostForum: General   Posted: Wed Jan 31, 2018 9:38 am   Subject: Fix pack install fails with error
still there after a reboot?
 Topic: Data Copy Issue
UCDI

Replies: 11
Views: 322

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 31, 2018 9:22 am   Subject: Data Copy Issue
We also have had db2 memory problems for large tables, due to run-stats / indexing / rollback / etc problems.

A novel approach worked for us: we had our DBA copy the big tables and let our jobs ...
 Topic: Any way to export rules to Excel?
UCDI

Replies: 7
Views: 342

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Jan 18, 2018 1:39 pm   Subject: Any way to export rules to Excel?
its still fasttrack. But if your team isnt using it, it won't help, its a lot of work to maintain the mappings. We use it as storage for our source to target mappings and rules, but have had no luck ...
 Topic: Can't send an email with the Notification activity
UCDI

Replies: 3
Views: 233

PostForum: General   Posted: Thu Jan 18, 2018 1:04 pm   Subject: Can't send an email with the Notification activity
DataStage should have a setting somewhere on the server side on what to do for outgoing email. That appears to be set up incorrectly. Once that is configured, DataStage will use that email as outg ...
 Topic: Column to column comparison of DB2 and Hive tables
UCDI

Replies: 6
Views: 358

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 18, 2018 12:02 pm   Subject: Column to column comparison of DB2 and Hive tables
You can.

One way is to make a shared container with N input columns and M key columns.

You can use a transformer or modify or whatnot to rename your actual metadata columns to the temporary ...
 Topic: Any way to export rules to Excel?
UCDI

Replies: 7
Views: 342

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jan 12, 2018 10:01 am   Subject: Any way to export rules to Excel?
you can also export from fast-track to excel.
 Topic: Job from a Query
UCDI

Replies: 4
Views: 333

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 12, 2018 10:00 am   Subject: Job from a Query
you will need to take care here due to parallel processing. if you query the table and get max is 100, then try to insert 10 records on 4 nodes, you will then insert 101 4 times, 102 4 times, and 10 ...
 Topic: Intel Kernel design flaw / bug
UCDI

Replies: 6
Views: 324

PostForum: General   Posted: Mon Jan 08, 2018 1:27 pm   Subject: Intel Kernel design flaw / bug
we knew it was going to be brutal though. You can't really patch a CPU. The BIOS, but not the actual CPU chip. So they *have* to be jacking in a software solution that bypasses the hardware flaw ...
Resolved
 Topic: Select rows from table and use results as parameter to job
UCDI

Replies: 6
Views: 383

PostForum: General   Posted: Mon Jan 08, 2018 1:23 pm   Subject: Select rows from table and use results as parameter to job
Ibm's training class instructors flat out told us to not use server jobs as they were there for porting old code only, never for new work. Things like this get heard by people in charge who don't ac ...
 Topic: Hiding specific columns
UCDI

Replies: 7
Views: 658

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 28, 2017 12:06 pm   Subject: Hiding specific columns
sounds like a good place for a modify stage and RCP.
The final output can be RCP and you can drop the columns in the modify right before?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours