Hello all... Yay DB2!on these DBs.
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
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 meantimemeaningless 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
Hello all... Yay DB2!on these DBs.
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
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 meantimemeaningless 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
On Wednesday, May 24, 2017 at 3:04:57 PM UTC+2, bwmil...@gmail.com wrote:s on these DBs.
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'
meantime meaningless and constant messages are filling up the db2diag log.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
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?
I just don't see what might be causing this ACTIVATE/DEACTIVATE activity to occur on these 3 DB's.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 78:09:22 |
Calls: | 6,658 |
Calls today: | 4 |
Files: | 12,203 |
Messages: | 5,332,972 |
Posted today: | 1 |