Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Accessing and Exiting File-AID for Db2

Accessing and exiting File-AID for Db2 is familiar to any user of ISPF. To start, log onto TSO and follow your local procedures for invoking ISPF-based products. Select the option on the ISPF/PDF Primary Option Menu that corresponds to File-AID for Db2.

The Primary Option Menu (see the following figure) is the first screen displayed when you access File-AID for Db2. It lists the major functions of the product for selection. Press PF7 or PF8 to scroll up and down in this menu. To exit File-AID for Db2, type =X on the command line of any File-AID for Db2 screen and press Enter.

File-AID for Db2 Primary Option Menu

image2023-2-24_18-12-34.png

OPTION

Enter the desired File-AID for Db2 option.

USERID

Current User Identification. This field is display only.

DATE

Current date. This field is display only.

TIME

Current time. This field is display only.

TERMINAL

Terminal type. This field is display only.

CCSID

The terminal Coded Character Set Identification (CCSID). This field is display only. Based upon this CCSID, the Browse and Edit functions convert Unicode data using IBM z/OS Conversion Services, and display the correct character representation data for the Unicode data. See also CCSID Warning Window.

DB2 SSID

Current subsystem identification of your Db2 system. This field can be updated. Entering a new value in this field allows you to immediately connect to a new subsystem. A wildcard character (see Wildcard-Characters) can be used to display the Subsystem ID Selection window (Subsystem ID Selection Window).

CCSID Warning Window

When you access a File-AID for Db2 session, the CCSID defined for the terminal is compared against the default CCSID of the Db2 subsystem. If the terminal CCSID is different than the default Db2 subsystem CCSID, File-AID for Db2 displays a warning (see the following figure) that this difference can cause data conversion errors.

CCSID Warning

image2021-3-9_12-16-41.png

To prevent data conversion errors, you should update the terminal CCSID so that it matches the Db2 subsystem CCSID. The terminal CCSID is an ISPF system variable named ZTERMCID. When using emulator software, ISPF sets dialog variable ZTERMCID based on the emulator’s code page setting. Refer to your emulator documentation for further information.

Show this warning in the future

If you do not want to show this warning window, specify N at “Show this warning in the future” field.

Getting Started with the Object Administration Utility

The first time that you access Object Administration, the Getting Started with the Object Administration Utility window displays (see the following figure). The Getting Started helps with understanding the user interface of Object Administration, which is a window-like interface within ISPF, compared to the rest of File-AID for Db2, which has an ISPF interface. Getting Started explains how to navigate within Object Administration, and how the panels interact. The default is Y.

Getting Started with the Object Administration Utility

image2023-2-24_18-13-42.png

Subsystem ID Selection Window

The Subsystem ID Selection window (see the following figure) displays when you enter a wildcard character in the DB2 SSID field on the Primary Option menu. Select an SSID to connect to a new subsystem.

Subsystem ID Selection Window

image2023-2-24_18-14-25.png

The Subsystem ID Selection window lists all Db2 Subsystems along with their description that have been successfully defined in the File-AID Db2 Environment PARMLIB member (FADEnnnn). When switching to a different Db2 Subsystem, all settings for the new subsystem will take effect.

SET CURRENT DEGREE

Db2 Parallelism can be activated/deactivated during the definition of an individual Db2 Subsystem with Db2 Subsystem parameter ENABLE_PARALLEL_PROC_OF_DYNAMIC_SQL. For more information, see ENABLE_PARALLEL_PROC_OF_DYNAMIC_SQL in the Db2 environment. ENABLE_PARALLEL_PROC_OF_DYNAMIC_SQL=Y produces SET CURRENT DEGREE='ANY' while ENABLE_PARALLEL_PROC_OF_DYNAMIC_SQL=N produces SET CURRENT DEGREE='1'.

DB2 Connection Type

When the File-AID for Db2 bridge is used from Xpediter to debug a stored procedure, File-AID for Db2 uses Resource Recovery Services Attachment Facility (RRSAF). In all other cases, File-AID for Db2 first attempts a Db2 connection through Call Attach Facility (CAF). If this attempt fails, a second attempt is made using RRSAF. If that also fails, an error message is displayed. This process addresses the issue of another application running in the address space that already has established a Db2 connection.

DB2 Call Attach Alert

The DB2 Call Attach Alert window (see the following figure) displays when another application other than File-AID/Related Data XPERT or File-AID for Db2 is accessing Db2 in your current TSO session.

DB2 Call Attach Alert

image2023-2-24_18-14-58.png

Disregard this alert only when the other application shares the same Db2 load libraries with File-AID for Db2. To prevent Db2 call attach problems with unpredictable results, we recommend terminating the other applications before you continue with the File-AID for Db2 session.

Press ENTER to continue with your File-AID for Db2 session.

Invoking File-AID for Db2 from Source Code Edit Session

If you are editing SQL in ISPF, or a Library Management Tool, such as CA Panvalet or CA Librarian, you can directly invoke File-AID for Db2 Browse, Edit, and SQL Source Development and Analysis with the FADB2 primary command. (See FADB2 and ISPF-PDF-SQL-source-development-and-analysis.)

Related topics

Browse-and-Edit-function


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID for Db2 21.01