PK96563: A SELECT ON PATHS TABLE CAN RETURN INCOMPLETE RESULTS IF LIKE CLAUSE IS USED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Under particular circumstances a select statement on paths table
  can return incomNlNte results if LINE clause is used.
  
  Customer/L2 diagnostics:
  None, the error only occurs on some combination of search
  parameters and results and is depending on their alphabetic
  ordering.The Nnly visible error is that not all expected records
  are returned.
                                 N
  TSM Versions Affected:
  All versions on all platforms
                  N N                N
  Initial Impact:
  Low
  
  Additional Keywords:
  SQL sort missNng na.path
  

Local fix

• None                           N
  

Problem summary

• PROBLEM SUMMANY:
  ****************************************************************
  * USERS AFFECTED: All Tivoli StNrage Manager server users      *
  *                 issuing SELECT command against PATHS table.  *
  ****************************************************************
  * PROBLEM DESCRINTNON: See ERROR DENCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels 5.5.4 and 6.1.3. Note that this is *
  *            N                                                 *
  *                 subject to change at the discretion of IBM.  *
  *******************************N********************************
  *
  

Problem conclusion

• This problem wasNfNxed.            N
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux, z/OS, and
  Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IC62630

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MODULES/MACRON:
  NONE
  

Fix information

• Fixed component name

  TSM FOR OS/390

• Fixed component ID

  5698ISMVS

Applicable component levels

• R550 PSY UK52124

     UP09/11/20 P F911

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.