DB2 Setup (5.5.0)
Related Tpoics
The DB2 Setup screen (5.5.0) lets you override default Db2 parameters established during installation. If the Code Debug CICS profile data set is used, your overrides are saved for future debugging sessions.
Access this screen by typing the number 0 on the DB2-Easy-Query-Menu-5-5 or as described in Selecting Functions from Menus.
DB2 Setup Screen (5.5.0)
COMMAND ===>
MODULE: CSECT:
STRING DELIMITER ===> ' (' or ")
DECIMAL INDICATOR ===> . (. or ,)
NULL COLUMN DISPLAY CHARACTER ===> @
VARIABLE LENGTH COLUMN END OF STRING CHARACTER ===> |
TRUNCATE TRAILING BLANKS ===> Y
USE LOCAL/GMT WHEN INSERTING NEW COLUMN ===> LOCAL (Local/GMT)
LIST OF TABLES/VIEW LIMITS: CREATOR ===> *
TABLE/VIEW ===> *
TYPE ===> * (Table/View)
DATABASE ===> *
TABLESPACE ===> *
MAXIMUM ROWS TO SELECT ===> 250 (1 - 1000)
LOCK TABLES WHEN UPDATING ===> N (Y/N)
LOCK TABLES GLOBAL OVERRIDE ===> YES
Input Fields
Global Parameters Used to Initialize Defaults
The input fields on the DB2 Setup screen are initialized based on the values of the Code Debug CICS global parameters listed in the following table. For a complete description of Code Debug’s global parameters, see Code Debug CICS Advanced Configuration space.
Code Debug Global Parameters for DB2 Setup Screen
DB2 Setup Screen Field | Global Parameter |
|---|---|
STRING DELIMITER | FILE_UTILITY_DB2_STRING_DELIMITER |
DECIMAL INDICATOR | FILE_UTILITY_DB2_DECIMAL_CHARACTER |
NULL COLUMN DISPLAY CHARACTER | FILE_UTILITY_DB2_NULL_CHARACTER |
VARIABLE LENGTH COLUMN | FILE_UTILITY_DB2_VARCHAR_END_OF_STRING |
TRUNCATE TRAILING BLANKS | FILE_UTILITY_DB2_TRUNC_TRAILING_BLANKS |
USE LOCAL/GMT WHEN | FILE_UTILITY_DB2_TIMESTAMP_LOCALE |
CREATOR | FILE_UTILITY_DB2_CREATOR_LIMIT |
TABLE/VIEW | FILE_UTILITY_DB2_TABLE_LIMIT |
TYPE | FILE_UTILITY_DB2_TYPE_LIMIT |
DATABASE | FILE_UTILITY_DB2_DATABASE_LIMIT |
TABLESPACE | FILE_UTILITY_DB2_TABLESPACE_LIMIT |
MAXIMUM ROWS TO SELECT | FILE_UTILITY_DB2_MAX_ROWS_USER |
LOCK TABLES WHEN UPDATING | FILE_UTILITY_DB2_EXCLUSIVE_LOCK_SYSTEM |
STRING DELIMITER
Select an apostrophe (') or quote (") as a delimiter for entering a string constant. String constants are used on the DB2 Build SQL Easy Query (5.5.2) screen. Apostrophe (') is the default.
DECIMAL INDICATOR
Select a period (.) or comma (,) as a decimal indicator for entering or displaying a numeric value or constant.
NULL COLUMN DISPLAY CHARACTER
Displays a character that you select to display the contents of a NULL column. When a NULL column is displayed, this character shows in the column. Do not select the same character as the string delimiter, decimal indicator, or end-of-string character.
VARIABLE LENGTH COLUMN END OF STRING CHARACTER
Controls the input of data for columns defined as variable length. Variable length columns are used on the DB2 Edit Result Table Row (5.5.5) screen.
The end-of-string character marks the end of data in a variable length column. All data following this character is ignored and only data to the left of the character is retained. To create a variable length column of length 0, place the end-of-string character in position 1 of the input field associated with the column.
TRUNCATE TRAILING BLANKS
Determines if trailing blanks are retained or removed.
- N: Retains trailing blanks as part of the variable length field. Always pads the variable length column to the right with blanks to its maximum defined length.
- Y: Removes all trailing blanks from the input string and only retains the data up to the trailing blanks for the column.
USE LOCAL/GMT WHEN INSERTING NEW COLUMN
Time zone factor for a TIME, DATE, or TIMESTAMP field. Greenwich Mean Time (GMT) values are the same as LOCAL values if your Db2 system has not been generated to support GMT values.
- LOCAL: Uses associated LOCAL value.
- GMT: Uses Greenwich Mean Time value.
LIST OF TABLE/VIEW LIMITS Area
Fields may be used in combination. Fields are processed in top-to-bottom order.
The asterisk (*) is used as a generic matching character; any positions starting at the asterisk and continuing through the end of the string are assumed to match. An asterisk in position 1 selects all entries for that field.
CREATOR
Limits the displayed list to tables created by specified users.
TABLE/VIEW
Limits the displayed list to specified tables and views.
TYPE
Limits the displayed list to the specified type. Valid values are TABLE, VIEW, and asterisk (*).
DATABASE
Limits the displayed list to tables and views residing in the specified Db2 databases.
TABLESPACE
Limits the displayed list to tables and views residing in the specified Db2 tablespaces.
MAXIMUM ROWS TO SELECT
Limits the number of rows displayed from the Db2 result table on the DB2-Browse-Result-Table-5-5-4 screen. This value must be in the range from 1 to the displayed value, which is set during installation. The default value is 1000. If the maximum value is too small, contact your system programmer.
LOCK TABLES WHEN UPDATING
Places or prohibits a lock on a table.
- Y: Locks a table that is selected for update. When you enter the DB2-Browse-Result-Table-5-5-4 screen, Code Debug CICS locks a table so that other users cannot modify it at the same time. This does not mean you gain exclusive control of a table. The system programmer can disable the lock capability.
- N: Prohibits Code Debug CICS from locking a table while you are updating it. Other users can access a table and update it while you are viewing or modifying it. When you use this value, you risk losing changes, but you gain resource savings. N is the default.
Output Field
LOCK TABLES GLOBAL OVERRIDE
Indicates whether you can actually lock Db2 tables for exclusive use. This parameter is set in the Code Debug CICS global parameter FILE_UTILITY_DB2_EXCLUSIVE_LOCK_SYSTEM.
- YES: Users can lock Db2 tables.
- NO: Users cannot lock Db2 tables.