Thursday, March 6, 2008

TDW 2.1 DB2 Schema

The schema for TDW 2.1 is not published and I find myself having to reference table names and such quite often. The download listed below is the DDL from DB2 8.2 with the historical Windows tables.

I will post additional DDL in the coming days - Linux and Unix will be included. The tables for TDW are generated automatically when you select atrribute groups to collect for historical reasons.

http://www.gulfsoft.com/downloads/tdw21.ddl

So hopefully this will at least satisfy some DBA curiosity on what the table structures look like.

No comments: