Need to remove old information
Answered: amber (hollow confidence) — Leftover Excalibur DataBlade (ETX/TXT) routines cause the load errors; unregister the blade with sysbldprepare drop or blademgr, which is the appropriate path, but the asker never confirmed.
Advisory only.
Posted in 2024
Jeffrey Filippi saw daily online.log errors about loading missing ETX and TXT modules under $INFORMIXDIR/extend. Gerd Kaluzinski identified them as remnants of the Excalibur datablade and Hedwig Fuchs suggested checking sysbldregistered; both advised unregistering with sysbldprepare(..., 'drop') or blademgr. Art Kagel suggested dropping the functions, casts and row types. No final result was reported.
Topics: General Discussion
We get these messages in the online.logs daily. We want to remove them, but I cannot find them. One of the issues is that in the directory $INFORMIXDIR/extend does not exit. Here is the diredtory for the extend directory. drwxr-xr-x. 2 informix informix 138 Nov 16 13:54 binaryudt.1.0 drwxr-xr-x. 2 informix informix 159 Nov 16 13:54 bts.3.11 drwxr-xr-x. 2 informix informix 124 Nov 16 13:54 excompat.1.2 drwxr-xr-x. 2 informix informix 74 Nov 16 13:54 ifxbuiltins.1.1 drwxr-xr-x. 2 informix informix 145 Nov 16 13:54 ifxmngr drwxr-xr-x. 2 informix informix 178 Nov 16 13:54 ifxregex.1.10 drwxr-xr-x. 2 informix informix 172 Nov 16 13:54 ifxrltree.3.00 drwxr-xr-x. 3 informix informix 4096 Nov 16 13:55 krakatoa drwxr-xr-x. 4 informix informix 4096 Nov 16 13:54 LLD.1.20.FC2 drwxr-xr-x. 2 informix informix 174 Nov 16 13:55 mqblade.2.0 drwxr-xr-x. 2 informix informix 115 Nov 16 13:54 Node.2.0 drwxr-xr-x. 8 informix informix 4096 Nov 16 13:54 spatial.8.22.FC4 drwxr-xr-x. 2 informix informix 131 Nov 16 13:54 sts.2.00.FC2 drwxr-xr-x. 6 informix informix 4096 Nov 16 13:54 TimeSeries.6.01.FC2 drwxr-xr-x. 2 informix informix 119 Nov 16 13:54 TSAFuncs.1.00.FC2 drwxr-xr-x. 2 informix informix 119 Nov 16 13:54 TSPIndex.1.00.FC1 drwxr-xr-x. 2 informix informix 136 Nov 16 13:54 TSPMatch.2.00.FC1 drwxr-xr-x. 4 informix informix 146 Nov 16 13:54 wfs.1.00.FC1 02/05/2024 07:21:03 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:03 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:03 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 Loading Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> 02/05/2024 07:21:03 (2): The C Language Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> can't load reason: Cannot access library file 02/05/2024 07:21:03 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> 02/05/2024 07:21:03 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:03 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:03 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:03 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:09 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:09 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 Loading Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> 02/05/2024 07:21:09 (2): The C Language Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> can't load reason: Cannot access library file 02/05/2024 07:21:09 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld> 02/05/2024 07:21:09 Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> 02/05/2024 07:21:09 (2): The C Language Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> can't load reason: Cannot access library file 02/05/2024 07:21:09 (-1): ERROR: Loading Module <$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld> Does anyone know how to remove these functions. Thanks, Jeff Jeffrey J. Filippi Integrated Data Consulting, LLC 104 Cottonwood Dr. Streamwood, IL 60107 (P) 630-842-3608 (F) 630-497-1762 jeff.filippi@itdataconsulting.com www.itdataconsulting.com Linkedin: http://www.linkedin.com/pub/jeff-filippi/4/203/313 Twitter: https://twitter.com/jfilippi1
They are not in the schema ?
Here is some of the functions.
create opaque type "informix".sysbldsqltext
(
internallength=variable,
maxlen=24000,
alignment=1
);
grant usage on type "informix".sysbldsqltext to 'public' as "informix";create opaque type "informix".lld_lob
(
internallength=76,
alignment=8
);
grant usage on type "informix".lld_lob to 'public' as "informix";create row type "informix".lld_locator
(
lo_protocol char(18),
lo_pointer lld_lob,
lo_location lvarchar
);
grant usage on type "informix".lld_locator to 'public' as "informix";create opaque type "informix".ifxmrdata
(
internallength=variable,
maxlen=2048,
alignment=4,
cannothash
);
grant usage on type "informix".ifxmrdata to 'public' as "informix";create row type "informix".ifxdocdesc
(
format varchar(18),
version varchar(10),
location lld_locator,
params lvarchar
);
grant usage on type "informix".ifxdocdesc to 'public' as "informix";create row type "informix".etx_internalhilite
(
amparam lvarchar,
part_num integer,
index_name varchar(18),
sbspace varchar(18),
expanded_clue lvarchar
);
grant usage on type "informix".etx_internalhilite to 'public' as "informix";create row type "informix".etx_returntype
(
score smallfloat,
hilite_info etx_internalhilite
);
grant usage on type "informix".etx_returntype to 'public' as "informix";create row type "informix".etxfsestoragerow
(
sto_name char(255),
num_buckets integer,
bucket_num integer,
bucket blob
);
grant usage on type "informix".etxfsestoragerow to 'public' as "informix";create distinct type "informix".etxfsestoarearow as etxfsestoragerow ;
grant usage on type "informix".etxfsestoarearow to 'public' as "informix";create row type "informix".etx_hilitetype
(
vec_offset clob,
viewer_doc blob
);
grant usage on type "informix".etx_hilitetype to 'public' as "informix";create row type "informix".etx_fragfreq
(
fragment integer,
frequency integer
);
grant usage on type "informix".etx_fragfreq to 'public' as "informix";create row type "informix".etx_fragnumwords
(
fragment integer,
total integer,
unique integer
);
grant usage on type "informix".etx_fragnumwords to 'public' as "informix";create row type "informix".etx_numwords
(
total integer,
unique integer
);
grant usage on type "informix".etx_numwords to 'public' as "informix";create implicit cast (lvarchar as sysbldsqltext with "informix".sysbldsqltextin);
create explicit cast (sysbldsqltext as lvarchar with "informix".sysbldsqltextout);
create explicit cast (sysbldsqltext as sendrecv with "informix".sysbldsqltextsend);
create implicit cast (sendrecv as sysbldsqltext with "informix".sysbldsqltextrecv);
create implicit cast (impexp as sysbldsqltext with "informix".sysbldsqltextimpt);
create explicit cast (sysbldsqltext as impexp with "informix".sysbldsqltextexpt);
create implicit cast (impexpbin as sysbldsqltext with "informix".sysbldsqltextimpb);
create explicit cast (sysbldsqltext as impexpbin with "informix".sysbldsqltextexpb);
create implicit cast (lvarchar as lld_lob with "informix".lld_lobin);
create explicit cast (lld_lob as lvarchar with "informix".lld_lobout);
create explicit cast (lld_lob as sendrecv with "informix".lld_lobsend);
create implicit cast (sendrecv as lld_lob with "informix".lld_lobrecv);
create implicit cast (impexp as lld_lob with "informix".lld_lobimpt);
create explicit cast (lld_lob as impexp with "informix".lld_lobexpt);
create implicit cast (blob as lld_lob with "informix".lld_lobcast);
create implicit cast (clob as lld_lob with "informix".lld_lobcast);
create implicit cast (lld_lob as blob with "informix".blobcast);
create implicit cast (lld_lob as clob with "informix".clobcast);
create implicit cast (lvarchar as ifxmrdata with "informix".ifxmrdatain);
create explicit cast (ifxmrdata as lvarchar with "informix".ifxmrdataout);
create explicit cast (ifxmrdata as sendrecv with "informix".ifxmrdatasend);
create implicit cast (sendrecv as ifxmrdata with "informix".ifxmrdatarecv);
create implicit cast (impexp as ifxmrdata with "informix".ifxmrdataimpt);
create explicit cast (ifxmrdata as impexp with "informix".ifxmrdataexpt);
create explicit cast (row as ifxmrdata with "informix".ifxmrdatacast);
create explicit cast (lvarchar as ifxdocdesc with "informix".rowinput);
create function "informix".enable_slc_session ( integer ) returns integer external name '(mi_enable_sql_logical_char_db)' language C
;
create function "informix".disable_slc_session ( ) returns integer external name '(mi_disable_sql_logical_char_db)' language C
;
create function "informix".txt_release ()
returns lvarchar
external name "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)" language c;
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
alter routine "informix".txt_release ()
with (Modify External Name = "$INFORMIXDIR/extend/TXT.1.10.UC6/TXT.bld(Txt_Release)");
alter routine "informix".txt_release ()
with (add not variant);
create function "informix".etx_begin_scan (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_begin_scan)"
language c;
create function "informix".etx_check_index (pointer,integer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_check_index)"
language c;
create function "informix".etx_close_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_close_index)"
language c;
create function "informix".etx_create_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_create_index)"
language c;
create function "informix".etx_delete_index (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_delete_index)"
language c;
create function "informix".etx_drop_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_drop_index)"
language c;
create function "informix".etx_end_scan (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_end_scan)"
language c;
create function "informix".etx_get_next (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_get_next)"
language c;
create function "informix".etx_insert_index (pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_insert_index)"
language c;
create function "informix".etx_rescan_index (pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_rescan_index)"
language c;
create function "informix".etx_scan_cost (pointer,pointer)
returns real
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_scan_cost)"
language c;
create function "informix".etx_update_index (pointer,pointer,pointer,pointer,pointer)
returns integer
with
(
not variant
)
external name "$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_update_index)"
language c;
create function "informix".etx_contains (
doc lvarchar,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc varchar(255),
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc char,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains15)'
language C not variant;
create function "informix".etx_contains (
doc lvarchar,
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc varchar(255),
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc char,
query ROW(clue varchar(255), tuning_params varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains17)'
language C not variant;
create function "informix".etx_contains (
doc clob,
query ROW(clue varchar(255))
)
returns boolean
external name
'$INFORMIXDIR/extend/ETX.1.30.UC8/ETX.bld(etx_contains9)'
language C not variant;
create function "informix".etx_contains (
doc blob,
query ROW(clue varchar(255))
Thanks, Jeff
Jeffrey J. Filippi
Integrated Data Consulting, LLC
104 Cottonwood Dr.
Streamwood, IL 60107
(P) 630-842-3608
(F) 630-497-1762
jeff.filippi@itdataconsulting.com
www.itdataconsulting.com
Linkedin:
http://www.linkedin.com/pub/jeff-filippi/4/203/313
Twitter:
https://twitter.com/jfilippi1
Jeff: DROP FUNCTION, DROP CAST, and DROP ROW TYPE should work. No? Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Hi
when these blades are still registered, you can try to unregister the blade first
This select will show what is still registered:
select * from sysbldregisteredExample:
execute function sysbldprepare('ext.*', 'drop');But the messages in the online.log are suggesting that you try to use the blades?
------------------------------
Hedwig Fuchs
------------------------------
Hello,
these functions are remainders of the Excalibur Datablade (I loved it for searching PDFs).
So just try to remove this datablade by using
EXECUTE FUNCTION sysbldprepare(ETX.1.30.UC8
','drop');
Or in Version 12.10:
blademgr
> unregister ETX.1.30.UC8 <databasename>
and check if there are more datablade registered.
> list <databasename>
Mit freundlichen Grüßen - Kind regards
Gerd Kaluzinski
Consultant Software Services
IBM Expert Labs DACH, Data & AI
Phone: +49 175 228 1983
EMail:
gerd.kaluzinski@de.ibm.com
IBM Deutschland GmbH
Vorsitzender des Aufsichtsrats: Sebastian Krause
Geschäftsführung: Gregor Pillen (Vorsitzender), Nicole Reimer, Gabriele Schwarenthorer, Christine Rupp, Frank Theisen
Sitz der Gesellschaft: Ehningen / Registergericht: Amtsgericht Stuttgart, HRB 14562 / WEEE-Reg.-Nr. DE 99369940