IDMS

Hi All,

In my project we thought of using IDMS in JAVA.

So we need to connect IDMS using JDBC, To connect via JDBC we need the idmsjdbc.Jar file, Server name, Port number and Dictionary name.

Can any one tell me how to find the Server Name and Port Number of the machine where IDMS is installed?

Is there any steps to Configure JDBC to connect with IDMS?

Regards,
Vaasudevan Balusamy (India- Chennai)

Prior technote might be of some help:

Tech Tip: CA IDMS steps to establish a TCP/IP connection from a PC  

Server name is in System statement in Sysgen.  Port is in PTE definition.

You can determine the IP address by issuing a DCMT D TCPIP ALL command from within your IDMS CV.  

DCMT D TCPIP ALL:    

Hostname IP address                  Job name           Active    IPv6
======== =============== =========== ====== ====
USILCA31    ***.***.***.***      TCPIP31 (D)      Y             Y

-------------------------------

The port number can be determined by coding DCMT D LINE TCPIP (where TCPIP is the name of your TCP/IP line).   Look for a 'LIST' type PTE (typically named TCPJSRV) who's Task code invokes RHDCNP3J:

DCMT D LINE TCPIP:

LTerm-ID PTerm-ID Type/M Status Port Target-host
TCPJSRV TCPJSRV     LIST InSrv 03760

-----------------------------------

DCMT D PTE TCPJSRV:

D PTE TCPJSRV
Logical Term ID TCPJSRV
Physical Term ID TCPJSRV
Physical Line ID TCPIP
Physical Term Type TCP/IP List
Physical Term Model
Physical Term Status InSrv
Logical Term Status InSrv
Task code RHDCNP3J
Task mode SYSTEM
Port number 3760
Backlog 100
Maximum connections OFF
Active connections 0
Connections rejected 0
IP specification *none (*DEFAULT)
PARM string TASK=IDMSJSRV

Hi David,

Thanks for the quick and useful reply.

I have tried the commands which you mentioned But there are some error message. So we have send those details to our system DBA.
Regards
Vaasu

First you need to make sure the IDMS SQL Option is installed at your site, and the IDMS System Programmer should be able to answer that and should also be able to provide you with the necessary information, such as server name, port number, etc. as well as the JDBC related files.

Hi Tommy,

Thanks for the Suggestion.

How we can find whether IDMS SQL is installed or not?
I am able to query the DB using SQL query from JCL - If this is possible then we can conclude that IDMS SQL is installed?
Regards
Vaasu

Hi, Vaasu,

Depending on what release of IDMS you are running, your dynamic SQL statement from IDMSBCF might work even if the SQL Option is not intentionally installed, due to the Web-connect feature added at r18.5.
(See https://docops.ca.com/ca-idms/19/en/administrating/administrating-ca-idms-system-operations/sql-web-connect-considerations )

To check if the SQL option was installed:

1. Look in your *.CAISAG.CONFIG(VARBLIST) installation member for this line:
GTJ000OP = YES CA IDMS SQL
(the "GTJ000OP" may be different for different releases).

2. An RHDCPINT entry will have been generated in member *.CUSTOM.SRCLIB(RHDCPINT). Look for this line:
#DEFPINT SQL CA IDMS SQL

3. Within your IDMS system, from the ENTER NEXT TASK CODE: prompt, type the command DCPROFIL, then scroll through to the end where you will find a screen with the heading "* Product Intent Status *".
Look for this line:
CA IDMS SQL YES

These things will tell you if the SQL Option was intentionally installed in this environment.

Best regards,
Ian Hill.

Hi Ian Hill,

Your reply is more useful and we have IDMS Version 19 and after checking with your commands we got to know that we have "CA IDMS SQL YES"  .

Thank you

Regards,
Vaasu