I am getting the error as FATAL ERROR: Virtual data Set;.....; the record is too big to fit in a block; the length requested is : 135012. when i am running the DataStage and trying to load data using Oracle enterprise.
Can anyone suggest me how to over come this
the record is too big to fit in a block;
Moderators: chulett, rschirm, roy
the record is too big to fit in a block;
bullabai vachadu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is this the same question as the one in this post?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Yes, this is the same questionray.wurlod wrote:Is this the same question as the one in this post? ...
Error: ##F TFDR 000043 13:36:21(001) <Oracle_Enterprise_3,0> Fatal Error: Virtual data set.; output of "Oracle_Enterprise_3": the record is too big to fit in a block; the length requested is: 134048.
any suggestion???
bullabai vachadu
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
APT_DEFAULT_TRANSPORT_BLOCK_SIZE need to be set to the double of maximum possible message size that is expected
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>