DB2 activating de-activated DB's

[b***@gmail.com]

Hello all... Yay DB2!

I just upgraded a client from 9.7 to 10.5 FP3 (3 because they run OneWorld and that is the level we were told to use when the client upgraded from E1 9.0 to E1 9.2). Anyway, its under AIX 7 with HADR.

So, I have 3 older OneWorld 9.0 (E1) databases on the system, mainly so that if the client needs some older data then its readily available. I plan on dropping these databases this up-coming weekend. I have revoked all CONNECT authority for user ID's on these DBs.

I have these 3 databases deactivated and STMM is OFF to reduce activity. My db2diag log is constant with these 3 DB's getting activated automatically by something in DB2. DB2 is then deactivating them after a short period of time but in the meantime meaningless and constant messages are filling up the db2diag log.

All committed transactions have been written to disk = YES
Rollforward pending = NO
Restore pending = NO


Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Real-time statistics (AUTO_STMT_STATS) = OFF
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic reorganization (AUTO_REORG) = OFF

I just don't see what might be causing this ACTIVATE/DEACTIVATE activity to occur on these 3 DB's.

Anybody have a clue?

thanks,

-B

[Luiz da Silva]

Post by b***@gmail.com
Hello all... Yay DB2!
I just upgraded a client from 9.7 to 10.5 FP3 (3 because they run OneWorld and that is the level we were told to use when the client upgraded from E1 9.0 to E1 9.2). Anyway, its under AIX 7 with HADR.
So, I have 3 older OneWorld 9.0 (E1) databases on the system, mainly so that if the client needs some older data then its readily available. I plan on dropping these databases this up-coming weekend. I have revoked all CONNECT authority for user ID's on these DBs.
I have these 3 databases deactivated and STMM is OFF to reduce activity. My db2diag log is constant with these 3 DB's getting activated automatically by something in DB2. DB2 is then deactivating them after a short period of time but in the meantime meaningless and constant messages are filling up the db2diag log.
All committed transactions have been written to disk = YES
Rollforward pending = NO
Restore pending = NO
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Real-time statistics (AUTO_STMT_STATS) = OFF
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic reorganization (AUTO_REORG) = OFF
I just don't see what might be causing this ACTIVATE/DEACTIVATE activity to occur on these 3 DB's.
Anybody have a clue?
thanks,
-B

When a database is explicity deactivated, an user/application connection implicitly activates the databases. Once the connection is gone the database is deactivated again.

Maybe there is an user with SECADM, DBADM or ACCESCTRL authority trying to connect to those dbs?

[Luiz da Silva]

Post by b***@gmail.com
Hello all... Yay DB2!
I just upgraded a client from 9.7 to 10.5 FP3 (3 because they run OneWorld and that is the level we were told to use when the client upgraded from E1 9.0 to E1 9.2). Anyway, its under AIX 7 with HADR.
So, I have 3 older OneWorld 9.0 (E1) databases on the system, mainly so that if the client needs some older data then its readily available. I plan on dropping these databases this up-coming weekend. I have revoked all CONNECT authority for user ID's on these DBs.
I have these 3 databases deactivated and STMM is OFF to reduce activity. My db2diag log is constant with these 3 DB's getting activated automatically by something in DB2. DB2 is then deactivating them after a short period of time but in the meantime meaningless and constant messages are filling up the db2diag log.
All committed transactions have been written to disk = YES
Rollforward pending = NO
Restore pending = NO
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Real-time statistics (AUTO_STMT_STATS) = OFF
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic reorganization (AUTO_REORG) = OFF
I just don't see what might be causing this ACTIVATE/DEACTIVATE activity to occur on these 3 DB's.
Anybody have a clue?
thanks,
-B

When a database is explicitly deactivated, an user/application connection implicitly activates the databases. Once the connection is gone the database is deactivated again.

Maybe there is an user with SECADM, DBADM or ACCESCTRL authority trying to connect to those dbs?

[j***@calculo-sa.es]

Post by Luiz da Silva

Post by b***@gmail.com
Hello all... Yay DB2!
I just upgraded a client from 9.7 to 10.5 FP3 (3 because they run OneWorld and that is the level we were told to use when the client upgraded from E1 9.0 to E1 9.2). Anyway, its under AIX 7 with HADR.
So, I have 3 older OneWorld 9.0 (E1) databases on the system, mainly so that if the client needs some older data then its readily available. I plan on dropping these databases this up-coming weekend. I have revoked all CONNECT authority for user ID's on these DBs.
I have these 3 databases deactivated and STMM is OFF to reduce activity. My db2diag log is constant with these 3 DB's getting activated automatically by something in DB2. DB2 is then deactivating them after a short period of time but in the meantime meaningless and constant messages are filling up the db2diag log.
All committed transactions have been written to disk = YES
Rollforward pending = NO
Restore pending = NO
Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Real-time statistics (AUTO_STMT_STATS) = OFF
Statistical views (AUTO_STATS_VIEWS) = OFF
Automatic sampling (AUTO_SAMPLING) = OFF
Automatic reorganization (AUTO_REORG) = OFF
I just don't see what might be causing this ACTIVATE/DEACTIVATE activity to occur on these 3 DB's.
Anybody have a clue?
thanks,
-B

When a database is explicitly deactivated, an user/application connection implicitly activates the databases. Once the connection is gone the database is deactivated again.
Maybe there is an user with SECADM, DBADM or ACCESCTRL authority trying to connect to those dbs?

You might want to set the DB in quiesced state to avoid unexpected connections. In that case make sure the users trying to connect have no quiesceconnect on DB privilege.

[m***@gmail.com]

This post might be inappropriate. Click to display it.