update statistics failed

[Former Member]

Dear All,

we are schuduling upadate statistics daily in bi production system and completed successfully.

but today we finished with return code 3

plz check in log file and suggest me good solution

17.05.2011 11:25:54 Job started

17.05.2011 11:25:54 Step 001 started (program RSDBAJOB, variant &0000000000157, user ID BASIS)

17.05.2011 11:25:54 No application server found on database host - rsh/gateway will be used

17.05.2011 11:25:54 Execute logical command BRCONNECT On host KBIDBP

17.05.2011 11:25:54 Parameters: -u / -jid STATS20110517112554 -c -f stats -t

17.05.2011 11:25:57 BR0801I BRCONNECT 7.00 (40)

17.05.2011 11:25:57 BR0155E No value found for option '-t'

17.05.2011 11:25:57

17.05.2011 11:25:57 BR0806I End of BRCONNECT processing: cefxbuiv.log2011-05-17 11.25.57

17.05.2011 11:25:57 BR0280I BRCONNECT time stamp: 2011-05-17 11.25.57

17.05.2011 11:25:57 BR0804I BRCONNECT terminated with errors

17.05.2011 11:25:57 External program terminated with exit code 3

17.05.2011 11:25:57 BRCONNECT returned error status E

17.05.2011 11:25:57 Job finished

Regards

[JPReyes]

17.05.2011 11:25:54 Parameters: -u / -jid STATS20110517112554 -c -f stats -t
17.05.2011 11:25:57 BR0801I BRCONNECT 7.00 (40)
17.05.2011 11:25:57 BR0155E No value found for option '-t'

After the -t you should find the tablespace name or "ALL" which cover all tablespaces.

Check your job details in DB13 and reschedule if necesary.

Regards

Juan

[Former Member]

hi,

now i re executed updated statistics and this time it runs 4 hrs and completed with an error

below are error details

BR0280I BRCONNECT time stamp: 2011-05-09 04.26.34

BR0879I Statistics checked for 26726 tables

BR0878I Number of tables selected to collect statistics after check: 522

BR0880I Statistics collected for 607/1 tables/indexes

BR1308E Collection of statistics failed for 8/0 tables/indexes

kindly reply how can i collect / recover those missing statistics

Regards

[former_member185031]

Analyze the logs on DB13. There must be the reason why it's been failed. without logs impossible to say.

Regards,

Subhash

[Former Member]

Hello Swathi,

As suggested by Subhash check which are indexes are missing you can recreate the statistics in DB20 and analyse the index using RSANAORA report too.

Regards

Vivek

[nishikant_kulkarni2]

How is the CHECKDB working? is it also giving any errors?

Also try to run it at OS level.

- Nishikant