Installing Training Files

This section provides information on how to create sample data for all or select File-AID products that you can use for training or demonstration purposes. BMC provides sample JCL to create a complete master set of MVS (XVJTRNM) training files that can be used for all File-AID products. Five sample CLISTs (UDACOPY, XFACOPY, XFDCOPY, XIXCOPY, and XFRCOPY) need to be tailored to your site requirements to copy File-AID master training files to individual users for training. These samples are located in the sample library, hlq.SXVJSAMP. BMC also provides a dialog to create Db2 sample objects for File-AID for Db2 and File-AID/RDX. It’s started by executing REXX member XVJTRNDB in the hlq.SXVJSAMP.

Task 11.1 Create MVS Master Training Files (XVJTRNM)

This sample JCL creates a copy of all MVS master training files for the File-AID products.

Update sample member XVJTRNM in hlq.SXVJSAMP to your site’s requirements by following the instructions in the member.
Submit the job.

Task 11.2 Create Db2 Training Files (XVJTRNDB)

This sample JCL creates a copy of all Db2 training files, including database, tablespaces, tables, etc., for the File-AID products that use Db2.

Create Db2 Sample Objects using the Sample Db2 Data Create dialog:
1. Execute REXX member XVJTRNDB in hlq.SXVJSAMP to display the Sample Db2 Data Create screen (see the following figure).Sample Db2 Data Create Screen
2. Update the fields to your site’s requirements. Press PF1 (HELP) for descriptions of the field entries.
3. Press Enter to generate JCL to build Db2 sample objects for File-AID for Db2 and File-AID/RDX.
Submit the job.
Warning
Important
CREATEDBA privilege is needed to execute this job.

Task 11.3 Create CLISTs for Individual Products

Once you have created the master training files (Task 11.1 and Task 11.2), customize the sample CLISTs to create the CLISTs that users can use to create their own individual training files for each product.

Copy sample CLIST members (UDACOPY, XFACOPY, XFDCOPY, XIXCOPY, and XFRCOPY) from hlq.SXVJSAMP into your customized CLIST library hlq.CXVJCLIB.

Modify these CLIST to your site’s requirements by following the instructions in the member. These should point to the high level qualifier for the master training files to make them available for execution within the product. Refer to the following table 28 for more information on the training data CLISTs.

CLISTS for File-AID Training Data

CLIST Name	Description
UDACOPY	This is a sample CLIST to copy File-AID/Data Solutions Master training files to individual users for training. See Creating Your Training Files in the Using File-AID/Data solutions for instructions on creating your own set of DASAMP sample files by running the UDACOPY CLIST. See Appendix 31, of the Getting started with File-AID/Data Solutions for a description of these files.
XFACOPY	This is a sample CLIST to copy File-AID/MVS Master training files to individual users for training. See Creating your training files for instructions on creating your own set of FASAMP sample files by running the XFACOPY CLIST. See Appendix A, of the Using File-AID/MVS for a description of these files.
XFDCOPY	This is a sample CLIST to create the following 2 files: Relationship file (empty) userid.FDSAMP.RELATION SHOW SQL data set userid.SHOW.SQL SQL sample programs are copied into the SHOW SQL data set. Refer to File-AID for DB2 Sample Programs.
XIXCOPY	This is a sample CLIST to copy File-AID for IMS Master training files to individual users FISAMP sample files for training.
XFRCOPY	This is a sample CLIST to copy File-AID/RDX Master training files to individual users for training. See Creating the Sample Files in Using BMC AMI DevX File-AID/RDX for instructions on creating your own set of FRSAMP sample files by running the XFRCOPY CLIST. See Sample Training Tables and Files in Using BMC AMI DevX File-AID/RDX for a description of these files.

File-AID for Db2 Sample Tables

The following table lists the tables that are created and loaded by Task 11.2 Create Db2 Training Files (XVJTRNDB).

File-AID Tables Used During Installation of Sample Data

Table Name	Primary Key	Foreign Key	Relationships
ORDER_nn	ORDER_NUMBER		Parent of ORDER_LINE_nn
CUSTOMER_nn	CUSTOMER_NUMBER
ORDER_LINE_nn	ORD_NUM, and ORDER_LINE_NUMBER	ORD_NUM, PART_NUM	Dependent of ORDER_nn and PART_nn
PART_nn	PART_NUMBER		Parent of ORDER_LINE__nn
WORK_STATUS_nn	ORDER_NUM, ORDER_LINE_NUM, and PROCESS_IDENTIFIER
TSQLSAMPLE

File-AID for Db2 Sample Programs

File-AID for Db2includes two sample programs. They are located in the File-AID hlq.SXVJSAMP library. The programs read in a record and use the value to set up a DECLARE CURSOR, OPEN CURSOR, and FETCH CURSOR for the primary table. The programs include a series of SELECT statements to aid in demonstrating Browse/Edit Host Variable Resolution. For more information, see Getting started with BMC AMI DevX File-AID for Db2 options. The programs are:

SQLDEMO: This program references the following table:
- FADB2.ORDER_1
  The installation tasks in this section must be performed in order to access the table.
  The installation procedure allows modification of the high level qualifier and creates up to twenty copies of each table (table name suffix: _nn). If the high level qualifier is modified during the installation, this program must reflect the change. Additionally, each user must modify his/her copy of the program to reference the proper table name. For example, change the table name to:
- FADB2.ORDER_02

SQLSAMP: This program references table VSQLSAMP. Task 11.2 creates table TSQLSAMPLE as well as alias VSQLSAMP for TSQLSAMPLE. The installation procedures described in this section do not affect this program or its table.

File-AID/RDX Sample Tables

The following table lists the File-AID/RDX sample tables that are created and loaded by Task 11.2 Create Db2 Training Files (XVJTRNDB).

File-AID/RDX Tables Used During Installation of Sample Data

Table Name	Primary Key	Foreign Key	Relationships
ORDER_TABLE	ORDER_NUMBER		Parent of ORDER_LINE_TABLE
CUSTOMER_TABLE	CUSTOMER_NUMBER
ORDER_LINE_TABLE	ORD_NUM, and ORDER_LINE_NUMBER	ORD_NUM, PART_NUM	Dependent of ORDER_TABLE and PART_TABLE
PART_TABLE	PART_NUMBER		Parent of ORDER_LINE_TABLE
WORK_STATUS_TABLE	ORDER_NUM, ORDER_LINE_NUM, and PROCESS_IDENTIFIER