Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Defragmenting the system tables

Status
Not open for further replies.
testhandle

testhandle

Technical User
Mar 14, 2003
42
GB
Hi,

Some of the system tables is taking more extetns (14 extents). Is there any way to defragment these system tables.

informix.sysprocplan
informix.sysprocbody
informix.syscolumns


Thanks
 
Sort by date Sort by votes
I know for Informix 7SE there is a tool called secheck. Might be worth having a look. This tool is useful for repairing indicies on tables, and maybe used for defragmenting.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
128
jamescpp
jamescpp
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
87
KaronW
KaronW
evgeniosc
  • Locked
  • Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
95
evgeniosc
evgeniosc
omkhan
  • Locked
  • Question
accoring thread404-451532 the solution is given in this link http://www-01.ibm.com/support/docview.w
Replies
1
Views
85
PHV
PHV
marcq
  • Locked
  • Question
Table space usage vs tables
Replies
0
Views
46
marcq
marcq

Part and Inventory Search

Sponsor

Back
Top