DB2I Defaults Panel 1

DB2I Defaults Panel 1 lets you change many of the system default values that were set at Db2 installation time.

The following figure shows the fields that affect the processing of the other DB2I panels.

Figure 1. DB2I Defaults Panel 1
 DSNEOP01                DB2I DEFAULTS PANEL 1
 COMMAND ===>_
 
 Change defaults as desired:
 
  1  DB2 NAME ............. ===> DSN       (Subsystem identifier)
  2  DB2 CONNECTION RETRIES ===> 0         (How many retries for DB2 connection)
  3  APPLICATION LANGUAGE   ===> IBMCOB    (ASM, C, CPP, IBMCOB, FORTRAN, PLI)
  4  LINES/PAGE OF LISTING  ===> 60        (A number from 5 to 999)
  5  MESSAGE LEVEL ........ ===> I         (Information, Warning, Error, Severe)
  6  SQL STRING DELIMITER   ===> DEFAULT   (DEFAULT, ' or ")
  7  DECIMAL POINT ........ ===> .         (. or ,)
  8  STOP IF RETURN CODE >= ===> 8         (Lowest terminating return code)
  9  NUMBER OF ROWS         ===> 20        (For ISPF Tables)
 10  AS USER                ===>           (User ID to associate with trusted connection)
The following explains the fields on DB2I Defaults Panel 1.
1 Db2 NAME
Lets you specify the Db2 subsystem that processes your DB2I requests. If you specify a different Db2 subsystem, its identifier displays in the SSID (subsystem identifier) field located at the top, right side of your screen. The default is DSN.
2 Db2 CONNECTION RETRIES
Lets you specify the number of additional times to attempt to connect to Db2, if Db2 is not up when the program issues the DSN command. The program preparation process does not use this option.

Use a number from 0 to 120. The default is 0. Connections are attempted at 30-second intervals.

3 APPLICATION LANGUAGE
Lets you specify the default programming language for your application program. You can specify any of the following languages:
ASM
For High Level Assembler/z/OS®
C
For C language
CPP
For C++
IBMCOB
For Enterprise COBOL for z/OS. This option is the default.
FORTRAN
For VS Fortran
PLI
For PL/I

If you specify IBMCOB, Db2 prompts you for more COBOL defaults on panel DSNEOP02. See DB2I Defaults Panel 2.

You cannot specify FORTRAN for IMS or CICS® programs.

4 LINES/PAGE OF LISTING
Lets you specify the number of lines to print on each page of listing or SPUFI output. The default is 60.
5 MESSAGE LEVEL
Lets you specify the lowest level of message to return to you during the BIND phase of the preparation process. Use:
I
For all information, warning, error, and severe error messages
W
For warning, error, and severe error messages
E
For error and severe error messages
S
For severe error messages only
6 SQL STRING DELIMITER
Lets you specify the symbol used to delimit a string in SQL statements in COBOL programs. This option is valid only when the application language is IBMCOB. Use:
DEFAULT
To use the default defined at installation time
'
For an apostrophe
"
For a quotation mark
7 DECIMAL POINT
Lets you specify how your host language source program represents decimal separators and how SPUFI displays decimal separators in its output. Use a comma (,) or a period (.). The default is a period (.).
8 STOP IF RETURN CODE >=
Lets you specify the smallest value of the return code (from precompile, compile, link-edit, or bind) that will prevent later steps from running. Use:
4
To stop on warnings and more severe errors.
8
To stop on errors and more severe errors. The default is 8.
9 NUMBER OF ROWS
Lets you specify the default number of input entry rows to generate on the initial display of ISPF panels. The number of rows with non-blank entries determines the number of rows that appear on later displays.
10 AS USER
Lets you specify a user ID to associate with the trusted connection for the current DB2I session.
Db2 establishes the trusted connection for the user that you specify if the following conditions are true:
  • The primary authorization ID that Db2 obtains after running the connection exit is allowed to use the trusted connection without authentication.
  • The security label, if defined either implicitly or explicitly in the trusted context for the user, is defined in RACF® for the user.

After Db2 establishes the trusted connection, the primary authorization ID, any secondary authorization IDs, any role, and any security label that is associated with the user ID that is specified in the AS USER field are used for the trusted connection. Db2 uses this security label to verify multilevel security for the user.

If the primary authorization ID that is associated with the user ID that is specified in the AS USER field is not allowed to use the trusted connection or requires authentication information, the connection request fails. If Db2 cannot verify the security label, the connection request also fails.

The value that you enter in this field is retained only for the length of the DB2I session. The field is reset to blank when you exit DB2I.

Suppose that the default programming language is PL/I and the default number of lines per page of program listing is 60. Your program is in COBOL, so you want to change field 3, APPLICATION LANGUAGE. You also want to print 80 lines to the page, so you need to change field 4, LINES/PAGE OF LISTING, as well. Figure 1 shows the entries that you make in DB2I Defaults Panel 1 to make these changes. In this case, pressing ENTER takes you to Db2 Defaults Panel 2.