Direct upgrade to Content Manager V8.5 Fix Pack 1 for z/OS

Answer

Upgrading from Content Manager V8.4.3 for z/OS to Content Manager V8.5 Fix Pack 1 for z/OS is supported by using the upgrade jobs that are provided by the release. You can use the attachment upgrade jobs to upgrade your Content Manager for z/OS components: library server and resource manager, from Version 8.4.1 Fix Pack 1 (or 8.4.2.x) to Version 8.5 Fix Pack 1. Once you are on 8.5 Fix Pack 1, you can upgrade your Content Manager to a new release of Content Management by using the upgrade jobs included in the new release.

Note: In this document, the terms, previous release or original release refer to the Content Manager release that you want to upgrade from and the term, new release refers to Content Manager Version 8.5 Fix Pack 1.


Table 1: Jobs for Direct Upgrade to 8.5 Fix Pack 1

Library server upgrade job	icmmlsup.txt
ICMMDRPP - Drop DB2 stored procedures, functions, and alias. Used by job step CM8403S8 in ICMMLSUP.	icmmdrpp.txt
ICMMCRTP - Create DB2 stored procedures, functions, and alias. Used by job step CM8403S9 in ICMMLSUP.	icmmcrtp.txt
Resource manger upgrade job	icmmrmup.txt
Re-upgrade library server from CM 84x to CM 85 FP1	Re-upgrade.txt

If your current Content Manager is Version 8.4.1 Fix Pack 1, you can use the attached upgrade jobs without removing any job steps. However, as an example, if you are using 8.4.2 Fix Pack 1, the job steps from 8.4.1 Fix Pack 1 to 8.4.2 Fix Pack 1 need to be removed. The prolog section of each upgrade lists the job steps of upgrade to each fix pack. You have to carefully review them and remove unwanted job steps.

The upgrade jobs are used to upgrade to Content Manager Version 8.5 Fix Pack 1 for z/OS.

Upgrading to the New Release

The table below is a check list for your reference when you are preparing to run the upgrade jobs. You can add additional steps based on your environment. The term "new release" in the table refers to either Version 8.5 or Version 8.5 Fix Pack 1.

Table 2: Upgrading to 8.5 Fix Pack 1
Reverting to the Original Release

After the upgrade, if you need to use your original Content Manager release again, you can restore your upgraded library server and resource manager databases from your backup copy or continue to use the upgraded databases.

If you decide to continue to use the upgraded databases, the table below provides a checklist of tasks you need to perform in order to use them. For the simplicity, Version 8.4.1 Fix Pack 1 is mentioned in the table as an example of the version and release of Content Manager that you used before the upgrade. You have to change it to your original release level.

Table 3: Reverting to 8.4.1 Fix Pack 1

Step	Description	Status
	Library server tasks
1	Run the SQL statements mentioned in the prolog section of the ICMMLSU3 member in Version 8.5 Fix Pack 1 .SICMINS1
2	Modify ICMMLSU3 and change the RELNAME1, RELNAME2, and RELNAME3 based on the value obtained from Step 1.
3	Ensure library server is active and run ICMMLSU3.
4	Stop your library server
5	Modify and submit ICMMLSDR from Version 8.5 Fix Pack 1 .SICMINS1 - Remove the second job step ICMDROP2 which drops the library server database - Run the first step ICMDROP1 to drop DB2 stored procedures, functions, and alias used by the Version 8.5 Fix Pack 1. Note: expect an error with RC=8 due to the following functions dropped by the ICMMLSU3 job: ICMOLDENC ICMOLDDEC
6	Modify ICMMLSCR from Version 8.4.1 Fix Pack 1 to only execute the last job step ICMSTPR. Note: Add the following statement in the ICMSTPR job step before submit the job: CREATE ALIAS ?CREATOR?.ICMFICTITIOUS FOR SYSIBM.SYSDUMMY1;
7	Set the LSCURRENTVERSION column in the ICMSTSYSCONTROL table to Version 8.4.1 Fix Pack 1: UPDATE ?CREATOR?.ICMSTSYSCONTROL SET LSCURRENTVERSION = '8.4.01.100' WHERE 1 = 1;
8	After revert back to CM84x, execute the following statements (see note 1) DELETE FROM ?CREATOR?.ICMSTPRIVSETS WHERE PRIVSETCODE = 1 AND PRIVDEFCODE IN (149 , 150 , 151 , 152); COMMIT; DELETE FROM ?CREATOR?.ICMSTPRIVDEFS WHERE PRIVDEFCODE IN (149 , 150 , 151 , 152); COMMIT; DELETE FROM ?CREATOR?.ICMSTNLSKEYWORDS WHERE KEYWORDCLASS = 10 AND KEYWORDCODE IN (149 , 150 , 151 , 152); COMMIT; Skip this step if you revert back to CM85
9	Update your library server procedure STEPLIB to use the load library from 8.4.1 Fix Pack 1.
10	Run the following members from 8.4.1 Fix Pack 1 .SICMINS1 data set: ICMMLSBD ICMMLSGT ICMMCACL
11	Build component table views by running cmcfglsi -t comptypes from a Content Manager V8.4.x system administration workstation
12	Re-bind batch utilities plans to use the DBRMs from 8.4.1 Fix Pack 1, if you are using batch utilities.
	Resource manager tasks
