Thank you Andy!
Actually the large column will be only upto two stages, so I will give the buffer size to 9mb only to that particular stages in advanced tab and remove the parameter default transport size....Does that work?
Search found 246 matches
- Wed Feb 05, 2014 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reduce the links to use 9MB APT_DEFAULT_TRANSPORT_BLOCK_SIZE
- Replies: 2
- Views: 2252
- Mon Feb 03, 2014 3:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reduce the links to use 9MB APT_DEFAULT_TRANSPORT_BLOCK_SIZE
- Replies: 2
- Views: 2252
Reduce the links to use 9MB APT_DEFAULT_TRANSPORT_BLOCK_SIZE
I used 4 MB of block size and now due to a very big length column it is asking me to give 9MB which could cause the job to use more memory than needed since all the links would use a 9 MB transport block size. Any idea how to use that 9MB for only particular links to reduce the memory usage? Thank you
- Fri Jan 24, 2014 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use DB seq value in the job
- Replies: 5
- Views: 3373
- Thu Jan 23, 2014 6:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use DB seq value in the job
- Replies: 5
- Views: 3373
The reason I am asking to do it in one job is the flow of the data is same all the way till target and you already said its not advisable. Is there any way where we can do it as it will be more complex to built an other job with the same flow..:( regarding your input So will the DB sequence in surro...
- Thu Jan 23, 2014 6:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use DB seq value in the job
- Replies: 5
- Views: 3373
- Wed Jan 22, 2014 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use DB seq value in the job
- Replies: 5
- Views: 3373
use DB seq value in the job
Hello, I have a Db2 table1 as target for which the key is DB Sequence generator. I also have an other table2 in the same job for which the key is the FK from the table1. Each time only one record will get inserted into the table1, once its inserted I need the seq value which has been generated and u...
- Wed Jan 22, 2014 8:28 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: XML data in an XML tag as input to Web Service
- Replies: 5
- Views: 6842
- Tue Jan 21, 2014 1:49 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: XML data in an XML tag as input to Web Service
- Replies: 5
- Views: 6842
- Tue Jan 21, 2014 8:52 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: XML data in an XML tag as input to Web Service
- Replies: 5
- Views: 6842
XML data in an XML tag as input to Web Service
Hello, Have a question regarding the XML format of Web Service As of now our source is as below through a table Name(char) Entity(integer) Account(integer) Tran_CLOB(XML data) Prod_cd Prod_type Now we are planning to build a web service with the same fields but as WISD input and WISD output as below...
- Mon Jan 13, 2014 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888
- Sat Jan 11, 2014 10:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888
- Fri Jan 10, 2014 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888
I think I tried a different way, just included a new column. Now I added an other column at the CHILD level giving it a sequence and I see the data in the below way which is not in correct format <Parent> <child> <newchild>1 <userID>123</userID> <Phone>6436431347</Phone> <Fax>5654345678</Fax> <Addr>...
- Fri Jan 10, 2014 11:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888
- Thu Jan 09, 2014 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888
I changed it to Aggregate button and all the data came into a Single XML file but all the tags came into one child tags like below <Parent> <child> <userID>123</userID> <userID>123</userID> <userID>123</userID> <userID>123</userID> <userID>123</userID> <Phone>6436431347</Phone> <Fax>5654345678</Fax>...
- Thu Jan 09, 2014 12:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage
- Replies: 13
- Views: 6888