RE: onspaces error

Hi Guy and Jonathan, Sorry if I put the post in the wrong place. I am using Remote Desktop to get to the server as the server is not local to me. I get the message if I used standard RD or the console mode. Registry setting is correct and the same as my environment variables %INFROMIXSERVER% and %ONCONFIG% Based on the fact that my DB server is running with no complaints from users of any type my backups are running normally and the fact that I added a chunk in mid May, I'm confused too. The server was last rebooted on 5/15/07 at which time it came up with no errors/warnings logged. I added 2 chunks that after the reboot and no other upgrades/changes since then. CJ -----Original Message----- From: Jonathan Leffler [mailto:jleffler.iiug@gmail.com] Sent: Thursday, June 07, 2007 10:05 AM To: datablade-list@iiug.org; ids@iiug.org Subject: Re: onspaces error Forwarding on behalf of Guy Bowerman. Thank you for generating the answer (or follow-up suggestions), Guy. The original question - at the bottom of the message - was posted on the datablade list; it is better treated on the IDS list. Please exclude datablade-list@iiug.org from responses to this message, and only follow-up on the ids@iiug.org list. =============== From: "Guy" <gbowerman@yahoo.com> Subject: Re: onspaces error... [212] Hi, Assuming you rule out permissions problems with the onconfig file, are you logged in via Remote Desktop? Do you get the same error when logged in directly? Can you run regedit and check this Registry value: HKEY_LOCAL_MACHINE\\\\Software\\\\Informix\\\\Online\\\\%INFORMIXSERVER%\\\\Environment \\\\ONCONFIG based on the INFORMIXSERVER value set in the command line environment? I wouldn't really expect this value to be wrong or you'd have problems running other commands. Thanks Guy ps I am not on this alias, Jonathan was kind enough to forward the mail, please include the ids alias in the reply. Jonathan Leffler wrote: Dear CJ, I'm not convinced this is the best mailing list for this question - it probably belongs on the ids@iiug.org mailing list instead. Have you looked at the full ACL (all the permissions) on the path %INFORMIXDIR%/etc/%ONCONFIG%? On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote: > I've run into a little problem and am hoping someone out there might help. I'm > trying to add some space to my database. When I run the following command: > > onspaces -a psapstab -p D:\\\\informix\\\\LPR\\\\sapdata\\\\psapstab.005 -o 0 -s1024000 > > I get the following message: > > WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. > > This is amy production DB server, running informix 9.4 with the latest > patches. I'm on a windows 2003 server, the database is up and running > correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct values > in them. I'm logged in as informix when I try to run the command. I have > plenty of disk space in the supplied location. I was able to add a chunk to a > different dbspace a few weeks ago, but could not when I wanted needed to last > week. I get the same error is I type onspaces with no arguments just trying to > look at help on this server. onstat, onmode and others seem to work fine. > > All the reading/searching of done over the last few days has not pointed me to > any solution. Any thoughts???? Who's Amy? :-) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/ NB: Please do not use the jleffler.iiug@gmail.com email for correspondence. I don't necessarily read it every week, even.

This error is sent to onspaces from oninit. Two ways you could trace it further are: 1. Use regmon from sysinternals.com to track registry usage by the oninit.exe process when onspaces is run. Set a filter of "oninit*" Look at the keys accessed and any errors. 2. Use filemon from the same place with a filter of "oninit*" to see which files are accessed and attempted to be accessed when you run the onspaces command. Regards Guy ----- Original Message ---- From: "Butcher, Creighton" <Creighton_Butcher@adaptec.com> To: ids@iiug.org Sent: Thursday, June 7, 2007 11:25:03 AM Subject: RE: onspaces error [9312] Hi Guy and Jonathan, Sorry if I put the post in the wrong place. I am using Remote Desktop to get to the server as the server is not local to me. I get the message if I used standard RD or the console mode. Registry setting is correct and the same as my environment variables %INFROMIXSERVER% and %ONCONFIG% Based on the fact that my DB server is running with no complaints from users of any type my backups are running normally and the fact that I added a chunk in mid May, I'm confused too. The server was last rebooted on 5/15/07 at which time it came up with no errors/warnings logged. I added 2 chunks that after the reboot and no other upgrades/changes since then. CJ -----Original Message----- From: Jonathan Leffler [mailto:jleffler.iiug@gmail.com] Sent: Thursday, June 07, 2007 10:05 AM To: datablade-list@iiug.org; ids@iiug.org Subject: Re: onspaces error Forwarding on behalf of Guy Bowerman. Thank you for generating the answer (or follow-up suggestions), Guy. The original question - at the bottom of the message - was posted on the datablade list; it is better treated on the IDS list. Please exclude datablade-list@iiug.org from responses to this message, and only follow-up on the ids@iiug.org list. =============== From: "Guy" <gbowerman@yahoo.com> Subject: Re: onspaces error... [212] Hi, Assuming you rule out permissions problems with the onconfig file, are you logged in via Remote Desktop? Do you get the same error when logged in directly? Can you run regedit and check this Registry value: HKEY_LOCAL_MACHINE\\\\Software\\\\Informix\\\\Online\\\\%INFORMIXSERVER%\\\\Environment \\\\ONCONFIG based on the INFORMIXSERVER value set in the command line environment? I wouldn't really expect this value to be wrong or you'd have problems running other commands. Thanks Guy ps I am not on this alias, Jonathan was kind enough to forward the mail, please include the ids alias in the reply. Jonathan Leffler wrote: Dear CJ, I'm not convinced this is the best mailing list for this question - it probably belongs on the ids@iiug.org mailing list instead. Have you looked at the full ACL (all the permissions) on the path %INFORMIXDIR%/etc/%ONCONFIG%? On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote: > I've run into a little problem and am hoping someone out there might help. I'm > trying to add some space to my database. When I run the following command: > > onspaces -a psapstab -p D:\\\\informix\\\\LPR\\\\sapdata\\\\psapstab.005 -o 0 -s1024000 > > I get the following message: > > WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. > > This is amy production DB server, running informix 9.4 with the latest > patches. I'm on a windows 2003 server, the database is up and running > correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct values > in them. I'm logged in as informix when I try to run the command. I have > plenty of disk space in the supplied location. I was able to add a chunk to a > different dbspace a few weeks ago, but could not when I wanted needed to last > week. I get the same error is I type onspaces with no arguments just trying to > look at help on this server. onstat, onmode and others seem to work fine. > > All the reading/searching of done over the last few days has not pointed me to > any solution. Any thoughts???? Who's Amy? :-) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/ NB: Please do not use the jleffler.iiug@gmail.com email for correspondence. I don't necessarily read it every week, even. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz

I would check your environment settings. I've seen this sort of thing happen with LOCALE. j. >From: "Butcher, Creighton" <Creighton_Butcher@adaptec.com> >Date: 2007/06/07 Thu PM 01:25:03 CDT >To: ids@iiug.org >Subject: RE: onspaces error [9312] >Hi Guy and Jonathan, > >Sorry if I put the post in the wrong place. > >I am using Remote Desktop to get to the server as the server is not >local to me. I get the message if I used standard RD or the console >mode. Registry setting is correct and the same as my environment >variables %INFROMIXSERVER% and %ONCONFIG% > >Based on the fact that my DB server is running with no complaints from >users of any type my backups are running normally and the fact that I >added a chunk in mid May, I'm confused too. The server was last >rebooted on 5/15/07 at which time it came up with no errors/warnings >logged. I added 2 chunks that after the reboot and no other >upgrades/changes since then. > >CJ > >-----Original Message----- >From: Jonathan Leffler [mailto:jleffler.iiug@gmail.com] >Sent: Thursday, June 07, 2007 10:05 AM >To: datablade-list@iiug.org; ids@iiug.org >Subject: Re: onspaces error > >Forwarding on behalf of Guy Bowerman. >Thank you for generating the answer (or follow-up suggestions), Guy. > >The original question - at the bottom of the message - was posted on >the datablade list; it is better treated on the IDS list. Please >exclude datablade-list@iiug.org from responses to this message, and >only follow-up on the ids@iiug.org list. > >=============== > >From: "Guy" <gbowerman@yahoo.com> >Subject: Re: onspaces error... [212] > >Hi, > >Assuming you rule out permissions problems with the onconfig file, are >you logged in via Remote Desktop? Do you get the same error when >logged in directly? > >Can you run regedit and check this Registry value: > >HKEY_LOCAL_MACHINE\\\\Software\\\\Informix\\\\Online\\\\%INFORMIXSERVER%\\\\Environment >\\\\ONCONFIG > >based on the INFORMIXSERVER value set in the command line environment? > >I wouldn't really expect this value to be wrong or you'd have problems >running other commands. > >Thanks >Guy > >ps I am not on this alias, Jonathan was kind enough to forward the >mail, please include the ids alias in the reply. > >Jonathan Leffler wrote: > >Dear CJ, > >I'm not convinced this is the best mailing list for this question - it >probably belongs on the ids@iiug.org mailing list instead. > >Have you looked at the full ACL (all the permissions) on the path >%INFORMIXDIR%/etc/%ONCONFIG%? > >On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote: >> I've run into a little problem and am hoping someone out there might >help. I'm >> trying to add some space to my database. When I run the following >command: >> >> onspaces -a psapstab -p D:\\\\informix\\\\LPR\\\\sapdata\\\\psapstab.005 -o 0 -s>1024000 >> >> I get the following message: >> >> WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. >> >> This is amy production DB server, running informix 9.4 with the latest >> patches. I'm on a windows 2003 server, the database is up and running >> correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct >values >> in them. I'm logged in as informix when I try to run the command. I >have >> plenty of disk space in the supplied location. I was able to add a >chunk to a >> different dbspace a few weeks ago, but could not when I wanted needed >to last >> week. I get the same error is I type onspaces with no arguments just >trying to >> look at help on this server. onstat, onmode and others seem to work >fine. >> >> All the reading/searching of done over the last few days has not >pointed me to >> any solution. Any thoughts???? > >Who's Amy? :-) > >-- >Jonathan Leffler #include <disclaimer.h> >Email: jleffler@earthlink.net, jleffler@us.ibm.com >Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/ >NB: Please do not use the jleffler.iiug@gmail.com email for >correspondence. >I don't necessarily read it every week, even. > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

Regmon found only this error for oninit: 11.11498070 oninit.exe:1692 OpenKey HKLM\\\\Software\\\\Policies\\\\Microsoft\\\\Windows NT\\\\DnsClient NOT FOUND There were a ton of entries for oninit as the DB is up and running...so I filtered further looking for a status != "SUCCESS" and got these: 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\onspaces.exe.Local NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\WINMM.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\WS2_32.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\WS2HELP.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\rdpsnd.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\WINSTA.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\PSAPI.DLL NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 OPEN D:\\\\informix\\\\LPR\\\\etc\\\\informix.rc NOT FOUND Options: Open Access: Read 12:44:37 PM onspaces.exe:6996 OPEN D:\\\\.informix NOT FOUND Options: Open Access: Read 12:44:37 PM onspaces.exe:6996 READ D:\\\\informix\\\\LPR\\\\gls\\\\cm3\\\\registry END OF FILE Offset: 12420 Length: 4096 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\DNSAPI.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 OPEN D:\\\\.netrc NOT FOUND Options: Open Access: Read 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\rasadhlp.dll NOT FOUND Attributes: Error 12:44:37 PM onspaces.exe:6996 QUERY INFORMATION D:\\\\informix\\\\LPR\\\\bin\\\\hnetcfg.dll NOT FOUND Attributes: Error Nothing "seems" out of the ordinary to me...most of the not founds were looking for a .DLL in one path and then found it in the next path. CJ -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guy . Sent: Thursday, June 07, 2007 11:49 AM To: ids@iiug.org Subject: Re: onspaces error [9313] This error is sent to onspaces from oninit. Two ways you could trace it further are: 1. Use regmon from sysinternals.com to track registry usage by the oninit.exe process when onspaces is run. Set a filter of "oninit*" Look at the keys accessed and any errors. 2. Use filemon from the same place with a filter of "oninit*" to see which files are accessed and attempted to be accessed when you run the onspaces command. Regards Guy ----- Original Message ---- From: "Butcher, Creighton" <Creighton_Butcher@adaptec.com> To: ids@iiug.org Sent: Thursday, June 7, 2007 11:25:03 AM Subject: RE: onspaces error [9312] Hi Guy and Jonathan, Sorry if I put the post in the wrong place. I am using Remote Desktop to get to the server as the server is not local to me. I get the message if I used standard RD or the console mode. Registry setting is correct and the same as my environment variables %INFROMIXSERVER% and %ONCONFIG% Based on the fact that my DB server is running with no complaints from users of any type my backups are running normally and the fact that I added a chunk in mid May, I'm confused too. The server was last rebooted on 5/15/07 at which time it came up with no errors/warnings logged. I added 2 chunks that after the reboot and no other upgrades/changes since then. CJ -----Original Message----- From: Jonathan Leffler [mailto:jleffler.iiug@gmail.com] Sent: Thursday, June 07, 2007 10:05 AM To: datablade-list@iiug.org; ids@iiug.org Subject: Re: onspaces error Forwarding on behalf of Guy Bowerman. Thank you for generating the answer (or follow-up suggestions), Guy. The original question - at the bottom of the message - was posted on the datablade list; it is better treated on the IDS list. Please exclude datablade-list@iiug.org from responses to this message, and only follow-up on the ids@iiug.org list. =============== From: "Guy" <gbowerman@yahoo.com> Subject: Re: onspaces error... [212] Hi, Assuming you rule out permissions problems with the onconfig file, are you logged in via Remote Desktop? Do you get the same error when logged in directly? Can you run regedit and check this Registry value: HKEY_LOCAL_MACHINE\\\\Software\\\\Informix\\\\Online\\\\%INFORMIXSERVER%\\\\Environment \\\\ONCONFIG based on the INFORMIXSERVER value set in the command line environment? I wouldn't really expect this value to be wrong or you'd have problems running other commands. Thanks Guy ps I am not on this alias, Jonathan was kind enough to forward the mail, please include the ids alias in the reply. Jonathan Leffler wrote: Dear CJ, I'm not convinced this is the best mailing list for this question - it probably belongs on the ids@iiug.org mailing list instead. Have you looked at the full ACL (all the permissions) on the path %INFORMIXDIR%/etc/%ONCONFIG%? On 6/4/07, CJ BUTCHER <creighton_butcher@adaptec.com> wrote: > I've run into a little problem and am hoping someone out there might help. I'm > trying to add some space to my database. When I run the following command: > > onspaces -a psapstab -p D:\\\\informix\\\\LPR\\\\sapdata\\\\psapstab.005 -o 0 -s1024000 > > I get the following message: > > WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. > > This is amy production DB server, running informix 9.4 with the latest > patches. I'm on a windows 2003 server, the database is up and running > correctly. The %INFORMIXDIR% and %ONCONFIG% variables have the correct values > in them. I'm logged in as informix when I try to run the command. I have > plenty of disk space in the supplied location. I was able to add a chunk to a > different dbspace a few weeks ago, but could not when I wanted needed to last > week. I get the same error is I type onspaces with no arguments just trying to > look at help on this server. onstat, onmode and others seem to work fine. > > All the reading/searching of done over the last few days has not pointed me to > any solution. Any thoughts???? Who's Amy? :-) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/ NB: Please do not use the jleffler.iiug@gmail.com email for correspondence. I don't necessarily read it every week, even. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________ ____________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+ki ds&cs=bz *******************************************************************