SQL-904 REASON 00C90084 resource 4K for Merge/Modify

Document ID : KB000023046
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

CA Merge/Modify job fails during processing with the following errors:

PMM0200E - AN SQL ERROR HAS OCCURRED                                  
           This Error has Occurred in CSECT - MMA@SEL              

and

                                                                      
 DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN 
          UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE     
          00000230, AND RESOURCE NAME 4K                              
 DSNT418I SQLSTATE   = 57011 SQLSTATE RETURN CODE                     
 DSNT415I SQLERRP    = DSNXRSOR SQL PROCEDURE DETECTING ERROR         
 DSNT416I SQLERRD    = -115  13172746  0  13231826  -959250432  0 SQL 
          DIAGNOSTIC INFORMATION                                      
 DSNT416I SQLERRD    = X'FFFFFF8D'  X'00C9000A'  X'00000000'          
          X'00C9E6D2'  X'C6D30000'  X'00000000' SQL DIAGNOSTIC        
          INFORMATION                                                 
                                                                      
PMM0682E - Unexpected return code 00000008 from module MMA@SEL.

Which resource is effected during this CA Merge/Modify process?

Resolution:

According to the SQLCODE = -904 ERROR this indicates that there is a space problem with the work file tablespaces allocated with 4 KB page sizes.

 
REASON 00C90084                                                          
TYPE 00000230                                                            
NAME 4K                                                                   
  

Work file database storage requirements vary depending on application use.

 

Additional Information:

Please review "The DB2 Admin Guide" section: Creating additional work file table spaces.