Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Question Unanswered: DB2 UDB SQL5005C System error


    I installed v9.7 ESE with default "db2admin" konto, as I use another user konto to login in Win7, got an system error "SQL5005C", but with "db2admin" is ok. how can I fix it ?

    follow shows the part of infos with db2diag:

    2011-07-06- I47011F484 LEVEL: Error
    PID : 6580 TID : 6048 PROC : db2dasstm.exe
    INSTANCE: DB2 NODE : 000
    APPID : *LOCAL.DB2.110706103735
    EDUID : 6048
    FUNCTION: DB2 Tools, DB2 administration server, writeICMErrorMsg, probe:10
    DATA #1 : String, 149 bytes
    [IBM][CLI Driver][DB2/NT64] SQL0552N "DB2ADMIN" has no access rights for executing operation "CREATE SCHEMA". SQLSTATE=42502

  2. #2
    Join Date
    Jul 2006
    looks like permission issue.
    Check your konto user account, if its available as OS user and you granted permission for this user for your database.
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

Posting Permissions

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