Results 1 to 3 of 3

Thread: DB2 login error

  1. #1
    Join Date
    Sep 2011
    Posts
    3

    Unanswered: DB2 login error

    Hi all ,
    I am very new to DB2..Actually i am getting data from DB2 soruce and loaging that into SQL tables.
    When i am trying to connect to source i am getting an error..until yesterday it was fine.

    ------------------------------ Commands Entered ------------------------------
    connect to AMDPROD user m45575 using ********;
    ------------------------------------------------------------------------------
    connect to AMDPROD user m4557511 using
    SQL20157N User "M4557511 " does not have the QUIESCE_CONNECT privilege.
    SQLSTATE=08004

    SQL20157N User "M4557511 " does not have the QUIESCE_CONNECT privilege.

    Explanation:

    The specified authorization ID does not have the QUIESCE_CONNECT
    privilege to access a database or instance that is currently in a
    quiesced mode. The QUIESCE_CONNECT privilege must be granted
    before the user can connect to a quiesced database or instance.

    User Response:

    Wait for the unquiesce to complete or contact the system
    administrator or database administrator for the database and
    request a GRANT QUIESCE_CONNECT for the authorization ID.
    Resubmit the command.

    sqlcode :-20157

    sqlstate :08004

    Plz let me know what does it means.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please follow the directions in the "User Response".
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2011
    Posts
    3
    Thanks...i got it

Posting Permissions

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