Db2 Tools

 View Only
  • 1.  Query regarding the BTLKCONT Lock Timeouts and Deadlock report

    Posted Mar 16, 2018 05:12 AM

    Hi all,

     

    We have recently setup the CA SYSVIEW® Performance Management Option for DB2 in our shop as a replacement for a similar tool. We however, were not able to get hold of the JCL to setup these reports (in our case the BTLKCONT report). Could you please direct us to the appropriate documentation page or provide a sample JCL that we could customize for our shop.

     

    @denis.tronin@ca.com

     

    Regards,

    Nikhil Bhole

    Datavail Infotech Pvt. Ltd.



  • 2.  Re: Query regarding the BTLKCONT Lock Timeouts and Deadlock report

    Broadcom Employee
    Posted Mar 16, 2018 08:21 AM

    Hi There,

        If you review your Sysview for DB2 Datasets and fine the Source dataset.

    In there is a sample batch job named IDB2RWJ.

    Just update it with Datasets names and update the DBGIN DD to just reference the reports you want to run.

    Make sure you add DD for the report Sysout and you should be fine.

    Any further queries just let me know

    keith



  • 3.  Re: Query regarding the BTLKCONT Lock Timeouts and Deadlock report

    Posted Mar 16, 2018 08:45 AM

    Hi Keith,

     

    Thanks a ton!

     

    I have located the IDB2RWJ job and will customize according to the requirement and get back to you in case of any issues.

     

     

    Regards,

    Nikhil Bhole



  • 4.  Re: Query regarding the BTLKCONT Lock Timeouts and Deadlock report

    Posted Mar 16, 2018 10:19 AM

    Hello Keith,

     

    I tried setting up the job in our shop, however, I did not find any options to specify the time interval and the Db2 subsystem ID in the job.

     

    Could you please suggest whether I could use any document for identifying these options or any sample JCL I could refer to.

     

     

    Regards,

    Nikhil Bhole



  • 5.  Re: Query regarding the BTLKCONT Lock Timeouts and Deadlock report

    Broadcom Employee
    Posted Mar 16, 2018 10:33 AM

    Sure here is a link to the Sysview for DB2 R19 documentation on our Docops site.

    Use your CA Support Online user id and password to log in

    https://docops.ca.com/ca-sysview-db2/19/en/configuring/batch-report-writer/batch-report-filtering-examples

    if you search on batch you will find all the info you need

    This example shows a Date and Time filter for the report you can also add a DB2 SSID filter if you only want information on a selected DB2 Subsystem.                keith



  • 6.  Re: Query regarding the BTLKCONT Lock Timeouts and Deadlock report
    Best Answer

    Broadcom Employee
    Posted Mar 16, 2018 10:37 AM

    Here is a DocOps section describing how to use and customize batch processor: https://docops.ca.com/ca-sysview-db2/20/en/configuring/batch-report-writer. One of the sections includes filtering examples: https://docops.ca.com/ca-sysview-db2/20/en/configuring/batch-report-writer/batch-report-filtering-examples 

     

    I would recommend using the GLOBALS WHERE example as by this you don't need to change the BTLKCONT report. More details on its syntax can be found here: https://docops.ca.com/ca-sysview-db2/20/en/reference/iql-reference/iql-syntax/globals-statement 

    The beauty is that you can use any common IFCID field for filtering (https://docops.ca.com/ca-sysview-db2/20/en/reference/ifcid-records/common-fields), for example here is filter for Db2 subsytem DDDD and trace records produced on March 16, 2018:

      GLOBALS
      WHERE SUBSYS='DDDD' AND 
            EVENT-TIME >= '180316000000' AND

                                  <= '180316235959'

     

    Hope this helps.

     

    Kind regards,

    Denis