Results 1 to 3 of 3

Thread: Dba2191e

  1. #1
    Join Date
    Feb 2002

    Lightbulb Unanswered: Dba2191e

    when executing a select statement on DB2 71 EE on AIX, a message box says DBA2191E error occurs. anyone can help me find out it's meaning?


  2. #2
    Join Date
    May 2002
    Look in the db2diag.log file. You may need to update your diaglevel instance parameter...

    db2 update dbm cfg using diaglevel 4

    ...then recycle db2, now you should get just about every little piece of information that you would ever want in the db2diag.log file.

    The file is located in the instance directory. Don't know where that is in Unix but on Windows its in \sqllib\db2 or \sqllib\db2mpp or \sqllib\instance_name .

    Good Luck...

  3. #3
    Join Date
    Feb 2002

    further information about DBA2191E

    hi Chris F.

    thanks for your advise.
    I have settled the problem.
    When allocating memory to sortheap, DB2 meets a problem.IBM consider it as a bug.One way is to run the sql backyard and another way is to fix the DB2 by pack six.


Posting Permissions

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