Cause: The RESTORE utility either could not read data from the restored database or only a portion of the database was restored. Both cases indicate that the restored database is not usable.
The database is unusable and the RESTORE utility stops processing.
Action: Resubmit the RESTORE command.
Cause: An operating system error occurred when the RESTORE utility was reading the diskette or disk, or the diskette or disk does not contain a backup of the database directory or does not contain the results of any previous backup.
The utility stops processing.
Action: If the input drive specified is a diskette drive, check the diskette being used. If the input drive is a hard file, verify that it is the correct hard file. Resubmit the command with the correct input drive and the correct diskettes, if applicable.
Cause: The name of the database contained on the backup disk does not match the database name specified on the RESTORE command. The RESTORE utility cannot determine the name until after the database has been restored because a previous release backup image was restored.
The utility stops processing.
Action: If the wrong database name was used in the command, resubmit the command with the correct database name. If the input drive specified is a diskette drive, check the diskette being used. If the input drive is a hard file, verify that it is the correct hard file. Resubmit the command with the correct input drive and the correct diskettes, if applicable.
Cause: The RESTORE utility reads the first backup diskette to determine the path of the database directory that was backed up. If the backup media is a diskette and the diskette is not found in the specified input drive, the utility returns to the caller with this prompt. The calling program is expected to query the user and return to the utility with the user response.
The utility waits for a response from the caller.
Action: Prompt the user for the diskette and return to the utility with the callerac parameter, indicating if processing continues or ends.
Cause: If the database being restored already exists, its files will be deleted before the restore process starts. The utility returns to the caller with this warning. The caller is expected to query the user and return to the utility with the user response. Once the database is dropped, it cannot be accessed again.
The utility waits for response from the caller.
Action: Warn the user that the database files will be deleted and return to the utility with the callerac parameter indicating if processing continues or ends.
Cause: If changes-only backups were performed and database files were deleted between backups, the RESTORE utility adds these deleted files back into the database. The restore process could not delete the extra files either because of an I/O error or by the failure of an internal connection to an internally stopped database.
The utility ends successfully.
Action: Either use the database as it is or attempt to restore it again. Ensure that the DB2 configuration is compatible with the restored database configuration before rerunning the RESTORE utility.
Cause: Because the RESTORE utility was not bound to the database or the package of the utility that was bound to the database is not compatible with the installed version of DB2, all the utilities have been rebound to the database. But there is a timestamp conflict between the installed version of DB2 and the package so the utility and bind file are not compatible.
The database is restored, but the utility is not correctly bound.
Action: Reinstall DB2 or reapply recent updates and resubmit the utility command.
Cause: The timestamp parameter must contain either NULL or a portion of a valid timestamp, the portion consisting of complete components of a timestamp.
Action: Resubmit the Restore operation with a valid timestamp value.
Cause: The drive specified does not exist, or the database does not exist on this drive or is not cataloged on this drive. RESTORE should use the db2uexit command to perform the database restore.
The utility stops processing.
Action: Resubmit the utility command with a valid drive.
Cause: An error occurred in the wait or post semaphore.
The utility stops processing.
Action: Stop the database manager, then restart it and resubmit the utility command.
Cause: The utility could not drop the database.
The utility stops processing.
Action: Look at the error number in the message for more information. Make changes and resubmit the command.
Cause: The utility could not create the database.
The utility stops processing.
Action: Look at the error number in the message for more information. Make changes and resubmit the command.
Cause: The utility could not rename the database.
The utility stops processing.
Action: Look at the error number in the message for more information. Make changes and resubmit the command.
Cause: The release number of the restored database is not compatible with the release number of the installed version of the database manager.
The utility erases the restored database and stops processing.
Action: Resubmit the command with a backup that is compatible with the release level of the database manager.
Cause: The user attempted to execute the RESTORE utility without SYSADM authority.
The utility stops processing.
Action: Do not attempt to call the RESTORE utility command without appropriate authorization.
Cause: In some situations, the RESTORE utility can attempt to move a database to a directory by renaming the directory associated with the database. This cannot be done if any databases are in use in any process on the workstation.
The utility stops processing.
Action: Wait until no databases on the workstation are in use and resubmit the command.
Cause: The database being restored was backed up using a previous release of DB2. The RESTORE utility migrated it to the format of the current release.
The user who submitted the RESTORE command is given DBADM authority for the database. If there are other users, the database administrator with DBADM authority must grant authorization privileges to the specific database users.
The RESTORE utility completes successfully.
Action: No action is required.
Cause: The database configuration file could not be restored due to an I/O error.
The utility stops processing.
Action: Determine whether the I/O error can be corrected. Resubmit the command.
Cause: The backup image contains a previous release of the database. After the database files were restored, an attempt was made to migrate the database to the current release. The migration failed.
The utility finishes processing but the database was not migrated.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and submit the Migrate command before using the database.
Cause: When a database is restored, the current database configuration file is not always replaced with the backup version. The current database configuration file was not usable. It has been replaced by the backup version.
The utility completed successfully.
Action: Some values in the database configuration file may be different after the restore process. Check that the configuration parameters are set to the desired values.
Cause: The restore process ran successfully. The .BRG file was not deleted due to an I/O error.
The .BRG file is used to determine whether a Restore operation has terminated abnormally. The .BRG file resides in the local database directory of the database in question and consists of a filename equivalent to the database token and filetype of .BRG.
The utility completed successfully.
Action: Try to delete the .BRG file. If you are unsuccessful, contact your technical service representative.
Cause: The backup image file filename consists of a database alias and a timestamp component. A filename is constructed from the source database alias and timestamp parameters provided in the Database Restore call. A portion of a timestamp may have been specified so that a match with more than one backup image filename was found.
Action: Resubmit the operation by specifying a timestamp with sufficient timestamp components to result in a match to a unique backup file.
Cause: The database alias and name of the target database are the same as the backup image database alias and name. The database seeds are not the same indicating that the databases are not the same. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted. The current configuration file will be overwritten with the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database seeds of the target database and the database image are the same, indicating these are the same databases, the database names are the same, but the database aliases are not the same. The target database will be overwritten by the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database aliases of the target database and database image are not the same, the database names are the same, and the database seeds are not the same, indicating these are different databases. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted. The current configuration file will be overwritten with the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database aliases of the target database and database image are the same, and the database seeds are the same, however the database names are different. These are the same databases. The target database will be overwritten by the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database aliases of the target database and database image are the same, the database names are not the same, and the database seeds are not the same, indicating these are different databases. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted. The current configuration file will be overwritten with the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database aliases of the target database and database image are not the same, the database names are not the same, and the database seeds are the same, indicating these are the same databases. The current database will be overwritten by the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The database aliases of the target and database image are not the same, the database names are not the same, and the database seeds are not the same, indicating these are different databases. The current database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted. The current configuration file will be overwritten with the backup version.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The backup image being restored is corrupted making the database image non-restorable.
Action: Discard the backup image as it is unusable. Restore from a previous backup if possible.
Cause: The file selected for restore is not a valid backup image. Either the file selected has become corrupted or a backup tape is not at the correct position.
Action: Determine the location of the correct backup image file, and resubmit the Restore command.
Cause: The file selected for restore does not contain the requested backup image. The image is for a different database than that requested.
Action: If using tape, ensure that the correct tape is mounted. If a restore or load is being done from disk, then the file must have been renamed. Rename the file to the correct filename with a match on database name and timestamp. Resubmit the command after taking the appropriate action.
Cause: The backup image read from the tape position contains a media header that does not match the header of the image of the first file of the backup file sequence.
Action: Ensure that the tape is positioned at the correct backup, then return to the utility with the callerac parameter indicating if processing continues.
Cause: The data read from the tape position does not contain a valid backup media header.
Action: Ensure that the tape is positioned at the correct position, then return to the utility with the callerac parameter indicating if processing continues.
Cause: The end of tape has been reached and there is still more data to be processed. The remainder of the backup or load source exists on another tape or on several more tapes.
Action: Mount the next tape in sequence that contains the source image and resubmit the Restore or Load command with the callerac parameter set to continue or end.
Cause: The tape is positioned on a backup image file that is out of sequence. The tape containing the backup image must be positioned to the file of sequence number "<sequence>" of the backup image.
Action: Position the tape containing the backup image to the correct file and resubmit the Restore command with the callerac parameter set to continue or end.
Cause: SQLUD_NOROLLFWD was specified for the rst_type parameter of the Database Restore utility, indicating that a roll-forward is not required to make the restored database usable. The database to be restored was backed up in online mode and a roll-forward operation is necessary to make the database usable.
Action: Resubmit the Database Restore command without specifying SQLUD_NOROLLFWD for the rst_type parameter.
Cause: While reading and restoring from the Backup Image file, an end of file condition was reached unexpectedly. The backup image is unusable and the restore operation terminates.
Action: Resubmit the Database Restore command with a usable backup image file.
Cause: 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.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: The Database Restore utility was invoked in No Interrupt mode, i.e. SQLUB_NO_INTERRUPT or SQLUD_NO_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.
Action: Ensure that the action that caused this warning to be generated has not resulted in a condition not wanted.
Cause: The utility was successful, but the file containing the backup image could not be closed.
Action: Attempt to close the file containing the backup image.
Cause: The backup image file filename consists of a database alias and a timestamp component. A filename is constructed from the source database alias and timestamp parameters provided in the Database Restore call. No filename existed in the source directory that matched based on the source database alias and timestamp provided.
Action: Ensure that the database backup image resides on the media source. Resubmit the operation by specifying a correct timestamp to result in a match.
Cause: The application calling the Restore utility has supplied a target directory for the new database to be created. Either this directory does not exist, or is not a valid directory for database creation. An invalid directory for database creation would be a directory of greater than 255 characters in length.
Action: Reissue the Backup or Restore command with a valid target directory.
Cause: While the database was being restored the directory to which it was being restored had become full. The database being restored is unusable. The Restore terminates and if the database being restored is a new database, then it is deleted.
Action: Free up sufficient space on the directory for the database, and reissue the Restore, or if restoring to a new database supply a directory with sufficient space to contain the database.
Cause: The backup image is not immediately accessible by the ADSM server. The restore process can continue and make the request to the server to retrieve the data. The time required is unknown.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: During restore or load recovery, the first image from the backup or copy must be processed first. The image found on the media is not the first in sequence.
The utility waits for a response to continue.
Action: Mount the media with the correct backup or copy image and return to the utility with the correct caller action parameter to indicate if processing should continue or terminate.
Cause: The physical log file formats have changed between these releases, making rollforward impossible.
Action: Restore the database using the version of DB2 used to create the database and rollforward to the end of logs. Take an off-line full database backup at this time. This new backup image will be restorable on the new release of DB2.
Cause: The database contained in the backup image contains data stored in a codepage different from that of the database into which the data is being restored.
This problem can be caused by one of the following situations:
Action:
Cause: The containers which were used by the table spaces in the backup image are not available, are already in use, or one or more table space names specified in the list on the restore command do not exist in the backup image.
Action: Use redirected restore to redefine the containers for the table spaces in this backup image, or specify a list of valid table space names to restore.
Cause: The backup image used for the restore is a backup of a database from a different node. You can only restore a backup to the same node.
Action: Ensure that you have the correct backup image for the node then issue the request again.
Cause: The catalog node can exist on only one node and there is a discrepancy between the backup image and the node being restored to. This can occur in the following cases:
Action: Verify that the correct backup image is being restored.
If you are restoring to an existing database and want to change the catalog node to "<node2>", the existing database must be dropped first.
If you are restoring to a new database, restore the catalog node "<node1>" first.
Cause: The length of the report file name exceeded the allowed limit of 255.
Action: Specify a report file name whose length is within the allowed limit and resubmit the restore command.
Cause: The utility completed successfully.
Action: No action necessary.
Cause: Possible Reason codes:
Action: Possible Solutions:
Cause: For a restore from a table space level backup, the target database must be either the original database from which the backup is taken or a new database.
Action: Specify the correct target database and resubmit the utility command.
Cause: For a restore from a table space level backup, the target database must have the same attributes (database name, alias and seed) as the source database. If the database does not already exist, it will be created.
Action: Return to the utility with the callerac parameter indicating processing to continue or end.
Cause: For a restore from a full database level backup, the restore type cannot be table space level.
Action: Specify a correct restore type or use a correct backup image and resubmit the utility command.
Cause: The restore process has completed successfully. One or more table spaces that are in the backup were not restored for one of the following reasons:
Action: If this message is not due to a subset restore, use the query table space function to check the states of the table spaces. If a table space is in the "storage definition pending" state, the storage definition for the table space must be corrected for restore to complete successfully. See the Administration Guide for details about recovering the table space.
Cause: The target table space pagesize must match that of the table space pagesize in the backup image. Restoring to a table space of a different pagesize is not supported. The default pagesize is 4K.
Action: Ensure that the table space being restored into has the same pagesize as the table space in the backup image.
Cause: The database contained in the backup image is an existing database and does not match the database to be restored. The option you have specified for restore requires that the database being restored to is new or the same as in the backup image.
The utility stops processing.
Action: Resubmit the command with the correct database name.
Cause: One or more table spaces have tables in DATALINK Reconcile Pending (DRP) or DATALINK Reconcile Not Possible (DRNP) because of one of the following reasons:
Action: Look in the db2diag.log file to find out what tables are put in DRP/DRNP state. See the Administration Guide for information on reconciling tables that are in DRP/DRNP state.