How to Query Records in Hot and Archive Databases

Document ID : KB000012639
Last Modified Date : 14/02/2018
Show Technical Document Details

There may be times when you need to manually view information directly from UAR databases. This document provides the commands to access "hot" databases and "Archived" databases.

Please Note:

You should never perform these commands on databases that are "live" on a system. Access should be done on copies of the databases outside the archive, hot and raw directories. Tampering and/or accessing live data can cause corruption and flag databases as tampered.


Can we access hot and archive databases with sqlite3 command?

LinuxAll UAR versions

Yes, we can access them with sqlite3 command.

for hot database:

#/opt/CA/SharedComponents/iTechnology/sqlite3 /data/hot/<hot database>

for Archive database:

#/opt/CA/SharedComponents/iTechnology/sqlite3 :cerod::/data/archive/<archive database>