Search found 7 matches

by Dave Malia
Fri May 29, 2009 3:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see the Locks in the Director[Cleanup Resources]
Replies: 12
Views: 14607

ray.wurlod wrote:And do execute the dsenv script before entering the DataStage shell. ...
did i miss something? :wink:

I love the fact you can edit a previous post :D
by Dave Malia
Fri May 29, 2009 2:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increase number of nodes in CONFIGURATION file
Replies: 6
Views: 7045

Totally agree with you all on this subject which is why most of my answers pretty much said it depends on... or words to that effect. The only way to know what the system can handle and whats a good configuration for the jobs being run is basically to do some performance tests with different configu...
by Dave Malia
Thu May 28, 2009 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Increase number of nodes in CONFIGURATION file
Replies: 6
Views: 7045

Re: Increase number of nodes in CONFIGURATION file

Hi, I am using a 4 node CONFIGURATION file. I want to increase it to 8 node CONFIGURATION file but i have below questions: What all i should keep in mind before doing this? Will it really increase performance of my datatsgae job? Will it increase the number of datastage jobs which i can run simulta...
by Dave Malia
Thu May 28, 2009 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error:sqlldr not found.
Replies: 5
Views: 6063

Re: Error:sqlldr not found.

Hi, I have a simple parallel job which reads from a sequential file and loads into a oracle table. The job is aborting with following errors. Project:cvid (etlprd2) Job name:CvBT0002Job5SsaStageLoad_parllel.2 Event #:433 Timestamp:3/8/2006 1:00:10 PM Event type: Warning User:cvid Message: Oracle_En...
by Dave Malia
Thu May 28, 2009 7:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job is locked
Replies: 9
Views: 8959

I've found the Cleanup Resources option to be the simplest solution 99% of the time. Yes, sometimes you need to dig a little deeper and know the job number you are looking for, but very ... Use these methods to unlock: 1. use DS.TOOLS to manage processes and locks 2. if using UNLOCK - use LIST.READ...
by Dave Malia
Thu May 28, 2009 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see the Locks in the Director[Cleanup Resources]
Replies: 12
Views: 14607

Dave - good point with the attribute to select which process, I had forgotten all about and have never changed it. The default wait period for the deadlock daemon is 900; but setting it to a lower ... By the way, the best method for starting/stopping the daemon is from within the universe using the...
by Dave Malia
Thu May 28, 2009 5:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see the Locks in the Director[Cleanup Resources]
Replies: 12
Views: 14607

Deadlock Daemon

Hi, Q1 means that Cleanup resources option is not enabled. How to enable it so that i locks are visible when we select show all. Q2) please let me know what how to go about enabling the lock daemon and setting the time. thanks for your quick responses. Q2 - To start the daemon up modify the followi...