IBM Support

LI72063: CRASH REOCVERY HANG WITH DB2DIAG MESSAGE SQLP_NOSPACE FROM SQLPGWRITETODISK, PROBE:1010 IN DB2DIAG.LOG

Fixes are available

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3   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 3a 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

  • crash reocvery hang with db2diag message SQLP_NOSPACE from
sqlpgWriteToDisk, probe:1010 in db2diag.log
crash recovery hang wih the following message in db2diag.log:
2007-02-07-23.28.58.319963-300 I31039497E398 LEVEL: Severe PID :
16688 TID : 183030385024PROC : db2loggw (dbname) 1 INSTANCE:
userid NODE : 001 FUNCTION: DB2 UDB, data protection services,
sqlpgWriteToDisk, probe:1010 RETCODE :
ZRC=0x85100009=-2062548983=SQLP_NOSPACE "Log File has reached
its saturation point" DIA8309C Log file was full.

Local fix

  • 



Problem summary


    

  • CRASH REOCVERY HANG WITH DB2DIAG MESSAGE SQLP_NOSPACE FROM
SQLPGWRITETODISK, PROBE:1010 IN DB2DIAG.LOG

    



Problem conclusion


    

  • crash reocvery hang with db2diag message SQLP_NOSPACE from
sqlpgWriteToDisk, probe:1010 in db2diag.log
crash recovery hang wih the following message in db2diag.log:
2007-02-07-23.28.58.319963-300 I31039497E398 LEVEL: Severe PID :
16688 TID : 183030385024PROC : db2loggw (dbname) 1 INSTANCE:
userid NODE : 001 FUNCTION: DB2 UDB, data protection services,
sqlpgWriteToDisk, probe:1010 RETCODE :
ZRC=0x85100009=-2062548983=SQLP_NOSPACE "Log File has reached
its saturation point" DIA8309C Log file was full.

    



Temporary fix


    

  • NOne

APAR first fixed in DB2 V9.1 FP 3

    



Comments


    

  • 



APAR Information




    

  • APAR number
    LI72063
    • 

  • Reported component name
    DB2 UDE ESE LIN
    • 

  • Reported component ID
    5765F4104
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-02-21
    • 

  • Closed date
    2009-09-24
    • 

  • Last modified date
    2009-09-24
    • 





    

  • 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
    DB2 UDE ESE LIN
    • 

  • Fixed component ID
    5765F4104
    • 



Applicable component levels


    

  • R910  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:
            

            08 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback