Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Issues with onpload

Posted By: Alexandre Marini
Date: Friday, 21 August 2009, at 7:39 a.m.

In Response To: RE: Issues with onpload (Schleicher, Keith)

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
>>>>> 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.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.