SQL6000N DB2 Conversion of QMF Data.
Explanation: This is the normal termination message.
User Response: No action is required.
SQL6001N The prefix for the filename was not specified.
Explanation: The user executed a module of the SQLQMF facility directly rather than using the SQLQMF facility command.
The command cannot be processed.
User Response: Use the provided SQLQMF facility command.
SQL6002N Communications Manager encountered a download error.
Explanation: Communications Manager encountered an error during the download of the host file.
The command cannot be processed.
User Response: Review the Communications Manager message log.
SQL6003N The file exported from QMF contains rows that are too long. The row length is "<number>".
Explanation: The computed row size (the sum of the computed column sizes) exceeds the maximum of 7000 bytes.
The command cannot be processed.
User Response: Return to your QMF host session and run a query with fewer data columns selected. EXPORT the data again and then try the SQLQMF facility command again.
SQL6004N "<function>" returned the unexpected return code "<code>".
Explanation: An unexpected error occurred during processing. The Communications Manager or DB2 may not be installed or configured correctly.
The command cannot be processed.
User Response: Ensure that Communications Manager has been installed and the appropriate host communications session is active. Retry the command after checking for other errors. If the problem persists, contact your Communications Manager system administrator.
SQL6005N An error occurred while reading the downloaded QMF file.
Explanation: One of the following conditions was encountered:
The command cannot be processed.
User Response: Review the Communications Manager message log. Retry the command. If the error continues, contact your Communications Manager system administrator.
SQL6006N An error occurred while writing to an output file.
Explanation: One of the following conditions was encountered:
Federated system users: there isn't enough space to hold the db2djlink output. Additional space is required for the temporary files that db2djlink creates and uses.
The command cannot be processed.
User Response: Check for sufficient disk space on the C: drive. Retry the command.
Federated system users: increase the size of the file system where the federated server is installed. To estimate the amount of free space db2djlink needs on an AIX operating system, enter:
ls -e /install_directory/lib/libdb2euni.a
This command returns the number of bytes used by the listed file. Multiply that number by 3. The result is an estimate of how much free space is needed on the file system. Increase the size of the file system as necessary and retry the command.
SQL6007N The decimal number in row "<row>", column "<column>" cannot be converted to ASCII.
Explanation: The indicated decimal field could not be converted.
The command cannot be processed.
User Response: Verify that the host column data type is DECIMAL. Retry the QMF EXPORT and then try the SQLQMF facility command again. If the error continues, rerun the QMF query without the named column.
SQL6008N The file specified in the command is not in QMF data format.
Explanation: The file specified by the filename parameter is not in the expected QMF format.
The command cannot be processed.
User Response: Verify that you have typed the name correctly. If correct, return to your QMF host session and issue the command EXPORT DATA TO filename again. Be sure to export using the QMF data format.
SQL6009N The file exported from QMF contains Column "<name>" with a width "<width>" that is too long. The maximum column width is 4000 bytes.
Explanation: The downloaded QMF file has a column width greater than 4000 bytes.
The command cannot be processed.
User Response: Return to your QMF host session, rerun the QMF query without the named column, and export the data again. Then run the SQLQMF facility command again.
SQL6010N The downloaded QMF file has more than 255 data columns.
Explanation: The file being processed has more than 255 data columns.
The command cannot be processed.
User Response: Return to your QMF host session and rerun a query, selecting 255 or fewer data columns. EXPORT the data again and then run the SQLQMF facility command again.
SQL6011N The data type "<number>" ("<type-text>") of column "<name>" (positioned at column "<number>") cannot be processed.
Explanation: The QMF file contains a column with data type that is not supported.
The SQLQMF facility does NOT support the following data types:
Only the SQLQMF facility SQLQMFDB supports graphic data types.
The command cannot be processed.
User Response: Return to your QMF host session and rerun the query without selecting the named column. Then run the SQLQMF facility command again.
SQL6012N Too many parameters were specified for the command.
Explanation: Too many parameters were specified with the command.
The command cannot be processed.
User Response: Retry the command with the correct number of parameters.
SQL6013N Host filename "<host filename>" is either too long or does not begin with an alphabetic character.
Explanation: The host filename does not begin with an alphabetic character; or, if the host is a VM System, the host filename, filetype, or filemode are too long.
The command cannot be processed.
User Response: Retry the command with a correct host filename syntax.
SQL6014N Invalid command syntax, colon (':') should follow a keyword.
Explanation: Keyword parameters with operands require the keyword to be immediately followed by a ":" character and then the operand.
The command cannot be processed.
User Response: Verify the command syntax and retry the command.
SQL6015N The keyword is not recognized.
Explanation: The keyword parameter indicator ("/") was followed by a value that is not a keyword.
The command cannot be processed.
User Response: Retry the command using a different keyword value.
SQL6016N Too many operands for the System/370 filename "<name>".
Explanation: If the host is a VM System, the host file name contains more than three space-separate tokens. If the host is an MVS System, the host filename contains embedded blanks.
The command cannot be processed.
User Response: Retry the command using a different keyword value.
SQL6017N More information may be contained in the Import message log "<name>".
Explanation: The database IMPORT operation terminated with warning or error messages.
The command has left its work files allocated.
User Response: Use the message preceding this message and the IMPORT message log, if it exists, to decide if the IMPORT was successful and to determine corrective action. If the import was successful, erase the DEL, CRE, COL, and IML files.
SQL6018N No S/370 filename was specified.
Explanation: The S/370 filename is a required parameter.
The command cannot be processed.
User Response: Retry the command with a host filename.
SQL6019N Communications short session ID "<ID>" is either too long or is invalid.
Explanation: The value provided for the communications short session ID is either longer than one byte or is not alphabetic.
The command cannot be processed.
User Response: Retry the command with a valid value.
SQL6020N An import option was specified without also providing a database name.
Explanation: No database name was provided and an import option was specified.
The command has terminated.
User Response: Retry the command and include a database name.
SQL6021N Data was successfully imported.
Explanation: This is a normal ending message when the SQLQMF facility imports data to a database.
User Response: No action is required.
SQL6022N System database directory is not shared by all nodes.
Explanation: All nodes should be accessing one physical copy of the system database directory.
The command cannot be processed.
User Response: Ensure that all nodes are accessing the system database directory that resides in the sqllib directory, then try the request again.
SQL6023N The user does not have the authority to run the Get Table Partitioning Information utility on table "<name>".
Explanation: The user attempted to retrieve partitioning information on the specified table without the appropriate authorization (either the SYSADM or DBADM authority or the CONTROL or SELECT privilege on the table).
The utility stops processing.
User Response: Do not attempt to call the Get Table Partitioning Information utility without appropriate authorization. Contact your system administrator for assistance.
SQL6024N Table or index <name> is not defined on node <node-number>.
Explanation: The application is connected to node "<node-number>", and the table or index "<name>" is not defined.
The cause is one of the following:
The utility stops processing.
User Response: Connect the application to a node on which the table or index is defined. Determine the nodegroup in which the table was created and obtain the list of nodes in the nodegroup by selecting the appropriate rows from the NODEGROUPDEF catalog view. The nodes whose IN_USE value is set to Y are the ones on which the table or index is defined.
SQL6025N Database backed up on node "<node1>" cannot be restored to node "<node2>".
Explanation: The backup image used for the restore is a backup of the database on a different node.
User Response: Ensure that you have the correct backup image for the node, then try the request again.
SQL6026N Database with catalog node "<node1>" cannot be restored to a database with catalog node "<node2>".
Explanation: The catalog node can exist on only one node and there is a discrepancy between the backup image and the node being restored to. This can occur in the following cases:
User Response: Verify that the correct backup image is being restored.
If you are restoring to an existing database and want to change the catalog node to "<node2>", the existing database must be dropped first.
If you are restoring to a new database, restore the catalog node "<node1>" first.
SQL6027N The path "<path>" for the database directory is not valid.
Explanation: The path "<path>" specified for either the CREATE DATABASE or the CATALOG DATABASE command starts with the character '.' or contains the character string '/.'.
The command cannot be processed.
User Response: Ensure that the specified path is a fully qualified path, does not start with the character '.', and does not contain the character string '/.'. Then try the request again.
SQL6028N Catalog database failed because database "<dbname>" was not found in the local database directory.
Explanation: When cataloguing a local database into the system database directory, the command/API has to be issued from a node on the server where the database resides.
User Response: Reissue the command/API from a node where the database resides.
SQL6030N START or STOP DATABASE MANAGER failed. Reason code "<reason-code>".
Explanation: The reason code indicates the error. The statement cannot be processed.
User Response: The action corresponding to the reason code is:
SQL6031N Error in the db2nodes.cfg file at line number "<line>". Reason code "<reason code>".
Explanation: The statement cannot be processed because of a problem with the db2nodes.cfg file, as indicated by the following reason codes:
User Response: The action corresponding to the reason code is:
SQL6032W Start command processing was attempted on "<total_number>" node(s). "<number_started>" node(s) were successfully started. "<number_already_started>" node(s) were already started. "<number_not_started>" node(s) could not be started.
Explanation: The database manager did not start successfully on all the nodes. Not all of the data in the database may be accessible. Data on the nodes that started successfully or were already running is accessible.
User Response: Check the log file created in the log directory of the sqllib directory for the instance to see which nodes did not start.
SQL6033W Stop command processing was attempted on "<total_number>" node(s). "<number_stopped>" node(s) were successfully stopped. "<number_already_stopped>" node(s) were already stopped. "<number_not_stopped>" node(s) could not be stopped.
Explanation: The database manager did not stop successfully on all the nodes. The database manager is still active on the nodes that could not be stopped.
User Response: Check the log file created in the log directory of the sqllib directory for the instance to see which nodes did not stop.
SQL6034W Node "<node>" is not being used by any databases.
Explanation: During DROP NODE VERIFY processing, all databases are scanned to verify that this node does not exist in the nodegroups of any database, and that no event monitor is defined on this node.
User Response: This node can now be removed from the system by issuing the 'db2stop drop nodenum <node>' command.
SQL6035W Node "<node>" is being used by database "<database>".
Explanation: During DROP NODE VERIFY processing, databases are scanned to verify that this node does not exist in the nodegroups of any database, and that no event monitor is defined on this node. Node "<node>" is being used by database "<database>" and cannot be dropped.
User Response: You must do the following before dropping the node:
SQL6036N START or STOP DATABASE MANAGER command is already in progress.
Explanation: A START DATABASE MANAGER or a STOP DATABASE MANAGER command is already in progress on the system.
User Response: Wait for the command in progress to complete, then try the request again.
SQL6037N START or STOP DATABASE MANAGER timeout value was reached.
Explanation: The start_stop_time value defined in the database manager configuration was reached at the node. This value specifies the time, in minutes, in which a node must respond to a Start Database Manager, Stop Database Manager or Add Node command.
User Response: Do the following:
SQL6038N No partitioning key is defined.
Explanation: The user attempted to use the Get Row Partitioning Information utility without specifying a partitioning key.
The utility stops processing.
User Response: Ensure that you specify a partitioning key, then try the request again.
SQL6039N Partitioning column "<column-number>" is currently defined as not nullable.
Explanation: An attempt was made to assign a null value to partitioning column "<column-number>", which is not nullable.
The utility stops processing.
User Response: Assign a non-null value or change the type of the partitioning column to be nullable.
SQL6040C No FCM buffers are available.
Explanation: No FCM buffer is available.
The statement cannot be processed.
User Response: Try the request again.
If the error persists, increase the number of FCM buffers (fcm_num_buffers) specified in the database manager configuration file, then try the request again.
sqlcode: -6040
sqlstate: 57011
SQL6041C No FCM connection entries are available.
Explanation: No FCM connection entry is available.
The statement cannot be processed.
User Response: Try the request again.
If the error persists, increase the number of FCM connection entries (fcm_num_connect) specified in the database manager configuration file, then try the request again.
sqlcode: -6041
sqlstate: 57011
SQL6042C No FCM message anchors are available.
Explanation: No FCM message anchor is available.
The statement cannot be processed.
User Response: Try the request again.
If the error persists, increase the number of FCM message anchors (fcm_num_anchors) specified in the database manager configuration file, then try the request again.
sqlcode: -6042
sqlstate: 57011
SQL6043C No FCM request blocks are available.
Explanation: No FCM request block is available.
The statement cannot be processed.
User Response: Try the request again.
If the error persists, increase the number of FCM request blocks (fcm_num_rqb) specified in the database manager configuration file, then try the request again.
sqlcode: -6043
sqlstate: 57011
SQL6044N The syntax of the string representation "<string>" with value of datatype "<datatype-value>" and length "<length>" is not correct.
Explanation: The specified string cannot be recognized as the target datatype. (The Programming Reference contains information on datatypes.) Either the syntax is not valid or the value is out of range.
The utility stops processing.
User Response: Ensure that the string representation or the datatype is correct, then try the request again.
SQL6045N The datatype "<datatype-value>" of length "<datatype-length>" is not supported.
Explanation: The datatype and data length are not supported for a partitioning key.
The utility stops processing.
User Response: See the Administration Guide for information about datatypes. See the API Reference for information about the Get Row Partitioning Information API.
SQL6046N Specified DROP NODE action is not valid.
Explanation: The value specified for the action parameter of the DROP NODE command is not valid. Only the verify mode is supported for the DROP NODE command. The parameter must be set to the value SQL_DROPNODE_VERIFY.
The command cannot be processed.
User Response: Ensure that the action is set to SQL_DROPNODE_VERIFY, then try the request again.
SQL6047N Nodegroup cannot be redistributed because table "<name>" does not have a partitioning key.
Explanation: At least one table in the single-node nodegroup does not have a partitioning key. All tables in the single-node nodegroup must have a partitioning key before the nodegroup can be redistributed to a multiple-node nodegroup.
The operation was not performed.
User Response: Use the ALTER TABLE command to specify partitioning keys for tables that do not have one. Then try the request again.
SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
Explanation: A TCP/IP communication error occurred while the START or STOP DATABASE MANAGER command was trying to establish connection with all the nodes defined in the sqllib/db2nodes.cfg file.
User Response: Do the following:
SQL6049N The log control file for database "<name>" could not be found on node(s) "<node-list>".
Explanation: The SQLOGCTL.LFH file for the database is not in the database directory on the specified node(s).
The database was not started.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Either restore the database from a backup on the specified node(s), or re-create the database.
SQL6050N An I/O error occurred while accessing the log control file for database "<name>" on node(s) "<node-list>".
Explanation: An error occurred while accessing the SQLOGCTL.LFH file for the database on the specified node(s).
The database cannot be used.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Either restore the database from a backup on the specified node(s), or re-create the database.
SQL6051N Database "<name>" is not configured for roll-forward recovery on node(s) "<node-list>".
Explanation: The specified database is not configured for roll-forward recovery on the specified node(s).
The database is not rolled forward on all nodes.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Ensure that recovery is required on the specified node(s), then restore the most recent backup version of the database on these nodes.
SQL6052N Cannot roll forward database "<name>" because it is not in roll-forward pending state on node(s) "<node list>".
Explanation: The specified database is not in the roll-forward pending state on the specified node(s). This may be because the database has not been restored, or was restored with the WITHOUT ROLLING FORWARD option, or roll-forward recovery is complete on these nodes.
The database is not rolled forward.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Do the following:
SQL6053N Error exists in file "<file>". Reason code = "<reason-code>".
Explanation: There is an error in the specified file as indicated by the reason code:
User Response: The action corresponding to the reason code is:
SQL6054N The archive file "<name>" is not a valid log file for the database "<name>" on node "<node-number>".
Explanation: An archive log file exists in the log directory on the specified node, but it is not valid.
The ROLLFORWARD DATABASE processing stops.
User Response: To determine the correct archive log file, issue the ROLLFORWARD DATABASE command with the QUERY STATUS option. Move the correct archive log file to the database log directory or, if the database is in a consistent state, change the log path to point to the correct archive file and issue the ROLLFORWARD DATABASE command again.
SQL6055N The archive file "<name>" does not belong to database "<name>" on node "<node-number>".
Explanation: An archive log file in the log directory on the specified node does not belong to the specified database.
The ROLLFORWARD DATABASE processing stops.
User Response: To determine the correct archive log file, issue the ROLLFORWARD DATABASE command with the QUERY STATUS option. Move the correct archive log file to the database log directory or, if the database is in a consistent state, change the log path to point to the correct archive file and issue the ROLLFORWARD DATABASE command again.
SQL6056N Nodegroup cannot be redistributed. Reason code = "<reason-code>".
Explanation: The operation cannot be executed. The reason code indicates the error.
User Response: The action corresponding to the reason code is:
SQL6057N Archive file "<name>" is not associated with the database "<name>" that was restored, or with the log file previously processed on node "<node-number>".
Explanation: An archive log file is found in the log directory on the specified node, but does not belong to the specified database.
The ROLLFORWARD DATABASE processing stops.
User Response: To determine the correct archive log file, issue the ROLLFORWARD DATABASE command with the QUERY STATUS option. Move the correct archive log file to the database log directory or, if the database is in a consistent state, change the log path to point to the correct archive file and issue the ROLLFORWARD DATABASE command again.
SQL6058N Roll-forward recovery stopped because of error "<error>" while retrieving log file "<name>" for database "<name>" on node "<node-number>".
Explanation: Roll-forward processing invokes the db2uexit to retrieve the log file for the database on the specified node. The error may have occurred in the db2uexit.
The ROLLFORWARD DATABASE processing stops.
User Response: See the user exit documentation in the Administration Guide for a description of the error, and either resume or terminate the roll-forward recovery.
SQL6059N The point-in-time passed to the Rollforward utility must be greater than or equal to "<timestamp>", because database "<name>" on node(s) "<node-list>" contains information later than the specified time.
Explanation: An advanced virtual timestamp is in the database backup.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Do one of the following:
SQL6061N Roll-forward recovery on database "<name>" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "<node-list>".
Explanation: The Rollforward Database utility cannot find the necessary log file(s) in the logpath.
User Response: Do one of the following:
SQL6062N Roll-forward recovery on database "<name>" cannot complete because the log information on node(s) "<node-list>" does not match the corresponding record(s) on the catalog node.
Explanation: The Rollforward utility processed all the log files found on each node, but the stop points on the specified nodes do not match the corresponding records on the catalog node. This can be caused by missing log files on either the catalog node or on the specified nodes, or the catalog node must be included in the list of nodes to be rolled forward.
The ROLLFORWARD DATABASE processing stops.
User Response: Do one of the following:
SQL6063N Roll-forward recovery on database "<name>" has stopped on node(s) "<node-list>" due to a change in log file size.
Explanation: The Rollforward Database utility has stopped rolling forward because the log files have changed in size. It must be restarted to establish the new log file size.
If ",..." is displayed at the end of the node list, see the diagnostic log for the complete list of nodes.
Roll-forward recovery has stopped.
(Note : if you are using a partitioned database server, the node number(s) indicate which node(s) the error occurred on. Otherwise, it is not pertinent and should be ignored.)
User Response: Reissue the ROLLFORWARD command to continue.
SQL6064N SQL error "<sqlcode>" occurred during data redistribution.
Explanation: An error occurred during data redistribution.
The utility stops processing.
User Response: Look at the SQLCODE (message number) in the message for more information. Make any required changes and try the request again.
SQL6065N An error occurred while writing to file "<file>".
Explanation: One of the following conditions was encountered:
The command or the utility cannot be processed.
User Response: Ensure that the file exists and that the file permissions allow write access. Try the command or the utility again.
SQL6067W ROLLFORWARD DATABASE QUERY STATUS command encountered sqlcode "<sqlcode>".
Explanation: The ROLLFORWARD DATABASE QUERY STATUS command encountered an error with the sqlcode "<sqlcode>". The query might not be successful on some nodes for various reasons. The most severe error is indicated by "<sqlcode>". The roll-forward status is only returned for the successful nodes.
User Response: Look up the sqlcode "<sqlcode>" in the DB2 Messages Reference, or online to determine the problems on the failed nodes. Take the required corrective actions, then continue the forward recovery on these nodes.
SQL6068W Rollforward operation was cancelled successfully. The database has to be restored on node(s) "<node-list>".
Explanation: A Rollforward operation was cancelled before it successfully completed, and the database is left in an inconsistent state. The restore pending flag is on for the listed nodes.
If ",..." is displayed at the end of the node list, see the syslog file for the complete list of nodes.
User Response: Restore the database on the listed nodes.
SQL6069N The ROLLFORWARD DATABASE command cannot be submitted on a non-catalog node.
Explanation: The ROLLFORWARD DATABASE command is only accepted on the catalog node.
User Response: Submit the command on the catalog node.
SQL6071N The requested operation cannot be processed because a new node has been added to the system. The system must be stopped and started again before the operation can be done.
Explanation: One of the following:
User Response: Issue db2stop to stop all the nodes. When all nodes are successfully stopped, issue db2start to start all the nodes, including the new node, then try the request again.
sqlcode: -6071
sqlstate: 57019
SQL6072N DB2START with the RESTART option cannot proceed because the specified node is already active.
Explanation: The node specified for restart is already active on the system.
User Response: If necessary, issue a DB2STOP specifying the node to stop and issue the DB2START command again to restart the node.
SQL6073N Add Node operation failed. SQLCODE = "<sqlcode>".
Explanation: The Add Node operation failed with sqlcode "<sqlcode>".
User Response: Check the message associated with the sqlcode that is returned in either the DB2 Messages Reference, or online.
Take any required corrective action, then try the request again.
SQL6074N Add Node operation failed because a Create or Drop Database operation is currently executing.
Explanation: An Add Node operation cannot execute concurrently with a Create or Drop Database operation.
User Response: Wait for the Create or Drop Database operation to complete, then try the request again.
SQL6075W The Start Database Manager operation successfully added the node. The node is not active until all nodes are stopped and started again.
Explanation: The db2nodes.cfg file is not updated to include the new node until all nodes are simultaneously stopped by the STOP DATABASE MANAGER (db2stop) command. Until the file is updated, the existing nodes cannot communicate with the new node.
User Response: Issue db2stop to stop all the nodes. When all nodes are successfully stopped, issue db2start to start all the nodes, including the new node.
SQL6076W Warning! This command will remove all database files on the node for this instance. Before continuing, ensure that there is no user data on this node by running the DROP NODE VERIFY command.
Explanation: This procedure will remove all the database partitions from the specified node.
User Response: Ensure that the DROP NODE VERIFY command was run before dropping this node. If using the API, ensure that the callerac parameter is specified correctly.
SQL6077W The db2stop DROP NODENUM procedure ended successfully, but could not remove all the files. See the file "<file>" for details.
Explanation: The db2stop DROP NODENUM procedure ended successfully, but some user data files are still on the node.
User Response: Information in "<file>" file will indicate the directory structure from which files could not be deleted.
SQL6078N The db2stop DROP NODENUM procedure could not update the database information for database "<dbname>".
Explanation: The db2stop DROP NODENUM procedure could not access the catalog node for database "<dbname>".
User Response: Try the request again. If the problem persists, contact your service representative.
SQL6079W The db2stop DROP NODENUM command was cancelled successfully.
Explanation: The db2stop DROP NODENUM command was stopped before it began processing.
User Response: None.
SQL6080W The Start Database Manager operation successfully added in the node, but no database partitions have been created on the node. The node is not active until all nodes are stopped and started again.
Explanation: The db2nodes.cfg file is not updated to include the new node until all nodes are simultaneously stopped by the STOP DATABASE MANAGER (DB2STOP) command. Until the file is updated, the existing nodes cannot communicate with the new node.
User Response: Issue DB2STOP to stop all the nodes. When all nodes are successfully stopped, issue DB2START to start all the nodes, including the new node. When all nodes are successfully started, the database system can be used.
SQL6081 A communication error caused a DB2STOP FORCE command to time out on this node.
Explanation: A communication error occurred on one or more of the database nodes, causing the DB2STOP FORCE command to time out on the current node, or, DB2STOP FORCE terminated because a severe error occurred during FORCE on one or more nodes. Any node where the communication error occurred will receive the SQL6048N message.
User Response: Do the following: