Search found 53125 matches

by ray.wurlod
Thu Jan 22, 2009 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Setting microsecond portion of Timestamp???
Replies: 4
Views: 1413

What is the format picture you are using for the timestamp? Does it include the fractional seconds part?
by ray.wurlod
Thu Jan 22, 2009 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Multiple parameters to dsjob returns DSJE_DSJOB_ERRO
Replies: 15
Views: 8942

Rot. A member of the Developer role for DataStage (provided all other permissions and credentials are in place) can legitimately use dsjob command. What error message do you get?
by ray.wurlod
Thu Jan 22, 2009 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Truncate decimal with our rounding
Replies: 2
Views: 932

Read (in the Parallel Job Developers Guide manual) about conversion functions, and particularly about the rtype argument values for rounding/truncation.
by ray.wurlod
Thu Jan 22, 2009 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Metadata Repository in 8.0.1
Replies: 1
Views: 720

The metadata repository is for storing metadata in a format that is accessible to all Information Server products via metadata delivery and metadata analysis services. The installation software includes a script that will create all the requisite tables in Oracle 10g. (Earlier versions of Oracle are...
by ray.wurlod
Thu Jan 22, 2009 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Execute dsjob command from client machine
Replies: 25
Views: 8614

Doesn't necessarily make it right, especially if it's from IBM sales team!

Remember our recent discussion about the future of server jobs?
by ray.wurlod
Thu Jan 22, 2009 3:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Monitoring
Replies: 4
Views: 1154

Marginally. Maybe only negligibly. Depending on what you mean by "performance".
by ray.wurlod
Thu Jan 22, 2009 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting error while Logging in IBM InfoSphere
Replies: 6
Views: 4463

Welcome aboard. The important part of the message is "Failed to authenticate the current user against the selected Domain" - the stack trace is not helpful unless you happen to have source code (which IBM does not release). Is this user actually registered in Information Server and credent...
by ray.wurlod
Thu Jan 22, 2009 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Reject records
Replies: 15
Views: 4039

The reject link should not have any connection to the Transformer stage. It is an output from the ODBC Enterprise stage. Its link type must be Reject (painted in long dashes in the design area).
by ray.wurlod
Thu Jan 22, 2009 3:32 pm
Forum: General
Topic: DS 7.5.3 - weird problems regarding sequencer and loop
Replies: 2
Views: 1775

An "all" sequencer will generate this message if the job sequence ends and at least one of the sequencers inputs has not fired.

The restart mechanism keeps track of where it was up to in the loop.
by ray.wurlod
Thu Jan 22, 2009 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling through Datastage
Replies: 16
Views: 5438

You can test for a corrupted RT_CONFIG62 using UVFIXFILE RT_CONFIG62 command. The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director? What happens when you execute this com...
by ray.wurlod
Thu Jan 22, 2009 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling through Datastage
Replies: 16
Views: 5438

You can test for a corrupted RT_CONFIG62 using UVFIXFILE RT_CONFIG62 command. The JOBPARAMINSTS record in RT_CONFIG62 will not be created until that particuar job (job number 62 in DS_JOBS) is actually scheduled. Is the job showing in schedule view in Director? What happens when you execute this com...
by ray.wurlod
Thu Jan 22, 2009 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Oracle Connectivity
Replies: 2
Views: 1212

Is Oracle client software properly installed and configured on the DataStage server machine(s)?
by ray.wurlod
Thu Jan 22, 2009 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll
Replies: 2
Views: 3628

And your shared library search path might need to be corrected. Check PATH, LIB and LD_LIBRARY_PATH environment variables.
by ray.wurlod
Thu Jan 22, 2009 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle view data error
Replies: 3
Views: 1262

No, I think that's just a default table of file handles within the code. The message is informational only. It's definitely not related to T30FILE (which is only about dynamic hashed files) and it's almost certainly not related to MFILE (which is for the server engine rather than the parallel engine...