2 Database

This chapter covers information regarding maintenance of the database.

Database Downtime in Central Office

Note: This information is only applicable if messages are being sent to the Java Message Service (JMS) queue.

When the Central Office database is down for maintenance or backing up, the Central Office application should be brought down as well. See your application server documentation for information on stopping the application server container running Central Office.

While the Central Office database is down, Point-of-Service continues sending messages containing retail transaction information to Central Office. This information cannot be persisted in the Central Office database until the database is once again available. If the database remains down, and the number of messages, sends, and retries exceeds a specified number, Point-of-Service stops attempting to send the messages to Central Office and instead places the messages into an error queue. At that point, manual intervention is required to resend the messages from Point-of-Service or to retrieve the messages from the error queue.