DBI1250E Applications are still using instance instance-name.

Explanation

There are applications that are still running that are using the specified instance. All applications using this instance must be terminated before the command can be completed successfully. You can get a list of the applications that are currently using the instance by issuing the command:


    db2 list applications

User response

You can either wait for the applications to end by themselves, or you can explicitly force the applications to end. You can logon as the instance owner and run the command


    db2 force application all

Note that some applications may have unexpected behavior when terminated using the indicated command. After all the applications have stopped, stop the database manager using "db2stop" command.

DBI1251N An error occurred while creating the cluster resource for this instance.

Explanation

The db2iupgrade command is unable to initialize the clustering service or is unable to find the existing DB2 resource to upgrade.

User response

Ensure that the current logon user account has sufficient authority to access the clustering service. Also ensure that the cluster service is active on the system, and that any resources that the DB2 resource you are upgrading depends on are online on the current node.

If the problem persists, contact your IBM service representative for assistance.

DBI1252N An error occurred while registering the database server resource type in the clustering service.

Explanation

DB2 requires a resource type to be available in the clustering service but the command to register the resource type failed.

User response

Ensure that the current logon user account has sufficient authority to access the clustering service.

Register the resource type manually using the utility "db2wolfi.exe i".

If the problem persists, contact your IBM service representative for assistance.

DBI1253N An error occurred while creating the cluster resource for this instance. The system cannot revert to its original settings.

Explanation

An error occurred while creating the cluster resource required for this instance. The existing cluster resource for this instance was removed and could not be restored.

User response

Ensure that the current logon user account has sufficient authority to access the clustering service. Also ensure that that cluster service is active on the system, and that any resources that the DB2 resource you are upgrading depends on are online on the current node.

Recreate the resource for the instance using the "Cluster Administrator" available under the administrative tools control panel applet.

If the problem persists, contact your IBM service representative for assistance.

DBI1254N An error occurred while upgrading the cluster resource for this instance because the existing resource cannot be removed.

Explanation

In order to upgrade the instance, the cluster resource must be removed and a new cluster resource must be created using the database server type. The command was not able to remove the existing cluster resource and therefore cannot upgrade this instance.

User response

Ensure that the current logon user account has sufficient authority to access the clustering service. Also ensure that the cluster service is active on the system, and that any resources that the DB2 resource you are upgrading depends on are online on the current node.

If the problem persists, contact your IBM service representative for assistance.

DBI1255E The configuration file filename needed to create the specified instance type cannot be found.

Explanation

The required configuration file to create the specified instance type can not be found.

User response

Specify the instance type supported by the current installation and then rerun the command.

DBI1256E The db2cluster_prepare command failed because the -instance_shared_dev parameter was not specified.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

You must specify the absolute path to the shared device on which the GPFS file system will be created using the required -instance_shared_dev parameter.

This message is returned when the db2cluster_prepare command is called without the -instance_shared_dev parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a valid value for the -instance_shared_dev parameter.

DBI1257I The DB2 Information Center is not listening for requests.

DBI1258E Unable to start DB2 Information Center.

Explanation

The command to start the DB2 Information Center was unsuccessful.

User response

The messages are written in the log file doc/eclipse/workspace/.metadata/.log from the DB2 Information Center install path.

DBI1259I Enabled root feature:

DBI1260E Cannot read from response file.

Explanation

An attempt was made to read from the given response file failed. Ensure that the response file has read access permission and the given path to the response file is correct.

User response

Correct the access permission and the location of the response file and try again.

DBI1261E The value is not valid for the keyword.

Explanation

The value specified in the response file is not valid for its corresponding keyword. Refer to the sample response file for a list of valid entries.

User response

Correct the problem in the following line of the response file and try again.

DBI1262E Unknown keyword detected in the response file.

Explanation

The given keyword in the response file is not valid. Refer to the sample response file for a list of valid keywords.

User response

Correct the problem in the following line of the response file and try again.

DBI1263I Not enabled root feature:

DBI1264E This program failed. Errors encountered during execution were written to the installation log file. Program name: program-name. Log file name: log-name.

Explanation

This message is returned when some processes and operations have failed. Detailed information about the error was written to the log file.

User response

Contact IBM support to get assistance in resolving this issue. Keep the log file intact as this file is an important reference for IBM support.

DBI1265I Reserved service entry:

DBI1266I Refer to the log file log-name for more information.

Explanation

All processed and failed operations have been saved into this log file.

User response

Do not modify this file in any way. This file is for IBM Technical Support reference.

DBI1267I Not reserved service entry:

DBI1268E The file set fileset is not available on the installation media.

Explanation

One of the file sets to be installed is not found on the installation media. If the file set is not located on the installation media then it cannot be installed.

User response

Ensure that the file set is located on the installation media. If the file set is not located on the installation media de-select it and try again.

DBI1269I Summary:

DBI1270E Error detected in the response file.

Explanation

An error has been detected when processing the response file. Install cannot be continued unless the problem has been corrected.

User response

Correct the problem in the following line of the response file and try again.

DBI1271E The configuration file configuration-file is invalid.

DBI1272I To start using the database manager instance instance-name, you must set up the instance environment by sourcing db2profile or db2cshrc in the sqllib directory, or you can open a new login window of the instance user.

Explanation

The database manager instance cannot be used before db2profile (for Bourne or Korn shell users) or db2cshrc (for C shell users) is sourced.

User response

To set up the database manager instance environment, you can open a new login window under the ID that owns the instance, or source the instance environment by running the appropriate following command under the ID that owns the instance:


. $HOME/sqllib/db2profile

source $HOME/sqllib/db2cshrc
where $HOME represents the home directory of the user ID that owns the instance.

DBI1273W The DB2 Text Search instance service could not be configured for the instance. Reason code: reason-code.

Explanation

An attempt to configure the instance for DB2 Text Search failed. Possible reasons are:

1

DB2 Text Search is not installed. Install DB2 Text Search from the installation media then try again.

2

The service name or port number specified is not valid. A valid service name must not exceed 14 characters in length, and a valid port number must be in the range 1024-65535.

3

The port number specified is being used by another application. Choose a port number that is available on the system.

4

The specified service name or port number conflict with existing values in the TCP/IP services file. Provide a service name and a port number that is available on the system.

5

The TCP/IP services file could not be accessed. Check that you have permission to read and write to the services file. Also, ensure that the content of the file is valid and no duplicate entries exist.

6

The default service name is reserved to a port number that is different from the one provided. Provide a service name and port number that do not conflict with existing entries in the TCP/IP services file.

7

The default service name is reserved to a port number that is being used by another application. Choose a service name and port number that is available on the system.

8

The service name provided is reserved to a port number that is being used by another application. Choose a service name and port number that is available on the system.

9

An attempt to create or copy DB2 Text Search directories or files in the instance directory failed.

10

An attempt to read or write to DB2 Text Search configuration files in the instance directory failed.

11

An attempt to create the DB2 Text Search instance service Windows service failed.

12

An unexpected internal error occurred.

User response

Contact your IBM service representative if the suggested action associated with the reason code did not solve the problem.

DBI1274N The DB2 Text Search instance service for the instance could not be stopped.

Explanation

An attempt to stop the DB2 Text Search instance service failed. The Windows service could not be stopped.

User response

Stop the DB2 Text Search server for the instance and try your command again.

DBI1275E The DB2 Text Search instance service for the instance could not be stopped.

Explanation

An attempt to stop the DB2 Text Search instance service failed.

User response

Stop the DB2 Text Search instance service for the instance and try your command again.

DBI1276E The database product installation at install-path must be updated while logged in under the user ID that performed the installation.

Explanation

You can only update the database product installation by running the installFixPack command under the user ID that performed the database product installation.

You have to run the installFixPack command as a user with root privilege to update a DB2 root installation.

User response

Rerun the command with an appropriate user ID.

DBI1277E Install path and runtime path do not match

Explanation

When setting up the runtime path with db2chgpath, a path was given that does not match the current path that the database manager is running from.

User response

Perform one of the following actions:

  • Move the install path to match the runtime path.
  • Rerun db2chgpath with the correct runtime path, to match the current install path.

DBI1278W Warning issued from the response file.

Explanation

A warning has been raised when processing the response file. The database product installer will carry on without stopping.

User response

If required, correct the problem in the following line of the response file and try again.

DBI1279I Notice issued from the response file.

Explanation

A notice has been issued when processing the response file. The database product installer will carry on without stopping.

User response

This is for your information only. No action is required.

DBI1280E The db2cluster_prepare command failed because one or more parameters were specified multiple times.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

This message is returned when the db2cluster_prepare command is called with a duplicate parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying each parameter only once.

DBI1281E The database manager configuration file could not be initialized.

Explanation

An error occurred when attempting to initialize the database manager configuration file. A database manager instance could not be created or upgraded.

User response

Refer to the log file for troubleshooting. Resolve the problem and try the command again. If the problem persists, contact your IBM service representative.

DBI1282W The database manager configuration files could not be merged. The original configuration file was saved as dbm-cfg-file-name. (The original instance type is original-instance-type. The instance type to be upgraded or updated is instance-type-upgraded.)

Explanation

An error was detected when attempting to merge two database manager configuration files. The previous database manager configuration file could not be merged with the new database manager configuration file. This error could happen if the instance is being upgraded or updated from a higher instance type to a lower instance type.

If the instance update or upgrade was successful, a new instance is created using the default configuration settings for the instance-type-upgrade.

This error could happen if the instance is being upgraded or updated from a higher instance type to a lower instance type. The new instance uses the default configuration settings for the new instance type if update or upgrade was successful.

User response

Check the values in the new database manager configuration file and update the parameters as required using the dbm-cfg-file-name original configuration file.

DBI1283E Unable to update the communication information for instance.

Explanation

The SVCENAME parameter and/or the DB2COMM registry values could not be updated during instance creation.

User response

Make sure that the SVCENAME parameter is set to “<profile-name>” in the database manager configuration file and update using

 db2 update dbm cfg using
     SVCENAME “<profile-name>”

Also update the DB2COMM variable to tcpip by running

    db2set DB2COMM=tcpip

DBI1284I feature-name has been set successfully.

DBI1285E Setting feature-name failed. See log file log-file-name for details.

DBI1286E The utility utility-name was not found.

Explanation

The utility must be available on your system to install or update database products.

User response

Ensure that the utility is installed and its location is in the PATH environment variable.

Re-enter the command.

DBI1287E There has been an attempt to use db2_deinstall on an image for a platform that does not match the current platform platform on which it is being run.

Explanation

Possible causes include:
  • This database product install image is not valid for the current platform.
  • The current platform is not supported by the database product.

User response

Remove the database product using the install image that corresponds with the current platform platform or directly run the command db2_deinstall from the directory 'DB2DIR/install', where DB2DIR is the database product installation path.

DBI1288E The execution of the program program-name failed. This program failed because you do not have write permission on the directory or file directory-or-file-name.

Explanation

Reasons for this error include:

  • The given directory or file is on a local file system of the current machine, but the user id running the program does not have write permission for that directory or file.
  • The given directory or file is on an NFS mounted file system mounted on the current machine, but the current user id does not have write permission for that directory or file.
  • The current user id does not have write permission for the given directory or file located at the target partition. This can happen when the current machine's operating system is IBM AIX Version 6.1 or later and a Workload Partition root user id is attempting to write to a Global Partition.
  • The current user id does not have write permission for the directory or file located at the target zone. This can happen when the current machine's operating system is Sun Solaris 10 or later and a local zone root user id is attempting to write to a global zone.
  • The current machine is running the Sun Solaris Operating System in a local zone which does not have the write permission for the directory or file located on the global zone.

User response

There are several ways to respond to this message:

  • Run the program with a user id that has write permission for the given directory or file.
  • Modify the permissions of the directory or file to allow the user id to write to that directory or file, and rerun the program.
  • Modify the authority of the user id to allow that user id to write to the given directory or file, and rerun the program.

DBI1289W The database product install or instance utility utility-name failed to configure file permission and ownership properties for files related to DB2 Advanced Copy Services (ACS). See the log file log-file-name for more information.

Explanation

The database product install or instance utility attempted to configure permission and ownership for DB2 ACS files that are located in the sqllib/acs directory under the DB2 instance home directory. The given log file contains information about why the database product install or instance utility failed.

DB2 ACS might not be usable because the database product install or instance utility failed to configure permission and ownership for these files.

User response

If you will not be using DB2 ACS, you do not need to reinstall IBM Data Server, or recreate the database manager instance.

If you will be using DB2 ACS, perform the following steps:

  1. See the given log file for more information about the failures.
  2. Correct the cause of the failures and take the action recommended in the log file.

DBI1290E An attempt to create the profile registry profile-name failed.

Explanation

An error occurred when creating the profile registry. One of the following situations occurred:
  • Incorrect access permission on the top directory of the current database product installation.
  • There is not enough space on your file system.

User response

Check the directory permissions for the top directory of the current database product installation.

DBI1291E The instance instance-name was not found in the instance list.

Explanation

The specified instance was not found in the instance list.

User response

Verify that the list of instances as reported by the “db2ilist” command is correct. Retry the command with a valid instance name.

DBI1292E The instance instance-name is already in the instance list.

Explanation

The instance that is being created or upgraded is already in the instance list.

User response

Use a different instance name that is not part of the instance list as reported by the db2ilist command.

DBI1294W The database product install or instance utility utility-name failed to start DB2 Advanced Copy Services (ACS.) See the log file log-file-name for more information.

Explanation

Before you can use DB2 ACS, the services must be started. The database product install or instance utility attempted to start the services, but failed.

You can use the database manager instance, but you cannot use DB2 ACS until the services are started.

User response

To start DB2 ACS, perform the following steps:

  1. See the given log file for more information about the failures.
  2. Correct the cause of the failures.
  3. Start DB2 ACS manually.

DBI1295E The instance list could not be updated.

Explanation

The instance could not be added to or removed from the instance list. An error has occurred when adding or removing the instance from the instance list. One of the following situations occurred:
  • Incorrect access permission on the registry profile.
  • Profile registry is not set up properly.
  • There is not enough space on your file system.

User response

Check the file permissions on the instance list profile under the top directory of the current database product installation.

DBI1296E The database product install or instance utility utility-name failed to stop DB2 Advanced Copy Services (ACS.) See the log file log-file-name for more information.

Explanation

Before you can update or upgrade a database manager instance, DB2 ACS must be stopped. The database product install or instance utility attempted to stop the services, but failed.

You cannot update or upgrade the instance until DB2 ACS is stopped.

User response

To stop DB2 ACS, perform the following steps:

  1. See the given log file for more information about the failures.
  2. Correct the cause of the failures.
  3. Stop DB2 ACS manually.

DBI1297E The instance profile profile-name could not be updated.

Explanation

An error occurred when updating the instance profile registry. One of the following situations occurred:
  • Incorrect access permissions on the instance profile registry.
  • Profile registry is not set up properly.
  • There is not enough space on your file system.

User response

Check the file permissions on the instance list profile under the top directory of the current database product installation.

DBI1298E The database product install or instance utility utility-name failed to disable DB2 Advanced Copy Services (ACS.) See the log file log-file-name for more information.

Explanation

Before you can drop a database manager instance, or remove a non-root install of IBM Data Server, DB2 ACS must be stopped. The database product install or instance utility attempted to disable the services, but failed.

You cannot drop an instance, or remove a non-root install of IBM Data Server until DB2 ACS is disabled.

User response

To disable DB2 ACS, perform the following steps:

  1. See the given log file for more information about the failures.
  2. Correct the cause of the failures.
  3. Disable DB2 ACS manually.

DBI1299E DB2 profile registry variable variable-name was not nulled because it is a member of an aggregate set.

Explanation

Several DB2 profile registry variables can be grouped together and set as one aggregate DB2 profile registry variable. When you configure an aggregate DB2 profile registry variable, the DB2 profile registry variables that are members of that set are automatically configured to their predefined values.

DB2 profile registry variables that are members of an aggregate set, can not be nulled using the following db2set command syntax:

db2set variable-name=

The variable was not nulled.

User response

To null a DB2 profile registry variable that is a member of an aggregate set, use the following db2set command syntax to set the variable to NULL:

db2set -null variable-name

DBI1300N db2set displays, sets, or removes DB2 profile variables.

db2set [variable=[value]]
       [-g|-i instance [member-number]]
       [-all]
       [-null]
       [-r [instance] [member-number]]
       [-im|-immediate]
       [-info]
       [-n DAS node[-u user[-p password]]]
       [-l|-lr]
       [-v]
       [-ul|-ur]
       [-?|-h]

Explanation

The command options are:

-g

Access the global profile variables.

-i

Specifies the instance profile to use instead of the current or default.

-n

Specifies the remote DB2 Administration Server node name.

-u

Specifies the user ID to use for the Administration Server attachment.

-ul

Access the user profile variables

-ur

Refreshes user profile variables

-p

Specifies the password to use for the admin server attachment.

-r

Resets the profile registry for the given instance. The default/current instance will be used if none is provided.

-im | -immediate

Specifies that the update takes effect the next time an SQL statement is compiled for registry variables that support this feature.

-info

Returns the properties of the specified variable. The properties state whether an immediate change is supported by the variable and whether the change is immediate by default

-l

Lists all instance profiles.

-lr

Lists all supported registry variables.

-v

Verbose mode.

-?

Displays the command help message.

-h

Same as -? option.

-all

Displays all occurrences of the local environment variables as defined in:

  • The environment, denoted by [e]
  • The user level registry, denoted by [u]
  • The node level registry, denoted by [n]
  • The instance level registry, denoted by [i] and
  • The global level registry, denoted by [g]
-null

Sets the variables value to null at the specified registry level to prevent looking up the value in the next registry level as defined in the variable value search order.

Notes:

  • db2set with no variable name displays all defined variables.
  • db2set <variable> displays <variable>'s value.
  • db2set <variable>= (nothing) deletes the <variable>.
  • db2set <variable>=<value> modifies the <variable>'s value.
  • db2set <variable> -null sets <variable>'s value to NULL.
  • db2set <variable> -all displays all defined <variable>'s values.
  • db2set -ur refreshes the current user profile.
  • db2set <variable> -ul displays defined <variables> at the user level.
  • db2set -all displays all defined variables in all registry levels.

User response

DBI1301E The registry variable was not updated because an invalid value was specified.

Explanation

You can configure many aspects of DB2 database functionality by setting DB2 profile registry variables. You can set DB2 profile registry variables by using the db2set command.

This message is returned when an attempt is made to use the db2set command to set a DB2 profile registry variable to a value that is invalid.

User response

  1. Determine the range of valid values for the registry variable.
  2. Call the db2set command again, specifying a valid value for the specified registry variable.

DBI1302E Invalid parameter detected.

Explanation

An invalid parameter was used.

User response

Use the -? option for the usage help message.

DBI1303W Variable not set.

Explanation

The variable was not set in the profile registry.

User response

No further action is required.

DBI1304E Unexpected error.

Explanation

The tool encountered an unexpected system error.

User response

Contact your DB2 service representative.

DBI1305E The profile registry was not found.

Explanation

The target machine does not have a profile registry setup.

User response

Create the registry on the target machine by installing DB2.

DBI1306N The instance profile is not defined.

Explanation

The instance is not defined in the target machine registry.

User response

Specify an existing instance name or create the required instance.

DBI1307N The instance node profile is not defined.

Explanation

The instance node is not defined in the target machine registry.

User response

Create the registry by installing the required database product parts.

DBI1308E Out of memory condition encountered.

Explanation

The tool encountered an “out of memory resource” error.

User response

System is low on memory resources. Terminate non-essential applications or try again later.

DBI1309E System error.

Explanation

The tool encountered an operating system error.

User response

A system error was encountered during registry access. Ensure that there is enough space on the file system where the registry is located, and that there is a valid LAN connection if the registry is remote.

DBI1310E Remote registry access is not supported.

Explanation

The tool does not support the remote registry option.

User response

Consult the Command Reference on how to access the registry remotely.

DBI1311I Listing registry instance profiles...

DBI1312I Listing defined global variables...

DBI1313I Listing defined instance variables...

DBI1314I Listing all supported registry variables...

DBI1315E The specified variable is not an aggregate type registry variable.

Explanation

To display the group definition, the registry variable must be an aggregate type registry variable.

User response

Do not specify the -gd option or specify a valid aggregate variable name when using the -gd option.

DBI1316E Instance is not MPP.

Explanation

The target instance is not a DB2 MPP instance.

User response

Choose an MPP instance.

DBI1317E Instance node already exists.

Explanation

A duplicate instance node already exists.

User response

Choose a different instance node.

DBI1318E The value specified for the registry variable is too long.

Explanation

The value specified for the registry variable exceeds the maximum limit. The maximum length for a registry variable value is 255 bytes.

User response

Specify a shorter value for the registry variable.

DBI1319W The variable variable-name has been explicitly set and will not be affected by the configuration of the aggregate variable aggregate-var-name.

Explanation

An aggregate registry variable has been configured to a value whose group definition contains settings for a variable which has been explicitly configured. The explicitly configured value will be retained.

User response

If desired, explicitly configure the variable.

DBI1320W WARNING:

Explanation

This script is used to gather information useful to IBM Support to debug the problems you may be experiencing. This information may be of a sensitive nature. You may wish to edit the output file, db2ginfo.txt, before sending it to IBM Support.

User response

To signal your awareness and acceptance of the warning, run this script with the -y flag specified.

DBI1321W The ulimit setting for the database manager instance instance-name does not comply with the recommended values for DB2 on the current platform.

Explanation

The ulimit setting for the current non-root database manager instance has values for 'data' and 'nofiles' smaller than the values recommended by DB2 on the current platform. Set the 'data' to 'unlimited' and 'nofiles' to '65536' or the maximum value allowed on the system. If setting 'data' to 'unlimited' cannot be done, the following formula can be used as reference to decide the estimate value in kilobytes of 'data' required by DB2 for the current platform:

default_data_ulimit + ( ( 20 * max_concurrent_active_databases ) + estimated_max_connections ) * max_querydegree * 8192

where:

  1. default_data_ulimit is the default value of 'data' of ulimit for a user on the system. For example, the default value is 262144 on IBM AIX system.
  2. max_concurrent_active_databases is the maximum number of concurrent active databases for the instance.
  3. estimated_max_connections is the estimated maximum number of database connections for the instance.
  4. max_querydegree is the value of the parameter "MAX_QUERYDEGREE" for database manager configuration when the INTRA_PARALLEL is enabled in the database manager configuration. If INTRA_PARALLEL is not enabled, the max_querydegree's value is 1.

User response

Ask the system administrator with root privilege to update the ulimit setting for the current instance.

DBI1322I An incorrect argument was entered for the db2iprune command.

Explanation

Syntax:


db2iprune -r input_file_path 
          -o destination_dir_path | -c
         [-t trace_file]                 
         [-l log_filename]
         [-h|-?]

User response

Enter the command again using the valid parameters.

DBI1323I Usage:   
      db2rspgn -d output_directory
              [-i instance]
              [-t trace-file]
              [-h|-?]        

Explanation

An incorrect argument was entered for the db2rspgn command. Valid arguments for this command are:

-d

Specifies the full path to the output directory for generated files. If the output directory specified is an existing directory, the directory must be empty and writable. If the output directory specified does not exist, the new directory is created if the location is writable. This parameter is mandatory.

-i instance

Generates the specified instance configuration and saves this information in the generated response file and instance configuration profile. This parameter is optional. By default, all instances are selected. To specify multiple instances, specify this parameter multiple times. For example, -i db2inst1 -i db2inst3.

-t trace-file

Linux and UNIX operating systems only. Turns on the debug mode. The debug information is written to the file name specified as trace-file.

-h|-?

Displays help information.

User response

Enter the command again using the valid parameters.

DBI1324W Support of the command-name command is deprecated.

DBI1325E The command-name command has failed.

Explanation

At least one instance is still running the DB2 Text Search instance service.

User response

Stop the DB2 text search instance service and re-run the command.

DBI1326W The Text Search instance services failed to restart.

Explanation

Before running the database manager instance command, the Text Search instance service was not stopped. The database manager process stopped the Text Search instance service. However, the database manager process is unable to restart the Text Search instance service.

User response

Manually restart the Text Search instance service.

DBI1327E The db2icrt command failed because the home directory of the instance owner is a subdirectory under the directory in which the database product is installed.

Explanation

The home directory of the instance owner cannot be a subdirectory under the directory in which the database product is installed.

For example, if the database product is installed in the directory named /opt/db2v97, the home directory of the user who will be the instance owner cannot be in any directory under /opt/db2v97.

This message is returned in the following scenario:

  • On Linux and UNIX operating systems: the home directory of the instance owner is a subdirectory under the directory in which the database product is installed.

The database manager instance was not created.

User response

  1. Configure that the user environment and directory structure so that the home directory of the instance owner is not a subdirectory of the directory in which the database product is installed.
  2. Run the db2icrt command again.

DBI1328E The db2cluster_prepare command failed because no value was specified for the -instance_shared_dev parameter.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

You must specify the absolute path to the shared device on which the GPFS file system will be created using the required -instance_shared_dev parameter. The db2cluster_prepare utility will create the GPFS file system in the specified location.

This message is returned when the db2cluster_prepare command is called without a value specified for the -instance_shared_dev parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a value for the -instance_shared_dev parameter.

DBI1329I Usage:
db2val [-h|-?]
       [-o]
       [-i inst_name1] | [-a]
       [-b db_name]
       [-t trace_file]
       [-d]
       [-s]
       [-l log_file]

Explanation

An invalid argument was entered for the db2val command. Valid arguments for this command are:

-o

Specifies that only the installation files will be validated; validation of the instance, database, and extended security will not be performed. If this parameter is specified, the -i, -a, -b, and -s parameters are ignored.

-i inst_name

Specifies that the name of the instance to validate. To specify validation of multiple instances, specify this parameter multiple times. For example, -i inst1 -i inst2.

  • On Windows operating systems, if this parameter is not specified, the current instance will be used as the default value.
  • On Linux and UNIX operating systems, this parameter can only be used by root users in a root installation of a DB2 copy.
-a

Validates all instances in the DB2 copy. On Linux and UNIX operating systems, this parameter can only be used by root users in a root installation of a DB2 copy. This option overrides the -i option.

-b db_name

Validates the local database creation and connection with the given database name. This parameter is ignored in the following scenarios:

  • the instance to be validated is a client instance
  • -a and -i are not specified when db2val is run by root users (on Linux and UNIX only).
-t trace_file

Specifies the full path and name of trace file specified by trace_file.

-d

This parameter is deprecated and might be removed in a future release. Use the the -t parameter instead. Valid only on Linux and UNIX operating systems. Use this parameter only when instructed by DB2 Support. Turns the debug mode on.

-s

Starts the database manager for the specified instance that is part of a partitioned database environment. This parameter overrides parameter -i.

-l log_file

Writes the log to the file name specified. Unless the -l parameter is specified, the default log path is:

  • On Linux and Unix, /tmp/db2valxx.log
  • On Windows, My Documents\DB2LOG\db2valxx.log

where xx is a generated value.

-h|-?

Displays the usage information.

User response

Enter the command again using the valid parameters.

DBI1330W The action might affect other instances.

Explanation

The file IWH.environment contains global information for all instances. Updating this file might affect all instances. Do you wish to continue?

DBI1331E Installation file validation for the DB2 copy copy_name failed.

Explanation

Some features or components have missing files or are the wrong size.

User response

To repair the database product installation, from the Add or Remove Programs tool, select Change for the DB2 copy, and select the Repair option. Rerun the db2val command.

DBI1332E Missing template file for IWH.environment.

Explanation

The template file for IWH.environment is needed.

DBI1333I Installation file validation for the DB2 copy copy_name was successful.

DBI1334E Installation file validation failed for the DB2 copy installed at installation-location. Reason code = reason-code.

Explanation

You can verify the basic functions of a DB2 copy, checking the state of installation files, instance setup, and local database connections, by using the db2val utility.

This message is returned when the db2val utility detected problems with the DB2 copy that is installed at the given location.

The reason code indicates more specifically what the problem is:

1

Some features or components have missing files or files with the wrong size.

2

The installation image inside the install path has missing files.

3

The embedded runtime path for some DB2 library or executable files is not set properly.

4

The installation path is not accessible to the database manager.

5

The /etc/services file is not accessible to the database manager.

User response

Respond to this message according to the reason code:

1

Respond to reason code 1 in one of the following ways:

  • If your DB2 copy has the DB2 pureScale Feature installed:
    1. Reinstall the DB2 copy to a new path by running the installFixPack command from the installation media, specifying the -p <new-path> option and the -f nobackup option.
    2. Update the instance to the new copy using the db2iupdt command.
    3. Run the db2val command.
  • If your DB2 copy does not have DB2 pureScale installed:
    1. Reinstall the DB2 copy to the same path by running the installFixPack command, specifying the "-f nobackup" option.
    2. Run the db2val command.
2

Copy the installation image into <DB2-installation-path>/sd directory.

3

Set the embedded runtime path by using one of the following methods:

  • For root installations, run <DB2-installation-path>/install/db2chgpath as root.
  • For non-root installations, run <DB2-installation-path>/install/db2chgpath as the copy owner.

Then run the db2val command.

4

Modify the access permissions for the installation path so that the database manager can access the installation path.

5

Modify the access permissions for the /etc/services file so that the database manager can access that file.

DBI1335I Installation file validation for the DB2 copy installed at installation_location was successful.

DBI1336E The partitioned database environment validation for the instance instance_name failed. Reason code = reason_code.

Explanation

  1. The format of the DB2 node configuration file (db2nodes.cfg) is incorrect.
  2. The other database partition servers are not accessible.
  3. The start and end ports for Fast Communication Manager (FCM) are not reserved properly on all database partition servers.
  4. The instance profile directory is not accessible from all database partition servers.
  5. The instance service is running under a non-domain account. This will prevent the database manager instance from starting.
  6. The installation directory for the instance is not accessible from all database partition servers.
  7. The code level on each database partition server is not consistent.
  8. On Windows operating systems, if the db2val command is run to validate a multiple partition instance, domain user account authority is required.
  9. An unexpected internal error occurred.

User response

  1. Ensure the format of db2nodes.cfg follows the DB2 standard.
  2. Check the .rhosts file is configured on all the partitions. If the DB2RSHCMD registry variable is set to ssh, ensure the ssh remote shell utility is available.
  3. Ensure the start and end ports for FCM are free and reserved on each computer participating in the partitioned database environment. The start port should be the same on each participating computer.
  4. Ensure the instance profile directory on the instance-owning machine is shared among all the database partition servers. The instance profile directory should be in the UNC format.
  5. Use a domain account for the instance service on all database partition servers.
  6. Ensure the installation directory is accessible from all database partition servers.
  7. Ensure the same code level is installed on all computers participating in the partitioned database environment.
  8. Log on as a user with the domain user account authority and retry the command.
  9. Rerun the db2val command. If this error persists, contact your IBM service representative.

DBI1337I The partitioned database environment validation for the instance instance_name was successful.

DBI1338E The validation of instance instance_name failed. Reason code=reason_code.

Explanation

  1. The default instance is not set.
  2. Some files in the instance directory are damaged. The symbolic links of the files are not pointing to the current DB2 copy installation path, and the file permission and ownership might have been changed.
  3. The DB2 Extended Security setup does not allow the current user to start an instance. If Extended Security is enabled, the user needs to be in the DB2ADMNS group.
  4. To start the instance, read permission is required to the /etc/services file.
  5. The appropriate authority is required to validate this instance.
  6. The partitioned database environment setting is not correct.
  7. The instance failed to start because of system errors.
  8. An unexpected internal error occurred.

User response

  1. Set the DB2INSTDEF profile registry variable to an instance in the DB2 copy.
  2. Run the db2iupdt or db2nrupdt command with the -k option for the instance.
  3. Add the current user to the DB2ADMNS group and rerun the command.
  4. Ensure you have read permission to the /etc/services file.
  5. Log on as a user with the appropriate authority, and retry the command.
  6. Check the partitioned database environment validation log file for details.
  7. Check the log file for details.
  8. Rerun the db2val command. If this error persists, contact your IBM service representative.

DBI1339I The instance validation for the instance instance_name was successful.

DBI1340I Database validation for instance instance_name was successful.

DBI1341E ID does not have the authority to perform the requested command.

Explanation

The appropriate authority is required to run the command.

User response

Log on as a user with the appropriate authority, and retry the command.

DBI1342E Instance instance_name does not exist in the current DB2 copy.

Explanation

The specified instance does not exist in the current DB2 copy and will not be validated.

User response

Rerun the db2val command with an instance that is listed by the db2ilist command for the current DB2 copy.

DBI1343I The db2val command completed successfully. For details, see the log file log_path.

DBI1344E The validation tasks of the db2val command failed. For details, see the log file log_path.

DBI1345W Read permission to the /etc/services file is not granted to every user. This lack of permission can cause the instance creation to fail.

Explanation

Creating an instance requires the users who manage the instance to have read permission to the /etc/services file.

User response

Ensure users have read permission to the /etc/services file.

DBI1346W Path path defined in the DFTDBPATH database manager configuration variable is not accessible on the current database partition server. This can cause the database creation to fail.

DBI1347W The db2val command completed with warnings. For details, see the log file log_path.

DBI1348W Read and execute permissions to the installation directory are not granted to everyone. This lack of permission might cause problems when using your database product.

DBI1349W Installation file validation completed with warnings for the DB2 copy installed at installation_location. For details, see the log file log_path.

DBI1350E The database validation failed for the instance instance_name. Reason code=reason_code.

Explanation

Database validation failed because of one of the following reasons:

  1. Database creation failed because of system errors.
  2. Database connection failed because of system errors.
  3. An unexpected internal error occurred.

User response

Check the log file for details, or rerun the db2val command. If this error persists, contact your IBM service representative.

DBI1354E The instance instance-name is not an DB2 Query Patroller Server instance.

User response

Use dqplist to find out the proper server instance name and re-run the command again.

DBI1356I Usage:

  dqplist [-h|-?]

Explanation

An incorrect argument was entered. Valid arguments for this command are:
-h|-?
display the usage information

User response

Re-enter the command with the proper syntax.

DBI1362W IWM schema objects have been detected.

Explanation

The database manager has detected IWM schema objects, possibly from a previous install of IWM.

User response

If you wish to keep the existing IWM schema objects, there is nothing to do. If you wish to remove them and re-create new ones, re-issue the dqpsetup command with the -o flag.

DBI1363E Failed to create IWM schema objects.

Explanation

An attempt to create the IWM schema objects has failed.

User response

Verify that the files db2_qp_schema and iwm_schema.sql are both in the directory /usr/opt/db2_08_xx/bin, where xx is 01 or FPn, where n is the FixPak number.

If both files exist, then the output of the IWM schema creation procedure can be found in /tmp/iwmschcr.log. Correct any error and re-run the dqpsetup command again.

DBI1365E Node number is not defined.

Explanation

The node number is not defined in the db2nodes.cfg.

User response

Examine the db2nodes.cfg file and make sure the entry you want is there. Enter the command again using the correct node number exactly as recorded in the db2nodes.cfg file.

DBI1366E The container sms-path is already in use.

Explanation

The directory named as a container for the table space already exists.

User response

Run the command again using a different path for the container for the table space.

DBI1367E Failed to bind the files listed in bind-list.

Explanation

