-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbreorg.1
72 lines (72 loc) · 1.19 KB
/
dbreorg.1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
.\"
.\" @(#)dbreorg.1 1.8 11/10/97 11:58:37 11/17/97 12:01:34
.\"
.TH DBREORG 1 "dbreorg 1.8"
.SH NAME
dbreorg \- generates SQL to reorg a database table or index
.SH SYNOPSIS
dbreorg \-d dbname \-t tabname \-e extent [\-n next] [\-s dbspace] file
.br
dbreorg \-d dbname \-i idxname [\-s dbspace] file
.br
dbreorg \-r [-m max]
.br
dbreorg \-d dbname \-t tabname \-schema file
.br
dbreorg \-d dbname \-t tabname \-views file
.SH DESCRIPTION
.I Dbreorg
will generate SQL statements that:
.br
* re-organize an Informix-ONLINE table (or index)
.br
* create an Informix-ONLINE table schema
.br
* rebuild all dependent views of an Informix-ONLINE table
.SH OPTIONS
.TP
.B \-d
database name
.TP
.B \-t
table name
.TP
.B \-e
extent size
.TP
.B \-i
index name
.TP
.B \-n
next size
.TP
.B \-s
dbspace
.TP
.B file
the basename of the file(s) to be generated
.TP
.B \-r
generate extent report
.TP
.B \-m
report tables with greater than
.I max
extents
.TP
.B \-schema
generates a table schema only (with views)
.TP
.B \-views
generates a table's views only
.SH NOTES
The default value for
.I dbspace
is the
.I dbname
.PP
The default value for
.I max
extents is 8
.SH SUPPORT
Send bug reports to Dave Snyder <dave@snide.com>