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 | |
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 | |
10.5.0.3 |