IC40142: SELECT COMMAND INCLUDING THE ESCAPE SEQUENCE % AND SOME SPECIFIC ASCCI CHARACTERS, GENERATES A WRONG MESSAGE IN THE WEB ADMIN INT

APAR status

• Closed as program error.

Error description

• Trying to execute, from the Web Admin Interface (Show Command
  option), a Select command that includes the escape sequence %
  and some ASCII character cause that the TSM Server generates a
  wrong message about invalid characters. For example, the select
  statement:
  .
     select * from nodes where node_name like '%F%'"
  .
  generates on the browser the following answer from the TSM
  Server:
  .
     ANR2912E Invalid character string literal token - '￐'.
  
                                               |
  
      .........................................V..
     select * from nodes where node_name like '￐'
  .
  The problem occurs with any browser.
  .
  Initial Impact:
  Low
  

Local fix

• Use the Administrative Command Line to issue the Select command.
  .
  Recommendation:
  Apply the fixpack (PTF) when ready.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the command line interface in   *
  *                 the Server Web Admin Client, when            *
  *                 issuing certain selects.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing a select containing a      *
  *                      "like" clause of the form "like '%X'"   *
  *                      where X is one of a range of ASCII      *
  *                      characters, the server returned an      *
  *                      incorrect result.                       *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 5.2.3. Note that this is subject    *
  *                 to change at the discretion of IBM.          *
  ****************************************************************
  When issuing a select containing a "like" clause of the form
  "like '%X'" where X is one of a range of ASCII characters, the
  server returned an incorrect result.
  

Problem conclusion

• The code has been changed to output a correct response to the
  query.
  

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:

  PQ87511

Fix information

Applicable component levels

• R52A PSY

     UP

• R52H PSY

     UP

• R52L PSY

     UP

• R52P PSY

     UP

• R52S PSY

     UP

• R52W PSY

     UP