Upgrade Guide for DB2 UDB for z/OS > How to Perform the Upgrade >

Process of Upgrading a Production Environment

Upgrades: All upgrades.

Environments: Production environment only. Does not apply to production test environment.

This process is part of a roadmap. See Roadmap for Performing the Upgrade.

This topic lists the tasks required to transition your production test environment to production. Print this topic and use it as a checklist for doing the upgrade.

The topic is divided into sections, each containing numbered steps. Complete the steps in the order shown.

Upgrade Third-Party Software

1. Upgrade third-party software as required due to dependencies on Siebel software or other installed software. For example, you may need to upgrade the following software:
   • Actuate Server (Siebel Reports Server).
   • Operating system software. Some database upgrades require newer versions of AIX or Windows.

     For further information, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

Upgrade the Servers

Verify you have identified all the maintenance releases, Fix Packs, and quick-fix patches required for the upgrade. These requirements are documented in Siebel Maintenance Release Guide on My Oracle Support.

To perform the following steps, see the Siebel Installation Guide for the operating system you are using and Implementing Siebel Business Applications on DB2 UDB for z/OS.

2. Install the Siebel Gateway Name Server, Siebel Servers, and Siebel Web Server Extension (SWSE).

   The upgraded Siebel Servers will not work correctly with the RDBMS server until after you have upgraded the Siebel Database to the new release.

3. Install the Siebel Database Server files on the Siebel Server you will use to perform the upgrade.
4. Install language packs for your currently deployed languages and any new languages.
5. If you have customized the configuration of Enterprise components, such as Siebel Servers, you must manually enter the customizations in the upgraded environment. See Going Live with Siebel Business Applications.

NOTE:  You do not install a new Siebel database as part of upgrading the Siebel Enterprise.

Upgrade the RDBMS

6. If required, upgrade the RDBMS version. Refer to the vendor's documentation to perform the upgrade. For information on supported RDBMS systems, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

Identify and Resolve Duplicate Row IDs

7. 6.2.1 upgrades only: Identifying and Resolving Duplicate Row IDs.

   After you install the Siebel Database Server software, but before you upgrade to this release, you must identify and resolve any duplicate row IDs in your Siebel Database.

Preupgrade Tasks for the Siebel Database

8. Review Siebel Technical Notes and Siebel Alerts on upgrading to the current release. Make revisions to the upgrade process as required. See Important Upgrade Planning Resources.
9. Review 477519.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 521. It contains important changes to database records and repository objects that must be made during the upgrade. See Important Upgrade Planning Resources.
10. Review guidelines for configuring the RDBMS. See Implementing Siebel Business Applications on DB2 UDB for z/OS.
11. Verify that the Workflow Monitor and Workflow action agents have processed all pending requests.
12. Stop the Siebel Server and the Siebel Gateway Name Server.
13. Verify there are no open database connections.
14. Perform the tasks in Basic Database Preparations.

Preupgrade Tasks for a Production Environment Upgrade

15. Perform the relevant tasks in Preparing a Production Environment for Upgrade.

    You must perform the task Transferring the Customized Repository and Schema Definition Files.

Preupgrade Tasks for Application Data

16. Perform the relevant tasks in Preparing Application Data for Upgrade.

Some of these tasks are optional, depending on the currently installed Siebel products and your upgrade path. Review and perform these tasks as necessary.

Upgrade the Siebel Database Schema (upgrep + upgphys)

17. Verify you have a current backup of the production environment database.
18. On the Siebel Server you used to upgrade the production test environment, create an ODBC to connect to the production environment database.
19. Run the Database Server Configuration utility:
    • Preparing to Run the Database Server Configuration Utility.
    • Running the Database Server Configuration Utility Under Windows.
    • Running the Database Server Configuration Utility Under UNIX.

      When running the Database Server Configuration utility, choose the following settings:

    • Upgrade Options: Upgrade Siebel Database Schema (upgrep + upgphys)
    • Environment Type: Production

      You do not have to run the Database Server Configuration Utility in Prepare for Production mode.

      NOTE:  If you have completed a production test upgrade and have tuned the upgrade scripts used to perform the mainframe upgrade tasks, ensure that you copy these files to a safe location so that you can use them during the production upgrade. This will ensure you do not overwrite them when you next run the Database Server Configuration utility.

20. Enter configuration information for the production environment. The master UCF file is updated with the production environment configuration.
21. Review the following topic and perform the procedure if applicable: Migrating Address Data from Custom Extension Columns.
22. Enter Yes on the Database Server Configuration utility screen to launch the Siebel Upgrade Wizard. SQL commands are executed on the production database until the Upgrade Wizard stops at the First Pause.

