Creating the CONNX Library in an Adabas-Managed Space

The Adabas SQL Gateway provides an automated installation client application that transfers the CONNX server components to the target VSE host via TCP/IP FTP. To succeed, the automated FTP step requires a target VSE library defined in VSAM-managed space. The target library must be defined manually, either via the following CONNX-supplied template and FTP, or by using the VSE resource-definition panels. To use the CONNX installation template, follow the following steps:

1. The CONNX VSE installation template is copied to the CONNX VSE installation directory on the client machine. The default name is C:\connx32\adabas\templates\ftp\vse\cnxlibv_.dat

2. Make the following substitutions for the template variables defined in the following table:

Variable	Definition
[CNXLIB]	The 1-7 character Adabas SQL Gateway library name defined in the [CNXLIBP] CONNX library cluster; the default is CNXVVRR.
[CNXLIBP]	The 1-44 character fully-qualified VSE cluster name which contains the CONNX Adabas SQL Gateway library; the default is CONNX..LIBRARY.
[CNXCATL]	The 1-7 character VSE standard label which references the physical data set name of the Adabas SQL Gateway user or system catalog ([CNXCATP] ).
[CNXCATP]	The 1-to-44 character physical data set name of the VSE Adabas SQL Gateway user catalog into which the Adabas SQL Gateway-managed library [CNXLIBP] is defined. If left blank, the CONNX library is defined in the default VSE system catalog.
[SAMPLEVOLSER]	The 1-6 character DASD volume serial number on which the VSE Adabas SQL Gateway-managed library is installed: no default.

3. Visually inspect the JCL and move each line continuation character (a rightmost capital X preceded by a comma and one or more blanks ) to column 72; truncate all data beyond column 72.

The control records for the standard label delete and add job steps are column-sensitive.

4. Delete the column rule lines in the template and save the cnxlibv_.dat file as a new file.

5. Via the Windows command prompt, start an ftp session to the target VSE host. Change directory to the VSE POWER Reader queue and submit the cnxlibv0.jcl job:

>ftp
>open 123.456.788.812
>user user
>password password
>cd POWER\RDR\A
>put cnxlibv0.jcl

6. This job should execute in less than a minute. Within the same ftp session, retrieve the output JCL from the POWER List Queue:

>cd "..\..\LST\A"
>dir

7. Retrieve the job output by issuing the following command:

>get CNXLIB.00037.00

For a first-time run, the return codes from the first step // EXEC LIBR,PARM='MSHP' is 8, which is expected.

For a first-time run, the return code from the IDCAMS statement is 8, which is expected. All subsequent return codes should be 0 or 4.

8. The VSE volume and Adabas SQL Gateway user catalog physical data set and data label names are substituted into template variables.

9. Make the CONNX for Adabas SQL Gateway - VSE library available for FTP access.

10. Depending on the TCP/IP security rules of the target VSE system, the newly allocated CONNX library may not be immediately available for ftp read/write access. The Adabas SQL Gateway library can be manually defined to the VSE TCP/IP partition via VSE console commands as follows:

msg f7
AR 0015 1I40I READY
F7-0100 IPN300I Enter TCP/IP Command
102 def file,pub=CNXVVRR,dlbl=CNXVVRR,type=lib,READONLY=NO
F7 0098 IPN264I File defined, Dataset: CNXVVR

The CONNX for VSE-Adabas SQL Gateway library can be permanently defined to the TCP/IP partition via the batch JCL provided in member IPINIT00 of the TCP/IP for VSE installation library. The control record syntax is identical to the console command:

DEFINE FILE,PUBLIC='CNXVVRR',DLBL=CNXV8R8,TYPE=LIBRARY,READONLY=NO

To verify that the new CNXVVRR library is defined and available for ftp, start a Command Prompt window, and then an ftp session to the target host. Once logged on, you can navigate to the CNXVVRR directory and list the subdirectories.