Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    82

    Unanswered: db2diag log error

    When I connect to my database .. it takes a lot of time to connect.. when I check the log I get this error.

    WARNING: The user per process file descriptor limit of 1024 is less than the maxfilop setting of 61440.
    Decrease maxfilop to below the user process file descriptor limit, or
    increase the user process file descriptor limit to remove this warning.
    Setting maxfilop temporarily to 820

    the complete log entry is

    2012-09-30-14.48.46.739555-240 E18876A736 LEVEL: Severe
    PID : 27375 TID : 2199383959888PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : SODAPROD
    APPHDL : 0-80 APPID: *LOCAL.db2inst1.120930184846
    AUTHID : DB2INST1
    EDUID : 21 EDUNAME: db2agent (APP_PROD) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbCheckRegistryAndBpvars, probe:10
    DATA #1 : <preformatted>
    WARNING: The user per process file descriptor limit of 1024 is less than the maxfilop setting of 61440.
    Decrease maxfilop to below the user process file descriptor limit, or
    increase the user process file descriptor limit to remove this warning.
    Setting maxfilop temporarily to 820



    Any idea.. how I can increase user process file descriptor limit..??


    Running db2 9.7 fp 3a on linux on z...

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    man ulimit
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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