Vision Database Scan Start Page

The main goal of VdbScan.vis is to alert teams using vision to problems in their databases before they become critical. The goal of this package is to raise alarm about issues in a database so that there is a week or more to work on implementing a solution BEFORE production is impacted.

VdbScan Error Message Lookup

VdbScan Error Message Lookup is where you should start looking if you have an error generated by VdbScan.vis

Daily Use Prescription

################################################################################
# VdbScan.vis
#
# USAGE:
#   Run this report EVERY DAY if possible.  Any output from this script should
#   be evaluated per the instructions here:
#   https://vision-dbms.github.io/vision/VdbScan/
#
#   Most days this script will not produce any output.  We suggest scripting
#   around this script such that it sends an email to your vision developers
#   every day that it produces output.
#
# EXAMPLE VISION SCRIPT:
#   "/path/to/VdbScan.vis" asFileContents evaluate;
#   AdminTools vdbScan;
#   ?g
#   AdminTools vdbScanExtraInformation;
#   ?g
#
# OPTIONS:
#   If you have exceptions you'd like to include load them after you load
#   VdbScan.vis and before you call AdminTools vdbScan .
#
################################################################################

Two-liner

For reference

limit datasize 20000000
echo QUIT | batchvision -x '"VdbScan.vis" asFileContents evaluate; AdminTools vdbScan;' >& VdbScan.log &

Getting the File

VdbScan.vis can be downloaded here.

What can be detected

  • Product Mapped Index Cartesian Space Exceeded
  • Index Map too Large
  • Huge Containers
  • NDF running out of Space
  • Container Table Out of Space
  • Requested Alteration Count Exceeds Maximum