Join field on CICS Exception Alerts (SY620700) does not have RsceScope
search cancel

Join field on CICS Exception Alerts (SY620700) does not have RsceScope

book

Article ID: 428554

calendar_today

Updated On:

Products

Vantage Storage Resource Manager

Issue/Introduction

Try to create "joined objects" from the "CICSLIST - CICS Address spaces (SY600500)" and the "CALERTS - CICS Exception Alerts (SY620700)", the Join field of the "Candidate Object(CICS Exception Alerts)" does not have "RsceScope".

The "name"  field of the "CICSLIST - CICS Address spaces (SY600500)" has a CICS jobname and the "RsceScope" field of the "CALERTS - CICS Exception Alerts (SY620700)" has a CICS jobname as well,

it can be a key to create "joined objects" of  "CICSLIST" and "CALERTS".

・CICSLIST - CICS Address spaces (SY600500)

・CICS Exception Alerts (SY620700)

・Try to register the RsceScope field as a Join Field, but the RsceScope field is not displayed.

Environment

Vantage SAMS: 14.1

Vantage Web Client: 14.1

Vantage StoragePoint™ Web Client r14.1.7

Resolution

2 objects in Vantage can be joined on one filed. The field has to be of the same type and length. 
 
CICSLIST - CICS Address spaces (SY600500) 
Name field is type T length 8
CALERTS -  CICS Exception Alerts (SY620700)
RsceScope field is type T but length 16
 
The length 16 in RsceScope field is for the following reason:
For CICS this happens to be a jobname of the cics region, for mq it is a 4 character (logically) qmgr name, etc.  For JVMs it is likely to go larger than 16, at which time all alert commands will probably expand.  So all of our xxxALERTS commands have it as the common 16 in length.
 
So currently it's not possible to create such a join. Create a different view, dashboard that would solve the problem a bit differently.