In my database check job come across below error message.
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPSR3.DDXTF
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPSR3.DDXTT
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (table) SAPSR3.TRBAT
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (index) SAPSR3.DDXTF~0
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (index) SAPSR3.DDXTT~0
19.07.2011 04:02:45 BR0970W Database administration alert - level: ERROR, type: HARMFUL_STATISTICS, object: (index) SAPSR3.TRBAT~0
To resolve neeed to delete harmful statistics through BRTOOLS.
tstmig:orapip 1> brtools
BR0651I BRTOOLS 7.20 (12)
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.02
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu
1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
7
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.17
BR0663I Your choice: '7'
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.17
BR0656I Choice menu 13 - please make a selection
-------------------------------------------------------------------------------
Processing database statistics
1 = Update database statistics
2 - Collect missing
4 - Manage database statistics
statistics
3 - Delete harmful statistics
5 - Collect dictionary statistics
6 - Collect system statistics
7 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.20
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.20
BR0657I Input menu 46 - please enter/check input values
-------------------------------------------------------------------------------
BRCONNECT main options for deletion of harmful statistics
1 - BRCONNECT profile (profile) ....... [initPIP.sap]
2 - Database user/password (user) ..... [/]
3 ~ Database owner for delete (owner) . []
4 ~ Ignore DBSTATC table (ignore) ..... []
5 ~ Exclude from delete (exclude) ..... []
6 ~ Tables for delete (table) ......... [harmful]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.53
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRTOOLS time stamp: 2011-07-19 11.37.53
BR0657I Input menu 47 - please enter/check input values
-------------------------------------------------------------------------------
Additional BRCONNECT options for deletion of harmful statistics
1 - Confirmation mode (confirm) ...... [yes]
2 - Query mode (query) ............... [no]
3 ~ Force options (force) ............ []
4 - Extended output (output) ......... [no]
5 - Message language (language) ...... [E]
6 - BRCONNECT command line (command) . [-p initPIP.sap -l E -f stats -d -t "harmful"]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-07-19 11.38.02
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRCONNECT will be started with options '-p initPIP.sap -l E -f stats -d -t "harmful"'
BR0280I BRTOOLS time stamp: 2011-07-19 11.38.02
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2011-07-19 11.38.11
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0801I BRCONNECT 7.20 (12)
BR0805I Start of BRCONNECT processing: cegiznmy.dst 2011-07-19 11.38.12
BR0484I BRCONNECT log file: /oracle/PIP/sapcheck/cegiznmy.dst
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.17
BR0813I Schema owner found in database PIP: SAPSR3*
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.32
BR0814I Number of tables in schema of owner SAPSR3: 71043
BR0836I Number of tables treated as info cubes for owner SAPSR3: 93
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.55
BR0815I Number of indexes in schema of owner SAPSR3: 84920
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.56
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 391
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.56
BR0807I Name of database instance: PIP
BR0808I BRCONNECT action ID: cegiznmy
BR0809I BRCONNECT function ID: dst
BR0810I BRCONNECT function: stats
BR0812I Database objects for processing: HARMFUL
BR0852I Number of tables to delete statistics: 3
Owner SAPSR3: 3
DDXTF DDXTT TRBAT
BR0856I Number of indexes to delete statistics: 0
BR0860I Delete option set - statistics will be deleted
BR0280I BRCONNECT time stamp: 2011-07-19 11.38.56
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:
c
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.15
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.15
BR0872I Deleting table and index statistics...
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.16
BR0874I Statistics deleted for table SAPSR3.DDXTF
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.16
BR0874I Statistics deleted for table SAPSR3.DDXTT
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.16
BR0874I Statistics deleted for table SAPSR3.TRBAT
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.16
BR0873I Statistics deleted for 3/0 tables/indexes
BR0806I End of BRCONNECT processing: cegiznmy.dst 2011-07-19 11.39.16
BR0280I BRCONNECT time stamp: 2011-07-19 11.39.17
BR0802I BRCONNECT completed successfully
###############################################################################
BR0292I Execution of BRCONNECT finished with return code 0
BR0280I BRTOOLS time stamp: 2011-07-19 11.39.17
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2011-07-19 11.39.34
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2011-07-19 11.39.36
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2011-07-19 11.39.36
BR0654I BRTOOLS terminated with errors
tstmig:orapip 2> exit
tstmig:orapip 3> logout
No comments:
Post a Comment