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 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
What to do next
--
.)
-- 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 ;