IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Increasing RID pool size


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Sat Nov 07, 2009 3:55 pm
Reply with quote

Hi,

I am working on DB2 v9.1 z/os.
I need to increase the RID pool size for our system.As far as i understand RID pool is used for the row id sorts which helps the optimizer during multi index access, joins etc...
In my system the present RID pool size value is 8000(i guess the default).
In the installation guide following eqn is given for calculating the same-:

Quote:
number of concurrent RID processing activities * average number of RIDs * 2 * 5 (bytes per RID)


Please guide me in finding the approx values for the same eqn. ie how should i proceed to find the "number of concurrent RID processing activities " and "average number of RIDs * 2 * 5 (bytes per RID)"

Please correct me if i am wrong anywhere.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sun Nov 08, 2009 12:25 pm
Reply with quote

I think Visual Explain will contain the statistics you desire.
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Mon Nov 09, 2009 1:50 pm
Reply with quote

HI dejunzhu,

We dont have license to Visual Explain. icon_cry.gif We have control centre and Omegamon performance expert.

Can u suggest some other way for the same?
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Mon Nov 09, 2009 5:47 pm
Reply with quote

IBM TivoliĀ® OMEGAMON XE for DB2 on z/OS contains all information that Visual Explain contains.

Furthermore, Visual Explain is free, no licence is needed. but it has been substituted by Optimization Service Center from DB2 v9.1.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Find the size of a PS file before rea... COBOL Programming 13
No new posts Masking variable size field - min 10 ... DFSORT/ICETOOL 4
No new posts Dataset size increase on adding 1 byt... DFSORT/ICETOOL 8
No new posts TWA size of the CPLT transaction CICS 0
Search our Forums:

Back to Top