Cause: The alias specified in the command or api is not valid. The alias must contain 1 to 8 characters (bytes in MBCS countries) and all the characters must be from the database manager base character set.
The command cannot be processed.
Action: Resubmit the command with the correct alias.
Cause: The syntax of the database name specified in the command is not valid. The database name must contain 1 to 8 characters and all the characters must be from the database manager base character set.
The command cannot be processed.
Action: Resubmit the command with the correct database name.
sqlcode: -1001
sqlstate: 2E000
Cause: The drive specified in the command is not valid. The drive is a single character (A to Z) indicating the diskette drive or fixed-disk partition where the database or database directory is located.
The command cannot be processed.
Action: Resubmit the command with the correct drive.
Cause: The length of the password is expected to be 18 characters or less. However, if the password is to be verified for an APPC conversation, it must be 8 characters or less.
Action: Ensure that the password is not longer than the limit allowed.
sqlcode: -1003
sqlstate: 28000
Cause: There is not enough storage on the specified file system to process the command.
In a partitioned database environment on OS/2 and Windows environments, each node in the partitioned database group must have the exact same physical hard drive specification (letter) available and useable (must contain useable space) for the CREATE DATABASE command to succeed. The physical hard drive letter is specifed in the database manager configuration. If this field is left blank the default will be the hard drive where DB2 is installed on the instance owning machine (sqllib path).
The command cannot be processed.
Action: Choose a different file system or erase some non-database files from the specified file system to make space for the database manager functions.
In a partitioned database environment on OS/2 and Windows environments, follow the following steps:
Cause: The alias name specified has already been used. If no alias is specified in the catalog database command, the database name is used as the alias. When a database is created, the alias name is the same as the database name.
This error may occur on the catalog database command when the alias already exists in the system database directory.
On the create database command this error may occur in one of the following situations:
Action: For the catalog database command, uncatalog the alias from the system database directory and resubmit your original command or catalog the database with a different alias name.
For the create database command, do the following operations with respect to the above 3 situations:
Cause: The application could not connect to the database because the active codepage is different from the one that was active when the database was created.
The command cannot be processed.
Action: Exit the current application program and return to the operating system. Change the code page for the process and restart the application program.
Cause: There are corrupted internal database pages or internal logic error for a table space. Details can be found in the system error log and/or the database manager error log.
Action: Discontinue use of the object or table space. Contact IBM service to inspect the object and the table space.
sqlcode: -1007
sqlstate: 58034
Cause: The table space ID specified does not exist. It is either larger than the current maximum table space ID, or the table space has been dropped.
Action: Discontinue use of the database. Save the diagnostic information in the error log and contact IBM service.
sqlcode: -1008
sqlstate: 58036
Cause: The command is not supported when issued on a client-only workstation or against remote databases. An example of such a command is cataloging a local database.
The command cannot be processed.
Action: Possible solutions include:
Cause: The type specified in the Database Environment command is not valid. It must be '0' for an indirect database or '1' for a remote database.
In addition, on the Unix, OS/2, Windows NT, and Windows 95 platforms, the type can be '3' for a database that has a DCE global name.
The command cannot be processed.
Action: Resubmit the command with a valid type.
Cause: A CATALOG DATABASE command was issued for an indirect entry but no path was specified. Indirect entries must specify the path where the database resides.
The command cannot be processed.
Action: Resubmit the command with the required path or change the type.
Cause: There was no nodename parameter specified in the CATALOG DATABASE command for a remote entry. Remote entries must specify the node name of the database.
The command cannot be processed.
Action: Resubmit the command with the nodename parameter or a different type.
Cause: The database name or alias specified in the command is not an existing database or the database could not be found in the (client or server) database directories.
Action: Ensure that the specified database name exists in the system database directory. If the database name does not exist in the system database directory, then the database either does not exist or the database name has not been cataloged.
If the database name appears in the system database directory and the entry type is INDIRECT, ensure that the database exists in the specified local database directory. If the entry type is REMOTE, then ensure that the database exists and is cataloged on the database directories of the server node.
For CREATE DATABASE with the AT NODE clause, ensure that the database name is in the system database directory with an entry type of INDIRECT and with a catalog node number that does not equal -1.
DataJoiner users: in addition to the above, verify that the database names specified in SYSCAT.SERVERS are all valid. Correct any SYSCAT.SERVERS entry for which the database specified in that entry does not exist.
sqlcode: -1013
sqlstate: 42705
Cause: The scan of the directory, file, or list is finished.
Action: No action is required.
Cause: The database must be restarted because of an abnormal termination of the previous session (for example, a power failure).
The command cannot be processed.
Action: On receipt of this message (SQLCODE), an application can post a message warning the user that it takes time to recover the database. To restart the database, issue the RESTART DATABASE command. In a partitioned database server environment, the command must be issued on all nodes.
sqlcode: -1015
sqlstate: 55025
Cause: The local logical unit (local_lu) alias specified in the CATALOG NODE command is not permitted. The local logical unit alias is the local SNA logical unit alias and must be 1 to 8 characters and cannot contain blank characters.
The command cannot be processed.
Action: Verify that the alias is a permitted logical unit name. Verify the characters used in the name. Resubmit the command with a valid logical unit name.
Cause: The mode specified in the CATALOG NODE command is not permitted.
The mode parameter identifies the communications profile the Communications Manager uses to set up a session. The mode must be 1 to 8 characters. Valid characters are uppercase or lowercase A through Z, 0 through 9, #, @, and $. The first character must be alphabetic. The system changes lowercase characters to uppercase.
The command cannot be processed.
Action: Verify that the name is a permitted mode name. Verify the characters used in the name. Resubmit the command with a correct mode.
Cause: The node name specified in the nodename parameter of the CATALOG NODE command is already cataloged in the node directory on this file system.
The command cannot be processed.
Action: If the nodename parameter is typed correctly, continue processing.
Uncatalog the cataloged node in the node directory if the node cataloged information is no longer valid and resubmit the command. If the node cataloged information is valid, define a new node name and resubmit the command using the new node name.
Cause: The node name specified in the command is not valid. The node name may be 1 to 8 characters and all of the characters must be from the database manager base character set.
The command cannot be processed.
Action: Resubmit the command with the correct node name.
Cause: The node directory cannot hold any more entries.
The command cannot be processed.
Action: Uncatalog any unnecessary entries in the node directory.
Cause: The nodename specified in the command could not be found in the node directory.
The command cannot be processed.
Action: If the nodename parameter is correct, the node may already have been uncataloged, and processing can continue. Otherwise, resubmit the command with the correct node name.
Cause: Not enough random access memory (RAM) is available to process the command.
If a remote procedure was invoked, the remote procedure may use a local variable space that is larger than the allowable maximum (4K).
If the statement involves a user-defined function (UDF), the memory set controlled by the udf_mem_sz database manager configuration parameter may be larger than the memory available.
The command cannot be processed.
Action: Stop the application. Possible solutions include:
NOTE: This is applicable only for releases of DB2 prior to Version 2.
sqlcode: -1022
sqlstate: 57011
Cause: An error occurred in the communications conversation.
The command cannot be processed.
Action: Retry the original command. If the error persists, contact your communications administrator.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
sqlcode: -1023
sqlstate: 08001
Cause: There is no connection to a database. Other SQL statements cannot be processed unless an SQL CONNECT was previously executed.
The command cannot be processed.
Action: If the error occurred when disconnecting from the database, continue processing. If the error occurred on another SQL statement, issue an SQL CONNECT statement and resubmit the command or statement.
sqlcode: -1024
sqlstate: 08003
Cause: The stop database manager command cannot be processed if there are any applications connected to databases under control of the database manager, or if any databases have been activated.
No action is taken.
Action: Usually no action is required. To stop the database manager, all active applications must disconnect from all the databases they are using. Alternatively, the user can use the FORCE command to force applications to disconnect, and the DEACTIVATE command to deactivate the database.
Cause: A start database manager command is already processed.
The command cannot be processed.
Action: Because the command is already processed, the application may continue processing.
Cause: The list node directory command cannot be processed because the node directory could not be found.
The command cannot be processed.
Action: Issue a CATALOG NODE command with the appropriate parameters and resubmit the current command.
Cause: The partner_lu alias specified in the CATALOG NODE command was not specified or contains characters that are not valid. The partner_lu alias is the partner SNA logical unit alias and must be 1 to 8 characters and must not contain blank characters.
The command cannot be processed.
Action: Examine the partner_lu for a typing error. Verify that the alias is a permitted logical unit name. Verify the characters used in the alias. Resubmit the command with a correct partner_lu.
Cause: Either the system database directory or the local database directory cannot hold any more entries.
The command cannot be processed.
Action: Uncatalog any unnecessary entries in the directory. Create new databases on another file system if the local database directory is full.
Cause: The system database directory or local database directory could not be found. A database has not been created or it was not cataloged correctly.
The command cannot be processed.
Action: Verify that the database is created with the correct path specification. The Catalog Database command has a path parameter which specifies the directory where the database resides.
sqlcode: -1031
sqlstate: 58031
Cause: The start database manager command has not been processed. It must be processed before a stop database manager, any SQL statement, or utility can be issued.
The command cannot be processed.
Action: Issue a start database manager command and resubmit the current command.
If using multiple logical nodes, ensure the DB2NODE environment variable is set correctly. The DB2NODE environment variable indicates the node the application will attempt to connect to. DB2NODE must be set to the node number of one of the nodes defined on the same host as the application.
sqlcode: -1032
sqlstate: 57019
Cause: The database directory cannot be accessed if it is currently being updated. Also, the directory cannot be accessed for update if it is already being accessed for any reason. This situation could exist with either the system database directory or the local database directory.
The command cannot be processed.
Action: Wait until the access has completed, then resubmit the command.
sqlcode: -1033
sqlstate: 57019
Cause: Damage has occurred to the database. It cannot be used until it is recovered. All applications connected to the database have been disconnected and all processes running applications on the database have been stopped.
The command cannot be processed.
Action: Issue a RESTART DATABASE command to recover the database. If the RESTART command consistently fails, you may want to restore the database from a backup. In a partitioned database server environment, check the syslog to find out if the RESTART command fails because of node or communication failures before restoring the database from a backup. If so, ensure the database manager is up and running and communication is available among all the nodes, then resubmit the restart command.
If you encountered this error during roll-forward processing, you must restore the database from a backup and perform roll-forward again.
Note that in a partitioned database environment, the RESTART database command is run on a per-node basis. To ensure that the database is restarted on all nodes, use the command:
db2_all db2 restart database <database_name>
This command may have to be run several times to ensure that all in-doubt transactions have been resolved.
If you are installing the sample database, drop it and install the sample database again.
sqlcode: -1034
sqlstate: 58031
Cause: One of the following conditions exists:
The command cannot be processed.
Action: Possible solutions include:
sqlcode: -1035
sqlstate: 57019
Cause: At least one database file has an I/O error:
The database cannot be used.
Action: If the error occurred during the processing of a database, resubmit the command. If the error continues, restore the database from a backup version.
If the error occurred during CREATE DATABASE or DROP DATABASE, a subsequent CREATE DATABASE or DROP DATABASE command attempts to erase files and directories left from the unsuccessful CREATE DATABASE or DROP DATABASE command.
If installing the sample database, drop it and install the sample database again.
If the error occurred while trying to connect to a database, get a trace and call IBM support for the possibility of recovering the database.
sqlcode: -1036
sqlstate: 58030
Cause: An attempt was made to read the contents of the node directory, but no entries existed.
Action: No action is required.
sqlcode: +1037
sqlstate: 01606
Cause: The node directory could not be accessed because of an I/O error.
The command cannot be processed.
Action: Resubmit the command. If the error continues, remove the node directory (sqlnodir under the sqllib directory) and recatalog the node names on the network.
sqlcode: -1038
sqlstate: 58031
Cause: Either the system database directory or the local database directory cannot be accessed. This error may occur not only when the system is cataloging or uncataloging a database but also when the system is accessing a database that is cataloged in the directory.
The command cannot be processed.
Action: Possible solutions include:
If installing the sample database, drop it and install the sample database again.
sqlcode: -1039
sqlstate: 58031
Cause: The number of applications connected to the database is equal to the maximum value defined in the configuration file for the database.
The command cannot be processed.
Action: Wait for other applications to disconnect from the database. If more applications are required to run concurrently, increase the value for maxappls. After all applications disconnect from the database and the database is restarted, the new value takes effect.
sqlcode: -1040
sqlstate: 57030
Cause: The application attempted to start an inactive database but the number of active databases already equals the maximum value defined in the system configuration file.
The command cannot be processed.
Action: Wait for one of the databases to become inactive. If more databases are required to be active at the same time, increase the value for numdb. The new value takes effect after the next successful database manager start.
sqlcode: -1041
sqlstate: 57032
Cause: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
Action: If the error occurred on OS/2 while trying to start the database manager, and the NET.ACC file is suspected, replace the NET.ACC files on the system with those on diskette 1 of the DB2 for OS/2 installation diskettes.
If the error occurred while trying to connect to a database, get a trace (instructions below) and call IBM support.
If the problem falls outside of the above suggestions, ensure that the system time and date is correctly set, and make sure your system has enough memory and swapping/paging space available.
Resubmit the current command.
If the error continues, stop the database manager and restart it.
If the error still continues, reinstall the database manager.
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. Contact your technical service representative with the following information:
Required information:
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). If the problem is with a data source follow the problem determination procedures for that data source.
sqlcode: -1042
sqlstate: 58004
Cause: The CREATE DATABASE command failed while initializing the system catalogs.
Action: Record the message number (SQLCODE) and error in this message.
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 with the following information:
Cause: The user may have pressed the interrupt key sequence.
Processing is stopped.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Continue processing to handle the interrupt.
If installing the sample database, drop it and install the sample database again.
If starting the database manager, issue a db2stop before issuing any db2 commands.
sqlcode: -1044
sqlstate: 57014
Cause: An indirect entry in the database directory points to another non-HOME entry.
The command cannot be processed.
Action: Verify the entries in all the associated database directories with the directory scan commands.
sqlcode: -1045
sqlstate: 58031
Cause: The authorization specified at logon is not valid for either the data source or the database manager. One of the following occurred:
The command cannot be processed.
Action: Log on with a valid authorization ID.
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 use an authorization ID valid for that data source.
sqlcode: -1046
sqlstate: 28000
Cause: An application cannot create a database while connected to another database.
Binding a bind file to one database while already connected to another database is not permitted.
The command cannot be processed.
Action: Disconnect from the active database and resubmit the command.
Cause: The use parameter in the START USING DATABASE or CONNECT TO command must be either an S for shared or an X for exclusive use. If connecting to a database using DB2 Connect, only shared access is allowed. Mnemonic equates for these values are provided in the SQLENV.H file.
The command cannot be processed.
Action: Resubmit the command with a valid use parameter (preferably from the mnemonic equates).
Cause: The connection to the database has been lost.
The command cannot be processed.
Action: Issue a CONNECT RESET statement.
Cause: The database specified in the UNCATALOG DATABASE command is a home database. Home databases cannot be uncataloged because their directory entries are deleted when the database is dropped.
The command cannot be processed.
Action: Continue processing if the database name was specified correctly.
Cause: The path specified in the database directory parameter of the command or in the database directory entry is not valid. There is no file system with that name.
The command cannot be processed.
Action: Resubmit the command with the correct path for the database directory.
sqlcode: -1051
sqlstate: 57019
Cause: The path specified in the path parameter of the command is not valid. There is no path with that name.
In a partitioned database environment on OS/2 and Windows environments, each node in the partitioned database group must have the exact same physical hard drive specification (letter) available and useable (must contain useable space) for the CREATE DATABASE command to succeed. The physical hard drive letter is specifed in the database manager configuration. If this field is left blank the default will be the hard drive where DB2 is installed on the instance owning machine (sqllib path).
The command cannot be processed.
Action: Resubmit the command with the correct database path.
In a partitioned database environment on OS/2 and Windows environments, follow the following steps:
Cause: The system is currently processing an interrupt so another interrupt is not honored.
The interrupt request is ignored.
Action: Wait until the current interrupt processing finishes and resubmit the command.
Cause: The system is currently processing a COMMIT. The user entered an interrupt key sequence.
The interrupt request is ignored.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Wait until COMMIT is finished and resubmit the request.
Cause: The system is currently processing a ROLLBACK. The user entered an interrupt key sequence.
The interrupt request is ignored.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Wait until ROLLBACK is finished and resubmit the request.
Cause: Eight database directory scans in this process are already open. No more than eight open scans are allowed.
The command cannot be processed.
Action: Issue one or more CLOSE DIRECTORY SCAN commands and resubmit the command.
sqlcode: -1056
sqlstate: 54029
Cause: An attempt was made to read the contents of the system database directory, but no entries existed.
Action: No action is required.
sqlcode: +1057
sqlstate: 01606
Cause: The handle parameter specified in the Directory Scan command is not valid. The handle must be the one returned from the OPEN DIRECTORY SCAN or the OPEN NODE DIRECTORY SCAN command.
The command cannot be processed.
Action: Resubmit the command with a valid handle parameter.
Cause: A directory scan command was issued before the scan was opened.
The command cannot be processed.
Action: Issue an OPEN DIRECTORY SCAN or OPEN NODE DIRECTORY SCAN command and resubmit the current command.
Cause: The specified authorization does not have the CONNECT privilege to access the database. The CONNECT privilege must be granted before the user can connect to a database.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
The command cannot be processed.
Action: Contact the system administrator or database administrator for the database and request a GRANT CONNECT for the authorization ID. Resubmit the command.
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 ensure that correct authorizations exist on that data source.
sqlcode: -1060
sqlstate: 08004
Cause: A RESTART was successfully completed, except indoubt transactions were discovered. The database is usable, but if the indoubt transactions are not resolved before the last connection to the database is dropped, then the database will again require a RESTART before it can be used.
Action: Either resolve the indoubt transactions, or be prepared to RESTART the database whenever you wish to use it. If the transaction manager (TM) that was using the database (in an XA/DTP environment) is available, then the administrator should instruct the TM to resolve the indoubt transactions. Alternatively, with great caution, the administrator can use the CLP to heuristically complete the transactions.
Note that in a partitioned database server environment, the RESTART database command is run on a per-node basis. In order to ensure that the database is restarted on all nodes, use the following command:
db2_all db2 restart database <database_name>
Issuing the above command will resolve any in-doubt transactions if all nodes are operational.
This command may have to be run several times to ensure that all in-doubt transactions have been resolved.
Cause: The database path parameter specified in the command does not exist. If the path is not specified, the default path defined in the system configuration file is used, and it does not exist.
In a partitioned database environment on OS/2 and Windows environments, each node in the partitioned database group must have the exact same physical hard drive specification (letter) available and useable (must contain useable space) for the CREATE DATABASE command to succeed. The physical hard drive letter is specifed in the database manager configuration. If this field is left blank the default will be the hard drive where DB2 is installed on the instance owning machine (sqllib path).
The command cannot be processed.
Action: Verify the path or the default path and make sure they exist in the system. Resubmit the command.
In a partitioned database environment on OS/2 and Windows environments, follow the following steps:
Cause: The command to start the database manager completed successfully.
Cause: The command to stop the database manager completed successfully.
Cause: One or more utilities were not bound to the database. The list file "<list-name>" contains a list of the bind files. The numbers in "<list>" indicate the relative positions of the unbound files in the list file.
The listed utility bind files are not bound to the newly created database.
Action: The user may bind the indicated utilities to the database. The format option must not be used on the binder call.
Cause: The IPX/SPX protocol support was not successfully started. Remote clients cannot use IPX/SPX to connect to the server. Possible causes are:
Action: Ensure that the workstation is logged in to the NetWare file server, and has sufficient authority to create an object in the bindery at the file server. The user must be logged in as SUPERVISOR or equivalent. Also ensure that the object name specified in the database manager configuration file is unique for all database managers in the network. Make any corrections, run DB2STOP, and then run DB2START again.
If the problem continues, at the operating system command prompt type DB2TRC ON -L 0X100000. Run DB2START again, then at the command prompt, type DB2TRC DUMP filename to save the trace information. To turn trace off, type DB2TRC OFF. Contact your service coordinator with the trace information.
Cause: The IPX/SPX protocol support was not successfully stopped. Possible causes are:
Action: Ensure that the workstation is logged in to the NetWare file server, and has sufficient authority to delete an object in the bindery at the file server. The user must be logged in as SUPERVISOR or equivalent. Make any corrections, and run DB2STOP again.
If the problem continues, at the operating system command prompt type DB2TRC ON -L 0X100000. Run DB2STOP again, then at the command prompt, type DB2TRC DUMP filename to save the trace information. To turn trace off, type DB2TRC OFF. Contact your service coordinator with the trace information.
Cause: The database is not a local database. A local database is cataloged as indirect in the system database directory and this entry references a home entry in the local database directory on the same node. Remote databases cannot be dropped.
The command cannot be processed.
Action: If the specified database name was incorrect, resubmit the command with the correct database name. If the specified database name was correct and the intent is to remove the database name from the database directory, use the UNCATALOG DATABASE command.
Cause: The application program used an address that is not valid for the database name 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: Correct the application program so a correct address is used and the input string is null terminated.
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 request failed because the database manager resources are in an inconsistent state. This can occur if:
Action: Resource cleanup may be required:
Cause: The node directory release number does not match the product expected release number. The node directory could be from a previous release.
Action: Re-catalog all the node entries and try the command again.
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 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 application program used an address that is not valid for the count parameter.
The command cannot be processed.
Action: Ensure that a valid address is used in the application program.
Cause: The application program used an address that is not valid for the handle parameter.
The command cannot be processed.
Action: Ensure that a valid address is used in the application program.
Cause: The application program used an address that is not valid for the buffer parameter.
The command cannot be processed.
Action: Ensure that a valid address is used in the application program.
Cause: The application program used a nname parameter address that is invalid. 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 application program used an address that is not valid for the local_lu name 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 application program has used an address that is not valid for the partner_lu 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 application program has used an address that is not valid for the mode 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 application issued a CREATE DATABASE command, but the database descriptor block (DBDB) could not be processed for one of the following reason codes:
The command cannot be processed.
Action: Correct the error and resubmit the command.
Cause: The database manager could not allocate segments while processing a Database Environment command or an SQL CONNECT statement.
The dbheap parameter may be too small.
Action: Record the message number (SQLCODE). The cause of this error may be insufficient memory resources either for the database manager or the environment where operation of the database manager is being attempted. Validate that sufficient memory resources are available to satisfy the database manager requirements. You may also close any background processes that do not need to be active.
If sufficient memory resources exist and the problem continues, 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. Contact your technical service representative with the following information:
Required information:
sqlcode: -1084
sqlstate: 57019
Cause: The application could not connect to the database because the database manager could not allocate the number of application heap 4K pages specified in the database configuration file. The system is out of 4K pages. The command cannot be processed.
Action: Possible solutions are:
sqlcode: -1085
sqlstate: 57019
Cause: The command received an error from the operating system that prevents further processing.
The command cannot be processed.
Action: Refer to the operating system user publications to determine the nature of the error.
Cause: CREATE DATABASE could not open the list file containing the list of utility bind files. The list file should be located in the bnd subdirectory of the sqllib subdirectory.
The utility bind files are not bound to the newly created database.
Action: Bind the utilities to the database. Do not use the format option on the binder call.
Cause: CREATE DATABASE or MIGRATE DATABASE could not bind the utility bind files to the database.
The utility bind files are not bound to the newly created or migrated database.
Action: Bind the utilities to the database. Do not use the format option on the binder call.
Cause: CREATE DATABASE was interrupted while binding the utilities to the database. The interrupt key sequence may have been pressed.
The utility bind files are not bound to the newly created database.
Action: Bind the utilities to the database. Do not use the format option on the binder call.
Cause: The release number of the precompiled application program or utility is not compatible with the release number of the installed version of the database manager.
The error will also occur if the application program is using down-level database manager libraries or DLLs while accessing the installed version of the database manager configuration file.
The command cannot be processed.
Action: Verify that there is no older version of the database manager libraries or DLLs that will be picked up for your application processing.
If the problem persist, repeat the precompile process, if possible, with the current database manager and use only application programs. precompiled with a compatible release level of database manager.
Cause: The release number of the database is not compatible with the release number of the installed version of the database manager.
The command cannot be processed. If the error occurred during a Migrate or Restore, you are attempting to migrate or restore an incompatible release of database.
Action: Use only databases created with a compatible release of database manager. If the error occurred during a Migrate or Restore, you must first migrate the database to a release which can be migrated by the current release of the database manager.
Cause: The user attempted to execute a command or operation without having the proper authority for that command or operation.
The command cannot be processed.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Log on as a user with the correct authority and retry the failed command or operation. Correct authorities may include SYSADM, SYSCTRL, SYSMAINT, and DBADM. DBADM is granted on databases and all other authorities are determined by membership in the groups defined in the database manager configuration (eg. if sysctrl_group in the database manager configuration file is defined as 'beatles', then you must belong to the group 'beatles' to have SYSCTRL authority). Refer to the Command Reference or the SQL Reference for the listing of required authorities for the attempted command or operation.
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 ensure that correct authorizations exist on that data source.
Contact the System Administrator for authority request assistance. Do not attempt to execute the command without appropriate authorization.
Cause: A user must be logged on before any command requiring authorization can be processed. Possible causes for this error include:
The command cannot be processed.
Action: Log on with a valid user ID and resubmit the command. If several concurrent processes are attempting to log on, wait a few seconds and retry the logon procedure.
sqlcode: -1093
sqlstate: 51017
Cause: The node directory cannot be scanned or used while it is being updated. Also, the directory cannot be accessed for update if it is already being accessed for any reason.
The command cannot be processed.
Action: Resubmit the command after the update is finished.
sqlcode: -1094
sqlstate: 57009
Cause: Eight node directory scans are already open in this process and no more than eight are allowed.
The command cannot be processed.
Action: Issue one or more CLOSE NODE DIRECTORY SCAN commands. Resubmit the command.
sqlcode: -1095
sqlstate: 54029
Cause: A command was issued on a node that does not support the command, or the system environment was found to be set up incorrectly for this node type. For example, a database was cataloged as LOCAL on a client node.
The command cannot be processed.
Action: Verify that the command and parameters are correct for the node type. Also verify that the environment where the command is to be processed is correct. Resubmit the command.
Cause: Either the node name listed in the database directory for a remote database or the node name specified on an attach command was not cataloged in the node directory.
The command cannot be processed.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
Action: Verify that the node name listed in the database directory or as the object of the attach command is cataloged in the node directory. If the node is not listed in the node directory, submit a CATALOG NODE command.
DataJoiner users: in addition to the actions listed above, also verify that the node names listed in all the SYSCAT.SERVERS entries are correct. If the node is not listed in the node directory and the server is a member of the DB2 family, submit a CATALOG NODE command for that node.
sqlcode: -1097
sqlstate: 42720
Cause: A connection to a database was requested but the application is already connected to the specified database.
The command cannot be processed.
Action: No action is necessary.
sqlcode: -1098
sqlstate: 53056
Cause: A write operation was attempted to a database residing on a write-protected diskette.
The statement cannot be processed.
Action: Verify you are using the correct diskette. Remove protection from the diskette, if necessary.