SAP Knowledge Base Article - Preview

2780111 - index rebuilds resulting in excessing message logging in .iqmsg file s_bm::Dump - SAP IQ

Symptom

When having index rebuild the server prints a lot of messages "s_bm::Dump" in the iqmsg file.

-----------------------------------------
  ## columnEBM, isValid :
  ## tableEBM :
 s_bm::Dump(this=0x28499b848):
 s_bmidentity(this=0x28499b860)={ver=1,flg=0105,pad=00000000,cnt=3420,rb=@(6,2)}
 bmdmp(this=0x1158d24f0): L1 Root  (uid=2657997;main Bufman). bpP=1045440
 L1: @(6,2): pda length: 1, 8B; data length: 2, 8B, blklen: 24
 L1:    0) Leaf @(6,1): part    0(   0), pos   2 {Boff 0 : 7} [bits 0 : 1045439]
 LF:    lfbvcnt: 4 (SBV: 01000000, SIV: 01000000), lfhdrlen: 8, lfblklen: 24
 LF:    Slices: 1, total bit count: 3420, total data length: 4, sda length: 8, data+sda length: 12
 LF:    0) range slice 0, position 2, count 3420, length 4B = 2S = 1I
 LF:      {bytes 0 - 3, shorts 0 - 1} [bits 0 : 32767]
 rs[000000]:      1  -3420
  ## s_barray not found
  ## tokenVdo :
   Max Key Size: 8
   Blocks/page: 16
   Unit Size 32
   Units/page: 4078
I. 03/05 11:01:46. 0000000799 LBN:7 NextLBN:0 UnitsUsed:2522 NextAvail:2673 1stAvail:9 MinRef:1557 UBM:1 PBM:1 DBM:0
I. 03/05 11:01:46. 0000000799 ------------+------------+---------+----------+---------------------------------
I. 03/05 11:01:46. 0000000799  Unit Range |     | Size    |       | Value
I. 03/05 11:01:46. 0000000799 ------------+------------+---------+----------+---------------------------------
I. 03/05 11:01:46. 0000000799     1-1     | 1          |      17 | 00000001 | 00000000000000000000000000000000
I. 03/05 11:01:46. 0000000799             |            |         | 00000001 | 00000000
I. 03/05 11:01:46. 0000000799     2-2     | 1          |       8 | 00000001 | 00000d5c00000000
I. 03/05 11:01:46. 0000000799             |            |         | 00000002 |
I. 03/05 11:01:46. 0000000799     3-3     | 1          |      24 | 00000001 | 001442617365206265666f7265206d6f
I. 03/05 11:01:46. 0000000799             |            |         | 00000003 | 76656d656e740000
I. 03/05 11:01:46. 0000000799     4-8     | 11111      |     128 | 00000001 | 00000001001000010000000000000007
I. 03/05 11:01:46. 0000000799             |            |         | 00000000 | 00000000000000080000000000000011
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000001001000020000000000000007
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000000000000040000000000000008
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000001001000030000000000000007
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000000000000160000000000000018
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000001000000000000000000000000
I. 03/05 11:01:46. 0000000799             |            |         |          | 00000000000000000000000000000000
I. 03/05 11:01:46. 0000000799     9-18    | 0000000    |
I. 03/05 11:01:46. 0000000799    16-16    | 1          |      17 | 00000002 | 00e0f5c5de1887f90000000000000000
I. 03/05 11:01:46. 0000000799             |            |         | 00000001 | 00000000
I. 03/05 11:01:46. 0000000799    17-17    | 1          |       8 | 00000002 | 00000d5c00000000
I. 03/05 11:01:46. 0000000799             |            |         | 00000002 |

There is no way to avoid it.


Read more...

Environment

SAP 16 SP11 PL22  on RS6000MP/AIX 6.1.0/64bit

Product

SAP IQ 16.0

Keywords

s_bm::Dump, imsg filled, , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.