More detail on Vantage DB2 Interface Installation

Products

• Vantage Storage Resource Manager

Issue/Introduction

After installation and configuration of the CA Vantage DB2 feature, System Script, DB2NAMES not functioning, which includes all of it objects, such as DB2TABLs. Also other functions that are needed are not available and not documented; OBJ12039, DB2LITS. Was able to find OBJ12030, in member VNS12030. However this object was not documented.

Environment

Vantage 14.0

Resolution

Check to make sure the script VSAMVVDS is running and has to be run for every DTOC, and has to complete before any of the DB2 SYSTEM SCRIPTS can run.

DB2NAMES in 12.6 contains only one Object, but Rel 14 contains 4 objects. When DB2names Script for 14 is run, the objects are 1) not created, and 2) the system script was updated to remove 3 of the object lines. You can recreate the DB2NAMES script with only the DB2NAMES object, and create 3 other system scripts for the other 3 objects; DB2TABLS, DB2DETAL and DB2SYST.

There is an order required in executing/loading the system scripts. please try:

DB2NAMES
DB2TABLS
VNS12030
DB2RTS
DB2LITS
DB2DETAL
DB2SYST

Please review this chapter and make sure all steps are followed: "Configure for CA Vantage Database Option (DB2)" under link:
https://docops.ca.com/ca-vantage-storage-resource-manager/14-0/en/configuring/configuring-database-options#ConfiguringDatabaseOptions-ConfigureforCAVantageDatabaseOption(DB2)

Especially:
6. Use the Config Client to set appropriate system parameters:
SUDB2 (Y) - Activates DB2 support
DB2SUBS (sub1,sub2,...,sub8) - Include local DB2s only DB2SUBS (<DB2LIST>) - Include remote DB2s

The DB2SUBS parameter is described in detail under link:
https://docops.ca.com/ca-vantage-storage-resource-manager/14-0/en/configuring/system-parameters/vkgparms-parameter-descriptions-0-to-d-inclusive

Some points the documentation misses is that VNS12030, and DB2Names has to be run for every release of Vantage, and not skipped.