Search found 4 matches

by MikeGoldrick
Thu Apr 22, 2010 6:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: C Stage PlugIn function "Get" required (DB2)
Replies: 1
Views: 1272

C Stage PlugIn function "Get" required (DB2)

Hi All This has been going on for several weeks. We have many oracle jobs which are running fine. When the requirement came up to access db2, everything came to a grinding halt. The jobs are server jobs. they are accessing db2 using the db2/udb api stage. This same job runs beautifully in another en...
by MikeGoldrick
Wed May 30, 2007 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance from 86 rows to 1 row per second
Replies: 11
Views: 5323

Oracle jobs can slow significantly if they are loading indexes in the background if you are loading a lot of rows. You might consider disabling the index(s) before the job starts and rebuilding the index(s) after the job ends. You can also sort the rows in index order before loading for some improve...
by MikeGoldrick
Thu May 03, 2007 10:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HOw to start the datastage job from win bat file or DOS mode
Replies: 7
Views: 3971

An example in a ".bat" file

:runjob C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -jobstatus %project% %job% :: if not errorlevel 2 goto end C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -mode RESET %project% %job% C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -lo...
by MikeGoldrick
Thu Mar 23, 2006 3:07 pm
Forum:
Topic: SmartHeap library - Out of memory error - During Job Imports
Replies: 2
Views: 2017

Request => MetaStage 7.5.2 upgrade.

I had the same problem and tried the same work arounds.