DB2 - L

 View Only

  • 1.  DEADLOCK_RESOLUTION_PRIORITY and DSNT375I

    Posted Nov 22, 2022 04:35 AM
    If you are using (or planning to use) the DEADLOCK_RESOLUTION_PRIORITY global variable (requires APPLCOMPAT V13R1M501) then please consider voting for my enhancement idea, to include the info in the DSNT375I deadlock message

    https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24ZOS-I-1415

    Thanks

    ------------------------------
    AndySmithHSBC
    ------------------------------


  • 2.  RE: DEADLOCK_RESOLUTION_PRIORITY and DSNT375I

    Posted Nov 23, 2022 04:57 AM
    Edited by Dhiren Chaudhary Nov 23, 2022 05:01 AM

    Hi,

    we are just starting with V13 so have not seen this message but the a-Ha makes sense so it gets my vote.

    I have queried this feature with IBM and it was confirmed that the relative difference between 2 values is not a factor and just being higher is enough.
    so value=1 for process-A and value=2 for process-B   is the same as value=1 for process-A and value=100 for process-B in the sense that all other things being equal process-B is NOT more likely to win out in the latter case anymore than in the former case.

    anyway, a good suggestion on the message.

    Regards

    Dhiren Chaudhary



  • 3.  RE: DEADLOCK_RESOLUTION_PRIORITY and DSNT375I

    Posted Nov 23, 2022 04:59 AM
    Edited by Dhiren Chaudhary Nov 23, 2022 05:01 AM
    Chaudhary, Dhirendra (Core Solutions, Technology) would like to recall the message, "Re: DEADLOCK_RESOLUTION_PRIORITY and DSNT375I".


    National Westminster Bank plc. Registered in England No. 929027. Registered Office: 250 Bishopsgate, London EC2M 4AA. National Westminster Bank plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

    The Royal Bank of Scotland plc. Registered in Scotland No. 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

    The Royal Bank of Scotland plc and National Westminster Bank plc are authorised to act as agent for each other.

    The Royal Bank of Scotland plc and National Westminster Bank plc are UK chartered banks and are not chartered or licensed as banks by the United States or any individual state.

    This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, National Westminster Bank plc or any affiliated entity (“NatWest” or “us”) does not accept responsibility for changes made to this message after it was sent. NatWest may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by NatWest in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


    Original Message


  • 4.  RE: DEADLOCK_RESOLUTION_PRIORITY and DSNT375I

    Posted Nov 23, 2022 07:26 AM
    Done :)

    Steve

    ------------------------------
    Steven Lamb
    ------------------------------

    Original Message