Each message has a message identifier that consists of a prefix (DBA) and the message number. Messages are listed in numeric sequence based upon the message number. These messages are generated by the Control Centre and the DBA Utility to alert you when a warning or error condition occurs.
DBA0001E An internal error occurred when allocating memory.
Cause: An internal error occurred when allocating memory. The application is terminated.
Action: Try closing some applications to release memory. If the problem persists, contact IBM Service.
DBA0002E An internal error occurred. Unexpected input was received from the request.
Cause: An unexpected input value was received from the request. The application is terminated.
Action: Contact IBM Service.
DBA0003E An inconsistency in the table definition was detected when processing the alter request.
Cause: When processing an alter table request, an inconsistency was detected between the last known table definition and the table definition fetched from the database. The table definition might have changed outside of the context of the administration tool. The table cannot be altered. The request is terminated.
Action: Select the "Refresh" action on the "Tables" pop-up menu to get an updated list of tables from the database. Try altering the table again.
DBA0004E An internal error occurred when validating a connection to a database.
Cause: An invalid connection was detected. A problem can occur if the server is brought down, the currently held connections are no longer valid, and a new connection cannot be obtained. The request is terminated.
Action: Ensure that the server is started. Select the "Connect" action in the pop-up menu of the database that you want to connect to. Try the action again.
If the action fails again, ensure that your network is operating for the target system and that the database is up and running on that system.
If the network is operational, a system internal error might have occurred. Contact IBM Service.
DBA0005E An internal error occurred when validating an attach to an instance.
Cause: An invalid connection was detected. The database might have stopped or the connection might no longer exist. The request is terminated.
Action: Ensure that the server is started. Select the "Connect" action in the pop-up menu of the database that you want to connect to. Try the action again.
If the action fails again, ensure that your network is operating for the target system and that the database is up and running on that system.
If the network is operational, a system internal error might have occurred. Contact IBM Service.
DBA0006E An internal error occurred when validating a handle for a persistent database connection or instance attach.
Cause: An invalid connection was detected. The database might have stopped or the connection might no longer exist. The request is terminated.
Action: Ensure that the server is started. Select the "Connect" action in the pop-up menu of the database that you want to connect to. Try the action again.
If the action fails again, ensure your network is operating for the target system and that the database is up and running on that system.
If the network is operational, a system internal error might have occurred. Contact IBM Service.
DBA0007E An internal error occurred when setting the context type for connections.
Cause: An error occurred when setting the context type for connections established by the application. The application is terminated.
Action: Contact IBM Service.
DBA0008E An internal error occurred. An unexpected list type was requested.
Cause: The type of object to be listed was not recognized as a valid type by the application. The application is terminated.
Action: Contact IBM Service.
DBA0009E An internal error occurred. An unexpected request type was received.
Cause: The type of request to be performed was not recognized as a valid type by the application. The application is terminated.
Action: Contact IBM Service.
DBA0010E An internal error occurred. An unexpected object type was detected.
Cause: The type of object to be processed was not recognized as a valid type by the application. The application is terminated.
Action: Contact IBM Service.
DBA0011E There are too many open connections.
Cause: The maximum number of open database connections was reached. The request is terminated.
Action: Either:
DBA0012E Unable to allocate a connection handle.
Cause: An error occurred when attempting to allocate a connection handle. The application is terminated.
Action: Contact IBM Service.
DBA0013W The maximum number of objects that can be listed was reached.
Cause: The maximum number of objects that can be listed by the application was reached. The maximum number is 20,000.
Action: None
DBA0014E An internal error occurred. An unexpected drop type was requested.
Cause: The type of object to be dropped was not recognized as a valid type by the application. The application is terminated.
Action: Contact IBM Service.
DBA0015E An internal error occurred. A latch request failed.
Cause: A latch request failed. The application is terminated.
Action: Contact IBM Service.
DBA0016E An internal error occurred. An unlatch request failed.
Cause: An unlatch request failed. The application is terminated.
Action: Contact IBM Service.
DBA0017E No error information is available. See the administration tools log.
Cause: No error information can be displayed.
Action: See the administration tools log for error information.
DBA0018E The Administration Server is not started. Start the Administration Server and try the action again.
Cause: The Administration Server is not started.
Action: Start the Administration Server using the DB2ADMIN START command on the target system and try the action again.
DBA0019E The object "<object_name>" or a related object is in use. Try the action again at a later time.
Cause: The object on which the action was requested or a related object is already being used in another action. Modifications to the object or a related object might be in progress.
The requested action cannot be performed at the same time as the current action.
Examples:
The action is not performed.
Action: Try the action again at a later time when the object is available.
DBA0020E An error occurred opening the administration tools trace file.
Cause: An error occurred opening the administration tools trace file.
Action: Contact IBM Service.
DBA0021E An error occurred writing to the administration tools trace file.
Cause: An error occurred writing to the administration tools trace file.
Action: Contact IBM Service.
DBA0022W An error occurred closing the administration tools trace file.
Cause: An error occurred when attempting to close the administration tools trace file. Processing continues.
Action: Ensure that the administration tools log file was specified correctly.
DBA0023W An error occurred opening the administration tools log file.
Cause: An error occurred when attempting to open the administration tools log file. Processing continues.
Action: Ensure that the administration tools log file was specified correctly.
DBA0024W An error occurred writing to the administration tools log file.
Cause: An error occurred when attempting to write to the administration tools log file. Processing continues.
Action: Ensure that the administration tools log file was specified correctly and can be written to.
DBA0025W An error occurred closing the administration tools log file.
Cause: An error occurred when attempting to close the administration tools log file. Processing continues.
Action: Ensure that the administration tools log file was specified correctly.
DBA0026E An internal administration tools error occurred.
Cause: An unrecoverable error occurred.
Action: Contact IBM Service.
DBA0027E An internal error occurred. Lock contention in the administration tools was detected.
Cause: Lock contention in the administration tools was detected.
Action: Contact IBM Service.
DBA0028I The current administration tools session will be terminated due to an unrecoverable error.
Cause: A severe internal error occurred.
Action: Contact IBM Service.
DBA0029 The application programming interface "<program>" did not complete successfully for object "<name>" with reason code "<name>". Try again or contact your local support.
Cause: An application programming interface call did not complete.
Action: Try the operation again or contact your system administrator.
DBA0030 An error occurred while attempting to connect to database "<name>".
Cause: The requested operation could not complete because it requires a connection to database "<name>". The connection was not successful.
Action: Make sure the database is accessible. Try explicitly connecting to the database using the connect action on the database pop-up menu. A common error on connection is an invalid userid and password. Make sure you have supplied the proper userid and password. Try the operation again or contact your system administrator.
DBA0031 An error occurred while attempting to attach to instance "<name>".
Cause: The requested operation could not complete because it requires an attachment to the instance "<name>". The attachment was not successful.
Action: Make sure the instance is accessible. Try explicitly connecting to the instance using the connect action on the instance pop-up menu. A common error on connection is an invalid userid and password. Make sure you have supplied the proper userid and password. Try the operation again or contact your system administrator.
DBA0032 An error occurred while attempting to load DLL "<name>".
Cause: Either the dynamic link library "<name>" was not found or an error occurred while reading the file.
Action: Verify that the DLL is installed and undamaged, and its location is part of the LIBPATH parameter in the CONFIG.SYS file.
DBA0033 "<name>" cannot be dropped because it is currently in use by the administration tools. Close some windows and retry the command.
Cause: Either the object "<name>" you selected to drop, or an item that is owned by the object you selected to drop, is still being used by another administration tool. For example, you might have and ALTER table window open for a database that you are trying to drop. In this case, you cannot drop the database until you close its ALTER table window.
Action: Close all the windows using the object you selected, or close all the windows using items owned by that object, and then retry the command.
DBA0034 "<name>" cannot be removed because it is currently in use by the administration tools. Close some windows and retry the command.
Cause: Either the object "<name>" you selected to remove, or an item that is owned by the object you selected to remove, is still being used by another administration tool. For example, you might have and ALTER table window open for a database that you are trying to remove. In this case, you cannot remove the database until you close its ALTER table window.
Action: Close all the windows using the object you selected, or close all the windows using items owned by that object, and then retry the command.
DBA0035 The "<operation>" operation cannot be performed because the object "<name>" you are issuing the operation against is not in the correct state for this operation. Close some windows and retry the command.
Cause: This operation "<operation>" requires "<name>" to be in a "<name>" state.
Action: Make sure all other pending operations on the selected object are complete, and then retry the command.
DBA0036 The database configuration was successfully updated. All applications must disconnect from database "<name>" before the changes take effect. If a backup has already been taken it is recommended to take another backup of the database in order to pick up the new configuration values.
Cause: The database configuration was successfully updated, but the active database configuration cannot be changed until all applications are disconnected from the database. Once all applications are disconnected, the changes will come into effect with the first connection to the database.
Action: Ensure that all applications are disconnected from the database, and then reconnect to the database.
DBA0037 The instance configuration was successfully updated. The instance "<name>" must be stopped before most changes take effect.
Cause: The instance configuration was successfully updated.
Changes to the configuration parameter "dftdbpath" take effect immediately.
For the remaining configuration parameters, the changes do not take effect until all applications have disconnected from the database, and the instance is successfully stopped and started again.
Action: To make all changes take effect, ensure that all applications have disconnected from the database, stop the instance, and then start it again.
You can stop the instance by selecting the stop action on the instance pop-up menu in the Control Center. You can then start the instance by selecting the start action on the instance pop-up menu in the Control Center.
DBA0039 There are currently database objects locked or database connections in use. Continue shutdown?
Cause: The database objects in the Control Center are locked when actions, such as Alter Table, are taken against them. Other actions will maintain connections to the database that are required to complete the task.
Action: If you choose to continue with the shutdown, then all locks and connections are forced and the tools will shut down. It can be dangerous to do so, however, because forcing some actions (like Restore Database) halfway through the task can leave the database in a corrupted state.
It is safest to first go back to the DB2 tools and make sure there are no database operations outstanding.
DBA0040 Shutting down will stop the Snapshot monitor. Continue shutdown?
Cause: Snapshot monitoring has been started on one or more database objects and to continue the monitoring, you must have the DB2 tools running.
Action: Choose to continue the shutdown only if you no longer require the Snapshot monitor.
DBA0100I Control Center is updating node directory information for instance - "<instance>". Incorrect information is being corrected. The current request cannot be performed.
Cause: The Control Center detected that the nodetype changed at the instance and is recataloging the instance based on the new information. Depending on the nodetype value for the instance, actions from the Control Center may be different.
Action: If available, try the request again.
DBA0101W Entries specified in the exception list will not be used. Do you want to continue?
Cause: The Nodes Contain Exceptions check box is deselected, but exception containers are specified in the List Exception dialog.
Action: Click on Yes to clear the exception containers list, or click on No or Cancel to reselect the Nodes Contain Exceptions check box.
DBA0102W Unable to detect nodetype for instance - "<instance>". Reason Code "<reason-code>".
Cause: Nodetype is a database manager configuration parameter that identifies whether the instance is a single-partition or partitioned environment.
Discovery tries to resolve the nodetype value for you. This distinction between instances is required because actions in the Control Center can be different between single-partition and partitioned environments.
If the reason code is -1, discovery could not map the catalogued instance to a valid DB2 instance.
All other reason codes map to a valid SQL message. Check the help for the corresponding SQL message.
Action: Discovery has the following requirements:
or
Verify the setting of these registry values by entering db2set -all.
DBA0103W Changes made to the configuration parameter values will not be used. Do you want to continue?
Cause: Another database partition was selected, but the changes to the configuration parameters apply to the previously selected database partition.
Action: Click on Yes to obtain the configuration parameter values for the next database partition and discard the changes that were specified for the previously selected database partition.
DBA0113E Exception containers are specified, but not all nodes in the nodegroup are included. No containers are specified for the following nodes: "node-list".
Cause: The specified exception containers have no common container. Because no common container is specified, the exception container must be defined at every node in the nodegroup.
Action: Click on OK to add containers to the specified nodes.
DBA0114W Control Centre detected incorrect node directory information for instance - "%1". Incorrect information is being corrected. Please exit and restart the Control Center. The current request cannot be performed.
Cause: The Control Center detected that the nodetype changed at the instance.
Action: Exit the Control Center and restart it.
DBA0115I Node directory information has been corrected for this instance. Instance "%1" should be refreshed.
Cause: Because the cataloged information for the instance is updated, the displayed objects and actions may not be correct.
Action: Select the "Refresh" action from the instance pop-up menu to update the Control Center, then try the request again.
DBA1100 Less than "<number>." MB of memory is dedicated to your server. No recommendation has been made. The current values on the Results Page match the suggested values.
Cause: Because the amount of memory dedicated to the server is so small, the Performance Configuration SmartGuide cannot make a recommendation.
The suggested values in the "Results Page" are the same as the current values.
Action: If you can dedicate more memory to the server, turn to the "Server Page", increase the amount of memory, and try again. Otherwise, click on Cancel to close the Performance Configuration SmartGuide.
DBA1102 An error occurred when the Performance Configuration SmartGuide tried to save the suggested values in a system file.
Cause: Either the Performance Configuration SmartGuide could not create a CFG subdirectory under your instance directory or it could not save a system file containing recommendations into the CFG subdirectory of your instance directory.
Action: Make sure the disk containing the instance directory is not full and you have write access to this disk. Afterwards, click on Done to try again.
DBA1104
The instance and database configuration parameters were
successfully updated. The instance "<name>" must be
stopped before most changes come into effect.
You may want to rebind your packages after the new
configuration parameters
take effect so that the new values will be used during the bind.
Cause: The Performance Configuration SmartGuide has updated the database manager configuration parameters, database configuration parameters, and buffer pool sizes in the SYSBUFFERPOOLS catalog.
The changes will not take effect until the instance is stopped on the server.
Packages were bound with the old configuration parameters. They need to be rebound, after the new parameters take effect, to exploit these new parameters.
Action: When you are ready to use the new configuration parameters, stop the instance, and then start the instance.
Rebind your packages if necessary.
DBA1107 An error occurred when the Performance Configuration SmartGuide tried to get system information from your server.
Cause: An unexpected error occurred. The Performance Configuration SmartGuide cannot continue.
Action: Contact your system administrator.
DBA1108 The Performance Configuration SmartGuide was unable to increase the sizes of the buffer pools due to other memory requirements determined from your responses. The buffer pool sizes are left unchanged. The use of the suggested set of configuration values may cause paging on the server.
Cause: This is a warning that there may not be enough memory dedicated to your server to run the workload that you specified.
Action: Review your selections on previous pages of the Performance Configuration SmartGuide to check that the workload description is appropriate or add more memory to your server.
DBA1109 The transactions rate you entered is more than ten times the average number of connected applications. If you are using a transaction manager, ignore this message. If not, consider changing the rate.
Cause: The Performance Configuration SmartGuide verifies that the transactions rate is reasonable. The transaction rate may be too high if you are not using a transaction manager.
Action: If you are using a transaction manager, ignore this message. Otherwise, use a lower number of transactions per minute, or increase the average number of connected applications.
DBA1110 The system database directory has no entries.
Cause: There are currently no entries found in this database directory.
Action: No action is required.
DBA1111 The database alias "<name>" already exists for another database.
Cause: You requested that a backup be recovered into a new database, but the database name you specified is already used as an alias for an existing database.
When a database is created, the database is cataloged in the system database directory using the database name as the alias, and this alias must be unique.
Action: Specify a database name that is not being used as an alias, or request that the backup be recovered into the existing database.
DBA1112 The database alias "<name>" was not found in the system database directory.
Cause: You requested that a backup be recovered into an existing database, but a database no longer exists with this alias.
Action: Select an existing database, or request that the backup be recovered into a new database.
DBA1113 Restart failed because indoubt transactions exist against the database and the connection to the database was dropped.
Cause: The restart operation encountered indoubt transactions. This left the database in an inconsistent state. The DBA Utility dropped the connection to the database.
Action: Resolve the indoubt transactions. If they are not resolved, applications must restart the database whenever it is required.
If you are in an XA/DTP environment, and the transaction manager that was using the database is available, instruct it to resolve the indoubt transactions.
Otherwise, use the Command Line Processor to manually complete each indoubt transaction.
DBA1114 Database "<name>" is now in backup pending state.
Cause: This state will prevent the database from being updated. The database must be backed up before any updates can happen.
Action: Back up the database.
DBA1115 Enter a value for "<name>".
Cause: A value is required.
Action: Provide the value and retry the request.
DBA1116 The value for "<parameter>" must be between "<minimum>" and "<maximum>".
Cause: The value must be within the specified range.
Action: Enter a value in the specified range and retry the request.
DBA1117 The value for "<name>" is not valid.
Cause: The value entered is not valid.
Action: Correct the value and retry the request.
DBA1118 The value for "<name>" must not exceed "<maximum>".
Cause: The value entered is not valid.
Action: Correct the value and retry the request.
DBA1119 The value for "<name>" must not be smaller than "<minimum>".
Cause: The value entered is not valid.
Action: Correct the value and retry the request.
DBA1121 A job was created for the request "<description>" on system "<system>". Its job number is "<number>". To view the status and output of the job, use the Jobs page on the Journal.
Cause: The job was successfully started.
Action: To view the status and output of the job, use the Jobs page on the Journal.
DBA1122 The job has completed for the request "<description>" on system "<system>". For the status and output of the job, view job "<number>" in the Jobs page on the Journal.
Cause: The job has completed.
Action: To view the status and output of the job, use the Jobs page on the Journal.
DBA1123 The job "<description>" has been canceled.
Cause: The job was canceled in response to a user request.
Action: No action is required.
DBA1126 The database has no table spaces.
Cause: The database has no table spaces.
Action: No action is required.
DBA1127 The table space has no containers.
Cause: The table space has no containers.
Action: No action is required.
DBA1128 No containers have been specified. Select "Add" in order to create containers.
Cause: The current list does not contain any new containers.
Action: Select "Add" and fill in the necessary fields to add a container to the list.
DBA1129 Enter a value for "<name>".
Cause: The operation you requested can be performed only if you enter a value for "<name>".
Action: Enter a value, and then click on OK.
DBA1130 The value for "<name>" must not exceed "<maximum>" characters.
Cause: You entered a value that exceeded the maximum number of characters.
Action: Enter a valid value, and then click on OK.
DBA1131 "<device>" is not a valid tape device.
Cause: The operating system did not accept the specified tape device. Local tape devices are of the form "\\.\TAPEn", where n represents the drive number (0 is the first).
Action: Enter a valid name for the tape device, and then click on OK.
DBA1132 Tape device "<device>" does not support a tape mark blocksize of "<blocksize>".
Cause: The Control center uses a tape mark blocksize that is not supported by the specified tape device.
Action: Use the Command Line Processor to submit the request. Specify a supported blocksize in the DB2 INITIALIZE TAPE command.
DBA1133 An error occurred operating tape device "<device>".
Cause: An unexpected error occurred while operating the specified tape device.
Action: Resubmit the request. If the problem persists, contact your system administrator.
DBA1134 A job was created for the request "<description>". However, no job-related entries can be created in the Journal because the database administrative server (DAS) instance could not be accessed.
Cause: The job started successfully, but the status and output of the job will not be logged in the Journal. This can happen if the DAS instance is not started.
Action: To have the status and output of the job logged in the Journal, start the DAS instance first before starting a backup operation.
DBA1135 The job has completed for the request "<description>".
Cause: The job has completed.
Action: No action is required.
DBA1136 A backup at the table space level cannot be performed because the database "<db>" is not enabled for forward recovery.
Cause: You can only back up a database at the table space level if you have first enabled that database for forward recovery.
Action: To enable the database for forward recovery, set the database configuration parameters LOGREATIN or USEREXIT to ON, disconnect all existing applications from the database, and perform an offline backup of the database.
DBA1137 The value for "<name>" must not be smaller than "<minimum>" "<units>".
Cause: The value entered is smaller than the minimum "<minimum>" "<units>".
Action: Enter a valid value and retry the request.
DBA1138 The value for "<name>" must not exceed "<maximum>" "<units>".
Cause: The value entered exceeded the maximum of "<maximum>" of "<units>".
Action: Enter a valid value and retry the request.
DBA1139 You must allocate at least "<pages>" for the system catalog.
Cause: There cannot be more than "<pages>" in each table space container. Each page of data requires 4 KB. So 1 MB of storage is equal to 256 of these 4 KB pages.
Action: Enter a valid value and retry the request.
DBA1140
You cannot allocate more than "<pages>" pages in a single
container.
There cannot be more than "<pages>" in a table space.
Cause: Each page of data requires 4 KB. So 1 MB of storage is equal to 256 of these 4 KB
pages.
Action: Enter a valid value and retry the request.
DBA1141 You must allocate a least "<pages>" pages in each container.
Cause: The minimum number of pages in a table space container is related to the extent size of the table space. It is 5 times the extent size plus one page. So for a table space with an extent size of 32 pages (the default value), the minimum size of a single container is 161 pages.
Action: Enter a valid value and retry the request.
DBA1142 The LOGARCHIVE database configuration parameter is currently set to ON for database "<name>". As soon as all applications have disconnected from the database, the database will be in backup pending state. This state prevents the database from being updated. The database must be backed up before any additional updates can occur.
Cause: Before the database manager can start logging each transaction in your database, it must have a full offline database backup to use as a starting point.
Action: Make a full offline database backup as soon as possible. If this is not possible, set the LOGARCHIVE parameter to OFF.
DBA1143 You cannot perform an offline backup right now because at least one application is still connected to the database. You can either try again later, or disconnect all applications connected to the database immediately by selecting force from the instance object's pop-up menu.
Cause: An offline backup cannot be performed until all applications connected to the selected database have stopped. You can either wait for the applications to disconnect themselves, or you can force the connected applications right now.
Action: Either try the action later, or, to force all applications connected to the selected database immediately, select "Force" from the instance object's pop-up menu.
DBA1144 The container you specified already exists on system you are working with.
Cause: Each table space container must be unique.
Action: Specify a file name or directory that does not currently exists on the system.
DBA1145 You have specified a container more than once.
Cause: Each table space container must be unique.
Action: Specify a file name or directory that is not currently in your list of new containers.
DBA1146 You have specified the same container in both the user and temporary table spaces.
Cause: Each table space container must be unique.
Action: Change the file name or directory of the container in either the user or temporary tablespace.
DBA1147 You have specified the same container in both the catalog and temporary table spaces.
Cause: Each table space container must be unique.
Action: Change the file name or directory of the container in either the catalog or temporary tablespace.
DBA1148 You have specified the same container in both the user and catalog table spaces.
Cause: Each table space container must be unique.
Action: Change the file name or directory of the container in either the user or catalog tablespace.
DBA1149 There is not enough free space for the containers you specified.
Cause: When a DMS container is created it consumes the full amount of space you allocated to it.
Action: Change the location of the container to an area that has more storage, or increase the available storage in the current location of the container.
DBA1150E A column with the same name already exists.
Cause: The column was not added because a column with the same name is already specified or exists in the table being created or altered.
Action: Specify a different column name.
DBA1151E The column participates in a primary key or foreign key.
Cause: The column was not removed because it participates in a primary key or foreign key.
Action: Ensure that the specified column is the correct column to remove. To remove the specified column in a table, modify the primary key or foreign key definitions so that the specified column is no longer referenced.
DBA1152E A constraint with the same name already exists.
Cause: The constraint was not added because a constraint with the same name is already specified or exists in the table being created or altered.
Action: Specify a different constraint name.
DBA1153E The object is already in the list.
Cause: The specified object already exists in the list. The action is not performed.
Action: Specify another object or close the window.
DBA1154E The specified system, instance, and database do not identify a recognized database.
Cause: The system, instance, and database specifications do not identify a database that is known to the application. The action is not performed.
Action: Either ensure that the system, instance, and database names are correct; or add the system, instance, and database that you want to access to the application.
DBA1155E The object "<object_name>" no longer exists in the database. The request cannot be performed.
Cause: The specified object no longer exists in the database and cannot be operated on. The request is terminated.
Action: Select the "Refresh" action in the pop-up menu of the object folder to get an updated list of objects.
DBA1156W The request completed with warnings. See the administration tools log for details.
Cause: The requested action completed, but one or more warning messages were issued.
Action: See the administration tools log for more information.
DBA1157I No authorities or privileges were granted or revoked on "<object_name>" for "<user_name>". See the administration log for details.
Cause: The requested action completed. No action was taken against the authorities or privileges on the specified object for the specified user or group.
Action: None
DBA1158I Number of records read during the load = "<count>". Number of records skipped before the load begins = "<count>". Number of rows loaded into the target table = "<count>". Number of records that could not be loaded = "<count>". Number of duplicate rows deleted = "<count>". Number of records loaded successfully and committed to the database = "<count>".
Cause: The action completed with the specified results.
Action: None
DBA1159I Export completed. "<item_description>" = "<count>"
Cause: The export action completed successfully with the specified results.
Action: None
DBA1160I Import completed. Number of records read during the import = "<count>". Number of records skipped before the import begins = "<count>". Number of rows imported into the target table = "<count>". Number of records that could not be imported = "<count>". Number of duplicate rows deleted = "<count>". Number of records imported successfully and committed to the database = "<count>".
Cause: The import action completed successfully with the specified results.
Action: None
DBA1161I "<item_description>" = "<count>"
Cause: The import or export completed with the specified results.
Action: None
DBA1162I Load completed. Number of records read during the load = "<count>". Number of records skipped before the load begins = "<count>". Number of rows loaded into the target table = "<count>". Number of records that could not be loaded = "<count>". Number of duplicate rows deleted = "<count>". Number of records loaded successfully and committed to the database = "<count>".
Cause: The load action completed successfully with the specified results.
Action: None
DBA1163E The table was not copied. See the administration tools log for details.
Cause: One or more warnings or errors occurred when copying the table. The table was not copied.
Action: See the administration tools log for more information.
DBA1164E The specified target table already exists. The source table was not copied.
Cause: The copy table action failed because the target table exists.
Action: Either specify a new target table or delete the existing target table and try the action again.
DBA1165E No privileges were granted or revoked for "<user_name>". See the administration tools log for details.
Cause: Privileges were not granted or revoked for the specified user or group.
Action: See the administration tools log for more information.
DBA1166E The identifier "<identifier_name>" contains unbalanced quotes. Correct the identifier and try the action again.
Cause: The specified identifier contains unbalanced single or double quotes. The naming rules require balanced quotes. The action is not performed.
Action: Correct the identifier and try the action again.
DBA1167E The identifier "<identifier_name>" contains embedded blanks. Correct the identifier and try the action again.
Cause: The specified identifier contains blank characters, which violates the naming rules for ordinary identifiers. The action is not performed.
Action: Remove the blanks or delimit the identifier with double quotes and try the action again.
DBA1168E The first character in the identifier "<identifier_name>" is invalid. Correct the identifier and try the action again.
Cause: The first character of the specified identifier is invalid. It must follow the naming rules for ordinary identifiers. The action is not performed.
Action: Replace the first character with a valid one or delimit the identifier with double quotes then try the action again.
DBA1169 The command script that can update the instance and database configuration parameters was created successfully. Use the Script Center to run or schedule the script.
Cause: A new script was saved successfully in the Script Center. You may open the Script Center to view, run or schedule the new command script.
After the script is run, the changes will not take effect until the instance is stopped on the server.
Packages were bound with the old configuration parameters. They need to be rebound, after the new parameters take effect, to exploit these new parameters.
Action: To view, run or schedule the newly saved script, open the Script Center by selecting the Script Center icon from the icon bar.
After you have run the script and when you are ready to use the new configuration parameters, stop the instance, and then start the instance.
Rebind your packages if necessary.
DBA1500 The local system object is not allowed to be removed.
Cause: The local system object appears in the tree if this is a server installation, and does not appear if this is a client installation. You have no direct control over the removal of this object because it has special properties that are required by the server installation type.
Action: No action is required.
DBA1501 The local system object is not allowed to be changed.
Cause: The local system object appears in the tree if this is a server installation, and does not appear if this is a client installation. You have no direct control over the changing of this object because it has special properties that are required by the server installation type.
Action: No action is required.
DBA1502 The unknown system object is not allowed to be removed.
Cause: The unknown system object appears in the tree only if orphaned instances that are not recognized as belonging to any existing system are found. You have no direct control over the removal of this object because it is shown automatically only when needed.
Action: No action is required. However, if you want to remove the need to show this object in the tree, then do the following steps:
DBA1503 The unknown system object is not allowed to be changed.
Cause: The unknown system object appears in the tree only if orphaned instances that are not recognized as belonging to any existing system are found. You have no direct control over the changing of this object because it is shown automatically only when needed and has only special properties that cannot be changed.
Action: No action is required.
DBA1510 Specify a system name.
Cause: You must specify a system name before you can add this new system object.
Action: Specify a system name in the appropriate entry field, and then try the action again.
DBA1511 The specified system name is already in use.
Cause: You specified a system name that matches the name used for another system object in the tree. System names must be unique within the control center, and are case-sensitive. You cannot use the names 'Local' or 'Unknown' because these are system names reserved for use by the local and unknown system objects. To avoid confusion, you should also try not to use the names of existing instances or databases as system names, although the tool does not prevent you from doing this.
Action: Specify a unique system name, and then try the action again.
DBA1520 The operating system type for this system object has been detected to be "<newos>", but the local information shows it to be "<oldos>". Do you want to update the local information now to reflect the correct operating system type?
Cause: When you add a new system object, you specify an operating system type, which is stored locally for that remote system. Later, when actual connections are made to the remote system, the true operating system type is reported back. It is possible for the original operating system type information to have been set incorrectly so that it does not match the true settings on the remote system. In this case, it is best to update the local information to match what settings truly exist on the remote system.
Action: Select Yes to update the local information now, or select No to leave the local information as it is.
DBA1521 The server version type for this system object has been detected to be "<newtyp>", but the local information shows it to be "<oldtyp>". Do you want to update the local information now to reflect the correct server version type?
Cause: When you add a new system object, the server version type is automatically set to be either DB2 V5 or DRDA, depending on the operating system type you choose. Later, when actual connections are made to the remote system, the true server version type, which may be a previous release such as DB2 V2, is reported back. In this case, it is best to update the local information to match what settings truly exist on the remote system.
Action: Select Yes to update the local information now, or select No to leave the local information as it is.
DBA1522 The operating system type and server version type for this system object have been detected to be "<newos>" and "<newtyp>" respectively, but the local information shows these to be "<oldos>" and "<oldtyp>" respectively. Do you want to update the local information now to reflect the correct settings for these values?
Cause: When you add a new system object, you specify an operating system type, which is stored locally for that remote system. Also, the server version type is automatically set to be either DB2 V5 or DRDA, depending on the operating system type you choose. Later, when actual connections are made to the remote system, the true operating system type and server version type are reported back. The original settings for this information may have been incorrect so that they do not match the true settings on the remote system. In this case, it is best to update the local information to match what settings truly exist on the remote system.
Action: Select Yes to update the local information now, or select No to leave the local information as it is.
DBA1540 The active local instance object is not allowed to be removed.
Cause: The active local instance object appears in the tree always as the first instance under the local system object. This is a special instance object used to represent the current DB2INSTANCE environment variable setting. You have no direct control over the removal of this object because it has special properties that are required by the local system.
Action: No action is required.
DBA1541 The active local instance object is not allowed to be changed.
Cause: The active local instance object appears in the tree always as the first instance under the local system object. This is a special instance object used to represent the current DB2INSTANCE environment variable setting. You have no direct control over the changing of this object because it has special properties that are required by the local system.
Action: No action is required.
DBA1542 New instance objects are not allowed to be added to the unknown system.
Cause: The unknown system object appears in the tree only if orphaned instances that are not recognized as belonging to any existing system are found. The tool tries to prevent you from creating new orphans whenever possible, so you are not allowed to add new ones to the unknown system.
Action: No action is required.
DBA1550 Specify an instance name.
Cause: You must specify an instance name before you can add this new instance object.
Action: Specify an instance name in the appropriate entry field, and then try the action again.
DBA1551 The specified instance name is already in use.
Cause: You specified an instance name that either matches the name used for another instance object in the tree, or is being used by a system object in the tree. Instance names must be unique within the control center, and are always capitalized. System objects also use an automatically generated instance name to store their own protocol information, with the instance name usually being a short form of the chosen system name. You cannot use the name 'LOCAL' or the current DB2INSTANCE environment variable setting for the instance name.
Action: Specify a different instance name, and then try the action again.
DBA1552 Specify a remote instance.
Cause: You must specify a remote instance before you can add this new instance object.
Action: Specify a remote instance in the appropriate entry field, and then try the action again.
DBA1560 Specify a destination name.
Cause: You must specify a destination name for the selected protocol before you can correctly add this new object.
Action: Specify a destination name in the appropriate entry field, and then try the action again.
DBA1561 Specify a file server.
Cause: You must specify a file server for the selected protocol before you can correctly add this new object.
Action: Specify a file server in the appropriate entry field, and then try the action again.
DBA1562 Specify a workstation name.
Cause: You must specify a workstation name for the selected protocol before you can correctly add this new object.
Action: Specify a workstation name in the appropriate entry field, and then try the action again.
DBA1563 Specify a host name.
Cause: You must specify a host name for the selected protocol before you can correctly add this new object.
Action: Specify a host name in the appropriate entry field, and then try the action again.
DBA1564 Specify a service name.
Cause: You must specify a service name for the selected protocol before you can correctly add this new object.
Action: Specify a service name in the appropriate entry field, and then try the action again.
DBA1565 Specify a computer name.
Cause: You must specify a computer name for the selected protocol before you can correctly add this new object.
Action: Specify a computer name in the appropriate entry field, and then try the action again.
DBA1566 Specify an instance name.
Cause: You must specify an instance name for the selected protocol before you can correctly add this new object.
Action: Specify an instance name in the appropriate entry field, and then try the action again.
DBA1580 New database objects are not allowed to be added to the unknown instance.
Cause: The unknown instance object appears in the tree only if orphaned databases that are not recognized as belonging to any existing instance are found. The tool tries to prevent you from creating new orphans whenever possible, so you are not allowed to add new ones to the unknown instance.
Action: No action is required.
DBA1581 Specify a database name.
Cause: You must specify a database name before you can add this new database object.
Action: Specify a database name in the appropriate entry field, and then try the action again.
DBA1582 Specify an alias.
Cause: You must specify an alias before you can add this new database object.
Action: Specify an alias in the appropriate entry field, and then try the action again.
DBA1583 The specified alias is already in use.
Cause: You specified an alias that matches the alias used for another database object in the tree. Database aliases must be unique within the control center, and are always capitalized.
Action: Specify a unique alias, and then try the action again.
DBA1590 The "<dbase>" database was created using an earlier version of DB2 than DB2 V5. Only limited function will be allowed for this database until it is migrated.
Cause: All databases that are found under DB2 V5 type system ojects are first assumed to be DB2 V5 databases. This database has now been detected to actually be a back-level database that has not yet been migrated to the DB2 V5 level. You can still access this database, but only limited function is available for back-level databases until you actually migrate them.
Action: No action is required.
DBA2000E You have not specified a job description.
Cause: A description for the job is required information.
Action: Enter a job description in the entry field, and then click on OK.
DBA2001E You have not specified the number of hours for your selection.
Cause: The number of hours for your selection is required information.
Action: Enter a number in the hours entry field.
DBA2002E You must select at least 1 day of the week for your selection.
Cause: To schedule a recurring job, you must specify at least one day of the week for the job.
Action: Select at least one day of the week when scheduling a recurring job.
DBA2003E You specified a date that is not valid.
Cause: The date you specified is not valid. Perhaps the date you have specified is in the past.
Action: Enter a valid date.
DBA2004E You specified a date or time or combination of date and time that is not valid.
Cause: The next execution date and time cannot be calculated, so no jobs can be scheduled. One possible error is when the time specified for a job to be run once is in the past. Remember that the date and time combination must be valid on the managed host where the schedule job is to be run.
Action: Enter a valid date and time combination.
DBA2005E You have not specified a script name.
Cause: A name for the script is required information.
Action: Enter a name for the script file, and then click on OK.
DBA2006E You have not specified a comment.
Cause: You indicated that you want to record a comment when the job is completed, but the comment entry field is empty.
Action: Enter a comment, or clear the 'Record a comment' check box.
DBA2007E You specified a script name that is not valid.
Cause: The command script is saved as a file in the file system. The script path is at most 255 bytes long. The file name part of the script name can be at most 8 bytes long. If an extension is specified, it cannot be longer than 3 bytes. The script name must not contain any blanks. For example, valid script names can be: j:\script\new.cmd c:\data\test\crtdb.bat
Action: Enter a valid script name, and then click on OK.
DBA2008I Job "<job id>" was created successfully.
Cause: A new job was scheduled successfully. You may turn to the journal job summary to view the newly created job.
Action: To view the newly created job, turn to the journal job summary by selecting the Journal icon from the icon bar.
DBA2009E A system error occurred. A Scheduler InfoBase call was unsuccessful. RC = "<return code>" Restart the Admin. Server, and then retry the command..
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2010E The Scheduler service is not up and running. Restart the Admin. Server, and then retry the command.
Cause: To perform any action involving the Job Scheduler or the Script Center, the Scheduler service must be up and running.
Action: Restart the Admin. Server, and then retry the command.
DBA2011E A system error occurred. Scheduling type (DBA or PGM) is not valid. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2012E A system error occurred. OS error was detected. RC = "<return code>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2013E The job id key was not found. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2014E A system error occurred. Unable to change the status of the job. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2015E A system error occurred. Memory allocation was unsuccessful in client. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2016E A system error occurred. Scan handle is not valid. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2017I Are you sure you want to remove the selected jobs?
Cause: You specified to remove the selected jobs. You have the chance now to double-check the jobs that you selected to remove, and either to continue or to cancel the request.
Action: Select YES to remove the selected jobs. Select NO to cancel the remove request.
DBA2018I Are you sure you want to remove the selected saved scripts?
Cause: You specified to remove the selected scripts that are currently saved. You have the chance now to double-check the scripts that you selected to remove, and either to continue or to cancel the request.
Action: Select YES to remove the selected scripts. Select NO to cancel the remove request.
DBA2019E You have not specified the number of days for your selection.
Cause: The number of days for your selection is required information.
Action: Enter a number in the days entry field.
DBA2020E A system error occurred. Unable to determine script type. Command script was not executed.
Cause:
Action:
DBA2021I Are you sure you want to discard your changes?
Cause: You specified to have your changes not saved in the Script Center. You have the chance now either to continue discarding your changes, or to cancel the request and resume editing.
Action: Select YES to discard the changes. Select NO to resume editing the command script.
DBA2022I Command script "<script id>" was created successfully.
Cause: A new script was saved successfully in the Script Center. You may turn to the Script Center to view the new command script.
Action: To view the newly saved script, turn to the Script Center by selecting the Script Center icon from the icon bar.
DBA2023E Instance "<instance name>" does not exist. Command script was not executed.
Cause: The instance name associated with the script file does not exist.
Action: You may select "Edit" from the Script Center to update the instance name to an existing instance.
DBA2024E Command script "<script id>" does not exist.
Cause: The scheduled job cannot be executed because the script file associated with the job does not exist.
Action:
DBA2025E A system error occurred. This problem may also be related to memory allocation on the client. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2026I Are you sure you want to remove the selected job?
Cause: You specified to remove the selected job. You have the chance now to double-check the job that you selected to remove, and either to continue or to cancel the request.
Action: Select YES to remove the selected job. Select NO to cancel the remove request.
DBA2027I Are you sure you want to remove the selected saved script?
Cause: You specified to remove the selected script that is currently saved. You have the chance now to double-check the script that you selected to remove, and either to continue or to cancel the request.
Action: Select YES to remove the selected script. Select NO to cancel the remove request.
DBA2028E You have not specified the number of weeks for your selection.
Cause: The number of weeks for your selection is required information.
Action: Enter a number in the weeks entry field.
DBA2029E A system error occurred. Scheduler key was not found. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2030E You did not specify a system name. Select one from the list.
Cause: The system name is required information to process the action.
Action: Select a system name from the drop-down list.
DBA2031I Job "<job id>" was rescheduled successfully.
Cause: A job that you requested to be rescheduled was rescheduled successfully.
Action:
DBA2032E You have not specified a script name.
Cause: A name for the script is required information.
Action: Enter the script name in the entry field, and then click on OK.
DBA2033E You have not entered the command script.
Cause: The command script is empty.
Action: Enter the command script content, and then click on OK.
DBA2034I Command script "<script id>" was updated successfully.
Cause:
Action:
DBA2035E A system error occurred. Unable to retrieve the command script "<script id>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2036E A system error occurred. Unable to create the command script. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2037E A system error occurred. Unable to replace the command script "<script id>" Restart the Admin. Server, and then retry the command..
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2038E A system error occurred. Unable to copy the command script "<script id>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2039E You have not specified the number of months for your selection.
Cause: The number of months for your selection is required information.
Action: Enter a number in the months entry field.
DBA2040E You must select at least 1 day of the month for your selection.
Cause: To schedule a recurring job, you must specify at least one date per month for the job.
Action: Select at least one date per month when scheduling a recurring job.
DBA2041E A system error occurred. Unable to remove the command script "<script id>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2042E A system error occurred. Unable to run the command script "<script id>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2043I Job "<job id>" was created successfully for running command script "<script id>".
Cause:
Action:
DBA2044E You have not specified a script description.
Cause: A description for the script file is required information.
Action: Enter a description for the script file, and then click on OK.
DBA2045E Command script associated with job "<job id>" is system-generated. Content cannot be shown.
Cause: The script associated with a backup or reorganize table action is not in readable format.
Action: Select a different command script (file?) to view the content of.
DBA2046E Command script "<script id>" is system-generated. Content cannot be edited.
Cause: The script associated with a backup or reorganize table action is not in readable format.
Action: Select a different command script file to edit.
DBA2047E A system error occurred. The script type is unknown. Restart the Admin. Server., and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2048E The file name you specified already exists. Specify a different script file name.
Cause: The name of each script file must be unique. You specified a file name that already exists.
Action: Specify an unique script file name.
DBA2049E A system error occurred. File access was denied.
Cause: The application was unable to access the file in the file system.
Action: Retry the command. If the problem persists, contact your system administrator.
DBA2050E A system error occurred. The disk is full.
Cause: There is no more room on the disk. Processing cannot continue.
Action: Delete unwanted files from the file system. If the problem persists, contact your system administrator.
DBA2051E A system error occurred. A hard disk error occurred.
Cause: An internal error relating to the hard disk occurred. The application was unable to access a file.
Action: Retry the command. If the problem persists, contact your system administrator.
DBA2052E Unable to execute the job due to logon failure. Userid = "<user id>".
Cause: The password was invalid for the given userid or the userid is invalid.
Action: Enter a valid userid and password when prompted.
DBA2053E A system error occurred. Unable to remove job history entry.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2054E A system error occurred. Unable to run job "<job id>".
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2055E Command script "<script id>" has been removed from the Script Center.
Cause:
Action:
DBA2056I Command script "<script id>" was not changed.
Cause:
Action:
DBA2057E A system error has occurred. The path was not valid.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2058E A line in the file is greater than "<number>" bytes.
Cause: The maximum number of bytes in a line is exceeded.
Action: Rewrite the long line into separate lines without exceeding the limit.
DBA2059E A system error occurred. There was a sharing violation.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2060E A system error occurred. Unable to copy script "<script id>".
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2061I Script "<script name>" was created successfully.
Cause: A new script file with the name "<script name>" was created successfully.
Action: To view the newly created script, turn to the Script Center by selecting the Script Center icon from the icon bar.
DBA2062E A system error occurred. Unable to create a new script. Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2063E A system error occurred. Unable to retrieve the results of job "<job id>". Restart the Admin. Server, and then retry the command.
Cause: An internal error occurred.
Action: Restart the Admin. Server, and then retry the command. If the problem persists, contact your system administrator.
DBA2064E A Script Center record already exists for this script file name. Specify a different script file name.
Cause: The name of each script file must be unique within the Script Center. You specified a file name that already exists.
Action: Specify an unique script file name.
DBA2065E A system error occurred. The script file does not exist in the file system.
Cause: The script file was not found in the file system. The file may have been erased.
Action: Remove the script entry and recreate it.
DBA2066E The db2job executable is not in the expected directory. Unable to run the script.
Cause: db2job executable should be copied to sqllib bin as part of the installation.
Action: Contact your system administrator.
DBA2067I The REORG TABLE command completed successfully.
Cause:
Action:
DBA2068E You have not entered the instance name.
Cause: The name of the instance is required information.
Action: Enter the instance name in the entry field, and then click on OK.
DBA2069W The maximum number of "<number>" jobs has been created. Please remove obsolete jobs.
Cause:
Action: Remove jobs that are no longer needed before creating another new job.
DBA2070W The maximum number of "<number>" scripts has been created. Please remove obsolete scripts.
Cause:
Action: Remove scripts that are no longer needed before creating another new script.
DBA2071W The maximum number of "<number>" bytes has been reached. Data shown is truncated. The complete file "<file name>" can be found at the server.
Cause: The editor cannot handle a file as large as the current one. Data shown had to be truncated.
Action: The entire file can be viewed at the server in the indicated location.
DBA2072E The script associated with job "<job id>" has been removed from the Script Center.
Cause: The script file does not exist anymore.
Action:
DBA2073E You have not specified a userid and password.
Cause: A userid and password for running the job are required.
Action: Enter a valid userid and password for running the job, and then click on OK.
DBA2074E A system error has occurred. The working directory path was not valid.
Cause: The specified working directory does not exist so it cannot be used to run the script.
Action: Use the Browse... button to select a valid working directory path.
DBA2075I Job "<job id>" has been submitted. Use the Jobs page on the Journal to view the results.
Cause:
Action:
DBA2076E The job terminated abnormally.
Cause:
Action:
DBA2077E File name "<file name>" already exists in the file system.
Cause: File name must be unique.
Action: Specify another file name.
DBA2078E An unexpected error occurred. There is no job output.
Cause: There is no job output from running the job.
Action: A possible error could be an invalid file extention is used on the operating system. Recreate the script with a valid extention.
DBA2151E The script cannot be scheduled because it was not saved.
Cause: The script cannot be scheduled because you canceled the save action and therefore, the script was not saved in the Script Center.
Action: Save the script and then try scheduling again.
DBA2152I The script has to be saved to the Script Center before it can be scheduled.
Cause: Only scripts that are saved in the Script Center can be scheduled and run.
Action: Select OK to save the script to the Script Center, or Cancel if you do not want to schedule the script.
DBA2153I File "<file name>" was opened successfully.
Cause:
Action:
DBA2154I Script "<script name>" was opened successfully.
Cause:
Action:
DBA2155I Do you want to overwrite file "<file name>"?
Cause: The file "<file name>" currently exists in the file system and the save operation will overwrite its contents.
Action: Select OK if you want to overwrite the contents of the file, or Cancel if you do not want to alter its contents.
DBA2156I Do you want to overwrite script "<script name>"?
Cause: The script "<script name>" currently exists in the Script Center and the save operation will overwrite its contents.
Action: Select OK if you want to overwrite the contents of the script, or Cancel if you do not want to alter its contents.
DBA2157I File "<file name>" was updated successfully.
Cause:
Action:
DBA2158I File "<file name>" was created successfully.
Cause: A new file with the name "<file name>" was created successfully in the file system.
Action:
DBA2171I Do you want to discard all your changes to the script, and exit from the Command Center?
Cause: You specified to exit from the Command Center, but the changes to the current script have not yet been saved. Your changes will be lost unless you cancel your exit request.
Action: Select Yes to discard your changes and exit from the Command Center, or select No to cancel the exit request.
DBA2172I Do you want to discard your changes to the current script, and create a new script?
Action: Select Yes to discard your changes and to create a new script, or select No to cancel the request.
DBA2173I The Command Center is still processing a command. Try again later.
Cause: You tried to run a script or issue a set of commands, but the Command Center cannot process your command until it has finished processing the current one.
Action: Please wait a few moments and try the command again. To stop the current command, click on the turning gears icon on the tool bar or select "Terminate" from the Results menu on the Results page.
DBA2174E The file "<file name>" specified on the command line could not be opened. Make sure that the file exists and that you have read access to the file, and then try again.
Cause: You specified the name of a file containing a script that you want to import, but the Command Center could not access that file.
Action: Make sure that you have entered the file name correctly on the command line, that the file exists, and that your user ID has read access to that file.
DBA2175E There is not enough memory to create the Command Center window. The application cannot continue.
Cause: The system encountered a memory allocation problem when trying to create the Command Center window.
Action: Make sure there is enough memory on your system to run the Command Center, and then try again.
DBA2176E The system environment did not initialize. The application cannot continue. Restart the database manager and try again, or contact your local support personnel.
Cause: The command processor environment did not initialize properly.
Action: Make sure you have enough disk space and then try again.
DBA2177E The system could not create an access plan because a problem relating to Visual Explain has occurred.
Cause: Command Center has encountered a problem when trying to create an access plan.
Action: Please refer to the help from the previous messages.
DBA2178E You need a database connection in order to create an access plan. Use the "Connect" statement to connect to a database, and then try the command again.
Action: Establish a database connection first using the "Connect" statement, and then create an access plan for that database. To see a list of available databases, issue the command "list database directory".
DBA2179E An access plan cannot be created because the statement you used is not in the correct format or is not a query.
Cause: The statement you used to try to create an access plan is either not in the correct format for a query or is not a query.
Action: Check your statement for errors in query format, make necessary changes, and retry the statement. Refer to Visual Explain documentation for guidance on forming valid queries.
DBA2180I The program name "db2" before the statement will be ignored because it is not required.
Cause: You don't need to type "db2" before a statement in the Command Center. It is only required at the operating system command prompt.
Action: No action is required.
DBA3007 Are you sure you want to delete the explained statement?
Cause: You are about to delete the explained statement. This will delete the rows in the explain tables.
Action: Ensure that you want to delete the explained statement.
DBA3008 Are you sure you want to delete the explained statements?
Cause: You are about to delete the explained statements. This will delete the rows in the explain tables.
Action: Ensure that you want to delete the explained statements.
DBA3009 A system error occurred. The Visual Explain tool could not continue processing.
Cause: An unexpected error occurred causing the operation to stop.
Action: Possible solutions include:
If the problem persists, contact your system administrator.
DBA3010 The explain snapshot has been deleted. Your request cannot be completed.
Cause: The explain snapshot that is requested has been deleted from the explain tables.
Action: Regenerate the snapshot.
DBA3011 This explain snapshot was created using a different version of the database manager from the Visual Explain Tool. Your request cannot be completed.
Cause: The explain snapshot was created using a newer version or an older version of the database manager from the Visual Explain Tool. The access plan graph cannot be constructed by the Tool.
Action: Use the same version of the database manager as the Visual Explain Tool to graph the explain snapshot.
DBA3012 String not found.
Cause: The search string is not found in the text being displayed.
Action: None.
DBA3013 Text is missing. You must specify the text string to be found.
Cause: You did not specify a search string.
Action: Specify a search string.
DBA3014 No selection is made in the list. You must select at least one entry in the list.
Cause: You did not make a selection in the list.
Action: Select at least one entry in the list.
DBA3015 There are no referenced columns associated with this access plan.
Cause: There were no columns referenced in the query for the referenced table.
Action: None.
DBA3016 There are no page fetch pairs statistics associated with this index.
Cause: There are no page fetch pairs statistics stored in the catalog table for this index. Refer to the System Catalog Statistics section in the Administration Guide for more details.
Action: None.
DBA3017 There are no referenced functions associated with this access plan.
Cause: This access plan did not require the use of any functions.
Action: None.
DBA3018 There are no column distribution statistics associated with this column.
Cause: There are no column distribution statistics stored in the catalog table for this column. Refer to the System Catalog Statistics section in the Administration Guide for more details.
Action: None.
DBA3019 There are no indexes associated with this table.
Cause: There were no indexes defined on the referenced table at the time of explain and there are no indexes currently defined in the table.
Action: None.
DBA3020 An error occurred while a COMMIT against the database was being attempted and no SQLCODE can be returned.
Cause: An unexpected error occurred.
Action: Contact your system administrator.
DBA3021 An error occurred while a ROLLBACK against the database was being attempted and no SQLCODE can be returned.
Cause: An unexpected error occurred.
Action: Contact your system administrator.
DBA3022 The Get Database Manager Configuration api passed back a non-zero return code.
Cause: An unexpected error occurred causing the operation to stop.
Action: Contact your system administrator.
DBA3023 The Get Database Configuration api passed back a non-zero return code.
Cause: An unexpected error occurred causing the operation to stop.
Action: Contact your system administrator.
DBA3024 An error occurred while saving to the file "<file>".
Cause: Possible problems include:
Action: Possible solutions include:
DBA3025 An error occurred while retrieving from the file "<file>".
Cause: Possible problems include:
Action: Specify the correct file name.
DBA3026 No printers are installed.
Cause: There are no printers installed on your machine.
Action: Install a printer on your machine.
DBA3033 There are no referenced table spaces associated with this access plan.
Cause: This access plan did not reference any database objects contained in a table space.
Action: None.
DBA3034 The snapshot was created using code page "<codepage>" but is not converted to the code page of the window running the Visual Explain Tool.
Cause: The snapshot of the access plan graph displayed was created on a code page different from the code page of the window running the Visual Explain Tool. Code page conversion is not successful because the snapshot is too large. The access plan graph is displayed without code page conversion. You may not be able to display the current statistics when you open the statistics windows.
Action: Change the code page of the window running the Visual Explain Tool to the same one used to create the snapshot and display the access plan graph again.
DBA3035 The snapshot was created using code page "<codepage>" but is not converted to the code page of the window running the Visual Explain Tool. The value of the database manager configuration parameter UDF_MEM_SZ is too small.
Cause: The snapshot of the access plan graph displayed was created on a code page different from the code page of the window running the Visual Explain Tool. Code page conversion is not successful because the user defined function used to convert between the code pages do not have enough memory to run. The access plan graph is displayed without code page conversion. You may not be able to display the current statistics when you open the statistics windows.
Action: Possible solutions include:
DBA3036 Explain tables have been created to process your dynamic explain request.
Cause: One or more explain tables have been created under the current user ID. These tables will be used to store the information needed by your dynamic explain request.
Action: None.
DBA3037 The explain snapshot has been corrupted. Your request cannot be completed.
Cause: The explain snapshot that is requested has been corrupted in the explain tables.
Action: Regenerate the snapshot.
DBA3038 There are no referenced buffer pools associated with this access plan.
Cause: This access plan did not reference any database objects contained in a buffer pool.
Action: None.
DBA3039 Explain tables cannot be found.
Cause: Explain tables do not exist.
Action: Create explain tables using one of the following methods:
DBA3040 The command is specified incorrectly.
Cause: The command has invalid syntax.
Action: Issue the command with the -h option to see the correct syntax.
DBA3041 The name of the database must be between 1 and "<maximum>" characters long.
Cause: The specified database name is either empty or too long.
Action: Reissue the command with a valid database name.
DBA3042 The explainable statement text must be between 1 and "<maximum>" characters long.
Cause: The specified explainable statement text is either empty or too long.
Action: Reissue the command with valid explainable statement text.
DBA3043 The query tag cannot have more than "<maximum>" characters.
Cause: The specified query tag is too long.
Action: Reissue the command with a valid query tag.
DBA3044 The user ID cannot have more than "<maximum>" characters.
Cause: The specified userid is too long.
Action: Reissue the command with a valid userid.
DBA3045 The valid range for query number is from 0 to "<maximum>".
Cause: The specified query number is either too small or too large.
Action: Reissue the command with a valid query number.
DBA3046 The valid values for optimization class are 0, 1, 2, 3, 5, 7 and 9.
Cause: The specified optimization class is not one of the valid values.
Action: Reissue the command with a valid optimization class.
DBA3047 The database "<name>" cannot be found.
Cause: The database name specified in the command does not exist in the system database directory.
Action: Reissue the command with an existing database name or catalog the database in the system database directory.
DBA3048
db2vexp explains a dynamic SQL statement to produce an access
plan graph.
The syntax is:
db2vexp -db <database name>
-sql <explainable statement text>
[-queryno <query number>]
[-querytag <query tag>]
[-opt <optimization class>]
[-user <user ID>]
[-password <password>]
[-withsnapshot]
Use -h option to get help information.
Cause: This is the syntax of the db2vexp command.
Action: None.
DBA4000 Are you sure you want to stop monitoring and exit the Snapshot Monitor.
Cause: You have requested to stop monitoring all database objects that are currently monitored and to exit the Snapshot Monitor.
Action: Click on "Yes" to process the request or "No" to ignore it.
DBA4003 You have selected too many performance variables to be shown in this view. The limit for both performance variable and information element columns is "<number>".
Cause: This occurs when:
If the number of performance variables to be displayed in this view exceeds the limit, some performance variables are ignored and are not shown in the view.
Action: If a performance variable that you have selected for viewing is not in the view, use the "Include performance variables" action to remove a performance variable already displayed and select the desired performance variable.
DBA4004 An unexpected error occurred while trying to get a snapshot. The Snapshot Monitor is paused. The message from the failing component is: "<message>".
Cause: The Snapshot Monitor has paused the collection of snapshots due to the unexpected error returned by the database manager that is being monitored. This usually occurs when the database manager is stopped or communication with the database manager is interrupted.
Action: Determine the cause of the error from the referenced message.
If you do not wish to continue monitoring, select the "Stop all monitoring" choice from the "Snapshot monitor" menu on any of the Snapshot Monitor windows for the database manager in question.
If you wish to continue monitoring, first correct the error and then select the "Resume monitoring" choice from the "Snapshot monitor" menu on any of the Snapshot Monitor windows for the database manager in question.
DBA4005 An unexpected error occurred while displaying the performance graph view. Presentation Manager returned the following error identifier: "<number>".
Cause: An unexpected error occurred while using Presentation Manager services.
Action: Write down the error identifier returned by Presentation Manager and contact support.
DBA4012 A fatal error has occurred in the database system monitor. It has returned invalid data.
Cause: The database system monitor returned data that is not recognized by the Snapshot Monitor. This can occur due to network problems or internal problems with the database manager system.
Action: Try your action again, and if the error persists please contact support.
DBA4070 The IBM-supplied performance variable profile "<name>" cannot be found.
Cause: The IBM-supplied performance variable profile is not found in the installation directory.
Action: Either reinstall the Snapshot Monitor, or specify a new performance variable profile to be used. To specify a new profile use the "Open as settings" action from the "Snapshot monitor" menu in any of the views.
DBA4071 The Snapshot Monitor tried to write to the performance variable profile "<name>", but it failed due to file access permissions.
Cause: The Snapshot Monitor encountered problems while writing to the specified performance variable profile.
Action: Examine file permissions for the file or the directory where the file resides, and make sure that they allow writing to the file.
DBA4072 The Snapshot Monitor detected "<number>" syntax errors while parsing the specified performance variable profile. "<number>" performance variable definitions were parsed correctly. For errors look in file "<name>".
Cause: Some of the performance variable definitions in the specified profile are invalid and are not recognized by the Snapshot Monitor.
Action: Examine the errors listed in the error file, fix them, and retry the operation.
DBA4080 You have specified a capture interval that is not between 00:00:01 and 99:59:59. Please specify a valid value.
Cause: The value entered for the capture interval cannot be used by the Snapshot Monitor, because it does not fall into the specified range.
Action: Type a valid value.
DBA4091 The specified performance database does not exist.
Cause: The performance database has been dropped or uncataloged since the last time the Snapshot Monitor was used.
Action:
Do one of the following actions:
DBA4094 The performance variable profile "<name>" was not found. You must specify a valid performance variable profile in order to use the Snapshot Monitor.
Cause: The performance variable profile last used with the Snapshot Monitor was either deleted or moved to a different location.
Action: Specify a new profile name. Use the "Open as settings" action from the "Snapshot monitor" menu in any view to display the Settings window, and type the profile name in the "Performance variable profile" field.
DBA4100 The X axis size must be between 1 and 999 snapshots.
Cause: You have entered a number that is outside this range.
Action: Enter a value that falls within the range.
DBA4110 There is already a performance variable profile with the same name in your default profile directory. Do you want to replace it with the IBM-supplied profile?
Cause: You have selected to copy the IBM-supplied performance variable profile. However, a profile with the identical name already exists in that directory.
Action: Select "OK" to copy the file and to overwrite the existing one, or "Cancel" to ignore the request.
DBA4115 An invalid combination of alarm and warning values has been entered.
Cause: Upper warning values must always be less than upper alarm values. Lower warning values must always be greater than lower alarm values. Upper warning values must always be greater than lower warning values.
Action: Re-enter your values, and make sure they meet the above conditions.
DBA4200 The performance variable profile "<name>" has been changed. Would you like to save the changes?
Cause: At least one of the performance variable definition or global definitions ( such as sampling interval ) of the currently active profile has been changed.
Action: Select "Yes" to save the changes or "No" to discard the changes.
DBA4201 Cannot open the performance variable profile "<name>" due to a system error.
Cause: The performance variable profile selected to be used is not valid or is corrupted due to a system error.
Action: Contact your system administrator.
DBA4202 The new performance variable profile name "<name>" already exist. Click on "Yes" to overwrite the existing file, or "No" to cancel the operation.
Cause: The performance variable profile name entered already exists in the file system.
Action: Click on "Yes" to overwrite the existing file, or "No" to cancel the operation.
DBA4203 The "<name>" is missing.
Cause: A valid data is required in the entry field in order to complete the operation.
Action: Enter a valid data in the corresponding entry field.
DBA4204 "<name>" is an invalid DB2 Version 2 performance variable profile.
Cause: You have specified an invalid DB2 version 2 performance variable profile for migration.
Action: Make sure that the file selected contains a DB2 Version 2 performance variable profile. If the problem persists, contact your system administrator.
DBA4205 The performance variable with the ID "<name>" already exists. Click on "Yes" to overwrite the existing performance variable, or "No to cancel the operation.
Cause: The performance variable ID used already exists in the currently active profile.
Action: Click on "Yes" to overwrite the existing performance variable, or "No to cancel the operation.
DBA4206 "IBM" is a predefined creator keyword. Use another creator name.
Cause: "IBM" can not be used as a creator name for a user-defined performance variable.
Action: Use a different creator name.
DBA4207 An invalid combination of alarm and warning values or alert actions has been entered for "<performance variable name>". Correct the error before choosing another category or performance variable.
Cause: Upper warning values must always be less than upper alarm values. Lower warning values must always be greater than lower alarm values. Upper warning values must always be greater than lower warning values. If the start script checkbox is on, you must provide a script file name in the entry field. If the show message checkbox is on, you must provide a message in the multiline edit field.
Action: Re-enter your values, and make sure they meet the above conditions.
DBA4208 An invalid performance variable equation has been entered.
Cause: The performance variable equation is invalid. The error can be caused by the use of invalid performance data elements or variables, syntax errors in the equation, or by not using a 7-bit ASCII character set alphabet.
Action: Refer to the online help for the correct syntax of a performance variable equation and correct the error.
DBA4209 Profile changes may not be effective until the performance monitor is restarted.
Cause: Depending on the operating system, the profile changes will not be saved if the profile is still in used by the performance monitor.
Action: Stop all monitoring activities and restart to use the profile changes.
DBA4210 The source and target profile names cannot be the same.
Cause: Different source and target profile names are required for the selected operation.
Action: Enter different profile names in the source and target entry fields.
DBA4211 "db2smpv" is the default profile name and cannot be used as the target profile name.
Cause: "db2smpv" is the IBM default performance variable profile and cannot be used as the target profile.
Action: Enter a different profile name in the target entry field.
DBA4212 "<Performance variable profile name>" is the current active profile and cannot be used as the target profile.
Cause: The active performance variable profile cannot be used as the target profile in any operation.
Action: Enter a different profile name in the target entry field.
DBA4213 The requested profile operation is terminated due to the disk being full.
Cause: The disk is full.
Action: Free up some disk space and retry the operation.
DBA4214 "<Performance variable ID>" is an IBM supplied performance variable ID. Specify another ID.
Cause: The IBM supplied performance variable ID cannot be used.
Action: Enter a different performance variable ID and retry the operation.
DBA4215 The new scale value must be greater than zero.
Cause: The performance graph will not work with a scale value of zero.
Action: Enter a valid scale value.
DBA4701 The database manager "<name>" where the performance database "<name>" resides is not started, or is not cataloged, or cannot be accessed due to a communication problem. No alerts will be recorded.
Cause: An ATTACH command to the database manager that manages the performance database failed, or the database manager is not cataloged.
No alerts will be recorded. The Snapshot Monitor setting to write alerts has been disabled.
Action: Make sure the database manager that manages the performance database is started and/or cataloged. To re-enable the writing of alerts to the performance database, use the "Open as settings" action from the "Snapshot monitor" menu in any view to display the Settings window. Then select the "Write alerts in performance database" check box.
DBA4702 The performance database "<name>" for recording alerts does not exist in the system database directory. No alerts will be recorded.
Cause: The performance database specified in the Snapshot Monitor Settings window does not exist in the system database directory.
No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: Specify a new performance database. Use the "Open as settings" action from the "Snapshot monitor" menu in any view to display the Settings window, select the "Write alerts in performance database" check box, and specify the new performance database name.
DBA4703 The table SSMON_ALERT does not have the definition expected by the Snapshot Monitor. No alerts will be recorded.
Cause: The table SSMON_ALERT in the performance database does not have the definition expected by the Snapshot Monitor.
No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: Drop the table SSMON_ALERT. Use the "Open as settings" action from the "Snapshot monitor" menu in any view to access the Settings window, select the "Write alerts in performance database" check box. The SSMON_ALERT table will be created for you by the Snapshot Monitor.
DBA4704 The table SSMON_ALERT used for recording alerts was created in the performance database by the Snapshot Monitor.
Cause: The table SSMON_ALERT was created in the performance database by the Snapshot Monitor, as specified in the Snapshot Monitor Settings window. For details on the format of the SSMON_ALERT table, see the file CALRTTBL.DDL in the samples directory.
Action:
DBA4705 An error occurred while a COMMIT for inserts made to the alert table in the performance database was being attempted, and no SQLCODE can be returned. No alerts will be recorded.
Cause: An unexpected error occurred.
No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: Contact your system administrator.
DBA4706 An error occurred while updates to the alert table were being attempted. A ROLLBACK against the performance database failed, and no SQLCODE can be returned. No alerts will be recorded.
Cause: An unexpected error occurred.
No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: Contact your system administrator.
DBA4707 The table SSMON_ALERT does not exist. It may have been deleted. No alerts will be recorded.
Cause: The table SSMON_ALERT does not exist in the performance database. It may have been deleted.
No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: To re-enable the writing of alerts to the performance database, use the "Open as settings" action from the "Snapshot monitor" menu in any view to display the Settings window. Then select the "Write alerts in performance database" check box. The SSMON_ALERT table will be created for you by the Snapshot Monitor.
DBA4708 A performance variable exceeded its upper threshold value.
Cause: You have defined an upper threshold for the specified performance variable, and it was exceeded.
Action: Examine the definition of the performance variable. If the threshold value is not valid, change it to avoid further alerting.
If this is an IBM-supplied performance variable, use the "Performance variable" action from the "Help" menu to display the online help, and examine the description of the performance variable and suggested actions when an alert is generated.
Otherwise, you may want to contact your system administrator for further explanation and investigation.
DBA4709 The following performance variable fell below its lower threshold value "<name>".
Cause: You have defined a lower threshold for the specified performance variable, and the performance variable fell below it.
Action: Examine the definition of the performance variable. If the threshold value is not valid, change it to avoid further alerting.
If this is an IBM-supplied performance variable, use the "Performance variable" action from the "Help" menu to display the online help, and examine the description of the performance variable and suggested actions when an alert is generated.
Otherwise, you may want to contact your system administrator for further explanation and investigation.
DBA4710 You have canceled the "<name>" command on the performance database. No alerts will be recorded.
Cause: The "Cancel" push button in the Logon Window was pressed while working with the performance database. No alerts will be recorded. The Snapshot Monitor setting for writing alerts has been disabled.
Action: To re-enable the writing of alerts to the performance database, use the "Open as settings" action from the "Snapshot monitor" menu in any view to display the Settings window. Then select the "Write alerts in performance database" check box.
DBA4730 An error occurred accessing the server. Monitoring will be terminated. smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Contact your technical service representative with the smcode.
DBA4731 A resource problem occurred on the server. Monitoring history data will be lost. Do you want to retry the operation? smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Free up some server resource and retry the operation. If the problem persists, contact your technical service representative with the smcode.
DBA4732 A failure occurred when trying to attach to the database instance. Monitoring history data will be lost. Do you want to retry the operation? smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Retry the operation. If the problem persists, contact your technical service representative with the smcode.
DBA4733 The monitored database instance is stopped. Restart the instance. smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Restart the instance. If the problem persists, contact your technical service representative with the smcode.
DBA4734 An error occurred accessing the server. Monitoring history will be lost. Do you want to retry the operation? smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Retry the operation. If the problem persists, contact your technical service representative with the smcode.
DBA4735 A failure occurred when trying to attach to the database instance. Monitoring history data will be lost. smcode: "<Error code>"
Cause: See the server error logs for more information.
Action: Contact your technical service representative with the smcode.
DBA4736 Unable to determine the current country code or current code page in use on the client. smcode: "<Error code>"
Cause: The client's country code and code page must be sent to the server so that the data is returned in the correct code page. The snapshot monitor subsystem was unable to determine the active country code or code page.
Action: Refer to your operating system documentation to determine how to set the country code and active code page for your system. Retry the operation after setting the country code and code page.
DBA4737 Unable to set the current client country code or current code page on the server. smcode: "<Error code>"
Cause: The client's country code and code page must be sent to the server so that the data is returned in the correct code page. The snapshot monitor subsystem was unable to set the client's active country code or code page on the server.
Action: Refer to your operating system documentation to determine how to activate the client's country code and active code page on your server's system. Retry the operation after activating the country code and code page.
DBA4738 The Administration Server on system "<name>" is not started. smcode: "<Error code>"
Cause: The listed Administration Server on system "<name>" is not started.
Action: Start the Administration Server and retry the operation.
DBA4739 An error occurred while attempting to determine the client codepage. smcode: "<Error code>"
Cause: This is a client system setup problem.
Action: Contact IBM Service.
DBA4740 The client codepage "<name>" is not available on instance "<name>". smcode: "<Error code>"
Cause: The listed codepage has not been installed on instance "<name>".
Action: Contact your system administrator. Your administrator should install codepage "<name>" on instance "<name>".
DBA4741 The client codepage "<name>" is not available on instance "<name>", at node "<name>". smcode: "<Error code>"
Cause: The listed codepage has not been installed on instance "<name>", at node "<name>".
Action: Contact your system administrator. Your administrator should install codepage "<name>" on instance "<name>" at node "<name>".
DBA4742 The Administration Server "<name>" cannot be found. smcode: "<Error code>"
Cause: Possible reasons for this problem include: 1) Remote instance name is invalid. 2)Hostname is invalid.
Action: Contact your system administrator.
DBA4743 The Administration Server "<name>" detected an error. sqlcode: "<Error code>". smcode: "<Error code>"
Cause: The Administration Server "<name>" had an internal error.
Action: Contact your system administrator.
DBA4744 A communications failure occurred when the Control Center attempted to communicate with the parallel tools on instance "<name>" at node "<name>". smcode: "<Error code>"
Cause: Communications may not have been started.
Action: Contact your system administrator.
DBA4745 The TCP/IP port configuration between the Control Center and the parallel tools on instance "<name>" at node "<name>" is not correct. smcode: "<Error code>"
Cause: The /etc/services file at node "<name>" might contain incorrect information.
Action: Contact your system administrator. Your administrator should check that the port name of db2ccmsrv is entered correctly in the /etc/services file on node "<name>".
DBA4746 Instance node host name "<name>" is not valid on instance "<name>". smcode: "<Error code>"
Cause: The db2nodes.cfg file for instance "<name>" might contain incorrect information.
Action: Contact your system administrator. Your administrator should validate the host name found in the db2nodes.cfg file for instance "<name>".
DBA4747 The snapshot monitor did not receive a response from node "<name>" within the snapshot capture interval. smcode: "<Error code>"
Cause: A performance or communications problem on the listed node is preventing a response from being sent, or the snapshot capture interval is not long enough to allow each node time to respond to the request.
Action: Contact your system administrator. Your administrator can 1) Validate the performance on the listed node. 2) Increase the snapshot capture interval to allow more time for the node to respond to the snapshot request.
DBA4748 Logical node "<name>" on instance "<name>" is not valid. smcode: "<Error code>"
Cause: The db2nodes.cfg file for instance "<name>" might contain incorrect information.
Action: Contact your system administrator.
DBA4749 The parallel tools on instance "<name>" is unable to establish communications with node "<name>". smcode: "<Error code>"
Cause: The communications subsystem may not have been started.
Action: Contact your system administrator.
DBA5006E PIPE Event Monitors are not supported.
Cause: The Event Analyzer only handles traces produced by FILE Event Monitors.
Action: Use a FILE Event Monitor.
DBA5007E The specified Event Monitor does not exist.
Cause: The Event Monitor names specified with the -evm option could not be found in the catalogs for the database specified with the -db option. The Event Monitor may have been dropped or you may be trying to connect to the wrong database.
Action: Make sure that the Database alias specified with the -db is properly cataloged and that the Event Monitor has not been dropped. If the latter is the case, re-create the event monitor.
DBA5250I The number of objects retrieved exceeds the limit of what can fit in the window. A partial list is displayed.
Cause: The window height required to display the retrieved objects exceeds a system limit.
Action: You can reduce the number of objects displayed in the window by doing the following:
DBA5300E
Event Analyzer invocation error.
Usage:
Where:
Window Manager Options can be intermixed with the db2eva arguments.
db2eva -path evmon-target |
[-conn | [-db database-alias]] |
-db database-alias |
-evm evmon-name [-conn]
Cause: Two modes of operation are provided for reading Event Monitor trace files:
This mode allow users to move trace files from a server and analyze them locally, even if the Event Monitor has been dropped.
When this mode is used, db2eva connects to the database, and issues a 'select target from sysibm.syseventmonitors' to locate the directory where the Event Monitor writes its trace files. The connection is then released, unless -conn is specified. The Event Monitor must not have been dropped when using this mode.
NOTE: Both the -conn and -db options require that the Database with which the trace was recorded still exists, and that the user has sufficient access privileges to connect and select from the system catalogs.
Action: Re-issue the command with valid arguments.
DBA5350E The specified file cannot be opened.
Cause: The specified file could not be opened in read-only mode for an unknown cause.
Action: Check the spelling of the directory specified by the -path option, its access authority, and that it contains a non-empty, readable trace file called 00000000.evt.
NOTE: The first trace file for an Event Monitor is always named 00000000.evt and cannot be renamed.
DBA5351E The specified file cannot be found.
Cause: There is no 00000000.evt file in the directory specified by -path.
Action: Check the spelling of the directory specified by the -path option, its access authority, and that it contains the trace file 00000000.evt.
NOTE: The first trace file for an Event Monitor is always named 00000000.evt and cannot be renamed.
DBA5352E The path specified was not found.
Cause: The -path option specifies a directory that does not exist.
Action: Check the spelling of the directory specified by the -path option, its access authority, and that it contains the trace file 00000000.evt.
NOTE: The first trace file for an Event Monitor is always named 00000000.evt and cannot be renamed.
DBA5353E Access to the specified file was denied.
Cause: The specified file could not be opened in read-only mode. The -path option may be specifying a directory to which you do not have sufficient access authority.
Action:
DBA5354E The data cannot be read from the specified file.
Cause: The Event Monitor trace file contains unexpected data, or cannot be accessed.
The trace file was likely corrupted during transmission or has been removed.
Action: Transmit your trace files from your server again. When transmitting trace files from a remote server, ensure that the transmission is done in binary mode.
DBA5355E An Event Monitor log header could not be found in the specified file.
Cause: The first file written to by an Event Monitor is named 00000000.evt and contains a data structure that identifies the trace characteristics. This data structure could not be read. Possible causes:
Action:
DBA5356E The byte order is not valid in the specified file.
Cause: The Event Monitor log header (the first record written to a new trace) specifies whether the trace contains little-endian (e.g., OS/2) or big-endian (e.g., AIX) data. The value found in the trace file specified neither of these two supported types of data.
The trace file was likely corrupted during transmission.
Action: Transmit your trace files from your server again. When transmitting trace files from a remote server, ensure that the transmission is done in binary mode.
DBA5357E Unexpected data was found at the specified offset in the specified file.
Cause: The Event Monitor trace file contains unexpected data.
The trace file was likely corrupted during transmission.
Action: Retransmit your trace files from the server, ensuring that the transmission is done in binary mode.
DBA5500E A system error has occurred. The Event Analyzer tool could not continue processing.
Cause: For an unknown reason a system error has occurred when trying to initialize the application environment.
Action: Re-issue the command.
DBA5501W Do you want to delete the event files associated with the event monitor "<evname>" that you are removing?
Cause:
Action: To delete the event files for the selected event monitor, click on OK. If you do not want to delete the event files, but still want the event monitor removed, click on NO. If you do not want to remove the event monitor, or delete the event files click on CANCEL.
DBA5502E No selection was made from the list of Event types. You must select one or more types from the list.
Cause: When creating an event monitor, at least one Event type must be selected.
Action: Select one or more of the Event type check boxes from the Create Event Monitor window.
DBA5503I An event monitor "<evname>" has been successfully created.
Cause: The event monitor has been successfully created and has been added to the database list of event monitors.
Action: Click on OK to remove the message.
DBA5504W Some event monitors were not removed because their event files could not be deleted. See the messages page from the journal notebook for the list of event monitors not removed.
Cause: Some of the selected event monitors may have been successfully removed, but others were not, because their associated event trace files could not be deleted.
This occurs when either event files are read-only, or they are being used by another active process.
Action: See the message page of the journal notebook for the list of event monitors that were not removed. To delete the files, end the process using them and check the access authority for the files. Then select the event monitor from the list of event monitors and choose remove from the menu.
DBA5505E Maximum file size was not specified.
Cause: If maximum file size in 4K pages is selected on the create event monitor Options window, then the maximum size of the event files must be specified.
Action: Enter a maximum file size of between 1 and 2,147,483,647 4K pages, or you can select the No Maximum option. If the No Maximum option is selected, the maximum number of event files is 1.
DBA5506E Maximum number of files was not specified.
Cause: If Maximum number of files is selected on the create event monitor Options window, then the maximum number of event files must be specified.
Action: Enter a maximum number of event files of between 1 and 2,147,483,647, or you can select No Maximum option.
DBA5507E Buffer size was not specified.
Cause: An event monitor Buffer size in 4K pages must be specified.
Action: You must enter an event monitor buffer size of between 1 and 2,147,483,647 4K pages.
DBA5508W Do you want to delete the event files associated with the event monitors that you are removing?
Action: To delete the event files for the selected event monitors, click on OK. If you do not want to delete the event files, but still want the event monitors removed, click on NO. If you do not want to remove the selected event monitors, or delete the event files click on CANCEL.
DBA5509E The name entered for the event monitor is not valid.
Cause: The name entered in the event monitor Name field contains one or more characters that are not allowed. An event monitor can contain alphanumerics and must begin with a letter.
Action: Remove from the name any characters that are not alphanumeric and make sure the name begins with a letter.
DBA5510E When trying to activate the monitor, the directory for its data files was not found.
Cause: When activating an event monitor, the directory that was specified when the event monitor was created must exist. In order to flush its buffers, an event monitor needs an existing file and path.
Action: Create the directory that was specified when creating the event monitor. Try to activate the event monitor again.
DBA5511E Entry "<name>" is not valid because the value is out of the acceptable range.
Cause: The values for an event monitor's Maximum file size, Maximum number of files, and Buffer size must be between 1 and 2,147,483,647.
Action: Enter a value in the entry fields that is within the given range.
DBA5512E The character "<character>" entered for the event monitor name is not allowed.
Cause: A character entered in the event monitor name entry field is not a valid character for an event monitor name.
Action: Remove from the event monitor name any characters that are not alphanumeric and make sure the name begins with a letter.
DBA5513W The dynamic link library "<dllname>" could not be loaded successfully.
Cause: During the initialization of the event analyzer the dll could not be loaded because the dll has been deleted or removed.
Action: Reinstall the event analyzer by selecting the performance monitor during the installation process.
DBA5514I The event files for event monitor "<evname>" could not be deleted.
Cause: The event files for the event monitor could not be deleted because the files are being used by an active process or are read-only.
Action: To delete the files, end the process that is using them and check the access authority for the files. Select the event monitor again and choose remove from the menu.
DBA5515W The database alias name or database name "<dbname>" could not be found.
Cause: The alias name that was entered on the command line has not been cataloged on this machine.
Action: Either catalog the alias on this machine and reenter the command or re-issue the command with a valid alias name.
DBA5516W Viewing the trace for this event monitor may take some time. Do you wish to continue processing?
Cause: The user has requested to view a large trace for an event monitor. Reading the files could take some time to complete.
Action: If you want to continue processing the trace click on OK. If you do not wish to continue processing the trace file then click on NO.
DBA5517E The event monitor could not be started due to a reason code of "<reason-code>".
Cause: The event monitor could not be started for the reason specified by "<reason-code>":
Action: To start the event monitor, make sure that the event monitor path is valid, the admin server started, and the proper authorities exist on the device. Click on OK.
If the problem persists, manually create the event monitor directory on the device and click on OK.
To create the event monitor without starting it, deselect the Start now check box and click on OK.
DBA5518E The event monitor could not be started because its output directory could not be created.
Cause: The directory could not be created for one of the following reasons.
Action: Make sure the proper authorities exist for directory creation.
On non-Intel platforms create the event monitor output directory manually.
DBA6001I The replication subscription set, "<subscription_set>", is in use. Please try again later.
Cause: The Apply program is currently processing the replication subscription and this action cannot be deactivated. Wait until the Apply program has completed its processing and retry your command.
Action: No action is required.
DBA6002I The replication source, "<source_name>", was defined successfully. To begin capturing changes to the replication source, start the Capture program from the command line.
Cause: The Capture program requires a defined replication source in order to run.
Action: Make sure the Capture program is running.
DBA6003I The replication subscription was defined successfully. To begin replicating the subscription set, ensure that the Apply program has been started from the command line.
Cause: The Apply program requires a defined replication source in order to run.
Action: Make sure the Apply program is running.
DBA6004I The replication subscription was successfully changed.
Cause: This is for your information only.
Action: No action is required.
DBA6005I The replication sources were successfully removed.
Cause: This is for your information only.
Action: No action is required.
DBA6006I The replication source, "<source_name>", could not be removed.
Cause: This is for your information only.
Action: No action is required.
DBA6007I The replication subscription, "<subscription_name>", could not be removed.
Cause: This is for your information only.
Action: No action is required.
DBA6008I The replication subscriptions were successfully removed.
Cause: This is for your information only.
Action: No action is required.
DBA6009E "<file_name>" is locked by another action.
Cause: The file is currently being used by another action.
Action: Wait until the action is completed and retry your command.
DBA6010I The join was successfully defined.
Cause: This message is for your information only.
Action: No action is required.
DBA6012I The replication source was defined successfully. To begin capturing changes to the replication source, ensure that the Capture program has been started from the command line.
Cause: The Capture program requires a defined replication source in order to run.
Action: Make sure the Capture program is running.
DBA6013I The replication subscription was successfully updated.
Cause: This message is for your information only.
Action: No action is required.
DBA6014I The replication subscription was successfully cloned.
Cause: This message is for your information only.
Action: No action is required.
DBA6015I The SQL statements for this action have been saved in a file for future editing and execution.
Cause: This message is for your information only.
Action: No action is required.
DBA6016I The SQL script file has been run successfully.
Cause: This message is for your information only.
Action: No action is required.
DBA6100I The Apply program will only perform full refresh copies to this set.
Cause: This message is for your information only.
Action: No action is required.
DBA6101E The table, "<table_name>", cannot be found.
Cause: The control table specified could not be located in the database or was accidently dropped.
Action: Create the control table. See the Tables Chapter for more details.
DBA6102I This action may take some time to complete. Please wait...
Cause: This message is for your information only.
Action: No action is required.
DBA6103E The SQL file, "<file_name>", cannot be run.
Cause: The user may have edited the SQL statement file for a replication action, such as defining a replication source, and there is an error in the SQL statement file.
Action: Correct the error in the SQL statement file and run the file again.
DBA6104W No unique prefix character was found. The prefix character will be set to NULL.
Cause: A prefix character is an alphabetical or numerical character used to distinguish before-image columns in the source table. If a prefix character connot be assigned because all possible prefix characters are already in use, you will receive this warning. The change data table cannot be created.
Action: Uncheck the before-image columns and rerun the action.
DBA6105E The field, "<field_name>", requires your input.
Cause: The user has not filled in a required field.
Action: Specify a parameter and select OK.
DBA6106E The replication action does not currently support this database system.
Cause: The replication action must support your database system in order to run.
Action: Contact your IBM Service representative.
DBA6107E Please enter a different value for the field, "<field_name>".
Cause: When cloning a replication subscription, the target server and Apply qualifier fields must be different from the original target server and Apply qualifier fields.
Action: Enter a different target server name or Apply qualifier and select OK.
DBA6108E The action cannot be completed due to a syntax error.
Cause: The SQL statement contains a syntax error.
Action: Check the SQL reference for the proper syntax. For subscription actions, check the where clause, the rows page, or the CREATE column. For define-join actions, check the CREATE VIEW statement.
DBA6109E SHOW COLUMNS action cannot be completed.
Cause: The SHOW COLUMNS action requires that a table be selected.
Action: Select a table from the Selected Table list box and then press the SHOW COLUMNS key.
DBA6110E The SQL file, "<file_name>", cannot be opened.
Cause: The SQL file either does not exist, is in the wrong subdirectory, or is engaged in another process.
Action: Make sure you enter the correct file name and that the file is in the correct subdirectory. If the file is engaged in another process, terminate the process and reenter the file name.
DBA6111E The file, "<file_name>", cannot be opened.
Cause: The file either does not exist or is in the wrong subdirectory.
Action: Make sure you enter the correct file name on the Replication page of the Tool Settings notebook.
DBA6112I You have chosen to substitute user-defined values to define replication objects in the Tool Settings notebook. Please supply these values in the file "<file_name>".
Cause: This message is for your information only.
Action: No action is required if you have already supplied user-defined values in the file.
DBA6113E "<keyword>" is an invalid keyword in file "<file_name>".
Cause: The specified keyword is invalid and may be a typographical error.
Action: Use the keywords as given in the default file "DPREPL.DFT".
DBA6114E The value for keyword "<keyword>" cannot be found in file "<file_name>".
Cause: The value of this keyword is required for this action to complete.
Action: Specify a value for this keyword in the file.
DBA6115E None of the items in the column list were selected. This action cannot be completed.
Cause: At least one item in the column list must be selected for this action to complete.
Action: Select one or more items from the column list and press OK.
DBA6116E The value for keyword "<keyword>" is invalid in file "<file_name>".
Cause: The value of this keyword is either too long, an incorrect data type, or in an incorrect format.
Action: Correct the value and invoke the action again.