Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
Original Message:
Sent: Fri June 07, 2024 09:32 AM
From: Dennis Melnikov
Subject: Size of blob column
Art:
Another trick helped: I UPDATEd sysbldobjects.drop_sql mistyped in 'objects.sql'.
------------------------------
Sincerely,
Dennis
Original Message:
Sent: Fri June 07, 2024 06:51 AM
From: Art Kagel
Subject: Size of blob column
Dennis:
Try this: find the DDL for the dbms_random_jrand48() function in the objects.sql file and try to CREATE it and ALTER it. Then see if you can deregister the datablade.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Fri June 07, 2024 06:38 AM
From: Dennis Melnikov
Subject: Size of blob column
Thomas:
I've got a problem unregistering excompat.1.0 on 11.70:
EXECUTE FUNCTION sysbldprepare('excompat.1.0','drop');
# ^
#(U0001) - SYSBldUnregister - Unregistration failed for DataBlade module "excompat.1.0" - unknown error - check online log and sysblderrorlog table for more information
A sysblderrorlog table contains a single row,
order 1416
bld_id excompat.1.0
err_operation SYSBldRegister
err_expected unexpected
err_sql_stmt alter function dbms_random_jrand48 (integer)| with (Modify External Name = "jrand48");
err_sql_state XIX000:-674 : Routine (dbms_random_jrand48) can not be resolved.
Comparing the datablade with that of 12.10, I found that regardless of the same version (1.0) two files differ,
excompat.bld 74733 74801
objects.sql 99609 99608
The difference in text file objects.sql is as follows,
4559c4559
< "alter function dbms_random_jrand48 (integer)
---
> "alter function dbms_random_jrand48 (bigint)
How do I try to fix the problem?
Replace the files of 11.70 with those of 12.10 and restart the server?
Or something else?
------------------------------
Sincerely,
Dennis
Original Message:
Sent: Wed June 05, 2024 09:05 AM
From: Thomas Beebe
Subject: Size of blob column
Yes, it is the 'excompat' datablade for all versions. 11.7 I believe has 1.0.
As a note for other folks, version 1.2 is out, fixes a bug where it didn't correctly calculate sizes > 2gb and is backwards compatible with older versions of Informix.
select dbms_lob_getlength(column) from <table>.
------------------------------
Thomas Beebe
Vice President
xDB Systems, Inc
Woodbridge
5713399029
Original Message:
Sent: Wed June 05, 2024 08:34 AM
From: Dennis Melnikov
Subject: Size of blob column
Art:
Does it exist for 11.70?
------------------------------
Sincerely,
Dennis
Original Message:
Sent: Wed June 05, 2024 07:26 AM
From: Art Kagel
Subject: Size of blob column
Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Wed June 05, 2024 07:09 AM
From: Art Kagel
Subject: Size of blob column
Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Wed June 05, 2024 04:19 AM
From: Dennis Melnikov
Subject: Size of blob column
What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?
------------------------------
Sincerely,
Dennis
Original Message:
Sent: Thu March 18, 2021 11:12 AM
From: Celso Freitas de Andrade
Subject: Size of blob column
Hello all,
I need to know the space allocated by a table that has a byte column in a blobspace. When I look at the size of the table, I don't see the portion of it that is stored in the blobspace. Is there a way to get this information?
Thanks!
------------------------------
Celso Freitas
------------------------------
#Informix