anyone have an automagical update statisitics script generator?

[WiccaChic]

I have seen an example of such a thing written in 4gl, but I was wondering if anyone had something written in sql and/or a shell scripting type language? I do not speak 4gl and if I use such a thing I want to be able to tweak and customize it and I can do sql and corn/korn/sh.
-thanks

 

[olded]

Hi:

Check out the software repository at

http://www.iiug

This is a good website. There's a ton of software.

There's a script called upd_stats that might do what you want at:

http://www.iiug.org/software/index_DBA.html

Regards,


Ed

 

[mjldba]

Hi WiccaChic,

Email me & I'll send you the ksh script I use

michael.lasky@niagaracounty.com

 

[olded]

Michael:

Have you submit your script to the FAQ?

Ed

 

[vpshriyan]

Hi Michael,

Yes, Please post your script in the FAQ area of this Forum if you don't mind. Let rest of the members benefit from it.

Regards,
Shriyan

 

[mjldba]

FAQ has been posted

Good luck to all

Mike

 

[vpshriyan]

Hi Mike,

Thank you for sharing the customised script. Nice script indeed. I have not checked and benchmarked it for performance thoroughly, But, it is based on systables.nrows column value. The script generates statistics related statements, only if the column contains a non-zero value.

For a newly created and loaded table, systables.nrows shows zero value unless, an update statistics low is fired on that table. For a freshly imported database, using dbimport one need to issue:

update statistics low for table;

statement, before firing this script, inorder generate the statistics related statements.

Thanks once again.

Regards,
Shriyan

 

[mjldba]

Hi Shriyan,

People helping people, that's what it's all about, right?

Take care - Mike