DBI20000E A database manager instance could not be created as specified. A rollback of the instance creation will be started.

Explanation

The message indicates that the instance creation failed. Instance rollback happens on all involved hosts. Instance rollback is triggered if one of the following happens:

  • Any operation (DB2 binary installation, GPFS cluster setting, RSCT peer domain setting, and instance file set creation, for example) fails on install-initiating host (IIH).
  • Any operation fails on a CF host.
  • Any operation fails on all member hosts.

Instance rollback does not roll back DB2 binaries.

User response

For details, see the installation log. By default, the installation log is located in the /tmp directory. Additional error messages and details are contained in the log file. After fixing the problems shown in the log file, re-run the instance creation command.

DBI20001E A database manager instance could not be created as specified. A rollback of the instance creation has been performed.

Explanation

Instance creation rollback has been performed on all involved hosts. If DB2 binaries are successfully installed, they will not be rolled back. The DB2 pureScale instance that was partially created during the current installation has been removed.

User response

For details, see the installation log. By default, the installation log is located in the /tmp directory. After fixing the problems shown in the log file, re-run the instance creation command.

DBI20002E A database manager instance has been partially created. DB2 members that could not be added successfully will not be included in the instance. A cleanup of the affected members will be started.

Explanation

The message occurs when the instance is partially created on some of the hosts. Instance rollback happens on the hosts where the instance creation did not complete. Some immediate messages in the installation log after this line are rollback related. Rollback of the partial instance creation is triggered if any operation (DB2 binary installation, GPFS cluster setting, RSCT peer domain setting, instance file set creation, for example) fails on a member host, then rollback happens on the corresponding host.

Instance rollback does not roll back DB2 binaries.

User response

To determine the members that were not successfully added into the instance, see the log file. Additional error messages and details are contained in the log file. After fixing the problems shown in this log file, re-run the instance creation command.

DBI20004E An error occurred while removing registry_variable global registry variable record on the following hosts: host-name-list.

Explanation

This error occurs when removing the GPFS_CLUSTER global registry or the PEER_DOMAIN global registry from specific hosts.

User response

Contact IBM Software Support.

DBI20006E Installing the IBM Data Server Driver Package failed because the installer could not determine whether to install a new copy or to upgrade an existing copy because no copy name was specified.

Explanation

On Windows operating systems, the IBM Data Server Driver Package simplifies application deployment. This driver, which has a small footprint, is designed to be redistributed by independent software vendors (ISVs) and to be used for application distribution in mass deployment scenarios typical of large enterprises.

You can install the IBM Data Server Driver Package or perform a maintenance install on an existing copy of the driver package using either the DB2 Setup wizard or the SETUP command. When you install the IBM Data Server Driver Package, the behavior of the installer depends on whether there are copies of the driver package already installed and whether a driver package copy name is specified to the install utility.

This message is returned when an attempt is made to install the IBM Data Server Driver Package and the installer cannot determine whether to create a new copy of the driver package or to perform a maintenance install on an existing copy of the driver package.

User response

To install a new copy of the IBM Data Server Driver Package, use one of the following methods:

Using the GUI installer
  • Install a new copy using the generated, default name by issuing the SETUP command with the /o option.
  • Install a new copy using a name you choose by issuing the SETUP command with the /n <copy-name> option.
Using a silent install

Set the COPY_NAME keyword to a new copy name in the response file.

To perform a maintenance installation on an existing IBM Data Server Driver copy, specify which copy to upgrade using one of the following methods:

Using the GUI installer

Issue the SETUP command with the /n <copy-name> option to specify the copy you want to upgrade.

Using silent install

Set the COPY_NAME keyword to the existing copy you want to upgrade in the response file.

DBI20007E Upgrading the IBM Data Server Driver for ODBC and CLI failed because multiple copies of the driver exist on the system and the upgrade utility could not determine which copy to upgrade.

Explanation

You can install multiple copies of the IBM Data Server Driver for ODBC and CLI on the same machine. You might want to do this if you have two database applications on the same machine that require different versions of the driver. When multiple copies of the driver exist on this system, you can identify one of them as the "default" copy.

To upgrade a copy of the IBM Data Server Driver for ODBC and CLI when multiple copies of the driver are installed on the same system, the upgrade utility can determine which copy to upgrade in two ways: The name of the copy to upgrade can be specified with the upgrade command. If one of the copies is identified as the default and no name is specified with the upgrade command, the upgrade utility will upgrade the default copy.

This message is returned when an attempt is made to upgrade one of multiple copies of the IBM Data Server Driver for ODBC and CLI on a system and none of the existing copies is set as the default and no coy was specified by name with the upgrade command.

User response

To upgrade an existing IBM Data Server Driver copy, specify which copy to upgrade using one of the following methods:

Using the GUI installer

Issue the SETUP command with the /n <copy-name> option to specify the copy you want to upgrade.

Using silent install

Set the COPY_NAME keyword to the existing copy you want to upgrade in the response file.

DBI20008W Neither the Path environment variable nor the Classpath environment variable were updated during the installation of the IBM Data Server Driver Package because the following DB2 copy was previously installed: copy-name.

Explanation

When you install the IBM Data Server Driver Package, you can specify that the Data Server Driver Package should be the default database client interface.

When the Data Server Driver Package is set as the default database client interface during install, the Path and Classpath environment variables are automatically updated to include Data Server Driver Package details. However, if the Data Server Driver Package install detects that another IBM data server client or driver is already installed, the Path and Classpath environment variables will not be updated to include Data Server Driver Package details.

This message is returned when the Data Server Driver Package install detects that another IBM data server client or driver is already installed and as a result does not update the Path or Classpath environment variables.

User response

To configure the environment for the Data Server Driver Package, manually update the Path and Classpath environment variables.

DBI20009E Creation of SA MP resources for the database manager instance, instance_name, has failed. The instance creation will be rolled back.

Explanation

During instance creation, the database product installer creates IBM Tivoli System Automation for Multiplatforms (SA MP) resources by calling the following command as the instance user:


db2cluster -cm -resources -create

Error messages returned from the db2cluster command can be found in the following log file:


<instance_user>/sqllib/db2dump/db2diag.log

If there is a problem, the directory containing this log file is backed up as /tmp/db2dump.process_id during rollback.

This message is returned when the installer encounters a problem while creating the SA MP resources for the instance.

There are multiple reasons why this message might be returned. For example, this message can be returned if the db2nodes.cfg file incorrect or failed to be created. The file can be found at <instance_user>/sqllib/db2nodes.cfg. During rollback, the file is backed up as /tmp/db2nodes.cfg.process_id.

User response

Collect all log and trace files and then contact IBM software support.

DBI20010W The installer detected that a copy of Tivoli SA MP is already installed, and that the version of the currently installed Tivoli SA MP product is older than the version that is included in the database product installation media. If the installation proceeds, Tivoli SA MP will be updated or upgraded to the following new version: new-SA-MP-version.

Explanation

You can use the copy of the Tivoli System Automation for Multiplatforms (SA MP) Base Component that is integrated with your database product to manage the high availability of your database system. You can install IBM Tivoli SA MP by using either the database product installer or the installSAM installation script that is included in the database product installation media.

The database product is intended to use the version of Tivoli SA MP that is included in the database product installation media. If an older version of Tivoli SA MP is already installed before the database product is installed, Tivoli SA MP must be updated or upgraded to the version that is included in the database product installation media..

This message is returned when the database product installer detects an older version of Tivoli SA MP is already installed.

User response

Optional: verify that other software on the system that is using the currently installed version of Tivoli SA MP is compatible with the new version of Tivoli SA MP.

DBI20011E Deletion of the RSCT peer domain, domain_name, failed. Manually remove the domain by running the following command: command.

Explanation

Deletion of the RSCT peer domain error can occur during a rollback or when running the db2idrop -g command.

User response

To manually remove the RSCT peer domain by performing the following steps:

  1. Check if there is still resource attached to the peer domain by running lssam. If not, proceed to step 5.
  2. Switch to the instance owner by su - instance_owner
  3. Remove resource by db2cluster -cm -repair -resources
  4. Switch back to root.
  5. Remove RSCT peer domain by db2cluster -cm -delete -domain domain_name.

DBI20012W The database product installer successfully upgraded the SA MP Base Component. Previous version: old-SA-MP-version. New version: new-SA-MP-version. However, the license of the new SA MP product is a trial license, not a full license.

Explanation

You can upgrade IBM Tivoli System Automation for Multiplatforms (SA MP) using either the database product installer or the installSAM install script that is included in the IBM Data Server install media.

Depending on which database product licenses you have purchased, there are conditions under which you can use IBM Tivoli System Automation for Multiplatforms (SA MP) that is integrated with IBM Data Server.

This message is returned when a fully licensed version of SA MP Base Component is upgrade to a version of SA MP that has only a trial license. It is possible that if the host machine on which the trial version of the SA MP product is installed is restarted, the SA MP product will not longer function.

User response

For full use of the SA MP product, update the trial license of the SA MP product by performing the following steps:

  1. Acquire a full license key from either the IBM Passport Advantage web site or the activation CD in an installation media pack from IBM.
  2. Register the license key by using the db2licm command.

DBI20013E The database product installer detected that the given device path device_path is a symbolic link on the host host_name.

Explanation

This message indicates that the given device path for tie-breaker device path, or instance shared device, is a symbolic link. The device path must be a storage device.

User response

Specify a valid storage device as the device path.

DBI20014E Removal of DB2 resources has failed for database manager instance instance_name.

Explanation

Instance resource is the RSCT resource created for the DB2 pureScale instance during instance configuration. The instance is not in a usable state.

  • This error might occur when a DB2 pureScale instance creation is rolled back or a DB2 pureScale instance is dropped.
  • The command that the installer internally calls is db2cluster -cm -resources -delete running as the instance user. For more details, see the db2cluster command.
  • During db2idrop -g, if instance resource deletion fails, no further instance dropping action will be performed. The log file for this command is <instance_user>/sqllib/db2dump/db2diag.log.
  • Check if <instance_user>/sqllib/db2nodes.cfg is valid.
  • During a rollback in instance creation, instance resource deletion will also be called. Since rollback rolls back <instance_user>/sqllib, the file is backed up as /tmp/db2diag.log.process_id.

User response

For more details, see the db2diag.log for error messages. This log file can be found in <instance_user>/sqllib/db2dump/db2diag.log. Correct the problem and rerun the db2idrop command.

DBI20015E Shrinking of the RSCT peer domain, domain_name, failed on the following hosts: host-name-list. Manually remove the hosts by running the following command: command.

Explanation

This error can occur during partial rollback or db2iupdt -drop. It occurs because shrinking of the RSCT peer domain has failed.

User response

Manually remove failed hosts from the RSCT peer domain by performing the following steps:

  1. Check if there are still resources attached to the host by running lssam.
    • if a resource is still attached, proceed to step 2.
    • if a resource is not attached, run db2cluster -cm -remove -host host_name from IIH.
  2. From the install-initiating host (IIH), switch to the instance owner by running su - instance_owner.
  3. Remove resource by running db2cluster -cm -delete -resources.
  4. Switch back to root.
  5. Remove the failed hosts from the RSCT peer domain by running db2cluster -cm -remove -host host_name.
  6. Switch to the instance owner again.
  7. Recreate the resources by running db2cluster -cm -create -resources.
  8. Switch back to root.

DBI20016E The cluster interconnect netname net_name for host host_name is not on the same subnet as the installation-initiating host.

Explanation

This error occurs when the cluster interconnect netname for a host is not on the same subnet as the installation-initiating host.

All cluster interconnects need to be on the same subnet for performance reasons (all hosts within the same subnet can usually be reached in one routing hop). For example if the cluster interconnect network is configured with the network address 192.168.0.0/24, then all cluster interconnect netname addresses should start with 192.168.0 (for example, 192.168.0.1, 192.168.0.2, and so on).

User response

Check the network card configuration on the new host (for example run ifconfig -a ) and check /etc/hosts if a name was used instead of an address. Reconfigure the network adapter or choose a different one.

DBI20017E The cluster interconnect netname net_name is invalid.

Explanation

The database product installer cannot identify the cluster interconnect netname.

User response

Check the following:

  • Check the command for a typo error
  • Check the machine's network configuration (for example check /etc/hosts) or
  • Use the ping and nslookup tools to confirm the cluster interconnect netname maps to the same IP address on all hosts. Check that the IP address maps back to the same cluster interconnect netname on all hosts.

Enter the netname or IP address of a valid device.

DBI20018E The cluster interconnect netname for host host-name failed to ping the installation-initiating host.

Explanation

When adding a new host, validation checks to see if the new host can send a small data packet to the install-initiating host (IIH) and receive a reply. This send-reply test is commonly known as a ping. This message is the result of a failed ping.

User response

Check the network adapter and cable, or choose a different one. If there is a problem, you can verify the results by running this command line from the remote host's console: ping <installation-initiating host name>. After it is verified that the problem occurs outside the database product installer, there are various things you can check to find the source of the problem. For example:

  • bad physical connections (for example a loose cable),
  • a non-working network adapter driver,
  • misconfigured network.

DBI20019E The database product installer detected a conflict between the DEFAULT_INSTPROF record and the instance shared directory specified.

Explanation

The DEFAULT_INSTPROF record in the Global Registry indicates the instance shared file system has already been set up by the database product installer. In this case, the following options or keywords are not needed:

  • For response file installations:
    • INSTANCE_SHARED_DEVICE_PATH
    • INSTANCE_SHARED_DIR
  • For the db2icrt or db2iupdt command:
    • instance_shared_dev
    • instance_shared_dir

If the value for INSTANCE_SHARED_DIR (or instance_shared_dir) does not match with the existing instance shared file system mount point, the installation fails.

User response

Do not specify the instance shared directory.

DBI20020E The database product installer detected that GPFS cluster cluster_name was previously created on host host_name. However, the GPFS cluster is offline on that host.

Explanation

A GPFS cluster created by the DB2 software already exists. To create a DB2 pureScale instance by reusing this GPFS cluster, bring the cluster online on the specified host.

User response

To start the GPFS cluster, run the following command:


<installed_path>/bin/db2cluster -cfs -start -all

DBI20021E The database product installer detected that the reg-var variable record is defined in the global registry. However, the value dir-name is not an existing directory.

Explanation

This message occurs if the global registry variable record specified indicates that a shared file system already exists. The database product expects a shared file system exists for the instance shared file.

The directory name value is the mount point for the file system. The database product installer detects the mount point does not exist on the system. A possible reason is the specified global registry record is left over from a previous DB2 operation and the actual file system does not exist anymore, or, the filesystem was remounted somewhere else but the registry entry was not changed.

User response

Contact IBM Software Support.

DBI20022E The database product installer detected that the variable record reg-var is defined in the global registry. However, the GPFS cluster does not exist on host host_name.

Explanation

The global registry variable record GPFS_CLUSTER indicates that there is a DB2-created GPFS cluster on the host. In this case, the installer detects there is no GPFS cluster on the host. The database product expects an existing GPFS cluster on this host.

User response

Contact IBM Software Support.

DBI20023E The installation operation failed because a user-managed RSCT peer domain is active on the following host machine: host-name.

Explanation

This error occurs when the database product installer fails to create an IBM Reliable Scalable Cluster Technology (RSCT) peer domain on a host because another, user-managed RSCT peer domain is active.

The peer domain that was not created by the database product installer must be stopped or removed prior to creating an RSCT peer domain by the database product installer.

User response

  1. Stop the peer domain on the host specified by using the using db2cluster command or the stoprpdomain command.
  2. Restart the installation process.

DBI20024E The database product installer detected that the given device path device_path is not a valid device on host host_name.

Explanation

This message indicates that the given device path for tie-breaker device path, or instance shared device, is not a storage device. The device path must be a storage device. A device can be invalid for the following reasons:

  • there are existing files or directories
  • the device does not exist
  • the device is not a storage device, such as pipe, fifo device, character device
  • root has no searchable access authority to the given path
  • the path name is too long.

User response

Specify a valid storage device as the device path.

DBI20025E The database product installer detected that the IBM Reliable Scalable Cluster Technology (RSCT) peer domain domain_name was previously created on host host_name by DB2, but the peer domain is offline on that host.

Explanation

This error occurs when the database product installer detects that an RSCT peer domain was previously created on a host, but it is offline and the installation-initiating host is in a different RSCT peer domain. The remote host must be removed from the host list.

User response

To remove the host from a DB2 pureScale instance:

  1. log on to a different host which belongs to the same DB2 pureScale instance
  2. run db2iupdt [-d] -add -m|cf <host_name>:<interconnect_name> -u <fenced_id> <instance_owner>

DBI20026E The following hosts host-name-list are not included in the instance.

Explanation

This post installation message shows the hosts that have not been included in the instance due to an error. If DB2 binaries were successfully installed, they have not been removed. Look in the installation log for more information on the error that has caused this rollback.

User response

After fixing the problems shown in this log file, extend the instance to these hosts by running the instance extension command (db2isetup -add or db2iupdt -add).

DBI20027E The GPFS cluster creation failed on host host_name. Failed command: command_name.

Explanation

The GPFS cluster failed to be created during instance creation. This failure will trigger an instance creation rollback.

The db2cluster command log file can be found in /tmp/ibm.db2.cluster.*

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command.

DBI20028E The GPFS cluster, db2cluster_xxxx, cannot be deleted using the command_name command.

Explanation

This message occurs when the GPFS cluster fails to be deleted during a rollback.

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command to remove the host from GPFS cluster.

DBI20029E The GPFS cluster, db2cluster_xxxx, failed to create the file system fs_name. Failed command: command_name.

Explanation

This message occurs when the GPFS file system creation fails.

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command.

DBI20030E The GPFS cluster, db2cluster_xxxx, failed to extend to host, hostname. Failed command: command_name.

Explanation

This message occurs when the GPFS cluster extension to the host fails.

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command to extend the host.

DBI20031E The GPFS cluster, db2cluster_xxxx, failed to remove the file system fs_name. Failed command: command_name.

Explanation

This message occurs when the newly created GPFS file system fails to be deleted during a rollback.

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command to remove the file system.

DBI20032E The host host_name did not finish validation within the time out period time_period. To change the time out time, set the new time out value (in minutes) using environment variable environment-variable-name.

Explanation

This error occurs because a validation process on the remote machine did not return within the required time out period.

User response

If your machine is slow, you can extend the time out time to give it more time to complete. To change the time out time, set the new time out value (in minutes) using environment variable "environmentvariable1". Rerun the installation command.

If the machine is hanging, collect all information files and contact IBM service.

DBI20033E The host host_name cannot be removed from the GPFS cluster db2cluster_xxxx. Failed command: command_name.

Explanation

This message occurs when the GPFS cluster fails to remove the host.

User response

Refer to the db2cluster command log file. This log file can be found in /tmp/ibm.db2.cluster.*. Additional error messages and details are contained in the log file. After the problem is solved, rerun the command to remove the host from GPFS cluster.

DBI20034I No action is required, there is no user managed cluster to takeover.

Explanation

The db2cluster_prepare command did not detect a IBM General Parallel File System (GPFS). Running the db2cluster_prepare command is not required. When creating a DB2 pureScale instance, a GPFS file system will be created for you.

User response

None.

DBI20035E The PVID for device path device_path on the install-initiating host (IIH) host_name does not exist on remote host remote_host_name.

Explanation

This message occurs because there is no device path that can be found on the remote host with the same PVID as the given device path on the IIH. A matching PVID is required on the remote host.

User response

To check if the PVID is available on all hosts:

  1. Get the PVID of the given device path in the IIH machine.
  2. Make sure the same PVID exists on all hosts.

Configure the PVID on the remote hosts.

DBI20036E The remote host host_name belongs to an active IBM Reliable Scalable Cluster Technology (RSCT) peer domain which was previously created by the DB2 pureScale Feature.

Explanation

This error occurs when the database product installer detects that an RSCT peer domain was previously created by the DB2 pureScale Feature.

User response

To continue, perform one of the following:

  • Remove the remote host from the host list, or,
  • If the remote specified host belongs to a DB2 pureScale instance, remove it from that DB2 pureScale instance using the db2iupdt -drop command.

DBI20037E The remote host host_name belongs to an active IBM Reliable Scalable Cluster Technology (RSCT) Peer Domain which was previously created by the DB2 pureScale Feature, but the installation-initiating host is in a different RSCT peer domain.

Explanation

This error occurs when the database product installer detects that an RSCT peer domain was previously created by the DB2 pureScale Feature but the installation-initiating host is in a different RSCT peer domain.

User response

Perform one of the following actions:

  • Remove the remote host from the host list.
  • If the remote host belongs to a DB2 pureScale instance, remove that host from that DB2 pureScale instance by calling the db2iupdt command specifying the -drop parameter.

DBI20038E The remote host host_name belongs to a GPFS cluster.

Explanation

The database product does not allow the joining of multiple GPFS clusters. The current host and the remote host indicated belongs to different GPFS clusters.

When the install-initiating host (IIH) is part of a GPFS cluster, the remote host should either not belong to a GPFS cluster, or, belong to the same GPFS cluster. When IIH is not part of a GPFS cluster, the remote host should not belong to a GPFS cluster.

User response

To resolve this error, perform one of the suggestions below and reissue the command:

  • Remove the remote host from the host list.
  • Prior to adding the host to the current DB2 pureScale setup, remove the host from the other GPFS cluster.
  • For an instance creation, to reuse the GPFS cluster defined on the remote host, start the instance creation on the remote host.

Reissue the command.

DBI20039E The new copy, new-copy-name, must be installed to another path. The installation path specified, new-copy-path, contains an existing database product with the DB2 copy name existing-copy-name.

Explanation

New copies must be installed to a path which does not contain an existing copy.

User response

To install the new copy, specify a new path. To work with the database product installed at this location, exit the installation and select the 'Work with Existing' option from the setup launchpad.

DBI20040E The path specified in the response file by the keyword FILE, provided-path, contains an installed DB2 copy with DB2_COPY_NAME existing-copy-name that does not match the copy name provided in the response file, provided-copy-name.

Explanation

The path and name pair provided in the response file by keywords FILE and DB2_COPY_NAME is invalid. The path specified contains an existing DB2 copy with a copy name that is different from the copy name provided. A path may only contain a single DB2 copy.

User response

Ensure the correct copy name and path are provided and run the command again.

DBI20041E You cannot drop host host_name from the instance instance_name because host host_name is the installation-initiating host (IIH). Host host_name can be dropped from another host in the instance.

Explanation

The db2iupdt -drop command will not drop the last cluster caching facility or the last member, in the DB2 pureScale instance. You must run the db2iupdt -drop command from a host that will still belong to the instance after you've dropped the cluster caching facility or member.

User response

The specified host can be dropped from another host in the instance using the db2iupdt -drop command.

DBI20042E The response file keyword DB2_COPY_NAME value, provided-copy-name, is invalid for the path, provided-copy-path, specified by the keyword FILE. That copy exists on path existing-copy-path.

Explanation

The DB2_COPY_NAME provided exists, but not on the path provided. When working with an existing copy of database product installed on Windows, the correct installation path must be specified.

User response

To perform a new installation, specify a unique value for DB2_COPY_NAME. To work with an existing copy, ensure the keyword DB2_COPY_NAME corresponds to the correct path specified by keyword FILE.

DBI20043E DB2 failed to install because of restrictive permission settings on the temporary directory, tmp-directory.

Explanation

The temporary directory is used by the database manager to store files necessary for creating and managing instances and database objects. To install or update DB2 the temporary directory must be enabled for read, write and execute access to all users.

User response

Perform the following actions:

  • Enable read, write, and execute permission on the temporary directory for all users.
  • In a DB2 pureScale environment, enable read, write, and execute permission on the temporary directory for all users on all host machines in the DB2 cluster.
  • If the temporary directory is a mounted drive, mount the drive such that all users may directly execute binaries on the drive. (For example, do not specify the noexec parameter with the mount command.)

