Informix

 View Only

  • 1.  LOB error on a table w/o any blob

    Posted Mon September 02, 2024 08:56 AM
    Edited by Dennis Melnikov Mon September 02, 2024 08:56 AM

    Hi,

    IBM Informix Dynamic Server Version 11.70.FC5XE

    We have a rather weird error on UPDATE STATISTICS,

    UPDATE STATISTICS HIGH FOR TABLE ord_l_2 ( c_deliv,deliv_printed,notif_id,ofd_id,ord_id,ord_l_id,pp_status,status_req,time_deliv1) ;
     9810: Smart-large-object error.

    12014: Smart Large Objects: Cannot find entry in lofd table.
    Error in line 3
    Near character position 129

    A fact is that the table has no LOB.



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



  • 2.  RE: LOB error on a table w/o any blob

    IBM Champion
    Posted Mon September 02, 2024 09:20 AM

    Dennis:

    Does the table contain any LVARCHAR columns defined as longer than 4K? Those strings are stored out-of-row in smart blob objects when the particular string is longer than 4K (lvarchar string shorter than 4K, even if the definition is longer, are stored in-row).

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 3.  RE: LOB error on a table w/o any blob

    Posted Mon September 02, 2024 09:55 AM

    Art,

    No column longer than CHAR(75).



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------

    Original Message


  • 4.  RE: LOB error on a table w/o any blob

    IBM Champion
    Posted Mon September 02, 2024 10:23 AM

    That is odd! Can you run two onchecks to make sure there is no corruption: 

    oncheck -cc <database>

    oncheck -cDI <database>.<tablename>

    Let's get that out of the way. 

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 5.  RE: LOB error on a table w/o any blob

    IBM Champion
    Posted Mon September 02, 2024 10:44 AM

    Hi Dennis,

    Does the table have any fragmentation, especially RANGE fragmentation?



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message


  • 6.  RE: LOB error on a table w/o any blob

    Posted Mon September 02, 2024 11:34 AM

    Mike,

    Yes, the table as well as some indices has fragmentation, by expression.



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------

    Original Message


  • 7.  RE: LOB error on a table w/o any blob

    IBM Champion
    Posted Mon September 02, 2024 12:16 PM

    You are likely running into an issue with fragment level statistics.  These use blobs.

    First make sure that your sbspace in SYSSBSPACENAME has free space.

    You may be running into this problem, even though you are not using range fragmentation:  IT27566: RANGE FRAGMENTED TABLE WITH FRAGMENT LEVEL STATISTICS CAN HAVE NEGATIVE COUNT IN BIN AFTER UPDATE STATISTICS MEDIUM (ibm.com)

    If you really can't find a way around this, you can try changing the stats for the table to table-level instead of fragment level.  See Fragment-level statistics - IBM Documentation



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message