Record count warnings

This topic describes how the WUI can issue warnings if the expected number of records to be returned in certain views exceeds a set threshold.

This new feature is designed to issue a warning if a request to open certain views will result in a larger than expected amount of data. This provides an opportunity to alter the filters on these views and confirm or cancel the request before the request is executed.

This feature applies to the views associated with the following resources:
CMDT FEPINODE PROGRAM
CONNECT FEPIPOOL REMFILE
DB2CONN FEPITRGT REMTDQ
DB2ENTRY INDTDQ REMTRAN
DB2TRN INTRATDQ RQMODEL
DOCTEMP JOURNAL SMFJRNL
DSKJRNL JRNLNAME SYSDUMP
DSNAME LOCFILE TAPEJRNL
ENQMODEL LOCTRAN TCPIPS
EXITGLUE MODENAME TERMNL
EXITTRUE PARTNER TRAN
EXTRATDQ PROCTYP TRANDUMP
FEPICONN PROFILE TSMODEL
There are two ways of specifying the number of records required to trigger the warning mechanism: In both cases the default value is 0 meaning that no warnings are issued.

A value set in a user group takes precedence over a value set in the DEFAULTWARNCNT parameter. Before a warning is issued the WUI checks to determine whether or not the signed on user is associated with a user group (this can occur only if the WUI is running with security switched on). If so, the WUI uses any value for the warning count specified in that user group. If the user does not belong to a user group, or no maximum value is set, the WUI checks the initialization parameters and uses any value set there. If no value has been specified, the default of 0 is used.

If the value for the warning count is greater than 0, the WUI checks the size of the potential set of records to be returned. This gives an indication of the maximum number of records that could be returned. It is not always accurate because any filters other than that associated with the first part of the primary key field are not taken into account. If this potential value is greater than the value of the warning count, a warning screen like the one in Figure 1 is displayed. If the returned value is less than or equal to the warning count value, the WUI view is displayed in the usual way.
Figure 1. Warning count screenDetail of the Warning count for Program screen displaying message EYUVC1258

Clicking Refresh drives a new request. This allows you to alter the primary key field, which is included in the Warning count screen, to test a new filter value in order to produce a smaller set of results. Any other filters remain in place from the original request. If the set of results returned is not below the warning count limit, the warning count screen is redisplayed with the original warning count message. If the size is below the warning count limit, the warning count screen is redisplayed.

Clicking OK at the bottom of the screen performs the current request regardless of the number of results to be returned.

Clicking Cancel is the equivalent of pressing the back link on the browser; the previous screen is redisplayed.