There was a problem binding the bind files listed in named file(s).

User response

Perform the binding manually.

DBI1368E Failed to connect to DQP database db2dbdft.

Explanation

The database likely does not exist.

User response

Specify that you would like to setup a new DQP instance using all the required parameters to dqpsetup. This instance cannot be upgraded.

DBI1369W The partitioned database environment validation for the instance instance_name completed with warnings.

DBI1370W Unable to modify the .profile or the .login file of user inst-name.

Explanation

The database manager has failed to modify the .profile file or the .login file of this user. These files may not exist, or you may not have write permission to them. Without the modification you need to set your environment manually each time when you log in as this user to use DB2 Query Patroller.

User response

Set up the application development environment.

DBI1374W The validation of instance instance_name completed with warnings.

DBI1377N db2isetup was unable to locate a suitable Java Runtime Environment on your computer. If a Java Runtime Environment jre-version is present, set your JAVA_HOME environment variable and run the command again. Otherwise, refer to the database product installation requirements for information on the recommended Java environment for your operating system. If you need to use your own JRE, set DB2USELOCALJRE=true.

DBI1378N db2setup was unable to locate a suitable Java Runtime Environment on your computer. If a Java Runtime Environment jre-version is present, set your JAVA_HOME environment variable and run the command again. Otherwise, refer to the database product installation notes for information on the recommended Java environment for your operating system. If you are unable to obtain a suitable Java Runtime Environment you can install this product from the command using the doc_install script. Run this script without any parameters for information on how to use it. If you need to use your own JRE, set DB2USELOCALJRE=true.

DBI1379I The db2val command is running. This can take several minutes.

DBI1380W The database db_name cannot be removed.

Explanation

The database might be in use by other applications.

User response

To manually drop the database, run the following command: db2 drop db db_name

DBI1381W Database validation for instance instance_name completed with warnings.

DBI1382W The database manager of the instance instance_name cannot be stopped.

Explanation

The database might still be in use.

User response

To stop the database manager, run the db2stop command.

DBI1383I You must update the DB2 registry for the current instance manually using the db2iset command, including the full path of the db2iset command. For example: /opt/ibm/db2/<release>/instance/db2iset -d instance-name.

User response

DBI1384E The instance instance-name cannot be created.

Explanation

DB2 Text Search configuration can only be performed on server instances.

User response

Configure the DB2 Text Search feature on a server instance.

DBI1385W Partitioned instances are not supported with the DB2 Text Search feature.

Explanation

The DB2 Text Search feature cannot be configured for this instance.

User response

Configure a single-partition instance to use the DB2 Text Search feature

DBI1386N The account user-name is locked.

Explanation

The user's account is locked by the operating system.

User response

Contact the system administrator to unlock this user's account.

DBI1387I An invalid argument was entered for the db2isetup command.

Explanation

The syntax for the db2isetup command is:


   db2isetup   [-h|-?] 
               [-i <language_code>] 
               [-r <response_file>] 
               [-t <trace_file>] 
               [-l <log_file>]

User response

Enter the command again using valid parameters.

DBI1388E The db2nrupgrade command failed because an invalid parameter was specified.

Explanation

You can upgrade a non-root database manager instance to a new database product version by issuing the db2nrupgrade command.

This message is returned when the db2nrupgrade command is issued and an unsupported parameter is specified with the command.

User response

Enter the command again specifying supported parameters.

DBI1389I Usage:
db2ckupgrade ( <database_name> | -e )
             -l <logfile>
             [-u <userid> -p <password>] 
             [-h|?]

Explanation

database_name

Specifies the name of a database to be scanned.

-e

Specifies that all local cataloged databases are to be scanned.

-l logfile

Mandatory parameter. Specifies a log file to keep a list of errors and warnings generated for the scanned database.

-u userid

Specifies the user ID of the instance owner.

-p password

Specifies the password of the instance owner.

-h|?

Displays the usage information.

User response

Reenter the command with the proper syntax.

DBI1390E The current instance cannot be upgraded.

Explanation

An attempt was made to upgrade the instance. This instance cannot be upgraded because either:

  • The DB2 version running the db2nrupgrade command is not a supported version to upgrade the current instance.
  • The instance is still active

User response

Also ensure that there are no database manager processes running at the instance. Fix the error, and to upgrade the instance to the new DB2 Copy version, rerun the db2nrupgrade command.

DBI1391E directory-name is not a valid path.

Explanation

The directory cannot be accessed.

User response

Enter a valid path and rerun the command.

DBI1392W The deprecated-command-name command is deprecated. The deprecated command is replaced by new command new-command-name.

Explanation

The deprecated command will be removed from a future release.

User response

Replace the deprecated command with the new command in any scripts or applications.

DBI1393W The -j "TEXT_SEARCH" option is supported only on server instances ese, wse and standalone.

Explanation

The current instance is of type client or DB2 pureScale. The command completed, but the -j "TEXT_SEARCH" option was ignored.

User response

To use DB2 Text Search specify a server instance.

DBI1394E The db2cluster_prepare command failed because the db2cluster_prepare utility cannot write to the following trace file path: trace-file-path.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

You can cause the db2cluster_prepare utility to generate a trace file by specifying an absolute path for the trace file using the -t parameter. The db2cluster_prepare utility will create the trace file in the specified location. You can use this trace file to investigate any errors that occur while the GPFS cluster is being created.

This message is returned when the db2cluster_prepare command is called with a trace file location specified with the -t parameter and the db2cluster_prepare utility cannot access the specified trace path.

The db2cluster_prepare utility runs with the same authority as the user who runs the db2cluster_prepare command. This means that the user who runs the db2cluster_prepare command must have access to the path specified with the parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a trace file path that you can access.

DBI1395E The db2cluster_prepare command failed because the db2cluster_prepare utility cannot write to the following log file path: log-file-path.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

The db2cluster_prepare utility generates a log file that you can use to investigate any errors that occur while the GPFS cluster is being created. You can set the location for the log file by specifying an absolute path for the log file using the -log_file_path parameter. The db2cluster_prepare utility will create the log file in the specified location.

This message is returned when the db2cluster_prepare command is called with a log file location specified with the -log_file_path parameter and the db2cluster_prepare utility cannot access the specified log path.

The db2cluster_prepare utility runs with the same authority as the user who runs the db2cluster_prepare command. This means that the user who runs the db2cluster_prepare command must have access to the path specified with the -log_file_path parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a log file path that you can access.

DBI1396E The db2cluster_prepare command failed because the utility was unable to create necessary temporary files in the following path: path.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

The db2cluster_prepare utility generates some temporary files for internal use. This message is returned when the db2cluster_prepare command is unable to create these internal, temporary files.

The db2cluster_prepare utility runs with the same authority as the user who runs the db2cluster_prepare command. This means that to run the db2cluster_prepare command, you must have access to the named path.

A GPFS file system was not created.

User response

  1. Ensure you have permission to access the named path.
  2. Ensure that there is enough disk space available to create the temporary files.
  3. Run the db2cluster_prepare command again.

DBI1397W The db2set command failed to set the database manager configuration parameter DB2_ATS_ENABLE value to YES.

Explanation

The Administrative Task Scheduler (ATS) could not be enabled. Enabling ATS is a prerequisite for using DB2 Text Search.

User response

To use DB2 Text Search, you must enable the Administrative Task Scheduler.

DBI1398E The db2cluster_prepare command failed because the db2cluster_prepare utility was unable to access the following directory: /tmp.

Explanation

You can create a IBM General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

The db2cluster_prepare utility generates a log file that you can use to investigate any errors that occur while the GPFS cluster is being created. You can set the location for the log file by specifying an absolute path with the -log_file_path parameter. If you do not use the -log_file_path parameter, the db2cluster_prepare utility will attempt to create a log file named db2prepare_cluster.log in the default directory location /tmp.

This message is returned when the db2cluster_prepare command is called without a log file location being specified with the -log_file_path parameter the db2cluster_prepare utility cannot access the directory named /tmp.

The db2cluster_prepare utility runs with the same authority as the user who runs the db2cluster_prepare command. This means that you must be able to access the directory named /tmp to be able to call the db2cluster_prepare command without specifying the -log_file_path parameter.

A GPFS file system was not created.

User response

Respond to this error in one of the following ways:

  • Run the db2cluster_prepare command again, specifying a log file path with the -log_file_path parameter that you can access.
  • Allow the db2cluster_prepare utility to create the log file in the default location by performing the following two steps:
    1. Configure the /tmp directory permissions so that you have access to that directory.
    2. Run the db2cluster_prepare command again without using the -log_file_path parameter.

DBI1399I You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

Explanation

In a DB2 pureScale environment, all data and logs must be on a General Parallel File System. Existing data and logs that are not on GPFS must be moved to GPFS before upgrading to a DB2 pureScale environment. You can set up a DB2 managed GPFS cluster and file system, so that the data and logs can be moved to it in preparation for the upgrade to a DB2 pureScale environment using the db2cluster_prepare utility.

User response

No response is necessary. This message is for your information only.

