Hi there,

When I run "get authorizations" on all DB2 servers (Including AIX 5.2 DB2 7.2.9 and Windows 2000 DB 2 7.2.7), I get the following error:

db2 => get authorizations
SQL2018N The utility encountered an error "-1024" while attempting to verify
the user's authorization ID or database authorizations.
db2 => ? SQL2018n

SQL2018N The utility encountered an error "<error>" while
attempting to verify the user's authorization ID or
database authorizations.

Explanation: The user attempted to execute a utility and one of
the following has occurred:

o The user authorization ID is not valid.

o An error occurred attempting to access the user's
authorizations for the database.



The utility stops processing.

User Response: Look at the error number in the message for more
information. Make changes and resubmit the command.

What's the "the message" in the above "User Response"? What does the error "-1024" mean?

Usually when you get an error message that has an error code, as in your case -1024, that is another error that the utility encountered. Error codes that are positive are warnings and ones that are negative are errors. THese map directly to SQL codes, in your case SQL1024N which is "a database connection does not exist".

You need to connect to a DB to issue GET AUTHORIZATIONS

ANdy

db2 => ? SQL01024

SQL1024N A database connection does not exist.

Explanation: There is no connection to a database. Other SQL
statements cannot be processed unless an SQL CONNECT was
previously executed.

The command cannot be processed.

User Response: If the error occurred when disconnecting from the
database, continue processing. If the error occurred on another
SQL statement, issue an SQL CONNECT statement and resubmit the
command or statement.

sqlcode: -1024

sqlstate: 08003