Enabling spatial support for migration to Db2 13

If you are migrating from Db2 12 to Db2 13 and had spatial support enabled on Db2 12, you must enable your Db2 subsystem for spatial support again.

Before you begin

Before you enable the Db2 subsystem for spatial support, your TSO user ID must have SYSADM authority on the Db2 subsystem.

Procedure

To enable a Db2 subsystem for spatial support if you migrated from the previous version of Db2 for z/OS®:

  1. Customize and submit the DSNTIJCL job from the SDSNSAMP library.
    This job binds the Db2 ODBC application plan. The prolog for the DSNTIJCL job contains instructions for modifying the job.
  2. Customize and submit the DSN5SBND job from the SDSNSAMP library.
    The expected return code for the DSN5SBND job is 0 (zero).
    Note: If you are migrating from DB2® 10, you first need to migrate to Db2 11 and then migrate to Db2 12, then follow the above steps 1 through 2.

    Start of changeIf you have not already done so, run the DSN5SCLP program to enable spatial support, and specify the option '-update v10' for the enable_spatial command.End of change

Results

The expected return codes are 0 (zero) and 4 for the DSNTIJCL job.

What to do next

Now, the Db2 subsystem is enabled for spatial support. You can submit the DSN5SCMD JCL in the SDSNSAMP library to verify that the Spatial functions are correctly enabled.