IBM Support

IT42672: REPLICATING SMARTBLOBS GREATER THAN 2GB ISSUE.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When replicating smartblobs with a size greater than 2GB, you
    can see it going through ER queues but then it just ends up with
    a 0 byte in the sbspace.
    
    In the following oncheck output, there's a ~1.5 MB FILETOBLOB
    which shows correctly, the second one corresponds to a ~3.5 GB
    FILETOBLOB on the replicated server
    
    informix@farias-ThinkPad-P50:~/prods/12.10/FC14$ oncheck -cS
    sbspace1
    
    Validating space 'sbspace1' ...
    
      sbspace Metadata Partition                       Partnum
    Used      Free
      sbspace1:'informix'.TBLSpace                     0xb00001
    6        44
      sbspace1:'informix'.sbspace_desc                 0xb00002
    2         2
      sbspace1:'informix'.chunk_adjunc                 0xb00003
    2         2
      sbspace1:'informix'.LO_ud_free                   0xb00004
    2     10865
      sbspace1:'informix'.LO_hdr_partn                 0xb00005
    2     61361
    
      Large Objects
      ID               Ref Size       Allocced       Creat   Last
      Sbs# Chk#  Seq#  Cnt    (Bytes)    Pages Extns Flags
    Modified
      ---- ---- ----- ---- ---------- -------- ----- -----
    ------------------------
        11   11     1    1    1674465      833     1 N-N-H Wed Dec
    7 14:33:47 2022
        11   11     2    1          0        0     0 N-N-H Wed Dec
    7 15:31:18 2022
    
    informix@farias-ThinkPad-P50:~/prods/12.10/FC14$ oncheck -pe
    sbspace1
    
    
    DBspace Usage Report: sbspace1            Owner: informix
    Created: 12/07/2022
    
    
     Chunk Pathname                             Pagesize(k)  Size(p)
    Used(p)  Free(p)
        11
    /External/prods/12.10/FC14/storage/ol_informix1210_sbspace1_p_1
    2  4194304 see below see below
    
     Description
    Offset(p)  Size(p)
     -------------------------------------------------------------
    -------- --------
     RESERVED PAGES
    0        2
     CHUNK FREELIST PAGE
    2        1
     sbspace1:'informix'.TBLSpace
    3       50
     SBLOBSpace LO [11,11,1]
    53      833
     SBLOBSpace FREE USER DATA (AREA 1)
    886  1116286
     SBLOBSpace RESERVED USER DATA (AREA 1)
    1117172   838848
     sbspace1:'informix'.sbspace_desc
    1956020        4
     sbspace1:'informix'.chunk_adjunc
    1956024        4
     sbspace1:'informix'.LO_ud_free
    1956028    10867
     sbspace1:'informix'.LO_hdr_partn
    1966895    61363
     SBLOBSpace FREE META DATA
    2028258   210078
     SBLOBSpace RESERVED USER DATA (AREA 2)
    2238336   838848
     SBLOBSpace FREE USER DATA (AREA 2)
    3077184  1117120
    
     Total Used:    73124
     Total SBLOBSpace FREE META DATA:   210078
     Total SBLOBSpace FREE USER DATA:  3911102
    
    i
    
    
    While following shows on the source correctly:
    
    informix@affinity:~$ oncheck -cS sbspace1
    
    Validating space 'sbspace1' ...
    
      sbspace Metadata Partition                       Partnum
    Used      Free
      sbspace1:'informix'.TBLSpace                     0xb00001
    6        44
      sbspace1:'informix'.sbspace_desc                 0xb00002
    2         2
      sbspace1:'informix'.chunk_adjunc                 0xb00003
    2         2
      sbspace1:'informix'.LO_ud_free                   0xb00004
    2     10865
      sbspace1:'informix'.LO_hdr_partn                 0xb00005
    2     61361
    
      Large Objects
      ID               Ref Size       Allocced       Creat   Last
      Sbs# Chk#  Seq#  Cnt    (Bytes)    Pages Extns Flags
    Modified
      ---- ---- ----- ---- ---------- -------- ----- -----
    ------------------------
        11   11     1    1    1674465      829     1 N-N-H Wed Dec
    7 14:33:45 2022
        11   11     2    1    1674465  1907463     2 N-N-H Wed Dec
    7 14:45:23 2022
    
    informix@affinity:~$ oncheck -pe sbspace1
    
    
    
    DBspace Usage Report: sbspace1            Owner: informix
    Created: 12/07/2022
    
    
    Chunk Pathname                             Pagesize(k)  Size(p)
    Used(p)  Free(p)
        11
    /home/informix/prods/12.10/FC14/storage/ol_informix1210_sbspace1
    _p_1            2  4194304 see below see below
    
    Description
    Offset(p)  Size(p)
    -------------------------------------------------------------
    -------- --------
    RESERVED PAGES
    0        2
    CHUNK FREELIST PAGE
    2        1
    sbspace1:'informix'.TBLSpace
    3       50
    SBLOBSpace LO [11,11,1]
    53      829
    SBLOBSpace LO [11,11,2]
    882   790343
    SBLOBSpace FREE USER DATA (AREA 1)
    791225   325947
    SBLOBSpace RESERVED USER DATA (AREA 1)
    1117172   838848
    sbspace1:'informix'.sbspace_desc
    1956020        4
    sbspace1:'informix'.chunk_adjunc
    1956024        4
    sbspace1:'informix'.LO_ud_free
    1956028    10867
    sbspace1:'informix'.LO_hdr_partn
    1966895    61363
    SBLOBSpace FREE META DATA
    2028258   210078
    SBLOBSpace RESERVED USER DATA (AREA 2)
    2238336   838848
    SBLOBSpace LO [11,11,2]
    3077184  1117120
    
    Total Used:  1980583
    Total SBLOBSpace FREE META DATA:   210078
    Total SBLOBSpace FREE USER DATA:  2003643
    
    
    You can verify with onstat -g rqm recvq that it's being
    sent/received
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 14.10.FC10.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 14.10.FC10.                       *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.FC10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT42672

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-12-08

  • Closed date

    2023-02-23

  • Last modified date

    2023-02-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
24 February 2023