Search found 12 matches

by Isonisa
Tue Mar 22, 2016 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job hangs in string extraction in DS 11.3.1.2
Replies: 10
Views: 6378

In IBM appropriate doc for AIX XL C/C++ is told only miminum version as 12.1 and comment Support for AIX XL C/C++ 12.1 is limited to the base version (12.1.0.0) through Fix Pack 5 (12.1.0.5). Higher level Fix Packs are not currently supported. Let's wait what IBM support instructs to do. Perhaps use...
by Isonisa
Mon Mar 21, 2016 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job hangs in string extraction in DS 11.3.1.2
Replies: 10
Views: 6378

The problem relates to comparison operators in string comparisons. Operator greater (>) or greater than ( => ) works for ex. the following works. If DSLink2.varc1[14,2] > ' ' Then 'Msg1' Else If DSLink2.varc1[46,2] > ' ' Then 'Msg2' Else If DSLink2.varc1[60,2] > ' ' Then 'Msg3' Else 'OK' The followi...
by Isonisa
Sun Mar 20, 2016 1:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job hangs in string extraction in DS 11.3.1.2
Replies: 10
Views: 6378

Probably the error is related to C++ compiler. We are using IBM xlC 13.1.3 in AIX 7.1. According to Information Server 11.3.1.2 requirements miminum C++ version is 12.1 FP5 Simple test job (Row Generator - -> Transformer - -> Peak ): In transformer: If DSLink2.varc1 [14,16] <= ' ' Then 'Msg 1' Else ...
by Isonisa
Sat Mar 19, 2016 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job hangs in string extraction in DS 11.3.1.2
Replies: 10
Views: 6378

Parallel job hangs in string extraction in DS 11.3.1.2

Parallel job reads sequential file. Row length 1000 bytes. File size is small about 10 kB. Each row is extracted to columns with row[xx,yy] notation in Transformer stage. after this outputted to Peak stage. This is just a minimal test job to figure out the root cause. If the amount of these extracti...
by Isonisa
Wed Nov 06, 2013 11:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Open queue failed with reason code: 2085
Replies: 1
Views: 2605

Open queue failed with reason code: 2085

I have s similar problem to this post with MQ Connector DS 8.1 FB1. We have existing applications that use "Move to Work queue" transaction handling with DTS stage. If a new job is created from scratch that uses the same queue manager and same queues as the working jobs, then from second q...
by Isonisa
Thu Apr 11, 2013 5:28 am
Forum: General
Topic: PX ODBC connector properties dialog box missing some pages
Replies: 9
Views: 7410

This problem occurs also in DS 8.5 FB1,2 version.
Does reinstalling FB2 solve the problem or is some other FB available for DS 8.5 ?
by Isonisa
Thu Jan 24, 2013 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hang while reading large xml file
Replies: 0
Views: 1303

Hang while reading large xml file

Hai I have had same kind of hanging problems as this post but with DS 8.5 FB1+2 XML Stage. With about 10 Mb XML docs the application ran a while with a huge heap size about 2.5 GB. Then it reported "aborted" with no explanation. Then the whole DS installation wen locked, because the OS (Un...
by Isonisa
Wed Dec 05, 2012 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 XML Parser list mapping ?
Replies: 8
Views: 4008

No problems any more.

The documentation should clarify more precisely the differences with new XML stage and old XMLInput stage.

I close this ticket.
by Isonisa
Tue Dec 04, 2012 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 XML Parser list mapping ?
Replies: 8
Views: 4008

In new XML stage the clue was to first do "Auto map" to top level element. Then the tool allowed to map List elements to non-list output elements. In a more complicated .XSD the tool don't allow this and you have to map lists to separate link, where is a suitable list to map. Of course the...
by Isonisa
Fri Nov 30, 2012 1:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 XML Parser list mapping ?
Replies: 8
Views: 4008

Morning Let's explain this with traditional Customer / Address example where in xml is one Customer element (root) under which several Address elements. How this is mapped so that all the output is for case Customer-1 has three addresses. Customer-2 has one Customer-3 has two Customer-4 has one Cust...
by Isonisa
Thu Nov 29, 2012 12:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 XML Parser list mapping ?
Replies: 8
Views: 4008

In Output step Input structure (.xsd) is a List as Result (List) Time (string) Value (string) Output is a link to file (dataset) where this structure is Time (varchar 30), Value (varchar 30). Attribute Time is marked as "Key" to indicate that multiple rows according to Time, Value should b...
by Isonisa
Thu Nov 29, 2012 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 8.5 XML Parser list mapping ?
Replies: 8
Views: 4008

DS 8.5 XML Parser list mapping ?

Is somewhere a good example how a xml document, where is repetive structure (occurs > 1 in .xsd) is mapped to relational row ( file). In xsd is minOccurs=0, maxOccurs="unbounded" and two string-elements repeating. This should be mapped to file row where is attr11 attr12 attr21 attr22 attr3...