Search found 53125 matches

by ray.wurlod
Mon Nov 16, 2009 4:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unhandled failure encountered executing command
Replies: 13
Views: 11653

... unless, of course, you have an explicit "Failure" trigger, whose existence causes it to have priority over the automatic handler.
by ray.wurlod
Mon Nov 16, 2009 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 8.1 Server Hash Files.
Replies: 2
Views: 1607

Hashed files don't go away either.
by ray.wurlod
Mon Nov 16, 2009 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capturing job logs from universe table
Replies: 3
Views: 1284

I've already mentioned that it's not UniVerse. However, a query like the one you postulated, terminated with a semi-colon, will dump the contents of a particular job log.

What are you trying to achieve? This particular wheel may already have been invented.
by ray.wurlod
Mon Nov 16, 2009 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rt_log
Replies: 4
Views: 1408

There are options (new in version 8.1) in the DSParams file that govern location of DataStage job logs. You can Search DSXchange for details.
by ray.wurlod
Mon Nov 16, 2009 3:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash File Usage Analysis
Replies: 6
Views: 2767

It's not DS_OBJECTS, it's DS_JOBOBJECTS.
by ray.wurlod
Mon Nov 16, 2009 3:25 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: how to read sequential files in IA 8.0
Replies: 1
Views: 1454

Use ODBC driver for text files.
by ray.wurlod
Mon Nov 16, 2009 2:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Stage
Replies: 6
Views: 3395

No. The advice relates specifically to Switch and Filter stages. The Copy stage is more efficient for renaming and dropping columns than is the Transformer stage.
by ray.wurlod
Mon Nov 16, 2009 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: rt_log
Replies: 4
Views: 1408

The short answer is no. If you're running version 8.1 you get a choice of storing logs in the unified metadata repostiory or in the local DataStage project repository. Secondly, the DataStage engine has not been UniVerse since prior to version 6.0. Thirdly, every job has a separate hashed file, name...
by ray.wurlod
Mon Nov 16, 2009 2:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 17
Views: 6650

You should not even be allowed to copy in production; production should ideally be a protected project.

Use the Data Set Management Tool (or equivalent orchadmin commands) to view the record schema and data in Data Sets.
by ray.wurlod
Mon Nov 16, 2009 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Stage
Replies: 6
Views: 3395

Things changed between the two releases. The Transformer stage now compiles to an (efficient) transform operator. This was not the case in earlier versions.
by ray.wurlod
Mon Nov 16, 2009 2:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: AIX Group Function
Replies: 3
Views: 1300

Check in Web Console for IBM Information Server - you may just have made everyone a DataStage Administrator (rather than doing things the correct way)!
by ray.wurlod
Mon Nov 16, 2009 2:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Metadata error for oracle columns
Replies: 1
Views: 1164

It's not an error; it's an alert that your job design may be doing something foolish that might result in data loss. Search DSXchange for more information; it's been posted many times before.
by ray.wurlod
Mon Nov 16, 2009 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To capture link count in a sequential file
Replies: 2
Views: 1575

Or do you want an operating system level command? If so you're out of luck unless you create DataStage components (maybe a job) that you can invoke using dsjob.
by ray.wurlod
Sun Nov 15, 2009 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replace SUB character in sequential file
Replies: 6
Views: 8384

You can not remove the eof character - the operating system needs this to tell it when to stop reading the file.

Make sure that every line in the file, including the last line, has a correct line terminator. Your metadata expects it to.
by ray.wurlod
Sun Nov 15, 2009 6:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGABRT
Replies: 3
Views: 3512

I've also seen this error on a machine in which one of the memory chips started throwing parity errors. It might be worth getting the machine's memory verified.