Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

update statistics error in prod

Dear Experts ,

we are facing an error while updating statistics by using db13

please check on log below

18.05.2011 18:52:41 Job started

18.05.2011 18:52:41 Step 001 started (program RSDBAJOB, variant &0000000000047, user ID BASIS)

18.05.2011 18:52:42 No application server found on database host - rsh/gateway will be used

18.05.2011 18:52:42 Execute logical command BRCONNECT On host PRDHOSR

18.05.2011 18:52:42 Parameters: -u / -jid STATS20110518185240 -c -f stats -t ALL

18.05.2011 18:53:34 BR0801I BRCONNECT 7.00 (40)

18.05.2011 18:53:34 BR1304W Checking SAP license failed at location BrLicCheck-108

18.05.2011 18:53:34 BR0602W No valid SAP license found - please contact SAP

18.05.2011 18:53:34 BR0805I Start of BRCONNECT processing: cefxifuy.sta 2011-05-18 18.52.44

18.05.2011 18:53:34 BR0484I BRCONNECT log file: /oracle/PRD/sapcheck/cefxifuy.sta

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.52.53

18.05.2011 18:53:34 BR0813I Schema owners found in database PRD: SAPSR3*, SAPSR3DB%

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.05

18.05.2011 18:53:34 BR0814I Number of tables/partitions in schema of owner SAPSR3: 32818/10

18.05.2011 18:53:34 BR0836I Number of info cube tables found for owner SAPSR3: 143

18.05.2011 18:53:34 BR0814I Number of tables in schema of owner SAPSR3DB: 722

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.24

18.05.2011 18:53:34 BR0815I Number of indexes/partitions in schema ofowner SAPSR3: 43208/13

18.05.2011 18:53:34 BR0815I Number of indexes in schema of owner SAPSR3DB: 1051

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.29

18.05.2011 18:53:34 BR0818I Number of tables found in DBSTATC for owner SAPSR3: 814

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.29

18.05.2011 18:53:34 BR0807I Name of database instance: PRD

18.05.2011 18:53:34 BR0808I BRCONNECT action ID: cefxifuy

18.05.2011 18:53:34 BR0809I BRCONNECT function ID: sta

18.05.2011 18:53:34 BR0810I BRCONNECT function: stats

18.05.2011 18:53:34 BR0812I Database objects for processing: ALL

18.05.2011 18:53:34 BR0851I Number of tables with missing statistics:0

18.05.2011 18:53:34 BR0852I Number of tables to delete statistics: 0

18.05.2011 18:53:34 BR0854I Number of tables to collect statistics without checking: 0

18.05.2011 18:53:34 BR0855I Number of indexes with missing statistics: 0

18.05.2011 18:53:34 BR0856I Number of indexes to delete statistics: 0

18.05.2011 18:53:34 BR0857I Number of indexes to collect statistics: 0

18.05.2011 18:53:34 BR0853I Number of tables to check (and collect ifneeded) statistics: 33537

18.05.2011 18:53:34 BR0126I Unattended mode active - no operator confirmation required

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.31

18.05.2011 18:53:34 BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 32818/1055

18.05.2011 18:53:34 BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 722/8

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.33

18.05.2011 18:53:34 BR0301E SQL error -2132 at location thr_db_connect-3, SQL statement:

18.05.2011 18:53:34 'ENABLE THREADS'

18.05.2011 18:53:34 SQL-02132: Message 2132 not found; No message file for product=precomp, facility

18.05.2011 18:53:34 BR0310E Connect to database instance PRD failed

18.05.2011 18:53:34

18.05.2011 18:53:34 BR0806I End of BRCONNECT processing: cefxifuy.sta2011-05-18 18.53.33

18.05.2011 18:53:34 BR0280I BRCONNECT time stamp: 2011-05-18 18.53.34

18.05.2011 18:53:34 BR0804I BRCONNECT terminated with errors

18.05.2011 18:53:34 External program terminated with exit code 5

18.05.2011 18:53:34 BRCONNECT returned error status E

18.05.2011 18:53:34 Job finished

please help to solve this error in production

Regards

Former Member
Not what you were looking for? View more on this topic or Ask a question