INSTALLATION INSTRUCTIONS FOR the SAS 9.3 TS1M0 DBRMs DOWNLOAD ON z/OS SAS 9.3 TS1M0 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: * DBRM93_TS1M0_V8.xmit PDS in XMIT format. It contains the DBRM members needed for the bind if you are accessing DB2 V8 NFM and running SAS 9.3 TS1M0. * DBRM93_TS1M0_V9V10.xmit PDS in XMIT format. It contains the DBRM members needed for the bind if you are accessing DB2 V9 or DB2 V10 NFM and running SAS 9.3 TS1M0. 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 (required) Pre-allocate 2 files on z/OS (e.g. 'sas.dbrm93.ts1m0.v8.xmit' and 'sas.dbrm93.ts1m0.v9v10.xmit ') with the following DCBs. Be sure to check the space requirements on the download page. Organization : PS Record format : FB Record length : 80 Block size : 3120 STEP 2: FTP THE XMIT FILEs TO z/OS (required) FTP the appropriate XMIT files into the newly created files. DBRM93_TS1M0_V8.xmit would be stored in 'sas.dbrm93.ts1m0.v8.xmit', DBRM93_TS1M0_V9V10.xmit would be stored in 'sas.dbrm93.ts1m0.v9v10.xmit'. This can be done in one of 2 ways: Method 1) 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:\zos\dbrm93 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 DBRM93_TS1M0_V8.xmit and the DBRM93_TS1M0_V9V10.xmit files to your z/OS system by doing a BINARY upload into the pre-allocated files created in step 1. Method 2) From z/OS, FTP to ftp.sas.com using userid=anonymous and password=your.email@address Once you are logged on, cd into the following directory: /techsup/download/hotfix/dbrms/mvs Issue the following commands where 'SAS.DBRM93_TS1M0_V8.xmit' and 'SAS.DBRM93_TS1M0_V9V10.xmit' are the filenames you created in step 1. binary get DBRM93_TS1M0_V8.xmit SAS.DBRM93_TS1M0_V8.xmit (rep get DBRM93_TS1M0_V9V10.xmit SAS.DBRM93_TS1M0_V9V10.xmit (rep quit STEP 3: RECEIVE THE XMIT FILEs TO CREATE THE DBRMLIB PDS (required) On z/OS issue a RECEIVE command against the uploaded XMIT files as follows where 'sas.dbrm93.ts1m0.v8.xmit' and 'sas.dbrm93.ts1m0.v9v10.xmit' are the preallocated file in step 1. receive indataset('sas.dbrm93.ts1m0.vx.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.dbrm93.ts1m0.vx.dbrmlib will the name of your newly created PDS containing the DBRM members: DA('sas.dbrm93.ts1m0.vx.dbrmlib') This completes the download of the SAS 9.3 TS1M0 DBRM members on z/OS. NOTE: The following information should be given to the appropriate person responsible for doing the DB2 bind: * The name of the DBRMLIB data sets containing the SAS93 and SAS93X members that were created in the above step. * When performing the DB2 bind, point to that DBRMLIB data set.