Need to remove old information
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.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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