Result set 1
  --------------

  TEXT                                                                            
  --------------------------------------------------------------------------------
  -------------------------------------------------------------------------------- 
  Monitoring report - current lock waits                                           
  -------------------------------------------------------------------------------- 
  Database:               SAMPLE                                                   
  Generated:              10/13/2009 18:19:33                                      
                                                                                   
  ================================================================================ 
  Part 1 - Summary of current lock waits                                           
                                                                                   
  -------------------------------------------------------------------------------- 
                                                                                   
        REQ_APPLICATION  LOCK_MODE  HLD_APPLICATION  LOCK_  LOCK_OBJECT_TYPE       
  #     HANDLE           REQUESTED  _HANDLE          MODE                          
  ----  ---------------  ---------  ---------------  -----  ---------------------- 
  1     4703             U          4702             U      ROW                    
  2     4701             U          4702             U      ROW                    
  3     4714             U          4702             U      ROW                    
  4     4704             U          4702             U      ROW                    
                                                                                   
  ================================================================================ 
  Part 2 - Details for each current lock wait                                      
                                                                                   
  lock wait #:1                                                                    
  -------------------------------------------------------------------------------- 
                                                                                   
  -- Lock details --                                                               
                                                                                   
  LOCK_NAME            = 04000500040000000000000052                                
  LOCK_WAIT_START_TIME = 2009-10-13-18.19.33.319505                                
  LOCK_OBJECT_TYPE     = ROW                                                       
  TABSCHEMA            = ADMINISTRATOR                                             
  TABNAME              = INVENTORY                                                 
  ROWID                = 4                                                         
  LOCK_STATUS          = W                                                         
  LOCK_ATTRIBUTES      = 0000000000000000                                          
  ESCALATION           = N                                                         
                                                                                   
  -- Requestor and holder application details --                                   
                                                                                   
  Attributes           Requestor                      Holder                       
  -------------------  -----------------------------  ---------------------------- 
  APPLICATION_HANDLE   4703                           4702                         
  APPLICATION_ID       *LOCAL.DB2.091013124917        *LOCAL.DB2.091013124916      
  APPLICATION_NAME     java.exe                       java.exe                     
  SESSION_AUTHID       ADMINISTRATOR                  ADMINISTRATOR                
  MEMBER               0                              0                            
  LOCK_MODE            -                              U                            
  LOCK_MODE_REQUESTED  U                              -                            
                                                                                   
  -- Lock holder current agents --                                                 
                                                                                   
  AGENT_TID            = 368                                                       
  REQUEST_TYPE         = FETCH                                                     
  EVENT_STATE          = IDLE                                                      
  EVENT_OBJECT         = REQUEST                                                   
  EVENT_TYPE           = WAIT                                                      
  ACTIVITY_ID          =                                                           
  UOW_ID               =                                                           
                                                                                   
  -- Lock holder current activities --                                             
                                                                                   
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 6                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.30.222273                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = IDLE                                                      
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  -- Lock requestor waiting agent and activity --                                  
                                                                                   
  AGENT_TID            = 8476                                                      
  REQUEST_TYPE         = FETCH                                                     
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 6                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.33.230727                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = EXECUTING                                                 
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  lock wait #:2                                                                    
  -------------------------------------------------------------------------------- 
                                                                                   
  -- Lock details --                                                               
                                                                                   
  LOCK_NAME            = 04000500040000000000000052                                
  LOCK_WAIT_START_TIME = 2009-10-13-18.19.32.315140                                
  LOCK_OBJECT_TYPE     = ROW                                                       
  TABSCHEMA            = ADMINISTRATOR                                             
  TABNAME              = INVENTORY                                                 
  ROWID                = 4                                                         
  LOCK_STATUS          = W                                                         
  LOCK_ATTRIBUTES      = 0000000000000000                                          
  ESCALATION           = N                                                         
                                                                                   
  -- Requestor and holder application details --                                   
                                                                                   
  Attributes           Requestor                      Holder                       
  -------------------  -----------------------------  ---------------------------- 
  APPLICATION_HANDLE   4701                           4702                         
  APPLICATION_ID       *LOCAL.DB2.091013124911        *LOCAL.DB2.091013124916      
  APPLICATION_NAME     java.exe                       java.exe                     
  SESSION_AUTHID       ADMINISTRATOR                  ADMINISTRATOR                
  MEMBER               0                              0                            
  LOCK_MODE            -                              U                            
  LOCK_MODE_REQUESTED  U                              -                            
                                                                                   
  -- Lock holder current agents --                                                 
                                                                                   
  AGENT_TID            = 368                                                       
  REQUEST_TYPE         = FETCH                                                     
  EVENT_STATE          = IDLE                                                      
  EVENT_OBJECT         = REQUEST                                                   
  EVENT_TYPE           = WAIT                                                      
  ACTIVITY_ID          =                                                           
  UOW_ID               =                                                           
                                                                                   
  -- Lock holder current activities --                                             
                                                                                   
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 6                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.30.222273                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = IDLE                                                      
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  -- Lock requestor waiting agent and activity --                                  
                                                                                   
  AGENT_TID            = 8032                                                      
  REQUEST_TYPE         = FETCH                                                     
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 11                                                        
  LOCAL_START_TIME     = 2009-10-13-18.19.32.225902                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = EXECUTING                                                 
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  lock wait #:3                                                                    
  -------------------------------------------------------------------------------- 
                                                                                   
  -- Lock details --                                                               
                                                                                 
  LOCK_NAME            = 04000500040000000000000052                                
  LOCK_WAIT_START_TIME = 2009-10-13-18.19.33.211233                                
  LOCK_OBJECT_TYPE     = ROW                                                       
  TABSCHEMA            = ADMINISTRATOR                                             
  TABNAME              = INVENTORY                                                 
  ROWID                = 4                                                         
  LOCK_STATUS          = W                                                         
  LOCK_ATTRIBUTES      = 0000000000000000                                          
  ESCALATION           = N                                                         
                                                                                   
  -- Requestor and holder application details --                                   
                                                                                   
  Attributes           Requestor                      Holder                       
  -------------------  -----------------------------  ---------------------------- 
  APPLICATION_HANDLE   4714                           4702                         
  APPLICATION_ID       *LOCAL.DB2.091013124940        *LOCAL.DB2.091013124916      
  APPLICATION_NAME     java.exe                       java.exe                     
  SESSION_AUTHID       ADMINISTRATOR                  ADMINISTRATOR                
  MEMBER               0                              0                            
  LOCK_MODE            -                              U                            
  LOCK_MODE_REQUESTED  U                              -                            
                                                                                   
  -- Lock holder current agents --                                                 
                                                                                   
  AGENT_TID            = 368                                                       
  REQUEST_TYPE         = FETCH                                                     
  EVENT_STATE          = IDLE                                                      
  EVENT_OBJECT         = REQUEST                                                   
  EVENT_TYPE           = WAIT                                                      
  ACTIVITY_ID          =                                                           
  UOW_ID               =                                                           
                                                                                   
  -- Lock holder current activities --                                             
                                                                                   
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 6                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.30.222273                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = IDLE                                                      
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  -- Lock requestor waiting agent and activity --                                  
                                                                                   
  AGENT_TID            = 4476                                                      
  REQUEST_TYPE         = FETCH                                                     
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 1                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.33.122315                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = EXECUTING                                                 
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  lock wait #:4                                                                    
  -------------------------------------------------------------------------------- 
                                                                                   
  -- Lock details --                                                               
                                                                                   
  LOCK_NAME            = 04000500040000000000000052                                
  LOCK_WAIT_START_TIME = 2009-10-13-18.19.31.310790                                
  LOCK_OBJECT_TYPE     = ROW                                                       
  TABSCHEMA            = ADMINISTRATOR                                             
  TABNAME              = INVENTORY                                                 
  ROWID                = 4                                                         
  LOCK_STATUS          = W                                                         
  LOCK_ATTRIBUTES      = 0000000000000000                                          
  ESCALATION           = N                                                         
                                                                                   
  -- Requestor and holder application details --                                   
                                                                                   
  Attributes           Requestor                      Holder                       
  -------------------  -----------------------------  ---------------------------- 
  APPLICATION_HANDLE   4704                           4702                         
  APPLICATION_ID       *LOCAL.DB2.091013124927        *LOCAL.DB2.091013124916      
  APPLICATION_NAME     java.exe                       java.exe                     
  SESSION_AUTHID       ADMINISTRATOR                  ADMINISTRATOR                
  MEMBER               0                              0                            
  LOCK_MODE            -                              U                            
  LOCK_MODE_REQUESTED  U                              -                            
                                                                                   
  -- Lock holder current agents --                                                 
                                                                                   
  AGENT_TID            = 368                                                       
  REQUEST_TYPE         = FETCH                                                     
  EVENT_STATE          = IDLE                                                      
  EVENT_OBJECT         = REQUEST                                                   
  EVENT_TYPE           = WAIT                                                      
  ACTIVITY_ID          =                                                           
  UOW_ID               =                                                           
                                                                                   
  -- Lock holder current activities --                                             
                                                                                   
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 6                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.30.222273                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = IDLE                                                      
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   
  -- Lock requestor waiting agent and activity --                                  
                                                                                   
  AGENT_TID            = 4632                                                      
  REQUEST_TYPE         = FETCH                                                     
  ACTIVITY_ID          = 1                                                         
  UOW_ID               = 2                                                         
  LOCAL_START_TIME     = 2009-10-13-18.19.31.222442                                
  ACTIVITY_TYPE        = READ_DML                                                  
  ACTIVITY_STATE       = EXECUTING                                                 
                                                                                   
  STMT_TEXT            =                                                           
  select * from inventory for update                                               
                                                                                   

  266 record(s) selected.

  Return Status = 0