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?
dbmcli -d igen -u DBA,DBA
dbmcli on IGEN>exec_xpu
-24964,ERR_EXECUTE: error in program execution
Error during searching of the name of the database: no database name found