Informix

lg_IIUG_url_text_logo.gif

Announcements

  • Please vote for Informix in the 2020 DBTA Reader’ Choice Awards!

    By: Cindy Lichtenauer Cindy Lichtenauer , 22 days ago

    We need you to help show you love of Informix.  DBTA has opened up their Annual voting for information management solutions, products, and services.  Hurry a place you vote, voting closes Wednesday, May 8th.  Thanks for your support.

Latest Posts

  • Profile Picture

    RE: how to grab the update statistics sql statements ...

    By: Eric Vercelletto , an hour ago

    Thanks Markus, this one is neat �� Beautiful one liner ! And thank you for the other solutions too ( Lester, Art, Doug ) I have been rude not to thank you, but a bit overload here. Thanks all!

  • Profile Picture

    RE: how to grab the update statistics sql statements ...

    By: Markus Holzbauer , an hour ago

    OOps - bugfix: $ dbschema -d $DATABASE -hd all | nawk 'BEGIN{S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n")}{if($1~/^Distribution/){split($3,T,".");OT=T[1]"."T[2];C=C","T[3]};if($0~/ ...

  • Profile Picture

    RE: how to grab the update statistics sql statements ...

    By: Markus Holzbauer , 2 hours ago

    and if someone prefer multi column update stats: dbschema -d DATABASE -hd all | nawk 'BEGIN{S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n")}{if($1~/^Distribution/){split($3,T,".");OT=T[1]"."T[2];C=C","T[3]};if($0~/ ...

Latest Articles

  • Profile Picture

    Informix for the Future - 14.10 and Beyond

    By: Isaiah Brown 7 months ago

    In today’s world, companies need to be able to derive insights from their data no matter where it is – and that’s what Informix is all about. No matter the complication, Informix is built to be your partner on the journey towards maximizing your data. ...

Community Members
339 Members
Carlton Doe
group Admin
Rajesh Govindan
group Admin
Scott Hayes
group Admin
Cindy Lichtenauer
group Admin
Scott Pickett
group Admin
Hidden Member
group Admin
MILIND Tamaskar
group Admin
Carrie Tutino
group Admin
Mohammad AboSoud
John David Adamski
Rajat Agrawal
Sheshnarayan Agrawal
Paul Anderson
Gary Andrus
Laura Arreguín
Ramesh Arumugam
Nicholas Arvanitakis
umut aymakoglu
fauziah ayob
Theo B
Elisabeth Bach
Amogh Bagade
MIchał Bąkowski
Dave Baligo