Search found 53125 matches

by ray.wurlod
Wed Feb 04, 2009 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I unlock a job after it has been killed?
Replies: 2
Views: 1787

Tell the DS Admin that you NEVER kill processes associated with DataStage jobs. There are proper ways to stop jobs and remove their processes; kill -9 is not among them. So, the job is locked, and the lock is owned by a process that no longer exists (a "defunct" process). Your DS Admin is ...
by ray.wurlod
Wed Feb 04, 2009 3:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What are RT_BP and RT_STATUS files?
Replies: 5
Views: 3501

Anything with RT_ prefix is a run-time table; there are also RT_CONFIGnnn and RT_LOGnnn. No, you can't delete them. RT_STATUSnnn contains the status information for job number nnn and its active stages and resources, which you view in Director (in status and monitor views). RT_BPnnn contains the sou...
by ray.wurlod
Tue Feb 03, 2009 11:43 pm
Forum: General
Topic: Dataset gets deleted in the shared path as BEING_DELETED_FIL
Replies: 2
Views: 1332

Let me get this straight. Run 1 - the Data Set was not created. Run 2 - the Data Set could not be deleted. Is that right? Probably the Data Set stage is set to overwrite, and the "error" is spurious. What does your official support provider have to say? Is the error fatal, or does Run 2 fi...
by ray.wurlod
Tue Feb 03, 2009 9:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex FlatFile Stage View Data
Replies: 4
Views: 1359

Is there any OCCURS clause in the COBOL FD on which the CFF stage bases its operation?
by ray.wurlod
Tue Feb 03, 2009 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to load oracle table
Replies: 3
Views: 1509

Oooh, no, I don't think we can ignore it. Tell us what you did to castigate this "someone"!
by ray.wurlod
Tue Feb 03, 2009 5:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run 2 jobs Parallel in JOB SEQUENCER
Replies: 18
Views: 5716

JobA and Job2 started within the same second. Please post your actual job sequence design. Also please post the logged startup and execution times of all five jobs (including the job sequence).
by ray.wurlod
Tue Feb 03, 2009 5:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: When should I use "Entire" partitioning in a looku
Replies: 6
Views: 1473

On a single machine ("SMP" environment) you may as well use Entire, because it comes at no cost, via shared memory. In a multiple machine environment ("MPP", cluster, grid) there can be a substantial cost moving records to all nodes, so you tend to avoid Entire (other than for sm...
by ray.wurlod
Tue Feb 03, 2009 5:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where can I find the hashed file calculator?
Replies: 2
Views: 1115

Craig's memory is accurate. The actual folder is Utilies, and there's a sub-folder in there called Unsupported, and within that one for the HFC.
by ray.wurlod
Tue Feb 03, 2009 1:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: log file not updated in Director Client
Replies: 5
Views: 1620

Job logs are not stored in files - they are stored in database tables.

Try refreshing the Director client (View > Refresh).
by ray.wurlod
Tue Feb 03, 2009 1:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run 2 jobs Parallel in JOB SEQUENCER
Replies: 18
Views: 5716

Don't link them together. There ought to be no link from Job2 to Job3.

Code: Select all

         ------> Job2
   JobA 
         ------> Job3     
by ray.wurlod
Tue Feb 03, 2009 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem using Convert in Transformer
Replies: 31
Views: 8565

No, only the membership director can. You are not yet showing up as a premium member.
by ray.wurlod
Tue Feb 03, 2009 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: read the FileNameList.txt one by one and move it into target
Replies: 4
Views: 979

The other thread also gave the algorithm for the routine, if memory serves.
by ray.wurlod
Tue Feb 03, 2009 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SEQ. FILE PROBLEM
Replies: 3
Views: 884

It can not be done with a job design containing only passive stage types*. You need at least one active stage type.

* unless run multiple times, appending to the target and sorting the target in an after-job subroutine.
by ray.wurlod
Tue Feb 03, 2009 1:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Nulls causing a problem in Date Conversion
Replies: 4
Views: 1373

Handle the null explicitly - maybe convert it to a "high date" timestamp.
by ray.wurlod
Tue Feb 03, 2009 1:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information Server Blade for Server Jobs
Replies: 8
Views: 2206

They use the same dynamic configuration files that any grid configuration would use. The basis is a "standard" configuration file, and there are some environment variables that need to be set. I can not remember off the top of my head which ones they are.