Search found 53125 matches

by ray.wurlod
Wed May 26, 2010 3:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UNDO TABLESPACE
Replies: 9
Views: 3041

Decrease transaction size (rows per transaction) to, say, 50. If the UNDO tablespace is OK after that, try increasing by a factor of 2 until the problem recurs, then back off till it disappears again.
by ray.wurlod
Tue May 25, 2010 8:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create file in Local drive
Replies: 7
Views: 1861

You have a UNIX file called "C:\path\file.txt" (probably "C:pathfile.txt") in the project directory on the server.
by ray.wurlod
Tue May 25, 2010 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split file in windows
Replies: 5
Views: 1618

No can do. While you can split the file into 2GB chunks, each chunk will be irrecoverable. The tar archive must be intact before it can be unpacked.
by ray.wurlod
Tue May 25, 2010 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switch/Case
Replies: 11
Views: 2508

Not sure what you're attempting to accomplish, but there IS a Switch stage that you may wish to investigate.
by ray.wurlod
Tue May 25, 2010 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create file in Local drive
Replies: 7
Views: 1861

Not possible. Get the FTP limits changed, if only temporarily. 4GB is nothing for FTP.
by ray.wurlod
Tue May 25, 2010 5:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: istool - custom path
Replies: 8
Views: 2592

Sounds like you started services as root.
by ray.wurlod
Tue May 25, 2010 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Switch/Case
Replies: 11
Views: 2508

There is no direct implementation. If you feel you really must have this, embed it in a routine and invoke that from the Transformer stage.

Seems like overkill to me. Most situations can be accomplished using sets of stage variables, as suggested.
by ray.wurlod
Tue May 25, 2010 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Individual Job Running fine, but when run through sequence j
Replies: 7
Views: 3392

Look in the job logs - job starting event - for the successful and failed attempts. Is the password, as encrypted, the same for both?
by ray.wurlod
Tue May 25, 2010 5:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Information about DataStage job log
Replies: 1
Views: 1602

Startup time is the amount of time it took to get all the nodes into a running state. Processing time is the amount of time consumed actually processing data. Each is rounded to the nearest whole second. In your case, processing took less than 0.5 seconds. Startup time tends to be fairly constant fo...
by ray.wurlod
Tue May 25, 2010 5:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rerunning the job from fail point
Replies: 10
Views: 2975

YOU have to put it in. This does not happen out of the box.
by ray.wurlod
Tue May 25, 2010 5:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ANALYZE.FILE
Replies: 8
Views: 3271

Do you have a VOC pointer for hsh_Staging_2 hashed file?
by ray.wurlod
Tue May 25, 2010 5:15 am
Forum: General
Topic: send mail using DSSendMail command
Replies: 5
Views: 4010

DSSendMail() function, executed on UNIX, invokes sendmail() or an equivalent function.
by ray.wurlod
Tue May 25, 2010 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rerunning the job from fail point
Replies: 10
Views: 2975

Depends.

What does "processing" involve?

Are you keeping track of which records have been processed?

What is the source? How are you extracting rows from that source?
by ray.wurlod
Tue May 25, 2010 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid character(s) ([xC0]) found converting string issue
Replies: 5
Views: 3193

Can you use another utility to display what's actually in the source in this particular field? If so, please post the result of that exercise.