Db2 Tools

Expand all | Collapse all

Simplify Db2 Subsystem Management with Thread Termination/Dynamic DSNZPARM

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

    Posted 05-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 29 days ago

    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

    Posted 29 days ago
    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 28 days ago

    Hi Lucinda.

    Now the works fine.

    regadrs michael



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