Re: Extent/Next Extent

Hello, Theres a script/program in http://www.iiug.org that can help you do that or you can use this script: $1 == ");" { print ")" if ( nuro != 0 ) { exsi = insi * 1.25 * nuro exsi = exsi + nuro / 2016 * rosi * 2048 exsi = exsi / 1024 / 16 nesi = exsi / 8 exsi = (1 + int(exsi)) * 16 nesi = (1 + int(nesi)) * 16 print "extent size" , exsi print "next size" , nesi } print "lock mode row;" getline } $2 == "TABLE" { rosi = $7 insi = $16 } $2 == "unload" { nuro = $11 } {print $0} To run it: awk -f script_name schema_file The schema_file is the sql file generated by the export command. This script adds the 3 lines: extent size xxx next size xxx lock mode row; Regards Serafim Fonseca > > What's the best way to determine the Extent size and Next Extent size in > Informix ? > > Greg Kuntz > > ========================================================================== Serafim Fonseca e-mail: sf@growela.pt Growela Portuguesa Calcado, Lda. phone : +351 2 9866300 S. Pedro Avioso, Castelo fax : +351 2 9812212 4470 Maia - PORTUGAL