DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
vijaydasari
Participant



Joined: 22 Jul 2007
Posts: 27

Points: 318

Post Posted: Thu Feb 02, 2017 12:38 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
I used Connector Migration tool in 11.5 version, migrated the server jobs having ORA OCI stages to Oracle Connector stage.

Before migration server job ORA OCI stages property " Prefetch memory setting" value as 5000, but after migration setting in Oracle connector "Prefetch Buffer Size " value became 5000000. This is happening for all jobs where ever we defined Prefetch memory setting. because of this we couldn't compile jobs and error saying buffer size can't be more than 100240.

Please let me know how to resolve this.

_________________
Vijay
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2532
Location: USA
Points: 18269

Post Posted: Fri Feb 03, 2017 7:48 am Reply with quote    Back to top    

Since the utility is supported, you should really report this defect to Support and request a fix. They will most likely provide you with a patch, or at least with detailed instructions to follow to fix it manually. Good luck!

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
vijaydasari
Participant



Joined: 22 Jul 2007
Posts: 27

Points: 318

Post Posted: Fri Feb 03, 2017 2:13 pm Reply with quote    Back to top    

I contacted IBM support, they suggested to install patch JR56834.

Patch resolved issue.

_________________
Vijay
Rate this response:  
midstream
Participant



Joined: 04 May 2017
Posts: 2

Points: 6

Post Posted: Fri May 05, 2017 2:21 am Reply with quote    Back to top    

I know what you guys think and tell others is very helpful.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours