Oninit cdi / Archive
Talk to an expert →

RE: Best way to fix extents of Baan db?

Posted in 2000

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

Martin, Wayne E. — — source: Informix-list mailing list archive (1991-1998)

Dbexport the database add alter table "syssometable" next size 256; in the database.sql file from the export dbimport the database Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Jukka [mailto:makiju@mbnet.fiS] Sent: Thursday, December 07, 2000 2:27 PM To: informix-list@iiug.org Subject: Best way to fix extents of Baan db? What is the best way to fix this situation? IDS 7.31.FC6. dbsname tabname num_of_extents total_size baan sysconstraints 147 77696 baan sysobjstate 146 73608 baan syscolumns 125 29576 baan syscoldepend 121 25472 baan sysfragments 114 18304 baan sysindexes 98 9088 baan systables 85 5248 baan systabauth 69 2560 sysmaster syscolumns 8 72

↪ replying to Martin, Wayne E.
Jukka — — source: Informix-list mailing list archive (1991-1998)

does this work with baan hash columns? Level-1 -Jukka Martin, Wayne E. <WMartin@kmart.com> wrote in message news:90qs5h$mga$1@news.xmission.com... > > Dbexport the database > add alter table "syssometable" next size 256; in the database.sql file from > the export > dbimport the database > > > > Wayne E. Martin > Informix Database Administrator > Kmart Corp. > > > > > > -----Original Message----- > From: Jukka [mailto:makiju@mbnet.fiS] > Sent: Thursday, December 07, 2000 2:27 PM > To: informix-list@iiug.org > Subject: Best way to fix extents of Baan db? > > > What is the best way to fix this situation? IDS 7.31.FC6. > > dbsname tabname num_of_extents total_size > baan sysconstraints 147 77696 > baan sysobjstate 146 73608 > baan syscolumns 125 29576 > baan syscoldepend 121 25472 > baan sysfragments 114 18304 > baan sysindexes 98 9088 > baan systables 85 5248 > baan systabauth 69 2560 > sysmaster syscolumns 8 72 > > >

Glossary