SAP 7.40/ Oracle 12c on AIX
UpdateStats from DB13 in our BI system runs for a few minutes, then fails. It does not generate a ST22 dump. In the Action Log of DB13 screen, it shows status = "Finished with error" and return code = "0006 Severe crash".
Any suggestions on what's causing this issue?
This detailed log looks like this. As shown, the stats jobs starts processing and gets thru several tables, then it just dies.
Job started
Step 001 started (program RSDBAJOB, variant &0000000000134, user ID BDEES)
No application server found on database host - rsh/gateway will be used
Execute logical command BRCONNECT On host bipdb01-lp
Parameters: -jid STATS20160610082235 -u / -c -f stats -t ALL
BR0801I BRCONNECT 7.40 (12)
BR0805I Start of BRCONNECT processing: cetjcwdv.sta 2016-06-10 08:22:35
BR0484I BRCONNECT log file: /oracle/BIP/sapcheck/cetjcwdv.sta
...
...
...
BR0883I Table selected to collect statistics after check: SAPBW3./BIC/AZSD_O0900 +(49945397/699649:7663925:0)
BR0280I BRCONNECT thread 6 time stamp: 2016-06-1008:23:20
BR0881I Collecting statistics for table SAPBW3./B28/FWFIXT3Z with method/sample EH/P10 ...
BR0280I BRCONNECT thread 2 time stamp: 2016-06-1008:23:20
BR0881I Collecting statistics for table SAPBW3./BIC/AZSD_O0900 with method/sample EH/P1 ...
Process died due to signal 11
SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: unknown
Job cancelled after system exception ERROR_MESSAGE