IBM Support

When running a db2pd command on Windows against an activated database it returns "Option <option> requires <database> or -alldbs option and active database

Troubleshooting


Problem

With certain Windows configurations, the db2pd command can return a message that indicates the database against which you are running the db2pd command is not activated. To be sure that the database is activated, run “db2 activate db ”. If the database is already active, a likely cause is a configuration problem of the “User Rights” in Windows and DB2’s ability to use Windows debugging utilities.

Environment

Windows

Resolving The Problem

To verify the User Rights are configured correctly, we need to look at the local security policy on Windows:

Click control Panel - > Administrative Tools -> Local Security Policy

The Local Security Settings dialogue box should now be displayed.

From the Local Security Settings dialogue, select “Local Policies” from the right hand navigation, then double click “User Rights Assignment”



You should see in the list “Debug Programs”



If you don’t already see DB2ADMNS as having the right to Debug programs, this is likely the problem. To make the proper changes, double click “Debug programs” and add the DB2ADMNS group to the list by clicking the “Add User or Group” button.



After adding the group, it is important that you LOG OUT and log back in for the settings to take effect. In some cases, a reboot is necessary for the changes to take effect.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - db2pd","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5;9.1;8","Edition":"Enterprise Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21358580