Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ibm-db2 > #2858

DB2 activating de-activated DB's

Show all headers | View raw

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

Back to comp.databases.ibm-db2 | Previous | Next — Next in thread | Find similar

Thread

DB2 activating de-activated DB's bwmiller16@gmail.com - 2017-05-24 06:04 -0700
  Re: DB2 activating de-activated DB's Luiz da Silva <luizsms@gmail.com> - 2017-05-25 09:43 -0700
  Re: DB2 activating de-activated DB's Luiz da Silva <luizsms@gmail.com> - 2017-05-25 09:44 -0700
    Re: DB2 activating de-activated DB's jbaron@calculo-sa.es - 2017-05-29 00:19 -0700
  Re: DB2 activating de-activated DB's ma7.jason@gmail.com - 2019-09-07 17:55 -0700

csiph-web