Re: Can I alter the extent size of Sysprocedures?

HARINATH VENKATA wrote: > > Hi > > The sysprocedure table has large number of extents. Can I alter the next > extent size for sysprocedure table? You probably can but it is unneccessary and anyway you could not reorg or defragment the table successfully. I say it is unneccessary because sysprocedures and sysprocbody data, like all important catalog data, is cached in memory in a hashed cache table separate from the normal data buffer pool. The default table is large enough for about 50 active stored procedures and can be adjusted by sites requiring the caching of larger numbers of procedures using the PC_HASHSIZE and PC_POOLSIZE config parameters which are undocumented. You can get specifics of permitted values (one of these probably must be prime) from tech support. Art S. Kagel