Oninit cdi / Archive
Talk to an expert →

dbschema with fragment expressions?

Posted in 2000

Topics: General Discussion

Matthew H. Devlin III — — source: Informix-list mailing list archive (1991-1998)

how can I get a shema of the database that reflects the fragmentation expressions I have in place? If there is no way with dbschema is there another way? We have over 500 tables in the database with about 100 of them fragmented and I don't want to have to rewrite the fragments.

↪ replying to Matthew H. Devlin III
Alan Caldera — — source: Informix-list mailing list archive (1991-1998)

Matthew, dbschema -d <database> -ss filename.sql The key of course is -ss (server specific). All dbspaces and frag expressions as well as extent and locklevel info will be output as part of the .sql file. HTH, Alan "Matthew H. Devlin III" wrote: > how can I get a shema of the database that reflects the fragmentation > expressions I have in place? If there is no way with dbschema is there > another way? We have over 500 tables in the database with about 100 of > them fragmented and I don't want to have to rewrite the fragments.

Glossary