FAQ
# Name : nextx
# Author : Tom Hogarty
# Program : Integrated script/awk program to read/format/output
# the current next extent sizes in a database.
# Syntax : nextx >>extents.sql
# ( update the new db calling [isql|dbaccess] <dbname> extents )
# call as user informix
>/tmp/tom
echo " select 'EXTENTS',
owner,
tabname,
nextsize
from systables
where owner <> 'informix'
order by systables.owner,
systables.tabname;" >/tmp/tom
# edit the following line
[isql|dbaccess] <dbname> - </tmp/tom |
awk '
$0 ~ /EXTENTS/ { tabname=hoch1$2hoch2$3
nextsize=$4*2
printf "%12s %24s %18s %4s %15s\\n",
"ALTER TABLE ",tabname," MODIFY NEXT SIZE ",
nextsize, "; COMMIT WORK ;"
} ' hoch1=\\" hoch2=\\".
----snip here ----------------------------------------------------------------
Hope this helps
Tom Hogarty Usual Disclaimers apply Online 5.01.U
SNI ----------------------- RM600, RM400, MXI
Paderborn Phone: 049-5251-8-11602 Sinix, Sco etc.
Germany Fax : 049-5251-8-11599 (Online 6.0 on desk)