Results 1 to 2 of 2

Thread: unlock db2 db

  1. #1
    Join Date
    Oct 2010

    Unanswered: unlock db2 db

    Hi All,

    I have a db2 database named xmeta owned by user 'xmeta'(my datastage repository db).
    Now i found that 'Login failed for user 'xmeta'. Reason: The account is disabled'.

    i heard that DBA should do an "alter user xmeta account unlock if it is oracle repository.
    But mine is db2 and don't know how to unlock/enable this account.
    I only installed DB2 and don't have any DBA.
    Could you please help me on this issue?

  2. #2
    Join Date
    May 2003
    DB2 uses operating system authentication, so make sure that account is set up and enabled in the OS. You should be able to logon to the box (outside of DB2) before proceeding.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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