Changing FLTABSZ will do nothing for you unless you are setting an inordinate number of file locks, which, if you are getting the "READU...." message, then this is not the case. Rather, you should be concerned with the GSEMNUM value. Think of GSEMNUM as the number of the locking tables, whereas GLTABSZ and RLTABSZ should be thought of as the number of entries allowable within each table.
You can increase the size of any of these, though usually there are less GROUP latches/locks (GLTABSZ) than READU locks (RLTABSZ). Since both are already set to 300, which is good sized, you may want to consider increasing the number of locking tables by upping the GSEMNUM value by a little bit. I don't recall what the universe default value for this is anymore (it's 97 for DataStage Engine), but you should really only be limited by the size which you can create your shared memory segment. When you change GSEMNUM, you then run uvregen, which will fail if you exceed your maximum shared memory value. Hope this helps. _________________________________________________________ "I reject your reality and substitute my own" - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct "Hennessey, Mark F." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/18/2005 03:02 PM Please respond to u2-users To [email protected] cc Subject [U2] UV - Setting FLTABSZ Back in February I changed GLTABSZ and RLTABSZ to 300. I have never changed FLTABSZ, which is set at 11. I'm revisiting the issue because during the day yesterday some users, for a brief period, started receiving the dreaded "READU THRESHOLD EXCEEDED" message. Sadly, I have not yet figured out why. Is there a good rule of thumb of how FLTABSZ should be set relative to GLTABSZ and RLTABSZ? Any help/advice would be greatly appreciated. Mark Hennessey ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
