Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
Hi,
We have severe problems with some of our tables having reached nearly 200 extents, so I am having to do an urgent rebuild. My method is:
unload data using sql command unload table to file
select * from table;
dbchema on the table to gather index/grants info.
drop/rename existing table
recreate with new initial and next extents
dbload data back in.
(I really want a new initial extent, hence not using onunload/onload)
My problem is that dbschema does not cope with synonyms - if I have synonyms created in a different database within the same informix server which reference the table to be dropped for instance.
Are there any tables in sysmaster database which show all synonyms created against a table, regardless of the database it resides in? Or is there any other way in which I can ensure I have all synonyms before I drop the table and lose all synonyms associated?
Thank you!
We have severe problems with some of our tables having reached nearly 200 extents, so I am having to do an urgent rebuild. My method is:
unload data using sql command unload table to file
select * from table;
dbchema on the table to gather index/grants info.
drop/rename existing table
recreate with new initial and next extents
dbload data back in.
(I really want a new initial extent, hence not using onunload/onload)
My problem is that dbschema does not cope with synonyms - if I have synonyms created in a different database within the same informix server which reference the table to be dropped for instance.
Are there any tables in sysmaster database which show all synonyms created against a table, regardless of the database it resides in? Or is there any other way in which I can ensure I have all synonyms before I drop the table and lose all synonyms associated?
Thank you!
