cancel
Showing results for 
Search instead for 
Did you mean: 

Delete stale user sessions

Phenom
Phenom

How can I delete stale user sessions from server ? See the attached image.

 

Thanks in advance for your inputs.

4 REPLIES

Re: Delete stale user sessions

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom
The easiest way is to wait for the next downtime and run "clearlocks -assert_all_dead". Not to be done while users are still in the system.

Otherwise, you'll have to find the process id from the syslog (typically, "ayt
local says dead, locks are held by process AARRcRLF2fTX6D") then run the following SQL commands:

DELETE from pom_m_lock where process = 'AARRcRLF2fTX6D';
DELETE from pom_r_lock where process = 'AARRcRLF2fTX6D';
COMMIT;

Clears all locks attained by that process.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Evaluating:AW 3.2

Re: Delete stale user sessions

Genius
Genius

Hi Randy,

When I login  as DBA and try to view 'Current Login Users', I get an option to Purge. Is this same as Deleting DB locks?

TC 11.2.1

TC11.png

 

Thanks

NaveenGM

TC11.2.1

 

Re: Delete stale user sessions

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom
Yes! Purging is the same.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Evaluating:AW 3.2

Re: Delete stale user sessions

Phenom
Phenom
Thanks Randy, ran clearlocks early morning when no one was there Smiley Happy