Search found 1419 matches

by asorrell
Tue Nov 27, 2018 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stuck DataStage Parallel Job
Replies: 1
Views: 2631

The VOCabulary hashed file is a very critical part of the "uniVerse" database that supports every DataStage project. It tracks a lot of critical pieces required in a working DataStage project. The top reasons you can't open VOC file are: - Someone deleted it (Very bad!) - Operating System ...
by asorrell
Wed Nov 21, 2018 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchical stage: Error 500 using Recursive to List
Replies: 4
Views: 3961

You didn't answer one of my questions - have you used this option before in another job?

I'd recommend proceed to step 4...

The "Caused by: java.lang.NullPointerException" message seems to indicate that something didn't install correctly.

I'd say it is time to open a ticket...
by asorrell
Wed Nov 21, 2018 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL file without copybook
Replies: 98
Views: 43366

When Franklin said "Map it to the copybook" I believe he meant FIX the copybook to make it reflect reality. Then use the Complex Flat File stage to read the data using the new copybook. You will probably need assistance from a COBOL programmer on the mainframe to help you do that, but it c...
by asorrell
Wed Nov 21, 2018 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 12c Update Jobs are failing with deadlock
Replies: 2
Views: 2930

Also check the exact release of both Information Server and Oracle and insure they are compatible. For example, Oracle 12c, Release 2 is only certified on Information Server 11.7 or higher. You can check the IIS requirements web page, be sure to check the "notes" icon as it will specify li...
by asorrell
Wed Nov 21, 2018 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hierarchical stage: Error 500 using Recursive to List
Replies: 4
Views: 3961

Hmm - I've used the stage a lot and never had that happen, so I don't recognize the error. It looks like it can't find the properties file in WebSphere that supports that option. Have you used that option on any other jobs? Since I can't give you specific recommendations, let's try a shotgun approac...
by asorrell
Wed Nov 21, 2018 7:54 am
Forum: General
Topic: Is there a licensing cost for the Connector Migration tool?
Replies: 5
Views: 4309

Ray - is it in Passport Advantage now?
by asorrell
Wed Nov 21, 2018 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migrate Netezza connector stage to Snowflake Connector stage
Replies: 1
Views: 2684

The Snowflake Connector has only been out for a few months on the latest release of Information Server (11.7). At this point you are probably one of the first customers working on a deployment. I'm just letting you know there's a low probability of getting assistance from someone with "hands-on...
by asorrell
Mon Nov 12, 2018 9:37 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How can I backup Information Analyzer assets?
Replies: 2
Views: 12251

The answer isn't simple. Information Analyzer uses several components including the XMETA repository and the IADB. You can start with this link: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.found.admin.burest.doc/topics/t_admin_backup_restore_super.html Are you try...
by asorrell
Wed Oct 10, 2018 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom transform routine - undefined symbol
Replies: 3
Views: 3182

The error was misleading. We had several problems that apparently combined to confuse the situation. The C routine had arguments that were unsigned char* and the parallel routine definition only supported char* . The same mismatch occurred for the return value. We used casting in the C routine to sw...
by asorrell
Thu Sep 27, 2018 9:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: custom transform routine - undefined symbol
Replies: 3
Views: 3182

custom transform routine - undefined symbol

We're working on a custom transformer routine that calls a custom C++ function. The C++ function has been compiled with the same compiler options as DataStage. We've got the lib path in the LD_LIBRARY_PATH, and in also put in the source and include paths just in case. The DataStage job fails at runt...
by asorrell
Tue Sep 11, 2018 8:17 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Backing up IADB
Replies: 8
Views: 16576

I would recommend doing the purge in very small chunks initially to determine timings / impact. The admin at a previous site initially kicked it off to purge an entire month and the purge process not only killed the system performance, it took forever to complete. We changed it to purge a day at a t...
by asorrell
Tue Aug 14, 2018 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Junk characters when moving data from VARCHAR to CHAR
Replies: 4
Views: 3428

Because you have not identified what kind of "junk" you are getting - my best guess is that your project is still using the default value 0x0 (Hex 0) for padding CHAR fields. CHAR fields are always automatically padded to their max length. Your job is probably using the default value from ...
by asorrell
Tue Aug 14, 2018 11:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage MD5 Implementation
Replies: 12
Views: 10778

I know I'm resurrecting an old thread, but just encountered this, and it IS now documented. The checksum stage does use MD5, but unfortunately the checksum stage changes the data being hashed without telling you so that it won't match an externally generated hash value unless they also add pipes to ...
by asorrell
Wed Aug 01, 2018 7:36 am
Forum: General
Topic: Information Integrator Connectors Install Info
Replies: 3
Views: 3158

Information Integrator was an old DB2 product that is now re-branded / renamed as part of WebSphere...

As far as I know, it is completely unrelated to DataStage licensing and DataStage connectors.
by asorrell
Wed Jul 25, 2018 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we copy Datasets from one server to another?
Replies: 11
Views: 7515

IBM's official answer:

How to move dataset from one server to another in IBM InfoSphere DataStage
https://www-01.ibm.com/support/docview. ... wg21392477