DBI20044E The parameter parameter-name is missing or invalid.

Explanation

The specified parameter is either missing, or invalid. Some parameters are mandatory in a response file for the specified command, however, certain combinations are not supported. For example, the PREFERRED_PRIMARY_CF parameter, or the PREFERRED_SECONDARY_CF parameter, can only be specified for a instance type of 'dsf'.

User response

Check the response file for the specified parameter.

DBI20045E DB2 failed to create a DB2 pureScale instance because the detected operating system is not supported.

Explanation

The DB2 pureScale Feature for Linux is only supported on specific distributions.

User Action Consult the documentation for installing the DB2 pureScale Feature for information on software considerations in the installation prerequisites.

User response

DBI20046E The DB2 pureScale instance could not be created because the uDAPL configuration file could not be accessed.

Explanation

The user Direct Access Programming Library (uDAPL) configuration file could not be accessed while attempting to create the DB2 pureScale instance. The DAPL configuration file is referenced by the DB2 pureScale Feature to verify the presence of a remote direct memory access (RDMA) capable network adapter. The file must be accessible on the path /etc/dat.conf.

User response

If a backup copy of the file exists, restore it to the original location.

DBI20047E The database product installation process failed on the following host or hosts: host-list.

Explanation

All software components of the DB2 pureScale Feature are installed and configured from a single host. If the installation of the feature fails on any one of the host machines, the database product installation process cannot complete.

There are several reasons why the installation process might have failed on a host machine:

  • The host name cannot be found.
  • The host is unreachable.
  • Someone other than the root user is performing the installation.
  • Your system does not meet all uDAPL or InfiniBand prerequisites.
  • There is not enough disk space available in the /root or /tmp path to complete the installation.

User response

To help you identify and resolve the reason for the installation failure you can collect diagnostic data by using the db2support tool provided with the install image.

To collect diagnostic data from the affected host or hosts, run the 'db2support -install' command with the -host option.

DBI20048E The database product installation failed because an adapter could not be found to link to the cluster interconnect on one or more hosts. Hosts: host-names.

Explanation

All hosts in a DB2 pureScale environment must be connected to a low latency, high-speed interconnect.

User response

Ensure your environment meets the installation prerequisites, and then rerun the installation.

DBI20049C The installFixPack command failed. The base DB2 copy contains DB2 pureScale instances, however the database product installer cannot detect the hosts in these instances. To install the fix pack on the local host only, rerun the installFixPack command with the -L parameter. To install the fix pack on all hosts, rerun the installFixPack command with the -H parameter specifying the host list file.

Explanation

The database product installer cannot detect which hosts require the fix pack to be applied.

User response

Rerun the command specifying to apply the fix pack to either the local host or to all hosts.

DBI20050I When the installFixPack command is run with the -p parameter, the instances are not updated automatically. You must manually update the instances using the db2iupdt command. If the fix pack is applied on multiple hosts, you must run the db2iupdt command on all hosts.

Explanation

The installFixPack -p parameter does not automatically update instances. This must be performed manually.

User response

Run the db2iupdt command as indicated.

DBI20051C The database product installation has failed on the remote hosts host_name. Review the logged errors then re-run the installFixPack on those machines.

Explanation

The fix pack was not installed successfully. The error log contains details.

User response

Review the error log for additional information.

DBI20052E The fix pack update failed because the DB2 pureScale component is not installed on this host.

Explanation

In environments that are not DB2 pureScale environments, a fix pack cannot be applied across hosts.

In DB2 pureScale environments, to apply fix pack update across multiple hosts, the DB2 copy must have the DB2 pureScale component installed on every host.

User response

  1. Remove the host that does not contain DB2 pureScale component from the host list file.
  2. Rerun the installFixPack command.

DBI20053C The service level (version, release, modification level) on this host is different from the service level on the IIH. Current host level: host_level. IIH level: iih_level. To apply a fix pack update across multiple hosts, the base DB2 copy on all hosts must have the same service level. Apply the fix pack required to bring this host and the IIH to the same service level, and rerun the installFixPack command. Otherwise, rerun the installFixPack command with the -H parameter with the current host removed from the host list file.

Explanation

All hosts must have the same service level to proceed.

User response

Rerun the installFixPack as indicated.

DBI20054C The IIH host is not listed in the specified host list file. IIH host host_name.

Explanation

The IIH host must be listed in the host list file provided by the -H parameter.

User response

Add the IIH host to the host list file and rerun the installFixPack command.

DBI20055I An invalid value was entered for the port number when configuring the TCP/IP settings for a database manager instance. Value: port-value.

Explanation

A database manager instance can be configured during product installation. TCP/IP port values are one of the settings that can be set during instance configuration. The TCP/IP port number is used by a database manager instance to listen for incoming DB2 connections. This message is displayed when an invalid invalid port number is entered. This message also appears in the log file created during a silent install operation

User response

Enter a valid port value of between 1024 and 65535 and try again.

DBI20056E Installation of product product-name could not start because a supported version of Visual Studio and a .NET Framework are not installed.

Explanation

The IBM Database Add-Ins for Visual Studio are included as a separately installable component. Once you are finished installing your database product, you will be presented with an option to install the IBM Database Add-Ins for Visual Studio.

This message is returned when the option to install the IBM Database Add-Ins for Visual Studio is selected and a supported version of Visual Studio and a .NET Framework are not installed.

User response

Install a version of Visual Studio and a .NET Framework that are supported by the database product and then retry the product installation.

DBI20057I product-name was only installed on Visual Studio 2008 and not on Visual Studio 2005 because Visual Studio 2005 Service Pack 1 was not installed.

Explanation

The IBM Database Add-Ins for Visual Studio are included as a separately installable component. Once you are finished installing your database product, you will be presented with an option to install the IBM Database Add-Ins for Visual Studio.

If you have Visual Studio 2008 and Visual Studio 2005 but your Visual Studio 2005 is not at the Service Pack 1 level, then VSAI will only be installed on Visual Studio 2008.

User response

Install Visual Studio 2005 Service Pack 1 and retry the install of VSAI.

DBI20058I The user user-name could not be deleted during the uninstall process.

Explanation

The installer can create Windows user accounts during the install process, for example a user account can be create as the instance owner. During uninstall you have the option to delete any Windows user accounts created by the installer during the install process.

This message is displayed when, during a database product uninstall, the uninstall utility tried to delete a Windows user account but failed.

User response

Delete the user account manually.

DBI20059I The user group user-group-name could not be deleted during the uninstall process.

Explanation

The installer can create Windows group accounts during the install process. During uninstall you have the option to delete any Windows group accounts created by the installer during the install process. This message is displayed when, during a database product uninstall, the uninstall utility tried to delete a group account but failed.

User response

Delete the user group account manually.

DBI20060I The uninstall utility found users and groups on the system which were created by the installer. Users: user-list. Groups: group-list.

Explanation

The installer can create Windows user and group accounts during the install process. This message is displayed when, during a database product uninstall, users and group accounts are found. These might be in use by another DB2 copy or by other applications. It is recommended keeping these accounts.

User response

One of the following:

  • If you want to keep the users and groups then select Yes
  • If you don't want to keep the users and groups then select No.

DBI20061I The uninstall utility found users on the system which were created by the installer. Users: user-list.

Explanation

The installer can create Windows user accounts during the install process. This message is displayed when, during a database product uninstall, user accounts were found. These might be in use by another DB2 copy or by other applications. It is recommended keeping these accounts.

User response

One of the following:

  • If you want to keep the user accounts then select Yes
  • If you don't want to keep the user accounts then select No.

DBI20062I The uninstall utility found groups on the system which were created by the installer. Groups: group-list.

Explanation

The installer can create Windows user group accounts during the install process. This message is displayed when, during a database product uninstall, user group accounts were found. These groups may be in use by another DB2 copy or by other applications. It is recommended keeping these accounts.

User response

One of the following:

  • If you want to keep the group accounts then select Yes
  • If you don't want to keep the group accounts then select No.

DBI20063E The database product installer failed to configure and start the SSH server because GPFS is unavailable. Database manager instance name: instance-name. Host machines: host-machine-name-list.

Explanation

You can securely run commands from remote machines by using a secure shell (SSH) server product such as IBM Secure Shell Server for Windows or Open Secure Shell (OpenSSH) on Linux and AIX operating systems.

This message is returned when the database product installer is configuring a SSH server in an environment with IBM General Parallel File System (GPFS) and the installer is unable to complete that SSH configuration on one or more host machines because GPFS is offline.

User response

  1. On each of the host machines listed, restart GPFS manually.
  2. Run the database product install operation again.

DBI20064E Copy upgrade is not supported from version source-version to version target-version.

Explanation

A copy refers to one or more installations of the database product on the same computer. If you attempt to upgrade from an unsupported version, the copy upgrade will fail.

User response

Perform the copy upgrade again specifying source and target versions that have supported upgrade paths.

DBI20065I No action is required, the cluster is managed by DB2 cluster services.

Explanation

Running the db2cluster_prepare command to takeover the cluster was unnecessary. DB2 cluster services are managing the cluster.

User response

None.

DBI20066E The GPFS cluster does not meet the requirements for a DB2 pureScale instance. Cluster name: cluster. Failed command: command-name.

Explanation

While running the command, the GPFS cluster failed a verification test of the requirements for the DB2 pureScale Feature.

User response

Set up a GPFS cluster that meets the requirements for a DB2 pureScale instance.

DBI20067E The operation failed because the DB2 global profile registry variable could not be updated on all hosts. Global registry variable: variable-name. Hosts not updated: comma-separated-host-list.

Explanation

The DB2 global registry file on the identified hosts could not be modified during the operation.

User response

Make sure that the DB2 global profile registry can be accessed, then rerun the command.

DBI20068E The command failed to update the DB2 global profile registry variable on one or more hosts. Registry variable: variable-name. Hosts not updated: comma-separated-host-list. Command to run on hosts: command-name.

Explanation

The DB2 global registry file on the identified hosts could not be modified during the operation.

User response

Make sure that the DB2 global-profile registry can be accessed on the identified hosts, then rerun the command as specified on each host to update the DB2 global profile registry file with the variable record.

DBI20069E Communication could not be established between two hosts. Source host: host-name1. Target host: host-2.

Explanation

All hosts in a DB2 pureScale instance must be able to communicate with all other hosts participating in the instance. The communication can be configured to use one of the following methods:

  • db2locssh
  • Passwordless SSH

This message is returned when the instance is configured to use passwordless SSH and the installer is unable to communicate between two host machines using passwordless SSH.

User response

Respond to this error by performing the following steps:

  1. Verify that the host machines are online.
  2. Configure passwordless SSH access between the host machines.

DBI20070E An error occurred running the command because a required component is not installed. Missing component: component-name.

Explanation

The missing component is a prerequisite to running the command.

User response

Install the component on the host, then rerun the command.

DBI20071I The cluster takeover has completed successfully.

Explanation

The user-managed cluster is now managed by DB2 cluster services.

User response

None.

DBI20072W The DB2 cluster services tiebreaker disk validation failed. The tiebreaker specified has not been configured.

Explanation

The DB2 cluster services tiebreaker disk helps a subcluster obtain operational quorum in the event of a failure that leaves exactly half of the DB2 pureScale instance hosts able to communicate with each other. In this event, the subcluster will attempt to get an exclusive lock on the disk to achieve operational quorum. The DB2 pureScale instance can operate without a configured tiebreaker disk, however the instance is more resilient with one.

User response

Optional: Configure a tiebreaker device.

DBI20073E The specified command failed because the value specified for a keyword in the response file was invalid. Value: keyword-value. Keyword: keyword-name.

Explanation

All response file keywords must be applicable to the installation, and all keyword values must be valid. Some commands and keywords are only valid when run by the instance owner, or when the installation includes specific components, features, or configurations.

User response

