Can I use Data Reporter to access a table in a Multi-MUF Facility environment (also called MMF)?
Per CA Datacom/DB Reporting Facility Guide 14.0, MMF supports Data Reporter.
Chapter 4: CA Datacom/DB Reporting Facility Tutorial
Paragraph: Defining a Table
The following parameters are used to request data from multiple MUFS and are optional:
- SIDNAME=xxxxxxxx - The xxxxxxxx is the load module name of the SID of the MUF you want to access. SIDNAME defaults to DBSIDPR.
- DBIDUSER=9999 - The 9999 is the DBID that you use in the Reporting Facility program with DBIDMUF. These parameters are only needed if you are using the same DBID in one DR program from the two different MUFs.
- DBIDMUF=9999 - The 9999 is the DBID that MUF knows about.
Note: Code and link the DBSIDPR macro as xxxxxxxx matching the SIDNAME=parameter coded. For more information about coding the DBSIDPR macro, see the CA Datacom Database and System Administration Guide.