home clear 64x64
en blue 200x116 de orange 200x116 info letter User
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 IC97825 Status: Closed

DB2OSCONF DOES NOT SHOW SEMUME IN HP-UX.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
db2osconf does not show semume. 
 
$ db2osconf | grep -c semume 
0 
 
If semume is specified default value, semop may fail with 
EINVAL. 
 
Here is a part of db2daig.log. 
2013-02-06-18.52.43.440012+540 E680250A473        LEVEL: Error 
(OS) 
... snip ... 
FUNCTION: DB2 UDB, oper system services, sqloOpenMLNQue, probe:3 
MESSAGE : ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad 
Queue Handle" 
          DIA8555C An invalid message queue handle was 
encountered. 
CALLED  : OS, -, semop 
OSERR   : EINVAL (22) "Invalid argument" 
 
 
From man of HP-UX. 
man semume 
 NAME 
      semume - maximum number of System V IPC undo entries per 
process 
... snip ... 
DESCRIPTION 
      The semume tunable specifies the maximum number of System 
V IPC 
      semaphores upon which a single process can have 
outstanding (non-zero) 
      "undo" operations. 
 
      If an application exhausts this limit, it will receive an 
[EINVAL] 
      error from semop(). 
 
man semop 
 NAME 
      semop, semtimedop - semaphore operations 
... snip ... 
 RETURN VALUE 
           [EINVAL]  The number of individual semaphores for 
which the 
                          calling process requests a SEM_UNDO 
would exceed 
                          the limit.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 10.1 fixpack 4.                   * 
****************************************************************
Local Fix:
Increase semume
available fix packs:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 10.1 fix pack 4.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
21.11.2013
02.06.2014
02.06.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.4 FixList