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 number
IC85639
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-08-02
Closed date
2012-08-09
Last modified date
2012-08-09
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
09 August 2012