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-:
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)"