®INSTALLATION INSTRUCTIONS FOR THE SAS 9.4 SASTKTS DBRM DOWNLOAD ON z/OS SAS 9.4 SASTKTS DBRM member for SAS/ACCESS Interface to DB2 BEFORE DOWNLOADING: This download addresses the fact that the Database Request Modules (DBRMs) members that are needed for the DB2 bind are not included as part of the SAS Depot and must be downloaded separately. The following file will be installed: * DBRM94_SASTKTS_V10.xmit Partitioned data set (PDS) in XMIT format. This file contains the DBRM member (SASTKTS) needed for the bind if you are accessing DB2 V10 New Function Mode (NFM) and running SAS 9.4. * DBRM94_SASTKTS_V11.xmit Partitioned data set (PDS) in XMIT format. This file contains the DBRM member (SASTKTS) needed for the bind if you are accessing DB2 V11 New Function Mode (NFM) and running SAS 9.4. * DBRM94_SASTKTS_V12.xmit Partitioned data set (PDS) in XMIT format. This file contains the DBRM member (SASTKTS) needed for the bind if you are accessing DB2 V12 New Function Mode (NFM) and running SAS 9.4. INSTALLATION INSTRUCTIONS: The following instructions describe the steps for extracting the contents of the downloaded files, moving the file(s) to your z/OS system and installing the DBRM member. STEP 1: PRE-ALLOCATE AN XMIT FILE UNDER z/OS (required) Pre-allocate file under z/OS (for example, 'sas.dbrm94.sastkts.v10.xmit', 'sas.dbrm94.sastkts.v11.xmit' or 'sas.dbrm94.sastkts.v12.xmit') with the following data control blocks (DCBs). Organization : PS Record format : FB Record length : 80 Block size : 3120 STEP 2: USE FTP TO TRANSFER THE XMIT FILE TO z/OS (required) Use File Transfer Protocol (FTP) to transfer the appropriate XMIT file into the newly created file. For example, DBRM94_SASTKTS_V10.xmit would be stored in 'sas.dbrm94.sastkts.v10.xmit' DBRM94_SASTKTS_V11.xmit would be stored in 'sas.dbrm94.sastkts.v11.xmit' and DBRM94_SASTKTS_V12.xmit would be stored in 'sas.dbrm94.sastkts.v12.xmit'. - Download the packaged hot fix to your computer. The packaged hot fix is a self extracting executable. Launching the executable will extract the z/OS file to a default location example: C:\Documents and Settings\userid\Local Settings\Temp You are 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, use FTP to transfer the DBRM94_SASTKTS_V10.xmit, DBRM94_SASTKTS_V11.xmit, or the the DBRM94_SASTKTS_V12.xmit file to your z/OS system by doing a BINARY upload into the pre-allocated file created in step 1. STEP 3: RECEIVE THE XMIT FILE TO CREATE THE DBRMLIB PDS (required) Under z/OS, issue a RECEIVE command against the uploaded XMIT file as follows where 'sas.dbrm94.sastkts.vxx.xmit' was the preallocated file in step 1. receive indataset('sas.dbrm94.sastkts.vxx.xmit') After doing this step, you see a prompt 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 in which sas.dbrm94.sastkts.dbrmlib will the name of your newly created PDS containing the SASTKTS DBRM member: DA('sas.dbrm94.sastkts.vxx.dbrmlib') This completes the download of the SAS 9.4 SASTKTS DBRM members under z/OS. NOTE: The following information should be given to the appropriate person responsible for doing the SASTKTS DB2 bind: * The name of the DBRMLIB data set containing the SASTKTS member that was created in step 3 above. * When performing the SASTKTS DB2 bind, point to that DBRMLIB data set. * The same bind options specified for the DB2 bind that was done to create the SAS94 package and SAS94 plan can be used for creating the SASTKTS plan. * The bind will required that you create a package first by doing a BIND PACKAGE followed by a BIND PLAN. Doing a BIND PLAN with a MEMBER option will result in an error similiar to the following: IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00E30065 PSW 077C0001A4442954,ASIDS: HOME = 027C PRIMARY = 006B SECONDARY = 027C