dscc - locks not cleared
Posted: Tue May 24, 2011 5:10 pm
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>
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>