IBM Support

IZ83491: ERROR FOR BATCH ELEMENT #2: DB2 SQL ERROR: SQLCODE: -803, SQLSTATE: 23505, SQLERRMC: 1;TLMHW.IPX_ADDR]]></LOGTEXT>

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Errors during full Hardware scan:
<LogText><![CDATA[Error for batch element #2: DB2 SQL error:
SQLCODE: -803, SQLSTATE: 23505, SQLERRMC:
1;TLMHW.IPX_ADDR]]></LogText>

Opening APAR per agreement with Darek

Local fix

  • 



Problem summary


    

  • During uploading full hardware scan results in some cases agents
were sending many records with the same IPX address which was
failing besause of DB constraints. The logic was changed to put
only one such row to the DB. This issue was causing uploading of
full HW scan results to fail.

    



Problem conclusion


    

  • The fix for this APAR will be contained in the following
maintenance package:
       | interim fix | 7.2.1.1-TIV-LMT-TAD4D-IF0001

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ83491
    • 

  • Reported component name
    TIV ASSET DIS 4
    • 

  • Reported component ID
    5724T4D00
    • 

  • Reported release
    720
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-08-25
    • 

  • Closed date
    2010-08-31
    • 

  • Last modified date
    2010-08-31
    • 





    

  • 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
    TIV ASSET DIS 4
    • 

  • Fixed component ID
    5724T4D00
    • 



Applicable component levels


    

  • R721  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSHT5T","label":"Tivoli Asset Discovery for Distributed"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            31 August 2010
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback