Search found 27 matches

by RayLade
Tue Sep 19, 2006 9:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delete orphan dataset
Replies: 6
Views: 4702

delete orphan dataset

Is it OK to use a unix rm statement to remove the orphan datasets in my resource disk "/cba_app/dstemp/iis_fdm/datasets/temp01" {pools ""} directories ?
I would use orchadmin rm on them, but the dataset definition files have already been deleted.
by RayLade
Wed Jul 19, 2006 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding Environment Variables
Replies: 4
Views: 2109

That sounds like a plan, I'll try and suppress them from the job log.
After all, its not how you feel, but how you look that counts 8)
by RayLade
Wed Jul 19, 2006 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding Environment Variables
Replies: 4
Views: 2109

The variables are defined in all projects. Setting them True and False appears to be working too. It is just the messages in the &PH& directory that have me concerned. I can get all the... The variable "APT_blaa_blaa_blaa" is not in the environment. ... messages to go away simply b...
by RayLade
Wed Jul 19, 2006 7:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding Environment Variables
Replies: 4
Views: 2109

Understanding Environment Variables

I have 3 projects (DEV, SIT & UAT) In DEV, the &PH& logs state... The variable "APT_NO_JOBMON" is not in the environment. The variable "APT_PM_PLAYER_TIMING" is not in the environment. In the other two, the &PH& log states... The variable "APT_DISABLE_COM...
by RayLade
Mon Jul 03, 2006 12:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kill a job when DsDirector Stop does not work
Replies: 10
Views: 4976

Re: How to kill a job when DsDirector Stop does not work

Thanks for that, I shall try it out next hang... I think my "hangs" are related to my "aborts". Today I got a "PID 21174 has failed", 2 "Failure during execution of operator logic", 2 "not a runnable job" and one "other error". All jobs ran...
by RayLade
Sun Jul 02, 2006 6:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kill a job when DsDirector Stop does not work
Replies: 10
Views: 4976

The DBA is a helpful chappy, open to bribery, and I expect his assistance the next hang. As for our select/update strategy, our parallel jobs select from their own staging tables, work within their own datasets, and then insert into their own partition of the datamart. I think this is fairly efficie...
by RayLade
Fri Jun 30, 2006 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kill a job when DsDirector Stop does not work
Replies: 10
Views: 4976

That would be too simple Ray, I have a situation where a corporation use this server, and no one in particular is resoponsible for what happens... I need a crash course on SysAdmin of DS (easily said than done). I have a technique of re-compile and re-index which sorts the problem out, but it is a b...
by RayLade
Thu Jun 29, 2006 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kill a job when DsDirector Stop does not work
Replies: 10
Views: 4976

thank you both Ken and Ray. I'll go investigate list_readu. These things happen a lot over here, and are referred to as "resource problems". Then a lot of killing goes on, followed by re-compiles and re-indexing. I am looking for more subtle ways of manageing these issues. Basically, I try...
by RayLade
Thu Jun 29, 2006 6:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to kill a job when DsDirector Stop does not work
Replies: 10
Views: 4976

How to kill a job when DsDirector Stop does not work

I have a sequence, calling a sequence, calling a sequence, calling a job. For some reason, the job hangs. I've tried stopping the job via DsDirector's Stop button, and get a "stop has been sent to the server" dialog box. After a while, when nothing appeared to happen, I tried "stoppin...
by RayLade
Fri Jun 02, 2006 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs suddenly become un-runable
Replies: 9
Views: 2844

OK, I've recompiled the project and reindexed it. Ran a few jobs that had been causing me problems, and they ran ok. I banked up a series of jobs and have left them running over the weekend. I shall investigae on monday. A problem is that there are other teams using the server, and I can't see what ...
by RayLade
Thu Jun 01, 2006 5:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs suddenly become un-runable
Replies: 9
Views: 2844

Still chasing... our scratch and &PH& space is purged everyday for files older than 5 days. We have 30gig free for datasets and scratch, and 2.6 for $DSHOME (&PH&). Jobs that were recompiled and started working, have since "gotten worn out". I shall recompile the project an...
by RayLade
Wed May 31, 2006 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs suddenly become un-runable
Replies: 9
Views: 2844

Jobs suddenly become un-runable

Whilst running a series of sequences, all of a sudden, a series of jobs became unrunable. Some gave a -99 "other error", some claimed the job was not compiled and others reported "not executable RT_etc" problems. Re-compiling the jobs fixed the problem. My questions are, "am...