Friday, July 07, 2006

Releasing User lock on DBC

What to do if someone tries to logon to DBC with a wrong password three times and locks the user ???

Solution:
1. Logon as Root (on to the gateway node).
2. Enter cnsterm 6 on the UNIX command line. This will display the
Database Window Supervisor screen.
3. To start a console utility, type 'start tstsql'). The display will tell you which partition tstsql was
started in (i.e., Window 1).
4. Press the Delete key (CTRL + D) and enter cnsterm 1. You will now see the
contents of Window 1 (i.e., the TSTSQL program)
TSTSQL here. Enter your logon or TSTSQL command:
>.logon dbc,
.logon dbc,

*** Logon successfully completed.
*** Time was 0 seconds.
TSTSQL -- Enter DBC/SQL request or TSTSQL command:
> MODIFY USER dbc AS RELEASE PASSWORD LOCK;
MODIFY USER dbc AS RELEASE PASSWORD LOCK;


*** Database/User has been modified.
*** Time was 0 seconds.

TSTSQL -- Enter DBC/SQL request or TSTSQL command:

5. Press the DELETE key and enter cnsterm 6 to move back to the
Supervisor display.
6. Type stop 1 to terminate the utility that was running in Window 1 (i.e.,
TSTSQL).

3 Comments:

Blogger Manas said...

Nice Post Ranjit. Thanks!!!

1:45 am  
Blogger Manas said...

Useful Post!! Thanks Ranjit

1:46 am  
Blogger Andrew E said...

One additional note. Once you logon as DBC, nostop will be set to TRUE (use cnscim -s to show this) so "stop 1" will not work. The best way to exit is .logoff followed by .quit in the tstsql window.

2:42 am  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home