How to Change Showcase Server Ports or Swap Ports Between two Showcase Servers [Video]

 

Summary

During the installation of a new Showcase server environment 3 ports are assigned: Showcase Server, RMI Compression Port, and Firewall Port.

From time to time it is necessary to change these allocated port numbers after installation has been complete. Most commonly we see customers who have installed a new version of Showcase into a different library to test features of a new release. Once the functionality has been successfully tested in the new library it is time to put this environment into production.

In order for end users to connect to the new environment through the client applications (Query, Report Writer, etc) they would need to change their ODBC set up to direct their PC's to the new environments iSeries port. Rather than changing the settings on each client PC, you can change the port numbers that the new environment is using on the iSeries and force it to use the ports that the old environment was on. This eliminates the need to update individual PC's.

In this article we will walk through the steps needed to change port numbers for both ShowCase servers. In this example, we will change port numbers for a new ShowCase 9.1.0.0 test library (SUPPORT91), so that it will use the current 9.0 production library (SUPPORT90) port numbers. This will make the upgrade transparent to the end users.

To alleviate confusion along the way please note ALL your port numbers for both environments. The port numbers for our example are listed below. This will help to guide you through which port numbers to use in the instructions to follow. In addition to the port numbers in use, you will need to know what subsystem you are using. By default Showcase will run in QCMN and this is the subsystem noted in the instructions.

NOTE: In the Examples below, you will need to replace SUPPORT90 and SUPPORT91 with your Showcase server library names.

1. Document your current port numbers by issuing the command WRKSRVTBLE. To get to the bottom of the list press Shift-F6 and search for the following entries

   SCFIREWALLSUPPORT90 __________________ TCP (for example: 43901)

   SCRMICOMPSUPPORT90 ____ _____________ TCP (for example: 43902)

   SCSERVERSUPPORT90 ____ ________________ TCP (for example: 43900)

2. Our first sequence of steps will remove the 3 ports associated for SUPPORT90 library:
   1. Log onto to a new iSeries with a QSECOFR profile that has a CCSID=37

   2. Run Command: ADDLIBLE SCSERVER90NOTE: This will add SCSERVER90 to library list

      NOTE: Make sure this is the only Showcase library in your library list

   3. Run Command: ENDSCSVR - This will end the Showcase Server

   4. Issue the following 3 commands to verify there are NO locks on your Showcase Server Library and END any jobs that have locks on these objects.

      WRKOBJLCK OBJ(SCSERVER) OBJTYPE(*LIB)

      WRKOBJLCK OBJ(SCSERVER/SCCONNECT) OBJTYPE(*USRSPC)

      WRKOBJLCK OBJ(SCSERVER/SCASSIST) OBJTYPE(*PGM)

   5. Run Command: RMVSCTCP FRCRMV(*YES) SBSD(QSYS/QCMN)

      NOTE: Be sure to change the subsystem as needed, here we are using QCMN

   6. Log off of the iSeries session
3. Remove the current port entries for SUPPORT91:
   1. Log onto to a new iSeries session with a QSECOFR profile that has a CCSID=37
   2. Run Command: ADDLIBLE SUPPORT91NOTE: This will add SCSERVER91 to library list. Make sure this is the only Showcase library in your library list
   3. Run Command: ENDSCSVRNOTE: This will end the Showcase Server

   4. Issue the following 3 commands to verify there are NO locks on your Showcase Server Library and END any jobs that have locks on these objects:

      WRKOBJLCK OBJ(SCSERVER) OBJTYPE(*LIB)

      WRKOBJLCK OBJ(SCSERVER/SCCONNECT) OBJTYPE(*USRSPC)

      WRKOBJLCK OBJ(SCSERVER/SCASSIST) OBJTYPE(*PGM)

   5. Run Command: RMVSCTCP FRCRMV(*YES) SBSD(QSYS/QCMN)

      NOTE: Be sure to change the subsystem as needed, here we are using QCMN

4. Assign the new ports to SUPPORT91 (these are the ports that SUPPORT90 was using) with the command SCSERVER90/ADDSCTCP. Press F4 to fill in the following:

   Subsystem for TCP server jobs: Specify the Subsystem that your Showcase Server runs in or where you would like it to run~Library: Specify your (new) showcase Server library name

   TCP Port Number: Specify the port number you want your Showcase Server to be connected to OR use your existing port number if you are just changing the Subsystem where Showcase server runs

   Firewall Port Number: Specify the port number from above

   Compressed Data Firewall Port: Specify the port number from above

   HostName: *TCPCFG

   Press Enter to save changes - you should receive message, "Showcase TCPIP support successfully added"

5. If the ADDSCTCP command completed successfully, the server will attempt to start.
6. Verify your Showcase server started by running the WRKACTJOB command.

View the video below for more information.