Update stats getting hung

[Former Member]

Hi ,

We have installed a new ECC system and while running update stats  it does not complete fully. It gets killed automatically in between.

BR0801I BRCONNECT 7.00 (40)

BR0805I Start of BRCONNECT processing: cepdoofd.sta 2014-11-09 05.18.53

BR0484I BRCONNECT log file: /oracle/<SID>/sapcheck/cepdoofd.sta

BR0280I BRCONNECT time stamp: 2014-11-09 05.18.54

BR0813I Schema owner found in database <SID>: SAPSR3*

BR0280I BRCONNECT time stamp: 2014-11-09 05.18.57

BR0814I Number of tables/partitions in schema of owner SAPSR3: 86982/1

BR0836I Number of info cube tables found for owner SAPSR3: 139

BR0280I BRCONNECT time stamp: 2014-11-09 05.19.01

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 104793/4

BR0280I BRCONNECT time stamp: 2014-11-09 05.19.02

BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390

BR0280I BRCONNECT time stamp: 2014-11-09 05.19.02

BR0807I Name of database instance: <SID>

BR0808I BRCONNECT action ID: cepdoofd

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: ALL

BR0851I Number of tables with missing statistics: 61

Owner SAPSR3: 61

IUUC_COMMAND          IUUC_DB_TABLE         IUUC_DDSND_ID         IUUC_DR_CHECK         IUUC_FLD_PROCOPT      IUUC_IM_TARGETTB      IUUC_INCR_COUNT       IUUC_LOGTAB_ID        IUUC_LOGTAB_PERF      IUUC_MOD_DB

IUUC_MOD_DYN          IUUC_MOD_DYN_NAV      IUUC_MT_HEADER        IUUC_NRIVLO_SNAP      IUUC_NRIVSH_SNAP      IUUC_NRIV_SNAP        IUUC_PERF_OPTION      IUUC_PREPROC_CNT      IUUC_PROBTAB_ID       IUUC_PTABS

IUUC_RECON IUUC_RECON_F2F        IUUC_RECON_F2F_R      IUUC_RECON_HDR        IUUC_RECON_RC         IUUC_RECON_WCL        IUUC_RULE_ASSIGN      IUUC_RUNINFO_CNT      IUUC_RUNINFO_TIM      IUUC_SHDWTB_ID

IUUC_SPC_PROCOPT      IUUC_ST10DATA         IUUC_ST10V IUUC_TABLES           IUUC_TABLESV          IUUC_TABLE_EVAL       IUUC_TABLE_EVALC      IUUC_TABLE_EX         IUUC_TABLE_EXCEP      IUUC_TABLE_EXCPT

IUUC_TABLE_TXT        IUUC_TABLE_TXTC       IUUC_TAB_EVALCV       IUUC_TAB_EVALV        IUUC_TAB_SELFLD       IUUC_TNRO_SNAP        IUUC_TRACK IUUC_TRACK_HDR        IUUC_TRESE IUUC_VERIF_DL

IUUC_WCLAUSE          MBO_FIELD  MBO_FORKEY MBO_WORKSTEPS         PATALLOWED PATTPCALL  PATTPIMPLOG           PATTPLOGPTR           PATTPOPTIONS          PATTPSTDOUT

PATUSEDOBJ

BR0852I Number of tables to delete statistics: 0

BR0854I Number of tables to collect statistics without checking: 0

BR0855I Number of indexes with missing statistics: 0

BR0856I Number of indexes to delete statistics: 0

BR0857I Number of indexes to collect statistics: 0

BR0853I Number of tables to check (and collect if needed) statistics: 86982

BR0846I Number of threads that will be started in parallel to the main thread: 4

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2014-11-09 05.19.02

BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 86982/2842

BR0280I BRCONNECT time stamp: 2014-11-09 05.19.03

BR0877I Checking and collecting table and index statistics...

BR0847I Thread 1 started successfully

BR0847I Thread 2 started successfully

BR0847I Thread 3 started successfully

BR0847I Thread 4 started successfully

BR0280I BRCONNECT thread 1: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_COMMAND with method/sample C ...

BR0280I BRCONNECT thread 3: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_DB_TABLE with method/sample C ...

BR0280I BRCONNECT thread 4: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_DDSND_ID with method/sample C ...

BR0280I BRCONNECT thread 2: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_DR_CHECK with method/sample C ...

BR0280I BRCONNECT thread 2: time stamp: 2014-11-09 05.19.03

BR0884I Statistics collected for table: SAPSR3.IUUC_DR_CHECK, rows old/new: -1/0

BR0280I BRCONNECT thread 3: time stamp: 2014-11-09 05.19.03

BR0884I Statistics collected for table: SAPSR3.IUUC_DB_TABLE, rows old/new: -1/0

BR0280I BRCONNECT thread 2: time stamp: 2014-11-09 05.19.03

KPEDBG_POP_KGPPTR_TLSBR0881I Collecting statistics for table SAPSR3.IUUC_FLD_PROCOPT with method/sample C ...

BR0280I BRCONNECT thread 4: time stamp: 2014-11-09 05.19.03

BR0884I Statistics collected for table: SAPSR3.IUUC_DDSND_ID, rows old/new: -1/0

BR0280I BRCONNECT thread 3: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_IM_TARGETTB with method/sample C ...

BR0280I BRCONNECT thread 4: time stamp: 2014-11-09 05.19.03

BR0881I Collecting statistics for table SAPSR3.IUUC_INCR_COUNT with method/sample C ...

Killed

Please help me fixing this

[Reagan]

That "Killed" word in the log makes me feel someone is running the brconnect from the OS level and terminating it for a reason only known to him. The BR*Tools is quite old and you should consider updating it.

[Former Member]

Hi

Padmini Shivaji

Check the following sap note 1909451 it will be helpful for you

---

Thanks&Regards

  MANIKANTA

[former_member185239]

Hi Padmini,

Check the table on which its getting hang.

Then run the stats on that particular table then go ahead with the all the table.

Moreover you can set the environment variable BR_TRACE = 15 and then run the brtools , it will then record the reason for handing.

With Regards

Ashutosh Chaturvedi

[fidel_vales]

Hi,

for starters, I would upgrade your "BR*Tools" version (not that has anything to do with this but it is quite "ancient" version

BRCONNECT 7.00 (40)

the "killed" part seems to point to an external "something" killing the process.

The trace mentioned by Ashutosh might be also a good idea.

Would be interesting to know also how do you schedule or execute it and what command do you use