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

Document ID : KB000055033
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

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

  • Client has installed CA 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?

Answer:

The five implementation verification steps are as follows:

  1. Verify the TCP/IP Listener is installed and in service in the CA IDMS mainframe Central Version (CV).
  2. Display the PORT number in TSO to verify that it is allocated to the CA 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 CA IDMS Server is installed on the CA IDMS mainframe CV.
  5. Test CA IDMS/DB connectivity via CA IDMS Server IDMSJCF Test.
  1. Test network connectivity

    On the CA 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
         DCMT DIS LINE TCPIP      DIS LINE TCPIP     *** Physical Line Display ***PLine-ID TCPIPStatus InSrvOpened 2008-01-22-09.43.29.000995Module IPPlug-in RHDCD1IPLTerm-ID PTerm-ID Type/M Status  Port       SocketTCPJSRV1 TCPJSRV1 LIST   InSrv  03716       00000000TCPLTE01 TCPPTE01 BULK   DisconTCPLTE02 TCPPTE02 BULK   DisconTCPLTE03 TCPPTE03 BULK   Discon
    In this example, Port 3716 status is "In Service" and assigned to LTERM TCPJSRV1. The TCP/IP line status is also "In Service".

  2. Display the PORT number in TSO to verify that it is allocated to the CA IDMS CV and in "Listen" status.

    From the MVS TSO READY prompt, enter the command:
    netstat (port number
    Example: netstat (po 3730
     MVS TCP/IP NETSTAT CS V1R8       TCPIP Name: TCPIP31         17:57:04 User Id  Conn     State -------  ----     ----- SUP$TE30 00085C7E Listen   Local Socket:   ::..3730   Foreign Socket: ::..0 READY
  3. 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\nieda02>ping usilca31
        Reply from 141.202.65.31: bytes=32 time=46ms TTL=60     Ping statistics for 141.202.65.31:        Packets: Sent = 4, Received = 3, Lost =1 (25% loss),    Approximate round trip times in mill-seconds:        Minimum = 45 ms, Maximium = 47 ms, Average = 46ms
  4. Verify CA IDMS Server is installed in the IDMS central version.

    Do the following to verify that program RHDCD0LV contains the RHDCD0LB module, verifying that CA IDMS Server is installed on this IDMS mainframe CV.

    From the Enter Next Task Code prompt, enter the command:
        LOOK PROGRAM=RHDCD0LV        RHDCD0LV was #LOADed From --> CDMSLIB                           Entry Point Offset +58     -  Reentrant     -  AMODE 31  -  RMODE 24        24,224 Bytes in Load Module RHDCD0LV loaded at 00122C00                                                                                                    Module    Offset   Date   Time                                                                                                           RHDCD0LV   +0      001127  1350                                      RHDCD0LA   +25A0   990802  1908                                      RHDCCDDS   +2828   001127  1349                                      RHDCD0LB   +5A48   001106  1701
  5. Test CA IDMS/DB connectivity via CA IDMS Server IDMSJCF Demo Apps Test (Java Command Facility).

    Start/Programs/CA/CA IDMS Server/JCF Demo App/
    Press the Connect button then enter the following:
    USERID: Your userid for the CA IDMS mainframe CV              Password: your password for that same CA IDMS mainframe CV   Database:     jdbc:idms://ip address or hostname:port number/dbname     Example: jdbc:idms://usilca31:3730/appldict
    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.