Enabling the Spatial Analytics component

Enabling the Spatial Analytics component for a database supplies that database with the resources it needs to create spatial columns and to work with spatial data.

Before you begin

Ensure that your user ID has at least one of the following authorities for the database for which the Spatial Analytics component is to be enabled:
  • EXECUTE privilege on the procedure SYSINSTALLOBJECTS
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Procedure

Issue the following command: 
CALL SYSPROC.SYSINSTALLOBJECTS('GEO', 'C', CAST (NULL AS VARCHAR(128)), CAST (NULL AS VARCHAR(128)))
This command:
  • Installs the Spatial Analytics metadata tables in the SYSTOOLSPACE table space and SYSGEO schema
  • Grants the EXECUTE privilege for all spatial functions to PUBLIC
  • Creates the role SYSGEOADM and grants to it the privileges that are needed to run the administrative stored procedures