DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1406 matches
Author Message
 Topic: DB2 Connector Stage - Client Required?
asorrell

Replies: 1
Views: 61

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 16, 2018 12:30 am   Subject: DB2 Connector Stage - Client Required?
You will need to install the DB2 client software. You can usually use the newest client, but confirm that it is compatible and supported by your DB2 database version as well as your DataStage versi ...
 Topic: Oracle ODBC alternative server
asorrell

Replies: 6
Views: 117

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 16, 2018 12:15 am   Subject: Oracle ODBC alternative server
What you are describing is only done automatically (and transparently) if your Oracle database is using Oracle Real Application Cluster (RAC) software that is separately purchasable.

If you have an ...
 Topic: Data Lineage v Business Lineage v Blueprints
asorrell

Replies: 4
Views: 2568

PostForum: MetaData and IBM MetaData Workbench   Posted: Sun Apr 15, 2018 11:56 pm   Subject: Data Lineage v Business Lineage v Blueprints
Wow... You really necro'd this dead thread from 2013... and I believe BluePrint Director is dead as well. It is in 11.3, but not visible in 11.5 or later. I never saw an announcement, it just disap ...
 Topic: A weird problem with Change Capture stage
asorrell

Replies: 7
Views: 364

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 04, 2018 2:41 pm   Subject: A weird problem with Change Capture stage
...after sitting here and staring at my answer while the site slowly attempts to move elsewhere...

Just got them to reboot the server. MUCH better now...
 Topic: BigIntegrate in Hadoop - Dataset stage vs BDFS stage
asorrell

Replies: 2
Views: 315

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 03, 2018 12:04 pm   Subject: BigIntegrate in Hadoop - Dataset stage vs BDFS stage
Per what Arndt said, the descriptor file is tiny - it just describes where the parts are - no impact on performance.

The data portion of the dataset may actually be located in HDFS. That depends ...
 Topic: Memory usage by lookup stage
asorrell

Replies: 1
Views: 220

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 02, 2018 9:36 am   Subject: Memory usage by lookup stage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
So, I informed a developer that the lookup stage (non-sparse) should typically be used when referencing data in smaller tables, which allows the structure to fit into memory.

He asked two very goo ...
 Topic: Spambot
asorrell

Replies: 29
Views: 3478

PostForum: Site/Forum   Posted: Mon Mar 26, 2018 4:40 pm   Subject: Spambot
Banned and deleted!
 Topic: IIS on Hadoop Recommendations
asorrell

Replies: 1
Views: 275

PostForum: General   Posted: Wed Feb 14, 2018 12:26 pm   Subject: IIS on Hadoop Recommendations
If you are going to move to Big Integrate on Yarn, the Hadoop environment needs to be configured to support BI from the start. The Hadoop team will probably not like some of the changes that need t ...
 Topic: Error connecting to Big SQL
asorrell

Replies: 2
Views: 445

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 02, 2018 12:43 pm   Subject: Error connecting to Big SQL
SQLState 40504: A system error has caused the unit of work to be rolled back.
SQLCode -1229: The current transaction has been rolled back because of a system error.

https://www.ibm.com/support/kno ...
 Topic: Any limit on XML Schema Library size?
asorrell

Replies: 2
Views: 301

PostForum: General   Posted: Fri Feb 02, 2018 12:23 pm   Subject: Any limit on XML Schema Library size?
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I am assisting a client with loading some highly qualified XML schemas that came from a vendor. The schemas contain import statements to load other "sub"-schemas. And of course, the sub-schemas ha ...
 Topic: Spambot
asorrell

Replies: 29
Views: 3478

PostForum: Site/Forum   Posted: Wed Jan 31, 2018 2:35 pm   Subject: Spambot
...Who in their right mind...".

“No one ever went broke underestimating the intelligence of the public.”

H.L. Mencken 09/19/1926

That's a paraphrase, his actual quote was: "No one in this wo ...
 Topic: Capturing CDC logs into a table
asorrell

Replies: 3
Views: 373

PostForum: General   Posted: Mon Jan 29, 2018 9:45 am   Subject: Capturing CDC logs into a table
What you are being asked to do is already performed by an IBM product that is integrated in DataStage:

InfoSphere Change Data Capture
An efficient change data capture using IBM InfoSphere CDC Tran ...
 Topic: DataStage 8.7 and Oracle 12.1
asorrell

Replies: 3
Views: 347

PostForum: General   Posted: Mon Jan 29, 2018 9:28 am   Subject: DataStage 8.7 and Oracle 12.1
Yup - 8.7 went "EOS" (End of Service) on April 30, 2017.

I checked the Oracle client / database compatibility matrix which says the Oracle 11.2 client is certified to access the Oracle 12 databas ...
 Topic: Spambot
asorrell

Replies: 29
Views: 3478

PostForum: Site/Forum   Posted: Mon Jan 29, 2018 9:02 am   Subject: Spambot
Banned ploy2018 - deleting posts now...

edit: Done! thanks for the text!
 Topic: Stored Procedure stage with Longvarchar (CLOB)
asorrell

Replies: 16
Views: 1443

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jan 23, 2018 3:18 pm   Subject: Stored Procedure stage with Longvarchar (CLOB)
Yes - you might have to establish some sort of key structure / row count in order to reassemble the chunks.

Just realize - if the resulting data record including the re-assembled CLOB exceeds 128K ...
 

 Jump to:   



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