Search found 53125 matches

by ray.wurlod
Fri Jul 27, 2012 4:59 pm
Forum: General
Topic: Job is not in the right state (compiled and not running)
Replies: 60
Views: 17247

By default the limit on jobname.invocationID is 255 characters.

This can be made larger, but I've never found a need to.
by ray.wurlod
Fri Jul 27, 2012 4:57 pm
Forum:
Topic: Question on odd icon returned with Bus./Data Lineage reports
Replies: 6
Views: 4401

Who ya gonna call?

:lol:
by ray.wurlod
Fri Jul 27, 2012 4:56 pm
Forum:
Topic: Save failed while creating new Terms
Replies: 1
Views: 1961

Clearly you have at least BG Author role (you can save new categories). The next thing you need to do is to look at the WAS logs (SystemOut and SystemErr) to determine the cause of the failure. C:\IBM\WebSphere\AppServer\profiles\InfoSphere\logs\server1 is the default location on Windows for these l...
by ray.wurlod
Fri Jul 27, 2012 4:52 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: can we run to run the SQL queries in information Analyzer8.5
Replies: 1
Views: 1930

Not really though, if you have DataStage, you could use that. Both products share the same metadata repository.
by ray.wurlod
Fri Jul 27, 2012 4:51 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Review column analysis results in 'domain & Completeness
Replies: 5
Views: 2968

There are some consoles coming along to aid with managing these rules.

Can't tell you when, but they're in development now.
by ray.wurlod
Thu Jul 26, 2012 4:06 pm
Forum: General
Topic: DataStage credentials option not able see from WEBCONSOLE
Replies: 1
Views: 988

No. I don't believe so. The problem is likely to be that you have logged in to the Web Console as a user who is not a Suite Administrator.

You do have to have some kind of Engine credential, and it's most usually mapped through the interface you mentioned.
by ray.wurlod
Thu Jul 26, 2012 4:51 am
Forum: General
Topic: Import jobs from higher version to lower version
Replies: 2
Views: 1618

You will get zillions of errors, and it may or may not work. IBM will tell you it won't work, and that's true in many cases. Only if your 8.7 components are fully 8.1 compatible (no 8.5 or 8.7 functionality) will this have any chance at all of succeeding.
by ray.wurlod
Wed Jul 25, 2012 11:29 pm
Forum: General
Topic: Can UtilityRunJob utility run a parallel job
Replies: 4
Views: 1598

Of course it's possible, but you still need to incorporate all the logic to determine which job it is you need to run.
by ray.wurlod
Wed Jul 25, 2012 11:00 pm
Forum: General
Topic: Can UtilityRunJob utility run a parallel job
Replies: 4
Views: 1598

1. Yes (in a Routine activity) but why would you when you have the Job activity. It's going to be just as complex by this route as using Job activities.

2. Yes.
by ray.wurlod
Wed Jul 25, 2012 10:58 pm
Forum:
Topic: How to change Business Glossary Overview page
Replies: 8
Views: 4554

In version 8.7 they're available in the Administration tab of the Business Glossary browser itself.
by ray.wurlod
Wed Jul 25, 2012 10:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not In clause in Filter stage...
Replies: 8
Views: 12847

The following list summarizes the Boolean expressions that are supported. In the list, BOOLEAN denotes any Boolean expression. - true - false - six comparison operators: =, <>, <, >, <=, >= - is null - is not null - like 'abc' (the second operand must be a regular expression) - between (for example...
by ray.wurlod
Wed Jul 25, 2012 5:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle ties in QualityStage Survive Stage
Replies: 3
Views: 1867

Welcome aboard. I would guess (without testing) that the tie with the record with the highest match weight would survive in this case.
by ray.wurlod
Wed Jul 25, 2012 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exporting nullable field without null handling properties
Replies: 6
Views: 8933

Were I the support analyst for this PMR I'd ask for the complete error message so that I could determine which stage was actually throwing the error. For example it might be a Sequential File stage somewhere else in the job design. It's really important to extract all possible information from error...
by ray.wurlod
Wed Jul 25, 2012 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Range Lookup and Aggregation in same time
Replies: 3
Views: 1499

What have you tried? What did you achieve?

Or do you want us to solve all your problems for you? That's called "consulting" and comes at a fee.
by ray.wurlod
Wed Jul 25, 2012 5:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to connect to Unidata using ODBC
Replies: 1
Views: 1443

Once you've run VSG over your Unidata account it should be able to be accessed via the UniODBC driver. Therefore it will be necessary to install that driver on your DataStage Engine tier. Do this from the U2 clients media (usually CD or DVD). Note that the UniData stages in DataStage do not use an O...