How to enable SQL logging in UCSD 6.6

Available Languages

Download Options

  • PDF     (41.5 KB)
    View with Adobe Reader on a variety of devices
  • ePub     (70.6 KB)
    View in various apps on iPhone, iPad, Android, Sony Reader, or Windows Phone
  • Mobi (Kindle)     (64.1 KB)
    View on Kindle device or Kindle app on multiple devices
Updated:February 25, 2019
Document ID:214135

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

This document describes how to enable SQL logging within the UCS Director (UCSD) 6.6 environment.

Prerequisites

Requirements

Cisco recommends that you have knowledge of these topics:

  • UCS Director (UCSD)
  • Structured Query Language (SQL)

Components Used

The information in this document is based on UCS Director (UCSD) 6.6.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, ensure that you understand the potential impact of any command.

Problem: How to enable SQL logging in UCS Director (UCSD)?

A more detailed troubleshooting and problem analysis require in certain case to enable SQL logging. For example this log information helps to understand which database tables are accessed or may encounter errors during the table access.

Solution

Connect to the UCSD UI and go to Administration -> Support Information -> Enable debug logging

To view the UCSD application logfile (logfile.txt) from the command line interface (CLI) there are two different approaches possible.

Log review with the shelladmin user

  1. Open a ssh terminal 
  2. Specify the shelladmin credentials
  3. Select option 18 - tail inframgr logs

Log review with the root user

  1. Open a ssh terminal
  2. Specify the root user credentials
  3. Execute the following comand
tail -f /opt/infra/inframgr/logfile

Related Information

TAC Authored

Contributed by Cisco Engineers

  • Adam Jendrosek

Was this Document Helpful?

FeedbackFeedback

Contact Cisco