How to alter the CCI SYSID specified for CA Mainframe Software Manager during the install without re-running the CA MSM install script?

Document ID : KB000052489
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In the event the CCI SYSID value had been incorrectly specified at install time, or for other reasons the CCI SYSID has changed, users may need a mechanism to alter what has been stored for this variable. This method will not require the user to re-run the CA Mainframe Software Manager install script.

Solution:

The following steps will direct you on where and how to change the originally defined value for the CCI SYSID. The CA Mainframe Software Manager Tomcat region must be down for this change. The value is used in the URL for the Database Connection Pool.

This value is in the Tomcat file named: context.xml. This file is located in the .../tomcat/conf/ folder.

This file is an ASCII file so you have to edit it in ASCII mode. There are two ways to edit this file.

  1. This can be done from ISPF PDF option 2 (Edit). Use the path to the file in the 'other' section of the screen and then use 'EA' on the command line for 'Edit ASCII'.

  2. Another option is to download the file to your PC as BINARY via FTP. Edit the file and FTP back to the Tomcat/conf folder again as BINARY.

The context.xml file will have a definition for a connection pool and will look like the below text.

The 'SystemID=CCISYSA' is the CCI SYSID value. The value is not case sensitive.

      <Resource
      type="javax.sql.DataSource"
      name="jdbc/SWMgrDataSource"
      url="jdbc:datacom:/ServerName=MSM_DEV2,SystemID=CCISYSA,
      ApplicationID=MSM_DEV2,HostPort=1234,ConnectType=cci,
      HostName=usilca31,UserID=SWMGRDV"
      driverClassName="ca.datacom.jdbc.DatacomJdbcDriver"
      username=""
      password=""
      maxWait="5000"
      maxIdle="2"
      maxActive="40"/>