Hi All,
How to find how many datasets are opened for the particular DB2 address space. I read, if huge number of datasets are in open state, then it would impact performance problm - VSAM to do a lot of GETMAINs/STORAGE OBTAINs** in subpool 252.
Anyone, help from forum ???
Antony.
Number of DB2 Open dataset ????
Previous topic • Next topic • 2 posts
• Page 1 of 1
Number of DB2 Open dataset ????
by Antonyraj85 » Tue Sep 25, 2012 7:21 pm
- Antonyraj85
- Posts: 79
- Joined: Mon Jun 14, 2010 9:51 am
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- how to mask the phone number
by kumarinfy » Wed Mar 29, 2017 7:32 pm - 2 Replies
- 3071 Views
- Last post by kumarinfy
Mon Apr 10, 2017 2:35 pm
- how to mask the phone number
-
- Getting the number of rows before fetch?
by jijojohn2367 » Sat Jul 15, 2017 1:02 pm - 1 Replies
- 2543 Views
- Last post by NicC
Sat Jul 15, 2017 5:17 pm
- Getting the number of rows before fetch?
-
- Decrease the number of extent
by samb01 » Mon Nov 04, 2019 1:15 pm - 0 Replies
- 1578 Views
- Last post by samb01
Mon Nov 04, 2019 1:15 pm
- Decrease the number of extent
-
- maximum row number limitaion on fetch?
by kihaho » Wed Dec 10, 2008 10:06 pm - 1 Replies
- 2353 Views
- Last post by dick scherrer
Thu Dec 11, 2008 2:56 am
- maximum row number limitaion on fetch?
-
- Total Number of String Counts
by tdanielxyz » Sat Sep 07, 2019 9:44 pm - 1 Replies
- 2608 Views
- Last post by tdanielxyz
Sun Sep 08, 2019 1:19 am
- Total Number of String Counts