Issues with onpload
A DBA found his onpload binary on Solaris 10 / IDS 11.50.UC2 had become zero bytes; after sftp'ing a copy from another server it failed with "ksh: onpload: cannot execute". Suggestions were to check file size/checksum (binary vs text FTP mode) and permissions, and to restore the setgid bit (chmod 2755 or g+s); that didn't help. After reinstalling the engine, onpload then complained of an "Incorrect database version", prompting advice to run conpload.sh, open an IBM case (not possible for him), or drop the onpload database so it rebuilds itself. No confirmed resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Somehow the onpload file on our server got set to a blank file (byte =
0). I have no idea how this happened. I sftp'd an onpload file from
another server to this server from the same version of Informix.
However, when I try to run it, I get the following error:
ksh: onpload: cannot execute
Has anyone else seen this before? We are running on SunOS 5.10 and
Informix version 11.50.UC2.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
Check to see if the file has the same permissions as where you copied it
from ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Schleicher, Keith" <Keith.Schleicher@searshc.com>
To:
ids@iiug.org
Date:
08/14/2009 01:31 PM
Subject:
Issues with onpload [16687]
Sent by:
ids-bounces@iiug.org
Somehow the onpload file on our server got set to a blank file (byte =
0). I have no idea how this happened. I sftp'd an onpload file from
another server to this server from the same version of Informix.
However, when I try to run it, I get the following error:
ksh: onpload: cannot execute
Has anyone else seen this before? We are running on SunOS 5.10 and
Informix version 11.50.UC2.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
group permission?
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter_Logan@spartanstores.com
Sent: Friday, August 14, 2009 12:34 PM
To: ids@iiug.org
Subject: Re: Issues with onpload [16688]
Check to see if the file has the same permissions as where you copied it
from ...
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Schleicher, Keith" <Keith.Schleicher@searshc.com>
To:
ids@iiug.org
Date:
08/14/2009 01:31 PM
Subject:
Issues with onpload [16687]
Sent by:
ids-bounces@iiug.org
Somehow the onpload file on our server got set to a blank file (byte =
0). I have no idea how this happened. I sftp'd an onpload file from
another server to this server from the same version of Informix.
However, when I try to run it, I get the following error:
ksh: onpload: cannot execute
Has anyone else seen this before? We are running on SunOS 5.10 and
Informix version 11.50.UC2.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Take an ls -l and a 'sum' of the original and the ftp'd copy. If the sizes
or sums are not the same you may have FTP'd the file in 'TEXT' mode.
UNIX-to-UNIX FTPs should always be in binary mode, but it's worth a check.
Also check the priveleges on the file to make sure they are the same as on
the source installation. If that doesn't work, shutdown the instance and
just reinstall the engine to get a clean copy of the executables.
Art
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 explicitly or implicitly. 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, Aug 14, 2009 at 1:30 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> Somehow the onpload file on our server got set to a blank file (byte =
> 0). I have no idea how this happened. I sftp'd an onpload file from
> another server to this server from the same version of Informix.
> However, when I try to run it, I get the following error:
>
> ksh: onpload: cannot execute
>
> Has anyone else seen this before? We are running on SunOS 5.10 and
> Informix version 11.50.UC2.
>
> Keith Schleicher
>
> IT Database Administrator
>
> B2-253B-A
>
> Office: 847-286-4027
>
> Cell: 224-210-8358
>
> Blackberry: 2242108358@messaging.sprintpcs.com
>
> Page: 2242108358@sprint.skytel.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015173fe6c635108a04711e17cb
chmod 2755 onpload
-- or --
chmod g+s onpload
Art
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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
> group permission?
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Friday, August 14, 2009 12:34 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16688]
>
> Check to see if the file has the same permissions as where you copied it
>
> from ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
> To:
> ids@iiug.org
> Date:
> 08/14/2009 01:31 PM
> Subject:
> Issues with onpload [16687]
> Sent by:
> ids-bounces@iiug.org
>
> Somehow the onpload file on our server got set to a blank file (byte =
> 0). I have no idea how this happened. I sftp'd an onpload file from
> another server to this server from the same version of Informix.
> However, when I try to run it, I get the following error:
>
> ksh: onpload: cannot execute
>
> Has anyone else seen this before? We are running on SunOS 5.10 and
> Informix version 11.50.UC2.
>
> Keith Schleicher
>
> IT Database Administrator
>
> B2-253B-A
>
> Office: 847-286-4027
>
> Cell: 224-210-8358
>
> Blackberry: 2242108358@messaging.sprintpcs.com
>
> Page: 2242108358@sprint.skytel.com
>
> ************************************************************************
> *******
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b9acb742f804711e1e16
That still isn't working. I will try to get root access, but I really
would rather resolve it some other way if possible.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art Kagel
Sent: Friday, August 14, 2009 1:22 PM
To: ids@iiug.org
Subject: Re: Issues with onpload [16692]
chmod 2755 onpload
-- or --
chmod g+s onpload
Art
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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
> group permission?
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Friday, August 14, 2009 12:34 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16688]
>
> Check to see if the file has the same permissions as where you copied
it
>
> from ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
> To:
> ids@iiug.org
> Date:
> 08/14/2009 01:31 PM
> Subject:
> Issues with onpload [16687]
> Sent by:
> ids-bounces@iiug.org
>
> Somehow the onpload file on our server got set to a blank file (byte =
> 0). I have no idea how this happened. I sftp'd an onpload file from
> another server to this server from the same version of Informix.
> However, when I try to run it, I get the following error:
>
> ksh: onpload: cannot execute
>
> Has anyone else seen this before? We are running on SunOS 5.10 and
> Informix version 11.50.UC2.
>
> Keith Schleicher
>
> IT Database Administrator
>
> B2-253B-A
>
> Office: 847-286-4027
>
> Cell: 224-210-8358
>
> Blackberry: 2242108358@messaging.sprintpcs.com
>
> Page: 2242108358@sprint.skytel.com
>
>
************************************************************************
> *******
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b9acb742f804711e1e16
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
I reinstalled the instance and copied the onpload file over. However,
when I try to run it, I get this:
IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
pom_load -j nroxtrh -fl
Incorrect database version. Make sure that is upgraded properly.
To upgrade, manually run the conpload.sh or conpload.bat script, located
in the $INFORMIXDIR/etc/conv/ directory.
I tried running this script before but I think that is what caused the
odd behavior of the onpload file. What do I need to do here?
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: Schleicher, Keith
Sent: Friday, August 14, 2009 2:50 PM
To: 'ids@iiug.org'
Subject: RE: Issues with onpload [16692]
That still isn't working. I will try to get root access, but I really
would rather resolve it some other way if possible.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art Kagel
Sent: Friday, August 14, 2009 1:22 PM
To: ids@iiug.org
Subject: Re: Issues with onpload [16692]
chmod 2755 onpload
-- or --
chmod g+s onpload
Art
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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
> group permission?
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter_Logan@spartanstores.com
> Sent: Friday, August 14, 2009 12:34 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16688]
>
> Check to see if the file has the same permissions as where you copied
it
>
> from ...
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
> To:
> ids@iiug.org
> Date:
> 08/14/2009 01:31 PM
> Subject:
> Issues with onpload [16687]
> Sent by:
> ids-bounces@iiug.org
>
> Somehow the onpload file on our server got set to a blank file (byte =
> 0). I have no idea how this happened. I sftp'd an onpload file from
> another server to this server from the same version of Informix.
> However, when I try to run it, I get the following error:
>
> ksh: onpload: cannot execute
>
> Has anyone else seen this before? We are running on SunOS 5.10 and
> Informix version 11.50.UC2.
>
> Keith Schleicher
>
> IT Database Administrator
>
> B2-253B-A
>
> Office: 847-286-4027
>
> Cell: 224-210-8358
>
> Blackberry: 2242108358@messaging.sprintpcs.com
>
> Page: 2242108358@sprint.skytel.com
>
>
************************************************************************
> *******
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b9acb742f804711e1e16
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Open a case with IBM.
Art
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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> I reinstalled the instance and copied the onpload file over. However,
> when I try to run it, I get this:
>
> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
> pom_load -j nroxtrh -fl
>
> Incorrect database version. Make sure that is upgraded properly.
> To upgrade, manually run the conpload.sh or conpload.bat script, located
> in the $INFORMIXDIR/etc/conv/ directory.
>
> I tried running this script before but I think that is what caused the
> odd behavior of the onpload file. What do I need to do here?
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: Schleicher, Keith
> Sent: Friday, August 14, 2009 2:50 PM
> To: 'ids@iiug.org'
> Subject: RE: Issues with onpload [16692]
>
> That still isn't working. I will try to get root access, but I really
> would rather resolve it some other way if possible.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Friday, August 14, 2009 1:22 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16692]
>
> chmod 2755 onpload
> -- or --
> chmod g+s onpload
>
> Art
>
> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
> Keith.Schleicher@searshc.com> wrote:
>
> > OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
> > group permission?
> >
> > Keith Schleicher
> > IT Database Administrator
> > B2-253B-A
> > Office: 847-286-4027
> > Cell: 224-210-8358
> > Blackberry: 2242108358@messaging.sprintpcs.com
> > Page: 2242108358@sprint.skytel.com
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Peter_Logan@spartanstores.com
> > Sent: Friday, August 14, 2009 12:34 PM
> > To: ids@iiug.org
> > Subject: Re: Issues with onpload [16688]
> >
> > Check to see if the file has the same permissions as where you copied
> it
> >
> > from ...
> >
> > Peter Logan
> > Senior Database Administrator
> > Phone: 616/878-8309
> >
> > From:
> > "Schleicher, Keith" <Keith.Schleicher@searshc.com>
> > To:
> > ids@iiug.org
> > Date:
> > 08/14/2009 01:31 PM
> > Subject:
> > Issues with onpload [16687]
> > Sent by:
> > ids-bounces@iiug.org
> >
> > Somehow the onpload file on our server got set to a blank file (byte =
>
> > 0). I have no idea how this happened. I sftp'd an onpload file from
> > another server to this server from the same version of Informix.
> > However, when I try to run it, I get the following error:
> >
> > ksh: onpload: cannot execute
> >
> > Has anyone else seen this before? We are running on SunOS 5.10 and
> > Informix version 11.50.UC2.
> >
> > Keith Schleicher
> >
> > IT Database Administrator
> >
> > B2-253B-A
> >
> > Office: 847-286-4027
> >
> > Cell: 224-210-8358
> >
> > Blackberry: 2242108358@messaging.sprintpcs.com
> >
> > Page: 2242108358@sprint.skytel.com
> >
> >
> ************************************************************************
>
> > *******
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> ************************************************************************
>
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5b9acb742f804711e1e16
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015173ff2e0222f4d04715b8299
Unfortunately that isn't an option.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art Kagel
Sent: Monday, August 17, 2009 2:36 PM
To: ids@iiug.org
Subject: Re: Issues with onpload [16698]
Open a case with IBM.
Art
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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> I reinstalled the instance and copied the onpload file over. However,
> when I try to run it, I get this:
>
> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
> pom_load -j nroxtrh -fl
>
> Incorrect database version. Make sure that is upgraded properly.
> To upgrade, manually run the conpload.sh or conpload.bat script,
located
> in the $INFORMIXDIR/etc/conv/ directory.
>
> I tried running this script before but I think that is what caused the
> odd behavior of the onpload file. What do I need to do here?
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: Schleicher, Keith
> Sent: Friday, August 14, 2009 2:50 PM
> To: 'ids@iiug.org'
> Subject: RE: Issues with onpload [16692]
>
> That still isn't working. I will try to get root access, but I really
> would rather resolve it some other way if possible.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Friday, August 14, 2009 1:22 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16692]
>
> chmod 2755 onpload
> -- or --
> chmod g+s onpload
>
> Art
>
> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
> Keith.Schleicher@searshc.com> wrote:
>
> > OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
> > group permission?
> >
> > Keith Schleicher
> > IT Database Administrator
> > B2-253B-A
> > Office: 847-286-4027
> > Cell: 224-210-8358
> > Blackberry: 2242108358@messaging.sprintpcs.com
> > Page: 2242108358@sprint.skytel.com
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
Of
> > Peter_Logan@spartanstores.com
> > Sent: Friday, August 14, 2009 12:34 PM
> > To: ids@iiug.org
> > Subject: Re: Issues with onpload [16688]
> >
> > Check to see if the file has the same permissions as where you
copied
> it
> >
> > from ...
> >
> > Peter Logan
> > Senior Database Administrator
> > Phone: 616/878-8309
> >
> > From:
> > "Schleicher, Keith" <Keith.Schleicher@searshc.com>
> > To:
> > ids@iiug.org
> > Date:
> > 08/14/2009 01:31 PM
> > Subject:
> > Issues with onpload [16687]
> > Sent by:
> > ids-bounces@iiug.org
> >
> > Somehow the onpload file on our server got set to a blank file (byte
=
>
> > 0). I have no idea how this happened. I sftp'd an onpload file from
> > another server to this server from the same version of Informix.
> > However, when I try to run it, I get the following error:
> >
> > ksh: onpload: cannot execute
> >
> > Has anyone else seen this before? We are running on SunOS 5.10 and
> > Informix version 11.50.UC2.
> >
> > Keith Schleicher
> >
> > IT Database Administrator
> >
> > B2-253B-A
> >
> > Office: 847-286-4027
> >
> > Cell: 224-210-8358
> >
> > Blackberry: 2242108358@messaging.sprintpcs.com
> >
> > Page: 2242108358@sprint.skytel.com
> >
> >
>
************************************************************************
>
> > *******
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
************************************************************************
>
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5b9acb742f804711e1e16
>
>
************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015173ff2e0222f4d04715b8299
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Did you try to drop the onpload database?
On the first run, if it doesn´t exist, I´ll be self-created....
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> Unfortunately that isn't an option.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Monday, August 17, 2009 2:36 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16698]
>
> Open a case with IBM.
>
> Art
>
> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
> Keith.Schleicher@searshc.com> wrote:
>
>
>> I reinstalled the instance and copied the onpload file over. However,
>> when I try to run it, I get this:
>>
>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>> pom_load -j nroxtrh -fl
>>
>> Incorrect database version. Make sure that is upgraded properly.
>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>
> located
>
>> in the $INFORMIXDIR/etc/conv/ directory.
>>
>> I tried running this script before but I think that is what caused the
>>
>
>
>> odd behavior of the onpload file. What do I need to do here?
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: Schleicher, Keith
>> Sent: Friday, August 14, 2009 2:50 PM
>> To: 'ids@iiug.org'
>> Subject: RE: Issues with onpload [16692]
>>
>> That still isn't working. I will try to get root access, but I really
>> would rather resolve it some other way if possible.
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Art Kagel
>> Sent: Friday, August 14, 2009 1:22 PM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16692]
>>
>> chmod 2755 onpload
>> -- or --
>> chmod g+s onpload
>>
>> Art
>>
>> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
>> Keith.Schleicher@searshc.com> wrote:
>>
>>
>>> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
>>> group permission?
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>>>
> Of
>
>>> Peter_Logan@spartanstores.com
>>> Sent: Friday, August 14, 2009 12:34 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16688]
>>>
>>> Check to see if the file has the same permissions as where you
>>>
> copied
>
>> it
>>
>>> from ...
>>>
>>> Peter Logan
>>> Senior Database Administrator
>>> Phone: 616/878-8309
>>>
>>> From:
>>> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
>>> To:
>>> ids@iiug.org
>>> Date:
>>> 08/14/2009 01:31 PM
>>> Subject:
>>> Issues with onpload [16687]
>>> Sent by:
>>> ids-bounces@iiug.org
>>>
>>> Somehow the onpload file on our server got set to a blank file (byte
>>>
> =
>
>>> 0). I have no idea how this happened. I sftp'd an onpload file from
>>> another server to this server from the same version of Informix.
>>> However, when I try to run it, I get the following error:
>>>
>>> ksh: onpload: cannot execute
>>>
>>> Has anyone else seen this before? We are running on SunOS 5.10 and
>>> Informix version 11.50.UC2.
>>>
>>> Keith Schleicher
>>>
>>> IT Database Administrator
>>>
>>> B2-253B-A
>>>
>>> Office: 847-286-4027
>>>
>>> Cell: 224-210-8358
>>>
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>
>>> Page: 2242108358@sprint.skytel.com
>>>
>>>
>>>
> ************************************************************************
>
>
>>> *******
>>>
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
> ************************************************************************
>
>
>>> *******
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>>>
>>>
> ************************************************************************
>
>
>> *******
>>
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>> --001636c5b9acb742f804711e1e16
>>
>>
>>
> ************************************************************************
>
>
>> *******
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>
>>
> ************************************************************************
> *******
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
> --0015173ff2e0222f4d04715b8299
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
I dropped the onpload database and then tried running it again and I'm getting
a new error:
IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load -j
nroxtrh -fl
Error occured at HPL failpoint: 16603
Cannot open database 'onpload' - SQL error -329, ISAM error -111
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alexandre Marini
Sent: Tuesday, August 18, 2009 6:36 AM
To: ids@iiug.org
Subject: Re: Issues with onpload [16705]
Did you try to drop the onpload database?
On the first run, if it doesn´t exist, I´ll be self-created....
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> Unfortunately that isn't an option.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Monday, August 17, 2009 2:36 PM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16698]
>
> Open a case with IBM.
>
> Art
>
> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
> Keith.Schleicher@searshc.com> wrote:
>
>
>> I reinstalled the instance and copied the onpload file over. However,
>> when I try to run it, I get this:
>>
>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>> pom_load -j nroxtrh -fl
>>
>> Incorrect database version. Make sure that is upgraded properly.
>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>
> located
>
>> in the $INFORMIXDIR/etc/conv/ directory.
>>
>> I tried running this script before but I think that is what caused the
>>
>
>
>> odd behavior of the onpload file. What do I need to do here?
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: Schleicher, Keith
>> Sent: Friday, August 14, 2009 2:50 PM
>> To: 'ids@iiug.org'
>> Subject: RE: Issues with onpload [16692]
>>
>> That still isn't working. I will try to get root access, but I really
>> would rather resolve it some other way if possible.
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Art Kagel
>> Sent: Friday, August 14, 2009 1:22 PM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16692]
>>
>> chmod 2755 onpload
>> -- or --
>> chmod g+s onpload
>>
>> Art
>>
>> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
>> Keith.Schleicher@searshc.com> wrote:
>>
>>
>>> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
>>> group permission?
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>>>
> Of
>
>>> Peter_Logan@spartanstores.com
>>> Sent: Friday, August 14, 2009 12:34 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16688]
>>>
>>> Check to see if the file has the same permissions as where you
>>>
> copied
>
>> it
>>
>>> from ...
>>>
>>> Peter Logan
>>> Senior Database Administrator
>>> Phone: 616/878-8309
>>>
>>> From:
>>> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
>>> To:
>>> ids@iiug.org
>>> Date:
>>> 08/14/2009 01:31 PM
>>> Subject:
>>> Issues with onpload [16687]
>>> Sent by:
>>> ids-bounces@iiug.org
>>>
>>> Somehow the onpload file on our server got set to a blank file (byte
>>>
> =
>
>>> 0). I have no idea how this happened. I sftp'd an onpload file from
>>> another server to this server from the same version of Informix.
>>> However, when I try to run it, I get the following error:
>>>
>>> ksh: onpload: cannot execute
>>>
>>> Has anyone else seen this before? We are running on SunOS 5.10 and
>>> Informix version 11.50.UC2.
>>>
>>> Keith Schleicher
>>>
>>> IT Database Administrator
>>>
>>> B2-253B-A
>>>
>>> Office: 847-286-4027
>>>
>>> Cell: 224-210-8358
>>>
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>
>>> Page: 2242108358@sprint.skytel.com
>>>
>>>
>>>
> ************************************************************************
>
>
>>> *******
>>>
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
> ************************************************************************
>
>
>>> *******
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>>>
>>>
> ************************************************************************
>
>
>> *******
>>
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>> --001636c5b9acb742f804711e1e16
>>
>>
>>
> ************************************************************************
>
>
>> *******
>> Forum Note: Use "Reply@@
All the times I needed to drop the database, when I run the graphical
interface,
it was reconstructed fine.
obs: ipload is the command line for the graphical interface.
Check on the dbaccess, is your onpload database created?
If not, I suggest you open a graphical terminal and run the interface.
Or you could take the recommendations, and run the migration utility
(To upgrade, manually run the conpload.sh or conpload.bat script)
I found "strange" you upgrade your engine and copy the old executable
file onpload.
Don´t see any utility on copying the executable files of the old engine,
to a new installation.
Copy just the configuration files (onconfig, sqlhosts, etc) ok? And read
carefully the
new machine notes and release notes, to see if there´s parameters
deprecated, and new ones.
Regards.
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> I dropped the onpload database and then tried running it again and I'm
getting
> a new error:
>
> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load -j
> nroxtrh -fl
> Error occured at HPL failpoint: 16603
>
> Cannot open database 'onpload' - SQL error -329, ISAM error -111
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Tuesday, August 18, 2009 6:36 AM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16705]
>
> Did you try to drop the onpload database?
> On the first run, if it doesn´t exist, I´ll be self-created....
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>
> IIUG Member
>
> <http://www.iiug.org>;
>
> Schleicher, Keith escreveu:
>
>> Unfortunately that isn't an option.
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Art Kagel
>> Sent: Monday, August 17, 2009 2:36 PM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16698]
>>
>> Open a case with IBM.
>>
>> Art
>>
>> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
>> Keith.Schleicher@searshc.com> wrote:
>>
>>
>>
>>> I reinstalled the instance and copied the onpload file over. However,
>>> when I try to run it, I get this:
>>>
>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>>> pom_load -j nroxtrh -fl
>>>
>>> Incorrect database version. Make sure that is upgraded properly.
>>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>>
>>>
>> located
>>
>>
>>> in the $INFORMIXDIR/etc/conv/ directory.
>>>
>>> I tried running this script before but I think that is what caused the
>>>
>>>
>>
>>> odd behavior of the onpload file. What do I need to do here?
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: Schleicher, Keith
>>> Sent: Friday, August 14, 2009 2:50 PM
>>> To: 'ids@iiug.org'
>>> Subject: RE: Issues with onpload [16692]
>>>
>>> That still isn't working. I will try to get root access, but I really
>>> would rather resolve it some other way if possible.
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Art Kagel
>>> Sent: Friday, August 14, 2009 1:22 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16692]
>>>
>>> chmod 2755 onpload
>>> -- or --
>>> chmod g+s onpload
>>>
>>> Art
>>>
>>> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
>>> Keith.Schleicher@searshc.com> wrote:
>>>
>>>
>>>
>>>> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
>>>> group permission?
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>>>>
>>>>
>> Of
>>
>>
>>>> Peter_Logan@spartanstores.com
>>>> Sent: Friday, August 14, 2009 12:34 PM
>>>> To: ids@iiug.org
>>>> Subject: Re: Issues with onpload [16688]
>>>>
>>>> Check to see if the file has the same permissions as where you
>>>>
>>>>
>> copied
>>
>>
>>> it
>>>
>>>
>>>> from ...
>>>>
>>>> Peter Logan
>>>> Senior Database Administrator
>>>> Phone: 616/878-8309
>>>>
>>>> From:
>>>> "Schleicher, Keith" <Keith.Schleicher@searshc.com>
>>>> To:
>>>> ids@iiug.org
>>>> Date:
>>>> 08/14/2009 01:31 PM
>>>> Subject:
>>>> Issues with onpload [16687]
>>>> Sent by:
>>>> ids-bounces@iiug.org
>>>>
>>>> Somehow the onpload file on our server got set to a blank file (byte
>>>>
>>>>
>> =
>>
>>
>>>> 0). I have no idea how this happened. I sftp'd an onpload file from
>>>> anothe
I made a copy of the onpload file from a different directory that I installed
the same database server to. I didn't copy the onpload over from a different
version, but since the file got corrupted I needed to make a copy somehow.
I did try running conpload.sh (I couldn't find the conpload.bat script), but I
still got the same error. I will try to run the graphical interface, but I am
not sure how quickly I can get that done.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alexandre Marini
Sent: Tuesday, August 18, 2009 9:19 AM
To: ids@iiug.org
Subject: Re: Issues with onpload [16707]
All the times I needed to drop the database, when I run the graphical
interface,
it was reconstructed fine.
obs: ipload is the command line for the graphical interface.
Check on the dbaccess, is your onpload database created?
If not, I suggest you open a graphical terminal and run the interface.
Or you could take the recommendations, and run the migration utility
(To upgrade, manually run the conpload.sh or conpload.bat script)
I found "strange" you upgrade your engine and copy the old executable
file onpload.
Don´t see any utility on copying the executable files of the old engine,
to a new installation.
Copy just the configuration files (onconfig, sqlhosts, etc) ok? And read
carefully the
new machine notes and release notes, to see if there´s parameters
deprecated, and new ones.
Regards.
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> I dropped the onpload database and then tried running it again and I'm
getting
> a new error:
>
> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load -j
> nroxtrh -fl
> Error occured at HPL failpoint: 16603
>
> Cannot open database 'onpload' - SQL error -329, ISAM error -111
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Tuesday, August 18, 2009 6:36 AM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16705]
>
> Did you try to drop the onpload database?
> On the first run, if it doesn´t exist, I´ll be self-created....
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>
> IIUG Member
>
> <http://www.iiug.org>;
>
> Schleicher, Keith escreveu:
>
>> Unfortunately that isn't an option.
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Art Kagel
>> Sent: Monday, August 17, 2009 2:36 PM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16698]
>>
>> Open a case with IBM.
>>
>> Art
>>
>> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
>> Keith.Schleicher@searshc.com> wrote:
>>
>>
>>
>>> I reinstalled the instance and copied the onpload file over. However,
>>> when I try to run it, I get this:
>>>
>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>>> pom_load -j nroxtrh -fl
>>>
>>> Incorrect database version. Make sure that is upgraded properly.
>>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>>
>>>
>> located
>>
>>
>>> in the $INFORMIXDIR/etc/conv/ directory.
>>>
>>> I tried running this script before but I think that is what caused the
>>>
>>>
>>
>>> odd behavior of the onpload file. What do I need to do here?
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: Schleicher, Keith
>>> Sent: Friday, August 14, 2009 2:50 PM
>>> To: 'ids@iiug.org'
>>> Subject: RE: Issues with onpload [16692]
>>>
>>> That still isn't working. I will try to get root access, but I really
>>> would rather resolve it some other way if possible.
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Art Kagel
>>> Sent: Friday, August 14, 2009 1:22 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16692]
>>>
>>> chmod 2755 onpload
>>> -- or --
>>> chmod g+s onpload
>>>
>>> Art
>>>
>>> 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 explicitly or implicitly. 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, Aug 14, 2009 at 1:36 PM, Schleicher, Keith <
>>> Keith.Schleicher@searshc.com> wrote:
>>>
>>>
>>>
>>>> OK, the permissions are "-rwxr-sr-x". How do I get that "s" for the
>>>> group permission?
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
>>>>
>>>>
>> Of
>>
>>
>>>> Peter_Logan@spartanstore
Obs: what´s your database version and architecture ??
The .bat script is only for windows arch!!!
did you run the script with informix user???
Are your $INFORMIXDIR environment variable pointing to the new
binaries??? Or the old ones??
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> I made a copy of the onpload file from a different directory that I installed
> the same database server to. I didn't copy the onpload over from a different
> version, but since the file got corrupted I needed to make a copy somehow.
>
> I did try running conpload.sh (I couldn't find the conpload.bat script), but
I
> still got the same error. I will try to run the graphical interface, but I am
> not sure how quickly I can get that done.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Tuesday, August 18, 2009 9:19 AM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16707]
>
> All the times I needed to drop the database, when I run the graphical
> interface,
> it was reconstructed fine.
> obs: ipload is the command line for the graphical interface.
>
> Check on the dbaccess, is your onpload database created?
> If not, I suggest you open a graphical terminal and run the interface.
> Or you could take the recommendations, and run the migration utility
> (To upgrade, manually run the conpload.sh or conpload.bat script)
>
> I found "strange" you upgrade your engine and copy the old executable
> file onpload.
> Don´t see any utility on copying the executable files of the old engine,
> to a new installation.
> Copy just the configuration files (onconfig, sqlhosts, etc) ok? And read
> carefully the
> new machine notes and release notes, to see if there´s parameters
> deprecated, and new ones.
>
> Regards.
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>
> IIUG Member
>
> <http://www.iiug.org>;
>
> Schleicher, Keith escreveu:
>
>> I dropped the onpload database and then tried running it again and I'm
>>
> getting
>
>> a new error:
>>
>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load -j
>> nroxtrh -fl
>> Error occured at HPL failpoint: 16603
>>
>> Cannot open database 'onpload' - SQL error -329, ISAM error -111
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Alexandre Marini
>> Sent: Tuesday, August 18, 2009 6:36 AM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16705]
>>
>> Did you try to drop the onpload database?
>> On the first run, if it doesn´t exist, I´ll be self-created....
>>
>> Alexandre Marini
>>
>> Tecnologia da Informação - DBA
>>
>> msn: alexandre_marini@hotmail.com
>>
>> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>>
>> IIUG Member
>>
>> <http://www.iiug.org>;
>>
>> Schleicher, Keith escreveu:
>>
>>
>>> Unfortunately that isn't an option.
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Art Kagel
>>> Sent: Monday, August 17, 2009 2:36 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16698]
>>>
>>> Open a case with IBM.
>>>
>>> Art
>>>
>>> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
>>> Keith.Schleicher@searshc.com> wrote:
>>>
>>>
>>>
>>>
>>>> I reinstalled the instance and copied the onpload file over. However,
>>>> when I try to run it, I get this:
>>>>
>>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>>>> pom_load -j nroxtrh -fl
>>>>
>>>> Incorrect database version. Make sure that is upgraded properly.
>>>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>>>
>>>>
>>>>
>>> located
>>>
>>>
>>>
>>>> in the $INFORMIXDIR/etc/conv/ directory.
>>>>
>>>> I tried running this script before but I think that is what caused the
>>>>
>>>>
>>>>
>>>> odd behavior of the onpload file. What do I need to do here?
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: Schleicher, Keith
>>>> Sent: Friday, August 14, 2009 2:50 PM
>>>> To: 'ids@iiug.org'
>>>> Subject: RE: Issues with onpload [16692]
>>>>
>>>> That still isn't working. I will try to get root access, but I really
>>>> would rather resolve it some other way if possible.
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>>> Art Kagel
>>>> Sent: Friday, August 14, 2009 1:22 PM
>>>> To: ids@iiug.org
>>>> Subject: Re: Issues with onpload [16692]
>>>>
>>>> chmod 2755 onpload
>>>> -- or --
>>>> chmod g+s onpload
>>>>
>>>> Art
>>>>
>>>> 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 explicitly or implicitly. Neither do
>>>>
>>>>
>>>>
>>>> those opinions reflect those of other individuals affiliated with
The old database is on Informix 9.21.UC2 on AIX. The new database is on
Informix 11.50.UC2 on a Sun Solaris 10 box.
I did update the server, rejetfile, and logfile variables in the session table
in the onpload database.
Keith Schleicher
IT Database Administrator
B2-253B-A
Office: 847-286-4027
Cell: 224-210-8358
Blackberry: 2242108358@messaging.sprintpcs.com
Page: 2242108358@sprint.skytel.com
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alexandre Marini
Sent: Tuesday, August 18, 2009 11:47 AM
To: ids@iiug.org
Subject: Re: Issues with onpload [16710]
Obs: what´s your database version and architecture ??
The .bat script is only for windows arch!!!
did you run the script with informix user???
Are your $INFORMIXDIR environment variable pointing to the new
binaries??? Or the old ones??
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> I made a copy of the onpload file from a different directory that I
installed
> the same database server to. I didn't copy the onpload over from a different
> version, but since the file got corrupted I needed to make a copy somehow.
>
> I did try running conpload.sh (I couldn't find the conpload.bat script), but
I
> still got the same error. I will try to run the graphical interface, but I
am
> not sure how quickly I can get that done.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Tuesday, August 18, 2009 9:19 AM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16707]
>
> All the times I needed to drop the database, when I run the graphical
> interface,
> it was reconstructed fine.
> obs: ipload is the command line for the graphical interface.
>
> Check on the dbaccess, is your onpload database created?
> If not, I suggest you open a graphical terminal and run the interface.
> Or you could take the recommendations, and run the migration utility
> (To upgrade, manually run the conpload.sh or conpload.bat script)
>
> I found "strange" you upgrade your engine and copy the old executable
> file onpload.
> Don´t see any utility on copying the executable files of the old engine,
> to a new installation.
> Copy just the configuration files (onconfig, sqlhosts, etc) ok? And read
> carefully the
> new machine notes and release notes, to see if there´s parameters
> deprecated, and new ones.
>
> Regards.
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>
> IIUG Member
>
> <http://www.iiug.org>;
>
> Schleicher, Keith escreveu:
>
>> I dropped the onpload database and then tried running it again and I'm
>>
> getting
>
>> a new error:
>>
>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load
-j
>> nroxtrh -fl
>> Error occured at HPL failpoint: 16603
>>
>> Cannot open database 'onpload' - SQL error -329, ISAM error -111
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Alexandre Marini
>> Sent: Tuesday, August 18, 2009 6:36 AM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16705]
>>
>> Did you try to drop the onpload database?
>> On the first run, if it doesn´t exist, I´ll be self-created....
>>
>> Alexandre Marini
>>
>> Tecnologia da Informação - DBA
>>
>> msn: alexandre_marini@hotmail.com
>>
>> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>>
>> IIUG Member
>>
>> <http://www.iiug.org>;
>>
>> Schleicher, Keith escreveu:
>>
>>
>>> Unfortunately that isn't an option.
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Art Kagel
>>> Sent: Monday, August 17, 2009 2:36 PM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16698]
>>>
>>> Open a case with IBM.
>>>
>>> Art
>>>
>>> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
>>> Keith.Schleicher@searshc.com> wrote:
>>>
>>>
>>>
>>>
>>>> I reinstalled the instance and copied the onpload file over. However,
>>>> when I try to run it, I get this:
>>>>
>>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>>>> pom_load -j nroxtrh -fl
>>>>
>>>> Incorrect database version. Make sure that is upgraded properly.
>>>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>>>
>>>>
>>>>
>>> located
>>>
>>>
>>>
>>>> in the $INFORMIXDIR/etc/conv/ directory.
>>>>
>>>> I tried running this script before but I think that is what caused the
>>>>
>>>>
>>>>
>>>> odd behavior of the onpload file. What do I need to do here?
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: Schleicher, Keith
>>>> Sent: Friday, August 14, 2009 2:50 PM
>>>> To: 'ids@iiug.org'
>>>> Subject: RE: Issues with onpload [16692]
>>>>
>>>> That still isn't working. I will try to get root access, but I really
>>>> would rather resolve it some other way if possible.
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>>> Art Kagel
>>>> Sent: Friday, August 14, 2009 1:22 PM
>>>> To: ids@iiug.org@@N
Sorry, all my ideas are gone for now... if someone could give you
another one, regards.....
Alexandre Marini
Tecnologia da Informação - DBA
SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
IIUG Member
<http://www.iiug.org>;
Schleicher, Keith escreveu:
> The old database is on Informix 9.21.UC2 on AIX. The new database is on
> Informix 11.50.UC2 on a Sun Solaris 10 box.
>
> I did update the server, rejetfile, and logfile variables in the session
table
> in the onpload database.
>
> Keith Schleicher
> IT Database Administrator
> B2-253B-A
> Office: 847-286-4027
> Cell: 224-210-8358
> Blackberry: 2242108358@messaging.sprintpcs.com
> Page: 2242108358@sprint.skytel.com
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Tuesday, August 18, 2009 11:47 AM
> To: ids@iiug.org
> Subject: Re: Issues with onpload [16710]
>
> Obs: what´s your database version and architecture ??
> The .bat script is only for windows arch!!!
> did you run the script with informix user???
> Are your $INFORMIXDIR environment variable pointing to the new
> binaries??? Or the old ones??
>
> Alexandre Marini
>
> Tecnologia da Informação - DBA
>
> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>
> IIUG Member
>
> <http://www.iiug.org>;
>
> Schleicher, Keith escreveu:
>
>> I made a copy of the onpload file from a different directory that I
>>
> installed
>
>> the same database server to. I didn't copy the onpload over from a different
>> version, but since the file got corrupted I needed to make a copy somehow.
>>
>> I did try running conpload.sh (I couldn't find the conpload.bat script), but
>>
> I
>
>> still got the same error. I will try to run the graphical interface, but I
>>
> am
>
>> not sure how quickly I can get that done.
>>
>> Keith Schleicher
>> IT Database Administrator
>> B2-253B-A
>> Office: 847-286-4027
>> Cell: 224-210-8358
>> Blackberry: 2242108358@messaging.sprintpcs.com
>> Page: 2242108358@sprint.skytel.com
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>> Alexandre Marini
>> Sent: Tuesday, August 18, 2009 9:19 AM
>> To: ids@iiug.org
>> Subject: Re: Issues with onpload [16707]
>>
>> All the times I needed to drop the database, when I run the graphical
>> interface,
>> it was reconstructed fine.
>> obs: ipload is the command line for the graphical interface.
>>
>> Check on the dbaccess, is your onpload database created?
>> If not, I suggest you open a graphical terminal and run the interface.
>> Or you could take the recommendations, and run the migration utility
>> (To upgrade, manually run the conpload.sh or conpload.bat script)
>>
>> I found "strange" you upgrade your engine and copy the old executable
>> file onpload.
>> Don´t see any utility on copying the executable files of the old engine,
>> to a new installation.
>> Copy just the configuration files (onconfig, sqlhosts, etc) ok? And read
>> carefully the
>> new machine notes and release notes, to see if there´s parameters
>> deprecated, and new ones.
>>
>> Regards.
>>
>> Alexandre Marini
>>
>> Tecnologia da Informação - DBA
>>
>> msn: alexandre_marini@hotmail.com
>>
>> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>>
>> IIUG Member
>>
>> <http://www.iiug.org>;
>>
>> Schleicher, Keith escreveu:
>>
>>
>>> I dropped the onpload database and then tried running it again and I'm
>>>
>>>
>> getting
>>
>>
>>> a new error:
>>>
>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p pom_load
>>>
> -j
>
>>> nroxtrh -fl
>>> Error occured at HPL failpoint: 16603
>>>
>>> Cannot open database 'onpload' - SQL error -329, ISAM error -111
>>>
>>> Keith Schleicher
>>> IT Database Administrator
>>> B2-253B-A
>>> Office: 847-286-4027
>>> Cell: 224-210-8358
>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>> Page: 2242108358@sprint.skytel.com
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>> Alexandre Marini
>>> Sent: Tuesday, August 18, 2009 6:36 AM
>>> To: ids@iiug.org
>>> Subject: Re: Issues with onpload [16705]
>>>
>>> Did you try to drop the onpload database?
>>> On the first run, if it doesn´t exist, I´ll be self-created....
>>>
>>> Alexandre Marini
>>>
>>> Tecnologia da Informação - DBA
>>>
>>> msn: alexandre_marini@hotmail.com
>>>
>>> SEFAZ-MS / SGI-UIMP / Sistemas IBM-Informix
>>>
>>> IIUG Member
>>>
>>> <http://www.iiug.org>;
>>>
>>> Schleicher, Keith escreveu:
>>>
>>>
>>>
>>>> Unfortunately that isn't an option.
>>>>
>>>> Keith Schleicher
>>>> IT Database Administrator
>>>> B2-253B-A
>>>> Office: 847-286-4027
>>>> Cell: 224-210-8358
>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>> Page: 2242108358@sprint.skytel.com
>>>>
>>>> -----Original Message-----
>>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
>>>> Art Kagel
>>>> Sent: Monday, August 17, 2009 2:36 PM
>>>> To: ids@iiug.org
>>>> Subject: Re: Issues with onpload [16698]
>>>>
>>>> Open a case with IBM.
>>>>
>>>> Art
>>>>
>>>> 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 explicitly or implicitly. 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 Mon, Aug 17, 2009 at 1:43 PM, Schleicher, Keith <
>>>> Keith.Schleicher@searshc.com> wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> I reinstalled the instance and copied the onpload file over. However,
>>>>> when I try to run it, I get this:
>>>>>
>>>>> IFMX11:/pom_stage2_m>/dbengine/informix_11.50.uc2/bin/onpload -p
>>>>> pom_load -j nroxtrh -fl
>>>>>
>>>>> Incorrect database version. Make sure that is upgraded properly.
>>>>> To upgrade, manually run the conpload.sh or conpload.bat script,
>>>>>
>>>>>
>>>>>
>>>>>
>>>> located
>>>>
>>>>
>>>>
>>>>
>>>>> in the $INFORMIXDIR/etc/conv/ directory.
>>>>>
>>>>> I tried running this script before but I think that is what caused the
>>>>>
>>>>>
>>>>>
>>>>> odd behavior of the onpload file. What do I need to do here?
>>>>>
>>>>> Keith Schleicher
>>>>> IT Database Administrator
>>>>> B2-253B-A
>>>>> Office: 847-286-4027
>>>>> Cell: 224-210-8358
>>>>> Blackberry: 2242108358@messaging.sprintpcs.com
>>>>> Page: 2242108358@sprint.skytel.com
>>>>>
>>>>> -----Original Message-----
>>>>> From: Schleicher, Keith
>>>>> Sent: Friday, August 14, 2009 2:50 PM@