IT48964: OPERATIONS CENTER USERS WITH STATUSMONITIOR ENABLED MAY RUN INTO ISSUE WITH THE SERVER ACTIVELOG FULL

APAR status

• Closed as program error.

Error description

• After upgrade Storage Protect server to Version 8.2, Operations
  Center users with status monitor enabled can run into issue that
  the db2 active log fill up and causes server to become hang or
  crash.
  Customer /Support diagnostics:
  
  
  1. Validate status monitoring is enabled with :
    query  monitorsettings
  2. The command "query Log" will show the log usage continues to
  increase
  3. The command "db2 GET SNAPSHOT FOR DATABASE ON tsmdb1" shows :
  
    Appl id holding the oldest transaction = 1370
  4. The command "show txn" shows transaction 1370 belongs to
  thread 207 :
  
  Thread 207, ID 6800 (0x1a90): MonMaintThread, procToken=0,
  sessToken=0
  Parent=9, result=0, joining=0, detached=1, zombie=0, session=0
  Holding mutex 000001D29D5F7010 (&txnP->mutex)
  Stack trace:
  47060404 Unknown
  7ffe446fd90e WaitForSingleObjectEx()+8e
  7ffe39c4f8d5 sqloWaitInterrupt()+2f5
  7ffe39b21529 sqloSSemP()+39
  7ffe3b1c982c sqlcmhex()+4a2c
  7ffe3b1d1172 sqlccrecv()+3b2
  7ffe3b50cec9 sqljcReadGetPtrInt()+ec9
  7ffe3b53a4b2 sqljrDrdaArExecute()+972
  7ffe3ba2b503 CLI_dumpEventRecords()+10ac3
  7ffe3b86270f SQLReloadConfig()+a0ef
  7ffe3b83f30e SQLExecute()+17fe
  7ffe1787128f RdbPrepareAndExecuteStmt()+77f
  7ffe1786fff9 RdbCliInsert()+279
  7ffe17863ec5 tbCliSRInsDel()+6b5
  7ffe17666867 InsertAdminMaintGrids()+797
  7ffe176689d4 MonMonitorMaintHistory()+bd4
  7ffe176524b5 StatusMonitorGridsThread()+435
  7ffe16f6d913 startThread()+5b3
  7ffe445d6b4c recalloc()+5c
  
  
  
  MDVPARTL 8.2.0.0-TIV_5698ISMSV | IT44479
  
  Platform Version Affected:
  Storage Protect server 8.2.0 on all supported platforms
  

Local fix

• Disable status monitor with command
  Set statusmonitor off
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 	                                                            *
  * All IBM Storage Protect server users.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This problem is currently projected to be fixed in level 8.2.1.
  Note that this is subject to change at the discretion of IBM.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels