Summary and Example

Restriction: This topic applies to Windows environments only.

The XDB Server fully supports the naming conventions and data storage structures that are available on a mainframe DB2 subsystem. Features include the following structures and objects:

Locations
Storage Groups
Databases
Table Spaces
Tables
Indexes

Example

The following is a scenario for creating a new location with two databases. Each database has a table space defined. One table in each database is created in a table space. The other table in each database is created without a table space.

Use the SQL Wizard to execute these commands (applies to Windows environments only). See the SQLWizard User's Guide or on-line help for information.

Use the Interactive SQL tool to execute these commands (applies to UNIX environments only). See the Reference Help for more information.

CREATE LOCATION testxdb 
    IN c:\xdb\testxdb\/xdb/test/xdb/;
SET LOCATION TO testxdb;
CREATE DATABASE testdb1;CREATE DATABASE testdb2;CREATE TABLESPACE ts4db1 IN testdb1;
CREATE TABLESPACE ts4db2 IN testdb2;
CREATE TABLE table1 (Field1 integer, Field2 integer) 
    IN DATABASE testdb1;
CREATE TABLE table2 (Field3 integer, Field4 integer) 
    IN testdb1.ts4db1;
CREATE TABLE tableA (FieldA integer, FieldB integer) 
    IN DATABASE testdb2;
CREATE TABLE tableB (FieldC integer, FieldD integer) 
    IN testdb2.ts4db2;
CREATE INDEX inx ON table1 (Field1);