SAP Knowledge Base Article - Preview

2798191 - Feature Request: Print table names for blocks with multiple owners - SAP IQ

Symptom

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 ******

Allocation Summary:
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.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

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 page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.