Checklist for TCP/IP Listener Implementation using IDMS Server JDBC Type 4 Driver

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

Checklist for TCP/IP Listener Implementation using IDMSServer JDBC Type 4 Driver.

• Client has installed IDMS Server on the PC and TCP/IP Listener on the IDMS CV. What are the steps to verify each of the components required and if they are communicating successfully?

Resolution

The implementation verification steps are as follows:

1. Verify the TCP/IP Listener is installed and in service in the IDMS mainframe Central Version (CV).
2. Display the PORT number in TSO to verify that it is allocated to the IDMS CV and in "Listen" status.
3. Test IP Address or Hostname from PC to MVS system using the DOS Command Prompt.
4. Verify that IDMSServer is installed on the IDMS mainframe CV.
5. Test CA IDMS/DB connectivity via IDMSServer IDMSJCF Test.

1. Test network connectivity
   
   On the IDMS mainframe, verify that the TCPIP line and the "listener" LTE/PTE both have a status of "InSrv".  
   
   Note the Port number which is displayed next to the listener LTE/PTE
   
   
2. Display the PORT number in TSO to verify that it is allocated to the IDMS CV and in "Listen" status.
   
   From the MVS TSO READY prompt, enter the command:

netstat <port number>

Test IP Address or Hostname from PC to MVS system using the Command Prompt DOS.

On the PC, at the Command Prompt DOS screen, enter the command

ping <ip address> (or hostname)

Example: C:\Documents and Settings\>ping <hostname>

    Reply from  ##.###.##.##.###: bytes=32 time=46ms TTL=60     Ping statistics for  ##.###.##.##.###:        Packets: Sent = 4, Received = 3, Lost =1 (25% loss),    Approximate round trip times in mill-seconds:        Minimum = 45 ms, Maximium = 47 ms, Average = 46ms

1. Verify IDMSServer is installed in the IDMS central version.
   
   Do the following to verify that program RHDCD0LV contains the RHDCD0LB module, verifying that IDMSServer is installed on this IDMS mainframe CV.
   
   From the Enter Next Task Code prompt, enter the command:     LOOK PROGRAM=RHDCD0LV     
   

   Module    Offset   Date                                                                                                             RHDCD0LV   +0      001127  1350                                      
   RHDCD0LA   +25A0   990802        
   RHDCCDDS   +2828   001127  1349                                      
   RHDCD0LB   +5A48   001106  1701

Test CA IDMS/DB connectivity via IDMSServer IDMSJCF Demo Apps Test (Java Command Facility).

Start/Programs/CA/IDMSServer/JCF Demo App/
Press the Connect button then enter the following:
<your-cv-userid>  <your-cv-password>

Once it's connected, verify you can access IDMS SQL tables from the IDMS mainframe databases.
In the JCF Demo App panel, enter the command:

SELECT * FROM SYSTEM.TABLE

Press the Execute button run the command and receive the output.