DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1004 matches
Author Message
 Topic: waitForWriteSignal(): Premature EOF on node
Mike

Replies: 8
Views: 320

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 07, 2017 6:26 pm   Subject: waitForWriteSignal(): Premature EOF on node
You've told the aggregator to expect sorted data. So have you partitioned and sorted the data by the keys that the aggregator is using? Have you set up your funnel stage to preserve the sort order if ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 446

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 2:33 pm   Subject: Update SK Files with last surrogate Key values
Can't really say what your issue might be without actually looking over your shoulder. But in your example, the originally updated 16 byte surrogate key file should show
2004 2004 when viewed with th ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 446

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 9:30 am   Subject: Update SK Files with last surrogate Key values
The Surrogate Key Generator stage results in a sequential operator, so the number of processing nodes shouldn't matter. Partitioning is not needed or wanted.

I still use my default parallel configu ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 446

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 9:21 am   Subject: Update SK Files with last surrogate Key values
Then you did not successfully start with an empty state file.

It will have a length of 0 when it is empty. After your update it should have a length of 16.

Use an ls -l mystatefile to check file ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 446

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 7:41 am   Subject: Update SK Files with last surrogate Key values
There are quite a few nuances to the surrogate key generator stage. It actually includes some interesting flexibility. You would have to spend some time experimenting to learn all of the nuances.

I ...
 Topic: Generate sequence number using parallel job
Mike

Replies: 6
Views: 460

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 21, 2017 7:08 am   Subject: Generate sequence number using parallel job
Did you use round robin partitioning method?

Mike
 Topic: code version check
Mike

Replies: 4
Views: 342

PostForum: General   Posted: Tue Jun 20, 2017 6:45 pm   Subject: code version check
I've gone with a 2 step approach for identifying version change candidates.

Step 1 is to compare the modification timestamps using XMETA. These are the same modification timestamps that you would s ...
Resolved
 Topic: Unable to find Java Technology Edition software
Mike

Replies: 2
Views: 200

PostForum: General   Posted: Fri Jun 16, 2017 7:28 am   Subject: Unable to find Java Technology Edition software
I haven't done an 11.5 install yet, but for all other versions that I have installed the required IBM java is part of the installation package. You just have to follow the installation instructions an ...
Resolved
 Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
Mike

Replies: 13
Views: 596

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 15, 2017 9:41 am   Subject: Fatal Error: Attempt to setIsNull() on the accessor interfac
Nice job of narrowing down the cause.

It's good to know that a failed cast function in the ODBC Connector results in NULL.

You mentioned AS400, so is your underlying database DB2?

Mike
Resolved
 Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
Mike

Replies: 13
Views: 596

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 14, 2017 7:47 am   Subject: Fatal Error: Attempt to setIsNull() on the accessor interfac
Unfortunately the report of schemas generally gets lost when the job aborts.

1) Verify that you have no column metadata defined in the ODBC connector.
2) Verify that the sql select statement doesn ...
 Topic: Sequence x Job with ParameterSet
Mike

Replies: 7
Views: 379

PostForum: General   Posted: Fri Jun 09, 2017 1:44 pm   Subject: Sequence x Job with ParameterSet
Unfortunately the job activity is lacking in flexibility when it comes to parameter sets. You are essentially stuck with 3 options: choose "As Predefined", choose a values file name from the drop-down ...
Resolved
 Topic: Handling non English characters while using substring
Mike

Replies: 6
Views: 469

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 07, 2017 8:11 am   Subject: Handling non English characters while using substring
As you see, bytes and characters have a variable ratio when you are dealing with UTF8. Characters will range in size from 1 to 4 bytes. Your 30 byte column in Oracle could potentially hold as few as 7 ...
Resolved
 Topic: Handling non English characters while using substring
Mike

Replies: 6
Views: 469

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 07, 2017 6:36 am   Subject: Handling non English characters while using substring
UTF8 and bounded varchars come with the sort of baggage that you're seeing. That's due to UTF8 having a variable number of bytes per character. You should switch to nvarchar (or the equivalent of addi ...
Resolved
 Topic: Accessing IE during Information Server installation on Linux
Mike

Replies: 5
Views: 422

PostForum: General   Posted: Sat Jun 03, 2017 5:36 pm   Subject: Accessing IE during Information Server installation on Linux
If you want to use the Internet Explorer browser for installing on Linux, you'll be running it on a remote Windows computer. You can of course choose to use a browser on the local Linux computer, but ...
 Topic: Filter through Complex Flat file stage
Mike

Replies: 3
Views: 378

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 02, 2017 12:19 pm   Subject: Filter through Complex Flat file stage
That filter option is where you would put a UNIX command to operate on your file (not going to be much use on a binary file).

You could use a transformer constraint after the CFF stage.

The cons ...
 

 Jump to:   



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