Enabling the Db2 Spatial Extender

You can enable the Db2® Spatial Extender component to store geospatial data in special data types and provide a spatial grid index to improve performance.

Procedure

Note: If your deployment uses the restricted-v2 SCC, commands that require switching users or elevated privileges are not supported. Perform all steps as the Db2 instance user within the container. For more information, see Deploying Db2 or Db2 Warehouse with non-root deployment.

  1. Exec into the Db2 pod: 
    oc exec -ti c-db2ucluster-sample-db2u-0 bash
  2. Become the Db2 instance owner: 
    su - db2inst1
  3. Enable Spatial Extender by running the following command: 
    db2se enable_db database_name

What to do next

For more information, see Db2 Spatial Extender.