If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 UDB SQL5005C System error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-06-11, 10:58
alanhome alanhome is offline
Registered User
 
Join Date: Mar 2010
Posts: 9
Question DB2 UDB SQL5005C System error

Hello,

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-12.36.50.360000+120 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
Reply With Quote
  #2 (permalink)  
Old 07-07-11, 00:28
singhipst singhipst is offline
Registered User
 
Join Date: Jul 2006
Location: Bangalore
Posts: 57
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 !!**
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On