IBM Support

IZ15905: Load/import/export utilities generating lots of warnings may perform excessively slow

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the Load utility generates lots of warnings (for example if
the data being parsed is full of errors, truncations, or
rejected records), the utility may perform very poorly.  This is
because the Load utility opens its internal server-side message
file using the O_SYNC flag which means writes to this internal
server-side message file will block until all message data and
file meta-data is written to disk. Since this data is not
critical to the operation of the utility or management of the
database, we will avoid opening the server-side message file
using this O_SYNC flag.

Local fix

  • You can specify the Load NOROWWARNINGS modifier to force the
Load utility to avoid writing warning messages all together.

Problem summary

  • Please see above.

Problem conclusion

  • First fixed in DB2 UDB 8.1 FixPak 17

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IZ15905
    • 

  • Reported component name
    DB2 UDB ESE AIX
    • 

  • Reported component ID
    5765F4100
    • 

  • Reported release
    810
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2008-02-19
    • 

  • Closed date
    2008-09-22
    • 

  • Last modified date
    2008-09-22
    • 





    

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

    
LI73145
    

    • 

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

    • 



Fix information


    

  • Fixed component name
    DB2 UDB ESE AIX
    • 

  • Fixed component ID
    5765F4100
    • 



Applicable component levels


    

  • R820  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            22 September 2008
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback