|
View previous topic :: View next topic
|
| Author |
Message |
aviswam
New User
Joined: 17 Mar 2009
Posts: 9
Location: India
|
|
|
|
Hi,
Is there any command to see the active Threads against a Tablespace ?
Just like -DIS THD (*)
I am having DB2 version 9 in ZOS, when a program or query is executed i would like to see the active thread details in DB2 tablespace.
Thanks, |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
If you have a system monitoring tool like BMC MainView for DB2, you can see all the activities.
Perhaps, you can try the below options as well.
| Code: |
-DIS DB(dbname) SPACENAM(tsname) CLAIMERS
-DIS DB(dbname) SPACENAM(tsname) LOCKS
-DIS DB(dbname) SPACENAM(tsname) USE |
|
|
| Back to top |
|
|
aviswam
New User
Joined: 17 Mar 2009
Posts: 9
Location: India
|
|
|
|
Gnanas,
I tried
| Code: |
| - DIS DB(DBNAME) TS(TSNAME) CLAIMERS |
Is the Agent Token no and the Thread Token No the same?,
Could you please confirm.
Thanks, |
|
| Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
| Back to top |
|
|
|
|
