Table TBASE2.TBASE2.EXPLAIN_INSTANCE Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163137990
1 EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163137990
2 SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163137990
3 SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163137990
4 SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163137990
5 EXPLAIN_OPTION char 1
6 SNAPSHOT_TAKEN char 1
7 DB2_VERSION char 7
8 SQL_TYPE char 1
9 QUERYOPT integer 4
10 BLOCK char 1
11 ISOLATION char 2
12 BUFFPAGE integer 4
13 AVG_APPLS integer 4
14 SORTHEAP integer 4
15 LOCKLIST integer 4
16 MAXLOCKS smallint 2
17 LOCKS_AVAIL integer 4
18 CPU_SPEED double 8
19 REMARKS varchar 254  √  null
20 DBHEAP integer 4
21 COMM_SPEED double 8
22 PARALLELISM char 2
23 DATAJOINER char 1

Table contained 2,536 rows at Fri Nov 14 16:57 EST 2008

Indexes:
ID Column(s) Type Sort Constraint Name
1 EXPLAIN_REQUESTER + EXPLAIN_TIME + SOURCE_NAME + SOURCE_SCHEMA + SOURCE_VERSION Must be unique Asc/Asc/Asc/Asc/Asc SQL070118163137940

Close relationships  within of separation: