Number of DB2 Open dataset ????



IBM's flagship relational database management system

Number of DB2 Open dataset ????

Postby Antonyraj85 » Tue Sep 25, 2012 7:21 pm

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.
Antonyraj85
 
Posts: 79
Joined: Mon Jun 14, 2010 9:51 am
Has thanked: 0 time
Been thanked: 0 time

Re: Number of DB2 Open dataset ????

 

Re: Number of DB2 Open dataset ????

Postby GuyC » Tue Sep 25, 2012 7:59 pm

have you even tried to google "DB2 open datasets" ????????????
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post