Edit the response file to correct the reported error. The DB2 Setup wizard can be used to create a valid response file for future use. If you have an existing installation, the response file generator can be used to create a response file.

DBI20074E The command cannot be run due to insufficient authority to use the specified keyword. Keyword: keyword-name.

Explanation

Administrative or root authority is required to use the specified keyword when performing a response file installation.

User response

Retry installation with a user that has sufficient authority, or without the problematic keyword. Contact the system administrator if you require the response file installation to run with the keyword.

DBI20075E The database product installer failed to configure the IBM Secure Shell Server for Windows service to start automatically because the default port is in use. Default port number: port_number.

Explanation

The installation cannot configure IBM Secure Shell Server to automatically start on this port.

User response

Select a different port to manually install the service, stop the service currently running on the port before starting the IBM Secure Shell Server.

DBI20076E The directory specified for the IBM Secure Shell Server cannot be used.

Explanation

The IBM Secure Shell Server installation directory cannot be the same as a database product installation directory.

User response

Specify a directory different from a database product installation directory.

DBI20077E Updating the IBM Secure Shell Server for Windows failed during a fix pack installation.

Explanation

The database product installer detected an error with the version of the IBM Secure Shell Server binaries. The fix pack installation cannot continue.

User response

Ensure that the IBM Secure Shell Server files already installed in the system are not at a higher level then the fix pack image.

DBI20078W Because no value was specified for the response file keyword AUTOSTART_SSH_SERVER, the database product installer attempted to configure the IBM Secure Shell (SSH) Server for Windows service to start automatically on the default port. Default port number: port-number. However, that configuration failed because the default port is already in use. The service for IBM SSH Server will need to be started manually.

Explanation

An error occurred during the uninstallation of the IBM Secure Shell Server. IBM Secure Shell Server was not uninstalled.

User response

Login as an administrator user and manually remove the IBM Secure Shell Server.

DBI20079E Removal of the IBM Secure Shell Server for Windows failed during the DB2 uninstall process.

Explanation

An error occurred during the uninstallation of the IBM Secure Shell Server. IBM Secure Shell Server was not uninstalled.

User response

Login as an administrator user and manually remove the IBM Secure Shell Server.

DBI20080E During uninstall, the database product installer detected that both a 32-bit version and a 64-bit version of the IBM Data Server Driver Package (DSDRIVER) are installed. 32-bit and 64-bit versions of the DSDRIVER product cannot coexist.

Explanation

A 32-bit and 64-bit version of a database product cannot coexist on a host machine.

User response

Uninstall the conflicting product before attempting to reinstall. You must manually uninstall one of the DSDRIVER products using the db2unins command.

DBI20081E The installer detected that there is not enough free disk space in directory_name. Free space detected in directory_name is: space_available (measured in kilobytes). Space needed is: space_needed (measured in kilobytes).

Explanation

There is not enough free space available.

User response

Free more disk space and then resubmit the command.

DBI20082E The database product installer cannot create necessary database manager instance files because the database product installer does not have write permission for the specified shared disk partition device path. Specified shared disk partition device path: shared-disk-path.

Explanation

In a pureScale environment, a shared disk path is required to hold shared instance and database files. When a database manager instance is created by using the db2icrt command, the shared disk path is specified by using the -instance_shared_dev parameter.

This message is returned when the database product installer does not have write permission for the specified shared disk path.

User response

Respond to this message in one of the following ways:

  • Modify the permissions of the directory that is to be the specified shared disk path so that the DB2 database installer has write access to the path.
  • Call the db2icrt command again, specifying a shared disk path with the -instance_shared_dev parameter for which the database product installer has write access.

DBI20083E The DB2 pureScale instance could not be created because the database product installer found more than one uDAPL configuration file.

Explanation

The user Direct Access Programming Library (uDAPL) configuration file, dat.conf, is referenced by the DB2 pureScale Feature to verify the presence of a remote direct memory access (RDMA) capable network adapter. Exactly one copy of the file must be accessible under the appropriate subdirectory of /etc.

This message is returned when the database product installer found more than one of these uDAPL configuration files. If multiple uDAPL configuration files exist, the database product installer cannot determine which set of configurations to use.

User response

Verify the uDAPL configuration manually, including verifying that only one copy of the dat.conf file exists on the system, and then run the instance creation operation again.

DBI20084E The domain that was specified for the DB2 administrators group is not the same as the domain that was specified for the DB2 users group.

Explanation

Two Windows groups are used by the database manager to enforce extended Windows security: the DB2 administrators group, which is named "DB2ADMINS" by default; and the DB2 users group, which is named "DB2USERS" by default. These groups are used by the database manager to provide protection at the operating system level.

The DB2 administrators group and the DB2 users group may both be local groups or they may both be domain groups. If the DB2 administrators group and the DB2 users group are domain groups, they must be in the same domain as each other.

User response

Specify the same domain for both the DB2 administrators group and the DB2 users group.

DBI20085E The instance update operation for the instance named instance-name failed because some resources for other instances were not completely removed during previous instance drop operations.

Explanation

You can update a database manager instance to a higher level within a release, update an instance other than a DB2 pureScale instance to a DB2 pureScale instance, or scale a DB2 pureScale instance by using the db2iupdt command.

This message is returned when an an attempt is made to perform an instance update operation on a given instance, but the update operation cannot proceed because there is a conflict with resources that were not completely removed during a previous attempt to drop one or more instances.

User response

  1. Identify any entries in the global registry that were associated with instances that no longer exist.
  2. Remove any entries in the global registry that were associated with instances that no longer exist by using the db2greg command.
  3. Run the db2iupdt command again.

DBI20086E The update command failed because the specified CF or DB2 member is not present in the DB2 cluster. Specified CF or member: id.

Explanation

You can update a database manager instance to a higher level within a release, update an instance other than a DB2 pureScale instance to a DB2 pureScale instance, or scale a DB2 pureScale instance by using the db2iupdt command.

This message can be returned in two scenarios:

  • The db2iupdt command is called with the -update parameter and a cluster caching facility (CF) that is not part of the DB2 cluster is specified with the -cf parameter
  • The db2iupdt command is called with the -update parameter and a DB2 member that is not part of the DB2 cluster is specified with the -m parameter

User response

Respond to this error in one of the following ways:

  • To update an existing CF in the DB2 cluster, call the db2iupdt command again specifying a CF that is present in the DB2 cluster.
  • To add a new CF to the DB2 cluster, call the db2iupdt command again specifying the -add and -cf parameters.
  • To update an existing member in the DB2 cluster, call the db2iupdt command again specifying a member that is present in the DB2 cluster.
  • To add a new member to the DB2 cluster, call the db2iupdt command again specifying the -add and -m parameters.

DBI20087E The db2dsdriver.cfg file relocation failed because the file or folder is read-only.

Explanation

The db2dsdriver.cfg file was not moved to the destination directory. The following directory is not accessible:

  • On Windows XP Professional and Windows Server 2003 the path is:
    
    C:\Documents and Settings\
    All Users\Application Data\IBM\DB2\
    <driver-copy-name>\cfg
    
  • On Windows Vista, Windows 7, and Windows Server 2008 the path is:
    
    C:\ProgramData\IBM\DB2\<driver-copy-name>\cfg
    

User response

Modify the path so that the current user has read and write access to the file and folder. Then perform the silent installation again.

DBI20088E Installing or updating SSH utilities failed.

Explanation

The DB2 pureScale Feature uses General Parallel File System (GPFS) as the shared-disk file system to provide data access across all members in a DB2 pureScale environment. GPFS requires certain commands to run as root on all hosts that are part of the GPFS domain. There are two ways to confgure your environment to meet this GPFS requirement:

  • You can enable passwordless remote root login using standard SSH public key authentication.
  • In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, passwordless remote root login is no longer required. You can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts.

This message is returned when the database product installer fails to install the DB2 utilities that support using the db2sshid.

User response

Run the install operation again.

DBI20089E The db2dsdriver.cfg file relocation failed due to an unknown keyword in the response file. Keyword: keyword. Line: line-number.

Explanation

The response file used during silent installation has detected an unknown keyword.

User response

  1. Fix the error in the response file.
  2. Attempt silent installation again.

DBI20090W The database product installer detected that the db2ssh directory is world writeable.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login. There are several DB2 SSH utilities located in the db2ssh directory to support using the db2sshid.

This message is returned when the database product installer detects that the db2ssh directory is w-writable. The permissions of the db2ssh directory should allow only root users write access to the directory.

User response

Modify the access permissions for the db2ssh directory so that only root users may access those directories.

DBI20091W The database product installer failed to change the ownership of the db2locssh script to the db2sshid. The ownership of the db2locssh script has been set to the instance owner ID.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login.

One of the DB2 utilities that supports using the db2sshid is the db2locssh script. During install, the database product installer attempts to use operating system commands to set the owner of the db2locssh script to the db2sshid. However, if the installer is unable to set the owner of the db2locssh script to the db2sshid the installer will set the owner of the db2locssh script to the current instance owner ID.

This message is returned when the database product installer sets the owner of the db2locssh script to the current instance owner ID because the installer failed to set the owner of the db2locssh script to the db2sshid.

User response

Manually change the ownership of the db2locssh script to the db2sshid.

DBI20092W The database product installer detected a problem with the db2locssh utility that will prevent the use of the db2sshid.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login.

One of the DB2 utilities that supports using the db2sshid is the db2locssh script. During install, the database product installer verifies that the db2locssh script is functioning correctly.

This message is returned when the database product installer is unable to successfully verify the db2locssh functionality.

User response

Manually set up the db2sshid user ID.

DBI20094E The db2icrt command failed because the specified db2sshid does not exist on all hosts in the DB2 cluster. Specified db2sshid: specified-id.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login. To use the db2sshid, you need to create a user id on all hosts in the DB2 cluster, including the installation-initiating host, and then pass that user id to the db2icrt command with the -i parameter.

This message is returned when an attempt is made to specify a user id as a db2sshid but the specified user id does not exist on all hosts in the cluster.

User response

Call the db2icrt command again, specifying a user id that exists on all hosts in the DB2 cluster.

DBI20095E The distribution of the SSH public key failed because communication failed between two or more of the hosts in the DB2 cluster.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login. For the db2sshid to be used, a public key must be distributed to all hosts in the DB2 cluster.

This message is returned what the database product installer fails to distribute the public key to all of the hosts in the cluster during an upgrade or update operation.

User response

Manually distribute the public key of individual hosts to all hosts in the cluster.

DBI20096E The SSH configuration failed for the instance named instance-name on the following hosts in the cluster: host-name-list.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login. For the db2sshid to be used, a public key must be distributed to all hosts in the DB2 cluster.

This message is returned what the database product installer fails to create the public key during instance creation or or update operation.

User response

Manually distribute the public key of individual hosts to all hosts in the cluster.

DBI20097E The SSH configuration failed for the db2sshid user-id on the following hosts in the cluster: host-name-list.

Explanation

In DB2 Version 10.1 Fix Pack 2 and later fix packs, if you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts instead of using passwordless remote root login. For the db2sshid to be used, a public key must be distributed to all hosts in the DB2 cluster.

This message is returned what the database product installer fails to create the public key during instance creation or or update operation.

User response

Manually distribute the public key of individual hosts to all hosts in the cluster.

DBI20098E Adding a member failed because a CF is currently running on the host machine where the member was to be added.

Explanation

In an existing DB2 pureScale cluster, if the cluster caching facility (CF) is running, a member cannot be added to the CF host. Before a member can be added, the CF must be stopped using the db2stop command.

User response

On the host where you are adding the member, stop that CF using the db2stop command indicating the CF identifier.

DBI20099E The db2unins command failed because the command was run from an installed copy of the database product and the -f parameter, which can only be used when the command is run from the installation media, was specified.

Explanation

You can uninstall one or more database products, features, or languages by using the db2unins utility.

You can run the db2unins command either from the installed copy of DB2 database or from the DB2 database installation media:

  • Some db2unins parameters are only supported when the command is run from an installed copy of DB2 database.
  • Some db2unins command parameters are only supported when the command is run from the installation media.

You can perform a forced uninstallation of all database products on the system by specifying the -f parameter with the db2unins command. The -f parameter is one of the parameters that can only be used when the db2unins command is run from the installation media.

This message is returned when the command is run from an installed copy of DB2 database and the -f parameter is specified. The command fails because the -f parameter cannot be specified when the command is run from an installed copy of DB2 database.

User response

Respond to this error in one of the following ways:

  • To perform a forced uninstallation of all database products on the system, run the db2unins command from the installation media, specifying the -f parameter.
  • To use the db2unins command from the installed copy of DB2 database, call the db2unins command again without specifying the -f parameter.

DBI20100E The upgrade operation failed because upgrading the IBM Data Server Driver Package software from the current version to the new version is not supported. IBM Data Server Driver Package copy name: copy-name. Current version: version-number. New version: version-number.

Explanation

The IBM Data Server Driver Package software simplifies application deployment. This driver, which has a small footprint, is designed to be used by independent software vendors (ISVs) for mass application deployment scenarios that are typical of large enterprises.

This message is returned when an attempt is made to upgrade the version of the IBM Data Server Driver Package software, and updating from the current version to the new version is not supported.

User response

Respond to this error in one of the following ways:

  • Install a new copy of the IBM Data Server Driver Package software.
  • Upgrade to DB2 Version 9.7, and then upgrade from DB2 Version 9.7 to the latest release.
  • Uninstall the current IBM Data Server Driver Package software and then install the new IBM Data Server Driver Package software.

DBI20101E The upgrade operation failed because upgrading the IBM Database Add-Ins for Visual Studio software from the current version to the new version is not supported. Product name: product-name. Current version: version-number. New version: version-number.

Explanation

The IBM Database Add-Ins for Visual Studio software is a collection of features that integrate seamlessly into your Visual Studio development environment so that you can work with database servers and develop procedures, functions, and objects.

This message is returned when an attempt is made to upgrade IBM Database Add-Ins for Visual Studio, and updating from the current version to the new version is not supported.

User response

Uninstall the current IBM Database Add-Ins for Visual Studio software and then install the new IBM Database Add-Ins for Visual Studio software.

DBI20102E The upgrade operation has halted and cannot proceed further because upgrading the IBM Data Server Driver Package software from the current version to the new version is not supported. IBM Data Server Driver Package copy name: copy-name. Current version: version-number. New version: version-number.

Explanation

The IBM Data Server Driver Package software simplifies application deployment. This driver, which has a small footprint, is designed to be used by independent software vendors (ISVs) for mass application deployment scenarios that are typical of large enterprises.

This message is returned when an attempt is made to upgrade the version of the IBM Data Server Driver Package software, and updating from the current version to the new version is not supported.

User response

Respond to this error in one of the following ways:

  • Install a new copy of the IBM Data Server Driver Package software.
  • Upgrade to DB2 Version 9.7, and then upgrade from DB2 Version 9.7 to the latest release.
  • Uninstall the current IBM Data Server Driver Package software and then install the new IBM Data Server Driver Package software.

DBI20103E The upgrade operation has halted and cannot proceed further because upgrading the IBM Database Add-Ins for Visual Studio software from the current version to the new version is not supported. Product name: product-name. Current version: version-number. New version: version-number.

Explanation

The IBM Database Add-Ins for Visual Studio software is a collection of features that integrate seamlessly into your Visual Studio development environment so that you can work with database servers and develop database objects.

This message is returned when an attempt is made to upgrade IBM Database Add-Ins for Visual Studio, and updating from the current version to the new version is not supported.

User response

Uninstall the current IBM Database Add-Ins for Visual Studio software and then install the new IBM Database Add-Ins for Visual Studio software.

DBI20104E The installFixPack command failed because one or more invalid parameters were specified. Invalid parameter list: parameter-list.

Explanation

You can update installed database products to apply a fix pack by using the installFixPack command.

This message is returned when there is a problem with one or more of the specified command parameters, including the following example problems:

  • A parameter was specified that is not supported with the installFixPack command
  • A parameter was specified that is not valid for the operating environment or for the type of database manager instance

User response

  1. Review the installFixPack command syntax in the documentation or by running the following command:
    
    installFixPack -h
    
  2. Call the installFixPack command again, specifying only valid parameters.

DBI20105E An error occurred while installing the following file set: file-package-name. Because these files were not successfully installed, functionality that depends on these files might not work as expected.

Explanation

The database product installer installs files related to database functionality as well as files for software that is bundled with the database software.

This message is returned when the database product installer encounters a problem copying some files from the install media to the install location.

User response

Contact IBM Software Support for assistance.

DBI20106E Installation of the database product was not performed. The installer package cannot be invoked directly. The database product must be installed by using the setup command.

Explanation

On Windows operating systems, you can launch the setup wizard to install database products. You can perform a response file installation by specifying the -u parameter with the setup command.

This message is returned when an attempt is made to use one of the installation packages (such as DB2Serer.msi, for example) directly, which is not supported.

User response

Run the setup command.

DBI20107E The db2_deinstall command failed because the installer detected that the current host is a member of a GPFS cluster that includes other, remote host machines.

Explanation

You can remove database products or database product components by using the db2_deinstall command.

This message is returned when an attempt is made to uninstall a database product where the current host is part of an IBM General Parallel File System (GPFS) cluster that includes remote hosts.

User response

Manually remove the GPFS cluster and file system, and then run the db2_deinstall command again.

DBI20108W Validation of the RSCT peer domain failed. However, the validation failure is being ignored and the add member operation will proceed.

Explanation

When a new DB2 member is being added to a DB2 pureScale instance, it is database product install and configuration utilities that add the new member. While the database product install utility processes an add member request, the utility validates the IBM Reliable Scalable Cluster Technology (RSCT) peer domain.

This warning message is printed when the database product install utility detects a problem with the RSCT peer domain while the utility is processing an add member request. (The problem with the RSCT peer domain configuration could have been caused by an error during a previous add member operation, for example.)

This warning message is printed when the RSCT peer domain validation failure does not cause the current add member operation to fail. This warning is printed for your information only.

User response

Unless the database product install utility encounters other errors while processing the add member request, no response is required to this warning message.

DBI20109W Validation of the instance home directory structure failed. However, the validation failure is being ignored and the add member operation will proceed.

Explanation

When a new DB2 member is being added to a DB2 pureScale instance, it is database product install and configuration utilities that add the new member. While the database product install utility processes an add member request, the utility validates several aspects of the environment and of the database manager instance itself.

This warning message is printed when the database product install utility detects a problem with the instance home directory while the utility is processing an add member request. (The problem with the instance home directory could have been caused by an error during a previous add member operation, for example.)

This warning message is printed when the directory structure validation failure does not cause the current add member operation to fail. This warning is printed for your information only.

User response

Unless the database product install utility encounters other errors while processing the add member operation, no response is required to this warning message.

DBI20110W The database product install utility encountered an internal error while processing an add member operation. However, the validation failure is being ignored and the add member operation will be retried automatically.

Explanation

When a new DB2 member is being added to a DB2 pureScale instance, it is database product install and configuration utilities that add the new member. To accomplish the add member operation, the database product install utility performs many tasks.

This warning message is printed when the database product install utility encounters a recoverable error while processing an add member request. (The problem could have been caused by an error during a previous add member operation, for example.)

This warning message is printed when the failure does not cause the current add member operation to fail. This warning is printed for your information only.

User response

Unless the database product install utility encounters other errors while processing the add member operation, no response is required to this warning message.

DBI20111E The installation operation failed because one of the following invalid keywords was specified in the response file: ADVANCED_ENTERPRISE_SERVER_EDITION, ENTERPRISE_SERVER_EDITION, or WORKGROUP_SERVER_EDITION.

Explanation

You can install database software without any user interaction by using a response file.

A response file is an English-only text file that contains setup and configuration information in the form of keywords and keyword-value pairs.

This message is returned when an attempt is made to perform an installation operation with a response file that includes an invalid keyword.

User response

In your response file, replace instances of the following keywords with the keyword DB2_SERVER_EDITION:

  • ADVANCED_ENTERPRISE_SERVER_EDITION
  • ENTERPRISE_SERVER_EDITION
  • WORKGROUP_SERVER_EDITION

DBI20112E Instance creation failed because the rlogin operating system attribute is not set to TRUE for the specified instance name: name.

Explanation

You can create a database manager instance by running the db2icrt command. You specify the user name of the instance with the InstName parameter.

To create a DB2 pureScale instance, you must specify an instance name that can rlogin to host machines in the DB2 pureScale cluster. On AIX operating systems, you can enable a user name to rlogin to a host machine by setting the rlogin attribute to TRUE in the security file named /etc/security/user.

This message is returned when the database manager fails to create a DB2 pureScale instance because the rlogin attribute is not set to TRUE for the user name of the instance.

User response

For the user name of the instance, set the rlogin attribute to TRUE by using the chuser command.

DBI20113E The db2icrt command failed because no host name was specified with the -h parameter.

Explanation

You can create a database manager instance by using the db2icrt command.

On Windows operating systems only, and with multiple database partition instances only, you can override the default TCP/IP host name by using the -h parameter with the db2icrt command.

This message is returned when the -h parameter is specified, but no host name is specified with the -h parameter.

User response

To view db2icrt syntax information, call the db2icrt command again, specifying the -? parameter.

To override the default TCP/IP host name, call the db2icrt command again, specifying the name of the host machine with the -h parameter.

DBI20114E The db2icrt command failed because the specified db2sshid is not valid. The user ID and the group ID for the specified db2sshid is not the same on every host machine in the DB2 cluster. Specified db2sshid: specified-id.

Explanation

If you are using a DB2 managed GPFS file system for new DB2 pureScale installations, you can use the non-root user ID (db2sshid) to use a secure shell (SSH) network protocol between hosts. To use the db2sshid, you need to create a user with the same user ID (UID) and group ID (GID) on all hosts in the DB2 cluster, and then pass that user id to the db2icrt command with the -i parameter.

This message is returned when an attempt is made to specify a user id as a db2sshid but the specified user id does not exist with the same UID and GID on every host machine in the DB2 cluster.

User response

Call the db2icrt command again, specifying a user id that has the same UID and GID on all hosts in the DB2 cluster.

DBI20115E The command failed because the specified instance user is not valid. The UID and the GID for the specified instance user is not the same on every host machine in the DB2 cluster. Specified instance user: specified-user.

Explanation

To be able to create a DB2 pureScale instance, three users must exist:

  1. A user for the instance owner
  2. A non-root user to use a secure shell (SSH) network protocol between hosts
  3. Another user to run fenced user-defined functions or procedures

These three users are required on all servers hosting a cluster caching facility (CF) or a DB2 member. For each of these three users, the user ID (UID) and group ID (GID) must be the same on all host machines in the DB2 cluster.

This message is returned when an attempt is made to invoke an install-related command or a configuration-related command, specifying an instance user that does not exist with the same UID and GID on every host machine in the DB2 cluster.

User response

Call the command again, specifying an instance user that has the same UID and GID on all hosts in the DB2 cluster.

DBI20116E The netname was not updated because the target member or CF is not stopped.

Explanation

You can add one or more interconnect netnames to a DB2 member or cluster caching facility (CF) in a DB2 pureScale instance by calling the db2iupdt command:

  • To update the netname for a member, specify a comma-separated list of netnames with the the -mnet parameter
  • To update the netname for a CF, specify a comma-separated list of netnames with the the -cfnet parameter

A prerequisite for updating the netname of a member or CF is that the target member or CF must be stopped before calling the db2iupdt command.

This message is returned when an attempt is made to update the netname of a member or CF while the target member or CF is active.

User response

  1. Stop the target member or CF.
  2. Update the netname by calling the db2iupdt command.

DBI20117E The installFixPack command failed because an invalid value was specified for one or more parameters. Parameter list: parameter-list.

Explanation

You can update installed database products to apply a fix pack by using the installFixPack command.

This message is returned when there is a problem with the value that was specified for one or more of the command parameters, including the following example problems:

  • An invalid value was specified for a parameter
  • A value was specified that is not valid for the operating environment or for the type of database manager instance
  • Conflicting values, values that are not supported together, were specified

User response

  1. Review the installFixPack command syntax in the documentation or by running the following command:
    
    installFixPack -h
    
  2. Call the installFixPack command again, specifying only valid parameter values.

DBI20118E The database manager instance was not converted to a DB2 pureScale instance because all data and logs are not on a GPFS file system.

Explanation

You can convert a database manager instance to a DB2 pureScale instance by using the DB2 Setup Wizard or the db2iupdt command. There are a number of prerequisites for converting an instance to a DB2 pureScale instance, including that all data and logs be on an IBM General Parallel File System (GPFS).

This message is returned when an attempt is made to convert an instance to a DB2 pureScale instance, but the attempt fails because all data and logs are not on a GPFS file system.

User response

  1. Verify prerequisites for converting an instance to a DB2 pureScale instance.
  2. Perform all required pre-conversion tasks.
  3. Perform the conversion by either calling the db2iupdt command, or by invoking the DB2 Setup Wizard by calling the db2isetup command.

DBI20119E The upgrade operation failed because the response file keyword UPGRADE_PRIOR_VERSIONS was not set to TRUE.

Explanation

You can upgrade the version of an installed database product by using a response file.

On Windows operating systems and on non-root installations on Linux and UNIX operating systems, to upgrade the version of an installed database product by using a response file, you must set the UPGRADE_PRIOR_VERSIONS response file keyword to TRUE.

This message is returned when an attempt is made to perform a response file upgrade on a Windows operating system or with a non-root installation on a Linux or UNIX operating system and the UPGRADE_PRIOR_VERSIONS response file keyword is not set to TRUE.

User response

Set the keyword UPGRADE_PRIOR_VERSIONS to TRUE in the response file, and then perform the upgrade operation again.

DBI20122E The instance was not created or updated because the following netname does not exist: netname.

Explanation

When you are creating or updating a DB2 pureScale instance, you must specify the cluster interconnect netname for DB2 members and CFs. The cluster interconnect netname is the hostname of the interconnect used for high speed communication between members and cluster caching facilities (also referred to as CF.)

This message is returned when an attempt is made to create or update a DB2 pureScale instance, and a netname that does not exist is specified for a member or CF.

User response

Call the command again, specifying valid netnames for the members and CFs.

DBI20123E The instance was not created or updated because the following netname failed subnet validation tests: netname.

Explanation

When you are creating or updating a DB2 pureScale instance, you must specify the cluster interconnect netname for DB2 members and CFs. The cluster interconnect netname is the hostname of the interconnect used for high speed communication between members and cluster caching facilities (also referred to as CF.)

All members and CFs must be on the same subnet for performance reasons. This message is returned when an attempt is made to create or update a DB2 pureScale instance, and a member or CF netname is specified that is not on the same subnet as the netnames for the other members and CFs.

User response

Call the command again, specifying netnames on the same subnet for all of the members and CFs.

DBI20131E No DB2 members or CFs were upgraded. The db2iupgrade command failed because the following host machine is unavailable: host-name.

Explanation

You can upgrade a DB2 pureScale instance to a new release by using the db2iupgrade command. You can upgrade all hosts in the DB2 cluster simultaneously by specifying the -g parameter with the db2iupgrade command.

This message is returned when the db2iupgrade command is issued to upgrade a DB2 pureScale instance, but the db2iupgrade utility is unable to reach a host machine in the DB2 cluster.

User response

Troubleshoot the network and the host machine:

  • Verify that the host machine given in the runtime token host-machine is up and running.
  • Verify that the network is operational between the host machine on which the db2iupgrade command is issued and the unavailable host machine given in the runtime token host-machine.

DBI20132E The database product was not installed because the software named software-product-name was installed or updated outside of the database product installer and the -f parameter was not specified.

Explanation

Software such as Reliable Scalable Cluster Technology (RSCT), IBM Tivoli System Automation for Multiplatforms (SA MP), and IBM General Parallel File System (GPFS) is bundled with the database product and installed by the database product installer when you install the database product.

This message is returned when the database product installer detects that software that is bundled with the database product is already on the system and was installed or maintained by some mechanism other than the database product installer.

By default, the database product installer will not replace or update software that was not installed or maintained by the database product installer. You can force the database product installer to replace or update bundled software by specifying the appropriate software keyword with the -f parameter.

User response

To install the database product, force the database product installer to replace or update the bundled software by specifying the appropriate software keyword with the -f parameter.

DBI20133E The add member operation failed because a fix pack update is in progress.

Explanation

Some operations cannot be performed while a fix pack update is in progress. This message is returned when an attempt is made to perform one of these restricted operations while a fix pack update is in progress.

User response

Wait until the fix pack update has completed, and then add the member.

DBI20134E The database manager instance was not dropped because the instance is in a heterogeneous state.

Explanation

During an offline or online fix pack update of a DB2 pureScale instance, there will be times when DB2 members and cluster caching facilities (CFs) have a different code level from the current effective code level (CECL). The instance is said to be in a heterogeneous state when there are members or CFs at the CECL and at least one member or CF has a code level different from the CECL.

Some operations cannot be performed while an instance is in a heterogeneous state. This message is returned when an attempt is made to perform one of these restricted operations while instance is in a heterogeneous state.

User response

Wait until all of the members and CFs are at the CECL, and then drop the database manager instance.

DBI20135E The online fix pack update has halted because the secondary CF is not in PEER state.

Explanation

You can update the version to a higher code level within a release without having to bring your database offline by using an online fix pack update.

An online fix pack update is accomplished by updating each DB2 member and cluster caching facility (CF) individually: taking the member or CF offline, updating the code level, and bringing that member or CF online again. Because a DB2 pureScale instance is designed to be available even when one member or CF is offline, this is how the instance can remain online throughout the update.

This message is returned during an online fix pack update when the installFixPack utility discovers that the secondary CF is not in a suitable state to keep the instance available if the primary CF is taken offline to perform the update.

User response

Wait until the secondary CF is in PEER state and then perform the online fix pack update.

DBI20136E The installFixPack command failed because the member to be updated is the only active member in the instance.

Explanation

You can update the version to a higher code level within a release without having to bring your database offline by using an online fix pack update.

An online fix pack update is accomplished by updating each DB2 member and cluster caching facility (CF) individually: taking the member or CF offline, updating the code level, and bringing that member or CF online again. Because a DB2 pureScale instance is designed to be available even when a members or CF is offline, this is how the instance can remain online throughout the update.

This message is returned when an attempt is made to perform an online fix pack update on a DB2 pureScale instance that has only one active member. Because there is only one member active, taking that member offline to update it would cause the whole instance to be unavailable.

User response

To perform an online update of this member, wait until other members in the instance are online, and then update this member.

DBI20137E The installFixPack command failed because the utility could not determine whether or not the member or CF is in restart light mode.

Explanation

You can update the version to a higher code level within a release without having to bring your database offline by using an online fix pack update. To perform an online fix pack update, you call the installFixPack command.

There are some restrictions related to performing an online fix pack update. For example, an online fix pack update cannot be performed if a DB2 member or cluster caching facility (CF) is in restart light mode. This message is returned when an attempt is made to perform an online fix pack update while a member or CF is in restart light mode.

User response

Wait for the member or CF to be restarted on its home host and then perform the fix pack update operation.

DBI20138E The command failed because the current instance is a DB2 pureScale instance, but one or more parameters that are mandatory for DB2 pureScale instances were not specified. Missing parameter list: parameter-list.

Explanation

For many database manager commands, some parameter are mandatory in certain conditions.

This message is returned when a command is invoked in a DB2 pureScale environment, but some parameters that are mandatory for DB2 pureScale instances are not specified.

User response

Invoke the command again, specifying all required parameters.

DBI20139E The installFixPack command failed because the -online parameter was specified with the installFixPack command and the database manager instance is currently stopped.

Explanation

You can update the version to a higher code level within a release without having to bring your database offline by using an online fix pack update. To perform an online fix pack update, you call the installFixPack command specifying the -online parameter.

This message is returned when the installFixPack command is called with the -online parameter specified, but the instance being updated is currently stopped. It is impossible to perform an online fix pack update of an instance that is stopped.

User response

To perform an offline fix pack update, call the installFixPack command again, without specifying the -online parameter.

To perform an online fix pack update, start the instance and then call the installFixPack command again, specifying the -online parameter.

DBI20140E Creating the instance failed because the database product installer failed to determine the fenced user ID.

Explanation

The fenced user is used to run user defined functions (UDFs) and stored procedures outside of the address space used by the DB2 database.

This message is returned when an attempt is made to create an instance, but the database product installer could not determine the fenced user ID.

User response

Create a fenced user ID and then create the instance.

DBI20141E Creating the instance failed because the database product installer failed to determine the install path.

Explanation

When installing the database product, you can specify the install path. For example, you can specify the install path with the -b parameter of the db2_install command. If you do not specify an install path, the default install path will be used: $HOME/sqllib.

This message is returned when an attempt is made to create an instance, but the database product installer could not determine the install path.

User response

Repair the installation by using the DB2 Setup Wizard.

DBI20142E Instance creation failed because of an internal error.

Explanation

This message is returned when the database product installer encounters an internal error while creating a database manager instance.

User response

Perform the instance creation operation again.

If this error continues, collect the following information and then contact IBM Software Support:

  • Install logs
  • db2diag diagnostic log files

DBI20143E The installFixPack command failed because an invalid base install path was specified with the -b parameter. Specified path: path.

Explanation

You can update installed database products to apply a fix pack by using the installFixPack command.

When you run the installFixPack command in non-interactive mode, you must specify the path where the database product is currently installed with the -b parameter.

This message is returned when the installFixPack command is called with an invalid base path specified with the -b parameter. The path might be invalid for different reasons, including that the path does not exist.

User response

Call the installFixPack command again, specifying a valid base path with the -b parameter.

DBI20144E The installFixPack command failed because the specified instance does not exist in the specified base path. Instance specified with the -I parameter: instance-name. Base path specified with the -b parameter: path.

Explanation

You can update installed database products to apply a fix pack by using the installFixPack command.

You can specify the name of the instance to update with the -I parameter. And you can specify the base install path of the instance with the -b parameter.

This message is returned when the installFixPack command is called with incompatible values for the -I parameter and the -b parameter: the instance that is specified with the -I parameter is not installed in the path that is specified with the -b parameter.

User response

Respond to this message in one of the following ways:

  • To update the specified instance, call the installFixPack command again, specifying the correct base install path for that instance.
  • To update an instance that is installed in the specified base install path, call the installFixPack command again, specifying the name of an instance that is installed in that path.

DBI20145E The db2icrt command failed because the instance type is 'dsf', but not all parameters that are required to create a DB2 pureScale instance were specified. Missing parameters: parameter-list.

Explanation

You can create a database manager instance by calling the db2icrt command.

You can control the type of instance that is created by specifying the -s parameter with the db2icrt command. If the -s parameter is not specified, the db2icrt utility will create the default type of instance. The default instance type is the first instance in the following list that the DB2 copy is licensed to create:

  1. dsf
  2. ese
  3. wse
  4. standalone
  5. client

This message is returned when the db2icrt utility attempts to create a DB2 pureScale instance, either because a value of 'dsf' was specified with the -s parameter or because the -s parameter was not specified and the default type is 'dsf', but one or more parameters that are required to create a DB2 pureScale instance were not specified. The runtime token parameter-list lists all of the parameters that are required but were not specified.

User response

Respond to this message in one of the following ways:

  • To create a DB2 pureScale instance, call the db2icrt command again, specifying all of the required parameters for creating a DB2 pureScale instance.
  • To create a type of instance that is not a DB2 pureScale instance, call the db2icrt command again, specifying a an instance type other than 'dsf'.

DBI20146E The db2icrt command failed because one or more invalid parameters were specified. Invalid parameters: parameter-list.

