IC77246: INCORRECT SQL PARSING FOR SELECT STATEMENT.

APAR status

• Closed as program error.

Error description

• When an administrator queries the Tivoli Storage Manager
  database using the SELECT statement in an administrative
  console, it will return no match if the search entries have the
  date/time stamp format substring, such as 2AMXXXX, 10PMXXXX,
  YYYY-MM-DD, etc. For example,
  tsm: HERACLES>select node_name from nodes
  NODE_NAME
  ------------------
  2AM_INCR
  tsm: HERACLES>select node_name from nodes where
  node_name='2AM_INCR'
  ANR2034E SELECT: No match found using this criteria.
  ANS8001I Return code 11.
  In this case, the  2AM  substring is in the time format, which
  caused the command to fail.
  However, if the SELECT statement is run from a db2 console, the
  problem will not occur:
  db2 => select node_name from NODESVIEW where node_name =
  '2AM_INCR'
  NODE_NAME
  ----------------------------------------------------------------
  2AM_INCR
    1 record(s) selected.
  

Local fix

• 1. Rename the entries so that they do not contain the date/time
  format.
  Or,
  2. Issue the SELECT statement from a db2 console.
  

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 and 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, Sun 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