Hi
In addition to previous useful update:
1. Other than compatibility checks what are the things to keep in mind before upgrade.
A: System Packages have to be installed. For the complete list see:
AE Operating System and Database Support - CA Workload Automation AE & Workload Control Center - CA Technologies Documen…
2. Is there any specific binaries to perform upgrade or new version binaries (R11.3.6 SP7 in this case) will start the upgrade process during install process (Repair or Upgrade).
A: The installer is able to detect that this in an automatic Upgrade
3. Sequence of Upgrade will be (Common Components -> Autosys Server -> WCC). Correct?
A: See links provided by Faouzia. It depends if all these products are installed or not on same machine
4. what will be the changes at database end? I mean, will the upgrade process made the necessary changes at the database? if yes, then what are those changes and do we need to take backup of specific items related to database?
A: Stored Procedures are upgrades, changes to the schema are done , indexes are dropped and recreated automatically and so on... All this stuff is done by the CreateAEDB.pl script located in $AUTOSYS/dbobj/<database type> directory which is triggered by the Upgrade process.
A: It is always good to save the database before starting the upgrade
5. From the Autosys point of view, we need to take the back up of EEM policies, WCC (users, flows, views), jobs objects, Autosys_secure. is there anything else to consider for backup? also is there a convenient way to take the backup of all the required items?
A: While all these CCS/WCC/Autosys products are down, I would backup the entire /opt/CA directory tree along the Autosys database and WCC database is not using internal Derby database
6. Most important, at any point of time, if we need to rollback, then what is the rollback procedure? will the rollback stops immediately (once the error encounters) and revert the changes, hence we will be back to R11.3.0 SP1 version?
A: As soon as there is an error during the Upgrade process, an automatic rollback is done. But if this is not sufficient to recover, then restore the /opt/CA directory tree from point 5 and the database
7. Database changes made during upgrade process will be rolled back automatically and we will be able to work as earlier?
A: To be 100% safe, better to restore the database
8. How to make sure that Rollback is done successfully and we are able to work successfully as earlier?
A: If the database upgrade is successful with release 11.3.6 SP7, you can query the alamode table to get the AEDB_VERSION and BINARY_VERSION.
From my test server:
--------------------------
AEDB_VERSION 0
11.3.6.7.0
BINARY_VERSION 0
11.3.6.SP7
As said before, if there is any doubt by comparing the output of "autoflags -a" and the alamode table, restore the database
9. How much time is required to do the upgrade?
A: It all depends on the architecture
- a) Full HADS server or not.
- b) Have you installed all the OS prerequisites before the upgrade?
- c) Is there enough disk space to upgrade?
- d) Are you upgrading WCC and EEM first then in a second stage Autosys?
-e) are EEM and WCC running in HA mode?
Regards
Jean Paul