To test CONNX for VSAM query/import functionality against SCT VSAM master files

  1. Browse CONNX.STASK.CNTL and find members CNXVSCT, CNXVSCT1, CNXVSCTJ, and CNXVSJ02.  Members CNXVSCT and CNXVSCT1 define JCL procedures which invoke the CONNX Started Task TCP/IP Listener/Server programs.  Procedure CNXVSCT includes parameters and DDNAMEs for the SCT Master VSAM and CONNX sample VSAM / QSAM / PDS files.  Procedure CNXVSCT1 defines parameters and DDNAMES for the SCT Master VSAM files and omits the DDNAMES for the CONNX sample files. The batch job execution JCL for these procedures is in members CNXVSCTJ and CNXVSJ02, respectively. See Steps 5 and 6 in To verify installation of CONNX Started Task components for the recommended settings for the CONNX sample JCL procedure parameters and environment variables.

  2. Change the CONNX environment variables in member CNXPARMS from DEBUG=0 to DEBUG=1 and from CNXNOPREAUTHORIZE=0 to CNXNOPREAUTHORIZE=1.

  3. Review the following SCT-specific procedure parameters:

ADSHLQ
SCT Alumni Development System
VSAM master file high-level qualifier
Default:SCT.ADSBASE
FRSHLQ
SCT Financial Records System
VSAM master file high-level qualifier
Default: SCT.FRSBASE
HRSHLQ
SCT Human Resources System
VSAM master file high-level qualifier
Default: SCT.HRSBASE
LMSHLQ
SCT Loan Management System
VSAM master file High-Level Qualifier
Default:  SCT.LMSBASE
SISHLQ
SCT Student Information Systems
VSAM master file High-Level Qualifier
Default:  SCT.SISBASE
ZSSHLQ
SCT Z Support Software
VSAM master file High-Level Qualifier
Default:  SCT.ZSSBASE

Note: For testing purposes, it is not necessary to define all SCT subsystem VSAM master files in the CNXVSCT/CNSVSCT1 procedure. You can make a backup copy of CNXVSCT or CNXVSCT1 and remove or comment out the SCT symbolic parameters and DDNAMES which are not installed at your site.

  1. Edit member CNXVSCTJ or CNXVSJ02, change the job card parameters to match your installation standards, and submit the job to a batch execution queue. The CONNX TCP/IP Listener program (CNXRUNB) starts execution and attempts to listen on the TCP/IP port defined by the CNXRUNPORT environment variable. The following CONNX debug tracing messages, which are by default written to the CNXVSCT job output queue, show a successful attempt to listen on port 6710:

Tue Apr  2 17:59:21 2003                     
 Listening to network port 6710.             
Tue Apr  2 17:59:26 2003                     
 Binding to port 6710                        
Tue Apr  2 17:59:26 2003                     
 NET TCP Listening on (0.0.0.0) Port(6710)   
  1. After these messages are written to the job log, the CNXVSCT job waits for a connect request from an ODBC / JDBC / OLE DB / .NET application.  An SDSF display of an idle CNXVSCT batch server job follows:

    st890208.jpg
     

  2. Refer to the table above for the expected tracing messages for a successful bind to the designated TCP/IP port (default: CNXRUNPORT=6500 in member CNXPARMS of CONNX.STASK.CNTL).