Vertica provide the following diagnostic tools:
In This Chapter
Determining the Version Number
Diagnostics Utility
DUMP_CATALOG
DUMP_LOCKTABLE