Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    40

    Red face Unanswered: whats SQL Error: -1131, SQLState: 38503 ???

    Hi guys !! Please urgently help me out the the error SQL Error: -1131, SQLState: 38503. I am currently using db2 8.2 on aix. I have attached the db2diag file. My system is horrible affected by this. is this a bug ??
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I don't expect us to look through over 100 pages of your db2diag.log, do you? (I had a look at the first page, and you may want to take care of the lock escalations.)

    SQLCODE -1131 means that some stored procedure crashed. But without any more details on what you are doing, we cannot really say anything.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Feb 2008
    Posts
    40
    Hi.recently i have made changes for certain files under sqllib folder
    (db2shrc,db2audit)..but execute permission has been given to others and groups for those files... is ther any issue reltd to this ??

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Sure, you changed things you were not supposed to change.

    You should run "db2iupdt" to revert your changes and fix your instance.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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