Informix

 View Only
Expand all | Collapse all

Smart Blob errors 9810/12048

  • 1.  Smart Blob errors 9810/12048

    Posted Mon January 29, 2024 12:58 PM

    Greetings.

    When selecting a Smartblob  (SELECT lotofile(blobcol,'/tmp/xxx.tmp','server') ... I get these errors:

    9810: Smart-large-object error.

    12048: Smart Large Objects: unique ID does not match. Smart large object probably deleted.

    In this particular case 877 records that pointed to the blob throw the same error. So the question is basically:
    How does a blob get deleted while it is still being referenced? 

    Best regards,

    -Snorri



    ------------------------------
    Snorri Bergmann
    ------------------------------


  • 2.  RE: Smart Blob errors 9810/12048

    IBM Champion
    Posted Sat February 03, 2024 09:29 AM

    Hi,

    Open a case, this could be a defect or expected behaviour if multiple rows point to the same smart blob.

    Also run oncheck -cS on the smart blob space.


    Regards,
    David.



    ------------------------------
    David Williams
    ------------------------------

    Original Message