SQL Statement Questions

book

Article ID: 50081

calendar_today

Updated On:

Products

CA Capacity Manager CA MICS Resource Management CA Distributed Database Management CA Database Analyzer for DB2 for Oracle

Issue/Introduction

Description:

Would like to set up User Defined Scans for the Insight Agent to monitor the Database. The SQL statement works, but they don't see all the required data in the DCC Graphs. Why am I not able to see the data returned to the Graphs in DCC UI?

(Scan Group Details -> Individual Scan Types).

Solution:

  1. An SQL scan can only return 2 columns per scan. The 'Object' column and the 'Value' column are the only 2 columns you can have. You would need to set up separate SQL statements to have more data returned.

    Please see the attached document for more information.

  2. Please run the script and make sure it works with the database. If the script does work, please create a new script file and split the SELECT statement onto three separate lines like this template below and make sure you place ';' at the end of the statement:-

    SELECT xxxxxxxxxxxxxxxx
    FROM xxxxxxxxxxxxxxxxxxxxxxx
    WHERE xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;

Environment

Release:
Component: UNIDCC

Attachments

1558535184042TEC556056.zip get_app