Explanation

You can create a database manager instance by calling the db2icrt command.

This message is returned when one or more invalid parameters are specified with the db2icrt command. The parameter-list runtime token lists the parameter or parameters that are invalid.

User response

Call the db2icrt command again, specifying valid parameters.

DBI20147E The db2iupdt command failed because one or more topology configuring parameters were specified, but the current instance is not a DB2 pureScale instance. Topology configuring parameters specified: parameter-list.

Explanation

You can change or reconfigure the topology of a DB2 pureScale instance by calling the db2iupdt command with parameters such as: -add, -drop, -update, and -fixtopology.

This message is returned when the db2iupdt command is called with one of these topology configuring parameters specified, but the instance being updated is not a DB2 pureScale instance.

User response

Respond to this message in one of the following ways:

  • To update the code level of the instance, call the db2iupdt command again, without specifying any DB2 pureScale-related parameters.
  • To convert this instance to a DB2 pureScale instance, call the db2iupdt command again, specifying the -instance_shared_dev parameter or the -instance_shared_dir parameter, and without specifying topology configuring parameters.

DBI20148E The db2iupdt command failed because some DB2 pureScale Feature parameters were specified, but the current instance is not a DB2 pureScale instance, and instance type conversion parameters were not all specified. Specified DB2 pureScale Feature parameters: parameter-list.

Explanation

You can convert an instance to a DB2 pureScale type of instance by calling the db2iupdt command, specifying conversion parameters such as: -instance_shared_dev or -instance_shared_dir parameter.

This message is returned when the db2iupdt command is called with some parameters that are related to the DB2 pureScale Feature, but the instance is not a DB2 pureScale instance and conversion parameters were not specified.

User response

Respond to this message in one of the following ways:

  • To update the code level of the instance without changing the type of the instance to DB2 pureScale, call the db2iupdt command again, without specifying any DB2 pureScale Feature parameters.
  • To convert this instance to a DB2 pureScale instance, call the db2iupdt command again, specifying the -instance_shared_dev parameter or the -instance_shared_dir parameter.

DBI20149E The db2iupdt command failed because the current instance is a DB2 pureScale instance and some DB2 pureScale Feature parameters were specified, but topology configuration parameters (-add, -update, or -drop) were not specified. Specified DB2 pureScale Feature parameters: parameter-list.

Explanation

You can change or reconfigure the topology of a DB2 pureScale instance by calling the db2iupdt command with parameters such as: -add, -drop, -update, and -fixtopology.

This message is returned when the db2iupdt command is called with some DB2 pureScale Feature parameters, but topology configuration parameters were not specified.

User response

Respond to this message in one of the following ways:

  • To update the code level of the instance without changing the type of the instance to DB2 pureScale, call the db2iupdt command again, without specifying any DB2 pureScale Feature parameters.
  • To change or reconfigure the topology of this instance, call the db2iupdt command again, specifying one of the topology configuring parameters.

DBI20150E The db2iupdt command failed because one or more instance type conversion parameters were specified but the current instance is already a DB2 pureScale instance. Specified instance type conversion parameters: parameter-list.

Explanation

You can change or reconfigure the topology of a DB2 pureScale instance by calling the db2iupdt command with parameters such as: -add, -drop, -update, and -fixtopology.

You can convert an instance to a DB2 pureScale type of instance by calling the db2iupdt command, specifying conversion parameters such as: -instance_shared_dev and -instance_shared_dir parameter.

This message is returned when the db2iupdt command is called with conversion parameters specified against an instance that is already a DB2 pureScale instance.

User response

Respond to this message in one of the following ways:

  • To update the code level of the instance without changing the type of the instance to DB2 pureScale, call the db2iupdt command again, without specifying any DB2 pureScale related parameters.
  • To change or reconfigure the topology of this instance, call the db2iupdt command again, specifying one of the topology configuring parameters.

DBI20151E The db2icrt command failed because the specified instance name has more than 8 characters. Specified instance name: instance-name.

Explanation

You can create a database manager instance by calling the db2icrt command. You specify the name of the instance to be created when you call the command:


db2icrt <new-instance-name>

There is a length restriction on instance names: instance names must have 8 characters or less. This message is returned is returned when the db2icrt command is called, with an instance name specified that is longer than 8 characters.

User response

Call the db2icrt command again, specifying an instance name that is 8 characters or less.

DBI20152E The install operation was not completed because an older version of the database product is already installed in the specified install path but the UPGRADE_PRIOR_VERSIONS keyword is not specified in the response file.

Explanation

You can install a new version of DB2 software and upgrade existing database manager instances by using a response file installation. Response files contain values that are used to answer questions during the installation process that you would normally answer if you were using an interactive tool such as the DB2 Setup wizard.

When you are installing a database product in the same location as an existing database product using a response file installation, you must use the UPGRADE_PRIOR_VERSIONS keyword in the response file to specify whether the existing database product should be upgraded or overwritten.

This message is returned when, during a response file installation, the installer detects that an older version of the database product is installed in the specified install directory but the UPGRADE_PRIOR_VERSIONS keyword is not specified in the response file.

User response

Respond to this error in one of the following ways:

  • To install a new copy of the database product, specify a different install path.
  • Specify whether to upgrade or overwrite the existing database product by using the UPGRADE_PRIOR_VERSIONS response file keyword.

DBI20153E The db2iupdt command failed because an attempt was made to add or drop both a DB2 member and a CF at the same time, which is not supported.

Explanation

You can add a DB2 member or a cluster caching facility (CF) to a DB2 pureScale instance by invoking the db2iupdt command with the -add parameter. You can drop a DB2 member or a CF from a DB2 pureScale instance by invoking the db2iupdt command with the -drop parameter.

You can specify the details for a member to add or drop by using the -m and -mnet parameters. You can specify the details for a CF to add or drop by using the -cf and -cfnet parameters. However, it is not supported to add or drop both a member and a CF in one invocation of the db2iupdt command. In other words, it is not supported to specify both the -m parameter and the -cf parameter together.

This message is returned when the -m parameter is specified and the -cf parameter is also specified.

User response

Add or drop either a DB2 member or a CF, but not both.

DBI20154E The command failed because one or more invalid or unsupported parameters were specified. Command name: command-name. List of invalid or unsupported parameters specified: parameter-list.

Explanation

This message is returned when a command is invoked with parameters that are invalid for one the following reasons:

  • The parameter is not part of the command syntax
  • The parameter is not supported in the current environment
  • The parameter is not supported with the current product edition

User response

Invoke the command again, specifying only supported parameters.

DBI20155W The install path that was specified with the -b parameter was ignored. Specified path: path. The install will proceed in the user home directory instead. User home directory: path.

Explanation

You can install DB2 database by using the db2_install utility as a root user or as a non-root user:

  • When you install DB2 database as a root user by invoking the db2_install command, you can specify the install path with the -b parameter.
  • When you install DB2 database as a non-root user by invoking the db2_install command, the only supported install path is /home/<user>.

This message is returned when the db2_install command is invoked by a non-root user and a path other than /home/<user> is specified with the -b parameter. When a non-root user specifies a path other than /home/<user> with the -b parameter, the db2_install utility ignores the -b parameter and installs the database product in /home/<user>.

User response

No user response is required. The install operation will proceed in /home/<user>.

DBI20156E The instance configuration failed because the install or instance management utility does not have write access to the instance home directory. Instance name: instance-name. Instance home directory: instance-home-dir.

Explanation

This message is returned when an install utility or an instance configuration utility fails to perform required tasks because the utility cannot write to the instance home directory.

The install and instance configuration utilities perform tasks as the user who invoked the command, so this error could be phrased as: the operation failed because the user who invoked the command does not have write access to the instance home directory.

User response

Grant write permission to the instance home directory for the root user and the instance owner.

DBI20157E The db2icrt command failed because one or more parameters were specified that are specific to the DB2 pureScale Feature, but the DB2 pureScale Feature is not installed. Specified parameters: parameter-list.

Explanation

You can create a database manager instance by calling the db2icrt command. Not all db2icrt command parameters are applicable to every instance creation scenario. For example, parameters such as -m and -tbdev are applicable only to creating a DB2 pureScale instance.

This message is returned when the db2icrt command is invoked with parameters that are related to the DB2 pureScale Feature, but the DB2 pureScale Feature is not installed.

User response

  • To create a DB2 pureScale instance, install the DB2 pureScale Feature and then call the db2icrt command again.
  • To create a database manager instance that is not a DB2 pureScale instance, call the db2icrt command again without specifying any parameters that are specific to the DB2 pureScale Feature.

DBI20158E The db2_install command failed because the command was invoked by a non-root user and a path that is not supported with non-root installations (a path other than $HOME/sqllib) was specified with the -b parameter.

Explanation

You can install most database products as a non-root user. Non-root installations have most of the function of root installations, but there are some differences. For example, in non-root installations, the database product may only be installed in a subdirectory called "sqllib" in the home directory of the user who invokes the db2_install command ($HOME/sqllib).

This message is returned when the db2_install command is invoked by a non-root user and a path other than $HOME/sqllib is specified with the -b parameter.

User response

  • To perform a non-root install in $HOME/sqllib take one of the following actions:
    • Call the db2_install command again without specifying the -b parameter.
    • Call the db2_install command again, specifying a path equivalent to $HOME/sqllib with the -b parameter.
  • To install the database product in a directory other than $HOME/sqllib, invoke the db2_install command as a root user.

DBI20159E The command failed because mutually exclusive parameters were specified. Mutually exclusive parameters that were specified: parameter-list.

Explanation

You can update the version of a database manager instance, configure the topology of a DB2 pureScale instance, or convert an instance to a DB2 pureScale instance by invoking the db2iupdt command.

You can upgrade an instance from one product release to another by invoking the db2iupgrade command.

This message is returned when mutually exclusive parameters are specified with either the db2iupdt command or the db2iupgrade command.

User response

Issue the command again, specifying valid parameters.

DBI20160E The db2iupdt command failed because a group of parameters that must be specified together is incomplete. Parameter with which other parameters must be specified: parameter-name. Missing parameters: parameter-list.

Explanation

You can update the version of a database manager instance, configure the topology of a DB2 pureScale instance, or convert an instance to a DB2 pureScale instance by invoking the db2iupdt command.

You can control the actions of the db2iupdt utility by specifying various parameters with the db2iupdt command.

Some collections of parameters must be specified altogether or not at all. This message is returned when parameters that must all be specified together are not all specified with the db2iupt command.

User response

Call the db2iupdt command again, specifying valid parameters.

DBI20161E The db2ls command failed because no value was specified for the following parameter: parameter-name.

Explanation

You can list the installed database products by issuing the db2ls command. Some parameters, such as -f, require values to be specified with the parameter.

This message is returned when the db2ls command is called and a parameter that required a value is specified without a value.

User response

Call the command again, specifying all required parameter values.

DBI20162E The db2ls command failed because some parameters that must be specified as a pair were not specified as a pair. Specified parameter: parameter-name. Missing parameter: parameter-list.

Explanation

You can list the installed database products by issuing the db2ls command. Some parameters, such as -q and -b, must be specified together, if they are specified at all.

This message is returned when the db2ls command is called and only one parameter is specified from a pair of parameters that must be specified together.

User response

Call the command again, specifying a valid collection of parameters.

DBI20164E The db2iupgrade command failed because of a problem with the database product installation on a host machine in the DB2 cluster. Path from which the db2iupgrade command was issued: path. Host machine: host-name.

Explanation

After installing a new release of a database product, you can upgrade your existing database manager instances to the new release by issuing the db2iupgrade command.

This message is returned when the db2iupgrade command is issued from the path given in the runtime token path, and there is a problem with the database product that is installed on the host machine given in the runtime token host-name.

The reason code identifies the the problem more specifically:

Reason code 1

The database product is not installed on the host machine.

Reason code 2

There is a problem with the database product installation on the host machine. For example, some product files might be missing.

Reason code 3

The release of the database product that is installed on the host machine does not match the release of the database product that is installed in the path from which the db2iupgrade command was issued.

