DB2 - Problem description
Problem IT34112 | Status: Closed |
DB2BP TIMEOUT FOR LARGE UID | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When UID is larger than operating system's maximum value for integer, all CLP will fail and timeout with the error below: DB21015E The Command Line Processor backend process request queue or input queue was not created within the timeout period. Update DBM cfg SYSADM_GROUP errcode = 8 Sample output from AIX, UID is larger than AIX's maximum value 2147483647 which can be held by integer data type. $ id db2inst1 uid=4039207222(db2inst1) gid=2139207222(db2adm) groups=209(db2test) UID number is larger than AIX's maximum value for integer (2147483647) AFFECTS: Upgrading to v10.5 FP11 DB2 v11.1 and v11.5 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v11.1 Mod 4 Fixpack 6 to DB2 server * **************************************************************** | |
Local Fix: | |
Revert to v10.5 FP10 if DB2 instance was upgraded to FP11 OR Use operating system commands to change UID to number that is smaller. This would also require ownership change for database files (/NODE0000/...), DB2 instance home ($HOME/), etc... since existing files created with older UID would now have no owner | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v11.1 Mod 4 Fixpack 6 to DB2 server * **************************************************************** | |
Comment | |
Apply v11.1 Mod 4 Fixpack 6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.09.2020 29.03.2021 29.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |