KFAA30955-E


      
         Processing of the SQL statement or command was canceled and the transaction was rolled back. <SQLSTATE: 5B002>

         When a transaction is forced to terminate using the adbcancel command, the application program is disconnected from the HADB server. Check in the SQL results information whether the application program has been disconnected from the HADB server, and then check whether a KFAA70001-I message was output immediately afterwards.

         
            
               aa....aa:

               
                  Troubleshooting information 1

               

            
            
               bb....bb:

               
                  Troubleshooting information 2

               

            
            
               S:

               
                  Ignores this SQL statement.

               

            
            
               Action:

               
                  Carefully review the SQL statement, and then re-execute it.

                  This message is also displayed if processing of the command timed out. In such a case, take one of the following corrective actions:

                  
                     
                        Increase the timeout period of the command.

                        Increase the value specified for the --timeout option, and then re-execute the command.

                     

                     
                        Stop the SQL statement or command that places the command in wait status.

                        Release the command from the wait status.

                        
                           
                              ■ adbreorgsystemdata command

                              
                                 For details about how to stop the SQL statement or command that
                                    caused the wait status, see Reorganization of dictionary tables and system tables, and
                                    lock control in the HADB Setup and Operation
                                    Guide. Then, re-execute the adbreorgsystemdata command.

                              

                           
                        

                        
                           
                              ■ Other than adbreorgsystemdata command

                              
                                 The following steps should be taken to suspend the SQL statement or command that is causing the wait status. Once this is done, re-execute the timed-out command.

                                 
                                    
                                       Check the locked resource allocated by the command that timed out.

                                       For details about the locked resources that the command reserves, see Locked resources that are reserved and their lock modes in the HADB Setup and Operation Guide.

                                    

                                    
                                       Use the adbls -d lock command to confirm the connection ID that secures the locked resource confirmed in Step 1.

                                       If there is no corresponding connection ID, please re-execute the timed-out command.

                                    

                                    
                                       Use the adbcancel command to terminate the connection ID that you confirmed in Step 2.