|
IDS Forum
RE: Issues with onpload
Posted By: Schleicher, Keith Date: Thursday, 20 August 2009, at 3:43 p.m.
In Response To: Re: Issues with onpload (Alexandre Marini)
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
>>>> 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.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
*******************************************************************************
>
>> 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.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Messages In This Thread
- Issues with onpload
Schleicher, Keith -- Friday, 14 August 2009, at 1:30 p.m.
- Re: Issues with onpload
Peter_Logan@spartanstores.com -- Friday, 14 August 2009, at 1:33 p.m.
- RE: Issues with onpload
Schleicher, Keith -- Friday, 14 August 2009, at 1:36 p.m.
- Re: Issues with onpload
Art Kagel -- Friday, 14 August 2009, at 2:21 p.m.
- RE: Issues with onpload
Schleicher, Keith -- Friday, 14 August 2009, at 3:49 p.m.
- RE: Issues with onpload
Schleicher, Keith -- Monday, 17 August 2009, at 1:43 p.m.
- Re: Issues with onpload
Art Kagel -- Monday, 17 August 2009, at 3:35 p.m.
- RE: Issues with onpload
Schleicher, Keith -- Monday, 17 August 2009, at 4:58 p.m.
- Re: Issues with onpload
Alexandre Marini -- Tuesday, 18 August 2009, at 7:36 a.m.
- RE: Issues with onpload
Schleicher, Keith -- Tuesday, 18 August 2009, at 9:47 a.m.
- Re: Issues with onpload
Alexandre Marini -- Tuesday, 18 August 2009, at 10:19 a.m.
- RE: Issues with onpload
Schleicher, Keith -- Tuesday, 18 August 2009, at 10:28 a.m.
- Re: Issues with onpload
Alexandre Marini -- Tuesday, 18 August 2009, at 12:47 p.m.
- RE: Issues with onpload
Schleicher, Keith -- Thursday, 20 August 2009, at 3:43 p.m.
- Re: Issues with onpload
Art Kagel -- Friday, 14 August 2009, at 2:19 p.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|