O'Reilly logo

DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition by Michael Kyprianou, Steve Sanyal, Kevin Gashyna, David Martineau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuration

Spatial Extender can be configured using either the command line or the DB2 Control Center. To enter the CLP environment, type db2se. This is similar to the database CLP environments. You can enter Spatial Extender commands from this prompt or precede any command with the db2se from a regular prompt.

Each database in the database must be enabled to use Spatial Extender before a spatial column can be created. Enabling a database creates distinct types (UDTs), stored procedures, administration tables, and views needed for Spatial Extender to work. After a database is enabled, it will stay enabled until issuing the disable command. The selected database can be enabled and disabled with the following commands:

db2se ENABLE_DB database-name ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required