To help you learn how to access the Management Console for Unix WebService api using Web service calls, One Identity has included eight code sample projects in the product. From the installation media, navigate to /console/client/windows/QmcuWebserviceExamples.zip directory and extract the contents of the QmcuWebserviceExamples.zip file.
The Readme.txt file describes each of the example projects and discusses a few important points that will help you use the WebService calls.
Management Console for Unix uses a HSQLDB (Hyper Structured Query Language Database) to store its data such as information about the hosts, settings, users, groups, and so forth. This appendix provides general database information and guidelines for maintaining this database.
Management Console for Unix database files are located in the following locations:
The data for each database consists of multiple files located in the same directory. All the database files start with the same name as defined by the value in the jdbc.url key. For Management Console for Unix, the database consists of the following files by default:
|console.lck||This file is used to determine if the database is in use. If console.lck exists, the server is currently running. This file is deleted once the database is properly shutdown. DO NOT BACKUP THIS FILE.|
|console.log||This file contains the extra SQL statements that have modified the console database since the last checkpoint (something like the 'Redo-log' or 'Transaction-log', but just text.) For a normal shutdown this file is deleted once the database has completely shutdown.|
|console.properties||This file contains general settings about the database including the console.properties entry 'modified'. If [modified=yes], the database is either running or was not closed correctly (because the close algorithm sets 'modified' to 'no' at the end).|
|console.script||This file contains the SQL statements that make up the database up to the last checkpoint.|
It is best to perform a backup when the HSQLDB is not running. use normal backup methods, such as archiving the files in a compressed bundle.
To backup a database
Note: If a backup immediately follows a checkpoint, then the console.log file can also be excluded, reducing the significant files to console.properties and console.script.
You can backup the files while the HSQLDB server is running, but make sure that a shutdown or checkpoint is NOT performed during the backup. If you perform a backup while the server is running, you will need to backup the console.log file, as well. This file will be deleted once the server is shutdown.