Cause: The Catalog Database command specified node name "<name>" but that is not cataloged in the node directory. The node name must be cataloged before the remote database can be used.
The CATALOG DATABASE command completed successfully.
Action: Issue a CATALOG NODE command.
Cause: A connection to the remote database "<name>" on node "<node-name>" was requested, and the remote node does not accept the authorization ID and password combination specified for this node (either in the remote authorization tables or at runtime).
The request cannot be processed.
Action: Resubmit the request with a valid authorization ID and password combination for the remote system.
Cause: No database name was provided to proceed with migration.
The statement cannot be processed.
Action: Specify a database name for migration.
Cause: The Migrate command completed successfully.
Note that this message will also be returned if the database was already at the current level and did not need to be migrated.
Processing continues.
Action: No action is required.
Cause: The application program has used an address for the program name that is not valid.
The command cannot be processed.
Action: Use a correct address in the application program.
Cause: The remote application procedure contains an SQL CONNECT RESET statement.
The remote procedure is not allowed to continue.
Action: Remove the SQL CONNECT RESET statement and retry the remote procedure.
sqlcode: -1105
sqlstate: 42987
Cause: The function within the DLL (dynamic link library) cannot be found.
The command cannot be processed.
Action: Ensure that the DLL module is built correctly. Reference the module in the definition file.
sqlcode: -1106
sqlstate: 42724
Cause: When loading the DLL (dynamic link library) module, the command was interrupted, perhaps by Ctrl+Break.
Processing is stopped.
Action: Resubmit the command.
sqlcode: -1107
sqlstate: 42724
Cause: An unexpected error occurred when trying to load the DLL (dynamic link library) module specified in the program name field.
The command cannot be processed.
Action: Resubmit the current command. If the error continues, reinstall the database manager.
If reinstallation does not correct the error, record the message number (SQLCODE) and all information in the SQLCA if possible.
If trace was active, invoke the Independent Trace Facility at the operating system command prompt. Refer to the Independent Trace Facility in the Troubleshooting Guide for information on how to use this facility. Then contact your technical service representative.
sqlcode: -1108
sqlstate: 42724
Cause: The DLL (dynamic link library) module specified could not be found.
The command cannot be processed.
Action: Ensure that the specified file is in a subdirectory identified in the system LIBPATH.
sqlcode: -1109
sqlstate: 42724
Cause: The data area is not initialized correctly.
The command cannot be processed.
Action: Ensure that the user-supplied input SQLDA or output SQLDA fields are initialized correctly.
Cause: The DLL (dynamic link library) module or program name syntax is not correct.
The command cannot be processed.
Action: Ensure that the DLL or program name is specified correctly.
sqlcode: -1111
sqlstate: 42724
Cause: There is not enough random access memory (RAM) to load the specified DLL (dynamic link library) module.
The command cannot be processed.
Action: Stop the application. Possible solutions are:
sqlcode: -1112
sqlstate: 42724
Cause: The remote stored procedure changed the data type of the nth sqlvar in the output SQLDA; n is the sequence number of the first mismatched sqlvar.
The stored procedure does not return any data.
Action: Correct the remote stored procedure so the data type information in the output SQLDA is not changed.
sqlcode: -1113
sqlstate: 39502
Cause: The remote stored procedure changed the data length of the nth sqlvar in the output SQLDA; n is the sequence number of the first mismatched sqlvar.
The stored procedure does not return any data.
Action: Correct the remote stored procedure so the data length information in the output SQLDA is not changed.
sqlcode: -1114
sqlstate: 39502
Cause: The remote procedure changed the sqld field in the output SQLDA; sqld is the number of used sqlvars in the SQLDA.
The stored procedure does not return any data.
Action: Correct the remote stored procedure so the sqld field in the output SQLDA is not changed.
sqlcode: -1115
sqlstate: 39502
Cause: The specified database requires a backup to be taken to provide a starting point for roll-forward recovery.
No connection was made.
Action: Back up the database by calling the BACKUP routine or, if roll-recovery is not required, set the log retain and user exit database configuration parameters off.
sqlcode: -1116
sqlstate: 57019
Cause: The specified database is enabled for roll-forward recovery and it has been restored but not rolled forward.
No connection was made.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Roll forward the database or indicate that you do not wish to roll forward by using the ROLLFORWARD command. Note that if you do not roll forward the database, the records written since the last backup of the database will not be applied to the database.
DataJoiner users: if necessary isolate the problem to the data source rejecting the request (see the Problem Determination Guide for procedures to follow to identify the failing data source) and take recovery action appropriate to that data source to bring the data source to a point of consistency.
sqlcode: -1117
sqlstate: 57019
Cause: The database is in an inconsistent state because a system error occurred during a backup function.
No connection was made.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Issue the BACKUP command and then try the command again.
DataJoiner users: if necessary isolate the problem to the data source rejecting the request (see the Problem Determination Guide for procedures to follow to identify the failing data source) and issue the BACKUP command against that data source prior to trying the command again.
sqlcode: -1118
sqlstate: 57019
Cause: The database is in an inconsistent state because a system error occurred during a restore function.
No connection was made.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Issue the RESTORE command and then try the command again.
DataJoiner users: if necessary isolate the problem to the data source rejecting the request (see the Problem Determination Guide for procedures to follow to identify the failing data source) and issue the RESTORE command against that data source prior to trying the command again.
sqlcode: -1119
sqlstate: 57019
Cause: The database is in an inconsistent state because a system error occurred during a backup or restore function. It cannot be determined if backup or restore was being processed.
No connection was made.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Issue the BACKUP or RESTORE command, and then try the command again.
DataJoiner users: if necessary isolate the problem to the data source rejecting the request (see the Problem Determination Guide for procedures to follow to identify the failing data source) and issue the BACKUP or RESTORE command against that data source prior to trying the command again.
sqlcode: -1120
sqlstate: 57019
Cause: The application used an address for the node structure parameter that is not valid. Either the address points to an unallocated buffer or the buffer is not large enough to contain the required input.
The command cannot be processed.
Action: Verify that the program allocates the required buffer area and resubmit the command.
Cause: The application used an address for the protocol structure parameter that is not valid. Either the address points to an unallocated buffer or the address points to the incorrect protocol buffer.
The command cannot be processed.
Action: Verify that the program allocates the required buffer area based on the protocol field in the node structure and resubmit the command.
Cause: The protocol type specified in the node structure for the Catalog command does not represent a recognized value. The valid protocol types are defined in the sqlenv header files.
The command cannot be processed.
Action: Verify the protocol type in the node structure and resubmit the command.
Cause: The remote workstation name specified in the NETBIOS protocol structure for the Catalog command is not specified or contains characters that are not valid. The workstation name must be 1 to 8 characters. Valid characters are A through Z, a through z, 0 through 9, #, @, and $. The first character must be alphabetic or a special character: #, @, or $. Lowercase characters are changed to uppercase by the system.
The command cannot be processed.
Action: Verify the characters specified in the remote workstation name. Resubmit the command with a valid workstation name.
Cause: The adapter number specified in the NETBIOS protocol structure for the Catalog command is not valid.
The command cannot be processed.
Action: Verify that the adapter number is valid and resubmit the command.
Cause: The network ID specified in the APPN protocol structure for the Catalog command is not valid. The network ID identifies the SNA network where the remote logical unit (LU) resides. The network ID must be 1 to 8 characters. Valid characters are A through Z, a through z, 0 through 9, #, @, and $. The first character must be alphabetic or a special character: #, @, or $. Lowercase characters are changed to uppercase by the system.
The command cannot be processed.
Action: Verify the characters specified in the network ID. Resubmit the command with a valid network ID.
Cause: The remote logical unit (LU) name specified in the APPN protocol structure for the Catalog command is not valid. The remote LU name is the remote SNA logical unit name and must be 1 to 8 characters. Valid characters are A through Z, a through z, 0 through 9, #, @, and $. The first character must be alphabetic or a special character: #, @, or $. Lowercase characters are changed to uppercase by the system.
The command cannot be processed.
Action: Verify the characters specified in the remote LU name. Resubmit the command with a remote LU name.
Cause: New DARI (Stored Procedure) process could not be started because there are insufficient resources for a new process to be created.
Action: Do one of the following:
sqlcode: -1129
sqlstate: 42724
Cause: New DARI (Stored Procedure) process could not be started because the maximum number of DARI processes allowed to be present at the server at the same time has been reached.
Action: Increase the maximum number of DARI processes, maxdari, configuration parameter. See the database configuration parameter maxdari for more details.
sqlcode: -1130
sqlstate: 42724
Cause: The cause of this error may be:
Action: Reinitiate the DARI request after doing the following :
sqlcode: -1131
sqlstate: 38503
Cause: An illegal command has been made within the scope of DARI (Stored Procedure).
The DARI procedure is not allowed to continue.
Action: Remove the illegal command in the DARI procedure and retry.
sqlcode: -1132
sqlstate: 42987
Cause: The "sqlind" or the "sqldata" pointer within the sqlvar of the output SQLDA has been altered within the user prepared DARI function.
The stored procedure does not return any data.
Action: Correct the usage of the indicated sqlvar within the output SQLDA so that pointer addresses are not changed within the DARI (Stored Procedure) function routine.
sqlcode: -1133
sqlstate: 39502
Cause: All SYSADM commands are not allowed to execute within DARI (Stored Procedure) when the database authentication type is CLIENT.
The stored procedure does not return any data.
The DARI procedure is not allowed to continue.
Action: Remove the illegal command in the DARI procedure and retry.
sqlcode: -1134
sqlstate: 42987
Cause: The value that was specified for the number of segments was out of range. The valid range is from 1 to 256.
Action: Respecify the number of segments and try to create the database again.
Cause: The value that was specified for the default table space extent size (dft_extentsize) is out of range. The valid range is from 2 to 256.
Action: Correct the table space extent size and try again.
Cause: Either the list of containers could not be accessed or some failure occurred while attempting to remove them or the database directory.
Action: System managed containers (directories) and database managed file containers may be manually removed using operating system commands. To release device containers, please call your IBM service representative for assistance.
If the log directory has been changed via the New Log Path configuration parameter, then manually unmount the log directory file system and remove the log and database directories.
Cause: A CREATE INDEX operation was attempted on an existing index. Since the index had not yet been migrated to support deferred uniqueness checking, this migration was performed.
The migrated format of the unique index will allow multiple row updates to check the uniqueness of the columns of the index at the end of the update statement instead of when each row is updated.
Action: No action is required.
sqlcode: +1138
sqlstate: 01550
Cause: The size of the current table space is too big. The size of a REGULAR table space is limited to 0xFFFFFF (16777215) pages while the size of a TEMPORARY/LONG table space is limited to 2 tera bytes (2 TB).
Action: Check the diagnostic log file db2diag.log for details. Reduce the size of the table space and correct the SQL statement.
sqlcode: -1139
sqlstate: 54047
Cause: The application program used an address that is not valid for this parameter. Either the address points to an unallocated buffer or the character string in the buffer does not have a null terminator.
The command cannot be processed.
Action: Ensure that a valid address is used in the application program and the input string is null terminated.
Cause: The Terminate and Stay Resident (TSR) network driver for the specified communications protocol has not been loaded. The TSR must be loaded before attempting to use network communications.
Action: Ensure that the TSR for the specified communications protocol has been successfully loaded, then run your application again.
Cause: An error occurred while processing the SQLDA or host variable(s) in the SQL statement.
The call parameter list, which is created by the precompiler, may not be correct if the application programmer has modified the output of the precompiler, used a variable name beginning with SQL in the application program, or over-written the call parameter list in another way.
Also, if an SQLDA is passed directly by the application, it may not be initialized correctly.
Host variable/SQLDA types:
In SQL statements with host variables, use the host variable number to count in from the beginning of the statement (or substatement, in the case of compound SQL) to locate the invalid host variable. For statements using an SQLDA, the SQLVAR number is used to locate the invalid SQLVAR. For an input SQLDA, count only input host variables or SQLVARs; similarly for output. Note that this number is based at 1, and may not be applicable to all reason codes. Reason codes are interpreted as follows:
The statement cannot be processed.
Action: Examine the application program for any errors noted. Note that the programmer should not attempt to modify the precompiler output.
sqlcode: -1164
sqlstate: 07002
Cause: A FETCH, VALUES, or SELECT into a host variable list failed because the host variable was not large enough to hold the retrieved value.
The statement processing continued returning a null indicator of -2.
Action: Verify that table definitions are current and that the host variable has the correct data type. For the ranges of SQL data types, refer to the SQL Reference.
sqlcode: +1165
sqlstate: 01515
Cause: The processing of an arithmetic expression resulted in division by zero. This warning may be returned with a row other than the row which caused the warning. For example, this occurs with arithmetic expressions in predicates or when the query is processed using temporary tables. The warning may be issued again since it is also returned whenever a null indicator variable is set to -2.
The statement processing continued, using null as the result of the division expression and possibly returning a null indicator of -2.
Action: Examine the SQL statement to determine the cause of the problem. If the problem is data dependent, it is necessary to examine the data processed when the error occurred.
sqlcode: +1166
sqlstate: 01564
Cause: The processing of an arithmetic expression has resulted in an arithmetic overflow, underflow or other arithmetic exception. This warning may be returned with a row other than the row which caused the warning. For example, this occurs with arithmetic expressions in predicates or when the query is processed using temporary tables. The warning may be issued again since it is also returned whenever a null indicator variable is set to -2.
The statement processing continued, using null as the result of the arithmetic expression and possibly returning a null indicator of -2.
Action: Examine the SQL statement to determine the cause of the problem. If the problem is data dependent, it is necessary to examine the data processed when the error occurred. Refer to the SQL Reference to see the valid ranges for the data types.
sqlcode: +1167
sqlstate: 01519
Cause: DB2 received an OLE error code while trying to communicate with the OLE automation server of user defined function (UDF) "<function-name>" (specific name "<specific-name>"). HRESULT "<hresult>" is the returned OLE error code, and "<message text>" is the retrieved error message.
The following shows a partial list of error messages, HRESULTS, and possible causes. The error message text may be changed by OLE, and new error codes may be added by OLE.
Action: Consult the OLE Programmer's Reference Guide for a complete documentation, including the meaning of the special terminology.
sqlcode: -1180
sqlstate: 42724
Cause: The user defined function (UDF) "<function-name>" (specific name "<specific-name>") has raised an exception. The message text shows the textual description of the exception returned by the UDF.
Action: The user will need to understand the meaning of the exception. See the author of the UDF.
sqlcode: -1181
sqlstate: 38501