Migrating a Db2 for z/OS subsystem to Db2 13 at function level 100

The migration process for Db2 13 has a single phase. However, many new capabilities and enhancements in Db2 13 remain unavailable until you issue an ACTIVATE command to activate function level 500 or higher.

Before you begin

  • Read all information in Preparing your system to install or migrate to Db2 13.
  • Follow the documented migration procedures carefully.
    Attention: Failure to follow documented migration procedures can cause unpredictable results after migration.
  • Activate the last Db2 12 function level, function level 510, as described in Activate function level 510 in Db2 12.
  • Apply the fallback SPE (APAR PH37108) and stop and restart Db2 12 after the fallback SPE is applied, for every Db2 subsystem or data sharing member that you plan to migrate to Db2 13.

    Important: Inactive members that never started in Db2 12 with the fallback SPE (APAR PH37108) applied cannot start after the first data sharing member is migrated to Db2 13 at function level 100.
  • Ensure that Db2 12 is at the appropriate service level. See Required maintenance for Db2 13 installation or migration.
  • If your Db2 environment contains PBR RPN table spaces, APAR PH61633 is an important PE fix that you must apply on all data sharing members before migrating to or activating function levels in Db2 13.
    Attention: If your Db2 environment contains PBR RPN table spaces, do not migrate any data sharing members to function level V13R1M100, or activate function level V13R1M500 or higher, until you apply the PTF for PH61633 on all data sharing members and complete all ++HOLD actions. For more information, see the 21 June 2024 Red Alert.
  • When migrating a data sharing group to Db2 13, complete the migration steps for the first member to Db2 13 at function level 100 before starting any other members on Db2 13. For more information, see Migrating an existing data sharing group to Db2 13.
Tip: After you apply the PTF for APAR PH50072 in Db2 12, you can get a migration readiness report in the DSN7100I message by issuing DISPLAY GROUP command with the DETAIL keyword. The report includes a reason if your environment is not ready for migration to Db2 13. See Check readiness for migration to Db2 13.

About this task

When you start Db2, the code level of the starting Db2 is compared to the code level that is required by the current Db2 catalog. If the starting Db2 has a code-level mismatch with the catalog, Db2 does not start and a message is issued.

Tip: Start of changeNo structural changes are applied to Db2 catalog objects with the catalog updates in this task. The first updates to Db2 catalog objects for Db2 13 occur later, when you update the catalog for function level V13R1M501 or higher.End of change

Refer to the Db2 Program Directory for keyword specifications that are used for Preventive Service Planning (PSP) and for information about the service levels of any coupling facilities. You can use the z/OS® DISPLAY CF command to display the service level of coupling facilities. Check Information/Access or the ServiceLink facility of IBMLink for PSP information before you migrate. Or, to help you identify required service, you can instead use enhanced HOLDDATA and fix categories (FIXCATs), which provide a simplified, automated method of identifying and applying missing PTFs that are required for installation or migration. Also, check monthly for current information about Db2.

Restriction: After migration to Db2 13, the administrative task scheduler is disabled until you run job DSNTIJRT.

Procedure

