QDB database configuration uses many files. Suppose you want to create a database named customerdb and store its data in /usr/local/db/ and its schema definition files in your home directory of /home/user1/, and that you're using the default PPS configuration path (/pps/qnx/qdb/).
The following table lists the files required to set up this database:
Filename and path | Purpose |
---|---|
/pps/qnx/qdb/config/customerdb | Text file comprising configuration object that provides paths to other setup files and specifies policy settings such as auto-attached databases |
/pps/qnx/qdb/status/customerdb | Status file created by QDB to indicate database state after loading attempt |
/usr/local/db/customerdb | Raw SQLite file created by QDB, if necessary, to store database content |
/home/user1/customerdb.sql | Schema definition file that defines tables, views, indexes, and triggers that make up the database |
/home/user1/customerdb_data.sql | Data schema file that specifies initial data for populating the database |
/home/user1/customerdb_connect.sql | Client schema file that defines commands to run whenever a client establishes a connection |
/dev/qdb/customerdb | QDB device file that's used for PPS object publishing |