Utilities & Scripts

From CloudDB
Jump to: navigation, search

Reports[edit]

zz_report_error.sql - Show details about an error code from zztat's log table in the last 24h.

zz_report_error_all.sql - Show all details about an error code from zztat's log table, since the start of the data.

zz_report_gauge.sql - Show the current gauges.

zz_report_reaction_config.sql - Shows the reaction configuration parameters and their current values.

zz_report_metric.sql - Show the current metrics.


Enabling Features[edit]

The following scripts enable various zztat features:

zz_util_alter_session.sql

zz_util_mail.sql

zz_util_sys_helper.sql

Disabling Features[edit]

zz_no_alter_session.sql

Support Scripts & Various[edit]

zz_util_sql92.sql

zz_util_void_script.sql

zz_util_recompile.sql - Recompile zztat packages

zz_util_recompile_sys.sql - Recompile the zz$sys_helper package, if it's installed


zzdiag.sql - Run diagnostics and a system status check against a zztat database.

zztail.sh - Follow the zztat log in real-time.