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®:
-
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.
- 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.