DataStage Administrator

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

DataStage Administrator

Post by ewartpm »

Hi All

I'm trying to open the DataStage Administrator and get the following error:

CDSRUseraccess.TakeSharedLock: Internal error - Failed to open file: UV.ACCOUNT (81002)

I have stopped and restarted the services but still get the error. :cry:

Any help will be greatly appreciated.

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hello ewartpm,

if you "telnet localhost" on your Windows DS server, do you get a prompt and can you login to the account "UV" with your user-id and password?
If that works, do a "LOGTO <your ds project name>". If you get an error, tell us what it is; if not then the good news is that your account might not be corrupted.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Check whether any other person is working on the project in the same time.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Does the Admin take a lock on the account? I need to check up on that...
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Sainath - just had 3 people go into the Admin at the same time; that doesn't seem to be it.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

ArndW,

My assumption was in terms of someone bouncing the server or protecting the project etc.
ewartpm
Participant
Posts: 97
Joined: Wed Jun 25, 2003 2:15 am
Location: South Africa
Contact:

Post by ewartpm »

Thanks for the advice.
I have Telnetted into the project, gone into DS.Tools and rebuilt the indexes.

However, when I try to log onto a project (any project because we curently have 4 projects running concurrently) I get the following error:

Error calling subroutine: *DataStage*DSR_SELECT (Action=4); check DataStage is set up correctlyin project ForkliftDevIBR (The connection is broken (81002))

The services are running, project has been reindexed, I can log into the project using Telnet, so what's wrong now????
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What happens if, having connected via telnet and entered the DataStage environment, you execute the following commands:

Code: Select all

LOGTO UV
SELECT @ID, PATH FMT '40L' FROM UV.ACCOUNT;
(Trying to establish why a "can't open UV.ACCOUNT" error occurred.)
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