Re: extents
Yes but BESURE to dbschema the tables first with all dbschema information.
do a dbschema -- to get all of the fields. You want to include constraints
and permissions.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Mon, 6 May 1996, Thuc Nguyen wrote:
} I am newly hired DBA.
}
} I ran tbcheck -ce on Online 5.03 on HP Box.
}
} Here is the info..
}
} WARNING:TBLSpace coris:informix.syscolumns has more than 8 extents
} WARNING:TBLSpace coris:informix.sysprocbody has more than 8 extents
} WARNING:TBLSpace coris:informix.sysprocplan has more than 8 extents
} WARNING:TBLSpace coris:informix.account has more than 8 extents
} WARNING:TBLSpace coris:informix.case_hist has more than 8 extents
} WARNING:TBLSpace coris:informix.errorlog has more than 8 extents
} WARNING:TBLSpace coris:informix.event has more than 8 extents
} WARNING:TBLSpace coris:informix.summary_event has more than 8 extents
} WARNING:TBLSpace coris:informix.trans has more than 8 extents
} WARNING:TBLSpace coris:informix.judgment has more than 8 extents
} WARNING:TBLSpace coris:informix.judgment_debtor has more than 8 extents
} WARNING:TBLSpace coris:informix.judgment_delt has more than 8 extents
}
} I was told by an Informix Consultant to do the followings:
}
} 1. unload the table to a flat file
}
} 2. drop the table
}
} 3. create the table, get the extent size, next extent size, and row
} leveling locking.
}
} 4. load the tape...this willneed to have constraints dropped
} and trigger dropped.
}
} I cant find enough information about that script in any informix manual.
}
} Is an Informix Consultant right?
}
} Thanks,
}
} thuc
}