Search found 53125 matches

by ray.wurlod
Tue Oct 16, 2007 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output file full Error
Replies: 4
Views: 2288

A fork failure is also an inability to create a new process. So it may be that the process table (rather than the inode table) is the problem in this case, or that there is no inode left on the device with which to create communication channels. As to any command you can run from the Administrator, ...
by ray.wurlod
Tue Oct 16, 2007 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Skip checkpoint in rerun after fail sequence....
Replies: 4
Views: 3869

If you want it differently you will need to program it accordingly. Possibly a Nested Condition activity preceding each job activity.
by ray.wurlod
Tue Oct 16, 2007 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS 8.0.1 etlrun using dsjob 'Failed to open project’
Replies: 5
Views: 6773

Looks like the shared library search path (LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH) is incomplete for the executing user. This might be because the script (or its executing user) failed to run the dsenv script.
by ray.wurlod
Tue Oct 16, 2007 9:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem hours Unix and DataStage
Replies: 1
Views: 925

Welcome aboard. Restart DataStage is best in this case.
by ray.wurlod
Tue Oct 16, 2007 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning: buffer(6),1: APT_BufferOperator warning
Replies: 5
Views: 1579

This error can occur when the job runs through midnight. It's a bug. Contact your support provider.
by ray.wurlod
Tue Oct 16, 2007 9:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Detecting corrupt log files
Replies: 2
Views: 1098

The uvbackup command can do what you require. Search the forum for details.
by ray.wurlod
Tue Oct 16, 2007 9:04 am
Forum: General
Topic: reading datastage logs
Replies: 4
Views: 1216

You can use a Hashed File stage or a UV stage.

Premium membership helps to defray the hosting and bandwidth costs of the DSXchange web site. It really is worth it. There's a link on the home page to information about corporate discounts.
by ray.wurlod
Mon Oct 15, 2007 9:34 pm
Forum: General
Topic: reading datastage logs
Replies: 4
Views: 1216

Welcome aboard. It definitely has been asked before, albeit indirectly. You need the table definition for a DataStage log file (you can definitely search for that), and you will need a mechanism for determining the hashed file name that contains the job log (RT_LOGnnn, where nnn is the job number ob...
by ray.wurlod
Mon Oct 15, 2007 9:31 pm
Forum: General
Topic: Host name error msg in DS 7.5 adminstrator
Replies: 8
Views: 2157

In Control Panel (DataStage applet) please check that all services are running. Open a cmd (DOS) shell and issue the following commands (replacing the pathname of the DataStage engine folder with the pathname that is correct for your system): CD C:\Ascential\DataStage\Engine date /T bin\uv -admin -v...
by ray.wurlod
Mon Oct 15, 2007 5:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown Folders/Files found in "Projects" Folder (
Replies: 3
Views: 1014

That would be my first guess - and that ipf means "input file" and opf means "output file".

When Ernie next checks in (he's at IOD 2007 this week), he may be able to verify (or otherwise).
by ray.wurlod
Mon Oct 15, 2007 4:52 pm
Forum: General
Topic: Set Job parameters using unix script
Replies: 10
Views: 2390

DSSetParam() is not invoked from UNIX - hence my use of the word "ultimately".

If you're using the dsjob command line interface include as many -param name=value options as you require, or use a parameter file. Search the forum for details of each approach.
by ray.wurlod
Mon Oct 15, 2007 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check for StringtoDate
Replies: 4
Views: 1313

Try to insert the date into a column whose data type is Date - it should fail if your data value is not a valid date. For most database types, anyway.
by ray.wurlod
Mon Oct 15, 2007 4:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown Folders/Files found in "Projects" Folder (
Replies: 3
Views: 1014

Are you doing anything with the real-time componentry?
by ray.wurlod
Mon Oct 15, 2007 4:33 pm
Forum: General
Topic: Host name error msg in DS 7.5 adminstrator
Replies: 8
Views: 2157

Can you attach to any other project? Can you create a new project?
by ray.wurlod
Mon Oct 15, 2007 4:32 pm
Forum: General
Topic: Host name error msg in DS 7.5 adminstrator
Replies: 8
Views: 2157

Can you attach to any other project? Can you create a new project?