IC62253: A SELECT AGAINST THE TSM EVENTS TABLE MAY FAIL WITH 'ANS8001I RETURN CODE 4' AND REPORTS ANR0102E IN THE ACTLOG

IBM Tivoli Storage Manager V6.1 Fix Pack 3 (6.1.3) Server Downloads

APAR status

• Closed as program error.

Error description

• A SELECT command against the TSM events table can fail with
  'ANS8001I Return code 4' while a QUERY EVENTS command does
  return some valid results.
  In case the SELECT command fails, a ANR0102E message can be seen
  in the activity log of the TSM Server.
  .
  The problem results from having at least one event which is no
  longer associated with a client node - most likely as the node
  was deleted - causing the NODE_NAME of that particular event
  record to be of length 0 (zero).
  It can happen that after some time this SELECT command is
  working again when the particular event record has been deleted
  as the Event Record Retention Period has been exceeded.
  .
  .
  Customer/L2 Diagnostics:
  SELECT command:
  ===============
  tsm: TEST>select * from events
  ANS8001I Return code 4.
  .
  ACTLOG:
  =======
  09.07.2009 21:12:00      ANR2017I Administrator ADMIN issued
  command: select * from events (SESSION: 1234)
  09.07.2009 21:12:01      ANR0102E admsql.c(5023): Error 1
  inserting row in table "EVENTS.SQL". (SESSION: 1234)
  .
  A  TSM Server trace file traceflags ADM DB DBEXEC SQL shows at
  least one node name with a length of 0 (zero) with is still
  associated with an event, e.g.
  [...]
  21:12:01.164
  [6117][tbtbl.c][1148][tbGetColNameFromRow]:Returning columnName
  NODE_NAME from table table EVENTS.SQL for column 2.
  21:12:01.164
  [6116][tbcli.c][4917][RdbFetchAndGetNextResponse]:EXIT with rc
  0.
  21:12:01.164 [6117][tbtbl.c][1166][tbGetColNameFromRow]:Exit
  with rc 0.
  21:12:01.164 [6116][tbcli.c][1548][tbCliMRFetch]:RC 0 after
  fetch.
  21:12:01.164 [6117][admsql.c][4359][TsmSqlPrepareData]:Col 2,
  name NODE_NAME, type ADMITEM_STRING(1).
  21:12:01.164 [6116][dbitxn.c][979][DbiParticipate]:txnDesc
  0x1915d48 already participating in tid 0:172890.
  21:12:01.164 [6117][admsql.c][4401][TsmSqlPrepareData]:Col 2,
  string "", len 0.
  [...]
  21:12:01.367 [6117][dbieval.c][553][DbiEvalSQLOutcomeX]:SQLSTATE
  23505, SQLCODE -803, SQLMsg=[IBM][CLI Driver][DB2/LINUXX8664]
  SQL0803N  One or more values in the INSERT statement, UPDATE
  statement, or foreign key update caused by a DELETE statement
  are not valid because the primary key, unique constraint or
  unique index identified by "1" constrains table
  "TSMDB1.EVENTS_SQL" from having duplicate values for the index
  key.  SQLSTATE=23505
  .
  .
  TSM Versions Affected:
  TSM Server 6.1
  .
  .
  Initial Impact:
  Medium
  .
  .
  Additional Keywords:
  zz61 RC4 duplicates keys eventrecord
  

Local fix

• Use the QUERY EVENTS command (maybe with options
  BEGINDATE/BEGINTIME and ENDDATE/ENDTIME)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 the Administrative Client.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description                   *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.1.4. 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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP