[Schema]
TableDirect=0
SysTables=0
ProcDirect=0
Delimiter=;
Description=DB2
Function_owner=FUNCSCHEMA
Function_name=FUNCNAME
Function_source=
Function_sql=Select FUNCSCHEMA,FUNCNAME,SPECIFICNAME,IOS_PER_INVOC,INSTS_PER_INVOC,IOS_PER_ARGBYTE,INSTS_PER_ARGBYTE,PERCENT_ARGBYTES,INITIAL_IOS,INITIAL_INSTS,CARDINALITY,SELECTIVITY from SYSSTAT .FUNCTIONS order by FUNCSCHEMA,FUNCNAME asc
Function_open=1
Table_owner=tabschema
Table_name=tabname
Table_source=
Table_sql=SELECT * FROM syscat.tables order by tabschema,tabname asc
Table_open=1
Table space_owner=
Table space_name=
Table space_source=
Table space_sql=
Table space_open=0
Trigger_owner=trigschema
Trigger_name=trigname
Trigger_source=
Trigger_sql=Select * from SYSCAT.TRIGGERS order by trigschema,trigname asc
Trigger_open=1
Package_owner=pkgschema
Package_name=pkgname
Package_source=
Package_sql=Select * from SYSCAT.PACKAGES order by pkgschema,pkgname asc
Package_open=1
Package body_owner=
Package body_name=
Package body_source=
Package body_sql=
Package body_open=0
Procedure_owner=procschema
Procedure_name=procname
Procedure_source=
Procedure_sql=Select * from SYSIBM.SYSPROCEDURES order by procschema,procname asc
Procedure_open=1
User_owner=
User_name=USERNAME
User_source=
User_sql=
User_open=0
View_owner=viewschema
View_name=viewname
View_source=TEXT
View_sql=Select VIEWSCHEMA,VIEWNAME,OWNER,SEQNO,VIEWCHECK,READONLY,VALID,QUALIFIER,FUNC_PATH,TEXT,DEFINER from SYSCAT  .VIEWS order by viewschema,viewname asc
View_open=1
Index_owner=indschema
Index_name=indname
Index_source=
Index_sql=Select * from SYSSTAT.INDEXES order by indschema,indname asc
Index_open=1
Synonym_owner=Owner
Synonym_name=Synonym_name
Synonym_source=
Synonym_sql=
Synonym_open=0
Role_owner=
Role_name=Role
Role_source=
Role_sql=
Role_open=0
Sequence_owner=seqschema
Sequence_name=seqname
Sequence_source=
Sequence_sql=select * from syscat.sequences order by seqschema,seqname asc
Sequence_open=1
User defined_owner=
User defined_name=
User defined_source=
User defined_sql=
User defined_open=0
[Plan]
Explain=delete SYSTEM.HTMLDB_PLAN_TABLE; explain plan into SYSTEM.HTMLDB_PLAN_TABLE for %s;
View=select * from SYSTEM.HTMLDB_PLAN_TABLE;
