Setting MEMLIMIT

The EXPORTLOG command requires the specification of the MEMLIMIT parameter with a value of 1M or greater.

About this task

MEMLIMIT specifies the maximum amount of 64–bit storage that can be allocated to a single address space. Db2 Query Monitor uses 64–bit storage for two purposes. First, in an ISPF session, Db2 Query Monitor allocates a 1 megabyte log area. Second, when CAE browser client users specify the TopN function, 64–bit storage is allocated in the CAE agent address space for the sorting operation associated with TopN.

For the log function in the Db2 Query Monitor ISPF user interface, a MEMLIMIT of 1 megabyte or greater is required.

For the CAE browser client and the TopN function, the amount of storage required to complete this processing is related to the number of UNIQUE SQL STATEMENTS that occur in the interval range that has been selected by the user. 64-bit storage is allocated in 1 megabyte chunks. Db2 Query Monitor will not allocate more than 4 gigabytes of 64-bit storage for the TopN function in the CAE agent address space.

Approximately 700 unique SQL statements can be represented in 1 megabyte of 64–bit storage for the TopN function.

To estimate the MEMLIMIT setting for “Top N”, the customer can take the maximum number of UNIQUE SQL STATEMENTS that will be included within the interval range selected for “Top N” processing and divide by 700 to get a MEMLIMIT value. If the MEMLIMIT value is set too low, an ABEND 3193 will be generated in the CAE agent address space. If ABEND 3193 occurs, the following message will be issued in the CAE browser client:

com.rocketsoft.nm.qm.ipc.AbendException: 
Abend U3193 during query for data source 16 (SQL METRICS STANDALONE);
access type 64 (:REDUCE BY KEYS THEN RETURN);

MEMLIMIT is specified in the SMFPRMxx parameter file in the System Parmlib. The default value is NOLIMIT, but if a value of less than 1M is specified, CQM260E will be issued and Query Monitor will not initialize under ISPF.10000M is therefore the minimum recommended MEMLIMIT setting.

Procedure

You should specify a MEMLIMIT value of 1M or greater on the EXEC card of the TSO log in PROC or specify a value of 1M or greater in the SMFPRMxx member in PARMLIB. Db2 Query Monitor will allocate an area of 64–bit storage for a log in ISPF. 1 megabyte is sufficient for this purpose. However, if other products in ISPF require 64–bit storage, their requirements might be greater than 1M. The MEMLIMIT can be specified on the EXEC card of your TSO log in proc: 
//TSOPROC EXEC PGM=IKJEFT01,REGION=0M,DYNAMNBR=175,
//             PARM='%LOGINIT',TIME=1440,MEMLIMIT=10000M
If not specified there, then the value in the SMFPRMxx member in their PARMLIB concatenation is used. 
MEMLIMIT(10000M)

If no MEMLIMIT parameter is specified, the default is the value defined to SMF, except when REGION=0K/0M is specified, in which case the default is NOLIMIT. If MEMLIMIT is not specified in SMFPRMxx, the default value for this is the system default, 2G. If you want to use virtual storage above the bar, you must set the MEMLIMIT explicitly.

For more information see: