Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Locks 1hr

    Uploaded by

    saandeepd
    The document contains a series of event logs documenting lock timeout events occurring between Participant No 1 and Participant No 2 while accessing the ORDERS table in the DB2INST1 schema. Participant No 1 repeatedly requests and is denied a lock on the table due to lock timeouts at regular intervals from 2020-07-28-05.24.14 to 2020-07-28-05.33.36. The activities of Participant No 2 are not provided.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Locks 1hr

    Uploaded by

    saandeepd
    32 views10 pages
    The document contains a series of event logs documenting lock timeout events occurring between Participant No 1 and Participant No 2 while accessing the ORDERS table in the DB2INST1 schema. Participant No 1 repeatedly requests and is denied a lock on the table due to lock timeouts at regular intervals from 2020-07-28-05.24.14 to 2020-07-28-05.33.36. The activities of Participant No 2 are not provided.

    Original Title

    locks_1hr

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a series of event logs documenting lock timeout events occurring between Participant No 1 and Participant No 2 while accessing the ORDERS table in the DB2INST1 schema. Participant No 1 repeatedly requests and is denied a lock on the table due to lock timeouts at regular intervals from 2020-07-28-05.24.14 to 2020-07-28-05.33.36. The activities of Participant No 2 are not provided.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    32 views10 pages

    Locks 1hr

    Uploaded by

    saandeepd
    The document contains a series of event logs documenting lock timeout events occurring between Participant No 1 and Participant No 2 while accessing the ORDERS table in the DB2INST1 schema. Participant No 1 repeatedly requests and is denied a lock on the table due to lock timeouts at regular intervals from 2020-07-28-05.24.14 to 2020-07-28-05.33.36. The activities of Participant No 2 are not provided.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 10

    Event ID : 5278

    Event Type : LOCKTIMEOUT


    Event Timestamp : 2020-07-28-05.24.14.121252
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5279
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.25.00.035250
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5280
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.25.35.449246
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5281
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.26.36.935257
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5282
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.27.07.980263
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5283
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.28.15.045249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5284
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.29.00.199248
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5285
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.29.22.999249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5286
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.30.08.070248
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5287
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.32.51.233247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5288
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.33.36.311248
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5289
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.34.54.453249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5290
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.36.23.635249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5291
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.37.08.713249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5292
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.42.29.553247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5293
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.43.14.629247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5294
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.48.25.622251
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5295
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.53.37.171249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERITEMS
    Current Activities of Participant No 1
    Stmt text : DELETE FROM ORDERS WHERE ((ORDERS_ID = ?) AND (OPTCOUNTER
    = ?))
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5296
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.54.08.757246
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : SUBORDERS
    Current Activities of Participant No 1
    Stmt text : DELETE FROM ORDERS WHERE ((ORDERS_ID = ?) AND (OPTCOUNTER
    = ?))
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5297
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.54.23.015249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5298
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.55.47.533247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5299
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.56.32.614249
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5300
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.57.53.606247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5301
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.58.38.685251
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5302
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.58.50.843247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : SUBORDERS
    Current Activities of Participant No 1
    Stmt text : DELETE FROM ORDERS WHERE ((ORDERS_ID = ?) AND (OPTCOUNTER
    = ?))
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5303
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-05.59.46.129250
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5304
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-06.00.31.210250
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5305
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-06.03.50.217250
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5306
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-06.03.50.349247
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2
    Event ID : 5307
    Event Type : LOCKTIMEOUT
    Event Timestamp : 2020-07-28-06.07.07.999248
    Participant No 1 requesting lock
    Table Schema : DB2INST1
    Table Name : ORDERS
    Current Activities of Participant No 1
    Stmt text : SELECT T1.ORDERS_ID, T1.ORMORDER, T1.ORGENTITY_ID,
    T1.TOTALPRODUCT, T1.TOTALTAX, T1.TOTALSHIPPING, T1.TOTALTAXSHIPPING,
    T1.DESCRIPTION, T1.STOREENT_ID, T1.CURRENCY, T1.LOCKED, T1.TIMEPLACED,
    T1.LASTUPDATE, T1.SEQUENCE, T1.STATUS, T1.MEMBER_ID, T1.FIELD1, T1.ADDRESS_ID,
    T1.FIELD2, T1.PROVIDERORDERNUM, T1.SHIPASCOMPLETE, T1.FIELD3, T1.TOTALADJUSTMENT,
    T1.ORDCHNLTYP_ID, T1.COMMENTS, T1.NOTIFICATIONID, T1.TYPE, T1.EDITOR_ID,
    T1.OPTCOUNTER, T1.SOURCEID, T1.EXPIREDATE, T1.BUSCHN_ID, T1.BLOCKED,
    T1.TRANSFERSTATUS, T1.OPSYSTEM_ID, T1.BUYERPO_ID FROM ORDERS T1 WHERE T1.ORDERS_ID
    = ? FOR UPDATE WITH RS
    Past Activities of Participant No 1
    Current Activities of Participant No 2
    Past Activities of Participant No 2

    You might also like