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: Tuesday, 18 August 2009, at 12:47 p.m.

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

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.
>
>
>
>

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.