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 for Me (Login required).

Search for additional results

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