IBM Support

IZ92347: GETTING ERROR- COM.IBM.DB2.JCC.B.SQLEXCEPTION: ERROR FOR BATC ELEMENT #4: DB2 SQL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • error showing in tool-

  com.ibm.db2.jcc.b.SqlException: Error for batch element #4:
DB2 SQL
error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null issue)"

Local fix

  • there is no local fix

Problem summary

  • During full hardware scan upload in TAD4D it may happen than
some attributes are longer than the corresponding fields in
database. In this case truncation was not done which resulted in
SQL exceptions. This has no impact on other server
functionalities.

Problem conclusion

  • The fix for this issue will be contained in the following
deliverable:
     | Fix Pack | 7.2.2-TIV-ILMT-TAD4D-FP0001

Temporary fix

  • No temporary fix is available. The only possibility to
workaround this issue is to disable full hardware scan feature.

Comments

  • 



APAR Information




    

  • APAR number
    IZ92347
    • 

  • Reported component name
    TIV ASSET DIS 4
    • 

  • Reported component ID
    5724T4D00
    • 

  • Reported release
    721
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2011-01-17
    • 

  • Closed date
    2011-01-25
    • 

  • Last modified date
    2011-01-25
    • 





    

  • 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


    

  • R722  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":"721","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            25 January 2011
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback