Skip to Content
0
Nov 23, 2010 at 05:02 PM

DB13 - Scheduled Update Statistics not run - Error

268 Views

Hello gurus,

I´m faccing with an error in DB13, I scheduled Update statistics every day but it did not run due an error.

I think this may resulted because an authorization problem.

In /usr/sap is with this permissions:

drwxr-xr-x  15 orad01 dba   4096 Oct 18 16:34 sap

The /oracle/D01/sapcheck is with the following permissions:

drwxr-xr-x  2 orad01 dba     4096 Nov 14 20:28 sapcheck

Inside of sapcheck directory I can see the following files with permissions:

-rw-r--r-- 1 orad01 dba       32262 Oct 14 13:16 ceeimamu.sta
-rw-r--r-- 1 orad01 dba        2705 Oct 15 17:42 ceeisafo.sta
-rw-r--r-- 1 orad01 dba        2705 Oct 15 17:50 ceeisazq.sta
-rw-r--r-- 1 orad01 dba        1932 Oct 15 17:58 ceeisbie.sta
-rw-r--r-- 1 orad01 dba        1791 Oct 15 22:16 ceeisyhm.sta
-rw-r--r-- 1 orad01 dba        1931 Oct 15 22:24 ceeisyta.sta
-rw-r--r-- 1 orad01 dba    19394261 Oct 15 23:45 ceeiszph.sta
-rw-r--r-- 1 orad01 dba        1930 Nov  9 11:27 ceenjunx.sta
-rw-r--r-- 1 orad01 dba        1790 Nov  9 11:38 ceenjvuv.sta
-rw-r--r-- 1 orad01 dba      143103 Nov  9 11:40 ceenjwnr.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:46 ceeosxxw.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:49 ceeosydo.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:54 ceeosyqi.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 15:57 ceeotefd.sta
-rw-r--r-- 1 orad01 dba       18530 Nov 16 16:27 ceeotgun.sta
-rw-r--r-- 1 orad01 dba         996 Nov 16 16:27 connD01.log

In DB13 at details error, it show the following statements:

Job executado
Etapa 001 executada (program.RSDBAJOB, variante &0000000000016, nome usuário XNSJAD)
Execução do comando lógico BRCONNECT No host segoviad04
Parâmetros: -u / -jid STATS20101123153214 -c -f stats -t ALL
BR0801I BRCONNECT 7.20 (7)
BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:
'ENABLE THREADS'
BR0806I End of BRCONNECT processing: ceeqbmqh.sta2010-11-23 15.32.15
BR0280I BRCONNECT time stamp: 2010-11-23 15.32.15
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job encerrado

Can you help me please!? I do not know how to solve this situation...

Best regards,

João Dimas - Portugal