Enabling spatial support for migration to Db2 11

If you are migrating from Db2 10 to Db2 11 and had spatial support enabled on Db2 10, 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: This step is not required if you applied APAR PM92224/UK98018 to your DB2® 10 subsystem before migration and followed the ++HOLD instructions.

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.