DB2 Threads

Gurmeet · New User Joined: 22 Feb 2006 Posts: 46 Location: Pune

Do we have any thing in DB2 by which we can find the list of threads on a subsytem.

I am interested in a list where in I can have details of tables being accessed by various programs.

Please let me know if you need more about my requirement.

~Gurmeet

Gurmeet · New User Joined: 22 Feb 2006 Posts: 46 Location: Pune

Reposting with some changes:

Do we have any thing in DB2 by which we can find the list of threads on a subsytem.

I am interested in a list where in I can have details of all the tables being accessed by various programs or online users. I am looking for this info to find out any potential faults coming because of deadlocks.

Please let me know if you need more information about my requirement.

~Gurmeet

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

You can probably try work load analysis for your Db2 subsystem using BMC apptune provided BMC is supported in your installation.

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

For online transaction in CICS you can use the command DSNC DISPLAY STATISTICS provided you have appropriate levels of CICS authority.

Gurmeet · New User Joined: 22 Feb 2006 Posts: 46 Location: Pune

Thanks Anamika,

FYI, I also got the following command, which helped me in achieving the required.

-DIS DATABASE(DBNAME) SPACENAM(TSNAME) LOCKS

I was getting deadlocks for a particular table and tried to find out which applications are accessing that table on a given time.

The above command gave the required details.

~Gurmeet