hi,

My online incremental backup is getting failed today ,

it throws the error that it has reached the maxfilop.

So i have increased it to 61140 which is the maximum, then from OS level we have rhel, which had the maximum open connection/files as 1024 we increased it to 4096.

And found in google as can be issue in NFS, So we restarted the NFS service.
Still we are facing the same problem.

Help to over come the issue.

mu envi RHEL 5.5 , db2 9.7 64 bit.

Thanks!

When DB2 says "it has reached the maxfilop" , does it do so with a code ? And, does it write some info in the db2diag.log ?

And where exactly does NFS fit in the picture ?

hi sathya,

it has got nothing to do with the code and diaglog says
2011-12-06-12.15.23.211469+330 E483165140E481 LEVEL: Error
PID : 8485 TID : 47929855306048PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : WAREHOUS
APPHDL : 0-2186 APPID: *LOCAL.db2inst1.111206064512
AUTHID : DB2INST1
EDUID : 225 EDUNAME: db2agent (WAREHOUS)
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:909
MESSAGE : SQL0958C The maximum number of open files has been reached.

Now we are finding like backup is finished but the file size in 0
In one of the forum i read that
"if you are using NFS, either for the core database or for the files involving LOAD, EXPORT, BACKUP, RESTORE, make sure that nfslock is running."

when i check nfslock is also running...

i could see this error in the diagloag.

2011-12-06-13.56.39.610060+330 E483231019E1242 LEVEL: Error (OS)
PID : 8485 TID : 47929880471872PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : WAREHOUS
APPHDL : 0-5122 APPID: *LOCAL.db2inst1.111206082635
AUTHID : DB2INST1
EDUID : 240 EDUNAME: db2agent (WAREHOUS)
FUNCTION: DB2 UDB, oper system services, sqloflock, probe:100
MESSAGE : ZRC=0x850F0006=-2062614522=SQLO_FHNL "TOO MANY OPEN FILES"
DIA8306C Too many files were opened.
CALLED : OS, -, fcntl OSERR: ENOLCK (37)
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
File Handle = 112
File System Block Size = 0 bytes
File System Type = UNKNOWN
File Handle Flags :
Require Sector Align = No
DIO/CIO Mode = No
Raw Block Device = No
Reserved Handle = No
Flush On Close = No
Thread-Level Lock = Yes
Write-through Mode = Yes
File Not Tracked = No
DATA #2 : Hex integer, 1 bytes
0x01
DATA #3 : Hex integer, 1 bytes
0x03
DATA #4 : String, 105 bytes
Search for ossError*Analysis probe point after this log entry for further
self-diagnosis of this problem.


it also says about the files open... but we have that parameter to the maximum

cld this help, it was from did forum

Maximum Number of Open Files Reached- Error: SQL0958C - Toolbox for IT Groups

regds
Paul

show the results of below command,please

1 su - db2inst1

2 db2 get db cfg show detail|grep MAXFILOP

3 ulimit -Sn
ulimit -Hn

Do you build your database on NFS?
if so , plz make sure your NAS is supported by DB2:
IBM Verified network-attached storage systems for use with DB2 Universal Database Version 8.x and DB2 9.x - United States

thanks for all your suggestion.

On correcting 2 issues, we got this resoved.

1. NFSLOCK was not set to on the server.
2. rpcinfo service was not enabled.

doing these 2 changes we found the backup was successfull.