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 IC95443 Status: Closed

ossGetDiskInfo reports the error message in db2diag.log about filesystems
not related to DB2

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
On Linux platform, when getting file system information, some 
error messages about a file system not related to DB2 may be 
written to db2diag.log. This could occur when: 
 - File system(A) is mounted but cannot be accessed by DB2 due 
to permissions, etc. 
 - File system(B) is used for DB2(database directory, tablespace 
containers, etc) is mounted but appears lower than (A) in 
/proc/mounts 
 
The error message is as follows(The stack can be vary): 
 
2013-02-14-10.43.41.239868+540 I5761119A3189        LEVEL: Error 
PID     : 64566                TID : 2199434291472  PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000           DB   : 
SAMPLE 
APPHDL  : 0-7                  APPID: 
*LOCAL.db2inst1.130214014341 
AUTHID  : DB2INST1             HOSTNAME: mydbserver 
EDUID   : 19                   EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:80 
DATA #1 : signed integer, 4 bytes 
13 
DATA #2 : String, 26 bytes 
/dev/mapper/workvg-nondblv 
DATA #3 : String, 16 bytes 
/data/nondbfs 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x0000020006D3CDE2 
/home/opminst1/sqllib/lib64/libdb2osse.so.1 + 0x202DE2 
  [1] 0x0000020006D3DCEC ossLog + 0xFC 
  [2] 0x0000020006D59BCC ossGetDiskInfo + 0x70C 
  [3] 0x00000200016D0352 
_Z21sqlbGetFileSystemInfoPcP11OSSDiskInfoj + 0x102 
  [4] 0x00000200016BF35A 
_Z30sqlbCopyStoragePathsFromDiskCBPcmP13SQLO_MEM_POOLS_P20SQLB_S 
TORAGEGROUP_CBj + 0x3DE 
  [5] 0x00000200016BFC40 
_Z25sqlbReadStorageGroupEntryPclR12SQLO_FHANDLElP13SQLO_MEM_POOL 
PP20SQLB_STORAGEGROUP_CBP28SQLB_STORAGEGROUP_FILE_ENTRYjb + 
0x61C 
  [6] 0x00000200016C7DF4 
_Z20sqlbReadStorageGrouplP16sqeLocalDatabaseP23SQLB_STORAGEGROUP 
_TABLER12SQLO_FHANDLES4_P13SQLO_MEM_POOLPcjjb + 0x8F0 
  [7] 0x00000200016CC906 
_Z25sqlbReadStorageGroupTablePcP16sqeLocalDatabaseP23SQLB_STORAG 
EGROUP_TABLEP13SQLO_MEM_POOLjjb + 0x65E 
  [8] 0x00000200016CD204 sqlbInitStorageGroupTable + 0x698 
  [9] 0x00000200015CEE54 sqlbinit + 0x2E0 
  ..(snip)..
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 on Linux                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 3.                      * 
****************************************************************
Local Fix:
Mount the DB2 related file system before mounting other file 
systems which DB2 cannot access to.
available fix packs:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 10.5 Fix Pack 3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.08.2013
24.03.2014
24.03.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.3 FixList
10.5.0.3 FixList