When iQSonar is inventorying a database application (DB2, Oracle, SQL Server, Informix, and so on) it not only looks for files on the server's file systems, it needs to log in to the database and execute certain commands. If it fails to log in to the database it cannot fully report all the required information for licencing reports.
Note that the following queries use a "Connection" column to determine what type of database we're looking for. In order to get a list of the possible valid connection types in the user environment, the following one line query is useful:
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT DISTINCT Connection FROM [history].[t_ConnectionHistory] |
The following queries will enable you to investigate database connection issues:
...