KFAA31737-E


      
         The size of the area required to store a row exceeds the capacity of one segment. Therefore, the CREATE TABLE or ALTER TABLE statement can be executed. <SQLSTATE:52021>

         
            
               aa....aa: Size of the area required to store a row (unit: byte)

               
                  If the size of the area required to store a row cannot be output, *** is displayed.

               

            
            
               bb....bb: Capacity of one segment (unit: byte)

               
                  If the capacity of one segment cannot be output, *** is displayed.

               

            
            
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               

            
            
               Action:

               
                  Take one of the following corrective actions:

                  
                     
                        If this message is output during execution of a CREATE TABLE statement

                        Make sure to meet the condition expression of the capacity of
                           one segment explained in IN DB-area-name
                           [Common] in Explanation of specification format
                           in Specification format and rules for the CREATE TABLE
                           statement in the manual HADB SQL Reference. To
                           satisfy the condition expression, one or more of the following actions
                           must be taken.

                        
                           
                              Decrease the specified value of the data length of the element data type of an array-type column.

                           

                           
                              Decrease the specified value of the maximum number of elements in an array-type column.

                           

                           
                              Reduce the specified value of data length for non-array-type columns.

                           

                        

                        If the above actions are not possible, increase the capacity of one segment of the data DB area.

                     

                     
                        If this message is output during execution of a ALTER TABLE statement

                        Make sure to meet the condition expression of the capacity of one segment explained in Rules in Specification format and rules for the ALTER TABLE statement in the manual HADB SQL Reference. To satisfy the condition expression, one of the following actions is required.

                        
                           
                              If this message is output when a column was added

                              The specified value for the data length of the additional column is too large. Reduce the specified value for the data length of the additional column.

                              Note that when adding an array-type column, the specified value of data length of element data type is too large or the specified value of maximum number of elements is too large. Make at least one of the specified values smaller.

                           

                        

                        
                           
                              If this message is output when the data type of a column was changed

                              The specified value of the data length of the changed data type is too large for the column whose data type was changed. Reduce the specified value of the data length of the changed data type.

                           

                        

                        
                           
                              If this message is output when the maximum number of elements in an array-type column is increased

                              The specified value for the maximum number of elements after the change is too large. Reduce the specified value for the maximum number of elements after the change.

                           

                        

                        If the above actions are not possible, increase the capacity of one segment of the data DB area.

                     

                  

                  For details about the appropriate value for the capacity of one segment of the data DB area, see Points to consider when determining the capacity of one segment in data DB areas in the HADB Setup and Operation Guide.

                  Note that to increase the capacity of one segment of the data DB area, the data DB area must be deleted once using the adbmodarea command and then recreated. For how to recreate a data DB area, see Steps to take when a data DB area can no longer be expanded in the HADB Setup and Operation Guide.