Search found 53125 matches

by ray.wurlod
Fri Jan 25, 2013 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: slower ODBC Enterprise stage
Replies: 11
Views: 7459

Yes, the first is the prototype for DB2 Wire Protocol connections. This is in .odbc.ini when the product is installed. The other entry was added at, and is specific to, your site. The entry in uvodbc.config simply makes the DSN visible and identifies it as "true" ODBC or "UniVerse&quo...
by ray.wurlod
Fri Jan 25, 2013 3:55 pm
Forum: General
Topic: Identify Jobs that load/reads from a particular database
Replies: 5
Views: 1970

If you have Metadata Workbench you can create a lineage report that will show you exactly this information. If you do not have Metadata Workbench you probably build a query against DS_JOBOBJECTS and DS_JOBS that finds input links (for writes) or output links (for reads) that refer to the particular ...
by ray.wurlod
Fri Jan 25, 2013 3:52 pm
Forum: General
Topic: Datastage Certification
Replies: 9
Views: 4487

Note also that these cheat sites are apparently not particularly reliable.
by ray.wurlod
Fri Jan 25, 2013 12:44 am
Forum: General
Topic: Engine Credentials Data Not Found Error
Replies: 5
Views: 1543

Why would you expect data to be there on a fresh installation. You have to provide the data.

Is the error Data Not Found or No Data Found ? These are different.

What style of user registry are you using?
by ray.wurlod
Thu Jan 24, 2013 7:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Rewriting Server jobs in 7.5.1 as parallel jobs in 8.1
Replies: 4
Views: 1729

Re: Rewriting Server jobs in 7.5.1 as parallel jobs in 8.1

we have to convert a large number of Server jobs to be rewritten as Parallel job. Why? Server jobs still work, and are not going to go away (not least because sequences are server jobs). As noted, maybe only attempt the ones that are performing poorly. There are no tools. Analyse the logic of the s...
by ray.wurlod
Thu Jan 24, 2013 7:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File with Occurs in the table
Replies: 6
Views: 1407

Where is PORT-SUB defined?

Import the table definition from the FD.
Load the imported table definition into the Complex Flat File stage.
You can specify whether you want the OCCURS handled by creating a vector within a single column or by creating ten separate columns (flattening).
by ray.wurlod
Thu Jan 24, 2013 7:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage Issue
Replies: 10
Views: 3305

:idea: :idea:
I sometimes even hide the Sequential File stage in a local container when I'm appending to /dev/null (as well as keeping the annotation with it).
by ray.wurlod
Thu Jan 24, 2013 7:02 pm
Forum: General
Topic: List of sequences
Replies: 4
Views: 2109

1) All your sequences are non-restartable.
or
2) There's a bug.
by ray.wurlod
Thu Jan 24, 2013 7:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Keep MQ job running
Replies: 5
Views: 2370

That's a possibility. You still need to be aware of the hashed file size limit (default 2GB with 32-bit addressing asserted).
by ray.wurlod
Thu Jan 24, 2013 7:00 pm
Forum: General
Topic: List of jobs run in last 40 days
Replies: 11
Views: 2381

Assuming you're on version 8.7 or later, the Operations Console keeps and displays history. The underlying database DSODB is completely described, so you can create your own reports from there.
by ray.wurlod
Thu Jan 24, 2013 6:53 pm
Forum:
Topic: How to encrypt config.ini file for BGA install
Replies: 3
Views: 2339

I can only suggest that you try encrypting them with encrypt.bat, plugging the results into the config.ini file and testing whether that works.
by ray.wurlod
Thu Jan 24, 2013 1:13 am
Forum:
Topic: Metadataworkbench Database clarification
Replies: 7
Views: 4849

When you import or save jobs in DataStage, they are automatically stored in the common metadata repository, so Metadata Workbench and other tools can see them immediately.
by ray.wurlod
Wed Jan 23, 2013 7:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage Issue
Replies: 10
Views: 3305

:idea:
Annotate your job design to warn people against trying a View Data on the Sequential File stage that accesses /dev/null
by ray.wurlod
Wed Jan 23, 2013 7:30 pm
Forum: General
Topic: How to pass filenames 1 at a time to server routine
Replies: 2
Views: 827

Use a server job reading the output of the Filter command DIR /B pathname/TU* which will give you a stream of file names that you can pass to the Routine in a Transformer stage. Or use a sequence with an Execute Command activity to generate the list of file names, and a loop containing a Routine act...