INSTALLATION INSTRUCTIONS FOR the SAS 9.2 TS1M0, SAS 9.2 TS2M0 and SAS9.2 TS2M2 DBRMs DOWNLOAD ON z/OS SAS 9.2 TS1M0, SAS 9.2 TS2M0 and SAS9.2 TS2M2 DBRM members for SAS/ACCESS Interface to DB2 BEFORE DOWNLOADING: This download addresses the fact that the DBRMs members that are needed for the DB2 bind are not included as part of the install and must be downloaded separately. The following file(s) will be installed: * DBRM92_V7.xmit PDS in XMIT format. It contains the DBRM members needed for the bind if you are accessing DB2 V7 or DB2 V8 in Compatibility Mode and running SAS 9.2 TS1M0, running SAS 9.2 TS1M0, SAS 9.2 TS2M0 and SAS9.2 TS2M2. * DBRM92_V89.xmit PDS in XMIT format. It contains the DBRM members needed for the bind if you are accessing DB2 V8 in New Function Mode or DB2 V9 and running SAS 9.2 TS1M0, SAS 9.2 TS2M0 and SAS9.2 TS2M2. INSTALLATION INSTRUCTIONS: The following instructions describe the steps for extracting the contents of the downloaded files, moving the files to your z/OS system and installing the appropriate DBRM members. STEP 1: PRE-ALLOCATE THE XMIT FILES ON z/OS Pre-allocate 2 files on z/OS (e.g. 'sas.dbrm92.v7.xmit' and 'sas.dbrm92.v89.xmit') with the following DCBs. Organization : PS Record format : FB Record length : 80 Block size : 3120 STEP 2: FTP THE XMIT FILES TO z/OS FTP the appropriate XMIT files into these newly created files. DBRM92_V7.xmit should be stored in 'sas.dbrm92.v7.xmit' and DBRM92_V89.xmit should be stored in 'sas.dbrm92.v89.xmit'. - Download the packaged hot fix to your PC. The packaged hot fix is a is a self extracting executable. Launching the executable will extract the z/OS files to a default location example: C:\Documents and Settings\userid\Local Settings\Temp You will be prompted during the extraction process to accept or overwrite the default unzip location. The remaining steps in these installation instructions assume that you have unzipped the files to the default location. After extracting the files, FTP the DBRM92_v7.xmit and the DBRM92_v89.xmit files to your z/OS system by doing a BINARY upload into the pre-allocated files created in step 1. STEP 3: RECEIVE THE XMIT FILES TO CREATE THE DBRMLIB PDS On z/OS issue a RECEIVE command against the uploaded XMIT files as follows where 'sas.dbrm92.v7.xmit' and 'sas.dbrm92.v89.xmit' are the preallocated files in step 1. The RECEIVE will need to be done against both of the XMIT files individually where vxx is either v7 or v89 using the above example names: receive indataset('sas.dbrm92.vxx.xmit') After doing this you will be prompted with something similar to the following: INMR901I Dataset DATA.SET.NAME from USERID on ???????? INMR906A Enter restore parameters or 'DELETE' or 'END' + at this prompt you should enter something similar to the following where sas.dbrm92.vxx.dbrmlib will the name of your newly created PDS containing the DBRM members: DA('sas.dbrm92.vxx.dbrmlib') This completes the download of the SAS 9.2 DBRM members on z/OS. The bind can now be done. NOTE: The following information should be given to the appropriate person responsible for doing the DB2 bind: * The names of the 2 DBRMLIB data sets containing the SAS92 and SAS92X members that were created in the above step. One data set will be used during the bind for accessing DB2 V7 and one data set will be used for accessing DB2 V8 or DB2 V9. * When performing the DB2 bind, point to the appropriate DBRM data set, rather than specifying the DBRM data set created during the SAS install.