Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Unanswered: Instance problem

    Hi all - DB2 8.1.5 AIX 5.2.0.0

    When I quiesce or create a db within my instance
    - I suddenly cannot connect to the other databases
    under that instance without stopping and starting it !!

    Very frustrating - does anyone know whats going on ? (see code below)

    db2 => connect to toolsdb

    Database Connection Information

    Database server = DB2/6000 8.1.5
    SQL authorization ID = DB2INST2
    Local database alias = TOOLSDB

    db2 =>
    db2 =>
    db2 =>
    db2 => quiesce db immediate force connections
    DB20000I The QUIESCE DATABASE command completed successfully.
    db2 => connect reset
    DB20000I The SQL command completed successfully.
    db2 =>
    db2 =>
    db2 =>
    db2 => backup db toolsdb use tsm

    Backup successful. The timestamp for this backup image is : 20050114130640

    db2 => connect to toolsdb

    Database Connection Information

    Database server = DB2/6000 8.1.5
    SQL authorization ID = DB2INST2
    Local database alias = TOOLSDB

    db2 =>
    db2 =>
    db2 =>
    db2 => unquiesce db
    DB20000I The UNQUIESCE DATABASE command completed successfully.
    db2 => connect reset
    DB20000I The SQL command completed successfully.
    db2 =>
    db2 =>
    db2 =>
    db2 =>
    db2 => connect to sst
    SQL1391N The database is already in use by another instance of the database
    manager. SQLSTATE=51023
    db2 =>
    db2 =>
    db2 =>
    db2 => db2stop
    SQL1025N The database manager was not stopped because databases are still
    active.
    db2 => db2stop force
    DB20000I The DB2STOP command completed successfully.
    db2 => db2start
    DB20000I The DB2START command completed successfully.
    db2 => connect to sst

    Database Connection Information

    Database server = DB2/6000 8.1.5
    SQL authorization ID = DB2INST2
    Local database alias = SST

    db2 =>
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is a known bug with quiesce command in fixpak 5. Install fixpak 6a.
    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
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Talking

    Thank You Marcus

    - I didn't know
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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