RESLTHR parameter

From m204wiki
Jump to navigation Jump to search

APSY load threshold for making request resident


Default value
Parameter type
Where set
On User 0's parameter line or reset by system manager
Related products
Model 204 V5.1


The RESLTHR parameter specifies the minimum number of times an APSY precompiled procedure must be loaded into a user's server before Model 204 attempts to make the procedure's NTBL and QTBL resident and shareable in virtual storage. Once a procedure's NTBL and QTBL have been made resident, subsequent evaluation of that procedure no longer requires loading those tables into the user's server.

The RESLTHR default is -1; it indicates that the parameter has not been set and is not active.

The RESLTHR parameter is similar to the RESTHRSH parameter, which sets the minimum number of times a procedure must be swapped, along with the evaluating user, to CCASERVR before the procedure's NTBL and QTBL will be made resident. In a system with little or no server swapping, the number of APSY LOADs (and therefore RESLTHR) provides a better metric for determining whether to make a procedure's NTBL and QTBL resident. Resident requests may reduce CCATEMP I/O by as much as 20 percent and the number of bytes transferred per server I/O by as much as 30 percent.

You can view APSY LOAD statistics by using the MONITOR command with the STATISTICS parameter.