Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    61

    Question Unanswered: What's the "the message" in the "User Response"?

    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?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Aug 2004
    Posts
    138
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •