Device Cleanup 
Author Message
 Device Cleanup

Quote:

> Have an older database (SQL 10.0.2 for AIX) that has been extended many
> times. I created a new database with less devices, but when I restored
> the older database dump into the new database I still got the
> fragmentation of the older database. What is the best way to remove this
> fragmentation? Is there a utility or a simple way to correct this?

> shane

The problem is that syssegments (one in every user database) is in sync
with sysusages (in master).  Each device fragment is tracked in
syssegments and there is no easy way to move a database into another
with less fragments.  The easiest way is to make a logical backup of the
database (sql scripts and bcp files is a cheap way), create a new
database with the correct fragmentation and then reload the data.  If
you are using declarative referential integrity (foreign key
constraints), the option is tougher to manage because tables have to be
reloaded in a specific order.  Several companies, including Platinum
technology (www.platinum.com), offer tools that support logical
backups.  Hope this helps.

Kyle Hachey,
Platinum technology, inc.



Tue, 29 Feb 2000 03:00:00 GMT
 Device Cleanup

Have an older database (SQL 10.0.2 for AIX) that has been extended many
times. I created a new database with less devices, but when I restored
the older database dump into the new database I still got the
fragmentation of the older database. What is the best way to remove this
fragmentation? Is there a utility or a simple way to correct this?

shane



Wed, 01 Mar 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. backup permissions? device error or device offline

2. Restore from database device not backup device

3. Moving database from shared device to new device

4. Backup error - Can't open dump device or device off line

5. Understanding Backup Devices and Temporary Bkp devices

6. DISK DEVICE vs TAPE DEVICE BACKUP

7. SQL 7 - Dumping Devices or creating backup device on a Network Drive

8. raw device or not raw device

9. trans device and data device

10. Raw devices Vs. File system devices

11. Character device v.s. block device

12. Cook device vs. Raw device


 
Powered by phpBB® Forum Software