| DSQSBSTG |
B |
TSO, CICS |
- Controls or sets
- Maximum amount of virtual storage per user that is
to be used for report operations.
- Valid values
- 0 - 2147483647
- Specifies storage in bytes.
- 0KB - 2097152KB
- Specifies storage in KB.
- 0MB - 2048MB
- Specifies storage in MB.
- 0GB - 2GB
- Specifies storage in GB.
- 1% - 100%
- Specifies a percent of available storage. Percentages are valid
in TSO only.
- Defaults
- 0
- When you start QMF in TSO,
ISPF, or native z/OS®.
If
you set this parameter to a value of less than 15000 in these environments,
15000 is used automatically.
- 500000
- When QMF is
started in CICS
For more information, see Defining a fixed amount of virtual storage for reports
|
| DSQSDBCS |
K |
TSO, CICS |
- Controls or sets
- Printing of DBCS data from non-DBCS display devices
- Valid values
- YES (supports printing DBCS data from non-DBCS display devices)
or NO (does not set this support)
- Default
- NO
For more information, see Printing DBCS data from non-DBCS display devices.
|
| DSQSDBNM |
D |
TSO, CICS |
- Controls or sets
- Name of initial database location to connect to before the QMF home panel is displayed
- Valid values
- Any valid database name; location names can be up to 16 characters.
Do not use this parameter when you start QMF for TSO as
a Db2® for z/OS stored
procedure.
- Default
- For CICS,
the default database that is currently being used by CICS.
Otherwise, the the default database for the subsystem that is being
used.
For more information, see Specifying the initial database connection.
|
| DSQSDBQN |
— |
CICS |
- Controls or sets
- Name of CICS resource
to use for QMF trace data
- Valid values
- Any name that follows CICS queue-naming
conventions
- Default
- DSQD
For more information, see Setting the trace for CICS.
|
| DSQSDBQT |
— |
CICS |
- Controls or sets
- Type of CICS resource
to use for QMF trace data
- Valid values
- TS (uses a CICS temporary
storage queue) or TD (uses a CICS transient
data queue)
- Default
- TD
For more information, see Setting the trace for CICS.
|
| DSQSDBUG |
T |
TSO, CICS |
- Controls or sets
- Level of trace detail
- Valid values
- ALL (traces all functions at the highest level of detail) or NONE
(no trace data is recorded). Do not use this parameter when you start QMF for TSO as
a Db2 for z/OS stored
procedure.
- Default
- NONE
For more information, see Setting the trace for TSO and Setting the trace for CICS.
|
| DSQSFISO |
ISO |
TSO, CICS |
- Controls or sets
- Controls the format of CHAR(datetime-expression) data within a QMF report.
The setting controls whether QMF packages that are precompiled with the DATE(ISO) and TIME(ISO)
options are used. This parameter sets the DSQAO_DSQSFISO global variable and provides an initial
setting for the DSQEC_DSQSFISO global variable.
- Valid values
- YES
- Results of the CHAR(datetime-expression) function that do not specify a
format will be seen in ISO format. QMF packages that are precompiled with the DATE(ISO) and
TIME(ISO) options are used.
- NO
- Results of the CHAR(datetime-expression) function that do not specify a
format will be seen in the format of the DATE FORMAT and TIME FORMAT values specified on Db2
installation panel DSNTIP4. QMF packages that are not precompiled with the DATE(ISO) and TIME(ISO)
options are used. To determine the DATE FORMAT and TIME FORMAT values defined in the current Db2
subsystem, reference the DSQAO_DATE_FORMAT and DSQAO_TIME_FORMAT global variables.
- Default
- YES
The behavior set by the DSQSFISO program parameter may be changed within a QMF session by setting
global variable DSQEC_DSQSFISO. The DSQSFISO program parameter setting provides the initial default
value for DSQEC_DSQSFISO. Note that if DSQEC_DSQSFISO is modified, the value of DSQAO_DSQSFISO will
not change. DSQEC_DSQSFISO should be referenced for the current behavior settings.
|
| DSQSIROW |
F |
TSO, CICS |
- Controls or sets
- Number of rows fetched from the database before the first screen
of the report is displayed
- Valid values
- From 0 to 99999999
- Default
- 100
For more information, see Controlling report wait time.
|
| DSQSMODE |
M |
TSO, CICS |
- Controls or sets
- Mode of operation
- Valid values
- B (batch operation) or I (interactive operation). Do not use this
parameter when you start QMF for TSO as
a Db2 for z/OS stored
procedure.
- Default
- I (B if QMF is
started through the callable interface)
For more information, see Specifying the mode of operation (interactive or batch).
|
| DSQSMRFI |
MR |
TSO, CICS |
- Controls or sets
- Use of Db2 for z/OS multirow
fetch and insert features. This parameter sets the DSQAO_DSQSMRFI
global variable.
- Valid values
- YES (multirow fetch and insert is used) or NO (single-row
fetch and insert is used). If you are using a query accelerator, verify
its rowset cursor capabilities before setting this value to YES. Some
query accelerators do not support queries that are run with rowset
cursors, which are used by multirow fetch.
- Default
- NO
For more information, see Enabling support for multirow fetch and insert.
|
| DSQSMTHD |
MT |
TSO |
- Controls or sets
- Use of second Db2 for z/OS thread per user. This parameter
sets the DSQAO_DSQSMTHD global variable.
- Valid values
- YES (use a second Db2 for z/OS thread) or NO (use a single Db2 for z/OS thread). The second thread is active only
during RUN QUERY, DISPLAY TABLE commands and subsequent scrolling
(BOTTOM, TOP, FORWARD, BACKWARD, RIGHT, and LEFT) of reports with
open cursors. Commands that make use of a complete report such as
EXPORT DATA, SAVE DATA, PRINT REPORT, and DPRE will also use the second
thread.
- Default
- NO
|
| DSQSPILL |
L |
TSO, CICS |
- Controls or sets
- Use of extra storage to hold data that is no longer needed in
active storage
- Valid values
- YES (uses spill storage for data no longer needed in active storage)
or NO (does not use spill storage)
- Default
- YES when QMF is
running under TSO;
NO when QMF is
running under CICS.
When DSQSPILL is YES, use DSQSPTYP to specify the type of storage
to be used for spill data.
For more information, see Acquiring extra storage for data no longer needed in virtual storage.
|
| DSQSPLAN |
P |
TSO |
- Controls or sets
- Name of QMF application plan
- Valid values
- Any valid v application
plan name. This parameter is required in the DSQSCMDn exec
when you start QMF for TSO as
a Db2 for z/OS stored
procedure.
- Default
- QMF1310
For more information, see Specifying the name of the QMF application plan.
|
| DSQSPRID |
U |
TSO |
- Controls or sets
- QMF profile key for QMF for TSO installations
- Valid values
- PRIMEID (QMF authenticates
the user's Db2 primary authorization
ID against the CREATOR column of the Q.PROFILES table) or TSOID (QMF authenticates
the user's TSO logon
ID against the CREATOR column of the Q.PROFILES table). Only a value
of PRIMEID is allowed when you start QMF for TSO as Db2 for z/OS stored
procedure.
- Default
- PRIMEID
For more information, see Specifying which ID to use as the QMF profile key under TSO.
|
| DSQSPTYP |
ST |
TSO |
- Controls or sets
- Use of extended storage to hold data that is not needed in active
storage; supported only when the DSQSPILL parameter is set to YES
- Valid values
- FILE (spills data to a file) or 64BIT (spills data to extended
virtual storage)
- Default
- FILE
For more information, see Spilling report data to extended virtual storage (TSO only).
|
| DSQSRSTG |
R |
TSO |
- Controls or sets
- Number of bytes of storage that you want to reserve from the TSO region
to be used for applications other than QMF
When QMF generates
the first report in a QMF session,
it subtracts the amount of storage specified by this parameter from
the amount of free continuous storage available to QMF at
the time. The remaining storage is then available for QMF report operations for the remainder of the QMF session.
- Valid values
- From 0 to 99999999
- Default
- 0
For more information, see Reserving virtual storage from the TSO region to be used for applications other than QMF.
|
| DSQSRUN |
I |
TSO, CICS |
- Controls or sets
- Name of QMF procedure to
run when QMF starts,
before the QMF home panel is
displayed
- Valid values
- Any valid procedure name. Do not use this parameter when you start QMF for TSO as
a Db2 for z/OS stored
procedure.
- Default
- No initial procedure is run
For more information, see Specifying an initial procedure to run when QMF starts.
|
| DSQSSPQN |
— |
CICS |
- Controls or sets
- Name of CICS queue
to hold data no longer needed in active storage when DSQSPILL has
been set to YES
- Valid values
- Any name that follows CICS queue-naming
conventions
- Default
- DSQSnnnn (where nnnn is
the CICS terminal
ID)
For more information, see Spilling report data to a file in CICS.
|
| DSQSSUBS |
S |
TSO |
- Controls or sets
- Name of Db2 subsystem in
which to start QMF under TSO
- Valid values
- Any valid Db2 subsystem
name. This parameter is required in the DSQSCMDn exec
when you start QMF for TSO as
a Db2 for z/OS stored
procedure.
- Default
- DSN
For more information, see Specifying the name of the Db2 for z/OS subsystem in which to start QMF under TSO.
|