Smarts NCM: Which log file can I check to see if database transactions are being executed?

Products

• VMware

Issue/Introduction

Symptoms:


Which log file can I check to see if Smarts Network Configuration Manager (Smarts NCM) database transactions are being executed?

Environment

VMware Smart Assurance - NCM

Resolution

To see if database transactions are being carried out, review the server.postmaster file.  This file is located under the /var/log/controldb directory. The following are examples of entries that can be found in the file:

2012-09-12 13:48:06.858 EDT - SessionId:5050cad6.4e5b - TransId:0 - STATEMENT:  ALTER TABLE ONLY cm_cel_audit_record
            ADD CONSTRAINT cm_cel_audit_record_pkey PRIMARY KEY (id);
2012-09-12 13:48:06.859 EDT - SessionId:5050cad6.4e5b - TransId:0 - ERROR:  multiple primary keys for table "cm_config_file" are not allowed

2010-10-08 14:58:10.898 EDT - SessionId:4caf69c2.4dd4 - TransId:7542 - NOTICE: Command executed is: ALTER TABLE voyence.cm_meta_attribute_value DROP CONSTRAINT cm_meta_attribute_value_site_id_fkey

The examples above shows output indicating a table drop has taken place or an error has occurred when trying to execute a particular command.