IBM Support

SQL1092N error when attempting to create new database on DB2

Troubleshooting


Problem

This technote explains how to resolve an SQL1092N error that might occur when creating a new database on IBM® DB2® with IBM Rational® ClearQuest®.

Symptom

This error occurs when trying to create a new ClearQuest schema repository or user database with DB2 as a backend:

Error SQ1092N "<authorization-ID>" does not have the authority to perform the requested command.

Cause

This can occur if the the userid authorization-ID on the database server is attempting to use or modify a database resource, while not a member of the local DB2USERS or DB2ADMNS group. This is not allowed. The command cannot be processed.

Resolving The Problem

To resolve this issue, add the userid authorization-ID to the local windows security groups DB2USERS or DB2ADMNS using the Windows Computer Management tool.

  1. Go to Start > Control Panel > User Accounts.
  2. In the Advanced tab, click the Advanced button.
  3. Expand the Groups folder.
  4. Edit DB2ADMNS or DB2USERS and add the authorization-ID as a member of the group.
  5. This should prompt to log off and log back in for changes to take effect.

Note: Make sure the DB2 instance is running as an domain account where the domain is a member of the local Administrators group.

For more information, contact IBM DB2 support.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Configuration\/Connectivity - DB2","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4;7.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Designer - Database Administration","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Maintenance tool","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
04 December 2018

UID

swg21284960

Page Feedback