model management manual 2009 short

Model ManagementPolicies and Procedures

Created by – Robb CoutinhoMay 28, 2009

T A B L E O F C O N T E N T S

IMPACT ANALYSIS..........................................................................4WHERE EXISTS REPORT...........................................................4WHERE USED REPORT............................................................6MODEL COMPARE REPORT.......................................................9

MODEL MAINTENANCE..................................................15ADOPTIONS........................................................................15CREATE/COPY MODEL...........................................................20

GUARDIEN PROCESS................................................................20ADVANTAGE GEN PROCESS........................................................27

Change Owner of Model..........................................................27Grant Access to Model.............................................................27Set Package Bind Settings.......................................................28RI Trigger Construction Library Settings...................................30Construction Library Settings..................................................30External Action Block Load Library Settings.............................31External System Load Library Settings.....................................32Allocate Libraries....................................................................33

UPDATE DOCUMENTS................................................................35NOTIFICATION OF COMPLETION....................................................35

CONVERTING GEN 6.5 MODELS TO GEN 7.6 MODELS....................35MODEL NAMING CONVENTIONS................................................40

MODEL NAMING CONVENTIONS IN GUARDIEN..................................40MODEL NAMING CONVENTIONS IN THE HOST ENCYCLOPEDIA...............40

DELETE MODEL...................................................................41SUBSET MANAGEMENT..................................................45

CREATE SUBSET..................................................................45CREATE SUBSET......................................................................45DOWNLOAD SUBSET.................................................................47

DOWNLOAD MODEL..............................................................51UPLOAD SUBSET OR MODEL ...................................................55OVERRIDE SUBSET OR MODEL.................................................58

OVERRIDE MODEL....................................................................58OVERRIDE SUBSET...................................................................60

CHANGE REQUEST MANAGEMENT..................................62CREATE CHANGE REQUEST.....................................................62CHANGE CHANGE REQUEST STATUS..........................................64CHANGE DELIVERABLE STATUS................................................66

MIGRATIONS.................................................................69

of 38

PUBLICATION......................................................................69SPECIFICATION MIGRATION.....................................................78CONSUMPTION....................................................................86INTEGRATION MIGRATION.......................................................94

PREPARE CHANGE REQUEST.......................................................94PERFORM MIGRATION...............................................................96

INTEGRATION MIGRATION.....................................................102SYSTEM UPDATE USING RELEASE PACKS......................................102

CROSS RELEASE MIGRATION.................................................119AD-HOC MIGRATION...........................................................127

TECHNICAL DESIGN.....................................................135TECHNICAL DESIGN............................................................135

OVERVIEW...........................................................................135DETERMINE NEXT AVAILABLE TABLESPACE FOR NEW TABLE..............135OBTAIN TD # AND UPDATE TD DOCUMENTS.................................135DOWNLOAD THE SPECIFICATION MODEL.......................................135PERFORM TD WORK...............................................................136

Technical Design Settings......................................................136Data Store List Settings........................................................141Data Structure List Settings..................................................145

UPLOAD SPECIFICATION MODEL.................................................146MIGRATE CHANGES................................................................147DBA PROCESSING.................................................................147

APPENDIX...................................................................148MODEL MANAGEMENT/DEVELOPER STANDARDS..........................148ADD NEW GUARDIEN USER..................................................154

GUARDIEN ACCESS................................................................154ADD NEW GUARDIEN USER..................................................162

HOST ENCYCLOPEDIA COOL:GEN ACCESS......................................162Update GuardIEn Targets for Generating to Endevor Entry Stages.....................................................................................................165

of 38

IMPACT ANALYSISWhere Exists ReportFrom any panel in GuardIEn, using the dropdown menu click on ‘Function’/‘Deliverable List’.

From the Deliverable List window, if the Deliverable’s name is known, type it in the ‘Start List From’ box.

To search for the Deliverable, type in the ‘Search for Name’ box using ‘%’ as a wild card. The % sign can be used more than once within your search criteria.

of 38

Where Exists Report cont…

Using the dropdown menu click on ‘View’/‘Linkages’.

From the Deliverable window, view the Deliverable Linkages (Advantage Gen objects recognized by GuardIEn) for a Deliverable.

Some information about this screen: the last direct change timestamp for each Deliverable Linkage is extracted from the Encyclopedia. This is calculated by GuardIEn as the latest last changed timestamp for the object or its constituent objects.

Where Exisits Report is complete.

of 38

Where Used ReportFollow the instructions for the ‘Where Exists Report’.

From the Deliverable List window, using the dropdown menu click on ‘File’/‘Open’.

From the Deliverable window, click on the ‘Usage Across Models’ tab.

of 38

Where Used Report cont…

From the Deliverable/Usage Across Models window, use the filters (dropdown fields) to scope a certain Environment or Release. Otherwise select ‘ALL’ for Release and Environment.

If disabled ‘Use’ statements are required, using the dropdown menu select ‘Options’/‘Include Disabled USE’.

of 38

Where Used Report cont…

Highlight the Deliverable, using the dropdown menu select ‘Usage’/‘Used by’.

To print the report, using the dropdown menu select ‘View’/‘Report’.

The report will be available through Microsoft Notepad. From there print is available or for more formatting capabilities, copy and paste to Microsoft Word.

Where Used Report is complete.

of 38

Model Compare ReportFrom the main menu in Advantage:Gen (Central Encyclopedia) select I - COOL:Gen - COOL:Gen by Sterling Software; enter, 1 - Host Encyclopedia functions; enter, 2 - Version control management; enter and 6 - Compare aggregate objects between two models; enter.

Type the name of the source model to compare aggregate objects in’press enter.

To search for the source model, hit PF4 for Prompt to enter the selection list.

PF4 – to search, type ‘L 'R TRV SAF'’ (where ‘R TRV SAF’ is what you want to search for); press enter. Type ‘/’ next to the name of the source model to compare aggregate objects in; press enter. To cancel the selection request press Cancel (PF12).

Type the name of the destination model to compare aggregate objects or request Prompt (PF4) for list selection. Specify an object range and an execution mode; press enter.

of 38

Model Compare Report cont…

To save the objects identified by the compare report in an aggregate set specify the set or request Prompt (PF4) for list selection.

Specify the types of objects to be saved in the aggregate set. If an aggregate set is to be used/created only one report option can be selected per compare. To select all three enter ‘N’ in the ‘Save in aggregate set’ field.

Select the conditions if the aggregate set already exists; press enter. If an aggregate set is not being used this field is ignored.

Specify aggregate set retrieval option. If option is yes type the name of the aggregate set to be retrieved or request Prompt (PF4) for list selection; press enter. If option is no, clear the set name; press enter.

of 38


Type / by the aggregate object types you wish to expand (PF8 to view more objects); press enter. to cancel press Cancel (PF12).

To select individual aggregate objects, type S beside the aggregate object occurrence. To expand individual aggregate objects, type E beside the aggregate object occurrence; press enter.

of 38


To remove individual aggregate objects from the comparison list, type ‘/’ beside the aggregate object occurrence; press enter. To cancel press Cancel (PF12).

Type ‘Save’ to save the selected objects for comparison in an aggregate set; press enter.

of 38


Type the name of the aggregate set to add; press enter.

Submit job in appropriate Class; go to IOF.

of 38


Browse the ‘IEFRPT’ DDName to view your report.

Model Compare Report is complete.

of 38

MODEL MAINTENANCEAdoptionsFrom the main menu in Advantage:Gen (Central Encyclopedia), select I - COOL:Gen - COOL:Gen by Sterling Software; enter, 1 - Host Encyclopedia functions; enter, 2 - Version control management; enter and 4 – Adopt aggregate objects using related model; enter.

Type the name of the model to adopt aggregate objects in or request Prompt (PF4) for list selection; press enter.

Type the name of the model to relate to the adoptee model or request Prompt (PF4) for list selection. Specify one object range and one execution mode; press enter.

of 38

Adoptions cont…

Specify aggregate set retrieval option. If option is yes, type the name of the aggregate set to be retrieved or request Prompt (PF4) for list selection; press enter. If option is no, clear the set name; press enter.

Type / by the aggregate object types you wish to expand; press enter To cancel press Cancel (PF12).

of 38

Adoptions cont…

To adopt individual aggregate objects, type S beside the aggregate object occurrence. To expand individual aggregate objects, type E beside the aggregate object occurrence; press enter.

To remove individual aggregate objects from the adoption list, type / beside the aggregate object occurrence; press enter. To cancel the adoption press Cancel (PF12).

of 38

Adoptions cont…

Confirm selected aggregate objects. To save in an aggregate set type SAVE; press enter.

Type the name of the aggregate set to add; press enter.

of 38

Adoptions cont…

Submit job in appropriate Class; go to IOF.

Browse the ‘IEFRPT’ DDName to view your report.

Adoption is complete.

of 38

Create/Copy ModelGuardIEn Process

From the GuardIEn Task Assistant window, using the dropdown menu click ‘File’/‘New’.

From the Create a New Task window, using the dropdown field select Type (Copy Model) and Queue; click ‘Next’.

From the Copy Model Properties window, click the dropdown field to select the source model.

of 38

Create/Copy Model/GuardIEn Process cont…

From the Encyclopedia Model Selection window, select the source model; click ‘OK’. The source model would be the Component’s most recent unimplemented Integration (or ‘C’) model, otherwise, it would be the Component’s PROD model.

From the Copy Model Properties window, enter the name of the new model. Never check the box to ‘Copy Subsets’; click ‘Next’.

From the Compete Task window, make any necessary changes to the job parameters.; click ‘Finish’.

of 38


From the Task Assistant window, select the completed task, using the dropdown menu select ‘View’/‘Output’.

From the Report Output window, note any informational messages and process accordingly; click ‘Close’.

From any panel in GuardIEn, using the dropdown menu click ‘Function’/‘Project Administration’.

of 38


From the Project Administration window, using the dropdown menu click ‘Define’/’Models’.

From the Model Definition window, using the dropdown menu click ‘File’/‘New’.

of 38


From the Detail Model window, enter the following information; click ‘OK’.

CODEDevelopment/Customer models

Code consists of…the three character mnemonicthe version monththe type of model

D=DevelopmentC=Customer

Spec/Catalog/Production modelsCode consists of…

the three character mnemonicthe type of model

SPC=SpecificationCAT=CatalogPRD=Production

NAME - using the dropdown, select the new modelENCY – will always be ‘Host’MODEL ID – assigned by GuardIEnENVIRONMENT

Dev = DevelopmentInt = CustomerProd = ProductionSPCT = Specification or Catalog

RELEASE – Version year/monthDEFAULT ROLE

Catalog = Catalog modelMaster = component specific Development modelGenerate = Customer modelSlave = all other models

TARGETDevelopment = DevelopmentCatalog and Specification modelsProduction = Production model'yyyy month INT TEST' (ex. 2009 AUG INT TEST) = Customer model

SUB SYSTEM – <NONE>COMMON – check for Customer model

of 38


From the Model Setup Activities wizard, click ‘Update’ to perform a linkage update.

When creating INT (or ‘C’) models there will be an extra window to initialise the model for System Updating. Click on ‘Initialise’ and continue processing.

From the Linkage Update Results window, click ‘View Report Output’ button to view the results.

of 38

From the Report Output window, view all linkages made for this model. To print report from Microsoft Notepad, click ‘Open with…’. Close Report Output window.

Close Linkage Update Results window.

The model has been successfully added to GuardIEn.

Close the Model Definition window.

of 38

Create/Copy Model cont…

Advantage Gen Process

Go to Advantage Gen (Central Encyclopedia) to setup the properties and the appropriate libraries.

Change Owner of Model

Select I - COOL:Gen - COOL:Gen by Sterling Software; enter, 1 - Host Encyclopedia functions; enter, 1 - User access control; enter, 3 - Control model access and owner; enter and 4 - Change owner of model; enter.

Type the model name or request Prompt (PF4) for list selection; press enter.

Type new model owner ‘PLTS OWN’ or request Prompt (PF4) for list selection; press enter. To cancel press Cancel (PF12).

Grant Access to Model