User response

Correct the problem indicated by the reason code:

1

Install the database product on the host machine.

2

Validate the DB2 copy that is installed on the host machine by using the db2val tool.

3

Install the same database product release on all host machines in the DB2 cluster.

Then, issue the db2iupgrade command again.

DBI20165I All databases that were registered as data sources with the ODBC driver manager before the upgrade were successfully re-registered as data sources with the ODBC driver manager after the upgrade.

Explanation

To access a database through Open Database Connectivity (ODBC) APIs, you must register (or catalog) the database as a data source with the ODBC diver manager.

When you upgrade your database manager instance to a new release, the db2iupgrade utility ensures that any databases that were registered as ODBC data sources before the instance upgrade are still registered as ODBC data sources after the instance upgrade.

This message is returned for your information only.

User response

No response is required.

DBI20166E One or more databases were not re-registered as data sources with the ODBC driver manager after the upgrade.

Explanation

To access a database through Open Database Connectivity (ODBC) APIs, you must register (or catalog) the database as a data source with the ODBC diver manager.

When you upgrade your database manager instance to a new release, the db2iupgrade utility attempts to ensure that any databases that were registered as ODBC data sources before the instance upgrade are still registered as ODBC data sources after the instance upgrade.

This message is returned when the db2iupgrade utility encountered an error while preserving the list of databases that are registered as data sources with the ODBC driver manager.

User response

Register required database as data sources with the ODBC driver manager by using one or more of the following tools:

  • The db2cli tool with the registerdsn parameter
  • The CATALOG ODBC DATA SOURCE command.

DBI20167W The DB2 pureScale instance was set to use the TCP/IP network protocol because the network is not configured for the RDMA network protocol.

Explanation

You can run a DB2 pureScale environment using different network protocols:

  • Remote direct memory access (RDMA) protocol over an InfiniBand (IB) network
  • RDMA protocol over a Converged Ethernet (RoCE) network
  • Transmission Control Protocol/Internet Protocol (TCP/IP) over an Ethernet network

This message is returned when a DB2 pureScale instance is created or updated, and the instance will use the TCP/IP protocol because the database manager instance configuration utilities did not detect a network configured to use RDMA.

User response

Optional: To use the RDMA network protocol, configure a network for RDMA and then move the instance to the RDMA network.

DBI20168E The DB2 pureScale instance was not created because there is insufficient space available in a temporary directory on a host machine. Temporary directory name: temporary-directory-name. Host machine name: host-machine-name.

Explanation

The database product installer uses temporary directories to store files necessary for creating and managing instances and database objects. For database products to be installed or database manager instances to be updated, the temporary directories must have enough memory available to meet memory requirements.

User response

  1. On all host machines in the DB2 cluster, make enough memory available to meet memory requirements.
  2. Then, issue the command again.

DBI20169E The fix pack operation failed because starting GPFS on host machine host-machine-name failed.

Explanation

When you apply a fix pack to your database product by issuing the installFixPack command, the installFixPack utility will also update IBM General Parallel File System (GPFS) by default.

This message is returned when an attempt is made to apply a fix pack in a DB2 pureScale environment where GPFS is installed, and the installFixPack utility encounters an error starting GPFS.

More detailed diagnostic information is recorded in log files named installGPFS* in the /tmp directory.

User response

Correct the problems reported in the /tmp/installGPFS* logs and then issue the installFixPack command again.

DBI20170E The db2nrupgrade command failed because no backup directory was specified.

Explanation

You can upgrade a non-root database manager instance by issuing the db2nrupgrade command. When you issue the db2nrupgrade command, you must use the -b parameter to specify the directory where the configuration files from the old DB2 version are stored.

This message is returned when the db2nrupgrade command is issued without the backup directory being specified with the -b parameter.

User response

Issue the db2nrupgrade command again, specifying the backup directory with the -b parameter.

DBI20171E The installFixPack command failed because the level of GPFS that is installed on the host machine does not match the level of GPFS on the database product install media.

Explanation

By default, the database product installer installs IBM General Parallel File System (GPFS) and creates a GPFS cluster when you install the DB2 pureScale Feature. Similarly, when you apply a DB2 fix pack, the installFixPack utility automatically updates GPFS software, when required, by default. However, if you manually install or update GPFS, the database product installer and the installFixPack utility might be unable to subsequently maintain GPFS automatically.

This message is returned when the installFixPack utility detects that the GPFS software that is on the system was installed or updated by some mechanism other than the database product installer or the installFixPack utility.

User response

Manually update the GPFS software so that the level of the GPFS software matches the level of the GPFS software on the database product install media, and then perform the install or fix pack operation again.

DBI20172I The GSKit package was not updated because the GSKit package was not previously installed.

Explanation

You can use the SSL protocol to protect database client-server communications over the network by installing the IBM Global Security Kit (GSKit). In some configurations, the database product installer installs and updates the GSKit package automatically.

This message is printed in those configurations where the GSKit package is not installed, and consequently was not updated as part of a DB2 fix pack operation.

User response

No response is required.

DBI20173E The fix pack was not successfully installed because a cluster maintenance command failed on the following host machine: host-name.

Explanation

You can update installed database products to apply a fix pack by using the installFixPack command.

In a DB2 pureScale environment, the installFixPack utility performs the fix pack installation by installing the fix pack, including performing cluster maintenance operations, on each host machine in the DB2 cluster in sequence.

This message is returned when the installFixPack utility encounters an error while performing cluster maintenance operations for a host machine in the cluster.

User response

  1. Reboot the host machine listed in the runtime token host-name.
  2. Take the host machine listed in the runtime token host-name out of maintenance mode by issuing the following commands:
    
    db2cluster -cm -exit -maintenance
    db2cluster -cfs -exit -maintenance
    
  3. Reissue the installFixPack command.

DBI20174E The instance was not created because no entry was found in the DAT configuration file indicating the interconnect netname for the CF or member that will run on this host machine. Host machine name: host-name.

Explanation

To configure network settings in a DB2 pureScale environment, you must install required uDAPL software, associate interconnect netnames with pseudo IP addresses, and add required entries to the Direct Access Transport (DAT) configuration file.

This message is returned when an attempt is made to create a DB2 pureScale instance, but a host machines in the DB2 network has not been properly configured for uDAPL.

User response

  1. In the DAT configuration file, specify the interconnect netname for the CF or member that will be running on this host.
  2. Reissue the instance creation or install command.

DBI20175E The db2iupgrade command failed because the db2iupgrade command was previously called with the -prepare parameter from a different install path. Path from which the db2iupgrade command was previously issued: path.

Explanation

You can upgrade a database manager instance from one product release to another by invoking the db2iupgrade command.

To minimize the amount of time for which an instance must be stopped for an upgrade operation, you can perform the upgrade in two phases:

  • Phase 1: Prepare the instance for upgrade while the instance is active by issuing the db2iupgrade command with the -prepare parameter.
  • Phase 2: Commit the upgrade operation by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

You must perform both phases by issuing the db2upgrade command from the same install location. This message is returned when phase 1 is initiated from one install location, directory A, and then phase 2 is initiated from a different install location, directory B.

User response

To commit the prepared upgrade operation, issue the db2iupgrade command with the -commit parameter from the same directory from which the db2iupgrade command was previously issued with the -prepare parameter.

DBI20176E The db2iupgrade command failed because the instance has not been prepared for upgrade.

Explanation

You can upgrade a database manager instance from one product release to another by invoking the db2iupgrade command.

To minimize the amount of time for which an instance must be stopped for an upgrade operation, you can perform the upgrade in two phases:

  • Phase 1: Prepare the instance for upgrade while the instance is active by issuing the db2iupgrade command with the -prepare parameter.
  • Phase 2: Commit the upgrade operation by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

This message is returned when the db2iupgrade command is issued with the -commit parameter, but the instance has not yet been prepared for the upgrade operation.

User response

  • To perform a traditional, offline upgrade operation, stop the instance and then issue the db2iupgrade command without specifying either the -prepare parameter or the -commit parameter.
  • To upgrade the instance in two phases, perform the following actions:
    1. Prepare the instance for upgrade by issuing the db2iupgrade command with the -prepare parameter.
    2. Commit the upgrade by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

DBI20177E The db2iupgrade command failed because the instance was previously prepared for upgrade but the -commit parameter was not specified with the db2iupgrade command.

Explanation

You can upgrade a database manager instance from one product release to another by invoking the db2iupgrade command.

To minimize the amount of time for which an instance must be stopped for an upgrade operation, you can perform the upgrade in two phases:

  • Phase 1: Prepare the instance for upgrade while the instance is active by issuing the db2iupgrade command with the -prepare parameter.
  • Phase 2: Commit the upgrade operation by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

Once you prepare the instance for upgrade by issuing the db2iupgrade command with the -prepare parameter, you must either cancel the upgrade operation or complete it by issuing the db2upgrade command with the -commit parameter. This message is returned when the db2iupgrade command is issued with the -prepare parameter, and then the db2iupgrade command is issued without the -commit parameter.

User response

Upgrade the instance in one of the following two ways:

  • Complete the upgrade operation by issuing the db2iupgrade command with the -commit parameter.
  • Cancel the upgrade operation.

DBI20178E Preparing the instance for upgrade failed. Reason code: reason-code.

Explanation

You can upgrade a database manager instance from one product release to another by invoking the db2iupgrade command.

To minimize the amount of time for which an instance must be stopped for an upgrade operation, you can perform the upgrade in two phases:

  • Phase 1: Prepare the instance for upgrade while the instance is active by issuing the db2iupgrade command with the -prepare parameter.
  • Phase 2: Commit the upgrade operation by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

This message is returned when an error occurs while the instance is being prepared for upgrade.

User response

Issue the db2iupgrade command again.

DBI20179E Committing the instance upgrade operation failed. Reason code: reason-code.

Explanation

You can upgrade a database manager instance from one product release to another by invoking the db2iupgrade command.

To minimize the amount of time for which an instance must be stopped for an upgrade operation, you can perform the upgrade in two phases:

  • Phase 1: Prepare the instance for upgrade while the instance is active by issuing the db2iupgrade command with the -prepare parameter.
  • Phase 2: Commit the upgrade operation by stopping the instance and then issuing the db2iupgrade command with the -commit parameter.

This message is returned when an error occurs while the instance upgrade operation is being committed.

User response

Issue the db2iupgrade command again.

DBI20180E The installer failed to configure ports for the FCM service because there are already entries in the /etc/services file that are configured for a service with the same name. FCM service name: FCM-service-name.

Explanation

In a DB2 pureScale environment, the Fast Communications Manager (FCM) handles communications between DB2 members and cluster caching facilities (CFs).

When you install the DB2 pureScale Feature, a range of ports must be reserved for the FCM to use. The installer attempts to configure a range of ports in the /etc/services file.

This message is returned when the installer detects entries in the /etc/services file for a service with the same name as the new FCM service name.

User response

Remove entries from the /etc/services file that are configured for a service with the same name as the name given in the runtime token FCM-service-name.

DBI20181E The installer failed to configure ports for the FCM service because information in the /etc/services file is incomplete for the FCM service. FCM service name: FCM-service-name.

Explanation

In a DB2 pureScale environment, the Fast Communications Manager (FCM) handles communications between DB2 members and cluster caching facilities (CFs).

When you install the DB2 pureScale Feature, a range of ports must be reserved for the FCM to use. The installer attempts to configure a range of ports in the /etc/services file.

This message is returned when the installer detects entries in the /etc/services file for a service with the same name as the new FCM service name.

User response

Specify complete information for service name FCM-service-name in the /etc/services file.

DBI20182W Program program-name completed successfully but with warnings.

Explanation

This program completed successfully but with one or more warnings.

User response

For more information on warnings, look at the program log file and take appropriate action if required.

DBI20183W The execution completed with warnings.

Explanation

Execution completed with one or more warnings. Refer to installation log file for more information.

User response

Refer to installation log file for more information on one or more warnings. Take action accordingly and retry the execution.