Cannot find sysadmin:ifx_setupdwa function
Juan Roca got error 674 (routine ifx_setupdwa cannot be resolved) on a 12.10.FC8AWE server with accelerator. Martin Fuerderer said these admin UDRs auto-register on first use and need the dbscheduler running. It was running and the problem persisted. Juan then found the solution was to run the UDR from within a user database, never from sysadmin.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi everybody,
I am running a 12.10.FC8AWE Informix Server on a Centos 64 bit VMWare virtual
machine.The accelerator server is 12.10.FC8WE.
I've succesfully run ondwa setup, ondwa start, ondwa status ondwa getpin.
When I try to run ifx_setupdwa function:
dbaccess -e sysadmin<<EOFexecute function ifx_setupdwa('My_accel','127.0.0.1','21022','0789');EOF
the 674: Routine (ifx_setupdwa) cannot be resolved error occurs.
If seems as if this function does not exists is sysadmin database.
A dbschema -d sysadmin -f ifx_setupdwa corroborates it.
How can I create this function?
Thanks a lot for your help.
Hi,
the stored procedures for the
adminsitration of accelerators
and data marts are implemented
as UDRs.
I think you need to have the dbscheduler
running in the Informix server, so that
these UDRs can be properly
auto-registered upon their first use.
If you de-activated the dbscheduler,
then please activate it.
Regards, Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Inf= ormation Management
Read about the Informix Warehouse
Accelerator:http://tinyurl.com/the-iwa-blog
IBM Deutschland GmbH
Vorsitzend= er des Aufsichtsrats: Martin Jetter
Geschaeftsfuehrung: Martina Koederit= z (Vorsitzende), Susanne Peter,
Norbert Janzen, Dr. Christian Keller, Iv= o Koerner, Stefan Lutz
Sitz der Gesellschaft: Ehningen
Registergerich= t: Amtsgericht Stuttgart, HRB 14562 WEEE-Reg.-Nr. DE
99369940
&nb= sp;
----- Original message -----=
From: "JUAN ROCA" <jluis.roca@hotmail.com>
Sent by: ids-bounce= s@iiug.org
To: ids@iiug.org
Cc:
Subject: Cannot find sysadmin:ifx= =5Fsetupdwa function [39291]
Date: Tue, May 30, 2017 11:34 AM
Hi everybody,
I am running a 12.10.FC8AWE Informix Server on a = Centos 64 bit
VMWare virtual
machine.The accelerator server is 12.10.FC8= WE.
I've succesfully run ondwa setup, ondwa start, ondwa status ondw= a
getpin.
When I try to run ifx=5Fsetupdwa function:
dbaccess= -e sysadmin<<EOF
execute function ifx=5Fsetupdwa('My=5Faccel','12=
7.0.0.1','21022','0789');
EOF
the 674: Routine (ifx=5Fsetupdwa) c= annot be resolved error occurs.
If seems as if this function does no= t exists is sysadmin database.
A dbschema -d sysadmin -f ifx=5Fsetupdwa = corroborates it.
How can I create this function?
Thanks a lot= for your help.
************************************************=
*******************************
Forum Note: Use "Reply" to p= ost a response in the discussion
forum.
Many thanks Martin for your response, The scheduler is running, I have the same problem. Is there any script to manually register those udrs?
The solution is running the udr from within a user database, never use sysadmin database.