當您使用 DB2® for z/OS® 時,一開始您必須利用儲存庫工具,為 Jazz™ Team Server、任何您打算使用的 Rational® Collaborative Lifecycle Management (CLM) 應用程式解決方案以及資料倉儲,建立所需的資料庫表格和索引。
-- 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 ;