Cause: The input or output drive specified in the utility command does not exist.
The utility stops processing.
Action: Resubmit the utility command with the correct drive specifier.
Cause: The user may have pressed the interrupt key sequence, or had called the utility with a terminate caller action.
This message can also be returned by DB2 Extended Enterprise Edition during a backup or restore operation on a database node when the database catalog node is down.
The utility stops processing.
Action: Restart the application or reissue the command, if needed. The output data from the interrupted command may be incomplete, and should not be used.
Cause: The database utility command is only valid for local databases.
The utility stops processing.
Action: Run the utility locally.
Cause: An operating system error occurred. The return code can be found in the SQLERRD[0] field of the SQLCA.
The utility stops processing.
Action: Look at the error return code in the SQLERRD[0] field of the SQLCA. Correct the error, if possible, and resubmit the command.
Cause: The utility was using an SQL statement when an error occurred.
The utility stops processing.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: Incomplete data was read during an I/O operation.
The utility stops processing.
Action: Determine if the I/O error can be corrected and resubmit the command.
Cause: Incomplete data was written during an I/O operation.
The utility stops processing.
Action: Determine if the I/O error can be corrected and resubmit the command.
Cause: Either the callerac parameter value is not one of the acceptable values or the requested action is out of sequence.
The command cannot be processed.
Action: Each utility has its own list of valid callerac values. Check the API Reference for the valid values for the callerac for the utility in use. Resubmit the command with a valid callerac parameter.
Cause: More memory is needed to run the specified utility.
The command cannot be processed.
Action: Possible actions include:
Cause: The utility could not connect to 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 disconnect from 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 enable interrupt handling. The actual return code can be found in the SQLERRD[0] field of the SQLCA.
The utility stops processing.
Action: Look at the error return code in the SQLERRD[0] field of the SQLCA. Correct the error, if possible, and resubmit the command.
Cause: An error occurred while the utility was accessing the database directory.
The utility stops processing.
Action: If the path in the database parameter is not the database directory path, resubmit the command with the correct path. Otherwise, look at the error number in the message for more information. Make changes and resubmit the command.
Cause: The utility received an error from a database environment command. The database manager configuration file and the database configuration file may contain incompatible values.
The utility stops processing.
Action: Check the database manager configuration file and the database configuration file for inconsistent values. Resubmit the command.
Cause: The database name is required. It must contain 1 to 8 characters and the characters must be chosen from the database manager base character set. The name must be located at a valid address for the application.
The utility stops processing.
Action: Resubmit the command with a valid database name.
Cause: The utility could not find the required program using the operating system Select Path.
The utility stops processing.
Action: Update the PATH command to include the path to the indicated program name.
Cause: The BACKUP or RESTORE utility could not start the new session because:
The utility stops processing.
Action: Wait until some of the current sessions stop processing and resubmit the command. Or, see the SQLERRD[0] field in the SQLCA for more information and resubmit the command.
Cause: The user attempted to execute a utility and one of the following has occurred:
The utility stops processing.
Action: Look at the error number in the message for more information. Make changes and resubmit the command.
Cause: Because the current level of the utility being executed was not bound to the database, the system attempted to bind all utilities to the database and this binding process failed. Possible causes for the error include:
For the RESTORE utility, the database is restored, but at least one utility is not bound to the database. The other utilities stop processing.
Action: Complete all activities that may be competing for system resources and resubmit the utility command. If the error continues, perform one of the following actions:
Cause: All the utilities were rebound to the database because the utility was not bound to the database or the package of the utility that was bound to the database was not compatible with the installed version of the database manager, but there is still a timestamp conflict between the installed version of the database manager and the package so the utility and bind file are not compatible.
The utility stops processing.
Action: Reinstall the database manager or reapply any recent updates or do both. Resubmit the utility command.
Cause: The diskette to be used for Backup Database or for Restore Database is not in the drive or is not valid.
The command cannot be processed.
Action: Verify that the correct diskette is in the drive or insert a new diskette.
Cause: The read or write operation against the log control file failed.
The utility stops processing.
Action: Record the error return code value. Determine whether the I/O error can be corrected.
Cause: An I/O error occurred while accessing the specified file.
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 stops processing.
Action: Record the error return code. Determine whether the I/O error can be corrected.
Cause: An I/O error occurred while accessing a file on the specified media.
The utility stops processing.
Action: Record the error return code. Determine whether the I/O error can be corrected.
Cause: The internal disconnect command failed. The SQLCODE is returned in the message.
The utility stops processing.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: The internal connection failed. The SQLCODE is returned in the message. The database manager configuration file and the database configuration file may contain incompatible values.
The utility stops processing.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command. Check that the database manager configuration file values and the backup image's database configuration file values are compatible.
Cause: The utility could not enable the interrupt handler. The SQLCODE is returned in the message.
The utility stops processing.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: An error was returned from either the specified command file, or from the operating system.
Action: The user has either requested a "Backup changes only" of a database enabled for ROLLFORWARD recovery, or has requested a "Backup changes only" while requesting the use of the user exit.
Cause: The specified drive does not have enough space for creating an internal subdirectory and information file.
The utility stops processing.
Action: Free the indicated space on the specified drive and resubmit the command.
Cause: A database utility process either writes data to or reads data from the media on the specified device. The utility returns so that the user may mount the correct media for the operation.
The utility waits for a response to continue.
Action: Mount the media and return to the utility with the callerac parameter indicating if processing continues or ends.
Cause: The parameter is incorrectly specified. Either the value is out of range or is incorrect.
Action: Resubmit the command with a correct value for the parameter.
Cause: During the processing of a database utility, ADSM was called and encountered an error.
Action: Consult the ADSM documentation for a description of the error, take corrective actions and resubmit the command.
Cause: The application program used an address that is not valid for this parameter. Either the address points to an unallocated buffer or the character string in the buffer does not have a null terminator.
Action: Ensure that a valid address is used in the application program and the input string is null terminated.
Cause: The calling application invoked the utility with no interrupt mode. During the operation a warning condition was encountered.
Action: Resubmit the operation without specifying the no interrupt condition in the callerac parameter or take actions to prevent the warning and resubmit the operation.
Cause: The application calling the utility has supplied a source or target path that is not valid. The path or device specified may not exist or is incorrectly specified.
Action: Reissue the utility command with a path that represents a correct path or device.
Cause: A call to a database utility specified ADSM as the target or source of the backup. An attempt was made to load the ADSM client. Either the ADSM client is not available on the system or an error was encountered in the load procedure.
Action: Ensure that the system has ADSM available. Resubmit the command after ADSM is made available, or resubmit the command without utilizing ADSM.
Cause: A database system error was encountered during the processing of one of the utilities.
Action: Examine the error code in the message for more information. Take corrective action and resubmit the command.
Cause: The application calling the utility has terminated. The application side of the utility is in the same process as the calling application and terminates with the application. The agent side of the utility terminates as a result.
Action: Reissue the command after determining why the application terminated.
Cause: The application calling the Backup or Restore utility has supplied a database alias parameter that is not valid. The alias must be 1 to 8 bytes and the characters must be chosen from the database manager base character set.
Action: Reissue the Backup or Restore command with a valid database alias.
Cause: The application calling the utility has supplied a buffer size parameter that is not valid. The buffer size is used to determine the internal buffer size. The value is the number of 4K pages that are obtained for this buffer. The value must be specified as 0 or be between 16 and 16384 inclusive.
When running the backup or restore utility, if 0 is specified, the default buffer size defined in the database manager configuration is used.
If the target media is a diskette, the buffer size must be smaller than the diskette size.
Cause: The application calling the utility has encountered an I/O error while trying to read or write to the tape device. The utility returns so that the user may correctly mount and position the tape.
The message may contain additional information to help diagnose the problem.
The utility waits for a response to continue.
Action: Correctly mount and position the tape and return to the utility indicating if processing continues or ends.
The error, device and the additional information (if present) can be used to diagnose and correct the problem.
Cause: Unable to start up the child processes or threads required during the processing of a database utility. On UNIX-based systems, this may mean that the maxuproc value is too low. On OS/2-based systems, this may mean that the THREADS CONFIG.SYS value is too low. The problem may also be that there was insufficient memory to create the new process or thread. The utility stops processing.
Action: Ensure the system limit for number of processes or threads has not been reached (either increase the limit or reduce the number of processes or threads already running). Ensure that there is sufficient memory for the new process or thread. Resubmit the utility command.
Cause: An unexpected error or bad message was received on one of the message queues during the processing of a database utility. The following is a list of reason codes:
The utility stops processing.
Action: Ensure the number of message queues allowed is not reached. Reduce the number of message queues in use if necessary and resubmit the utility command.
Cause: A database utility process encountered error "<error>" returned by the operating system while writing to the media "<media>". The utility returns so that the user may attempt to fix the problem or cancel the operation.
The utility waits for a response to continue.
Action: Consult the problem determination documentation for your operating system and correct the "<error>" condition. Return to the utility with the correct caller action parameter to indicate if processing should continue or terminate.
Cause: An error occurred while accessing an object during the processing of a database utility. The following is a list of reason codes:
The utility stops processing.
Action: If a lock object operation failed, ensure the lock timeout limit in the database configuration is adequate and resubmit the utility command. You may also consider using the QUIESCE command to bring the database to a quiesced state to ensure access.
If the error was encountered during backup, take corrective action to recover the database and resubmit the utility command.
If the error was encountered during restore or load recovery, ensure the backup or copy image is correct and resubmit the utility command.
If the object is a table space and the error was encountered during a restore, the set table space container api may be used to modify the table space before resubmitting the utility command.
Cause: The backup or copy image in use is corrupted
The utility stops processing.
Action: Discard the image as it is not a valid image. Resubmit the utility command with a valid image.
Cause: A database utility was unable to access memory during processing.
The utility stops processing.
Action: Stop the database manager, then restart it and resubmit the utility command.
Cause: An invalid media type was encountered during the processing of a database utility.
The utility stops processing.
Action: Ensure the media used is among of the types supported by the utility. Resubmit the command with a valid media list.
Cause: The source or target media specified during the processing of a database utility is already open by another process. The utility does not allow shared access for the operation.
The utility stops processing.
Action: Ensure the media used is not in use currently. Resubmit the command with a valid media list.
Cause: An end-of-media warning was encountered during the processing of a database utility. This error can also occur if an invalid tape device block size was specified.
The utility is waiting for a response to continue.
Action: Correct the end-of-media condition and return to the utility with the correct caller action parameter to indicate if processing should continue or terminate.
The tape device block size (or blocking factor) used at restore time must be the same as that used during the backup. If a variable block size is used, then the buffer size used must be less than or equal to the maximum block size of the tape device.
Cause: An device full warning was encountered during the processing of a database utility.
The utility is waiting for a response to continue.
Action: Correct the device full condition and return to the utility with the correct caller action parameter to indicate if processing should continue or terminate.
Cause: An empty device was encountered during the processing of a database utility. The utility is waiting for a response to continue.
Action: Mount the media and return to the utility with the caller action parameter to indicate if processing should continue or terminate.
Cause: An attempt to access a device, file, ADSM or the vendor shared library is denied during the processing of a database utility. The utility stops processing.
Action: Ensure the device, file, ADSM or vendor shared library used by the utility allows the access requested and resubmit the utility command.
Cause: An unexpected error occurred while accessing a device, file, ADSM or the vendor shared library during the processing of a database utility. The following is a list of reason codes:
The utility stops processing.
Action: Ensure the device, file, ADSM or vendor shared library used by the utility is available and resubmit the utility command. If the command is still unsuccessful, contact your technical service representative.
Cause: The caller action specified is not allowed because there is only one device left connected to the database utility.
Action: Return to the utility with the correct caller action parameter to indicate if processing should continue or terminate.
Cause: The table space name specified is syntactically correct, but it does not exist in the database or cannot be used in an utility operation. If the utility in use is a backup operation, the table space may be disallowed because it is a temporary table space or is in an inconsistent state.
Action: Check the table space name and resubmit the utility command with the correct table space name.
Cause: An invalid image was encountered during the processing of a database utility. The utility was not able to locate a valid media header. The utility stops processing.
Action: Resubmit the command with correct backup or copy images.
Cause: An invalid image was encountered during the processing of a database utility. The image provided was from a different database alias. The utility stops processing.
Action: Resubmit the command with correct backup or copy images.
Cause: An invalid image was encountered during the processing of a database utility. The image provided was from a backup or copy with a different timestamp. The utility stops processing.
Action: Resubmit the command with correct backup or copy images.
Cause: An unexpected error occurred while accessing a vendor shared library during the processing of a database utility. The following is a list of reason codes:
The utility stops processing.
Action: Ensure the shared library provided is valid and resubmit the utility command or use another supported media.
Cause: An error was encountered while binding the shared library during the processing of a database utility. The utility stops processing.
Action: Note the reason code returned from the vendor utility in the message and take corrective action if possible. Resubmit the command with a valid shared library or using another supported media.
Cause: An unexpected error occurred while processing DATALINK values.
Action: Resubmit the command. If the problem still exists, resubmit the command after shutdown and restart of DB2 and the DATALINK File Managers.
The Restore utility can avoid DATALINK processing by specifying WITHOUT DATALINK.
Cause: An unexpected error occurred while processing DATALINK values.
Action: Resubmit the command. If the problem still exists, resubmit the command after shutdown and restart of DB2.
The Restore utility can avoid DATALINK processing by specifying WITHOUT DATALINK.
Cause: An unexpected error occurred while processing DATALINK values.
Action: Resubmit the command. If the problem still exists, resubmit the command after shutdown and restart of the DATALINK File Managers.
The Restore utility can avoid DATALINK processing by specifying WITHOUT DATALINK.