Question:
Checklist for TCP/IP Listener Implementation using CA IDMS Server JDBC Type 4 Driver.
Answer:
The five implementation verification steps are as follows:
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 DisconIn this example, Port 3716 status is "In Service" and assigned to LTERM TCPJSRV1. The TCP/IP line status is also "In Service".
netstat (port numberExample: 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
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
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
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/appldictOnce 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.TABLEPress the Execute button run the command and receive the output.