Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Increasing RID pool size

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Increasing RID pool size
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    Post subject:
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    Post subject:
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    Post subject:
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    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 To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts Pool Overflow in Mainframe ADABASE polymathtarun Java & MQSeries 4 Fri Jun 03, 2016 11:57 am
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm
No new posts Add Trailing Zeroes depending upon th... Rohit Umarjikar DFSORT/ICETOOL 3 Fri Oct 23, 2015 1:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us