dscc - locks not cleared

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
jim.paradies
Premium Member
Premium Member
Posts: 25
Joined: Thu Jan 31, 2008 11:06 pm
Location: Australia

dscc - locks not cleared

Post 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>
Jim Paradies
Post Reply