Select 1 - Grant access to model; enter.

Type a model name (model should prefill from previous screen) or request Prompt (PF4) for list selection. Type ‘PLTS DEV’ or request Prompt (PF4) for list selection; press enter.

The protection and activity levels may be changed by typing ‘X’ on the appropriate settings; press Enter. (see screenshots below for more details)

Note: Example of a ‘D’ Development Model

Create/Copy Model/Advantage Gen Process/Grant Access to Model cont…

of 38

Note: Example of a ‘C’ Integration Model

Set Package Bind Settings

Press Cancel (PF12) until… 4 - Application system functions; enter and 5 - Bind options; enter.

Enter the model name (should prefill from the previous screen) and select 1 – Model; enter.

The following settings are only for Development models, otherwise, enter delete on the command line and press enter to remove all settings; press Save (PF6).

of 38

Select 2 - RI Triggers; enter.

Package Bind defaults should not be set for the RI Triggers. If defaults have been set (copied from the source model), type DEL on the Command line to delete; press Save (PF6).

Select 3 - Business Systems; enter

Business System defaults should not be set for the model. If defaults have been set (copied from the source model), type ‘/’ next to a Business System; press Enter. At the ‘Set Package Bind Defaults for Business Systems’ screen, type DEL on the command line; press enter, then press Save (PF6).

of 38

Create/Copy Model/Advantage Gen Process cont…

RI Trigger Construction Library Settings

This section details setting the RI Triggers construction libraries.

1) Select 3; press enter.2) Enter the model name; press enter.3) Select 3; press enter.4) Select 2; press enter.5) Specify the construction libraries for the RI Triggers.

Note: The libraries will be different for Development and Customer models. Only Development and Customer models need RI Trigger construction libraries set.

Note: As of 2009 all NCAL/SIEFNCAL libraries should have a “Data Set Name Type” of “LIBRARY” as we are now using PDSe instead of PDS.

a) Development Models 'T4218RTX.P4218.COOLGEN.CCVVMMYY.COBOL' 'T4218RTX.P4218.COOLGEN. CCVVMMYY.NCAL' 'T4218RTX.T4218.DBRMMMDD.DATA' 'T4218RTX.P4218.COOLGEN. CCVVMMYY.INSTALL'

b) Customer Models 'T4218RTX.ENDMMM.SIEFCOB' 'T4218RTX.ENDMMM.SIEFNCAL' 'T4218RTX.ENDMMM.SCICDBRM' 'T4218RTX.ENDMMM.SIEFINS'

Note: For Mnemonic values see the Naming Standards section.

Press Save (PF6).

Construction Library Settings

This section details setting the Application System Construction Libraries.

1) Select 1; press enter.2) Enter a model name.3) Enter a business system name; press enter.4) Select 5; press enter.5) Select 2; press enter.6) Select 1; press enter.7) Specify the internal libraries for a (ONLINE) Business System/Model.

Note: The libraries will be different for Development and Customer models. Only Development and Customer models need internal libraries set.

Note: As of 2009 all NCAL/SIEFNCAL and LOAD/SCICLOAD/SBATLOAD libraries should have a “Data Set Name Type” of “LIBRARY” as we are now using PDSe instead of PDS.

c) Development Models Generated source code 'T4218RTX.P4218.COOLGEN.SC041005.COBOL'

of 38

NCAL load modules 'T4218RTX.P4218.COOLGEN.SC041005.NCAL' Executable load modules 'T4218RTX.P4218.COOLGEN.SC041005.LOAD' DB2 DBRM modules 'T4218RTX.T4218.DBRM1023.DATA' Installation control 'T4218RTX.P4218.COOLGEN.SC041005.INSTALL' Generated MFS/DECforms NONE Generated batch JCL NONE Compile listings NONE

d) Customer Models Generated source code 'T4218RTX.ENDOCT.SIEFCOB' NCAL load modules 'T4218RTX.ENDOCT.SIEFNCAL' Executable load modules 'T4218RTX.ENDOCT.SCICLOAD' DB2 DBRM modules 'T4218RTX.ENDOCT.SCICDBRM' Installation control 'T4218RTX.ENDOCT.SIEFINS' Generated MFS/DECforms NONE Generated batch JCL NONE Compile listings NONE

Note: For Mnemonic values see the Naming Standards section.

8) Specify the internal Libraries for a (BATCH) Business System/Model.e) Development Models

Generated source code 'T4218RTX.P4218.COOLGEN.SC041005.COBOL' NCAL load modules 'T4218RTX.P4218.COOLGEN.SC041005.NCAL' Executable load modules 'T4218BTX.P4218.COOLGEN.SC041005.LOAD' DB2 DBRM modules 'T4218RTX.T4218.DBRM1023.DATA' Installation control 'T4218RTX.P4218.COOLGEN.SC041005.INSTALL' Generated MFS/DECforms NONE Generated batch JCL NONE Compile listings NONE

f) Customer Models Generated source code 'T4218RTX.ENDOCT.SIEFCOB' NCAL load modules 'T4218RTX.ENDOCT.SIEFNCAL' Executable load modules 'T4218RTX.ENDOCT.SBATLOAD' DB2 DBRM modules 'T4218RTX.ENDOCT.SCICDBRM' Installation control 'T4218RTX.ENDOCT.SBATINS' Generated MFS/DECforms NONE Generated batch JCL NONE Compile listings NONE

8) Press Save (PF6).

External Action Block Load Library SettingsDevelopment and Integration models:1) Select 2; press enter.2) ‘ENDH2.G06PL003.SGRDNCDL'3) Press Save (PF6).

External Action Block DBRM Library SettingsDevelopment and Integration models:1) Select 3; press enter.2) There should be no libraries defined here

of 38


External System Load Library SettingsDevelopment and Integration models:1) Select 4; press enter.2) There should be no libraries defined here3) Press Save (PF6).

Internal Compatibility Library SettingsDevelopment and Integration models:1) Select 5; press enter.2) ‘T4218RTX.P4218.COOLGE.CCVVMMYY.NCAL.STATI’3) Press Save (PF6).

External cOMPATIBILITY Library SettingsDevelopment and Integration models:1) Select 6; press enter.2) Enter the following libraries in this order:

a) ‘ENDH2.G06PL003.SGRDNCAL’b) ‘ENDH2.G06PL003.SIEFNCAL’


Allocate Libraries

Use the JCL in N360D8.DMF.JCL (CONSTLIB) to allocate libraries

At the top of the JCL change N360D8 to your N-id

Change the MNEMONIC, VV, MMYY fields to the component that the libraries are being allocated for:

//N360D8MN JOB (8200,3021),'DOUG',NOTIFY=N360D8,MSGCLASS=J,CLASS=A // SET MNEMONIC=RS 2 CHARACTER MNEMONIC FOR THE COMPONENT // SET VV=02 2 CHARACTER VERSION OF THE COMPONENT // SET MMYY=1209 MONTH & YEAR OF VERSION //*=========== ========================================================

of 38

Create/Copy Model cont…

Update Documents

Update the COOLGen Release Models.xls with the new model name and all appropriate information.

Notification of Completion

Send an email to the requestor of new model notifying of completion.

Create/Copy Model complete.

Converting Gen 6.5 Models to Gen 7.6 Models1. To access the 7.6 host encyclopedia execute the new 7.6 CLIST; ‘GEN’, at the TSO READY prompt. If the 6.5 CLIST (EX 'SYSPCOOL.GEN.CLIST(V65)') has already been executed you’ll need to log off and log back on. If the 6.5 CLIST automatically executes when you log on, the automatic execution of the CLIST will need to be removed. To determine if the 6.5 CLIST is automatically executed on the mainframe, select option =E.1.2 – if the ‘First TSO Command:’ is not spaces then the 6.5 CLIST is automatically executed and this information must be removed from the ‘First TSO Command:’. Once removed, hit Enter to save the changes. Again, you’ll need to log off and log back on.

2. Copy a model using the model copy functionality. From the primary encyclopedia menu this is option 1 > 3 > 1.

3. Once the model has been copied you’ll want to define it to GuardIEn.

