Page 1 of 1

dscc - locks not cleared

Posted: Tue May 24, 2011 5:10 pm
by jim.paradies
Hi all,

Has anyone come across what seems to be a bug in dscc. It only happens when compiling routines. The first time I compile all is good but the second time shows a lock error which I then have to clear using the cleanup_abandoned_locks script.

<pre>
$ dscc /d mydomain /h myserver /u jim /p jim /r ExecSqlPlus /ouc myproject

Intializing

Compiling "ExecSqlPlus" - Succeeded

1 Items Processed

Done.
$ dscc /d mydomain /h myserver /u jim /p jim /r ExecSqlPlus /ouc myproject

Intializing

Compiling "ExecSqlPlus" - Failed
The Routine 'ExecSqlPlus' is locked by user 'jim'
(SessionID '26846584-37E9-48E1-98F0-2C18C57E1F25')

1 Items Processed

Done.
$ cleanup_abandoned_locks
Enter the username: jim
Enter the password:
$ dscc /d mydomain /h myserver /u jim /p jim /r ExecSqlPlus /ouc myproject

Intializing

Compiling "ExecSqlPlus" - Succeeded

1 Items Processed

Done.
$
</pre>