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
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.RegardsVaasu
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.
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?RegardsVaasu
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 SQL3. 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 YESThese 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" .