How to find DB_KEY for local database

Question

How can I find the db_key value to be used for patron_homedb in RESTful API requests?

Answer

DB_KEY is stored in the VOYAGER_DATABASES table.

1. Log into the database as the read-only user (ro_xxxdb / ro_xxxdb).
2. Use the following query to retrieve the db_key value for your local database

SELECT db_key
FROM voyager_databases
WHERE db_code='LOCAL';

• Article last edited: 25-Nov-2013