How is DB2 SSID set in the first panel of CA Database Management Solutions for DB2 for z/OS?
Article ID: 248076
Updated On:
Products
Issue/Introduction
No matter the LPAR used to logon, the Db2 SSID field is always the same Db2 subsystem. How do the tools determine what value to fill in this field?
20.0.00 CA Database Management Solutions for DB2 for z/OS 08-15-22 16:45
OPTION ===> SCROLL ===> CSR
DB2 SSID ==> DBMA LOCATION ==> LOCAL DB2 VERSION: V12R1M506
ACM ==> OFF ACMID ==> XXXXXXX SQLID ==> XXXXXXX
<-> Database Administration <-> Performance Management
_ 1 RC/Query _ DT Detector
_ 2 RC/Migrator
_ 3 RC/Update <-> Value Pack
_ 4 RC/Secure _ B Batch Processor
_ C DB2 Command Processor
<-> General Facilities _ I Interactive SQL
_ A Product Authorizations _ M Alt. Catalog Mapping
_ DF Dataset Facility _ TT Thread Term/Dynam DSNZPARM
_ EP Edit Parmlib Members _ Y Utility Manager
_ GP Global Prof. Variables _ 6 RI Manager
_ SS Space Calculator
_ T Product Tutorials
_ W Log Maintenance _ X Exit CA/DB2 Products
Environment
Release : 20.0
Component : RC/Query for DB2 for z/OS
Resolution
The SSID is pulled from the user's ISPF profile and will display by default whatever is used as an SSID the last time the Main Menu of CA/Broadcom is entered. This default can be overridden by changing the RSPINIT and RSPMAIN CLISTS in the following manner. In RSPINIT
/****************************
/* SET UP THE DB2 SUBSYSTEM ID */
/****************************
ISPEXEC VGET (SYS,LOCATION) PROFILE
IF &SYS = &STR()
THEN + SET &SYS = &STR(SSID)
IF &LOCATION = &STR() THEN +
SET &LOCATION = &STR(LOCAL)
ISPEXEC VPUT (SYS,LOCATION) PROFILE
SET &SYS = &STR(ABCD) */
This statement can be updated to always set the SSID to ABCD.
Feedback
