Granting catalog access to Db2 tables

Before you install and configure the data management products, make sure that you grant users the access on following Db2® catalog tables by running the following DCL script:

GRANT SELECT ON TABLE SYSIBM.SYSAUXRELS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCHECKDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCHECKS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCHECKS2 TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSCOLDIST TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCOLDISTSTATS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSCOLSTATS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCOLUMNS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCONSTDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCONTEXT TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCONTEXTAUTHIDS TO <Db2 data management product user>;   
GRANT SELECT ON TABLE SYSIBM.SYSCONTROLS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSCOPY TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSCTXTTRUSTATTRS TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSDATABASE TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSDATATYPES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSDEPENDENCIES TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSDUMMY1 TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSDUMMYA TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSDUMMYE TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSDYNQRY TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSDYNQRYDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSENVIRONMENT TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSFIELDS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSFOREIGNKEYS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSINDEXES TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSINDEXPART TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSINDEXSPACESTATS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSINDEXSTATS TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSJARCONTENTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSJAROBJECTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSJAVAOPTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSJAVAPATHS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSKEYCOLUSE TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSKEYS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSKEYTARGETS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSKEYTARGETSTATS TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSKEYTGTDIST TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSKEYTGTDISTSTATS TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSLEVELUPDATES TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSLOBSTATS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSOBDS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSOBJROLEDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPACKAGE TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSPACKCOPY TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPACKDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPACKLIST TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPACKSTMT TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPARMS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPENDINGDDL TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPENDINGOBJECTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPKSYSTEM TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPLAN TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSPLANDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSPLSYSTEM TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSRELS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSROLES TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSROUTINES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSROUTINES_OPTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSROUTINES_SRC TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSSEQUENCES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSEQUENCESDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSESSION TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSESSION_EX TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSESSION_STATUS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSSTMT TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSTOGROUP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSTRINGS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSSYNONYMS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSTABCONST TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSTABLEPART TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSTABLES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSTABLESPACE TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSTABLESPACESTATS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSTABLES_PROFILES TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSTABSTATS TO <Db2 data management product user>;  
GRANT SELECT ON TABLE SYSIBM.SYSTRIGGERS TO <Db2 data management product user>;
GRANT SELECT ON TABLE SYSIBM.SYSUTIL TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSUTILX TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSVARIABLES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSVIEWDEP TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSVIEWS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSVOLUMES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSXMLRELS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSXMLSTRINGS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSXMLTYPMOD TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.SYSXMLTYPMSCHEMA TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.XSRANNOTATIONINFO TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.XSROBJECTCOMPONENTS TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.XSROBJECTHIERARCHIES TO <Db2 data management product user>; 
GRANT SELECT ON TABLE SYSIBM.XSROBJECTS TO <Db2 data management product user>;