Smart Blob errors 9810/12048

Posted in 2024

Snorri Bergmann — source: IBM Community (ConnectedCommunity.org) Informix forum

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 ------------------------------

↪ replying to Snorri Bergmann

David Williams — source: IBM Community (ConnectedCommunity.org) Informix forum

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 ------------------------------