Search found 2288 matches

by roy
Mon Jun 20, 2005 2:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: debugging
Replies: 4
Views: 1015

Hi, you first go thru the director's log and find where things 'went a stray'. I agree it's a bit of work for big sequences. when you manage to narrow the suspicious section you can create a copy of it and remove unrelated activities. then use the director to get what values where used in the entire...
by roy
Mon Jun 20, 2005 1:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Eternal Informix Problem
Replies: 7
Views: 2168

Hi, Are you trying to connect via informix client? (probably) your SH_LIB_PATH should include the informix client's library path first. And if memory serves me you also need to configure .odbc.ini and uvodbc.config to get it working. To verify you didn't forgret anything go over the plugin manual an...
by roy
Mon Jun 20, 2005 1:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dspipe_init open - No such file or directory
Replies: 3
Views: 2350

Thaks,
I've heard the sys admins say something about a problem with the FS(File System).
so it might be also the cause.

I guess a bad disk might have similar result as no space left in the FS.

I'll keep this posted if anything new pops out :).
by roy
Thu Jun 16, 2005 8:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reporting DataStage Errors
Replies: 2
Views: 547

Hi,
you should use the dsjob command line interface to get the job status and act acording to it.
search this forum for exact syntax (it was covered way beyond any need ;))

IHTH,
by roy
Thu Jun 16, 2005 8:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC Connection from DataStage to Informix
Replies: 7
Views: 5833

Hi, in the $DSHOME/../branded_odbc directory you should find all the info you need for defining your odbc connection. there are lots of things there including work-around configurations for known issues using the odbc driver (of Data Direct at least). AFAIK, wire or not Informix still requires .odbc...
by roy
Thu Jun 16, 2005 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checkpoint restart
Replies: 15
Views: 7318

Ok and do the log shows they have been reset when you rerun the top level sequence job?
by roy
Thu Jun 16, 2005 8:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Req for list of possible values and descrip for Job codes
Replies: 7
Views: 4782

Hi, As you mentioned yourself there is a difference between internal codes to API codes. I believe the 0 for successfull run in the API simply conforms to the unix standards for return value for successfull OS command execution. Just to be on the safe side test the returned values for all cases that...
by roy
Thu Jun 16, 2005 6:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Abort
Replies: 7
Views: 1770

Hi,
Did you mean just reset before next run (which Arnd Answered) or did you want a way to retry a failed run automatically?
by roy
Thu Jun 16, 2005 6:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Monitoring
Replies: 6
Views: 1561

Hi, Since your director session i limited to one concurent project the answer is not via director. However you can incorporate a 3rd party monitoring tool if one exists in your organization to show every job status in every DS server installed in the organization. this includes a monitor you can bui...
by roy
Thu Jun 16, 2005 5:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to avoid warnings?
Replies: 15
Views: 3230

Hi, you managed to confuse me wih your last post Nripendra Chand, If you use insert or update then there is no way you'll get this message (if it isyourload method) in case you use only update you can, as mentioned, prepare or perform a lookup verifying the record exists and only then update it (use...
by roy
Thu Jun 16, 2005 4:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checkpoint restart
Replies: 15
Views: 7318

Hi,
Do you see the jobs getting reset before running again?
When they are in aborted state do you see only reset option in director for those sequence jobs?
by roy
Thu Jun 16, 2005 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid string or buffer length. SQLSTATE=HY090
Replies: 7
Views: 6597

Hi, Disable operator combination to get the exact stage causing the error and if you still need help repost the new error you get (add an env var of APT_DISABLE_COMBINATION with true value in your parameters list for that job or set it project wide). other then that it seems you don't have the requi...
by roy
Thu Jun 16, 2005 3:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading excel file
Replies: 8
Views: 2766

Just Thinking I mentioned all alternatives givven so far in my original post except for using acces but that could be similar for using csv files instead excell. (Guess My skills for passing ideas are poor or am I being ignored - probably wrote to much J/K lmao, felt I had to write this ) Do post wh...
by roy
Thu Jun 16, 2005 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning
Replies: 5
Views: 1387

Hi,
could it be that you have a first line of column headers and failed to flag it in the file format option?

IHTH,
by roy
Thu Jun 16, 2005 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dspipe_init open - No such file or directory
Replies: 3
Views: 2350

dspipe_init open - No such file or directory

Hi Yall, (The single post with dspipe_init that came out of a search returned me to a posts page not the post itself ) I have a job that runs twice. first time against Oracle 8 (at 9:00 PM) second time against Oracle 10g (at 9:30 PM) Last night the first run failed at 9:25 giving the following error...