Search found 53125 matches

by ray.wurlod
Wed Sep 28, 2011 4:41 pm
Forum: General
Topic: Install 2nd DataStage engine using same NAS directories?
Replies: 7
Views: 3112

What is blocking it is that they have not yet implemented the "itag" functionality that used to be available in version 7.5 and earlier, where each instance could be given a separate "itag" (during installation) that was used to construct its shared memory keys, etc.
by ray.wurlod
Wed Sep 28, 2011 4:39 pm
Forum: Data Quality Best Practices
Topic: Partitioning a Business Glossary
Replies: 11
Views: 14184

I'm getting ready to install 8.5 at a new client site. The 8.5 manual states that someone with Author or higher role can access all terms in all categories. The client isn't totally happy with that.
by ray.wurlod
Wed Sep 28, 2011 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Is not getting aborted
Replies: 7
Views: 1547

What stage type are you using? Does it have a property that causes an error to be recorded as fatal?
by ray.wurlod
Wed Sep 28, 2011 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Facts
Replies: 4
Views: 1324

I too have no idea what you mean by the "facts" of a job.
by ray.wurlod
Wed Sep 28, 2011 4:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MDM , log file name and extension
Replies: 10
Views: 2395

1. No. DataStage does not use log files. Job logs are stored in database tables. There is a separate log table in the local repository for each job. The name of that table is RT_LOGnnn, where nnn is the job number from DS_JOBS table. 2. MDM does not mean anything in DataStage. MDM usually means Mast...
by ray.wurlod
Wed Sep 28, 2011 4:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid precision value. Error in parameter 6
Replies: 8
Views: 4190

Does your Oracle allow VARCHAR2 to be that large?

You may need to specify LONG VARCHAR2
by ray.wurlod
Wed Sep 28, 2011 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Converting a DFLOAT to INT32
Replies: 4
Views: 2167

Within the Aggregator stage you have Preserve Type and Default Decimal Output properties that can override the default of calculating using Double (dfloat) data type.

Note that I don't have access to DataStage this week - I'm preparing a site to install it - so the property names are from memory.
by ray.wurlod
Wed Sep 28, 2011 4:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS - Unable to see Chinese characters
Replies: 3
Views: 1563

I would suspect that the database territory US that you've specified for DB2 would have trouble with Chinese characters.

Can you please advise what the NLS settings for DataStage (particularly the database connectivity stages) are?
by ray.wurlod
Wed Sep 28, 2011 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Terminating with exception:APT_ParseError : Parsing paramete
Replies: 10
Views: 3006

No - just right click on a stage. The pop-up menu should include an option to show where records come from.
by ray.wurlod
Wed Sep 28, 2011 4:16 pm
Forum: General
Topic: Project´s Daily Backup - Windows Server
Replies: 3
Views: 2707

I like to keep two backups. The BAT file deletes the older, renames the newer (to the "older" naming convention) then runs dscmdexport to perform the project backup. That BAT file could, if required, be invoked from another that processes the output of a dsjob "list projects" com...
by ray.wurlod
Wed Sep 28, 2011 4:03 pm
Forum: General
Topic: Install 2nd DataStage engine using same NAS directories?
Replies: 7
Views: 3112

It is not possible to use the same installation directory for multiple installations. It is also not possible, in versions 8.x thus far, to install more than one instance of the non-client tiers on the same machine.
by ray.wurlod
Wed Sep 28, 2011 4:00 pm
Forum: General
Topic: WEOFSEQ Subroutine doesn´t work.
Replies: 3
Views: 1870

So what you seem to be saying is that WEOFSEQ is not truncating the file?

Try using the OpenSequentialFile routine.
by ray.wurlod
Wed Sep 28, 2011 3:52 pm
Forum: Data Quality Best Practices
Topic: Partitioning a Business Glossary
Replies: 11
Views: 14184

It would be useful to be able to keep some Authors out of some Categories!
by ray.wurlod
Wed Sep 28, 2011 3:51 pm
Forum: IBM QualityStage
Topic: multiple passes question
Replies: 11
Views: 4376

Can you please supply more details about the blocking fields and match rules used for each pass?
by ray.wurlod
Wed Sep 28, 2011 3:48 pm
Forum: IBM QualityStage
Topic: Reference Match Stage
Replies: 1
Views: 1313

Yes, and your reference data set will come from the BEST_NAME table.
Tip: store standardized forms and frequencies in indexed columns in the BEST_NAME table or in a companion table to it.