Connector Migration tool issue

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vijaydasari
Participant
Posts: 29
Joined: Sun Jul 22, 2007 3:25 pm

Connector Migration tool issue

Post by vijaydasari »

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.
Vijaya K Dasari
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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
vijaydasari
Participant
Posts: 29
Joined: Sun Jul 22, 2007 3:25 pm

Post by vijaydasari »

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

Patch resolved issue.
Vijaya K Dasari
midstream
Participant
Posts: 2
Joined: Thu May 04, 2017 9:32 pm

Post by midstream »

I know what you guys think and tell others is very helpful.
Post Reply