0 Replies Latest reply on Oct 9, 2019 8:25 AM by John Quillinan

    IBM DB2 scanner user id permissions:  questions regarding documentation

    John Quillinan Active Member

      This question is in regard to the following documentation

       

      https://kb.informatica.com/faq/7/Pages/21/560644.aspx

      https://kb.informatica.com/solution/23/Pages/69/571374.aspx

      https://kb.informatica.com/h2l/HowTo%20Library/1/1216-EnterpriseDataCatalogResourceConfiguration.pdf

       

       

      • SYSCAT.INDEXES and SYSCAT.TRIGGERS is listed twice throughout the documentation.   Should this be deleted?  Or should it be SYSSTAT versus SYSCAT catalog views for these 2 objects?  REF:  IBM Knowledge Center
      IBM Knowledge Center

      SYSCAT views are read-only catalog views that are found in the SYSCAT schema.

      SYSSTAT views are updatable catalog views that are found in the SYSSTAT schema. The updatable views contain statistical information that is used by the optimizer. The values in some columns in these views can be changed to test performance.

      • SYSIBM.SYSPLAN
        SYSIBM.SYSDUMMY1
        are listed for IBM DB2; however, these views appears to be associated with z/OS. Do these requirements apply to IBM DB2 11.5 and DB2 for Linux UNIX and WIndows 10.5?

       

      • Documentation lists the following catalog views,
        SYSCAT.FUNCTIONS
        SYSCAT.PROCEDURES
        SYSCAT.FUNCDEP
        which are for functions, methods, and procedures defined in Db2 Version 7.1 and earlier.
        Do these views still apply to IBM DB2 10.5 and up? 

      • Regarding the catalog view SYSCAT.VIEWDEP, should this view be replaced with SYSCAT.TABDEP, which is presently not in the documentation?  Should SYSCAT.TABDEP be included in the set of catalog view to which the user id has SELECT permissions?