IC85639: REPLICATE NODE PREVIEW=YES WITH OPTION CAN CAUSE A SERVER CRASH.

APAR status

• Closed as program error.

Error description

• If a percieved data rate of greater than 2gb/s is encountered
  when the replicate node command is run with the preview=yes
  option, a server crash can occur.
  
  TSM Versions Affected: All 63 on all platforms
  
  Customer/L2 Diagnostics:
  A. Login to the TSM Server system as the DB2 instance owner.
  B. Open a command line window:
     1. Windows:
        Start > All Programs > IBM DB2 > DB2TSM1 (Default)
        > Command Line Tools > Command Window - Administrator
     2. Unix:
        su - tsminst1
  C. Run the following commands, in sequence:
     db2 connect to tsmdb1
     db2 set schema tsmdb1
     db2 "SELECT AVG
          ( ( bytes_transferred / transfer_time ) / num_sessions )
          FROM tsmdb1.replication_history WHERE
          servername=<SERVERNAME_of_TARGET_SERVER>
          AND transfer_time>0 AND num_sessions>0
          AND bytes_transferred>0 FOR READ ONLY WITH CS"
  
  NOTES:
  1. The entire SELECT must be entered at the same time on the
     same line.
  2. <SERVERNAME_of_TARGET_SERVER> *must* be replaced with the
     corresponding TSM Server name.
  
    Callstack from the core/dmp file:
    ANR9999D_1725343428 IssueMsgs(tbrsql.c:1701) Thread<XX>:
      DEBUG SERVER ONLY output to dump callstack.
      SQLSTATE 22003, SQLCODE -99999.
    ANR9999D Thread<XX> issued message 9999 from:
    ANR9999D Thread<XX> OutDiagToCons()+181 output.c:1287
    ANR9999D Thread<XX> outDiagfExt()+1f4 outvarg.c:215
    ANR9999D Thread<XX> IssueMsgs()+76d dbieval.c:1291
    ANR9999D Thread<XX> DbiEvalSQLOutcomeX()+a25 dbieval.c:667
    ANR9999D Thread<XX> DbiEvalSQLOutcome()+bb dbdefs.h:1218
    ANR9999D Thread<XX> tbRegSkipAndFetch()+552 tbrsql.c:1706
    ANR9999D Thread<XX> GetTransferRate()+381 nrmain.c:12171
    ANR9999D Thread<XX> IssuePreviewMessages()+819 nrmain.c:11653
    ANR9999D Thread<XX> NrReplicationThread()+2b4b nrmain.c:1760
    ANR9999D Thread<XX> startThread()+326 pkthread.c:3017
    ANR9999D Thread<XX> beginthreadex()+2d5
    ANR9999D Thread<XX> beginthreadex()+294
    ANR9999D Thread<XX> BaseThreadInitThunk()+d
    ANR9999D Thread<XX> RtlUserThreadStart()+21
    ANR0162W Supplemental database diagnostic information:
             1:22003:-99999 ([IBM][CLI Driver]
               CLI0111E  Numeric value out of range.
               SQLSTATE=22003).
  
    Initial Impact: High
  
    Additional Keywords:
    crash abend
  

Local fix

• Avoid the use of the preview=yes option, if possible.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.3.3. Note that this is            *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  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

• R63A PSY

     UP

• R63H PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP

• R63W PSY

     UP