Previous Topic: Create an SQL Schema to Access Network CA IDMS-DataNext Topic: Connect via ODBC or JDBC


Configure the TCP/IP Line

Both the ODBC and JDBC Drivers require that a TCP/IP line be defined on the target CA IDMS CV. Sample SYSGEN syntax for the installation of a TCP/IP line is provided below, as well as a listener definition for the CA IDMS Server listener. All Program and Task definitions are also provided.

Run the online or batch SYSGEN compiler using the sample syntax provided below to update your CV with the necessary components.

Note: You need to make changes to the sample syntax to account for site-specific implementation. See the comments at the beginning of the sample syntax.

Note: Users who have already defined the TCP/IP line as well as the CA IDMS Server listener should skip this step.

Sample SYSGEN Syntax

*+ SAMPLE SYSGEN INPUT TO DEFINE IDMS JDBC TYPE 4 and ODBC Wire Protocol Listener                      
*+                                                                              
*+ 1) MODIFY XX TO SYSTEM NUMBER ON FIRST LINE AND                              
*+    IN PTERM TCPJSRV PORT DEFINITION.                                         
*+                                                                              
*+ 2) MODIFY THE REPEAT COUNT FOR PTERM TCP0001 (OPTIONAL).                                                                                
*+                                                                              
DIS SYSTEM XX WITH NONE.                                                        
                                                                                
*+ BUILT-IN "DUMMY" PROGRAM IN DLODDB                                           
ADD PROGRAM RHDCNP3J                                                            
    LANGUAGE ASSEMBLER                                                          
    REENTRANT.                                                                  
                                                                                
*+ BUILT-IN LISTENER TASK IN DLODDB                                             
*+ INTERNAL SO IT CANNOT BE INVOKED AT A TERMINAL                               
*+ ATTACHED BEFORE SIGNON                                                       
*+ MUST BE AUTHORIZED FOR ALL USERS                                             
ADD TASK RHDCNP3J                                                               
    INTERNAL                                                                    
    INVOKES RHDCNP3J                                                            
    INACTIVE INTERVAL IS OFF                                                    
    RESOURCE TIMEOUT INTERVAL IS OFF                                            
    EXTERNAL WAIT IS SYSTEM.                                                    
                                                                                
*+ BUILT-IN DEFAULT TASK IN DLODDB                                              
*+ INTERNAL SO IT CANNOT BE INVOKED AT A TERMINAL                               
*+ ATTACHED AFTER SIGNON (OPTIONALLY)                                           
*+ AUTHORIZED FOR SPECIFIC USERS                                                
ADD TASK IDMSJSRV                                                               
    INTERNAL                                                                    
    INVOKES RHDCNP3J                                                            
    INACTIVE INTERVAL IS OFF                                                    
    RESOURCE TIMEOUT INTERVAL IS OFF                                            
    EXTERNAL WAIT IS SYSTEM.                                                    

*+ System-Wide TCP/IP statement options 
ADD TCP/IP                                        
    DEFAULT STATUS IS ON                          
    DEFAULT TCP_NODELAY OPTION IS OFF             
    DEFAULT STACK IS DEFAULT                      
    MAXIMUM NUMBER OF SOCKETS IS DEFAULT          
    MAXIMUM NUMBER OF SOCKETS PER TASK IS DEFAULT 
    PLUGIN MODULE IS RHDCD1IP
    SERVICES FILE IS OFF.                                                                 

*+ LINE DEFINITION FOR MVS SOCKET INTERFACE                                     
ADD LINE TCPIP                                                                  
    TYPE IS SOCKET                                                              
    MODULE RHDCD1IP. 
                                                                                
*+ LISTENER DEFINITION USING CONVENTION                                         
*+ THAT PORT = 3700 + SYSTEM NUMBER                                             
*+ (3709 IS THE DEFAULT PORT USED BY THE JDBC DRIVER                            
*+ AND REGISTERED FOR IDMS WITH IANA)                                           
ADD PTERM TCPJSRV                                                               
    TYPE IS LISTENER                                                            
    PORT IS 37XX                                                                
    BACKLOG IS 100                                                              
    TASK IS RHDCNP3J                                                            
    MODE IS SYSTEM                                                              
    PARM IS 'TASK=IDMSJSRV'.  
                                                                                
ADD LTERM TCLJSRV                                                               
    PTERM IS TCPJSRV.                                                           
                                                                                
*+ PTERM DEFINITION FOR 10 SOCKETS                                             
ADD PTERM TCP0001                                                               
    TYPE IS BULK                                                                
    REPEAT COUNT IS 9. 
                                                                                
ADD LTERM TCL0001                                                               
    PTERM IS TCP0001.                                                           
                                                                                
GENERATE.