DB2 - Problem description
Problem IT23128 | Status: Closed |
CREATE DATABASE RETURNS -1051 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When trying to create additional databases with system automation running, you may encounter messages like this in the db2diag.log: sqlhaEligibleHAFilesystem: /db1, fsType nfs4, instance policy 7 is not an HA eligible mount path "The path provided is not eligible to be used in shared data." MESSAGE : While creating database, error occured. Files and directories created will be removed now. DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes -1051 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1.3 Fix Pack 3 * **************************************************************** | |
Local Fix: | |
1) Disable system automation 'db2haicu -disable' and then create database or 2) export DB2_ROCM_DISABLE_FS_CHECK=TRUE and then create database | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 11.1.3 Fix Pack 3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.11.2017 16.03.2018 16.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |