IBM Support

How to customize Historical Query Execution, Locking events, Utility events and Threshold violations Retention of IBM Integrated Analytics System Console

How To


Summary

By default, IBM Integrated Analytics System (IIAS) Console collects and saves up to 10000 entries of query executions, locking events, utility events and threshold violations in the repository, and prunes the collected statements after 7 days. You can view the historical query executions in MONITOR-Workloads-Query Executions panel by switching the Time mode from Realtime to History. 

By customizing the number of historical entries and the retention period of query executions, locking events, utility events and threshold violations, IIAS console can save more number of entries and keep the records longer, which facilitates problem diagnosis or audit.However, it might also increase storage consumption.

Steps

To customize the historical query execution, locking events, utility events and threshold violations retention, use one of the following methods:

Command line

Prerequisites:
  • Root access to head node of the appliance
  • Will trigger a restart of console once set successfully
Command: 
/opt/ibm/dsserver/bin/set_retention.sh
-d parameter to specify days to keep the record
-m parameter to specify max number of data records.
yes/no `yes` to trigger a restart of console
Sample:
# docker exec -it web_console /opt/ibm/dsserver/bin/set_retention.sh -d 30 -m 1000000  yes

REST API 

Prerequisites:
  • User with BLUADMIN role
  • Will trigger a restart of console once set successfully
API:
POST /console/dbapi/v3/preference/repo/retention
Data in JSON: {"days":30,"maxNum":1000000}
Sample:
$ curl -u "<user>:<password>" -k -X POST -H 'Content-Type:application/json' https://<HOST>:11089/console/dbapi/v3/preference/repo/retention -d  '{"days":30, "maxNum":1000000}'
{"rc":0,"message":"Usage: set_retention.sh -d 7 -m 1000 no. Either -d or -m should be passed. 'no' specify no restart right away and should be passed as the last parameter. The absence of no will restart the server immediatel4 is equal to 1209600000 millisecondsMonitor data collection retention was set to 30 days. Maximal data number was set to 1000000"}

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHRBY","label":"IBM Integrated Analytics System"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"1.0.17.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2019

UID

ibm10959515

Page Feedback