The hpd_info.sql and db_info.sql scripts provide information about a schema and its parent database.
The hpd_info.sql script provides the following information:
• NLS session information.
• HPD information, schema information and statistics
• Checks for statistics on temporary tables
• Recompiling of any invalid objects in the schema
• Index information (non-valid or disabled)
• Review of paper chart status (neatline curvature)
• Used FOID ranges and sub-agencies
• Vector product information.
The HPD Server upgrade can fix some problems reported by this script, including deleting statistics on temporary tables used by HPD, recreating spatial indexes used by HPD, and fixing HPD sequences. These same fixes are also available by calling p_schema_diagnostic.repair.
The hpd_info script is run by the schema owner. The db_info script is run by a database administrator.
Process
To run either script, follow these steps:
1. In a Command Prompt, navigate to C:\ProgramData\CARIS\HPD\<version>\Server\admintools.
2. Start an SQL session by entering the following:
• For hpd_info.sql: sqlplus <schema_owner>/<password>@<database>
• For db_info.sql: sqlplus <database_admin>/<password>@<database>
SQLPlus is started.
3. Run the script by entering the script name, and then press <Enter>.
An HTML log file is generated and saved in the same folder as the scripts.