IBM Support

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

A fix is available

IBM Tivoli Storage Manager V6.1 Fix Pack 3 (6.1.3) Server Downloads

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Under particular circumstances a select statement on paths table
can return incomplete results if LIKE 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 only visible error is that not all expected records
are returned.

TSM Versions Affected:
All versions on all platforms

Initial Impact:
Low

Additional Keywords:
SQL sort missing na.path

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: All Tivoli Storage Manager server users      *
*                 issuing SELECT command against PATHS table.  *
****************************************************************
* PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
****************************************************************
* 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 *
*                                                              *
*                 subject to change at the discretion of IBM.  *
****************************************************************
*

    



Problem conclusion


    

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

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IC62630
    • 

  • Reported component name
    TSM SERVER
    • 

  • Reported component ID
    5698ISMSV
    • 

  • Reported release
    55A
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-08-20
    • 

  • Closed date
    2009-09-18
    • 

  • Last modified date
    2009-09-18
    • 





    

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

    • 

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

    
PK96563
    

    • 



Fix information


    

  • Fixed component name
    TSM SERVER
    • 

  • Fixed component ID
    5698ISMSV
    • 



Applicable component levels


    

  • R55A  PSY
       UP
    • 

  • R55H  PSY
       UP
    • 

  • R55L  PSY
       UP
    • 

  • R55S  PSY
       UP
    • 

  • R55W  PSY
       UP
    • 

  • R61A  PSY
       UP
    • 

  • R61H  PSY
       UP
    • 

  • R61L  PSY
       UP
    • 

  • R61S  PSY
       UP
    • 

  • R61W  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"55A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            18 September 2009
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback