ADDM: Customers report access errors apparently associated with the discovery of DB2

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Discovery


    COMPONENT:

    BMC Atrium Discovery and Dependency Mapping


    APPLIES TO:

    BMC Atrium Discovery and Dependency Mapping



    PROBLEM:

    Customers report access errors apparently associated with the discovery of DB2. Below is an example of the error:

    --------------------------------------------------------------
    2016-12-21-04.48.04.001107-480 I3401834A538 LEVEL: Error
    PID : 17039452 TID : 160014 PROC : db2sysc 0
    INSTANCE: abc NODE : 000 DB : CSE1PD01
    APPHDL : 0-19653 APPID: *LOCAL.instpd01.161221124803
    AUTHID : ADDMUSER HOSTNAME: xyz
    EDUID : 160014 EDUNAME: db2agent (CSE1PD01) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:180
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
    "SQLCA has already been built"


    How can we identify the pattern or script that is attempting this access in order to disable it? The host owner does not want to allow access and does not want to manage the alarms.
     


    SOLUTION:

    Discovery TKU includes patterns to do "deep" database discovery for DB2. For reference see:

    https://docs.bmc.com/docs/display/Configipedia/IBM+DB2+RDBMS+-+Database+Detail+Pattern
    https://docs.bmc.com/docs/display/Configipedia/IBM+DB2+RDBMS+on+Mainframe+-+Database+Detail+Pattern

    If no database credentials have been defined in the Discovery UI for DB2, these patterns will not try to connect thru JDBC. 

    However, other DB2-related patterns may run some commands or SQL queries to get information about the installation. 

    To see a complete list of all commands executed by TKU patterns, download the Command/File Matrix file bu doing the following:

    - Go to https://docs.bmc.com/docs/display/Configipedia/Schedule+and+Roadmap/

    - Click on the Release Name link for the relevant TKU.

    - Go to the bottom of the page and find the Command/File Matrix section. Click the link in the section "can be downloaded from here".

    - From the Technology Knowledge Update page that appears, click the link in the section "can be downloaded from here". This will display the Command/File Matrix.

    You can then disable or modify any patterns that run commands or SQL queries that are not allowed in your environment. Note however that subsequent TKU updates may revert these changes.

    Please also note that custom patterns may issue DB2 commands or queries (for example through the use of an integration point).


    Article Number:

    000132102


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles