Search found 42189 matches

by chulett
Fri Sep 25, 2015 6:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FIELD function
Replies: 5
Views: 2007

Thought that went without saying. :wink:
by chulett
Fri Sep 25, 2015 6:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01722
Replies: 2
Views: 2689

That's not a "workaround", at least not in my book.
by chulett
Fri Sep 25, 2015 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server Deadlock Error
Replies: 11
Views: 5191

Perhaps "we" should be having this conversation with prasad, could have sworn this was their thread.
by chulett
Fri Sep 25, 2015 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FIELD function
Replies: 5
Views: 2007

So... the second comma delimited field is First and Middle. Pull that and then use Field again on that telling it is a space delimited string: 1=First and 2+=Middle. Now that won't always work but it should get you close enough so you can then identify the outliers.
by chulett
Fri Sep 25, 2015 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: X Connector to Y Connector migration?
Replies: 5
Views: 2292

Assign multiple people. :wink:
by chulett
Thu Sep 24, 2015 1:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_PERFORMANCE_DATA
Replies: 5
Views: 2645

Have you been through Chapter 3. Improving performance of the Parallel Job Advanced Developer's Guide pdf? It's discussed there in a fair amount of detail.
by chulett
Wed Sep 23, 2015 8:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server Deadlock Error
Replies: 11
Views: 5191

Then it sounds like you didn't hash on the correct columns... the keys in your target.
by chulett
Wed Sep 23, 2015 8:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can't read a seq. file created in a server job in a Px job
Replies: 9
Views: 3227

I don't think it would hurt to post it here. You'll need a screenshot / snippet of it uploaded to a file sharing site (like say Imgur) and then use the BBCode Image tags to link it in here.
by chulett
Wed Sep 23, 2015 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server Deadlock Error
Replies: 11
Views: 5191

Today's hint is "partitioning". Confirm that by running the job on a single node.
by chulett
Wed Sep 23, 2015 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Job stalled
Replies: 7
Views: 2742

Isolation levels are about the locks that are (or are not) taken during the session.
by chulett
Tue Sep 22, 2015 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can't read a seq. file created in a server job in a Px job
Replies: 9
Views: 3227

Do you have the Server file metadata? Have you tried the 'Sync Parallel' option on it to populate the 'Parallel' tab with what your parallel job would need?
by chulett
Tue Sep 22, 2015 8:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: New and deprecated parallel transform functions
Replies: 7
Views: 3391

priyadarshikunal wrote:but why not update the same functions rather than using a new one?
Backwards compatibility.
by chulett
Tue Sep 22, 2015 7:50 am
Forum: General
Topic: Cognos Data Manager to DataStage
Replies: 7
Views: 5687

Interesting and seems to be new as of June? From the video's description: The Migration Assistant is a new feature added to IBM Cognos Data Manager 10.2.1 to help customers migrate their Data Manager (DM) solutions to IBM InfoSphere DataStage (DS). It is envisaged that the tool is used as part of a ...