Monitor TM1 locks

Post Reply
User avatar
FallenCipher
Posts: 8
Joined: Mon Aug 13, 2012 8:17 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013
Location: Germany

Monitor TM1 locks

Post by FallenCipher »

Hi!

Is there any way in TM1 to see which objects are currently locked by any thread, process or user (R-Rock, IX-Lock etc.)?
I currently have problems with parallel execution of TM1 cube load chores even with parallel interaction and need a little debugging.

My second question would be:
If you start a TM1 chore (regardless of single or multiple commit) it holds a minimum of 1 IX lock for the time of execution. Does anyone know, on which object the chore holds the lock?

Greetings Fallen
"Who's the more foolish? The fool, or the fool who follows him?"
- Obi-Wan Kenobi, Star Wars Episode IV
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Monitor TM1 locks

Post by jim wood »

Have you tried using TM1 Top? There are plenty of posts about that on here.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
FallenCipher
Posts: 8
Joined: Mon Aug 13, 2012 8:17 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013
Location: Germany

Re: Monitor TM1 locks

Post by FallenCipher »

jim wood wrote:Have you tried using TM1 Top? There are plenty of posts about that on here.
Yeah, but it only shows the most recent lock of a thread. If a thread hold multiple locks, you can't see them.
"Who's the more foolish? The fool, or the fool who follows him?"
- Obi-Wan Kenobi, Star Wars Episode IV
Post Reply