DB2 Version 10.1 for Linux, UNIX, and Windows

Central view of RDF stores

Starting with DB2® Version 10.1 Fix Pack 2 and later fix packs, Resource Description Framework (RDF) now lists all RDF stores that are present in a particular database within one table. Query the SYSTOOLS.RDFSTORES table to view all the RDF stores.

The SYSTOOLS.RDFSTORES table is created the first time that the createrdfstore or createrdfsoreandloader command and API is issued for a database.

Table 1. SYSTOOLS.RDFSTORES table schema
Column name	Data type	Nullable	Description
STORENAME	VARCHAR(256)	NO	Name of the RDF store
SCHEMANAME	VARCHAR(256)	NO	Name of the schema for the RDF store
STORETABLE	VARCHAR(256)	NO	Name of the metadata table for the RDF store
Primary key		NO	Primary key

To list all the RDF stores and their corresponding schema names in a database, issue the following query:

SELECT storeName, schemaName FROM SYSTOOLS.RDFSTORES

The following sample output is returned:

STORENAME       SCHEMANAME
---------------------------
STAFFING	  DB2ADMIN
SAMPLSTORE      DB2ADMIN

2 record(s) selected.