IC95204: NODE REPLICATION FAILS WITH "SQL0180N THE SYNTAX OF THE STRING REPRESENTATION OF A DATETIME VALUE IS INCORRECT"

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads

APAR status

• Closed as program error.

Error description

• During Tivoli Storage Manager server node replication, the
  target server may issue the following series of messages:
  
  ANR0162W Supplemental database diagnostic information:
    -1:22007:-180 ([IBM][CLI Driver][DB2/LINUXX8664]
    SQL0180N  The syntax of the string representation of a
    datetime value is incorrect.  SQLSTATE=22007
  ANR0102E tbcli.c(2146): Error 2343 inserting row in table
    "Backup.Objects".
  ANR0532W smrepl.c(989): Transaction 0:80564755 was aborted for
    session 210980 for node TEST1 (Linux/x86_64).
  
  The following message may also be issued by the target
  replication server while servicing a replication
  request:
  
  ANR9999D SmQueueBackIns(smnode.c:29206) Thread<301287>: Minus
  Infinite metaUpdate for replication
  
  The replication process on the source server will be marked
  FAILURE but some or all objects may have
  successfully replicated as indicated in the ANR0327I message,
  
  e.g.
  ANR0327I Replication of node TEST1 completed.
    Files current: 10,244,016.
    Files replicated: 99,781 of 99,781.
    Files updated: 398,971 of 398,971.
    Files  Zeleted: 262 of 262.
    Amount replicated: 17,422 MB of 17,422 MB.
    Amount transferred: 17,422 MB.
    Elapsed time: 0 Day(s), 8 Hour(s), 45 Minute(s).
    (SESSION: 210980)
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server: 6.3 all platforms
  
  Initial Impact:
  Low
  
  Additional Keywords:
  TSM, node replication, SQL0180N, date, time, zz63
  

Local fix

• If a subset of objects completed replication, using the
  QUERY REPLICATION command to determine which node and filespace
  is affected and if necessary, schedule a REPLICATE NODE
  for the failed node and filespace.
  

Problem summary

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

Problem conclusion

• This problem was fixed.
  

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