13	Stop your resource manager.
14	Modify the STEPLIB in the resource manager procedure if a different .SICMLOD2 is used for Version 8.4.1 Fix Pack 1.
15	Modify the "httpd.conf" file of the IBM HTTP Server V5.3 instance running the resource manager to use the Version 8.4.1 Fix Pack 1 resource manager subdirectory in USS.
16	Remove the added ServerInit directive in the httpd.conf file of the IBM HTTP Server V5.3 instance, if reverting to resource manager V8.4.3 or earlier.
17	Modify and run the following members in .SICMINS2 from the new release: ICMMRMBD or ICMMRMBR, and ICMMRMGT ICMTRMBD or ICMTRMBR, and ICMTRMGT (TSM feature)
18	Set the RMCURRENTVSERION column in the ICMRMCONTROL table to Version 8.4.1 Fix Pack 1: UPDATE ?RMCREATOR?.ICMRMCONTROL SET RMCURRENTVERSION = '8.4.01.100';
19	Modify the plan name used by your resource manager.
20	Update the CURRENTVERSION column in your library server ICMSTResourceMgr table for this resource manager to version 8.4.1 Fix Pack 1.
21	Start your resource manager.

Note:
1: If any of these four privilege codes is used by customer after upgrade to CM85x then customer needs to delete the privilege code from the customer defined privilege set after revert back to CM84x. Customer needs to add them back to the customer defined privilege set after re-upgrade to CM85x.


Re-upgrading Library Server and Resource Manager

After the reverting, if you use the upgraded databases and decide to upgrade the library server and resource manager to Content Manger V8.5 Fix Pack 1 again, you can follow the same steps outlined in the table 2 with some exceptions.

• Replace the ICMMLSUP job as stated in step 8 with the following tasks instead:

1. Drop DB2 stored procedures, functions, and alias using either ICMMDRPP member or ICMMLSDR member from your original release
2. Define DB2 stored procedures, functions, and alias using the ICMMCRTP member from the Content Manager V8.5 Fx Pack 1
3. Alter the ICMSTRESOURCEMGR table, before running ICMMLSU2 job,
ALTER TABLE ?CREATOR?.ICMSTRESOURCEMGR
ADD COLUMN RMPASSWORD2 VARCHAR(256) FOR BIT DATA
;
4. Set the LSCURRENTVERSION value to 8.5.00.100
5. If you run step 8 in table 3 during the reverting for library server, you have to run the SQL provided in the Re-upgrade.txt file which can be found in the table 1 at the beginning of this document.
6. You need to add the customer defined privilege set back, if any one of the four privilege code (149, 150, 151, 152) is used after the re-upgrade to CM85x. For example:
INSERT INTO ?CREATOR?.ICMSTPRIVSETS (PRIVSETCODE, PRIVDEFCODE)
SELECT x , 152
FROM SYSIBM.SYSDUMMY1
WHERE NOT EXISTS (SELECT 1 FROM ?CREATOR?.ICMSTPRIVSETS
WHERE PRIVSETCODE = x AND PRIVDEFCODE = 152)
;
where x is the privilege set code.
• Replace the ICMMRMUP job as stated in step 18 with the following task instead:

1. Set the RMCURRENTVERSION value to 8.5.00.100