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 Rational solution for Collaborative 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 (LQE) and Link Index Provider (LDX) 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 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 ;
-- Grants for RM 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 RELM assuming schema prefix of RELMX and user ID of jazz
GRANT DELETE, INSERT, SELECT, UPDATE
ON TABLE
RELMX_COMMON_SNAPSHOT.SMPL_ITER,
RELMX_REPOSITORY.CONTRIBUTOR,
RELMX_REPOSITORY_SNAPSHOT.LATEST
TO JAZZ ;
Watch videos CLM playlistJazz.net channel User Education channel |
Learn more CLM learning circleAgile learning circle Learning circles |
Ask questions Jazz.net forumdeveloperWorks forums |
Get support Support PortalDeployment wiki Support blog |