DBI1400N The syntax of the db2licm command is incorrect.

Explanation

The db2licm tool performs basic license functions. It adds, removes, lists, and modifies licenses installed on the local system. Execute db2licm tool with -l parameter to find out the product identifier for your product:

db2licm [-a filename]
        [-e product-identifier HARD | SOFT]
        [-p product-identifier
        REGISTERED | CONCURRENT | OFF]
        [-r product-identifier]
        [-u product-identifier num-users]
        [-c product-identifier num-connectors]
        [-l]
        [-v]
        [-?]

The command options are:

-a

Adds a license for a product. Specify a file name containing valid license information. This can be obtained from your licensed product CD or contact your IBM representative or authorized dealer.

-e

Updates the enforcement policy on the system. Valid values are: HARD and SOFT. HARD specifies that unlicensed requests will not be allowed. SOFT specifies that unlicensed requests will be logged but not restricted.

-p

Updates the license policy type to use on the system. The keywords CONCURRENT, REGISTERED, or CONCURRENT REGISTERED can be specified. Specify OFF to turn off all policies.

-r

Removes the license for a product. After the license is removed, the product functions in "Try & Buy" mode. To get the password for a specific product, invoke the command with the -l option.

-u

Updates the number of user entitlements that have been purchased. Specify the password of the product for which the entitlements were purchased and the number of users.

-c

Updates the number of connector entitlements that have been purchased. Specify the password of the product for which the entitlements were purchased and the number of connectors.

-l

Lists all the products with available license information, including the product identifier.

-v

Displays version information.

-?

Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.

User response

Enter the command again using the valid parameters.

DBI1401I Command line DB2 License Manager.

Explanation

The db2licm tool performs basic license functions. It adds, removes, lists, and modifies licenses installed on the local system.

To determine the product identifier for your product issue the db2licm -l command.

db2licm [-a filename]
        [-e product-identifier HARD | SOFT]
        [-p product-identifier
        REGISTERED | CONCURRENT | OFF]
        [-r product-identifier]
        [-u product-identifier num-users]
        [-c product-identifier num-connectors]
        [-l]
        [-v]
        [-?]

The command options are:

-a

Adds a license for a product. Specify a file name containing valid license information. This can be obtained from your licensed product CD or contact your IBM representative or authorized dealer.

-e

Updates the enforcement policy on the system. Valid values are: HARD and SOFT. HARD specifies that unlicensed requests will not be allowed. SOFT specifies that unlicensed requests will be logged but not restricted.

-p

Updates the license policy type to use on the system. The keywords CONCURRENT, REGISTERED, or CONCURRENT REGISTERED can be specified. Specify OFF to turn off all policies.

-r

Removes the license for a product. After the license is removed, the product functions in "Try & Buy" mode.

-u

Updates the number of user entitlements that have been purchased. Specify the password of the product for which the entitlements were purchased and the number of users.

-c

Updates the number of connector entitlements that have been purchased. Specify the password of the product for which the entitlements were purchased and the number of connectors.

-l

Lists all the products with available license information, including the product identifier.

-v

Displays version information.

-?

Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.

User response

DBI1402I License added successfully.

DBI1403I License removed successfully.

DBI1404N Product identifier not found.

Explanation

The given identifier is invalid, or a license for this product was not found.

User response

Verify the license keys and product identifiers by listing licenses using the db2licm command with the -l parameter.

DBI1405I License policy type updated successfully.

DBI1406N Invalid license policy type.

Explanation

The license policy type that was entered was not valid for the product specified.

User response

Please enter a valid license policy. Options are:
  • CONCURRENT
  • REGISTERED
  • CONCURRENT REGISTERED
  • OFF

DBI1407N Invalid license certificate file.

Explanation

License certificate file is not in the correct format.

User response

Enter the name of a file with the correct license certificate format.

DBI1408N The file file-name could not be opened.

Explanation

The file is not found or access to the file is denied.

User response

Enter the name of a file that exists and can be opened and try the command again.

DBI1409N Invalid enforcement policy type.

Explanation

The enforcement policy type specified is not valid for this product.

User response

Please enter a valid enforcement policy type that is supported by the specified product.

DBI1410I Concurrent entitlements updated successfully.

DBI1411I Enforcement policy type updated successfully.

DBI1412W A hard stop enforcement policy stops the use of the product by unlicensed users when licensing infractions have been exceeded.

DBI1413W A soft stop enforcement policy logs license infractions, but allows unlicensed users to still use the product.

DBI1414I The db2ls command is preparing and checking the installed DB2 copies on the system.

DBI1415I Checking active database manager instances on AIX system workload partitions (WPARs) workload-partition-list for the related DB2 copy.

DBI1416N The license could not be added automatically. Return code: return-code.

Explanation

You can perform basic license functions such as adding, removing, listing, or modifying licenses and policies by using the db2licm command.

User response

Add the license manually by using the db2licm command.

DBI1417N The specified license could not be removed. Return code: return-code.

Explanation

You can perform basic license functions such as adding, removing, listing, or modifying licenses and policies by using the db2licm command.

This message is returned when a license cannot be removed.

User response

Verify that the license for this product exists by using the db2licm command.

DBI1418I The number of licensed processors on this system has been updated successfully.

DBI1419N There was an error updating the number of licensed processors.

Explanation

The return code is “<return-code>”.

DBI1420N This product does not support this type of license policy.

Explanation

The license policy specified does not apply to this product or is not supported.

User response

Please enter a valid license policy.

DBI1421N This product specified is not installed on this system.

Explanation

You can not configure a license policy for a product until the product is installed.

User response

Install the product before running this command or specify the correct product identifier. To list the products install on the system issue db2licm -l command.

DBI1422N The number of concurrent entitlements was not updated.

Explanation

The return code is “<return-code>”.

User response

Please ensure the concurrent policy is enabled for this product.

DBI1423N This option requires the creation of an instance.

Explanation

Features that are required to perform this action are only accessible once an instance has been created.

User response

Please create an instance and issue this command again.

DBI1424N An unexpected error occurred while accessing processor information.

Explanation

The return code is “<return-code>”.

User response

None.

DBI1425E The license for the OLAP server cannot be updated because the OLAP processes are currently active.

Explanation

The database manager cannot update the license for the OLAP server while the OLAP server is running.

User response

To update your OLAP license, stop all OLAP processes and reinstall this license.

DBI1426I This product is now licensed for use as specified in the License Acceptance and License Information documents pertaining to the licensed copy of this product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING DIRECTORY: dir-name

DBI1427I This product is now licensed for use as specified in the License Acceptance and License Information documents pertaining to the evaluation ("Try and Buy") copy of this product. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE ACCEPTANCE AND LICENSE INFORMATION DOCUMENTS, LOCATED IN THE FOLLOWING DIRECTORY: dir-name

DBI1428N There was an error updating the number of licensed processors.

Explanation

The number of licensed processors entered exceeds the number of maximum licensed processors allowed for this product.

User response

Please enter number of licensed processors that does not exceed the defined maximum. If the number of processors on your system exceeds the maximum number of processors allowed for this product, please contact your IBM representative or authorized dealer.

DBI1429N This product does not support this combination of license policies.

User response

Please enter a valid combination of license policies. For example, you can specify "CONCURRENT REGISTERED" as a valid combination.

DBI1430N The license could not be added because the license date is greater than operating system date.

Explanation

You can perform basic license functions such as adding, removing, listing, or modifying licenses and policies by using the db2licm command.

This message is returned when a license could not be added because the date in the certificate file is later than the current operating system date.

User response

Verify that the license start date in the certificate file precedes the current date on the operating system.

DBI1431N This user does not have sufficient authority to perform the specified action.

Explanation

This program can be run only under the root user ID or a user ID with SYSADM authority.

User response

Login with a user ID that has permission to run this command.

DBI1432N The license could not be added because this product has used the maximum number of evaluation licenses: num-licenses.

Explanation

This product has used the maximum number of evaluation licenses.

User response

Run this command again with a permanent license key.

DBI1433N The number of license entitlements was not updated.

Explanation

The specified number of license entitlements is not in the valid range.

User response

Run this command again using a valid number of license entitlements.

DBI1434N The license entry was added, however this license entry is not active.

Explanation

The installer failed to activate this license entry, therefore the database product will run with the previous license configuration until this license is activated.

User response

Issue the command again.

If the operation continues to fail, contact IBM software support.

DBI1435E Error Opening DB2 First Steps. Cannot find supported Web browser.

Explanation

DB2 First Steps requires a supported Web browser.

User response

Install one of the following Web browsers:

  • Internet Explorer 6.0 and up
  • Mozilla 1.7 and up
  • Firefox 2.0 and up

When using Windows operating systems, set the default browser to your choice from the previous list.

DBI1437E The db2cluster_prepare command failed because no value was specified for the -t parameter.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

You can cause the db2cluster_prepare utility to generate a trace file by specifying an absolute path for the trace file using the -t parameter. The db2cluster_prepare utility will create the trace file in the specified location. You can use this trace file to investigate any errors that occur while the GPFS cluster is being created.

