Feature request for table names be printed alongside when blocks are detected with multiple owners.
Currently, sp_iqcheckdb 'allocation database' could report "N blocks with multiple owners",
but there is no info on the tables to which those problem blocks belong to.
Excerpt of IQMSG when the option DBCC_Log_Progress = 'ON':
I. 05/14 19:33:17. 0000000009 DBCC - 12 blocks with multiple owners
I. 05/14 19:33:17. 0000000009 s_bm::Print(this=0x62c648):
I. 05/14 19:33:17. 0000000009 3279154 3279155 3279156 3279157 3279174 3279175 3279176 3279177 3279210 3279211 3279212 3279213
DBCC Allocation Mode Report:
** DBCC Status: Errors Detected ******
Blocks Total: 5250875312
Blocks in Current Version: 5004104070
Blocks in All Versions: 5004104070
Blocks in Use: 5004104054
% Blocks in Use: 95
** Block Count Mismatch: 16 ******
** Blocks with Multiple Owners: 12 ******
** Unallocated Blocks in Use: 4 ******
There would need to run sp_iqcheckdb with check or verify modes to see the table names with blocks having multiple owners, and this could take several days on big databases.
It would be very handy to have the table names of the problem blocks and drop the tables and reload data instead of going to a backup/restore, in case check or verify modes aren't practical.
- SAP IQ 16.0
- SAP IQ 16.1
CR819384 ; CR#819384 ; 819384 ; DBCC ; allocation ; sp_iqcheckdb ; "Blocks with Multiple Owners:" ; "Block Count Mismatch:" ; "Unallocated Blocks in Use:" , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.