4. To convert the copied model to 7.6 read the ‘Converting a Model’ chapter (pg. 43) in the upgrade cookbook. A link to the upgrade cookbook is shown below. (The instructions below are taken from the link.)\\tdceh1d6\ProductDoc\Gen\r7.6\Upgrade_Documentation\Gen_r7.6_Upgrade_v2.doc

5. To set the Environment Parameters, see the following document:

\\Tlt3dvm3\pltscdeatlas3\Projects\Appdev Model Management\AppDev Model Management\Standards\Gen 7.6 Quick Guide Doc

of 38

Model Conversion cont…

Shown in the screen print below is the ‘Model conversion utilities’ panel. This panel is option =1, 3, 11 - Model conversion utilities’ from the Model Management menu.

Option 1 is used if copying a model from another encyclopedia and converting it in the process. This option can’t be used as there is only one HE.

Option 2 is for converting a model that currently exists in the HE. It’s recommended that this option be used when converting models.

Option 3 is for converting ALL models that currently exist the entire HE. It is recommended that this option not be used.

of 38


To Convert a Model… Develop a naming standard for the backed up models as well as keep track of which

model is associated to which backed up model. i.e. a spreadsheet Determine which models belong to an application and convert all models that belong to

the application at once. Validate that the model and all subsets are checked in. Use the copy model functionality in the HE to make a backup of the model. Use option 2 on the ‘Model conversion utilities’ panel to convert an existing model in the

HE to be used with the r7.6 toolset. Determine whether or not the model conversion should be done online or in batch. Shown below is the ‘Model Conversion’ panel. Press Enter to begin the conversion process.


of 38

Press Enter to start the conversion. Shown below is the model conversion confirmation panel.

of 38


The following screen print shows that the model conversion completed successfully. Press F3=Exit to exit from this panel.

of 38


1. An automated facility has been created to execute the SQL. The automated facility requires both the model name and model id.2. The following DB2 query (QMF or SPUFI) needs to be executed to retrieve the model id. The model name is required for the query. Note that the model name is followed by the percent sign (%).

SELECT * FROM P9280CPD.DMDL -- VDH2 WHERE MODEL_NAME LIKE 'ModelName%'

3. Following is the output of the query with the ModelName set to ZIET DEMO -LIVESTOCK REC SYS JLB.

---------+---------+---------+---------+------MODEL_ID MODEL_NAME ---------+---------+---------+---------+------

14076 ZIET DEMO -LIVESTOCK REC SYS JLB 4. To access the automated facility, type TSO EX ‘SYSPPLT.DISASTER.HTF1.CLIST(GU276E1)’ on the command line.5. Key in the ‘Model ID’ and ‘Model Name’ from the query. Use VDH2 for the ‘DB2 System’. Press enter.6. When the JCL is displayed, submit it by typing ‘sub’ on the command line and pressing Enter.7. In IOF look at the output and find “Successful Retrieval” and “Successful Update”. The totals should be the same.

Model Conversion is complete

Model Naming ConventionsThis section details the model naming conventions in GuardIEn and the Host Encyclopedia.

Model Naming Conventions in GuardIEn.This section lists the model naming conventions (CODE) used in GDN, see Table 1.Table 1

Model Type Name Template

Example

Specification Model CCCSPC PCYSPCDevelopment Model CCCMMD PCY12DCatalog Model CCCCAT PCYCATCustomer Model CCCMMC PCY12CProduction Model CCCPRD PCYPRD

Model Naming Conventions in the Host Encyclopedia.This section lists the model naming conventions used in the HE, see Table 2.Table 1

Model Type Name Template ExampleSpecification Model

R TRV CCC SHORTNAME VV S R TRV PCY POLICY 04 S

Development Model

D TRV CCC SHORTNAME VV MMYY I D TRV PCY POLICY 04 1205 I

Catalog Model R TRV CCC SHORTNAME VV 00 S R TRV PCY POLICY 04 00 SCustomer Model C TRV CCC SHORTNAME VV MMYY I C TRV PCY POLICY 04 1205 IProduction Model R TRV CCC SHORTNAME VV I R TRV PCY POLICY 04 I

of 38