• February 15, 2019

The iCluster files with triggers report

In our last post we covered the Replication Coverage Report, which is option 5 from the Reports Menu. In this post we will skip over Option 6 which is just the DMDSPLOG command (Event log report) and concentrate on the Files with Triggers Report Option 7.

Use the DMRPTTRG command to access this report as below:

DMRPTTRG

The Files with Triggers report can be run on any node and lists for the group specified or for all groups using the current node as the Primary, the files in replication scope with triggers.

The number of parameters is small, just the Group parameter – either GROUP(*ALL) for all groups using the current node as the Primary which is the default, or a specific group name (no generics allowed). The report is always created in a spool file but the Output parameter allows for it to be optionally displayed on screen using OUTPUT(*) which is the default. Finally you have the option of putting the results into a specified database file in the OUTFILE parameter. If the file exists it will be replaced, if it does not exist it will be created. The default for the OUTFILE parameter is *NONE.

Here is a sample report.

File with Triggers Report

As you can see in this report the Payroll group has 110 files that were processed and only 1 file ACUSTOMER has a trigger. The trigger is enabled and is a before update trigger running program CUSTUPD2 in library PAYROLL. The full trigger name is truncated on this display but is listed in full in the report.

Note: The report indicates the number of database files processed for each group; however, only those files that have triggers are listed in the report.

iCluster Tech Tuesday 115 Posts

iCluster TechTuesday is a set of posts covering technical tips and techniques to help get the most out of your Rocket iCluster installation.

2 Comments

  • Kaldip Sidhu Reply

    March 12, 2015 at 4:05 pm

    Is there a way for the command DMRPTTRG to generate the specified database file in the OUTFILE parameter. Is there a sample that can be provided and also will this command list SQL Procedures and SQL Functions?

  • Mike Warkentin Reply

    March 13, 2015 at 9:20 am

    Hi Kal.

    Yes it looks like there is a bug in the report option (for both DMRPTRG and DMRPTCST). There is a workaround, if you copy the DMTRGLIST or DMCSTLIST files from ICLUSTER into the library where you want the new output file to be created before running the reports, the output file will be created.

    We will fix this bug in the next interim fix package.

    Currently the report does not list SQL procedures or functions.

Leave a Comment

Your email address will not be published. Required fields are marked *