Dbschema

hi all, on linux with IDS 9.40 UC5 when i try to make a dbschema of my data base i get : -------------------------------------------------------------------------------- -------- DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.UC5 Copyright IBM Corporation 1996, 2004 All rights reserved Software Serial Number AAA#B000000 grant dba to "root"; grant dba to "informix"; grant connect to "public"; -9753 - Unable to find User Defined Routine with the given id. -------------------------------------------------------------------------------- -------- other problem on the same database when executing update statistics i get the error : -------------------------------------------------------------------------------- -------- 721: SPL routine(informix.ifx_load_module) is no longer valid. Error in line 1Near character position 1 -------------------------------------------------------------------------------- -------- how can this be explained ? ******************************************************************************** ************** IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email in error, please notify the system manager or the sender immediately and do not disclose the contents to anyone or make copies thereof. *** eSafe scanned this email for viruses, vandals, and malicious content. *** ******************************************************************************** **************

Yes, it means that something corrupted your database. The definition of one of the built-in stored procedures has been damaged. No knowing what else. Time to run onchecks to see what's bad, try to do a dbexport (though it will also likely fail), and possibly call IBM tech support to help out. On Thu, May 22, 2008 at 4:48 AM, Franck ABELLI <f.abelli@corsicaferries.com> wrote: > hi all, on linux with IDS 9.40 UC5 > when i try to make a dbschema of my data base > i get : > > > -------------------------------------------------------------------------------- -------- > DBSCHEMA Schema Utility INFORMIX-SQL Version 9.40.UC5 > Copyright IBM Corporation 1996, 2004 All rights reserved > Software Serial Number AAA#B000000 > grant dba to "root"; > grant dba to "informix"; > grant connect to "public";> > -9753 - Unable to find User Defined Routine with the given id. > > > -------------------------------------------------------------------------------- -------- > > other problem on the same database when executing update statistics i get > the error : > > > > -------------------------------------------------------------------------------- -------- > 721: SPL routine(informix.ifx_load_module) is no longer valid. > Error in line 1> Near character position 1 > > > -------------------------------------------------------------------------------- -------- > > how can this be explained ? > > > ******************************************************************************** ************** > IMPORTANT: The contents of this email and any attachments are confidential. > They are intended for the > named recipient(s) only. > If you have received this email in error, please notify the system manager > or > the sender immediately and do > not disclose the contents to anyone or make copies thereof. > *** eSafe scanned this email for viruses, vandals, and malicious content. > *** > > > ******************************************************************************** ************** > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitely or implicitely. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.