Creating Db2 for z/OS database tables remotely

You can set up servers to run on a non-z/OS system that accesses Db2 database tables on z/OS.

About this task

You can create the database tables remotely if you meet the following conditions:
  • You have customized the teamserver.properties for Db2 for z/OS. See Customizing the Jazz Team Server and Engineering Lifecycle Management properties files for Db2 on z/OS.
  • You have completed the additional configuration steps to make the Db2 for z/OS JDBC and license .jar files available on your system. See Configuring a Jazz Team Server that is not on z/OS to use a Db2 repository on z/OS.
    Important: Run the createTables command only if this is a new installation.
    Note:
    • When you run the repotools command, the teamserver.properties file will be updated and the original file with the original content will be saved in the same directory.
    • You might see a warning that the public URI has not been set. You can ignore this warning at this time because the public URI will be set when you run the setup wizard. For details, see Running the setup by using Custom setup in the setup wizard.

    The Lifecycle Query Engine and Link Index Provider repositories can use Db2 z/OS, but these applications do not use repository tools to create database tables. Tables are created when the server is started.

    Report Builder (RS) data is not stored in Db2 z/OS but is stored in the filesystem, and also does not use repository tools.

Procedure

  1. For the Jazz Team Server, go to the JazzInstallDir/server directory and run the following commands:
    repotools-jts -createTables
    repotools-jts -createWarehouse 
  2. For the Engineering Workflow Management application, go to the JazzInstallDir/server directory and run the following command:
    repotools-ccm -createTables  
  3. For the Engineering Test Management application, go to the JazzInstallDir/server directory and run the following command:
    repotools-qm -createTables 
  4. For the IBM DOORS® Next application, go to the JazzInstallDir/server directory and run the following command:
    repotools-rm -createTables 
  5. For the Data Collection Component application, go to the JazzInstallDir/server directory and run the following command:
    repotools-dcc -createTables 
  6. For the Global Configuration Management (GC) application, go to the JazzInstallDir/server directory and run the following command:
    repotools-gc -createTables 
  7. For the IBM Engineering Lifecycle Optimization Engineering Insights application, go to the JazzInstallDir/server directory and run the following command:
    repotools-relm -createTables 

What to do next

After you create the database tables, if you used a user ID with DBADM authority instead of a user ID with SYSADM authority, you must grant additional permissions to the views created by the table creation process. Use GRANT statements like the following examples. The GRANT statements must include the prefix you selected for your repositories. (Comments are indicated by --.)
-- Grants for JTS assuming schema prefix of JTSX and user ID of jazz
GRANT DELETE, INSERT, SELECT, UPDATE 
    ON TABLE 
         JTSX_COMMON_SNAPSHOT.SMPL_ITER, 
         JTSX_REPOSITORY.CONTRIBUTOR,           
         JTSX_REPOSITORY_SNAPSHOT.LATEST   
      TO JAZZ ;

-- Grants for Engineering Workflow Management assuming schema prefix of CCMX and user ID of jazz
GRANT DELETE, INSERT, SELECT, UPDATE                                         
      ON TABLE                                                                  
         CCMX_BUILD_SNAPSHOT.JUNIT_CNT, 
         CCMX_COMMON_SNAPSHOT.SMPL_ITER,         
         CCMX_REPOSITORY.CONTRIBUTOR, 
         CCMX_REPOSITORY_SNAPSHOT.LATEST,          
         CCMX_WORKITEMS_SNAPSHOT.NEW_WI_COUNT,                                  
         CCMX_WORKITEMS_SNAPSHOT.WC_BIGDECIMAL_EXT_FROM,                        
         CCMX_WORKITEMS_SNAPSHOT.WC_BIGDECIMAL_EXT_TO,                          
         CCMX_WORKITEMS_SNAPSHOT.WC_BOOL_EXT_FROM,                              
         CCMX_WORKITEMS_SNAPSHOT.WC_BOOL_EXT_TO,                                
         CCMX_WORKITEMS_SNAPSHOT.WC_DOUBLE_EXT_FROM,                            
         CCMX_WORKITEMS_SNAPSHOT.WC_DOUBLE_EXT_TO,                              
         CCMX_WORKITEMS_SNAPSHOT.WC_FLOAT_EXT_FROM,                             
         CCMX_WORKITEMS_SNAPSHOT.WC_FLOAT_EXT_TO,                               
         CCMX_WORKITEMS_SNAPSHOT.WC_INT_EXT_FROM,                               
         CCMX_WORKITEMS_SNAPSHOT.WC_INT_EXT_TO,                                 
         CCMX_WORKITEMS_SNAPSHOT.WC_LARGE_STRING_EXT_FROM,                      
         CCMX_WORKITEMS_SNAPSHOT.WC_LARGE_STRING_EXT_TO,                        
         CCMX_WORKITEMS_SNAPSHOT.WC_LONG_EXT_FROM,                              
         CCMX_WORKITEMS_SNAPSHOT.WC_LONG_EXT_TO,                                
         CCMX_WORKITEMS_SNAPSHOT.WC_MEDIUM_STRING_EXT_FROM                      
      TO JAZZ ; 
                                                                                
GRANT DELETE, INSERT, SELECT, UPDATE                                         
      ON TABLE                                                                  
         CCMX_WORKITEMS_SNAPSHOT.WC_MEDIUM_STRING_EXT_TO,                       
         CCMX_WORKITEMS_SNAPSHOT.WC_STRING_EXT_FROM,                            
         CCMX_WORKITEMS_SNAPSHOT.WC_STRING_EXT_TO,                              
         CCMX_WORKITEMS_SNAPSHOT.WC_TIMESTAMP_EXT_FROM,                         
         CCMX_WORKITEMS_SNAPSHOT.WC_TIMESTAMP_EXT_TO,                           
         CCMX_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_FROM,                           
         CCMX_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_TO,                             
         CCMX_WORKITEMS_SNAPSHOT.WS_BIGDECIMAL_EXT,                             
         CCMX_WORKITEMS_SNAPSHOT.WS_BOOL_EXT,                                   
         CCMX_WORKITEMS_SNAPSHOT.WS_DOUBLE_EXT,                                 
         CCMX_WORKITEMS_SNAPSHOT.WS_FLOAT_EXT,                                  
         CCMX_WORKITEMS_SNAPSHOT.WS_INT_EXT,                                    
         CCMX_WORKITEMS_SNAPSHOT.WS_LARGE_STRING_EXT,                           
         CCMX_WORKITEMS_SNAPSHOT.WS_LONG_EXT,                                   
         CCMX_WORKITEMS_SNAPSHOT.WS_MEDIUM_STRING_EXT,                          
         CCMX_WORKITEMS_SNAPSHOT.WS_STRING_EXT,                                 
         CCMX_WORKITEMS_SNAPSHOT.WS_TIMESTAMP_EXT                               
      TO JAZZ ;

