Db2

  • 1.  Use administrative task scheduler (ATS)

    Posted Mon September 14, 2020 11:46 AM
    Hi Team,

    Just wanted to understand the importance of ATS in event monitor profile.  What if I don't use them and collect data? Will it have any performance impact on the monitoring database?  Too many changes to monitoring database (introduing systools tablespace etc) might be restricted in production databases. 

    What is the limitation for not using ATS and its impact ? Can some one explain so I can check. For now I am testing without ATS.

    ------------------------------
    Rajesh ChandraMohan
    ------------------------------

    #Db2


  • 2.  RE: Use administrative task scheduler (ATS)

    Posted Thu September 17, 2020 06:03 AM
    Hi Rajesh,

    ATS is a protection mechanism for event monitor, and is strongly recommended when possible.

    Consider this scenario: If console is down unexpectedly, event monitor would still be working on the monitored DB. In such case, ATS is a good protection to help turn off event monitor automatically, so that protects DB from unnecessary data generation and performance downgrade.

    ATS itself is a light-weight assistant for event monitor, and would not have much performance impact on DB.

    I hope it answered your question. Please let me know. thanks.

    ------------------------------
    KAI DING
    ------------------------------

    Original Message


  • 3.  RE: Use administrative task scheduler (ATS)

    IBM Champion
    Posted Fri September 18, 2020 01:25 AM
    Ahh! Thanks for the insights!

    i'd love to get some more details on the other prereqs of the RT monitoring script too.
    what does not function, if e.g. the stogroup is not created, etc.

    In my case, the customer would behead me, if I sheepishly would run this script in his production database for 5000+ users. So every change, be it so insignificant as possible, has to be approved, go through chance control and so on.
    So just implementing DMC on a admin pc and running it against prod is a no go.

    Cheers
    Roland

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------

    Original Message


  • 4.  RE: Use administrative task scheduler (ATS)

    Posted Mon September 21, 2020 08:04 AM
    Hi Roland,

    Do you mean the "DATABASE PARTITION GROUP" named "CONSOLEGROUP"?  DMC would like to use a partition group spanning all DB partitions. The purpose is to make sure the event monitor like activity event monitor would generate data for all DB partitions (on the other hand, if the activity event monitor table is created in a table space that is only on 1 partition, then only data on that partition would be generated). BTW: this configuration is not related to ATS.

    ------------------------------
    KAI DING
    ------------------------------

    Original Message


  • 5.  RE: Use administrative task scheduler (ATS)

    Posted Mon September 21, 2020 09:30 AM

                    I agree – I would like to see more control on where DMC creates it's objects. Not every Database has Automatic Storage setup properly and I certainly cannot create objects in our Production Systems without planning and notification of what is being created.

     

                                    Thank You,

     

    --------------------------------------------------------------------------------------------

    Dennis James

       Db2 Database Administrator

    Please note that the information contained in this message is intended only for the use of the person or office to whom it is addressed, and may contain privileged and confidential information protected from disclosure under the law, including the Health Insurance Portability and Accountability Act (HIPAA). All recipients are hereby notified that any inadvertent or unauthorized receipt does not waive such privilege, and that unauthorized dissemination, distribution or copying of this communication is strictly prohibited and may subject you to criminal or civil penalties.

    If you have received this communication in error, please notify the sender by replying to the message and delete the material from any computer. HMS Holdings Corp., together with its subsidiaries and affiliates hereby claim all applicable privileges related to this information. Any views expressed in this message are those of the individual sender, except where the sender specifies, and with authority, states them to be the views of the company.



    Original Message