What to do if update db fails
The updateDB utility performs database update tasks during an upgrade. This
utility keeps track of the last database update statement successfully performed.
It stores this information in a database change file with an extension of .dbc.
If updateDB fails during an upgrade, you can correct the error. Restart updateDB,
and resume from the last successfully completed task.
If you modify a database change file to fix a problem, you might need the updateDB
utility tool to rerun all database update tasks instead of resuming from where it
left off. For example, if you add a new statement before the last successful
statement, updateDB might not be able to resume successfully. In this scenario,
use the following SQL commands to clear variables used to identify the last
successful statement before restarting the updateDB utility:
delete from maxvars where varname in ('BMXLASTATEMENT','BMXLGFFLINE')
delete from maxvartype where varname in ('BMXLASTATEMENT','BMXLGFFLINE')