Command Reference Guide

Object EVAR Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
6-5
Example—ADD EVAR
required. Use of the specific service $AS is not significant here; the asterisk (*) wild
card is less ambiguous.
CS>add evar $AS."TDM_Default_DataSource".=GROUP, type define, value 'CLASS MAP,
FILE $DATA3.PERSNL.GROUP';
-- ADD EVAR \ODBC.*.TDM_Default_DataSource.=GROUP Successful
This example adds an EVAR type rmp and displays it. The EVAR is named
"ESTIMATED COST" in uppercase and enclosed in double quotes to protect the space
character. Entering the name in lowercase is permitted, but all characters are
automatically converted to uppercase.
In this example, the service name and data source name are defaulted to those used
in the preceding example:
CS>add evar "ESTIMATED COST", type rmp, limit 5000, action log_with_info;
-- ADD EVAR \ODBC.$AS.
TDM_DEFAULT_DATASOURCE.ESTIMATED COST Successful
CS>info evar *, type rmp;
-- INFO EVAR \ODBC.$AS.
TDM_DEFAULT_DATASOURCE.* Report
Resource Management Policies:
ESTIMATED COST Limit: 5000 Action: LOG_WITH_INFO
This example is a set of adds showing at least one add for each EVAR type. The full
object name in the first command is the default for subsequent commands. Each
command produces a confirmation (not shown).
>>mode mxcs;
CS>ADD EVAR $AS."TDM_Default_DataSource".EMPLOYEE, type define, value
'CLASS MAP, FILE $DATA01.PERSNL.EMPLOYEE';
CS>ADD EVAR DEPT, type define, value 'CLASS MAP, FILE $DATA02.PERSNL.DEPT';
CS>ADD EVAR HIST_NO_STATS_ROWCOUNT, value '123456789';
CS>ADD EVAR HIST_NO_STATS_UEC, value '99';
CS>ADD EVAR QUERY_CACHE, value '10000';
CS>ADD EVAR QUERY_CACHE_MAX_VICTIMS, value '100';
CS>ADD EVAR QUERY_CACHE_STATISTICS, value 'ON';
CS>ADD EVAR QUERY_CACHE_STATISTICS_FILE, value '/home/testcachefiles/myStats';
CS>ADD EVAR TIMEOUT, value 'RESET';
CS>ADD EVAR SCRATCH_DISKS, value '$data01, $data02, \testsys.$data03';
CS>ADD EVAR "* TIMEOUT", prefix 'control table', value '3000';
CS>ADD EVAR "PERSNL.JOB MDAM", prefix 'control table', value 'OFF';
CS>ADD EVAR "ESTIMATED COST", type rmp, limit 123456, action STOP;
CS>ADD EVAR CATALOG, type set, value 'TANDEM_SYSTEM_NSK';
CS>ADD EVAR SCHEMA, type set, value 'PUBLIC_ACCESS_SCHEMA';
CS>ADD EVAR MPLOC, type set, value '$DATA03.PERSNL';
CS>mode sql;
>>
Note. Single and double quotes are required where shown.