This message is returned when the db2cluster_prepare command is called without a value specified for the -t parameter.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a value for the -t parameter.

DBI1438E The db2cluster_prepare command failed because no value was specified for the parameter named -l.

Explanation

You can create a DB2 managed General Parallel File System (GPFS) for a DB2 pureScale environment using the db2cluster_prepare utility.

The db2cluster_prepare utility generates a log file that you can use to investigate any errors that might occur while the GPFS cluster is being created. You can set the location for the log file by specifying an absolute path with the parameter named -l. If you use the parameter named -l, the db2cluster_prepare utility will create the log file in the specified location.

This message is returned when the db2cluster_prepare command is called without a value specified for the parameter named -l.

A GPFS file system was not created.

User response

Run the db2cluster_prepare command again, specifying a value for the parameter named -l.

DBI1439W The option -immediate was used when running db2set, but the variable specified cannot be updated immediately

Explanation

The registry was successfully updated with the new value, however, it is never possible for the change to the variable specified by the db2set -immediate call to take effect immediately. The -immediate option has been ignored.

User response

Do not supply the -immediate option when updating this specific variable.

DBI1440W A db2set -immediate call was made, the offline registry was successfully updated, but db2set could not attach to the instance

Explanation

Although the offline registry was updated successfully, the value cannot be applied immediately by one or more members because db2set could not attach to the instance.

User response

Try attaching to the instance explicitly and re-run the command and verify that all members of the instance are healthy.

DBI1441W A db2set -immediate call was made but the dynamic update failed on one or more hosts or members

Explanation

The offline registry was successfully updated, and the registry update has been made immediately on all of the hosts or members db2set could access.

On the hosts or members that db2set could not access, however, the setting for the variable specified could not be applied immediately.

User response

Make sure that all members can be accessed from the host where the command was issued and re-run the command or try attaching to each host or member explicitly and re-run the command. Alternatively, all members will see the changes the next time they restart.

DBI1442W Some variables governed by the aggregate variable aggregate_name were updated dynamically, although some variables it governs do not support an immediate change.

Explanation

The aggregate registry variable was successfully updated immediately. Some of the variables governed by the aggregate variable were changed dynamically, but other variables governed by the aggregate variable require the instance to be restarted to take effect.

User response

Restart the instance for all of the variables governed by this aggregate registry variable to take effect.

DBI1443W One or more registry variables meant to take effect for the whole instance have different values on different hosts.

Explanation

On the Windows operating system, registry variables are stored within the operating system registry of each host. Currently at least one registry variable has been set to a number of different values across hosts. It is highly recommended to keep each registry variable set consistently on all hosts.

User response

Make sure that all DB2 registry variable settings are consistent on all hosts and re-run the command.

DBI1444E The db2ls command cannot be found in the expected directory directory-name.

Explanation

The database product installation path passed to the db2ls command with the -b option must be the location of a copy with DB2 Version 9 or later installed.

User response

Specify a database product installation path of a copy with DB2 Version 9 or later installed.

DBI1445E The -b install-path option is mandatory when the -q option is specified. For a list of database product installation locations to query, run the db2ls command without the -b and -q options.

DBI1446I The %1 command is running.

DBI1447E A Java Runtime Environment is needed to run the program program-name.

Explanation

The execution of the command requires a Java Runtime Environment (JRE). If IBM Software Development Kit (SDK) for Java is installed with the related DB2 copy, the JRE is found in <DB2DIR>/java/jdk64/jre/bin for 64-bit Linux systems, or <DB2DIR>/java/jdk32/jre/bin for 32-bit Linux systems, where <DB2DIR> represents the installation path of the related DB2 copy.

If a JRE is not found in either path, the program looks for a JRE in either:

  • the current user's ${JAVA_HOME}/jre/bin, or,
  • the default PATH environment.

In this case, the JRE must meet the current DB2 version requirements.

User response

Install the IBM Software Development Kit (SDK) for Java and rerun the program.

DBI1448E An error occurred during the creation or removal of an entry on the main menu. Log file: log-file-name.

Explanation

On Linux operating systems, main menu entries for database tools can be created and removed manually or automatically. Main menu entries for database tools, such as db2fs, can be created manually by running the db2addicons command, or created automatically when some commands are run. These main menu entries can be removed manually by running the db2rmicons command, or removed automatically when some commands are run. Errors occurred during either the creation or removal of these main menu entries.

User response

Check the error log file for details and rerun the program.

DBI1449I Usage: db2addicons [-h]

Explanation

The db2addicons command creates main menu entries for the database tools, such as db2fs, for the current user. The main menu entries for the database manager tools are created by manually running the db2addicons command, or are created automatically when some commands are run.

The only argument for this command is:

-h

displays the usage information.

User response

Enter the db2addicons command again without any argument.

DBI1450I Usage: db2rmicons [-h]

Explanation

The db2rmicons command removes main menu entries for the database tools, such as db2fs, for the current user. The main menu entries for the database tools are removed by manually running the db2rmicons command, or are removed automatically when some commands are run.

The only argument for this command is:

-h

displays the usage information.

User response

Enter the db2rmicons command again without any argument.

DBI1451E A database manager instance environment is not set to run the program program-name.

Explanation

On Linux operating systems, the database manager instance environment needs to be set for the current user before the command can be run. An instance environment can be setup with:

  • <Instance_HOME>/sqllib/db2profile (for Bourne shell and Korn shell users), or
  • <Instance_HOME>/sqllib/db2chsrc (for C shell users)

where <Instance_HOME> is the instance owner's home directory.

User response

Set up the database manager instance environment and rerun the program.

DBI1452E You do not have the authority to install the network version of the DB2 Information Center. Installing the product named product-name requires root authority. You can find the workstation version of the DB2 Information Center in the subdirectory called "workstation" of the folder located at folder-location, at IBM Passport Advantage, or at the following URL: www.ibm.com/support/docview.wss?rs=71&uid=swg27009474. You do not need to have root authority to install the workstation version of the DB2 Information Center.

DBI1453E Invalid component name component-name

Explanation

Specified component name is either incorrect or misspelled. If the component name is correct, this component name might not be valid on this operating system or platform.

User response

Check to see if the component name is a valid DB2 component for the current operating system or platform.

DBI1454E instance-name is a DB2 pureScale instance. Validation on this type of instance is not supported in the current DB2 release.

Explanation

The db2val command does not support validation on a DB2 pureScale instance.

User response

No action required.

DBI1455W The information on instance instance_name will not be added to the generated response file.

Explanation

The specified instance is a DB2 pureScale instance. When the db2rspgn command is run against a DB2 pureScale instance the information on the specified instance is not added to the generated response file and the instance profile is not created.

User response

No action required

DBI1456W The command-name command failed because it was executed on a member that is not the coordinating member of the instance instance-name.

Explanation

The command is only supported on the coordinating member of the instance.

User response

Run the command on the coordinating member of the instance.

DBI1457E The database product or feature could not be uninstalled. To uninstall, the following list of instances must be dropped: instance-list.

Explanation

The product or feature must not be associated with any instances when it is uninstalled. The db2ilist command is used to list installed instances.

User response

Drop the offending instances using the db2idrop command and re-run the db2_deinstall command.

DBI1458E The db2iupdt or db2iupgrade commands are not supported on a non instance-owning member.

Explanation

The db2iupdt command can be used to update an instance to a higher level within a release. The db2iupgrade command upgrades an instance to a DB2 copy of the current release from a DB2 copy of a previous release. The instance update and upgrade are only supported on the instance-owning member.

User response

Run the db2iupdt or db2iupgrade command on the instance-owning member.

DBI1459E The db2_deinstall command failed because some DB2 database files are in use.

Explanation

You can uninstall database products, features, or languages using the db2_deinstall command.

Before you can uninstall any part of a non-root installed database manager instance, all operating system processes and resources for that instance must be release. This message is returned when an attempt is made to uninstall a non-root installed instance while some DB2 database-related system resources have not been freed. For example, this message can be returned for the following reasons:

  • DB2 database-related operating system processes are still running
  • DB2 database-related libraries are still loaded in memory

User response

  1. Stop the database manager using the db2stop force command
  2. Run the db2_deinstall command again

DBI1460E Command parameter combination is invalid.

Explanation

When using the db2setup command, if the -c parameter is specified to validate the contents of a response file, the -r parameter indicating the response file must also be specified.

User response

Rerun the db2setup command specifying both the -c and -r parameters.

DBI1461E The distributed fix pack installation failed because the -H parameter was specified with the installFixPack command, but the installer detected no DB2 pureScale components in the base copy of the database product.

Explanation

You can update the installed database products to the same level by using the installFixPack command.

In DB2 pureScale environments only, you can update multiple hosts in a DB2 cluster by specifying the -H parameter with the installFixPack command.

This message is returned when the -H parameter is specified with the installFixPack command in an environment that is not a DB2 pureScale environment.

User response

Rerun the installFixPack command without the -H parameter.

