User profile display and edit window

The User Profile Display and Edit window (see the following figure) displays when you select USER from the Profile Display Menu. It contains current profile values. The fast-path command for this window is MENU.PRO.US.

User Profile Display and Edit Window. This window is maximized.

User Profile Display and Edit Window. This window is scrolled down to show lines 21 through 22.

Each variable described below is identified as part of your subsystem user profile or your session user profile. Subsystem user profile values are specific to a subsystem and may change if you use the DSN command. Values associated with your session user profile remain the same from subsystem to subsystem and from session to session.

Important

For each File-AID for Db2 Object Administration session, variables are refreshed with the values specified in Object-Administration-Utility-Default-Values (refer to Option 5, Object Administration Utility Default Values of the Getting-started-with-BMC-AMI-DevX-File-AID-for-Db2-options manual).

DEFAULT DATABASE

Specifies the database used for the creation of the File-AID for Db2 Object Administration support tables. This value is part of your subsystem user profile.

DEFAULT TABLESPACE

Specifies the default tablespace, which is used for the same reason as the default database. This value is part of your subsystem user profile.

DEFAULT STOGROUP

Specifies the default storage group, which is used for the same reason as the default database. This value is part of your subsystem user profile.

DEFAULT TS BPOOL

Specifies the default bufferpool to be used when creating tablespaces.

DEFAULT IX BPOOL

Specifies the default bufferpool to be used when creating indexes.

DEFAULT BATCH OPTION

Specifies whether or not to generate JCL for File-AID for Db2 Object Administration processes for running in a batch mode. The batch option may be overridden in the Edit run options for each process. Valid Values are YES (set default to generate batch JCL and NO (set default to run online).

CALCULATION DEVICE

Specifies the default calculation device for use with any File-AID for Db2 Object Administration procedure that automatically calculates space requirements. This value is part of your subsystem user profile.

CAPTURE LIMIT

Specifies the number of rows that will be saved to the specified data set when the CAPTURE command is invoked.

MENU - ACTION OR OBJECT

Specifies the type of Main Menu. The Object Main Menu is the default. The alternate Action Main Menu lists actions instead of objects, but is not documented. The submenus from the Action Main Menu are the same as those from the Object Main Menu. This value is part of your session user profile.

PACKAGE VERSION COUNT

Specifies the version count for the VERSION selection in the Package Display Facility. Packages that contain the specified number of versions or more are displayed. This value is part of your session user profile.

DEFAULT UNCOMMITTED READ

Specifies the default value for the uncommitted read option for impact reports and modification. YES indicates the system will use Db2’s Uncommitted Read SQL Select Option. NO indicates it will not be used.

TEMPLATE Option

Specifies the default value for Template when generating Utility JCL. YES indicates to generate Templates in Utility JCL. NO indicates to generate standard DD statements for Utility Files.

DEFAULT DCLGEN PDS

Specifies the default PDS for saving DCLGEN statements. This value is part of your subsystem user profile.

DEFAULT DCLGEN LANGUAGE

Specifies the default programming language for which DCLGEN statements are generated. Valid values are PLI, C, COB2, COBOL, and ASM (Assembler). This value is part of your subsystem user profile.

DCLGEN CREATOR OPTION

Specifies the use of a creator qualifier when generating table and view names for DCLGEN statements. Valid values are YES (qualify object names) and NO (do not qualify object names). This value is part of your subsystem user profile.

DCLGEN COLUMN PREFIX

Specifies the prefix for column names generated during the DCLGEN process. This value is part of your subsystem user profile.

DCL SQL ESCAPE CHARACTER (COBOL)

Specifies the delimiter to be used for table and column names produced by DCLGEN for COBOL programs. Valid values are: “ (quote), ‘ (apostrophe), and NONE (do not generate escape characters).

TRIGGER TERMINATOR

Specifies the character to be used to terminate Create Trigger statements. Triggers may contain multiple statements, each terminated with a semi-colon (;). Thus, the overall statement must be terminated with a different character such as an exclamation point (!).

ID DATE DEFAULT

The Default Identifier Date Option indicates whether to use a Julian (YYDDD) or Gregorian (YMMDD) date format when generating default identifiers for Modify, Clone, Impact Report, Revoke Impact, Compare, etc. The ID will be generated as M (modify), followed by the date in the specified format, followed by an incrementing 2 characters which will start with AA, AB, ... Z9, 1A, ... 99. For example, an impact report id might be I40630AA (I for Impact, 40630 for Gregorian June 30, 2004, and AA the first ID generated for today.
Valid Values are: JULIAN or GREGORIAN.