Table Definition Locked by User

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
Nisusmage
Premium Member
Premium Member
Posts: 103
Joined: Mon May 07, 2007 1:57 am

Table Definition Locked by User

Post by Nisusmage »

Hello All,

I've just created a new Table Definition and half way through Windows decided to shutdown and restart with a problem in the winlogon.exe file.

Now, when I tried to open the Table Definition, I get the error message "The Table Definition 'Definition name' is locked by user 'garya'". The user locking it is ofcourse myself.

How do I clear that lock ?

Thnks
~The simpliest solutions are always the best~
~Trick is to understand the complexity to implement simplicity~
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Search the forum, you need to use a telnet to the DS Server and the UNLOCK USERNO xxxx ALL statement from the DS Engine command line, where xxxx is the userno associated with the table definition lock.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Nisusmage
Premium Member
Premium Member
Posts: 103
Joined: Mon May 07, 2007 1:57 am

Post by Nisusmage »

Not Resolved.

I cannot explain it or replicate this problem. The Table Definition somehow unlocked itself in time. I did nothing.

Regards.
~The simpliest solutions are always the best~
~Trick is to understand the complexity to implement simplicity~
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

dsdlockd probably cleaned up for you.
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