Configuring ODBA support

Edit online

You can configure the IBM Data Virtualization Manager for z/OS to support the Open Database Access (ODBA) interface. Perform the following tasks to enable ODBA support.

Procedure

  1. Turn off IMS DBCTL support in the IN00.
  2. Under Enable IMS CCTL/DBCTL support, choose DontDoThis. This sets the value of the parameter DBCTL to NO
  3. Add the following to the IN00: 
    /*------------------------------------------------------------------*/
/* Enable IMS ODBA support                                          */
/*------------------------------------------------------------------*/
if DoThis then                                                         
do                                                                    
   "MODIFY PARM NAME(IMSODBA)             VALUE(YES)"                 
   "MODIFY PARM NAME(RRS)                 VALUE(YES)"                 
   "MODIFY PARM NAME(MAXODBACONNECT)      VALUE(12)"                  
   "MODIFY PARM NAME(TRACEIMSDLIEVENTS)   VALUE(NO)"                  
   "MODIFY PARM NAME(IMSID)               VALUE(IMS1)"                
                                                                      
   "DEFINE IMSODBA",                                                  
        "NAME(IMS1)",                                                 
        "CONTROLREGIONID(IMS1)",                                      
        "MAXTHREADS(10)",                                             
        "MINTHREADS(3)",                                              
        "USERID(AVZ9)"                                                
end
  4. Confirm that the virtual table uses IMS/DBCTL on Studio
  5. If IMS is a FASTPATH DB, add the following. 
    "FASTPATHNBA(100)",      
"FASTPATHOVERFLOW(100)", 
"FASTPATHALLOCATED(100)",