The Universal Broker subsystem, UNVUBR510 (by default), must be down in order to perform database recovery. Use standard IBM i database recovery procedures and attempt to restart the Universal Broker subsystem.
 
If the problem persists, restore the failing database file. The entire Universal Spool file library may be required if restoring individual files fails to correct the problem. As a last resort, delete all files in the Universal Spool file library and restart UNVUBR510.
 
Deleting the files from the Universal Spool library will result in loss of all data stored in those files, including spooled output for Manager Fault Tolerant jobs. All affected jobs may need to be re-run.

The Broker daemon must be down to perform database recovery. A backup of either the database file being recovered or the entire directory should be created before recovery is attempted.
 
A sample database recovery script is provided in file ubrdbrec in the /opt/universal/ubroker/bin directory. The script uses the Universal Database Utilities to dump and reload a database file. The default location of all Universal Broker databases is the /var/opt/universal/spool directory.
 
The user ID with which the recovery script runs requires appropriate permissions to the database directory and to the database file. Write access is required to the directory and read and write access is required to the database file.
 
The ubrdbrec script accepts an optional argument: the database file name to recover. If no database file name is specified, the ues.db database is recovered. The script ends with exit code 0 if successful and a non-zero exit code if it failed.

The Broker service must be stopped to perform database recovery. A backup of either the database file being recovered or the entire directory should be created before recovery is attempted.
 
A sample database recovery batch file is provided in file ubrdbrec.bat in the "\Program Files\Universal\UBroker\bin" directory. The batch file uses the Universal Database Utilities to dump and reload a database file.
 
The default location of all Universal Broker databases is directory "\Program Files\Universal\spool\ubroker".
 
The user ID with which the recovery script runs requires appropriate permissions to the database directory and to the database file. Write access is required to the directory and read and write access is required to the database file.
 
The ubrdbrec.bat batch file accepts an optional argument: the database file name to recover. If no database file name is specified, the ues.db database is recovered. The batch file ends with exit code 0 if successful and a non-zero exit code if it failed.