Search found 516 matches

by rkashyap
Thu Sep 22, 2016 10:43 am
Forum: General
Topic: .isx Import issue Information Server Manager
Replies: 6
Views: 5428

I have applied the patch JR55200 and the issue is resolved.

Note that this is a Client tier only patch. The readme.txt file incorrectly states that this patch needs to be installed onto ALL tiers.
by rkashyap
Wed Sep 21, 2016 2:18 pm
Forum: General
Topic: .isx Import issue Information Server Manager
Replies: 6
Views: 5428

Thanks. This technote helps. I have raised a support ticket for this.
by rkashyap
Wed Sep 21, 2016 11:21 am
Forum: General
Topic: upgrade 11 problem
Replies: 8
Views: 5087

See this post.
by rkashyap
Wed Sep 21, 2016 9:02 am
Forum:
Topic: Data Dictionary for XMETA database
Replies: 6
Views: 5421

In earlier versions than 11.x you could use Metadata Workbench to get a model of the metadata repository, but this seems to have disappeared from Information Governance Catalog in version 11.x. :cry: If someone has used pre 11.X version of Metadata Workbench to generated a model of the metadata rep...
by rkashyap
Wed Sep 21, 2016 8:49 am
Forum: General
Topic: Annotations: Cannot change Border to invisible.
Replies: 8
Views: 4980

I agree.:-) As per documentation, this prehistoric bug is fixed in 11.5, but apparently not.
by rkashyap
Tue Sep 20, 2016 4:15 pm
Forum: General
Topic: Annotations: Cannot change Border to invisible.
Replies: 8
Views: 4980

Annotations: Cannot change Border to invisible.

This is more of an annoyance in 11.5 ... it is not possible to make the border of annotations invisible. i.e. If in Annotation stage properties, the Border Visible checkbox is unselected and subsequently the job is saved and closed. When the job is reopened, the "unselection" is not preser...
by rkashyap
Tue Sep 20, 2016 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error deleting datasets
Replies: 11
Views: 5021

This technote will help you.

You can also delete datasets by invoking Data Set Management utility in either DataStage Designer or Director client.
by rkashyap
Tue Sep 20, 2016 2:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 11.5.0.1: Oracle Join Predicates are considered table-names.
Replies: 1
Views: 2677

11.5.0.1: Oracle Join Predicates are considered table-names.

Issue : In DataStage 11.501 sometimes, if a space is not given around Join condition symbol (<, =, > etc), then at run-time Oracle Connector stage parser considers "Join Predicates" as a table-name and fails a valid SQL statement. Example: Following SQL fails at run-time in a DataStage jo...
by rkashyap
Tue Sep 20, 2016 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 11.501:Oracle Partitioned Read(Backward compatibility issue)
Replies: 2
Views: 2336

IBM has released patch JR56688for addressing this issue.
by rkashyap
Fri Jul 29, 2016 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading parent and child tables using the same connector
Replies: 1
Views: 2665

Yes, this is doable. Also see section titled 'Local transactions with database connectors' in Guaranteed delivery with InfoSphere DataStage.
by rkashyap
Thu Jul 21, 2016 2:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 11.501:Oracle Partitioned Read(Backward compatibility issue)
Replies: 2
Views: 2336

Engineering is looking into this issue. I will post updates in this forum.
by rkashyap
Thu Jul 21, 2016 2:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Vertical Pivot
Replies: 6
Views: 4807

Could you share the requirement in words. Examples are good, but only in conjunction with a requirement description. ;-)
by rkashyap
Thu Jul 14, 2016 2:53 pm
Forum: General
Topic: Fallen Premium Poster: Kim Duke
Replies: 32
Views: 27423

May his soul rest in peace. DataStage users will always be indebted to the man behind the ETLStats library.
by rkashyap
Mon Jul 11, 2016 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 11.501:Oracle Partitioned Read(Backward compatibility issue)
Replies: 2
Views: 2336

11.501:Oracle Partitioned Read(Backward compatibility issue)

During testing of 11.5.0.1, we found that jobs with Oracle Connector partitioned reads fail with the error given below. These jobs worked fine in DataStage 9.12. Error message: ORA-00904: "FACT_SLS"."ROWID": invalid identifier Workaround for this issue Change Oracle Connector's p...