NOTE:  If you have completed a production test upgrade and have generated and tuned the SQL and JCL upgrade scripts that are run on the mainframe, you may not have to perform all of the tasks listed in the rest of this section. Instead of transferring the files generated by the Upgrade Wizard to the mainframe, use the files that you generated and tuned during the Production Test environment upgrade to perform the mainframe upgrade tasks. Then resume the Upgrade Wizard on the midtier so that it can perform the midtier upgrade tasks. Siebel Expert Services can advise on which of the following steps you must run; this may depend on the upgrade script tuning that you have performed.

23. Preparing the z/OS Host Environment.
24. Resuming the Siebel Upgrade Wizard After the First Pause.
25. Transferring Control Cards and Schema DDL Files to the z/OS Host.
26. Preparing the Schema and JCL Files on the z/OS Host.
27. Installing Stored Procedures on the z/OS Host.
28. Preparing Siebel-Scheduled Jobs on the z/OS Host.
29. Optimizing the Target Job Stream, Part 1.
30. Optimizing Old-Schema Index Rebuild Jobstreams.
31. Loading Log Tables on the Source Database.
32. Loading Log Tables on the Target Database.
33. Executing the Upgrade on the z/OS Host (Phase 1 of 2).
34. Resuming the Siebel Upgrade Wizard on the Midtier After the Second Pause.
35. Transferring the Index Schema to the z/OS Host.
36. Preparing Siebel-Scheduled JCL.
37. Optimizing the Target Job Stream, Part 2.
38. Executing the Upgrade on the z/OS Host (Phase 2 of 2).
39. Performing Intersection Table Maintenance.
40. Resuming the Siebel Upgrade Wizard on the Midtier After the Third Pause.
41. Reviewing Upgrade Log Files for Errors.
42. If the upgrade contains unacceptable errors, do the following:
    1. Restore the backup of the database.
    2. Correct the errors.
    3. Rerun the Database Server Configuration utility.
43. Manually Archiving Upgrade Log Files.
44. Installing New License Keys After Upgrade.
45. Back up the upgraded database.
46. Deleting Redundant Upgrade Files.

Postupgrade Tasks for Environment Setup

47. Updating File System Attachments.
48. Generate a Siebel Remote database template file. See Siebel Remote and Replication Manager Administration Guide and Upgrading Siebel Mobile and Dedicated Web Clients.
49. Generate database extracts for all Regional Servers in the deployment. See Upgrading Regional Servers.
50. Reset upgrade-specific parameters back to their defaults. See Resetting Database Server Configuration Parameters.
51. Checking for Inactivated EIM Table Columns.
52. Run database statistics. For more information on running statistics, see Generating RUNSTATS.

NOTE:  The production environment is now upgraded. The remaining sections deal with configuration and validation tasks.

Postupgrade Tasks for Configuration

53. If you exported data from interface tables before the upgrade, review the database and import the data as desired.
54. Upgrading to RC2 or AES Encryption.

Configure for Globalization

55. Upgrading to the Symbolic String Model.
56. Setting Up Your Environment to Support Global Time Zone.

Deploy Workflows

Activate and deploy workflows. To perform these tasks, see Siebel Business Process Designer Administration Guide.

57. Upgrading Seeded Workflows.
58. Upgrading Inbound Workflows.

Verify Application Integration

59. Verify that EAI and EIM integrations are set up correctly. For information on using EAI and EIM, see Overview: Siebel Enterprise Application Integration and Siebel Enterprise Integration Manager Administration Guide.
60. Updating Enterprise Application Integration (EAI) After Upgrade.

Postupgrade Tasks for Application Administration

61. Review the results of the Person and Organization merge. Make configuration changes as required.
62. Generating Reporting Relationships After Upgrade.
63. Validating Dock Objects and Rule Definitions.
64. Perform the tasks in Postupgrade Tasks for Applications to prepare for system testing.

Perform System Tests

65. Thoroughly test all applications.

Deploy to Users

66. If you have customized the configuration of Siebel Enterprise Server components, such as Siebel Servers, you must manually enter the customizations in the upgraded environments. See Going Live with Siebel Business Applications.
67. Use the Siebel Application Deployment Manager to migrate administrative data such as LOVs and responsibilities from development to production. See Going Live with Siebel Business Applications.
68. Use Siebel Packager to create language packs for remote installation. See Going Live with Siebel Business Applications.
69. Use Siebel Anywhere to create installation kits for deployment. See Siebel Anywhere Administration Guide.
70. Generate a Siebel Remote database template. See Siebel Remote and Replication Manager Administration Guide.
71. Set up database extraction for Siebel Mobile Web Clients. See Siebel Remote and Replication Manager Administration Guide.