[IBM][DB2/LINUXX8664] SQL1092N failed because the user ID does not have the authority to perform (4221455)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

[IBM][DB2/LINUXX8664] SQL1092N failed because the user ID does not have the authority to perform
Description

IBM.Data.DB2.DB2Exception: ERROR [] [IBM][DB2/LINUXX8664] SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: "E008099".
Stack trace:
at IBM.Data.DB2.DB2DataReader.Read()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
Cause

Toad is demanding that the user must have the SYSADM authority granted.
Resolution

WORKAROUND
First, open "Options | Databases | SQL Dictionary", and find the row named "DB2.Trl.Tablespace.TablespaceContainerSQLTrl", select it and click on "New" and add this script:
select
t.DBPARTITIONNUM,
t.STRIPE_SET,
t.CONTAINER_NAME,
t.CONTAINER_ID,
t.CONTAINER_TYPE,
t.TOTAL_PAGES,
t.USABLE_PAGES,
char(t.ACCESSIBLE) AS ACCESSIBLE
from TABLE(MON_GET_CONTAINER('',-1)) AS t
where t.TBSP_NAME = ?
order by 1, 2, 3
for fetch only with UR
Apply and restart toad.

STATUS:
This issue is fixed in Toad for DB2 6.5. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

TDB-3430