Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 Threads

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Gurmeet

New User


Joined: 22 Feb 2006
Posts: 46
Location: Pune

PostPosted: Tue Jun 06, 2006 9:27 pm    Post subject: DB2 Threads
Reply with quote

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
Back to top
View user's profile Send private message

Gurmeet

New User


Joined: 22 Feb 2006
Posts: 46
Location: Pune

PostPosted: Tue Jun 06, 2006 9:30 pm    Post subject: Re: DB2 Threads
Reply with quote

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
Back to top
View user's profile Send private message
anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Wed Jun 07, 2006 11:52 am    Post subject:
Reply with quote

You can probably try work load analysis for your Db2 subsystem using BMC apptune provided BMC is supported in your installation.
Back to top
View user's profile Send private message
anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Wed Jun 07, 2006 11:57 am    Post subject:
Reply with quote

For online transaction in CICS you can use the command DSNC DISPLAY STATISTICS provided you have appropriate levels of CICS authority.
Back to top
View user's profile Send private message
Gurmeet

New User


Joined: 22 Feb 2006
Posts: 46
Location: Pune

PostPosted: Wed Jun 21, 2006 8:19 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Error with opening new threads vasanthz General Talk & Fun Stuff 0 Fri Mar 13, 2015 1:34 am
No new posts How to Display the Active Threads aga... aviswam DB2 3 Wed Oct 03, 2012 1:05 pm
No new posts DB2 WLM - Hanging threads dineshchaudhry DB2 1 Thu Mar 26, 2009 1:43 pm
No new posts 3 threads of ProgA simultaneously XCT... Keanehelp CICS 1 Sat Mar 21, 2009 6:46 am
No new posts How can we get the number of running ... William Thompson CICS 4 Fri Apr 27, 2007 10:27 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us