DatabaseΒΆ
CSM Database (CSM DB) holds information about systems hardware configuration, hardware inventory, RAS, diagnostics, job steps, job allocations, and CSM configuration. This information is essential for the CORAL system to run properly and for resources accounting.
CSM DB uses PostgreSQL.
- CSM Database Appendix
- Using csm_db_history_archive.py
- Using csm_db_backup_script_v1.sh
- Using csm_db_connections_script.sh
- Using csm_db_history_delete.py
- Using csm_db_schema_version_upgrade_19_0.sh
- Using csm_db_script.sh
- Using csm_db_stats.sh script
- Usage Overview
- 1. Table data activity
- 2. Index related information
- 3. Index Analysis Usage Information
- 4. Table Lock Monitoring
- 5. DB schema Version Query
- 6. DB Connections with details
- 7. PostgreSQL users with details
- 8. PostgreSQL Version Installed
- 9. DB Archiving Stats
- 10. DB Delete Count Stats
- 11. DB Vacuum Stats
- Using csm_ras_type_script.sh