Search found 102 matches

by thumati.praveen
Tue Jun 23, 2009 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 24171

Your input record length is over 4 billion bytes? :? Yes boss,You identified my actual problem. Could you please advise how to resolve the problem? when ever small amount of records comming means less than 50000 records it is working if the records are comming more than 100000 I am facing this prob...
by thumati.praveen
Tue Jun 23, 2009 6:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 24171

ArndW wrote:I seem to recall that the block size is allocated as a power of 2 and rounded from the number specified in the block size. Try specifying 1048576 ...
I amgetting same problem.

Even I given more then that what you have specified.

Thanks,
Praveen.
by thumati.praveen
Tue Jun 23, 2009 5:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 24171

I was already specified 8 digit number still job looking 131072 this.
by thumati.praveen
Tue Jun 23, 2009 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: the record is too big to fit into block
Replies: 22
Views: 24171

the record is too big to fit into block

Hi, Can you aware of below problem earlier ? APT_CombinedOperatorController(5),0: Fatal Error: File data set, file "/etl/IS/Datasets/ds_isap_irde020_am_gm_gbo_final.ds".; output of "cpyROw": the record is too big to fit in a block; the length requested is: 145247, the max block l...
by thumati.praveen
Thu Jun 04, 2009 7:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_SC error
Replies: 4
Views: 2319

Hi,

If you put the transformer stage in sequential execution mode in parallel job and job is running more than one node config it will give above error.

Please make parallel the transformer execution mode.

Thanks,
Praveen
by thumati.praveen
Wed Jun 03, 2009 2:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_SC error
Replies: 4
Views: 2319

Hi,

Any one have solution for the above problem.

Could you please let us know?

Thanks,
Praveen.
by thumati.praveen
Thu Apr 09, 2009 4:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

what does "multiple idocs" mean? Forget IDOCS for a moment... For your testing, have one output link from xmlOutput. On it, put one column. Name it xmlStuff. LongVarchar and say, 99999 as the length. Put a single slash in the Description property. Use "Aggregate" option. Send it...
by thumati.praveen
Wed Apr 08, 2009 8:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

Let's put our attention over there, then, at your XMLOutput. With aggregation, most scenarios should allow XMLOutput to produce one single output string. Are you using XMLOutput to do your i/o? This thread is getting long --- not sure if we've discussed it already, but just put a single column on a...
by thumati.praveen
Mon Apr 06, 2009 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

Any reason you are placing the info (the xml chunk) into an intermediate sequential file? Just pass it along downstream in the job. If you persist it to disk, then yes, you will have a variety of issues trying to read it, unless you use a Server Job and read it with the Folder Stage. I find that EE...
by thumati.praveen
Mon Apr 06, 2009 3:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

Please define what you mean by spaces....are they just "spaces" in the final document that you construct? (such as....) <element1>value</element1> [some number of blank lines] <element2>value</element2> ? If so, it will be fine (provided that the receiver is an application that truly resp...
by thumati.praveen
Fri Apr 03, 2009 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

I got xml best parcties last year from KIMS site.It is very worth. Any way I found the way to resolve it.But in that some what difficult is their I am generating all segments individualy and funneling all segments into one sequential file from this I am generating the required xml. The only problem ...
by thumati.praveen
Thu Apr 02, 2009 5:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

...btw, I am assuming that your "segments" above are unique from each other and repeat independently (ie..you could get 2 seg1's and 1 seg3, and 4 seg7's). ...and if they aren't unique, and are really just repeating "instances" of the same thing ,why do they have unique element ...
by thumati.praveen
Thu Apr 02, 2009 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

...one more thing....is it just these two columns that you are dealing with, or are many....10's or hundreds of columns? Ernie Hi Ernie, Thanks for suggestions. In my case I am having total 12 segments.For each segment I have more that 10 columns. Example:- <xmldoc> <segment1> <seg1-tag1> <seg1-tag...
by thumati.praveen
Wed Apr 01, 2009 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

There seems to be a conflict here of "rows" vs "columns". Is PORD1 a column name, or a value in a row? Right now, these are listed as individual and unique items --- but they are on separate rows. If indeed you just want all six elements in the same repeating group, then put the...
by thumati.praveen
Wed Apr 01, 2009 3:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: in XMLoutput stage more than one repeat element
Replies: 26
Views: 8180

Hi Pagadari,
If I give one key column actual results I poseted in my original post.

If dont give any key it will repeat entire xml doc.


Hi Chulett,
you mean to say generate individul chunks and assemble these chunks into main stream right?

Could you please clarify me?

Thanks,
Praveen.