Install the ReportCenter Database
nwmsol
ReportCenter uses a database that is installed into the
Datacom/AD
environment. The database is used to store reporting data collected by your ReportCenter regions. This database is empty until you begin your own data collection.The
Datacom/AD
environment must be installed before you install the ReportCenter database. This is because the installation tasks require an active Datacom/AD
environment.Start the
Datacom/AD
EnvironmentDuring the
Datacom/AD
installation tasks, you edited and saved the JCL member ADn
STRT, where n
is the release number of Datacom/AD
that you are using. This member starts the Datacom/AD
environment. The environment must be running before you run any ReportCenter database installation jobs.You must start the MUF before performing these tasks.
Create the ReportCenter Schema
Each database accessed by SQL in
Datacom/AD
has an SQL schema name.To ensure that the table names used by
NetMaster
are not duplicates of any other tables, create a specific schema for ReportCenter.To create the ReportCenter schema in the
Datacom/AD
environment- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$01) data set member.This job creates the ReportCenter database schema (PRODRPTS).
- Edit your copy of WRDCM$01, as instructed at the top of the member.
- Save your changes and submit the job. The expected return code is 0.
After the ReportCenter schema is defined, you never have to add it to this AD environment again. If you run this step a second time, you receive an SQLCODE of -118 with a DSF return code of NAAE (already exists).
Define the ReportCenter Database and Tables
The ReportCenter database is defined to the
Datacom/AD
environment by using a batch utility program that is provided with the environment. The batch utility defines the ReportCenter database (with the schema name of PRODRPTS), and the tables needed to support ReportCenter.To define the ReportCenter database and tables to the
Datacom/AD
environment- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$02) data set member.This job executes theDatacom/ADDDUPDATE batch utility.
- Edit your copy of WRDCM$02, as instructed at the top of the member.
- Save your changes and submit the job. The expected return code is 0.
This job may be resubmitted, as required, until it completes successfully.
After the database is defined, you should not need to define it to the environment again. You can redefine the database definition, if needed; however, this should be done only under instructions from Technical Support.
Catalog the ReportCenter Database and Tables
When the ReportCenter database is defined, you must catalog the database definition, using the DDRTVCAT batch utility provided by the
Datacom/AD
environment. This utility validates the database definition to make sure it matches the current ReportCenter database model, and then catalogs it to the environment. After it is cataloged, the database is available for processing under the Datacom/AD
environment.To catalog the ReportCenter databases and tables
- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$03) data set member.This job executes theDatacom/ADDDRTVCAT batch utility.
- Edit your copy of WRDCM$03, as instructed in the member.
- Save your changes and submit the job. The expected return code is 0.
This job may be resubmitted, as required, until it completes successfully.
After the database is cataloged, you should not need to catalog it to the environment again. You can recatalog the database definition, if needed; however, this should be done only under instructions from Technical Support. Rerunning the catalog of an active database definition can cause existing data in that database's tables to be marked unusable and result in a loss of existing data.
Allocate the ReportCenter Database Data Sets
When you have defined and cataloged the database, you must allocate a set of data sets to hold the data (and indexes) for the ReportCenter tables.
To allocate the database data sets
- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$04) data set member.This job executes the IBM IEFBR14 batch utility.
- Edit your copy of WRDCM$04, as instructed at the top of the member.This job contains the space allocations for all the database table files. The defaults should be sufficient for all but the largest sites. For more information, seeDatacom/ADSpace Sizing Considerations.
- Save your changes and submit the job. The expected return code is 0.
This job may be resubmitted, as required, until it completes successfully.
Initialize the Data Areas and Prepare the ReportCenter Database Tables
When you have allocated the data sets, you must format them ready for use as database tables.
To initialize the data areas and prepare the ReportCenter tables
- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$05) data set member.This job executes theDatacom/ADDBUTLTY batch utility. This utility formats (INIT) each of the data sets and marks themnullloaded (loaded with no rows).
- Edit your copy of WRDCM$05, as instructed in the member.
- Save your changes and submit the job. The expected return code is 0.
This job may be resubmitted, as required, until it completes successfully.
Add the ReportCenter Database Constraints
Database constraints include, for example, foreign key and check constraints. These constraints function as rules that the database management system enforces to ensure the integrity of the data.
To add the ReportCenter database constraints
- Locate and copy thedsnpref.NMC1.CC2DSAMP(WRDCM$06) data set member.This job executes the DBSQLPR dynamic SQL program that processes the SQL commands that add the constraints to the production and sample databases. It also primes the production database KEYRANGE table with zero values and loads the TIMEFRAME table with all the necessary valid time ranges used in report generation.
- Edit your copy of WRDCM$06, as instructed at the top of the member.
- Save your changes and submit the job. The expected return code is zero.
This job can be resubmitted, as required, until it successfully completes. When this job completes, the constraints remain in place until the table is dropped. Any attempt to add these constraints fail with an SQLCODE of -118 with a DSF Return Code of NAAE (already exists).
Back Up the
Datacom/AD
EnvironmentDuring the
Datacom/AD
installation, you are instructed to run the database backup job. This job creates backups of the Datacom/AD
environment, which includes everything except the data stored in the ReportCenter database. Following the successful implementation of the ReportCenter database, you must re-execute this database backup job.To back up the ReportCenter database, use the supplied job WRDCMUNL. To restore the RerportCenter database, use the supplied job WRDCMREL.
In addition, these jobs must be standardized for your environment and added to the regularly scheduled system backups. These backups are needed in case the system fails or you accidentally delete one of the data sets. If this occurs, contact Technical Support for assistance in restoring the required data sets.