Db2 Tools

 View Only
  • 1.  Simplify Db2 Subsystem Management with Thread Termination/Dynamic DSNZPARM

    Broadcom Employee
    Posted May 08, 2019 10:32 AM

    Thread Termination/Dynamic DSNZPARM is a powerful tool for managing your Db2 subsystems. Are you using it in your shop? If not, consider the following:

     

    • View and terminate threads. You can view and terminate threads without affecting other transactions. Threads can be terminated on demand, or automatically based on criteria that you specify. You can also free locked tables and page sets, which is useful for ensuring that a utility or batch job can execute.
    • Add active logs and manage exit routines. Manage your active log data sets and exit routines dynamically, without scheduling DB2 downtime.
    • View and change Db2 parameters. You can view and alter most Db2 parameters and attributes on demand. You can also schedule parameter changes to occur automatically. Scheduling these updates lets you customize a subsystem for different workloads at different times of day.
    • Keep a log with detailed information about each request. Easily determine who canceled a thread and how it was canceled. You can also see who requested a Db2 change and whether it was successful.

     

    Ready to learn more? See Using Thread Termination\Dynamic DSNZPARM. Start simplifying your life today!



  • 2.  RE: Simplify Db2 Subsystem Management with Thread Termination/Dynamic DSNZPARM

    Posted Aug 22, 2019 03:24 AM

    Hi Lucinda.

    I tried to use the Link you provided.

    Unfortunately it results in http 404.

    Do you have another one?
    regards michael



    ------------------------------
    [DBA and SYSPROG]
    [LVM Versicherung]
    [Germany]
    ------------------------------



  • 3.  RE: Simplify Db2 Subsystem Management with Thread Termination/Dynamic DSNZPARM

    Broadcom Employee
    Posted Aug 22, 2019 09:08 AM
    Hi Michael,

    Hmm, it looks like that link broke when we moved our documentation to the new techdocs.broadcom.com platform. Try using this link instead:

    http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/database-management/ca-database-management-solutions-for-db2-for-z-os/20/using/use-thread-termination-dynamic-dsnzparm.html

    Regards,
    Lucinda

    ------------------------------
    Staff Technical Writer
    Broadcom
    ------------------------------



  • 4.  RE: Simplify Db2 Subsystem Management with Thread Termination/Dynamic DSNZPARM

    Posted Aug 23, 2019 03:43 AM

    Hi Lucinda.

    Now the works fine.

    regadrs michael



    ------------------------------
    [DBA and SYSPROG]
    [LVM Versicherung]
    [Germany]
    ------------------------------