CA OPSMVS 13.0 : How to expand PREREQ and MISSING_PREREQ columns in Resource Table - SSM V2
book
Article ID: 131958
calendar_today
Updated On:
Products
OPS/MVS Event Management & Automation
Issue/Introduction
In CA OPSMVS the Resource tables store information about the status of each resource. You could place data on all of your system resources in a single table. However, we recommend that you create a separate resource table for each type of resource. For example, you create a table for VTAM nodes, another table describing printers, and so on. The Using Guide section ' Resource Tables' reports the following explanation: ... PREREQ Displays a list of resources that must be in an UP state before SSM can start the subsystem. Maximum Length: 1000 characters
MISSING_PREREQ Displays a list of the prerequisite resources that have not been satisfied. A VARCHAR definition is used to conserve memory. Maximum Length: 1000 characters ...
How is it possible to expand PREREQ and MISSING_PREREQ columns from char(200) to varchar(1000)?
Environment
Z/OS OPSMVS
Resolution
It is possible to expand PREREQ and MISSING_PREREQ columns from char(200) to varchar(1000) but, since we have no way of just modifying a column definition in RDF, it is necessary to create in OPSVIEW 2.6 editor menu a new table using the old one as the model table and update the column definitions for the PREREQ and MISSING_PREREQ columns. Then the Transfer command can be used to copy the data from the old table into the new one.