suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)