Where is the Vertica DB log located in CA Performance Management (CAPM) and what is the log used for?

Products

• CA Performance Management
• Network Observability

Issue/Introduction

Where is the Vertica DB log located in CA Performance Management (CAPM) and what is the log used for?

 

Environment

DX NetOps CAPM all releases

Resolution

During startup before the vertica log has been initialized to write messages, each node in the cluster writes messages into a file named dbLog. This log is useful to diagnose situations where database fails to start before it can write messages into vertica.log.

The vertica.log can be found at the following path, using catalog-path and database-name as described above:

catalog-path/database-name/dbLog

For example, if using default DB name (drdata) and path, then:

/opt/catalog/drdata/v_drdata_node0001_catalog/dbLog

While the main Vertica log would be located at:

/opt/catalog/drdata/v_drdata_node0001_catalog/vertica.log