Unable to open "D_DS_JOBS"

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Unable to open "D_DS_JOBS"

Post by GJ_Stage »

I am getting Unable to open "D_DS_JOBS" file error message while running SELECT category FROM DS_JOBS WHERE NAME = 'job_name' in admin.

Please help. how to solve this issue?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What happened with your "jobs not displaying" issue? Did this start after a reindex attempt?
-craig

"You can never have too many knives" -- Logan Nine Fingers
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Post by GJ_Stage »

Still not able to see the jobs after attempt DS.REINDEX ALL command in admin.

It is saying "Unable to open DS_JOBS"...


Please help.
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Post by GJ_Stage »

Hi Craig ,

Your help more appreciated here.
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Post by GJ_Stage »

Still not able to see the jobs after attempt DS.REINDEX ALL command in admin.

It is saying "Unable to open DICT DS_JOBS"...
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

The admin tool usually runs in the UV account. You need to LOGTO a project.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

IS there a file in your project called D_DS_JOBS ? (This is the dictionary for DS_JOBS.) If it is present, check the permissions on it. If it is missing, find out who stole it and kill them, then copy D_DS_JOBS from another project or from the Template directory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply