load module error...

This is probably a silly question or issue, but we are running: IDS 11.50.FC5 AIX 6.1.3.0 INFORMIXDIR=/dbengines/informix_11.50FC5 All, I am seeing the following errors in the online log: 08:02:42 Loading Module </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> 08:02:42 (2): The C Language Module </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load reason: Cannot access library file 08:02:42 (-1): ERROR: Loading Module </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> 08:02:42 Loading Module </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> The module is under /dbengines/informix_11.50FC5/extend/po_iter. Question: Is this from Informix somewhere or from the application causing these errors? I believe it's from the application, but want to verify that fact. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

It looks like a set of 'C' user defined functions were installed in that directory and the shared library does not have the correct permissions so the engine cannot load it. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > This is probably a silly question or issue, but we are running: > > IDS 11.50.FC5 > > AIX 6.1.3.0 > > INFORMIXDIR=/dbengines/informix_11.50FC5> > All, > > I am seeing the following errors in the online log: > > 08:02:42 Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > 08:02:42 (2): The C Language Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > reason: Cannot access library file > 08:02:42 (-1): ERROR: Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > 08:02:42 Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > Question: Is this from Informix somewhere or from the application > causing these errors? > > I believe it's from the application, but want to verify that fact. > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30334f25dac0cf049d1c9cce

The user is still pointing to the wrong name of the library, so it's not Informix. The application needs to find where they have the code that is trying to access the module, correct. They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, February 25, 2011 10:02 AM To: ids@iiug.org Subject: Re: load module error... [22920] It looks like a set of 'C' user defined functions were installed in that directory and the shared library does not have the correct permissions so the engine cannot load it. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > This is probably a silly question or issue, but we are running: > > IDS 11.50.FC5 > > AIX 6.1.3.0 > > INFORMIXDIR=/dbengines/informix_11.50FC5> > All, > > I am seeing the following errors in the online log: > > 08:02:42 Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > 08:02:42 (2): The C Language Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > reason: Cannot access library file > 08:02:42 (-1): ERROR: Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > 08:02:42 Loading Module > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > Question: Is this from Informix somewhere or from the application > causing these errors? > > I believe it's from the application, but want to verify that fact. > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > <mailto:2244650553@messaging.sprintpcs.com> > > Page via Skytel: 2244650553@sprint.skytel.com > <mailto:2244650553@sprint.skytel.com> > > Informix or MySQL Primary: 9110210@skytel.com > <mailto:9110210@skytel.com> > > Informix or MySQL Secondary: 7276872@skytel.com > <mailto:7276872@skytel.com> > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30334f25dac0cf049d1c9cce ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Just re-register the UDRs with the correct paths > The user is still pointing to the wrong name of the library, so it's not > Informix. The application needs to find where they have the code that > is trying to access the module, correct. > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:02 AM > To: ids@iiug.org > Subject: Re: load module error... [22920] > > It looks like a set of 'C' user defined functions were installed in that > > directory and the shared library does not have the correct permissions > so > the engine cannot load it. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > >> This is probably a silly question or issue, but we are running: >> >> IDS 11.50.FC5 >> >> AIX 6.1.3.0 >> >> INFORMIXDIR=/dbengines/informix_11.50FC5>> >> All, >> >> I am seeing the following errors in the online log: >> >> 08:02:42 Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> 08:02:42 (2): The C Language Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load >> >> reason: Cannot access library file >> 08:02:42 (-1): ERROR: Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> 08:02:42 Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> >> The module is under /dbengines/informix_11.50FC5/extend/po_iter. >> >> Question: Is this from Informix somewhere or from the application >> causing these errors? >> >> I believe it's from the application, but want to verify that fact. >> >> Thanks, >> >> ******************************************************************* >> >> Ernie Knox >> >> IT Database Administrator Specialist >> >> Sears Holdings - BU: I & T Group >> >> 3333 Beverly Rd., B4-266A >> >> Hoffman Estates, IL. 60179 >> >> Office: (847) 286-5735 >> >> Email: Ernest.Knox@searshc.com >> >> Blackberry: 2244650553@messaging.sprintpcs.com >> <mailto:2244650553@messaging.sprintpcs.com> >> >> Page via Skytel: 2244650553@sprint.skytel.com >> <mailto:2244650553@sprint.skytel.com> >> >> Informix or MySQL Primary: 9110210@skytel.com >> <mailto:9110210@skytel.com> >> >> Informix or MySQL Secondary: 7276872@skytel.com >> <mailto:7276872@skytel.com> >> >> " Yes we can make a Change! " >> >> " It's always a great day to watch Sports - GO LIONS, TIGERS, and > BEARS! >> " >> >> " Lets not forget - GO Pistons and Red Wings! " >> >> GSU >> >> ******************************************************************* >> >> >> >> > ************************************************************************ > ******* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --20cf30334f25dac0cf049d1c9cce > > ************************************************************************ > ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid.

They were able to load it after bouncing the instance. I'm wondering if they still have the old name somewhere in their code? 09:09:22 On-Line Mode 09:09:22 Booting Language <spl> from module <> 09:09:22 Loading Module <SPLNULL> 09:09:22 SCHAPI: Started 2 dbWorker threads. 09:11:22 Loading Module <$INFORMIXDIR/extend/po_iter/poiter.bld> 09:11:22 The C Language Module </dbengines/informix_11.50FC5/extend/po_iter/poiter.bld> loaded Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Friday, February 25, 2011 10:12 AM To: ids@iiug.org Subject: RE: load module error... [22923] Just re-register the UDRs with the correct paths > The user is still pointing to the wrong name of the library, so it's not > Informix. The application needs to find where they have the code that > is trying to access the module, correct. > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:02 AM > To: ids@iiug.org > Subject: Re: load module error... [22920] > > It looks like a set of 'C' user defined functions were installed in that > > directory and the shared library does not have the correct permissions > so > the engine cannot load it. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > >> This is probably a silly question or issue, but we are running: >> >> IDS 11.50.FC5 >> >> AIX 6.1.3.0 >> >> INFORMIXDIR=/dbengines/informix_11.50FC5>> >> All, >> >> I am seeing the following errors in the online log: >> >> 08:02:42 Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> 08:02:42 (2): The C Language Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load >> >> reason: Cannot access library file >> 08:02:42 (-1): ERROR: Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> 08:02:42 Loading Module >> </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> >> >> The module is under /dbengines/informix_11.50FC5/extend/po_iter. >> >> Question: Is this from Informix somewhere or from the application >> causing these errors? >> >> I believe it's from the application, but want to verify that fact. >> >> Thanks, >> >> ******************************************************************* >> >> Ernie Knox >> >> IT Database Administrator Specialist >> >> Sears Holdings - BU: I & T Group >> >> 3333 Beverly Rd., B4-266A >> >> Hoffman Estates, IL. 60179 >> >> Office: (847) 286-5735 >> >> Email: Ernest.Knox@searshc.com >> >> Blackberry: 2244650553@messaging.sprintpcs.com >> <mailto:2244650553@messaging.sprintpcs.com> >> >> Page via Skytel: 2244650553@sprint.skytel.com >> <mailto:2244650553@sprint.skytel.com> >> >> Informix or MySQL Primary: 9110210@skytel.com >> <mailto:9110210@skytel.com> >> >> Informix or MySQL Secondary: 7276872@skytel.com >> <mailto:7276872@skytel.com> >> >> " Yes we can make a Change! " >> >> " It's always a great day to watch Sports - GO LIONS, TIGERS, and > BEARS! >> " >> >> " Lets not forget - GO Pistons and Red Wings! " >> >> GSU >> >> ******************************************************************* >> >> >> >> > ************************************************************************ > ******* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --20cf30334f25dac0cf049d1c9cce > > ************************************************************************ > ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Check the definitions of the UDRs in sysprocedures. It may be that the incorrect location was entered when the functions were defined - or was the server moved? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 10:07 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > The user is still pointing to the wrong name of the library, so it's not > Informix. The application needs to find where they have the code that > is trying to access the module, correct. > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:02 AM > To: ids@iiug.org > Subject: Re: load module error... [22920] > > It looks like a set of 'C' user defined functions were installed in that > > directory and the shared library does not have the correct permissions > so > the engine cannot load it. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > > > This is probably a silly question or issue, but we are running: > > > > IDS 11.50.FC5 > > > > AIX 6.1.3.0 > > > > INFORMIXDIR=/dbengines/informix_11.50FC5> > > > All, > > > > I am seeing the following errors in the online log: > > > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 (2): The C Language Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > > > reason: Cannot access library file > > 08:02:42 (-1): ERROR: Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > > > Question: Is this from Informix somewhere or from the application > > causing these errors? > > > > I believe it's from the application, but want to verify that fact. > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com> > > > > Page via Skytel: 2244650553@sprint.skytel.com > > <mailto:2244650553@sprint.skytel.com> > > > > Informix or MySQL Primary: 9110210@skytel.com > > <mailto:9110210@skytel.com> > > > > Informix or MySQL Secondary: 7276872@skytel.com > > <mailto:7276872@skytel.com> > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and > BEARS! > > " > > > > " Lets not forget - GO Pistons and Red Wings! " > > > > GSU > > > > ******************************************************************* > > > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --20cf30334f25dac0cf049d1c9cce > > ************************************************************************ > ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517503b08131183049d1cf5e7

Yes there are two. Can I update these manually? Yes, they were migrated to a new server. unload to db_nros_sysprocedures.unl select * from sysprocedures informix@servername [/usr/informix]: $cat db_nros_sysprocedures.unl | grep ifmx_m podspinb_iter|lab2ifmx|386|R|1678|1824|0|0|1|f||/ifmx_m/ifmxpom01/fs_ser ver/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0 .0|en_US.819| podspout_iter|zmasud|388|R|1842|1988|0|0|1|f||/ifmx_m/ifmxpom01/fs_serve r/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0.0 |en_US.819| Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, February 25, 2011 10:27 AM To: ids@iiug.org Subject: Re: load module error... [22925] Check the definitions of the UDRs in sysprocedures. It may be that the incorrect location was entered when the functions were defined - or was the server moved? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 10:07 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > The user is still pointing to the wrong name of the library, so it's not > Informix. The application needs to find where they have the code that > is trying to access the module, correct. > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:02 AM > To: ids@iiug.org > Subject: Re: load module error... [22920] > > It looks like a set of 'C' user defined functions were installed in that > > directory and the shared library does not have the correct permissions > so > the engine cannot load it. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > > > This is probably a silly question or issue, but we are running: > > > > IDS 11.50.FC5 > > > > AIX 6.1.3.0 > > > > INFORMIXDIR=/dbengines/informix_11.50FC5> > > > All, > > > > I am seeing the following errors in the online log: > > > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 (2): The C Language Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > > > reason: Cannot access library file > > 08:02:42 (-1): ERROR: Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > > > Question: Is this from Informix somewhere or from the application > > causing these errors? > > > > I believe it's from the application, but want to verify that fact. > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.sprintpcs.com> > > > > Page via Skytel: 2244650553@sprint.skytel.com > > <mailto:2244650553@sprint.skytel.com> > > > > Informix or MySQL Primary: 9110210@skytel.com > > <mailto:9110210@skytel.com> > > > > Informix or MySQL Secondary: 7276872@skytel.com > > <mailto:7276872@skytel.com> > > > > " Yes we can make a Change! " > > > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and > BEARS! > > " > > > > " Lets not forget - GO Pistons and Red Wings! " > > > > GSU > > > > ******************************************************************* > > > > > > > > > ************************************************************************ > ******* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --20cf30334f25dac0cf049d1c9cce > > ************************************************************************ > ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ************

Yes: Use dbschema -ss -f <procname> for each to get the definitions of the procedures, modify the path in the SQL, drop the procedures and recreate them using the modified SQL. You can't update the sysprocedures records directly (even if you could, you'd have to immediately bounce the server for the change to be effective). The drop and create will take effect immediately. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 10:35 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > Yes there are two. Can I update these manually? Yes, they were > migrated to a new server. > > unload to db_nros_sysprocedures.unl > select * from sysprocedures> > informix@servername [/usr/informix]: > $cat db_nros_sysprocedures.unl | grep ifmx_m > podspinb_iter|lab2ifmx|386|R|1678|1824|0|0|1|f||/ifmx_m/ifmxpom01/fs_ser > ver/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0 > ..0|en_US.819| > podspout_iter|zmasud|388|R|1842|1988|0|0|1|f||/ifmx_m/ifmxpom01/fs_serve > r/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0.0 > |en_US.819| > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:27 AM > To: ids@iiug.org > Subject: Re: load module error... [22925] > > Check the definitions of the UDRs in sysprocedures. It may be that the > incorrect location was entered when the functions were defined - or was > the > server moved? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 10:07 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > > > The user is still pointing to the wrong name of the library, so it's > not > > Informix. The application needs to find where they have the code that > > is trying to access the module, correct. > > > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > > > Thanks, > > ******************************************************************* > > Ernie Knox > > IT Database Administrator Specialist > > Sears Holdings - BU: I & T Group > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Email: Ernest.Knox@searshc.com > > Blackberry: 2244650553@messaging.sprintpcs.com > > Page via Skytel: 2244650553@sprint.skytel.com > > Informix or MySQL Primary: 9110210@skytel.com > > Informix or MySQL Secondary: 7276872@skytel.com > > > > " Yes we can make a Change! " > > " It's always a great day to watch Sports - GO LIONS, TIGERS, and > BEARS! > > " > > " Lets not forget - GO Pistons and Red Wings! " > > GSU > > ******************************************************************* > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Art Kagel > > Sent: Friday, February 25, 2011 10:02 AM > > To: ids@iiug.org > > Subject: Re: load module error... [22920] > > > > It looks like a set of 'C' user defined functions were installed in > that > > > > directory and the shared library does not have the correct permissions > > > so > > the engine cannot load it. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > IIUG Board of Directors (art@iiug.org) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own > opinions > > and > > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other > > organization with which I am associated either explicitly, implicitly, > > > or by > > inference. Neither do those opinions reflect those of other > individuals > > affiliated with any entity with which I am affiliated nor those of the > > > entities themselves. > > > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > > <Ernest.Knox@searshc.com>wrote: > > > > > This is probably a silly question or issue, but we are running: > > > > > > IDS 11.50.FC5 > > > > > > AIX 6.1.3.0 > > > > > > INFORMIXDIR=/dbengines/informix_11.50FC5> > > > > > All, > > > > > > I am seeing the following errors in the online log: > > > > > > 08:02:42 Loading Module > > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > 08:02:42 (2): The C Language Module > > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > > > > > reason: Cannot access library file > > > 08:02:42 (-1): ERROR: Loading Module > > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > 08:02:42 Loading Module > > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > > > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > > > > > Question: Is this from Informix somewhere or from the application > > > causing these errors? > > > > > > I believe it's from the application, but want to verify that fact. > > > > > > Thanks, > > > > > > ******************************************************************* > > > > > > Ernie Knox > > > > > > IT Database Administrator Specialist > > > > > > Sears Holdings - BU: I & T Group > > > > > > 3333 Beverly Rd., B4-

I dropped and re-created the functions in the database using the correct user names. They look better. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Friday, February 25, 2011 10:36 AM To: ids@iiug.org Subject: RE: load module error... [22927] Yes there are two. Can I update these manually? Yes, they were migrated to a new server. unload to db_nros_sysprocedures.unl select * from sysprocedures informix@servername [/usr/informix]: $cat db_nros_sysprocedures.unl | grep ifmx_m podspinb_iter|lab2ifmx|386|R|1678|1824|0|0|1|f||/ifmx_m/ifmxpom01/fs_ser ver/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0 ..0|en_US.819| podspout_iter|zmasud|388|R|1842|1988|0|0|1|f||/ifmx_m/ifmxpom01/fs_serve r/extend/po_iter/poiter.bld(poiter)|I|1|lvarchar|f|f|f|t|0||||f|||f||0.0 |en_US.819| Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings - BU: I & T Group 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, February 25, 2011 10:27 AM To: ids@iiug.org Subject: Re: load module error... [22925] Check the definitions of the UDRs in sysprocedures. It may be that the incorrect location was entered when the functions were defined - or was the server moved? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Feb 25, 2011 at 10:07 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > The user is still pointing to the wrong name of the library, so it's not > Informix. The application needs to find where they have the code that > is trying to access the module, correct. > > They are looking for: /ifmx_m/ifmxpom01/fs_server/extend/po_iter > > We have placed it in: /dbengines/informix_11.50FC5/extend/po_iter > > Thanks, > ******************************************************************* > Ernie Knox > IT Database Administrator Specialist > Sears Holdings - BU: I & T Group > 3333 Beverly Rd., B4-266A > Hoffman Estates, IL. 60179 > Office: (847) 286-5735 > Email: Ernest.Knox@searshc.com > Blackberry: 2244650553@messaging.sprintpcs.com > Page via Skytel: 2244650553@sprint.skytel.com > Informix or MySQL Primary: 9110210@skytel.com > Informix or MySQL Secondary: 7276872@skytel.com > > " Yes we can make a Change! " > " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! > " > " Lets not forget - GO Pistons and Red Wings! " > GSU > ******************************************************************* > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Art Kagel > Sent: Friday, February 25, 2011 10:02 AM > To: ids@iiug.org > Subject: Re: load module error... [22920] > > It looks like a set of 'C' user defined functions were installed in that > > directory and the shared library does not have the correct permissions > so > the engine cannot load it. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other > organization with which I am associated either explicitly, implicitly, > or by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Feb 25, 2011 at 9:54 AM, Knox, Ernest > <Ernest.Knox@searshc.com>wrote: > > > This is probably a silly question or issue, but we are running: > > > > IDS 11.50.FC5 > > > > AIX 6.1.3.0 > > > > INFORMIXDIR=/dbengines/informix_11.50FC5> > > > All, > > > > I am seeing the following errors in the online log: > > > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 (2): The C Language Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> can't load > > > > reason: Cannot access library file > > 08:02:42 (-1): ERROR: Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > 08:02:42 Loading Module > > </ifmx_m/ifmxpom01/fs_server/extend/po_iter/poiter.bld> > > > > The module is under /dbengines/informix_11.50FC5/extend/po_iter. > > > > Question: Is this from Informix somewhere or from the application > > causing these errors? > > > > I believe it's from the application, but want to verify that fact. > > > > Thanks, > > > > ******************************************************************* > > > > Ernie Knox > > > > IT Database Administrator Specialist > > > > Sears Holdings - BU: I & T Group > > > > 3333 Beverly Rd., B4-266A > > > > Hoffman Estates, IL. 60179 > > > > Office: (847) 286-5735 > > > > Email: Ernest.Knox@searshc.com > > > > Blackberry: 2244650553@messaging.sprintpcs.com > > <mailto:2244650553@messaging.