DBREORG(1)		       (dbreorg	1.8)		    DBREORG(1)



     NAME
	  dbreorg - generates SQL to reorg a database table or index

     SYNOPSIS
	  dbreorg -d dbname -t tabname -e extent [-n next] [-s
	  dbspace] file
	  dbreorg -d dbname -i idxname [-s dbspace] file
	  dbreorg -r [-m max]
	  dbreorg -d dbname -t tabname -schema file
	  dbreorg -d dbname -t tabname -views file

     DESCRIPTION
	  Dbreorg will generate	SQL statements that:
	       * re-organize an	Informix-ONLINE	table (or index)
	       * create	an Informix-ONLINE table schema
	       * rebuild all dependent views of	an Informix-ONLINE
	  table

     OPTIONS
	  -d   database	name

	  -t   table name

	  -e   extent size

	  -i   index name

	  -n   next size

	  -s   dbspace

	  file the basename of the file(s) to be generated

	  -r   generate	extent report

	  -m   report tables with greater than max extents

	  -schema
	       generates a table schema	only (with views)

	  -views
	       generates a table's views only

     NOTES
	  The default value for	dbspace	is the dbname

	  The default value for	max extents is 8

     SUPPORT
	  Send bug reports to Dave Snyder <dave@snide.com>





     Page 1					      (printed 3/6/03)