-- Grants for Engineering Test Management assuming schema prefix of QMX and user ID of jazz
GRANT DELETE, INSERT, SELECT, UPDATE                                         
      ON TABLE                                                                  
         QMX_COMMON_SNAPSHOT.SMPL_ITER,                                         
         QMX_PLANNING_SNAPSHOT.DEFECT_FACT, 
         QMX_REPOSITORY.CONTRIBUTOR,         
         QMX_REPOSITORY_SNAPSHOT.LATEST,                                        
         QMX_RESERVATION_SNAPSHOT.GROUP_RESERVATION_DAY_VIEW,                   
         QMX_RESERVATION_SNAPSHOT.RESERVATION_DAY_VIEW,                         
         QMX_WORKITEMS_SNAPSHOT.NEW_WI_COUNT,                                   
         QMX_WORKITEMS_SNAPSHOT.WC_BIGDECIMAL_EXT_FROM,                         
         QMX_WORKITEMS_SNAPSHOT.WC_BIGDECIMAL_EXT_TO,                           
         QMX_WORKITEMS_SNAPSHOT.WC_BOOL_EXT_FROM,                               
         QMX_WORKITEMS_SNAPSHOT.WC_BOOL_EXT_TO,                                 
         QMX_WORKITEMS_SNAPSHOT.WC_DOUBLE_EXT_FROM,                             
         QMX_WORKITEMS_SNAPSHOT.WC_DOUBLE_EXT_TO,                               
         QMX_WORKITEMS_SNAPSHOT.WC_FLOAT_EXT_FROM,                              
         QMX_WORKITEMS_SNAPSHOT.WC_FLOAT_EXT_TO,                                
         QMX_WORKITEMS_SNAPSHOT.WC_INT_EXT_FROM,                                
         QMX_WORKITEMS_SNAPSHOT.WC_INT_EXT_TO,                                  
         QMX_WORKITEMS_SNAPSHOT.WC_LARGE_STRING_EXT_FROM,                       
         QMX_WORKITEMS_SNAPSHOT.WC_LARGE_STRING_EXT_TO,                         
         QMX_WORKITEMS_SNAPSHOT.WC_LONG_EXT_FROM                                
      TO JAZZ ;                                                 
                                                                                
   GRANT DELETE, INSERT, SELECT, UPDATE                                         
      ON TABLE                                                                  
         QMX_WORKITEMS_SNAPSHOT.WC_LONG_EXT_TO,                                 
         QMX_WORKITEMS_SNAPSHOT.WC_MEDIUM_STRING_EXT_FROM,                      
         QMX_WORKITEMS_SNAPSHOT.WC_MEDIUM_STRING_EXT_TO,                        
         QMX_WORKITEMS_SNAPSHOT.WC_STRING_EXT_FROM,                             
         QMX_WORKITEMS_SNAPSHOT.WC_STRING_EXT_TO,                               
         QMX_WORKITEMS_SNAPSHOT.WC_TIMESTAMP_EXT_FROM,                          
         QMX_WORKITEMS_SNAPSHOT.WC_TIMESTAMP_EXT_TO,                            
         QMX_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_FROM,                            
         QMX_WORKITEMS_SNAPSHOT.WORKITEM_CHNGS_TO,                              
         QMX_WORKITEMS_SNAPSHOT.WS_BIGDECIMAL_EXT,                              
         QMX_WORKITEMS_SNAPSHOT.WS_BOOL_EXT,                                    
         QMX_WORKITEMS_SNAPSHOT.WS_DOUBLE_EXT,                                  
         QMX_WORKITEMS_SNAPSHOT.WS_FLOAT_EXT,                                   
         QMX_WORKITEMS_SNAPSHOT.WS_INT_EXT,                                     
         QMX_WORKITEMS_SNAPSHOT.WS_LARGE_STRING_EXT,                            
         QMX_WORKITEMS_SNAPSHOT.WS_LONG_EXT,                                    
         QMX_WORKITEMS_SNAPSHOT.WS_MEDIUM_STRING_EXT,                           
         QMX_WORKITEMS_SNAPSHOT.WS_STRING_EXT,                                  
         QMX_WORKITEMS_SNAPSHOT.WS_TIMESTAMP_EXT                                
      TO JAZZ ; 
-- Grants for Engineering Requirements Management DOORS Next assuming schema prefix of RMX and user ID of jazz
GRANT DELETE, INSERT, SELECT, UPDATE 
    ON TABLE 
         RMX_COMMON_SNAPSHOT.SMPL_ITER, 
         RMX_REPOSITORY.CONTRIBUTOR,           
         RMX_REPOSITORY_SNAPSHOT.LATEST   
      TO JAZZ ;

-- Grants for DCC assuming schema prefix of DCCX and user ID of jazz  
GRANT DELETE, INSERT, SELECT, UPDATE
    ON TABLE
         DCCX_COMMON_SNAPSHOT.SMPL_ITER,
         DCCX_REPOSITORY.CONTRIBUTOR,
         DCCX_REPOSITORY_SNAPSHOT.LATEST
       TO JAZZ ;

-- Grants for GC assuming schema prefix of GCX and user ID of jazz  
GRANT DELETE, INSERT, SELECT, UPDATE
    ON TABLE
         GCX_COMMON_SNAPSHOT.SMPL_ITER,
         GCX_REPOSITORY.CONTRIBUTOR,
         GCX_REPOSITORY_SNAPSHOT.LATEST
       TO JAZZ ;

-- Grants for ENI assuming schema prefix of ENIX and user ID of jazz  
GRANT DELETE, INSERT, SELECT, UPDATE
    ON TABLE
         ENIX_COMMON_SNAPSHOT.SMPL_ITER,
         ENIX_REPOSITORY.CONTRIBUTOR,
         ENIX_REPOSITORY_SNAPSHOT.LATEST
       TO JAZZ ;