DSNTIPB: Update selection menu panel

During the update process, you can use the DSNTIPB panel to access all the installation panels and view the values that you specified during installation or migration.

Parameters that you can update are highlighted. Panels containing fields that cannot be updated are marked with an asterisk.

Figure 1. Individual update menu panel: DSNTIPB
     ----------------------------------------------------------------------------------
     | DSNTIPB          UPDATE DB2 - SELECTION MENU                                   |
     | ===>                                                                           |
     |  Select one of the following:                                                  |
     | ----------------- Use the UP/DOWN keys to access all options ------------------|
     |                                                                    More:     + |
     |  1 CATALOG AND DIRECTORY                27 APPLICATION PROGRAMMING DEFAULTS 1  |
     |  2 DATA PARAMETERS PANEL                28 APPLICATION PROGRAMMING DEFAULTS 2  |
     |  3 BSDS AND ACTIVE LOGS                 29 PERFORMANCE & OPTIMIZATION PANEL 1  |
     |  4 DEFINE GROUP OR MEMBER               30 PERFORMANCE & OPTIMIZATION PANEL 2  |
     |  5 ACTIVATE A FUNCTION LEVEL            31 QUERY ACCELERATOR PREFERENCES       |
     |  6 INSTALLATION PREFERENCES *           32 IRLM PANEL 1                        |
     |  7 INSTALLATION PREFERENCES PANEL 2 *   33 IRLM PANEL 2                        |
     |  8 SYSTEM RESOURCE DATA SET NAMES       34 DB2 UTILITIES PARAMETERS            | 
     |  9 DB2 DATA SET NAMES                   35 DB2 UTILITIES PARAMETERS PANEL 2    |
     | 10 HOST LANGUAGE DATA SET NAMES 1 *     36 DB2 UTILITIES PARAMETERS PANEL 3    |
     | 11 HOST LANGUAGE DATA SET NAMES 2 *     37 DB2 UTILITIES PARAMETERS PANEL 4    |
     | 12 OTHER DATA SET NAMES *               38 DB2 UTILITIES PARAMETERS PANEL 5    |
     | 13 SIZES                                39 PROTECTION                          |
     | 14 SQL OBJECT DEFAULTS PANEL 1          40 PROTECTION PANEL 2                  |
     | 15 SQL OBJECT DEFAULTS PANEL 2          41 MVS PARMLIB UPDATES                 |
     | 16 SQL OBJECT DEFAULTS PANEL 3          42 ACTIVE LOG DATA SET PARAMETERS      |
     | 17 WORK FILE DATABASE                   43 ACTIVE LOG CHECKPOINT PARAMETERS    |
     | 19 WORK FILE DATABASE PANEL 2           44 ARCHIVE LOG DATA SET PARAMETERS     |
     | 19 THREAD MANAGEMENT PANEL 1            45 DATABASES TO START AUTOMATICALLY    |
     | 20 THREAD MANAGEMENT PANEL 2            46 DISTRIBUTED DATA FACILITY           |
     | 21 BUFFER POOL SIZES PANEL 1            47 DISTRIBUTED DATA FACILITY PANEL 2   |
     | 22 BUFFER POOL SIZES PANEL 2            48 ROUTINE PARAMETERS                  |
     | 23 TRACING AND CHECKPOINT PARAMETERS    49 DB2 JAVA PROPERTIES                 |
     | 24 OPERATOR FUNCTIONS                   50 PARAMETERS FOR DB2-SUPPLIED ROUTINES|
     | 25 DEFAULT STARTUP MODULES              51 DATA DEFINITION CONTROL SUPPORT     |
     | 26 RESOURCE LIMIT FACILITY              52 JOB EDITING                         |
     | -------------------------------------------------------------------------------|
     | * None of the fields on these panels can be updated.                           |
     | PRESS:  ENTER to continue   UP/DOWN to scroll   RETURN to EXIT                 |
     |---------------------------------------------------------------------------------

Panels to update field

From the DSNTIPB panel, you can select a family of parameters to display and update. Some parameters cannot be updated.

On the command line, enter a number to select the family of parameters that you want to update. These numbers correspond to the installation panels in the following table.

Table 1. Panel names and identifiers, by DSNTIPB panel to update field option values
Option Value Panel Name and Identifier
1 DSNTIPA2: Db2 catalog and directory panel
2 DSNTIPA3: Data parameters panel
3 DSNTIPA4: BSDS and active log panel
4 DSNTIPK: Define group or member panel
5 DSNTIP00: Activate a function level panel
6 DSNTIPG: Installation preferences panel
7 DSNTIPG1: Installation preferences panel 2
8 DSNTIPH: System resource data set names panel
9 DSNTIPT: Db2 data set names panel
10 DSNTIPU: Host language data set names panel 1
11 DSNTIPU1: Host language data set names panel 2
12 DSNTIPW: Other data set names panel
13 DSNTIPD: Sizes panel 1
14 DSNTIP7: SQL OBJECT DEFAULTS PANEL 1
15 DSNTIP71: SQL OBJECT DEFAULTS PANEL 2
16 DSNTIP72: SQL OBJECT DEFAULTS PANEL 3
17 DSNTIP9: Work file database panel
18 DSNTIP91: Work file database panel 2
19 DSNTIPE: Thread management panel 1
20 DSNTIPE1: Thread management panel 2
21 DSNTIP1: Buffer pool sizes panel 1
22 DSNTIP2: Buffer pool sizes panel 2
23 DSNTIPN: Tracing parameters panel
24 DSNTIPO: Operator functions panel
25 DSNTIPO3: Default startup modules panel
26 DSNTIPO4: Resource Limit Facility panel
27 DSNTIPF: Application programming defaults panel 1
28 DSNTIP4: Application programming defaults panel 2
29 DSNTIP8: Performance and optimization panel
30 DSNTIP81: Performance and optimization panel 2
31 DSNTIP82: Query accelerator preferences panel
32 DSNTIPI: IRLM panel 1
33 DSNTIPJ: IRLM panel 2
34 DSNTIP6: Db2 utilities parameters panel 1
35 DSNTIP61: Db2 utilities parameters panel 2
36 DSNTIP62: Db2 utilities parameters panel 3
37 DSNTIP63: Db2 utilities parameters panel 4
38 DSNTIP64: Db2 utilities parameters panel 5
39 DSNTIPP: Protection panel
40 DSNTIPP1: Protection panel 2
41 DSNTIPM: MVS PARMLIB updates panel
42 DSNTIPL: Active log data set parameters
43 DSNTIPL1: Checkpoint parameters
44 DSNTIPA: Archive log data set parameters panel
45 DSNTIPS: Databases and spaces to start automatically panel
46 DSNTIPR: Distributed data facility panel 1
47 DSNTIP5: Distributed data facility panel 2
48 DSNTIPX: Routine parameters panel
49 DSNTIPX1: Db2 Java properties panel
50 DSNTIPR1: Parameters for Db2-supplied routines panel
51 DSNTIPZ: Data definition control support panel
52 DSNTIPY: Job editing panel

When the panel that you select is displayed, enter the new parameters. Press the Enter key to return to the update selection menu panel. Make another panel selection, or press Enter again to process. Press End to leave the update selection menu panel and return to the main panel (DNSTIPA1).