Skip to Content
0
Former Member
Aug 04, 2005 at 05:26 PM

Update statistics why/how

10 Views

Dear Forum

I am running a light weight OLTP workload with MaxDB and

am hitting my first bottlenecks. It was suggested that I run update statistics. I can't seem to get it working according to the online documentation. I need to run

exec_xpu or xpu. Neither works. The database is ONLINE.

Any idea what I'm doing wrong?

Also - how often should the statistics be updated?

Thanks!

dbmcli -d igen -u DBA,DBA

dbmcli on IGEN>exec_xpu

ERR

-24964,ERR_EXECUTE: error in program execution

65280,xpu

Error during searching of the name of the database: no database name found