IT24203: REPORTS IN OC DO NOT WORK DUE TO LONG IDLE OC SESSIONS.

7.1.10.000-TIV-TSMSRV-WIN
7.1.10.000-TIV-TSMSRV-SolarisSPARC
7.1.10.000-TIV-TSMSRV-Linuxx86_64
7.1.10.000-TIV-TSMSRV-Linuxs390x
7.1.10.000-TIV-TSMSRV-Linuxppc64
7.1.10.000-TIV-TSMSRV-HP-UX
7.1.10.000-TIV-TSMSRV-AIX
IBM Spectrum Protect Server V7.1 Fix Pack 10 (7.1.10.000) Downloads

APAR status

• Closed as program error.

Error description

• When the Operations Center (OC) Hub server has OC sessions that
  are idle for a long time, the reports in the OC do not work.
  The sessions started by the OC do not end properly and become
  idle.
  Reports in the OC do not work. Manually run the same SQL query
  on the server will take a long time to complete. The SQL query
  will gradually become slower and slower to complete.
  
  IBM Spectrum Protect Versions Affected:
  All supported IBM Spectrum Protect server
  
  Customer/L2 Diagnostics (If Applicable)
  When the reports work, manually run the same SQL queries on the
  server will complete quickly.
  When the reports do not work, manually run the same SQL queries
  on the server will take much longer to complete.
  
  QUERY SESSION on the HUB server will show idle OC sessions for
  more than 1 hour. The OC sessions are the sessions started by
  administrator with partial name 'IBM-OC'
  
  SHOW MONQUEUES will show the monitor queues being full. For
  example,
  0: Queue(0000008CE9333000)(E9333000) Session(993756) Count(0)
  Created(11/27/2017 0:37:6)
  1: Queue(0000008CB0603000)(B0603000) Session(967391) Count(5407)
  Created(11/26/2017 12:4:55)
  2: Queue(0000008C2F681000)(2F681000) Session(941763)
  Count(14385) Created(11/26/2017 0:41:5)
  3: Queue(0000008C2605D000)(2605D000) Session(925802)
  Count(21834) Created(11/25/2017 17:40:41)
  4: Queue(0000008BD57AA000)(D57AA000) Session(921731)
  Count(27998) Created(11/25/2017 15:36:54)
  5: Queue(0000008BB06B4000)(B06B4000) Session(901386)
  Count(29100) Created(11/25/2017 5:50:30)
  6: Queue(00000088F1C4A000)(F1C4A000) Session(894655)
  Count(34261) Created(11/25/2017 2:20:1)
  
  For V7 IBM Spectrum Protect servers the queue is full when the
  count reaches 1024000,
  For V8 IBM Spectrum Protect servers the queue is ull when the
  count reaches 10240.
  
  Initial Impact:
  Medium
  
  Additional Keywords:
  TSM Tivoli Storage Manager SP
  

Local fix

• Use command CANCEL SESSION to cancel all OC sessions when you
  see the following conditions:
  -  Session started by the Operations Center are idle for a long
  time such as 1 hour or more.
  -  COUNT value on the monitor queue continues to increase
  approaching  the maximum queue size.  In a normal monitor queue
  the COUNT increases as data is put on it and then drop down to
  under a hundred as data is read from it
  
  Restart the IBM Spectrum Protect server will also clear out the
  idle sessions.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 7.1.10 and 8.1.5. Note that  *
  * this is subject to change at the discretion of IBM.          *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, HP-UX, Solaris,
  Linux, and Windows.
  Platforms fixed:  AIX, HP-UX, Solaris, Linux, and Windows.
  

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