Changing defaults
You can change various parameters that affect the execution of Db2 Admin Tool by using the Admin Defaults (ADB2P2) panel.
Procedure
To change defaults in Db2 Admin Tool:
-
On the DB2 Admin Defaults (ADB2P2)
panel, edit the values as
needed. For information about each field, press PF1 to access the help.
Figure 1. DB2 Admin Defaults (ADB2P2) panel 
ADB2P2 in DB2 Admin Defaults 12:16 Option ===> DB2 System: DD1A More: + Max No of Rows to Fetch . . . . . . 1000 (0-327670, 0=unlimited, def. 1000) Max Chars in an SQL Stmt . . . . . . 32765 (4000-32765, default is 32765) Pgm Action when SQL error: First do a . . . . . . . . . . . . R (C-Commit, R-Rollback) Display error panel . . . . . . . YES (Yes/No) Continue executing SQL . . . . . . NO (Yes/No) Auto Refresh After Update . . . . . YES (Yes/No, default is YES) Display SQL cost estimate . . . . . NO (Yes/No, default is YES) Browse DB2 Command Output . . . . . YES (Yes/No) Max Chars in an ISPF Stmt . . . . . 2000 (500-32765, default is 2000) Max Chars in an Admin Cmd . . . . . 32765 (500-32765, default is 32765) Report Drop Impacts . . . . . . . . YES (Yes/No) Report Revoke Impacts . . . . . . . YES (Yes/No) Reset to Def. at Startup . . . . . . NO (Yes/No) Action when no rows found . . . . . M (M - Message (default), P - Panel) Default local CCSID . . . . . . . . 00000 (Optional, numeric) Verify CCSID . . . . . . . . . . . . YES (Yes/No, default is YES) Capitalize object names . . . . . . YES (Yes/No, default is YES) Capitalize data . . . . . . . . . . YES (Yes/No, default is YES) Use trusted context in batch . . . . NO (Yes/No, default is NO) Gen. utilities for restricted . . . YES (Yes/No, default is YES) Line command field behavior . . . . (*CMD, *, Clear , default is *CMD) Display result of explain . . . . . NO (Yes/No, default is NO) CAT command character . . . . . . . ? (default is question mark) Query type for views . . . . . . . . E (E-Enhanced or S-Singular) Prefix for LOB files . . . . . . . . (Prefix/blank, def. is blank) Limit for LOB data . . . . . . . . . 16 (Number of MB, 1 - 256, def. is 16) Query Java SP package . . . . . . . D (D-Default or E-Enhanced) Get DB2 ZPARM . . . . . . . . . . . YES (Yes/No) Format type for SQL stmts . . . . . E (E-Enhanced or S-Simple) Run Accelerator functions in batch . NO (Yes/No, default is NO) Max Db2 function level accepted . . 503 (Blank or nnn>500)
DB2 Admin Defaults (ADB2P2) panel has the following fields:
- Max No of Rows to Fetch
- Specifies the maximum number of rows to fetch for each SQL SELECT statement. The default value is 1000. If you do not want to limit the number of rows that are fetched, specify 0. In this case, the entire result set is fetched. However, be aware that specifying 0 or a large number can result in long response times for queries that have a large result set.
- Max Chars in an SQL Stmt
- Specifies the maximum length of the buffer for SQL statements. Db2 Admin Tool allocates the specified number of bytes when displaying a new panel. Specifying a high value can slow TSO performance on a storage-constrained system.
- Pgm Action when SQL error
- Specifies the action that Db2 Admin Tool takes when an SQL error
occurs.
- First do a
- Indicates whether Db2 Admin Tool performs a COMMIT or ROLLBACK operation.
- Display error panel
- Indicates whether Db2 Admin Tool displays the SQL error panel with the SQL error message and SQLCA.
- Continue executing SQL
- Indicates whether to continue processing and execute the next SQL statement
- Auto Refresh After Update
- Indicates whether table display panels are to be refreshed after SQL updates.
If YES is specified, Db2 Admin Tool refreshes the panels when they are displayed again. For performance reasons, this refresh is limited to panels where the elapsed time to fetch the rows to be displayed is less than 10 seconds.
If NO is specified, panels are not refreshed. This situation might result in you viewing and acting on old data when you press END.
- Display SQL cost estimate
- Indicates whether Db2 Admin Tool displays an estimated cost for an SQL SELECT statement. This estimate is displayed as an ISPF message. If the estimated cost is larger than the maximum value of an integer, the estimated cost is displayed as "*.***.***.***".
- Browse DB2 Command Output
- Indicates whether Db2 Admin Tool invokes ISPF browse (YES) or lets the output default to TSO line mode (NO).
- Max Chars in an ISPF Stmt
- Specifies the maximum length of the buffer for ISPF statements. Specifying a large number can slow TSO performance on a storage-constrained system.
- Max Chars in an Admin Cmd
- Specifies the maximum length of the buffer for Db2 Admin Tool commands. Specifying a large number can slow TSO performance on a storage-constrained system.
- Report Drop Impacts
- Specifies the default value to be displayed in the Report Drop Impacts field when dropping an object.
- Report Revoke Impacts
- Specifies the default value to be displayed in the Report Revoke Impacts field when revoking authorities.
- Reset to Def. at Startup
- Indicates
whether Db2 Admin Tool restores the
following fields to
their default values at the next startup:
- MAX NO OF ROWS TO FETCH
- MAX CHARS IN AN SQL STATEMENT
- AUTO REFRESH AFTER UPDATE
- MAX CHARS IN AN ISPF STMT
- MAX CHARS IN AN ADMIN CMD
If NO is specified, Db2 Admin Tool attempts to restore the CURRENT SQLID.
- Action when no rows found
- Indicates whether Db2 Admin Tool displays a panel or a message when no rows are found.
- Default local CCSID
- Specifies a default CCSID value to use if no terminal CCSID is available in ISPF variable ZTERMCID. This default CCSID value is used to enable the SQ line command for packages, plans, and triggers.
- Verify CCSID
- Indicates whether Db2 Admin Tool verifies that the CCSID for the TSO terminal matches the CCSID for the plan under which Db2 Admin Tool is running. When you start Db2 Admin Tool or Object Comparison Tool and verification is active, a warning is displayed if the CCSIDs do not match. Different CCSIDs can cause unexpected data conversions for any characters that do not map to the same code point in the two CCSIDs.
- Capitalize object names
- Indicates whether Db2 Admin Tool
translates the lowercase characters to uppercase characters in object names,
qualifiers, and authorization identifiers in the following fields on the System Catalog (ADB21)
panel:
- Name
- Owner
- In DB/Coll
(databases and collections)
- Grantor
- Grantee
If NO is specified, Db2 Admin Tool supports the use of lowercase characters in the qualifier and name of the object when you use Db2 Admin Tool panels to:- Create or drop an index.
- Create or drop an view.
- Drop a table.
Some Db2 object names are required to have only uppercase characters, such as database names, table space names, plan names, and package names (except for trigger package names). Db2 Admin Tool always translates any lowercase characters in these objects names to uppercase characters, even if NO is specified in the Capitalize object names field.
Tip:Use the CAPS primary command to
temporarily override the Capitalize object names setting on
the catalog navigation panels. - Capitalize data
- Indicates whether Db2 Admin Tool
translates lowercase characters to uppercase characters for data that you enter. For
example, if NO is specified, comment fields on Db2 Admin Tool panels remain in the case
in which they were entered.
This field does not apply to objects that are managed by Db2 Admin Tool.
- Use trusted context in batch
- Indicates whether the ASUSER parameter that is specified when Db2 Admin Tool starts should also be used in batch. The job name in the jobs that are submitted must match the job name in the trusted context.
- Gen. utilities for restricted
- Indicates whether Db2 Admin Tool should prompt for additional utilities when Db2 places an object in an restrictive state. (Db2 returns SQLCODE +610 to indicate that an object was placed in a restrictive state.)
- Line command field behavior
- Specifies
what to display in the line command field after a line command is processed.
- *CMD
- Specifies that an asterisk is to be displayed in the first position of the line command.
- *
- Specifies that only an asterisk is to be displayed in the line command field. (The line command is cleared.)
- CLEAR
- Specifies that the line command is to be cleared and nothing is displayed in the line command field.
- Display result of explain
- Indicates whether Db2 Admin Tool displays the EXPLAIN information if CURRENT EXPLAIN MODE is YES or EXPLAIN. (When CURRENT EXPLAIN MODE is EXPLAIN, Db2 does not return any data, only the EXPLAIN information.)
- CAT command character
- Specifies a character that can be used as a shortcut for the CAT command. The
character cannot be alphanumeric, the current value of the ISPF command delimiter,
or any of the following characters:
- + (plus)
- - (minus)
- % (percentage)
- & (ampersand)
- = (equal)
- < (less than)
- > (greater than)
- $ (dollar sign)
- # (pound sign)
- @ (at symbol)
- { (left bracket)
- ¦ (pipe)
- } (right bracket)
- _ (underscore)
- ' (single quote)
- : (colon)
- " (double quote)
- Query type for views
- Specifies the type of query to use to get information for views.
- S
- Singular query. The output includes only the contents of SYSTABLES.
- E
- Enhanced query. The output includes more information that is presented in a view-centric display. If you select E, you can use COLUMN search on columns in SYSVIEWS.
- Prefix for LOB files
- Specifies the high level qualifier(s) for LOB files. The default is blank. If the prefix contains a period, the TSO prefix is not appended to the file name.
- Limit for LOB data
- Specifies the maximum amount of LOB data to fetch (in MB) when LOB data is stored in ISPF tables.
- Query Java™ SP package
- Specifies the algorithm to use for locating the packages of a Java stored procedure, when the K line command is issued on
theStored Procedures (ADB21O)
panel.
- D
- Packages are located by using the COLLID value and EXTERNAL NAME value of the Java stored procedure, which are stored in Db2 catalog tables. D is the default.
- E
- Packages are located by using the default algorithm with the following
additions:
- If no packages are found, the Db2 Admin Tool attempts to locate packages by using the COLLID value and CLASS value of the stored procedure.
- If CLASS is embedded in the REMARKS column of a package and one of the
following conditions are true, Db2 Admin Tool associates the
package with the stored procedure:
- The COLLID value of the package is equal to the COLLID value of the stored procedure.
- The COLLID value of the package is NULLID if the COLLID value of the stored procedure is blank.
- Get DB2® ZPARM
- Indicates whether to call ADMIN_INFO_SYSPARM during a Db2 Admin Tool process to get Db2 subsystem parameters. The
default value is YES.
ADMIN_INFO_SYSPARM requires Db2 monitor privileges. Db2 Admin Tool does not call ADMIN_INFO_SYSPARM during the bind or rebind process.
- Format type for SQL stmts
- Specifies the format for displaying SQL statements when displaying package
details. (You display package details by using the DET line command on the Packages (ADB21K) panel.)
- S
- Displays SQL statements in simple format, with 72 bytes of text per line and host variable information on additional lines.
- E
- Displays SQL statements with complex nested subqueries in enhanced format, where the queries are formatted for readability. Enhanced format applies to only DECLARE CURSOR and SELECT statements. All other statements are displayed in simple format.
- Run Accelerator functions in batch
- Specifies whether eligible accelerator functions are run in batch (YES) or in TSO (NO).
- Max Db2 function level accepted
- The
maximum function level on which you want to allow Db2 Admin Tool to run, even if that
function level is not tolerated or supported.