IC76823: EXPLICIT SPECIFICATION OF THE TABLE NAME IN 6.X SELECT STATEMENT MAY CAUSE ERRORS OR UNEXPECTED RESULTS.

APAR status

• Closed as program error.

Error description

• Explicitly specifying some table names for a column in a SELECT
  statement might result in errors or unexpected results.  Several
  table names including the following are maintained for backward
  compatibility in the SELECT command, however, the table name in
  the FROM clause of the SELECT statement will be changed
  internally:
  FILESPACES
  LICENSES
  NODES
  SERVER_GROUP
  ACTIVITY_SUMMARY
  PROFILES
  SUBSCRIPTIONS
  DOMAINS
  VFSMAPPINGS
  LICENSE_DETAILS
  For these tables, if a column name must be qualified by the
  table name then the use of a table name alias that is different
  from the actual table name must be used.  The following example
  will fail in V6 but worked in V5:
  SELECT OCCUPANCY.NODE_NAME, NODES.TCP_NAME, NODES.TCP_ADDRESS,
  OCCUPANCY.TYPE, OCCUPANCY.FILESPACE_NAME,
  OCCUPANCY.STGPOOL_NAME, OCCUPANCY.NUM_FILES,
  OCCUPANCY.PHYSICAL_MB, OCCUPANCY.LOGICAL_MB,
  OCCUPANCY.FILESPACE_ID FROM NODES, OCCUPANCY WHERE
  NODES.NODE_NAME = OCCUPANCY.NODE_NAME
  The following message is received from the above command:
  ANR0162W Supplemental database diagnostic information:
  -1:42S22:-206
  ([IBM][CLI Driver][DB2/AIX64] SQL0206N  "NODES.NODE_NAME" is not
  valid in the
  context where it is used.  SQLSTATE=42703).
  The restriction of having to use the real table name or an alias
  needs to be lifted so that these selects that work in V5 work in
  V6.
  Tivoli Storage Manager Versions Affected: 6.1, 6.2
  Initial Impact: Low
  Additional Keywords:
  TSM SQL
  

Local fix

• Change the actual table name to a table name alias and the
  command will work.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users      *
  *                 who use SELECT commands.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.2.4 . 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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP