Search found 42189 matches

by chulett
Thu Mar 19, 2009 10:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence starts job but then immediately ends?
Replies: 7
Views: 2034

I had something very similar happen with a Sequence job with a Start/End loop structure. It would enter the loop for the first time and show that the included Job Activity had been started, but then immediately exit not only the loop but the Sequence job as well. Logs looked just like you posted. It...
by chulett
Thu Mar 19, 2009 2:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: bulk load
Replies: 3
Views: 1501

Any number of indexes on a target table will affect the load speed as each one adds overhead to the process... bitmapped ones even more so. But that doesn't mean it's always a good idea performance-wise to drop them all first and rebuild them all afterwards. However, if you do switch to a bulk load ...
by chulett
Thu Mar 19, 2009 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing log details from Datastage Director
Replies: 7
Views: 2385

probably you have guessed it correctly...the size of the log file is exceeding the default limit...that is why this error is being thrown... any command or option in DS to increase the limit of the hashed file manually? The command is RESIZE and the syntax for it is out there is the forums somewher...
by chulett
Thu Mar 19, 2009 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing log details from Datastage Director
Replies: 7
Views: 2385

Aren't you working with parallel jobs? How is a hash file coming into the picture? Because we're talking about a PX job's log, which is stored in a hashed file in all but the most recent release of the product. And from what we've seen here, the change to store them in the XMETA repository instead ...
by chulett
Thu Mar 19, 2009 2:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: bulk load
Replies: 3
Views: 1501

First tell us what you mean by 'load' here - what Update Action are you using in your OCI stage? Do your lookups prequalify the action needed on the database side, insert versus update, or are you using one of the crutch 'combo' actions to handle that for you? As for the 'bulk load' question, you do...
by chulett
Thu Mar 19, 2009 12:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringtoDecimal Issue
Replies: 7
Views: 2068

Is that because you're reading a 'DOS' file and not handling the record delimiter properly? :?
by chulett
Thu Mar 19, 2009 12:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing log details from Datastage Director
Replies: 7
Views: 2385

Yes, they can be converted to 64BIT hashed files, the 'limitation' is a function of the 32bit addressing they use by default. However, you really should look at why your jobs are logging that many messages. Is it simply a factor of the number of unique InvocationIDs you are using? Are they generatin...
by chulett
Thu Mar 19, 2009 10:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQLAllocHandle: Failed to allocate environment handle 'ENV'
Replies: 6
Views: 4336

I would say so, too. What does your official support provider have to say on the subject?
by chulett
Thu Mar 19, 2009 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter set used in Transformer = Compilation error
Replies: 13
Views: 3309

Druid_Elf wrote:But now you are actually reading the value of the project variable and you are not reading from the parameterset.
As the ancient philosopher Sam Ting would say - they are equivalent in this case. :wink:
by chulett
Thu Mar 19, 2009 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: failed to attach to project
Replies: 6
Views: 1677

We'll need to wait and see, but guessing the advice will be to upgrade to 8.1 as soon as possible as the 8.0.1 release is generally considered to be a buggy mess.
by chulett
Thu Mar 19, 2009 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter set used in Transformer = Compilation error
Replies: 13
Views: 3309

Try just GetEnvironment(DEF_UNKNOWN) as the parameter set name isn't part of the environment variable name that is actually set.
by chulett
Thu Mar 19, 2009 8:41 am
Forum: Site/Forum
Topic: Premium Membership
Replies: 17
Views: 15191

No, all it seems to mean is you had one at one point. Once the membership expires, the logo remains but they are unable to view Premium content. I would think the 'membership.director' would be the right one to contact, but adding the 'webmaster' in couldn't hurt.
by chulett
Thu Mar 19, 2009 8:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while viewing log details from Datastage Director
Replies: 7
Views: 2385

A "blink" is a "backwards link" which means your logs are corrupting, more than likely from blowing through the 2GB barrier for the hashed file in question due to the volume of entries being written to it. And a MI job still has a single hashed file log that everything writes to,...
by chulett
Thu Mar 19, 2009 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Goes To Exception Handler
Replies: 4
Views: 1540

Been discussed here many times, routines that do not return a zero are considered to have failed if the 'Automatically handle' option is ticked and you don't have the proper triggers set up from the Routine.
by chulett
Thu Mar 19, 2009 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pt of the file containing log of a job
Replies: 11
Views: 2611

Use a combination of the other two options, not the 'summary' one.