Search found 42189 matches

by chulett
Wed Oct 07, 2009 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed File Stage read/write cache size
Replies: 3
Views: 1600

Hashed File Stage read/write cache size

I have a silly question on the Tunables project properties of the hashed file stage Read cache size and Write cache size, the ones that default to 128MB per project. While contemplating the consequences of changing them, I realized I didn't know something for a certainty - Do they indicate the amoun...
by chulett
Wed Oct 07, 2009 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buffer and schema variable padding do not match
Replies: 9
Views: 5597

Errr... don't you have to uncompress it before you can read it? :?
by chulett
Wed Oct 07, 2009 3:26 pm
Forum: IBM QualityStage
Topic: CASS Stage Error
Replies: 2
Views: 2511

Thanks for posting the resolution! :wink:
by chulett
Wed Oct 07, 2009 2:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Important, but doest exist? XML file in a column
Replies: 9
Views: 2252

And if it was stored as an XMLTYPE rather than a CLOB you could just query it. :wink:
by chulett
Wed Oct 07, 2009 2:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SMS notifications to Mobile
Replies: 5
Views: 2326

Send short emails to your cell phone. All carriers will have an "email address" for your phone. For example:

http://www.tech-recipes.com/rx/939/sms_ ... on_virgin/
by chulett
Wed Oct 07, 2009 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Random "Controller problem: Error calling DSRunJob code
Replies: 4
Views: 3366

I don't think you can look at this error strictly through the narrow telescope of the 11g upgrade. You need to look at it for what it is - a resource issue, an error simply meaning that it could not start a job within the hard-coded time window the engine enforces. How that relates to upgrading a re...
by chulett
Wed Oct 07, 2009 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle load with DIRECT=TRUE option
Replies: 8
Views: 2077

You really should discuss this with your DBA as these are Oracle specific questions and some of this gets very specific about Oracle internals. You've already quoted documentation on the ROWS option and Google will turn up tons more. Think of it *like* the array size of a conventional load. 'Analogo...
by chulett
Wed Oct 07, 2009 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Random "Controller problem: Error calling DSRunJob code
Replies: 4
Views: 3366

Have you searched for your error message here?
by chulett
Wed Oct 07, 2009 12:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert 32bit hash file to 64 bit
Replies: 10
Views: 5499

As noted, in that case you need to create a VOC record for this command to work. Use SETFILE for that, the syntax can be found here by searching.
by chulett
Wed Oct 07, 2009 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle load with DIRECT=TRUE option
Replies: 8
Views: 2077

Direct path loads do not issue commits so there's nothing for you to control there.
by chulett
Wed Oct 07, 2009 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running multiple scripts parallely using sequencer
Replies: 5
Views: 1883

Even "unlinked" Execute Command stages won't really run in parallel as the code first needs to start one before it can start the other. Since there's no concept of background processing of commands, it must wait for the first stage to finish before it can start the second stage. So they ru...
by chulett
Wed Oct 07, 2009 11:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert 32bit hash file to 64 bit
Replies: 10
Views: 5499

Is your hashed file in an "account" or "pathed" into a specific directory?
by chulett
Wed Oct 07, 2009 11:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Database Connection
Replies: 4
Views: 1602

The connections are dropped when the job completes as that's the only time it is "done extracting all the data".
by chulett
Wed Oct 07, 2009 11:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Import .dsx file
Replies: 3
Views: 1405

Or just import it from the Designer.