ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001

Post new topic  Reply to topic
 ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 « View previous topic :: View next topic » 
Author Message
mahesh4eai
PostPosted: Sun Nov 29, 2015 7:33 am    Post subject: ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 Reply with quote

Novice

Joined: 09 Aug 2014
Posts: 21
Hi All,

I need your help on below issue.

I am working in one of client,still they are using message broker 6.1.

while seeing the list of execution groups under broker its throwing the below error.

$ mqsilist EEAX602D
BIP2393E: Database error: ODBC return code '-1' from data source ''EEAX602D''.
The broker received an error when executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical causes are incorrect data source or table names. Correct either the database or the broker configuration.
BIP2322E: Database error: SQL State ''08001''; Native Error Code '-30082'; Error Text ''[IBM][CLI Driver] SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 ''.
The error has the following diagnostic information: SQL State ''08001'' SQL Native Error Code '-30082' SQL Error Text ''[IBM][CLI Driver] SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 ''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

For resolution I have restarted the broker and DB2 but issue not resolved.

Kindly help me.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun Nov 29, 2015 9:30 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
What does your search for "USERID DISABLED or RESTRICTED

Show up?

do you not think that this could be a DB2 problem?
Have you asked your DB2 Admins what the solution to this is?

Oh, and V6.1 went out of support several years ago.

Time to move to a more recent version that does not have this dependency perhaps?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.