brconnect.exe exits with errors

[Former Member]

Hi All;

i got the following error during creation of database statics .

ERROR 2007-02-20 11:51:37

CJS-30023 Process call 'E:\usr\sap\PIF\SYS\exe\uc\NTI386\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -p 2' exits with error code 3. For details see log file(s) brconnect.log.

[Former Member · Accepted solution]

Hi Tushar,

Only use these options in exceptional circumstances.

· Check and update statistics for all tables in tablespace PSAPBTAD

brconnect -u / -c -f stats -t psapbtabd -f allsel

· Update statistics without check for all tables relevant to the application monitor

brconnect -u / -c -f stats -t dbstatc_mon -f collect

· Update statistics for a pool table specified in the DBSTATC table, to determine space usage, using method "estimate 10% rows"

brconnect -u / -c -f stats -t atab -m EI -s P10 -f allsel,method,sample,collect,space

BRCONNECT stores the space usage data in tables DBSTATTORA (for tables) and DBSTATIORA (for indexes). Finally, the statistics can be immediately deleted ­– for example, when the ACTIVE flag is set to N in DBSTATC.

If you want to keep the statistics for such tables – for example, for test purposes – you must include the keep option in the command, as follows:

brconnect -u / -c -f stats -t rfblg -m EI -s P10 -f allsel,method,sample,keep

· Check and update statistics according to the two-phase concept:

...

a. First phase: Check statistics

brconnect -u / -c -f stats -t all -f nocoll

b. Second phase: Update statistics on tables identified in the first phase

brconnect -u / -c -f stats -t all -f nocheck

Regards,

Abhishek

[Former Member · Accepted solution]

Hi Abhishek,

Would you please explain me how to run BRCONNECT as I installed IDES SAP ECC 5.0 on Windows 2000 Server Oracle 9.2 database. On what circumstance this is useful and why it is useful?. If you knew steps let me know please

Thanks

Happy

[Former Member · Accepted solution]

Hi Abhishek,

I am also facing the same problem,cuold you plz help me where should i do the following procedures...its urgent....

Thanks and Regards,

Rajesh.T

[Former Member · Accepted solution]

Hi,

Please check on help.sap.com for further information @ BRCONNECt...

[Former Member]

Hi,

Please find the brconnect.log file below and help me out to solve this error.

BR0801I BRCONNECT 7.00 (9)

BR0188E Value 16 of parameter/option '-p' greater than 15

BR0806I End of BRCONNECT processing: cduukxad.log 2007-03-12 18.51.19

BR0280I BRCONNECT time stamp: 2007-03-12 18.51.19

BR0804I BRCONNECT terminated with errors

Thanks

[Former Member]

refer Note 17163 - BRARCHIVE/BRBACKUP messages and codes

cheers,

-Sunil

[Former Member]

Check the BRCONNECT.LOG log file and send it in the forum .

Regards

Rahul