Recommended Resources
Abstract
A single stop shop of resources and documents to help you configure and setup Query History Data Collection on an IBM PureData System for Analytics appliance.
Content
Capturing query history data on a Pure Data for Analytics appliance is a key DBA task needed to understand the usage trends and patterns along with gathering information regarding object access, query runtimes, access plans, troubleshoot long running queries etc.
This document intends to capture various sources of published information on configuring/setting up query history data that would allow end users greater self sufficiency and flexibility in administering the PDA appliance.
Below are various resources available that explain configuring query history in detail as well as some best practices around it.
IBM PureData Systems for Analytics' Product Documentation thoroughly explains key concepts and the steps needed along with various configuration options:
(Please select the appropriate NPS version from the drop down on the below links)
Forum discussions and Blog Posts on the extremely popular dWAnswers and the IBM PureData-Enzee Community are great additional resources to perform searches for the latest information or initiate new discussion threads on any topic. For instance:
- How do I change query history configuration ?
- How to display query history timestamp in local timezone ?
- 50 PureData Nuggets #37 : How to Upgrade History Database From v1 ,v2 to v3
- Reconcile old QUERY_HISTORY database with new Query History database
IBM published Technotes** are another set of resources targeted to address specific customer questions or issues encountered.
Here are several specific Technotes around query history data configurations and capturing.
- How to create and configure Query History for IBM PureData System for Analytics
- How do I capture query history information in a persistent table?
- What do the columns in the table nz_query_history contain? How are they populated?
- How do I configure Linux ODBC Client attributes that persists in the NPS query history database and helps in determining the actual users of repetitive inefficient queries ?
- What does the CONFIG_LEVEL value mean in SHOW HISTORY CONFIGURATION output ?
- How can I change a Query History user's password?
- ERROR: Query History User is 'ADMIN'.
**You now have the ability to ask questions or open up new discussion threads on technotes as well, including this one.
Just click on 'Ask a Question' below the technotes!!
IBM PDA Best Practices contain valuable information targeted for new users. The following resources provide good reference for best practices on query history data collection and configuration:
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21993395