DBI1462I The db2setup command is validating the response file provided. This can take several minutes.

Explanation

Validation process in progress.

User response

No action required.

DBI1463E The response file validation failed. Log file: path_to_logfile

Explanation

Invalid entries were detected in the response file. For more details, refer to the log file.

User response

Correct the response file errors and rerun the command.

DBI1464E Conflicting installFixPack command parameters specified. Parameters: conflicting-parameter-list.

Explanation

There are specific parameters related to specific actions in the installFixPack command. Some parameters cannot be specified for some actions.

This message is returned when two parameters of the installFixPack command cannot be specified together because the syntax does not support such usage.

User response

Review the syntax of the installFixPack command and re-issue the command with the correct parameters.

DBI1465E An error occurred in the host list file. Host file: host-file-name.

Explanation

An error was detected in the specified host list file. The error can occur for any of the following reasons: the file does not exist, the file is not readable, the file is empty or contains an invalid character, the path name is not specified, or the HOST keyword is not valid.

User response

Check the contents of the specified host list file, and rerun the command.

DBI1466E Instance validation failed. Instance name: instance_name. Reason code: reason_code. Current host name: host_name.

Explanation

The specified reason code indicates one of the following errors occurred:

1

The IBM Reliable Scalable Cluster Technology (RSCT) peer domain is not online

2

The IBM General Parallel File System (GPFS) cluster is not online

3

At least one db2 cluster services alert is indicated

User response

Depending on the specified reason code, take the appropriate action:

1

Bring the RSCT peer domain online by entering the following command: db2cluster -cm -start -domain domain_name

2

Start the GPFS cluster by entering the following command: db2cluster -cfs -start -host host_name

3

Clear all alerts by running the following command: db2cluster -list -alert

DBI1467N The db2ndrop command was not able to drop the multiple partition instance member 0.

Explanation

The db2ndrop command is used to drop a database partition server from an instance that has no databases.

The db2ndrop command cannot drop the instance owning database partition server (0). To drop a database partition server that is assigned to the logical port 0 from a machine that is running multiple logical database partition servers, all other database partition servers assigned to the other logical ports must be dropped first. Each database partition server must have a database partition server assigned to logical port 0.

User response

Use the db2idrop command to drop the multiple partition instance member 0, after the rest of members have been dropped using the db2ndrop command.

DBI1468E Instance validation failed. Instance: instance_name. Log file: path_to_logfile. Hosts: host_name.

Explanation

The validation failed on the specified hosts.

User response

Check the log file for more details.

DBI1469W The DB2 copies of the hosts participating in the instance do not have the same code level or install path. Instance: instance_name.

Explanation

The instance might be in the rolling update stage.

User response

Update your instance to the same level and the same path on all participating hosts in the instance using the db2iupdt command.

DBI1470E The instance validation failed on host host_name. Reason code = reason_code.

Explanation

The specified reason code indicates one of the following errors occurred:

1

Validation on the specified host did not finish before time-out.

2

The instance is configured to use passwordless SSH and passwordless SSH communication between the specified host and other hosts failed.

3

Instance shared directory cannot be accessed from the given host or is not shared between the given host and the local host.

4

Some files in the instance directory are damaged. The symbolic links of the files are not pointing to the instance shared directory.

5

The specified host is offline in the RSCT peer domain.

6

The specified host is stopped in the GPFS cluster.

7

Installation file validation failed for the DB2 copy on the specified host.

User response

Depending on the specified reason code, take the appropriate action:

1

Rerun the db2val command on the specified remote host.

2

To use passwordless SSH, configure passwordless SSH access for the instance owner on the host machines.

3

The instance shared directory must be accessible from the specified host. The directory path must be accessible from all the hosts, and must have read/write permission.

4

To fix the symbolic links, run db2iupdt <instance_name> as root.

5

Bring the host online by running the following command: db2cluster -cm -start -host <host-name>

6

Bring the host online by running the following command: db2cluster -cfs -start -host <host-name>

7

Check the log file for more details.

DBI1471I db2setup validated the response file successfully. Log file: path_to_logfile.

Explanation

The validation process completed successfully.

User response

Check the log file for details.

DBI1472W The db2val -d parameter is deprecated. The deprecated parameter is replaced by the -t trace_file parameter.

Explanation

The deprecated parameter will be removed from a future release.

User response

Replace the deprecated parameter with the new parameter in any scripts or applications.

DBI1473W Parameter deprecated-parm-name is deprecated. The deprecated parameter is replaced by new parameter new-parm-name. Command: command-name.

Explanation

The deprecated parameter might be removed from a future release.

User response

Replace the deprecated parameter with the new parameter in any scripts or applications.

DBI1474E The instance shared mount point path is invalid. Command: command-name.

Explanation

In the specified command, the path specified for the instance shared mount point must be a new path and must not be a sub-directory of an existing GPFS file system.

User response

Rerun the command specifying a new path for the instance shared mount point.

DBI1475E The installation failed because only the root user is permitted to install DB2 pureScale.

Explanation

To install the DB2 pureScale Feature you must be logged in as the root user. Installation is restricted to the root user because components required by DB2 pureScale affect shared resources on the system.

User response

Review the prerequisites for DB2 pureScale before attempting another installation.

DBI1476E The db2_install command failed because the option "-f PURESCALE" was specified and the following option that is not supported with the "-f PURESCALE" option was specified: option.

Explanation

This message is returned when the db2_install command is issued with the "-f PURESCALE" option and another option is also specified that is not supported with the "-f PURESCALE" option.

User response

Respond to this message in one of the following ways:

  • To include DB2 pureScale in the installation, rerun the db2_install command without specifying the option that is not supported with the "-f PURESCALE" option.
  • If you do not want to install DB2 pureScale, rerun the db2_install command without specifying the "-f PURESCALE" option.

DBI1477E The db2cluster_prepare command failed because of a syntax error. Reason code: reason-number.

Explanation

The syntax entered was invalid. See the corresponding reason code for an explanation of the cause of the error.

  1. The -cfs_takeover and -instance_shared_dev option are mutually exclusive, when specifying one option for db2cluster_prepare the other cannot be used.
  2. The db2cluster_prepare command failed because one or more parameters were specified multiple times.
  3. The db2cluster_prepare command failed because no value was specified for the -instance_shared_dev parameter.
  4. The db2cluster_prepare command failed because no value was specified for the -t parameter.
  5. The db2cluster_prepare command failed because no value was specified for the parameter named -l.
  6. The db2cluster_prepare command failed because no value was specified for the -instance_shared_dev parameter.

User response

Rerun the db2cluster_prepare command with the correct syntax. For the correct syntax, see the command reference or run the command with the "-?" option, by typing "db2cluster_prepare -?".

DBI1478E The GPFS binary update failed. Installation detected one or more GPFS efixs that were not originally installed by the database product. Installation cannot proceed until these efixes are manually removed. efixes: efix_list

Explanation

The GPFS efixes detected by the installer were not installed by the database product. The installer can only remove efixes installed as part of a database product installation. The specified efixes must be removed manually.

User response

Manually remove the efixes, and rerun the command.

DBI1479N The syntax of the DB2NDROP command is incorrect.

Explanation

The DB2NDROP utility drops a node from a partitioned system.

DB2NDROP /n:node
         [/i:instance]

The command options are:

  • /i Specify the instance if different from the default/current instance

User response

Issue the DB2NDROP command with one of the valid command options.

DBI1480N Node node not found for instance instance.

Explanation

DB2NDROP failed because the node does not exist.

User response

Ensure the node number is correct and reissue the command.

DBI1481W Node node for instance instance has been deleted.

Explanation

The DB2NDROP processing has completed successfully.

User response

No further action is required.

DBI1482E Syntax error, the db2_deinstall command options to skip the removal and remove the same feature are mutually exclusive.

Explanation

The '-s' option skips the removal of a feature, and the '-F feature-name' option specifies that feature feature-name, should be removed. These two options must not contain the same feature identifier.

User response

If you want to remove the feature, rerun the command without the '-s feature-id' option. If you want to skip the removal of the feature, rerun the command without the '-F feature-id' option.

DBI1483E Syntax error, the '-F GPFS' option is not valid.

Explanation

The GPFS feature cannot be removed with '-F GPFS' option of the db2_deinstall command. By default, the GPFS feature will be removed with the 'db2_deinstall -a' command when you remove the last DB2 copy and GPFS is not still in use, if GPFS was installed by the database product installer.

User response

Rerun the db2_deinstall command without the '-F GPFS' option. See the uninstall documentation for more information.

DBI1493W A Reliable Scalable Cluster Technology (RSCT) peer domain was detected, IBM Tivoli System Automation for Multiplatforms (SA MP) cannot be removed by the DB2 uninstall process.

Explanation

If an RSCT peer domain is present, the Tivoli SA MP component is not uninstalled with the DB2 copy to prevent adverse behavior of other copies or applications, which might depend on the peer domain or Tivoli SA MP.

User response

If there are no other DB2 copies or applications dependant on Tivoli SA MP component and the component is no longer required, remove it.