Prepare db2 with spatial extender
---------------------------------

Preparing a db2 database needs the following steps:

1. After you created the db, use the db2se utility to do the following::
     
     db2se enable_db db_name

2. Next you need a Spatial Reference System (SRS).

   Pick an existing one::
     
     select srs_id,srs_name,coordsys_name from db2gse.st_spatial_reference_systems

   Or register your own using db2 spatial extender user guide (This is beyond of the scope of this documentation)::
     
     db2se create_srs .....

3. Now you should have a SRS_ID and SRS_NAME which will be used for table creation.::
     
     CREATE TABLE TILES0(location CHAR(64) NOT NULL ,data BLOB,CONSTRAINT TILES0_PK PRIMARY KEY(location))
     CREATE TABLE SPATIAL0 ( location CHAR(64) NOT NULL, GEOM db2gse.st_multipolygon NOT NULL ,CONSTRAINT SPATIAL0_PK PRIMARY KEY(location))
   
   If you prefer one table::
     
     CREATE TABLE SPATIAL0 ( location CHAR(64) NOT NULL, GEOM db2gse.st_multipolygon NOT NULL , data BLOB,CONSTRAINT SPATIAL0_PK PRIMARY KEY(location))

4. Register your geometry column::
     
     Usage: db2se register_spatial_column db_name
              [-userId user_id -pw password]
              [-tableSchema schema]
              -tableName SPATIAL0
              -columnName GEOM
              -srsName srs_name

5. And check it with::
     
     select srs_id,srs_name from db2gse.st_geometry_columns where table_schema='schema' and table_name='SPATIAL0' and column_name='GEOM'