IBM Support

IZ04618: GETTING SQL1606W WITH DB2BATCH.

Fixes are available

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL1606W The Database System Monitor output buffer is full error
message is returned by db2batch because there is insufficient
room to store a snapshot in the db2 internal output buffer.  The
buffer is allocated as a standard size of 102400 bytes and it
should be automatically increased as needed until the sufficient
size is allocated.  However, due to a bug in the code it is not
getting increased, hence the buffer full error message.

Local fix

  • Reduce the amount of information requested by lowering the value
of PERF_DETAIL option.

Problem summary

  • SQL1606W The Database System Monitor output buffer is full error
message is returned by db2batch because there is insufficient
room to store a snapshot in the db2 internal output buffer.  The
buffer is allocated as a standard size of 102400 bytes and it
should be automatically increased as needed until the sufficient
size is allocated.  However, due to a bug in the code it is not
getting increased, hence the buffer full error message.

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 1.

Temporary fix

  • Reduce the amount of information requested by lowering the value
of PERF_DETAIL option.

Comments

  • 



APAR Information




    

  • APAR number
    IZ04618
    • 

  • Reported component name
    DB2 UDB ESE SOL
    • 

  • Reported component ID
    5765F4102
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-09-11
    • 

  • Closed date
    2009-08-05
    • 

  • Last modified date
    2009-08-05
    • 





    

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

    • 

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

    
IZ04620 IZ08090 IZ18592 IZ18677
    

    • 



Fix information


    

  • Fixed component name
    DB2 UDB ESE SOL
    • 

  • Fixed component ID
    5765F4102
    • 



Applicable component levels


    

  • R950  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback