Warning during restore - SQLUB_NO_INTERRUPT and SQLUD_NO_INTERRUPT
John Darwin
I made a restore (restore db xy use tsm taken at ...") and received
the following message:
SQL2540W Restore is successful, however a warning "2539" was
encountered during database restore while processing in no interrupt
mode.
Explanation of SQL2540W: The database restore utility was invoked in
no interrupt mode, i.e. SQLUB_NO_INTERRUPT or SQLUD_NI_INTERRUPT was
specified. During the processing a warning was encountered but not
returned at the time it was encountered. The restore has completed
successfully and the warning message found is shown at the completion
in this message.
Does anybody know for what SQLUB_NO_INTERRUPT and SQLUD_NI_INTERRUPT
are used? Can I ignore the warning? If not what can I do to solve
the problem?
Thanks for your answers
John
Kelly D. Rodger
RESTORE... WITHOUT PROMPTING command, and that restore would have
returned an SQL2539 warning (it's a yes/no type prompt from the DB2 CLP)
if you had allowed prompts. Those *_NO_INTERRUPT flags are how WITHOUT
PROMPTING is specified to the backup API.
When prompting is enabled the RESTORE utility would request your
permission to restore over an existing database since that is a
destructive operation to the existing database. See also the REPLACE
EXSTING option.
> db2 ? sql2539
SQL2539W Warning! Restoring to an existing database that is the
same as the backup image database. The database files
will be deleted.
Explanation:
The database aliases, names and seeds of the target database and
database image are the same, indicating these are the same
databases. The current database will be overwritten by the
backup version.
User Response:
Return to the utility with the callerac parameter indicating
processing to continue or end.
kdr
--
------------------------------------------------------------------
Kelly D. Rodger IBM Canada
DB2 UDB Backup and Recovery Toronto Lab
------------------------------------------------------------------