Summary
Part of the task of adding a new user or modifying a profile of an established user is determining whether that user should be able to override system defaults established by the System Option Table. CA Dataquery allows you to override some predefined system defaults. From the User Table Maintenance panel, select <PF4> ADDITIONAL OPTIONS to display the Override System Defaults panel.
Override System Defaults (DQUM0)
=> Enter the user information and press the appropriate PF key --------------------------------------------------------------------------DQUM0 DATAQUERY: USER TABLE MAINTENANCE - OVERRIDE SYSTEM DEFAULTS ------------------------------------------------------------------------------ USER NAME : ________________________________ USER OVERRIDES TO SYSTEM DEFAULTS. MXREQ : SORTPAG : ESTIMATED MAX I/O : MXTLR : SORTCTG : FNDBLKS : NETPRT ID : PRIMARY : SECONDARY : AREA FOR PERSONAL DATABASE TABLES: ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> ADD <PF4> NOT USED
Action
To override the defaults shown, type over them according to the following information. When the panel is complete, press <PF3> ADD to save the changes. Then press <PF2> RETURN to return to the User Table Maintenance panel.
Panel Description
(Optional. DQL mode only.) A numeric value from 1 through 99999 to specify a search limit for this user that overrides the system default. This feature limits the amount of time CA Dataquery is to process before pausing to allow the user to end the query. MXREQ keeps one query from monopolizing the system. (The system default is used if this value is zeros.)
(Optional. DQL mode only.) A value from 1 through 1024 to specify, in 4096-byte pages, the maximum amount of storage CA Dataquery is to allocate to process a single sort request without using the database index for sorting. The value specified here overrides the system default for this user.
(Optional. DQL mode only.) A value from 1 through 99999 to specify a threshold count of I/O required to process the query. During optimization, if the estimated number of I/Os required to execute the FIND statement exceeds this number, a screen is presented to the user explaining that the MAX I/O has been exceeded, and asking the user if query execution should continue. If not specified, the default value is the value of the MAX I/O parameter from the Dataquery System Option Table.
(Optional. DQL mode only.) A value from 1 through 99999 to specify the number of times CA Dataquery is to relinquish control to other tasks during a query execution before pausing to allow a user to end processing. (The system default is used if this value is zeros.)
The first two features work together, CA Dataquery allows MXREQ to occur MXTLR times before asking the user if they want to terminate the query.
(Optional) A value from 1 through 16 to specify, in 4096-byte pages, the maximum amount of contiguous storage area for in-core sorting which CA Dataquery requests of CICS at one time. If this amount is not available when needed, CA Dataquery tries to allocate a number of smaller areas for the sort.
(Optional) A value from 1 through 99999 to specify the total number of physical blocks on the DQF (online work table) that this user can own at one time during a query execution. Ensure that the value specified for this user still leaves adequate space for all other users. (The system default is used if this value is zeros.)
(Optional) Specify the 1- to 4-character network printer ID where reports are to print for this user.
(Optional) The 2-character primary language ID of the primary language for this user. AE (American English), the default, is automatically distributed with CA Dataquery. Your site can also have German, French, or any other language of your company's choosing for a full or partial translation.
(Optional) The 2-character secondary language ID for the secondary language of this user. AE (American English), the default, is automatically distributed with CA Dataquery. Your site can also have German, French, or any other language of your company's choosing. (This should be a full translation.)
(Optional) The 1- to 32-character name for the CA Datacom/DB area used for the personal database tables of this user. This can be used only with CA Datacom extensions to SQL. Check with the Database Administrator for this information.
|
Copyright © 2014 CA.
All rights reserved.
|
|