To migrate a Db2 for z/OS subsystem to Db2 13, complete the following steps:

  1. Estimate storage needs for your Db2 13 environment. For more information, see Storage requirements for Db2 for z/OS.
  2. If you are using distributed data, install TCP⁄IP, VTAM, or both. For more information, see Connecting distributed database systems .
  3. If you plan to use data sharing, set up a Parallel Sysplex®. For more information, see Parallel Sysplex requirements for Db2 data sharing.
  4. Use SMP/E to load the Db2 13 libraries. For more information, see Making the Db2 product code available.
    Remember: If you copy Db2 library data sets from one system to another, such as for installing a related test or production subsystem, ensure that you copy all of the Db2 library data sets to the same location. For example, if you copy the SDNSLOAD data set from one system to another but omit the DBRMLIB data set, the resulting mismatch can cause job DSNTIJRT to fail with SQLCODE -812.

    If you plan to use the callable SQL interface of Db2, see Configuring Db2 ODBC and running sample applications for the additional installation jobs that you need to run. If you plan to use Db2 for z/OS Java™ Edition, you must run more installation jobs. For more information, see Installing the IBM® Data Server Driver for JDBC and SQLJ.

  5. Install the required service on Db2 12. For information about the required service to apply, see the Program Directory.
    Important: Inactive members that never started in Db2 12 with the fallback SPE (APAR PH37108) applied cannot start after the first data sharing member is migrated to Db2 13 at function level 100.
  6. Check for release incompatibilities, and make the necessary changes in your applications. For more information, see Make adjustments for incompatible changes in Db2 13.
  7. Generate tailored JCL jobs for migrating to Db2 13. You can use the DSNTIJBC batch job or the Db2 installation CLIST.
    Start of change
    Tip: Start of change You can avoid working through the Db2 installation CLIST panels in interactive mode by running a batch job with valid input files to generate the required JCL jobs and input files with a background process. See Generating tailored Db2 migration or function level activation jobs in the background.End of change
    To generate the required JCL jobs and input files with a background process, complete the following steps:
    1. Customize the DSNTIDOM parameter override file by following the instructions in the file.
    2. Customize the DSNTIJBC job. For example, if prefix.SDSNSAMP(DSNTIDOM) is the customized parameter override file, you can specify the following values in the IPSTART command in DSNTIJBC.
        ISPSTART CMD(%DSNTINSB + 
          OVERPARM(prefix.SDSNSAMP(DSNTIDOM)) + 
          ) BREDIMAX(1)
    3. Submit the customized DSNTIJBC job.
    End of change
    Start of changeTo generate the required JCL jobs and input files with the Db2 installation CLIST in interactive mode, complete the following steps. For more information, see Generating tailored installation, migration, or function level activation jobs by running the Db2 installation CLIST in interactive mode.End of change
  8. Complete the migration tasks that are listed in the following table.
    Tip: Tasks that are marked optional in the following table are not strictly required for a successful migration to Db2 13. However, they are generally recommended as best practices, and some of them might be required in your Db2 environment.
    Task number Migration task Optional task? Jobs to run for this task
    1 Complete all premigration tasks  
    • DSNTIJPE
    2 Connect Db2 to TSO  
    • DSNTIJVC
    3 Connect Db2 to IMS Yes  
    4 Connect CICS to Db2 Yes  
    5 Stop Db2 12 activity    
    6 Back up your Db2 12 volumes Yes  
    7 Define Db2 13 initialization parameters  
    • DSNTIJUZ
    • DSNTIJUA
    • DSNTIJUM
    8 Start of changeConvert the BSDS to support more active logsEnd of change Yes
    • DSNTIJCU
    9 Establish subsystem security Yes
    • DSNTIJRA
    10 Define Db2 13 to IRLM and MVS  
    • DSNTIJMV
    11 Update Db2 address space start and language procedure definitions  
    • DSNTIJMA
    • DSNTIJMW
    • DSNTIJMP
    • DSNTIJMJ
    12 Define system data sets  
    • DSNTIJIN
    13 Define user authorization exit routines Yes
    • DSNTIJEX
    14 Refresh the z/OS definition of Db2    
    15 Start Db2 13    
    16 Tailor the catalog for Db2 13  
    • DSNTIJTC
    17 Prepare dynamic SQL program  
    • DSNTIJTM
    18 Bind SPUFI and DCLGEN and user-maintained database activity  
    • DSNTIJSG
    19 Configure Db2 for running stored procedures and user-defined functions Yes
    • DSNTIJRW
    20 Set up Db2-supplied routines  
    • DSNTIJRT
    • DSNTIJRV
    21 Convert EXPLAIN tables to the current format  
    • DSNTIJXA
    22 Verify views  
    • DSNTIJVR
    23 Take an image copy of the Db2 13 catalog  
    • DSNTIJIC
    24 Verify migration of Db2 12 IVP objects to Db2 13 Yes (specific steps only)
    • DSNTEJ2A
    • DSNTEJ2C
    • DSNTEJ2D
    • DSNTEJ2E
    • DSNTEJ2F
    • DSNTEJ2P
    • DSNTEJ3M

    When you complete the tasks in the preceding table, Db2 13 is available for use at function level 100.

What to do next

  1. When you no longer require the option to fall back to Db2 12, and you are ready to use new capabilities in Db2 13, you can activate function level 500 or higher. For more information, see Activating Db2 13 function level 500 or higher. For more information about the new-function capabilities in all available function levels, see Db2 13 function levels.
    Important: Do not issue the ACTIVATE command or run job DSNTIJAF for activation of Db2 13 until you are certain that the subsystem or data sharing group can proceed on Db2 13, without the possibility of falling back to or coexistence with Db2 12. In data sharing, the ACTIVATE command has group scope. Fallback and coexistence become impossible with the successful activation of function level 500 or higher.
  2. Install, configure, and verify Db2-supplied routines that depend on Db2 13 function levels, as described in Installing and configuring Db2-supplied routines that use new function: DSNTIJRT.
  3. Verify the successful migration to Db2 13, as described in Verifying successful migration to Db2 13.