Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Talking Unanswered: db2 online incremental backup getting failed

    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!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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 ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    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...

  4. #4
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    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

  5. #5
    Join Date
    Oct 2007
    Posts
    246

  6. #6
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    show the results of below command,please

    1 su - db2inst1

    2 db2 get db cfg show detail|grep MAXFILOP

    3 ulimit -Sn
    ulimit -Hn

  7. #7
    Join Date
    Nov 2011
    Posts
    334
    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

  8. #8
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •