TS-359

Query and Reporting from DB2 Installation and Configuration

This paper describes how to customize Query and Reporting from DB2 after it has been installed.

During installation the following is added:
SAS autocall macros: DB2RC, SASRC, SASXRC
SAS catalog: SASHELP.QASSIST
SAS data set: SASHELP.SASAPPL
SAS library: XXXXXX.QASSIST.PARMS

Below are instructions on how to customize Query and Reporting from DB2 to run on sample DB2 data. We recommend you do this before you start working on your DB2 data.

Note: When the 4th maintenance 6.08 is installed, points 1-2 will be done at tape install time.

1. Specify the location of the Master Profile. Enter on the command line of the Program Editor:

Command ===> COPY SASHELP.QASSIST.PARMS.SOURCE

The contents of this file must be the actual name of the SAS library containing the Master Profile, example:

00001 userid.QASSIST.PARMS

If this is not the case then allocate SASHELP.QASSIST with write access and write the correct name.

2. Create the Master Profile.

Allocate the Master Profile SAS library and secure that it contains the QASSIST catalog. If not, then execute the following:

LIBNAME MASTER 'userid.QASSIST.PARMS' DISP=OLD; PROC CATALOG;

     COPY IN = SASHELP.QASSIST OUT = MASTER.QASSIST
      SELECT PARMSQA.SLIST;
	  RUN;
	  QUIT;
	  

3. New SAS macros for the autocall library.

You must have the following 3 SAS macros in your autocall library: DB2RC, SASRC, SASXRC.

If this is not the case, you can copy these from SASHELP.QAUTOLIB catalog, which only contains these 3 members.

4. Creating DB2 Sample data.

Query and Reporting from DB2 contains its own sample data. These data are used in the documentation.

Enter the following on the command line in the Program Editor:

Command ===> COPY SASHELP.QASSIST.SAMPLTAB.SOURCE

Specify the creator you want to use in line 58.

Execute this SAS program and the DB2 sample data will be created. Grant these DB2 tables to PUBLIC.

5. Create a Query Manager on the DB2 sample data.

The Query Manager contains information from the DB2 system tables.

Enter the following on the command line in the Program Editor:

Command ===> COPY SASHELP.QASSIST.DB2METAU.SOURCE

Specify the creators you want to use for this first demo of the Query and Reporting from DB2. Change the code in line 27.

Example: %let creators= ('DSN8230',USER);

Specify the name of the SAS library where you want to store the Query Manager in line 31-33.

Example: %let saslib=MANAGER;

LIBNAME MANAGER 'userid.qassist.manager';

Execute the program interactively or in batch.

6. Customize the Master Profile.

Start SAS/ASSIST. Go to <DATA MGMT> , <Query>, <Query and Reporting from DB2> , <SETUP>.

If you have write access to the SAS library containing the Master Profile you will be able to select <Master Profile> in the upper left corner of the screen.

Select <Master Profile>. You can now specify default values for your installation. These values will be used by new users as they start the Query and Reporting from DB2 tool.

If you activate the Required check box users will not be allowed to change the values you define.

Some of the parms are very DB2 specific and some are specific to the behavior of the Query and Reporting from DB2 tool. Read the documentation or use the <Help> button for more info.

Be sure to specify the value for the "Query Manager Library" you have created under point 5.

7. If you want the main menu in the Query and Reporting from DB2 as the first window, when you start SAS/ASSIST, you must create a logon exit.

Start SAS/ASSIST, <SETUP> , <Logon/Logoff exits> , <Logon exit>

Enter the application name: SASHELP.SASAPPL.SASDBQR.AF.

Use ? to get selection lists.

Activate: "Do not enter SAS/ASSIST".

<OK>.

The next time you start SAS/ASSIST you will go into the Query and Reporting from DB2 directly. Use ASSIST LOGON=NO suppress this.