Search found 53125 matches

by ray.wurlod
Thu Jul 06, 2006 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs not releasing
Replies: 7
Views: 2001

Usually because someone has killed a parent process, making a zombie out of the child process.
by ray.wurlod
Thu Jul 06, 2006 5:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: USING SEQUENCER's
Replies: 3
Views: 953

A Sequencer is a component in a job sequence that makes an "any input has fired" or "all inputs have fired" decision. They are not difficult to use, having only the one property.
by ray.wurlod
Thu Jul 06, 2006 5:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage-Type conversion from string to date
Replies: 5
Views: 1260

Read again "and it may be necessary to guarantee the leading zero on the month and day components". Use substring, concatenation and If constructs to get the format right.
by ray.wurlod
Thu Jul 06, 2006 2:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ Stage - Batch or Realtime
Replies: 8
Views: 3041

Even real time is a continuously running job with a "listener" awaiting some input, unless the job startup time is acceptable (a small proportion of the overall execution time).
by ray.wurlod
Thu Jul 06, 2006 2:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need information on resizing dynamic hash file
Replies: 3
Views: 1356

The first numeric argument is the file type. 30 is dynamic, 2-18 are static. The second numeric argument is minimum modulus for dynamic, and modulus for static. The third numeric argument is group size, and must be 4 or 8 for dynamic hashed files. Why do you believe you need to RESIZE dynamic hashed...
by ray.wurlod
Thu Jul 06, 2006 2:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: not a valid load module:
Replies: 4
Views: 2658

Change your shared library search path (SHLIB_PATH) so that the 32-bit Oracle libraries appear ahead of the 64-bit Oracle libraries. Search the forum for details of the library names, or ask your DBA.
by ray.wurlod
Thu Jul 06, 2006 1:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Selective Command Line Export?
Replies: 32
Views: 14321

I once wrote (and posted) a routine to dump a table definition in CSV, IMF or XML format.
by ray.wurlod
Thu Jul 06, 2006 1:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage-Type conversion from string to date
Replies: 5
Views: 1260

The format string may need to be "%mm/%dd/%yyyy" (note the use of "/" as the separator character, to match the data) and it may be necessary to guarantee the leading zero on the month and day components.
by ray.wurlod
Wed Jul 05, 2006 9:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Error
Replies: 24
Views: 8052

We spoke with Karen at the Las Vegas event last November, if you recall. Overwriting of dynamic hashed file headers has been seen in the past when the T30FILE table got exactly full - without generating any errors - but I thought that had been fixed. It could, in theory, also occur if some inadverte...
by ray.wurlod
Wed Jul 05, 2006 7:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help on SETFILE &VOC
Replies: 3
Views: 1970

Because they are not in the DataStage manuals. They are in the UniVerse manuals.
by ray.wurlod
Wed Jul 05, 2006 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: GRANT DROP priviledges to other users on localuv tables
Replies: 4
Views: 1547

DROP is not a privilege that can be granted to DataStage/SQL tables. Nor is CREATE. Hence the error in the first GRANT statement.

The creator of a table is its owner. You must be the owner of the table or have DBA privilege to be permitted to drop it. Those are the rules.
by ray.wurlod
Wed Jul 05, 2006 7:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server File System Getting Full
Replies: 8
Views: 1714

You can use find with a -size option to check for anything over, say, 1.5GB
by ray.wurlod
Wed Jul 05, 2006 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Login Error
Replies: 8
Views: 1960

DataStage RPC service for connecting via DataStage clients. This probably started OK. DataStage telnet service for connecting via telnet. However, you probably have something else starting first on port #23 (maybe MKS telnet), so the DataStage telnet service can't start. Doesn't matter, since you ca...
by ray.wurlod
Wed Jul 05, 2006 7:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unwanted Text File in Mail Attachment
Replies: 7
Views: 1510

That is put on by LookOut, not by DataStage. :evil:
by ray.wurlod
Wed Jul 05, 2006 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare stage, output columns
Replies: 16
Views: 16569

Difference stage outputs all columns (individually) from both input Data Sets, plus the result of the comparison as a coded value (codes are set up as properties) as one additional column.