Troubleshooting
Problem
Can connect to database but Query sysibmadm objects got SQL1032N error.
Symptom
Client can connect to database, but select objects of schema sysibmadm, report sql1032n error.
Cause
Too many open files.
Diagnosing The Problem
From the case log I saw following errors;
=========================
2015-06-23-16.07.49.584294+480 I599661581A1589 LEVEL: Error (OS)
PID : 31195516 TID : 1029 PROC : db2fmp (C) 18
INSTANCE: db2inst1 NODE : 018
APPID : *N0.db2inst1.150620181407
EDUID : 1029 EDUNAME: db2fmp (C) 18
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, read
OSERR : EBADF (9) "A file descriptor does not refer to an open file."
DATA #1 : String, 115 bytes
A total of 3 analysis will be performed :
- User info
- Target file info
- I/O attempt
Target file handle = 7
DATA #2 : String, 186 bytes
Real user ID of current process = 1002
Effective user ID of current process = 1002
Real group ID of current process = 998
Effective group ID of current process = 998
DATA #3 : String, 41 bytes
current sbrk(0) value: 0x00000001113d1060
DATA #4 : String, 33 bytes
I/O attempt not implemented yet.
CALLSTCK: (Static functions may not be resolved correctly, as they are
resolved to the nearest symbol)
[0] 0x0900000000D6C270 pdOSSeLoggingCallback + 0x34
[1] 0x09000000008B9CC4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x09000000008BA1A0 ossLogSysRC + 0xA0
[3] 0x09000000008D8D4C ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam
+ 0xC8C
[4] 0x09000000008DADE8 ossErrorAnalysis@AF12_1 + 0x48
[5] 0x0900000000E454C8 sqloSystemErrorHandler + 0x3F8
[6] 0x0900000000E3B0D0 sqloSystemErrorHandler@glue1ED + 0x124
[7] 0x0900000000E3857C sqloread + 0x150
[8] 0x090000000102D760 sqloFtokByInstance + 0x238
[9] 0x0900000000E7ED08 sqloFtokByInstance@glue288 + 0x7C
=========================
Check MAXFILOP value and OS limits, AIX does have a process system wide limit of 64k. But the default value was set to 2000; If didn't change it, this is a quite low value. e.g.:
=================
User Limits, '/usr/bin/ulimit -a'
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000
threads(per process) unlimited
processes(per user) unlimited
=================
Resolving The Problem
For AIX "nofiles" :Sets the soft limit for the number of file descriptors a user process may have open at one time. It is the max number of concurrently open files for a process. Usually unlimited is okay.
Was this topic helpful?
Document Information
Modified date:
19 February 2020
UID
swg21961818