KFAA31555-E


      
         The archivable multi-chunk table could not be changed to a regular multi-chunk table because an error occurred in the ALTER TABLE statement. <SQLSTATE: 42IBF>

         
            
               aa....aa: Cause of the error

               
                  
                     
                        the table has an archived chunk

                        The archivable multi-chunk table that contains an archived chunk is specified in the ALTER TABLE statement.

                     

                     
                        the table is not an archivable multi-chunk table

                        A table that is not an archivable multi-chunk table is specified in the ALTER TABLE statement.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  
                     
                        If aa....aa is the table has an archived chunk

                        Execute the adbunarchivechunk command to release the chunk from the archived state. Then, execute the ALTER TABLE statement.

                        Note that if there is a deletion-pending chunk in the archived state, delete the target chunk by using the PURGE CHUNK statement, and then execute the ALTER TABLE statement.

                     

                     
                        If aa....aa is the table is not an archivable multi-chunk table

                        Confirm that the table name specified in the ALTER TABLE statement is correct.