Lorsque vous utilisez DB2 for z/OS, vous devez d'abord utiliser les outils de référentiel pour créer les tables de base de données et les index requis pour Jazz Team Server, les applications Rational solution for Collaborative Lifecycle Management (CLM) que vous comptez utiliser et l'entrepôt de données.
-- Accorde des droits pour JTS en utilisant le préfixe de schéma JTSX et l'ID utilisateur jazz
GRANT DELETE, INSERT, SELECT, UPDATE
ON TABLE
JTSX_COMMON_SNAPSHOT.SMPL_ITER,
JTSX_REPOSITORY.CONTRIBUTOR,
JTSX_REPOSITORY_SNAPSHOT.LATEST
TO JAZZ ;
-- Accorde des droits pour CCM en utilisant le préfixe de schéma CCMX et l'ID utilisateur 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 ;
-- Accorde des droits pour QM en utilisant le préfixe de schéma QMX et l'ID utilisateurjazz
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 ;