Search found 53125 matches

by ray.wurlod
Thu Feb 09, 2006 9:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-02291
Replies: 7
Views: 2806

Correct. You read this in the original error message.

Code: Select all

ORA-02291: integrity constraint (SFADM.STG2_R_127_FK) violated - parent key not found 
by ray.wurlod
Thu Feb 09, 2006 9:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob staus Capturing
Replies: 8
Views: 2157

What happens on file unit 2 (stderr)? Read about dsjob and how it handles its output file units in the readme file for 7.5.
by ray.wurlod
Thu Feb 09, 2006 9:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to run a job which reads from an ODBC stage
Replies: 2
Views: 803

Welcome aboard. :D
Access violation is an attempt to use some memory you don't own. Common causes are trying to force too long a string into to small a buffer (for example "STRAWBERRY ICE CREAM" into a Char(16) field), and some operations with null values.
by ray.wurlod
Thu Feb 09, 2006 9:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSSendMailAttachmentTester routine
Replies: 2
Views: 1023

A DataStage log is not a file. It's a database table. It won't make a lot of sense to attach a DataStage log to an email.
by ray.wurlod
Thu Feb 09, 2006 9:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project getting locked
Replies: 22
Views: 9782

Is there an error code with the message? If so you might get more information out of the SYS.MESSAGE table. Or out of the Errors and Remedies manual reported to be part of Hawk.
by ray.wurlod
Thu Feb 09, 2006 9:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to update or insert
Replies: 4
Views: 1180

Of course, any of these "dual-mode upserts" have a performance overhead, as each involves up to two operations (replace is delete then insert). It's much better to perform existence checking within the job design then have a stream for "insert only" and a stream for "update only".
by ray.wurlod
Thu Feb 09, 2006 9:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the exact reference between Informatica&DataStag
Replies: 4
Views: 1011

DataStage is also object oriented, but it's not quite so obvious in the GUI. Each component you use in a design is instantiated from a class. For example a Transformer stage is an instance of the class of Transformer stages, as represented by a record in the DS_STAGETYPES table. When you "design" Da...
by ray.wurlod
Thu Feb 09, 2006 9:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the parameter of a job
Replies: 8
Views: 1940

Neither of these approaches will work satisfactorily in the next ("Hawk") release, where a new concept - parameter sets - is introduced to make life much easier with dealing with the same sets of parameters across multiple jobs and across multiple environments (via a concept called "values files" th...
by ray.wurlod
Thu Feb 09, 2006 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StageType XML Writer error in PX
Replies: 1
Views: 741

Are you using a lot of these? How many developers? How loaded is your development server? When you drag a stage onto the design canvas the stage type record (class, if you like) in DS_STAGETYPES is locked briefly while the inherited properties are copied into the new instance of the stage. If there ...
by ray.wurlod
Thu Feb 09, 2006 9:11 pm
Forum: Data Quality Best Practices
Topic: QS: limitation using datafile
Replies: 5
Views: 10683

Welcome aboard! :D

Are you running your QualityStage jobs independently or from DataStage. If the latter, why not have it split the source data into two streams for the separate QualityStage jobs? OK it's two copies of the data, but it's in memory rather than two physical files.
by ray.wurlod
Thu Feb 09, 2006 9:09 pm
Forum: Site/Forum
Topic: Can we expect detail responses?
Replies: 3
Views: 2825

It's possibly not been made explicitly clear, but we do have the capacity to make "non premium" responses. I have added a few of these already, when a brief, non-technical response was adequate. All of the premium posters are honest enough not to hide the kind of message New2DS worries about as prem...
by ray.wurlod
Thu Feb 09, 2006 3:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: De-install DataStage plugin?
Replies: 2
Views: 866

I've never seen uninstall instructions. I suspect "they" would take the view that unused stage types don't take up much room. You could try deleting the relevant records from DS_STAGETYPES (make sure you have a backup or export first).
by ray.wurlod
Thu Feb 09, 2006 3:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: usage analysis of hash file
Replies: 4
Views: 1033

Welcome aboard! :wink:
by ray.wurlod
Thu Feb 09, 2006 3:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reg DS_Audit
Replies: 15
Views: 3499

This is going to be a very long, very slow way to learn ED, one command per post at a time. Why not download the UniVerse manuals from IBM website (track down manuals on line for version 9.6) and learn from those?
by ray.wurlod
Thu Feb 09, 2006 3:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DB issue or DS issue?
Replies: 11
Views: 1913

Isolation level none means that you CAN read uncommitted transactions. That's what I was trying to get at in my earlier post. If the database is being updated while your select is running, and you are not isolating those transactions, then you will get different results at different times. Another t...