SQL2310N the utility could not generate statistics: error "-911"

[Former Member]

Hello,

we have a 46c system with DB V.8.2.2. Everytime we planned over db13 the runstat_all we get an error message.

Errormessage: Error -2310 in dmdb6upd.c(687):

SQL2310N the utility could not generate statistics: error "-911"

Regards,

Alexander Türk

[Former Member · Accepted solution]

Here some more information:

07.01.2007 13:00:31 Ausführung des logischen Kommandos REORGCHK_ALL auf Rechner b0d0m102

07.01.2007 13:00:31 Parameter: -t all -n PH0 -z 3600 -m b -l 1800

07.01.2007 20:01:09 pct_long_lob has been set to 10 percent

07.01.2007 20:01:09 Checking for old entries in db6treorg/db6ireorg ...

07.01.2007 20:01:09 Reading table names for runstats ...

07.01.2007 20:01:09 Tables to process: 26350 ...

07.01.2007 20:01:09 ERRORMESSAGE: Error -2310 in dmdb6upd.c(687):

07.01.2007 20:01:09 SQL2310N The utility could not generate statistics. Error "-911"

07.01.2007 20:01:09 was returned.

07.01.2007 20:01:09

07.01.2007 20:01:09 table: SAPR3.DB6PMHT

07.01.2007 20:01:09 ERRORMESSAGE: Error -2310 in dmdb6upd.c(687):

07.01.2007 20:01:09 SQL2310N The utility could not generate statistics. Error "-911"

07.01.2007 20:01:09 was returned.

07.01.2007 20:01:09

07.01.2007 20:01:09 table: SAPR3.DB6PMHT_HD

[Former Member · Accepted solution]

Hi Alexander,

the problem is an SQL0911, i.e. a lock situation. The table affected is DB6PMHT_HD. This is a table used to write history of tablespace growth. And this table is exclusively locked, when the history is collected. As I can see at the timestamp, the runstats_all was scheduled on sunday at 20:00. This is exactly the time, when the history is collected by the SAP system. That's the reason for the lock

Best regards

Ralf

[Frank-Martin]

Hi Alexander,

it would help to see what causes the lock wait or deadlock situation.

Could you please run

db6util -sl

in the while the runstats job is running? db6util can be run periodically, e.g.:

db6util -sl 10 -o /dev/null -w locks.out

Regards

Frank