以远程方式创建 DB2 for z/OS 数据库表

您可以将服务器设置为在一个将访问 z/OS® 上的 DB2® 数据库表的非 z/OS 系统上运行。

关于此任务

您在满足下列条件的情况下可以远程方式创建数据库表:

过程

  1. 对于 Jazz Team Server,请转至 JazzInstallDir/server 目录并运行下列命令:
    repotools-jts -createTables
    repotools-jts -createWarehouse 
  2. 对于“变更和配置管理”(CCM) 应用程序,请转至 JazzInstallDir/server 目录并运行以下命令:
    repotools-ccm -createTables  
  3. 对于“质量管理”(QM) 应用程序,请转至 JazzInstallDir/server 目录并运行以下命令:
    repotools-qm -createTables 

下一步做什么

创建数据库表之后,如果您使用的是具有 DBADM 权限的用户标识,而不是具有 SYSADM 权限的用户标识,那么您必须授予对于由“创建表”过程所创建的视图的其他许可权。请使用与下列示例相似的 GRANT 语句。GRANT 语句必须包括您为存储库选择的前缀。(由 -- 来指示注释。)
-- 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 CCM 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 QM 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 ; 

反馈