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 =>