[dbo].[dbh_sql

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:12:37 AM Wednesday, March 07, 2007
Last Modified	2:23:32 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)	Identity
	sql_id	decimal(8,0)	5	1 - 1
$Indexes dbh_sql_udb_snapshot_ts_idx: capture_id\snapshot_timestamp$	capture_id	decimal(8,0)	5
$Indexes dbh_sql_udb_snapshot_ts_idx: capture_id\snapshot_timestamp$ $Indexes dbh_sql_udb_inst_snapts_idx: var1\snapshot_timestamp$	snapshot_timestamp	datetime	8
	sql_owner	varchar(256)	256
	sql_parser	varchar(256)	256
	agent_id	decimal(12,0)	9
	appl_id	varchar(32)	32
	appl_name	varchar(256)	256
	os_user	varchar(256)	256
	agent_rows_read	decimal(12,0)	9
	agent_rows_written	decimal(12,0)	9
	agent_usr_cpu	decimal(16,6)	9
	agent_sys_cpu	decimal(16,6)	9
	stmt_rows_read	decimal(12,0)	9
	stmt_rows_written	decimal(12,0)	9
	stmt_rows_accessed	decimal(12,0)	9
	num_agents	decimal(12,0)	9
	agents_top	decimal(12,0)	9
	stmt_type	decimal(4,0)	5
	stmt_operation	decimal(4,0)	5
	section_number	decimal(12,0)	9
	query_cost_estimate	decimal(12,0)	9
	query_card_estimate	decimal(12,0)	9
	degree_parallelism	decimal(12,0)	9
	stmt_sorts	decimal(12,0)	9
	total_sort_time	decimal(16,6)	9
	sort_overflows	decimal(12,0)	9
	int_rows_deleted	decimal(12,0)	9
	int_rows_updated	decimal(12,0)	9
	int_rows_inserted	decimal(12,0)	9
	fetch_count	decimal(12,0)	9
	stmt_start	datetime	8
	stmt_stop	datetime	8
	stmt_usr_cpu	decimal(16,6)	9
	stmt_sys_cpu	decimal(16,6)	9
	stmt_elapsed_time	decimal(16,6)	9
	blocking_cursor	decimal(12,0)	9
	stmt_partition_number	decimal(12,0)	9
	cursor_name	varchar(256)	256
	creator	varchar(256)	256
	package_name	varchar(30)	30
	diff_rows_read	decimal(12,0)	9
	diff_rows_written	decimal(12,0)	9
	diff_rows_accessed	decimal(12,0)	9
	diff_cpu	decimal(16,6)	9
	stmt_text	text	max
	tag	varchar(50)	50
	folder	varchar(50)	50
	description	varchar(2000)	2000
	plan_owner	varchar(30)	30
	db_connect_string	varchar(400)	400
	db_name	varchar(50)	50
	db_version	varchar(30)	30
	create_date	datetime	8
	verify_date	datetime	8
	start_capture_time	datetime	8
	end_capture_time	datetime	8
	capture_interval	decimal(12,2)	9
$Indexes dbh_sql_udb_inst_snapts_idx: var1\snapshot_timestamp$	var1	varchar(400)	400
	var2	varchar(400)	400
	var3	varchar(400)	400
	var4	varchar(400)	400
	var5	varchar(400)	400
	text1	varchar(1)	1
	dec1	decimal(12,2)	9
	dec2	decimal(12,2)	9
	dec3	decimal(12,2)	9
	dec4	decimal(16,6)	9
	dec5	decimal(16,6)	9
	float1	float	8
	float2	float	8
	float3	float	8
	date1	datetime	8
	date2	datetime	8
	date3	datetime	8

	Name	Columns	Unique
	dbh_sql_udb_pk	sql_id
	dbh_sql_udb_inst_snapts_idx	var1, snapshot_timestamp
	dbh_sql_udb_snapshot_ts_idx	capture_id, snapshot_timestamp

Name	Delete	Columns
dbh_sql_udb_capture_fk	Cascade	capture_id->[dbo].[dbh_captures].[capture_id]

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[dbh_sql_udb]
(
[sql_id] [decimal] (8, 0) NOT NULL IDENTITY(1, 1),
[capture_id] [decimal] (8, 0) NULL,
[snapshot_timestamp] [datetime] NOT NULL,
[sql_owner] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_parser] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[agent_id] [decimal] (12, 0) NOT NULL,
[appl_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[appl_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os_user] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[agent_rows_read] [decimal] (12, 0) NULL,
[agent_rows_written] [decimal] (12, 0) NULL,
[agent_usr_cpu] [decimal] (16, 6) NULL,
[agent_sys_cpu] [decimal] (16, 6) NULL,
[stmt_rows_read] [decimal] (12, 0) NULL,
[stmt_rows_written] [decimal] (12, 0) NULL,
[stmt_rows_accessed] [decimal] (12, 0) NULL,
[num_agents] [decimal] (12, 0) NULL,
[agents_top] [decimal] (12, 0) NULL,
[stmt_type] [decimal] (4, 0) NULL,
[stmt_operation] [decimal] (4, 0) NULL,
[section_number] [decimal] (12, 0) NULL,
[query_cost_estimate] [decimal] (12, 0) NULL,
[query_card_estimate] [decimal] (12, 0) NULL,
[degree_parallelism] [decimal] (12, 0) NULL,
[stmt_sorts] [decimal] (12, 0) NULL,
[total_sort_time] [decimal] (16, 6) NULL,
[sort_overflows] [decimal] (12, 0) NULL,
[int_rows_deleted] [decimal] (12, 0) NULL,
[int_rows_updated] [decimal] (12, 0) NULL,
[int_rows_inserted] [decimal] (12, 0) NULL,
[fetch_count] [decimal] (12, 0) NULL,
[stmt_start] [datetime] NULL,
[stmt_stop] [datetime] NULL,
[stmt_usr_cpu] [decimal] (16, 6) NULL,
[stmt_sys_cpu] [decimal] (16, 6) NULL,
[stmt_elapsed_time] [decimal] (16, 6) NULL,
[blocking_cursor] [decimal] (12, 0) NULL,
[stmt_partition_number] [decimal] (12, 0) NULL,
[cursor_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creator] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[package_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[diff_rows_read] [decimal] (12, 0) NULL,
[diff_rows_written] [decimal] (12, 0) NULL,
[diff_rows_accessed] [decimal] (12, 0) NULL,
[diff_cpu] [decimal] (16, 6) NULL,
[stmt_text] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tag] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[folder] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[plan_owner] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_connect_string] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_version] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[create_date] [datetime] NULL,
[verify_date] [datetime] NULL,
[start_capture_time] [datetime] NULL,
[end_capture_time] [datetime] NULL,
[capture_interval] [decimal] (12, 2) NULL,
[var1] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var2] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var3] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var4] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[var5] [varchar] (400) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text1] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dec1] [decimal] (12, 2) NULL,
[dec2] [decimal] (12, 2) NULL,
[dec3] [decimal] (12, 2) NULL,
[dec4] [decimal] (16, 6) NULL,
[dec5] [decimal] (16, 6) NULL,
[float1] [float] NULL,
[float2] [float] NULL,
[float3] [float] NULL,
[date1] [datetime] NULL,
[date2] [datetime] NULL,
[date3] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_udb] ADD CONSTRAINT [dbh_sql_udb_pk] PRIMARY KEY CLUSTERED ([sql_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_udb_snapshot_ts_idx] ON [dbo].[dbh_sql_udb] ([capture_id], [snapshot_timestamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [dbh_sql_udb_inst_snapts_idx] ON [dbo].[dbh_sql_udb] ([var1], [snapshot_timestamp]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[dbh_sql_udb] ADD CONSTRAINT [dbh_sql_udb_capture_fk] FOREIGN KEY ([capture_id]) REFERENCES [dbo].[dbh_captures] ([capture_id]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[dbh_sql_udb] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbh_sql_udb] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbh_sql_udb] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbh_sql_udb] TO [udmadmin_group]
GO