IC63474: SELECT FROM MULTIPLE TABLES RETURNING ANR2034E

APAR status

• Closed as fixed if next.

Error description

• A select joining multiple tables can return no match found when
  data should be returned.
  .
  For example:
  The 'Nodes' and 'Status' tables both contain data:
  .
  tsm: TEST>select node_name from nodes
  NODE_NAME
  ----------------------------------------------------------------
  TESTNODE
  .
  tsm: TEST>select server_name from status
  Session established with server TSM: Linux/x86_64
    Server Version 6, Release 1, Level 0.0
    Server date/time: 09/16/2009 15:44:49  Last access: 09/16/2009
   15:33:34
  SERVER_NAME
  ------------------
  TEST
  .
  A select joining both tables returns no match found instead of
  the expected data.
  .
  tsm: TEST>select server_name, node_name from status, nodes
  ANR2034E SELECT: No match found using this criteria.
  ANS8001I Return code 11.
  .
  An up-to-date list of affected tables can be reviewed within
  the following technote(# 1403575)
  .
  http://www-01.ibm.com/support/docview.wss?uid=swg21403575&
  .
  Tivoli Storage Manager Versions Affected: All 6.1.0 and 6.1.2
  servers.
  .
  Initial Impact: medium
  .
  Additional Keywords: select tsm zzTSM61 selects table tables
  multiple
  

Local fix

• Run selects against only one table at a time and then compare
  the table data outside of Tivoli Storage Manager.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This problem is projected to be fixed in a future version of
  the Tivoli Storage Manager server.  Note that this is subject
  to change at the discretion of IBM.
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux and Windows.
  

Problem conclusion

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

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP