Oninit® Archive
Results for “DUMPCORE”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
Stuart: Yes, RALLOC_MODE is a diagnostic setting only used temporarily on advice from tech support to help them diagnose specific suspected memory issues. It has been known to cause memory allocation issues of its own in the past. You should unset that. Art ----------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Potentially Serious HDR Bug 14.10.FC7W1
Support is asking me to hop in my time machine, go back to the moment where things screwed up and gather diagnostics THEN. Uhh, thanks? ------------------------------ TOM GIRSCH ------------------------------…
curious about extendable chunks
Yet, the raw devices should work wiht informix, if there is no other diagnostics, try something like strace -f onspaces -a idxdbs -p /informix/links/ifmx_raw_1 -o 0 -s 100000 the output will give O/S error code for the operation. Most likely cause would be access not aligned on d…
Adding primary to a table having duplicate rows
Piyush, The volutations statement will work for the primary key on insert or update, not when there is already data in the table. From the manual. "When a constraint or unique index is in filtering mode, the statement succeeds and the database server enforces the constraint or th…
Can I request Case Open for Informix 11.50?
My understanding from the conference, you can get support now but it is a 'no fix' support i.e. any bugs will not be fixed but general help/diagnostic will be available Cheers Paul > Only if you have signed and paid for an extended support agreement with > IBM. > Shy not just upg…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Error -172
Hi all, with one of our 4gl-programs we occaisonally get the following errors: Program stopped at "//home/projekte/qualifiziert/qualifiziert_5.0/qual_del.4gl", line number 1606. Date: 13.07.2018 Time: 19:43:30 Program error at "//home/projekte/qualifiziert/qualifiziert_5.0/qual…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Erroc when dropping a table -- how to debug?
Hi, > Sounds weird ... is this situation still persisting? Could it even be reproduced? Yes, actually easily. Just not so easy to put into a separate program that I could show. > Re. -103 "illegal key descriptor": this would indicate some sort of index related problem, but aga…
How to avoid blocking checkpoints?
Dear: I have a problem with the checkpoints of an IDS 7.31 TD6 engine running on a Windows 2008 Server R2. The server has an array of 4 disks in RAID 5 for the data, and 3 arrays more than 2 disks in RAID 1 for the dbspaces temorial, for the Logdbs, and for the Physical Log, res…
onmode -I 154,-1 143 -1
No. In order to dump shared memory that memory has to be quiescent, unchanging. So the engine blocks all processing during the dump. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Discla…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
Can't compile SQLCMD
I'm struggling to build sqlcmd on Redhat 6.7. RHEL6.7 is shipped with GCC 4.4.7 and I'm getting the error "#pragma GCC Diagnostic not allowed inside functions" (initially this occurs during the compile of ensprintf.c). I have a feeling this might be a bug in GCC 4.4.7. Does anyo…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Slowest restore Ever via onbar need help
Hi Gurus, I need your help in my onbar restore. I am doing redirected restore from machine 1 to machine2(DEV). This is the first time i encountered so so so so slow restoration. It's working but a 10 GB restore will took me 10 hours.. Here's the onconfig file. I hope someone ca…
upgrade from 7.31 to 9.2
HI, IDS7.31 has ipload but haven't the onpladm,I want to use the HPL command line onpladm, so I try to upgrade from 7.31 to 9.2 using in-place upgrade. When I doing the upgrade using oninit, ids report below errors when running buildsmi. finderr 103 -103 ISAM error: illegal ke…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
esql pam module - undefined symbol: sqlca
On 21/06/13 00:58, Justin Killen wrote: > Now that it's all built and loading within the engine, I attempted to run a > select query and I'm getting an error with SQL code -23111. This turns out to > be: > > -23111 Internal error. Illegal argument for locale initialization. > > A…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
Issue about logical restore
Il 27/02/2013 16:17, Art Kagel ha scritto: > Re: Issue about logical restore > Posted By: Art Kagel <Send E-Mail> > Date: Wednesday, 27 February 2013, at 11:13 a.m. > In Response To: Re: Issue about logical restore (Francesco Alfano) > OK, first thing, version 9.30.xC2 is circ…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
unpacking IFMXULTIMTED11.50_FC9_LNX86_64MLRPM.bin
when i run script i get this Extracting the installation resources from the installer archive... Configuring the installer for this system's environment... libgcc_s.so.1 must be installed for pthread_cancel to work libgcc_s.so.1 must be installed for pthread_cancel to work Launc…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Re: What is happening to Informix?
Regarding this aspect, I think some examples may help to understand some differences... Not sure if I mentioned this here before... Sometime ago a query was catched running for something like two days (timings may be a bit imprecise) ... The DBA inquired the user who said that i…
Re: What is happening to Informix?
I agree with Fernando. I have open cases with Oracle and Sybase dating back to 1995 and 1991 respectively. OK, they probably closed them by now, but the point is that I NEVER GOT AN RESOLUTION TO THOSE TWO PROBLEMS! Informix had the best support in the industry BEFORE 1991 and …
What is happening to Informix?
I'm sorry, I just have to vent a bit. For the second time in 6 months, we have just experienced Informix crashing (assert failures) due to iniput of a syntactically and semantically correct SQL statement. The first time, we were on 11.5 (FC7, I think), tech support said the pro…
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
Re: "IDS seems to have shutdown cleanly"
well, I looked in some log files, like alarm, located in INFORMIXDIR\\\\etc to see if there were any diagnostic messages that would give me a clue to the problem, but there was nothing related to the inability to connect to the active instance. I ran onshutdown and it said IDS "s…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
chunk list when system down
Would this work with the database down ? An unable to check at present, as all my systems need to be up. Also, oncheck -pr produces a core dump, is there any way to debug this to find out why ?…
ER crashing ...
10.00.UC9 our ER server is crashing several times a day since yesterday with the following Assert Failure: 14:34:17 Assert Failed: Condition Failed (Bad allocation size (0) for pool 'CDR ' (0x715f0020)), In (mt_shm_malloc_segid) 14:34:17 Who: Session(8180, root@EastServer, 0, 7…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
IDS 7.31UD7 on MP-RAS not able to initialize
Wow didn't think MP-RAS still existed. If you search the CDI archives from around 1999/2000 then I know I was building a lot of MP-RAS/7.3x servers. You need/needed some very 'strange' settings - hopefully there is something there Cheers Paul > I am attempting to initialize 7.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
rootdbs size
The hardware is, according to RHEL within the VM, Dual Xeon X5660 2.8GHz ( 6 core, 12MB cache) with 6GB memory using SAN space for dbspace storage. The box's only purpose is the Informix DB and we are primarily a OLTP environment, but at night we do many DSS style batch jobs via …
IDS v11.10 hang: no error / logicalLog not full
Plateform: SunOS 5.10 Generic_138888-03 sqlhosts MYAPPLI_SHM onipcshm myHost myHost11 MYAPPLI_UA ontlitcp myHost myHost10 onconfig #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: INFO…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Handling Memory Limits
Occasionally we run into a situation on development hosts in which the informixserver is running several memory-intensive processes and attempts to procure more memory than the O/S permits. Since we don't set SHMTOTAL (and RESIDENT=0), the informixserver at first fills its tmp d…
Re: A teensy-weensy little oversight in the QA suite?
david@smooth1.co.uk wrote: > On 29 Jan, 14:01, Fernando Nunes <domusonl...@gmail.com> wrote: >> Accordingly to the report, if you need to upgrade TODAY, then use xC6 and >> use the workaround (force the building of the SMI). >> If you upgrade after xC6W1 is available then use it …
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
Application slow and data not saved
Hi, I have IDS v7.30.UC7 running on Solaris 2.6 with 1024Mb RAM and 1 CPU 400Mhz . There is 2 application db at this IDS. The problem is application will running slow and sometime data cannot be saved when more user used this application. This application already running about 8…
ontape -s -L 0 too slowly(onconfig)
continue,below is onconfig:(system has two cpu,4GB ram) # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dbspace/rootdbs # Path for device containing root dbspace ROOTOFFSET 10 # Offset of root dbspace into device (Kbytes) ROOTSIZE 2000000 # Size of ro…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
IDS 7.2 - Buffer modified in inconsistent chunk
Hi Art, Thanks for your prompt reply. I got the following message in Japanese with "oncheck -cDI 2097271": "Shared memory not initialized for INFORMIXSERVER 'ifmxhost006" Do we need to have at least some framework processes like oninit up and running when running oncheck -cDI? …
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
ipload core dumps
Hello all, As soon as I execute ipload or ipload -n the program fails with a core dump. The IDS is 11.5.FC3, the platform is AIX 6.1, the c compiler is AIX Xlc for AIX, the X server on my Windows XP SP2 PC is xming 6.9.0.31. I can run xclock and all of the standard pre-packaged…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Determining instance's oninits
red_valsen@yahoo.com wrote: > I have 3 informixservers running on a single host. One of the > instances has experienced an assertion failure and is now > unresponsive, so I'd like to kill its oninit processes and attempt to > restart it. But running onstat -g ses only reports a…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
-211 Cannot read system catalog systables
I'd start by running oncheck -cc <database>. After that I'd consider trapping for the error with onmode -I 211 (onmode -i will unset the error trap once the af file is generated)and looking at the diagnostics. I think the onmode -I cmd is undocumented so you might wanna call supp…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
RE: XPS 8.1
To All: I have just inherited an Informix XPS 8.1 instance. I believe that the plan was to eventually migrate away from it, so no upgrades were ever done and it is no longer supported. It has been running along fine up until about a week ago. All of a sudden, data uploads, queri…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Re: those who went to kansas
On 7 May, 02:38, John Carlson <jwcarls...@yahoo.com.invalid> wrote: > Andrew Ford wrote: > >> Where are the slides for this then? > > > I am told all slides for the 2008 IIUG conference will be in the members > > area of the IIUG web site later this week. > > > Andrew > > Cool . …
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Update from Digital 7.31.FD1to ....
Okay here the machine data and onconfig: The machine is a Compaq True 64 Unix V4.0 1229 alpha with 4 CPUs and 4 GB mainmemory. The only changes what we make is what stand in the releasenotes: shmmax = not change (2147483647) shmmni from 512 to 2048 shmseg from 150 to 512 semmni 4…
IBM Informix Technical Support Exchange Program - Thursday 15th November
This session is aimed at IBM Business Partners. As well as an overview of the features Backup and Restore features available it will also explore asscoiated problem determination and diagnostic techniques. http://www.iiug.org/news/announcements/partner_training.php…
Tuning IDS 7.3 TC9
Hi, i am going to change the server to fast processor and more memory. how can i customise the onconfig to performace db faster. current server is pentium 2-450 with 512MB RAM. new server is Xeon Quad Core 1.6 with 1GB RAM. current onconfig setting as below... Please help a…
Results: Exception Caught. Type: MT_EX_OS, Context
An internal error within the server code was caught by an exception handler which possibly core dumped and shut the engine down to prevent collateral damage to your data. The error was in some memory handling subsystem the details of which are only interesting to the server devel…
Re: PID - Post-Interim Drop (was: Informix 10 permissions problem?)
Jonathan Leffler wrote: > natebsi@gmail.com wrote: >> I spoke with Informix. [...] It may be fixed in the latest "pit >> drop"(sp? not familiar with that term, but he said it was like a >> service pack) or in FC7. > > A PID is a post-interim drop, also redundantly called a PID-dr…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Question on ownership of oninit
I seem to agree with Art's 10 year-old comment (see below) -- basically, if Informix instance is started by root, oninit processes will be owned by root; if started as Informix then they will be owned by Informix. However, at this environment, oninit processes are always owned b…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: dbexport core dumps
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:514v9hF1j3fb7U1@mid.individual.net... > IDS 7.22 on AIX > > I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and > the dbexport for 2 of them fails with a segmentation fault (I've tried it > multipl…
Re: dbexport core dumps
"scottishpoet" <dryburghj@yahoo.com> wrote in message news:1169030922.181023.143920@a75g2000cwd.googlegroups.com... > > also does oncheck run clean? are there other indexes on the table thats > just been unloaded other than the one that are in the create tabel > statement? if so…
Re: dbexport core dumps
"scottishpoet" <dryburghj@yahoo.com> wrote in message news:1169030922.181023.143920@a75g2000cwd.googlegroups.com... > If you have a dbexport binary from 7.31 for the OS you are migrating > you may want to try your export using that in case a defect in the > dbexport on 7.22 has b…
dbexport core dumps
IDS 7.22 on AIX I'm trying to upgrade this system to IDS 7.31. There are 3 databases, and the dbexport for 2 of them fails with a segmentation fault (I've tried it multiple times and it fails at the same point each time - see below). Obviously I'm not going to be able to get su…
Lost my database
my first posting here so please help me if I'm completely in the wrong group or something... I'm running INFORMIX-OnLine Version 7.24.UC7 on a HP-9000 machine with HP-UX B.10.20. My informix and hp experience is certainly not at an expert level so I'll telll you what I know. We …
Checkpoint taking more time
Hi Im having IDS 7.31 in HP-UX 4440 . Im having a problem with checkpoint taking lot of time when certain processes are running.rest of the time its taking 0 seconds. But sometimes its tabing 8,9,10 seconds How i can reduce the time taken for CKPT. I read that LRU writes should …
infdump
These are diagnostic files that IBM technical support can analyse as an aid to find the cause of failures They should not be created whenever you start and stop the engine. They should only be created if the engine aborts abnormally. How are you stopping the server? madh wrote:…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Help, I may be losing my mind ( Shared memory )
What is your "Buffers" set to? OS? and if you can maybe helpful to do a "oninit -v" to see if you get any messages that would give a clue. On 8/21/06, Floyd Wellershaus <fwellers@yahoo.com> wrote: > > > Good point about the OS restricting the size of the segment that can be > …
Re: Help, I may be losing my mind ( Shared memory )
Good point about the OS restricting the size of the segment that can be grabbed. But I am asking for 3.1gigs and it's giving me 4. Also, that doesn't explain why virtual is identical to resident. But it's a good place to start. Thanks. ======================== -<<Floyd Wel…
Re: Help, I may be losing my mind ( Shared memory )
What OS and OS Version? Find out from the SA (if it isn't you) what the SHM* values are. Maybe the values for the MIN values are set extremely high? Also what is the MAX value? If set to 2.1G then that would be why it was capped like it was. On 8/21/06, Floyd Wellershaus <fw…
Help, I may be losing my mind ( Shared memory )
I think I'm going crazy. I changed the SHMVIRTSIZE, LOCKS AND BUFFERS to take advantage of some new memory. Today, after reboot, I get these numbers and they make zero sense to me. 1) Why is my first virtual segment 4.2 G , when I have it configured to be 3.1G. 2) Why does the o…
Re: Contiguous shared memory segment allocation failed at 0xd0000000
You're on Version 10 ? You may be able to save resources and time on the delete part by using Truncate table. It can delete a whole table in one fell swoop. ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yah…
RE: Contiguous shared memory segment allocation failed at 0xd0000000
SHMBASE is different in your config from standard - why? How much shared memory is allocated to this instance (onstat -g seg) ? How many locks do you need for this process (16:10:23 dynamically allocated 100000 locks) ? OR you could lock the table. You need to configure LOCK…
Contiguous shared memory segment allocation failed at 0xd0000000
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000.…
Contiguous shared memory segment allocation failed
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000. Al…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: Select Query hangs up on IDS 9.40.
> > It _might_ be. Probably not, but running the new one is worth a shot. > > Art S. Kagel We can reproduce the problem on our DEV server which is 9.4UC5. I ran with the latest dostats (it works no more core dump) and it did not resolve the problem. I just want to make clear …
RE: checkpoint problem
Duplicate problem?? Have you got KAIO turned on? How many dbspaces/chunks/disks have you got? Are your chunks cooked or raw? onstat -d Keith -> -----Original Message----- -> From: mchivaviro@okzim.co.zw [mailto:mchivaviro@okzim.co.zw] -> Sent: Tuesday, June 20, 2006 7:58 AM ->…
checkpoint problem
I am runnind IDS 7.31 on HPUX 11 and my check points a taking too long. What do I need to change. 12:03:10 Checkpoint Completed: duration was 21 seconds. 12:09:48 Checkpoint Completed: duration was 34 seconds. 12:16:27 Checkpoint Completed: duration was 36 seconds. 12:23:0…
Re: Drop diagnostic/violation table
Sorry, found the solution short before you answerd by searching this list: stop violations table for foo; thx, Reinhard. > -----Ursprüngliche Nachricht----- > Von: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]Im Auftrag von Superboer > Gesendet am: M…
Drop diagnostic/violation table
IDS 9.40FC4W2 Trying to alter a table IDS generates the error: -898 Cannot alter a table which has associated violations/diagnostics tables. The user has tried to add, drop, or modify a column in a table that has a violations and diagnostics table associated with it. Trying…
7.3 to 9.4 HELP went live with issues
Neil Truby wrote: > UPDATE STATISTICS? > My problem is dostats. I am running an older copy. The current version core dumps on my 9.4. I didn't know it was dependent on versions. I ran update stats high on critical tables which seems to somewhat fix the problems. Do I need to…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Error checking - get diagnostics vs. sqlcode
Has anyone found any advantages to using "get diagnostics"? We're trying to establish error-checking standards and a co-worker pointed out to me that Informix manuals point out that this is X/Open and ANSI compliant as opposed to the sqlca structure and it also can report multip…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Exception Recursion while handling: MT_EX_OS
I've been running IDS 7.31.UD8 for a while w/o any problem on sparc/Solaris 7. Couple months ago moved to new Sun hardware and Solaris 10. Everything was ok for a month but lately I got 2 incidences of failure with the error: "Exception Recursion while handling: MT_EX_OS, Context…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
HDR Issue / ER Differences
Yes, there are big differences between HDR and ER. HDR is usually implemented as a failover methodology for disaster recovery. Or it is widely used if you would want to use the secondary to handle all the reporting work thus minimizing the load on primary server, and isolating t…
Re: DB2 RAISE_ERROR equivalent in IDS
On 12/1/05, Manas Dadarkar <manasd@gmail.com> wrote: > I am trying to find out if the DB2 RAISE_ERROR function can be > implemented in IDS. The description of the function from the DB2 > documentation is as follows > > *The RAISE_ERROR function causes the statement that includ…
Re: DB2 RAISE_ERROR equivalent in IDS
Obnoxio The Clown wrote: > Manas Dadarkar said: > >>Hi, >> I am trying to find out if the DB2 RAISE_ERROR function can be >>implemented in IDS. The description of the function from the DB2 >>documentation is as follows >> >>*The RAISE_ERROR function causes the statement that in…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
4GL compiler crashes on RECORD LIKE definitions when table contains lvarchar types
if I compile with a RECORD LIKE with an lvarchar with 7.32.UC3 I get a c4gl: line 283: 23339: Memory fault No segv , no core dump…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Ontape not starting - IDS9.4TC4 on Win2K
Simon Gosney wrote: > Guy > > All other IDS commands work fine, and if you map a drive to > %INFORMIXDIR% from another server you can run the physical ontape.exe > program from this machine to backup the instance on another server, so > I don't think it can be a problem with the …
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
Re: loadfile with quotation marks -> csv-file
> > No (sorry). For example: > > sqlcmd -d testdb -e begin -e 'select count(*) from systables' > > Bus Error - core dumped > > (This is also with sqlcmd 77.05) > > It seems there is a problem with 'begin'/'begin work' (?). > > I will try this tomorrow on Linux and on an other Sol…
Re: loadfile with quotation marks -> csv-file
> > No (sorry). For example: > > sqlcmd -d testdb -e begin -e 'select count(*) from systables' > > Bus Error - core dumped > > (This is also with sqlcmd 77.05) > > It seems there is a problem with 'begin'/'begin work' (?). > > I will try this tomorrow on Linux and on an other Sol…
Segmentation faulted - core dumped
Hi One of our client running on Solaris 9 with IDS 7.31 UD8. We never encounter such problem at other clients whose also running on Solaris platform. By running the application via debug mode, it stopedp during creation of temporary table such as below:- create temp table t_p…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: serial and sequential scan
hajek@nspuh.cz wrote: > Thanks to all for your answers. > Art: I have dostats compiled (I tried to use myexport, but after > compiling, it coredumps on first index :-() I will try dostats, it Odd, what's core dumping, myschema or sqlunload? Myschema, I'd guess. Can you send me…
IDS 9.30.TC2 Database Corruptions?! Help!
I am running Informix Dynamic Server Version 9.30.TC2 on Windows 2000 SP4. We run a custom application provided by an informix developer. I'm not really sure what is causing it, and our application provider doesn't seem to know either. We did have an unexpected shutdown, but I w…
IDS 9.30.TC2 Database Corruptions?! Help!
I am running Informix Dynamic Server Version 9.30.TC2 on Windows 2000 SP4. We run a custom application provided by an informix developer. I'm not really sure what is causing it, and our application provider doesn't seem to know either. We did have an unexpected shutdown, but I w…
Which thread consumes the most CPU time?
Hi! I'm looking for some diagnostics in situations when the database server's processes (oninit) starts to consume more CPU time. Is it possible to see which thread have consumed the most of the Database Server's CPU time for, let's say, the last 10 minutes? Regards Christian …
-25572 Network driver cannot bind a name to the port.
Hi, I am getting following error message "-25572 Network driver cannot bind a name to the port." Please find the contain of INFORMIX environment variables, sqlhosts, services and onconfig file. INFORMIX environment variables INFORMIXDIR=/usr/informix/9.40.UC1 INFORMIXSERVER=k…
Re: Running Informix on 2 different Servers in parrallel
Neil Truby said: > "Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message > news:10s070nqi9utl9f@corp.supernews.com... >> Obnoxio The Chav wrote: >> >>> Speed? Better diagnostics (I mean much, much, *much*, _*much*_ better >>> diagnostics)? New features? I mean, would you ad…
Re: Running Informix on 2 different Servers in parrallel
"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:10s070nqi9utl9f@corp.supernews.com... > Obnoxio The Chav wrote: > >> Speed? Better diagnostics (I mean much, much, *much*, _*much*_ better >> diagnostics)? New features? I mean, would you advocate that someone who >…
Re: Running Informix on 2 different Servers in parrallel
Obnoxio The Chav wrote: > Speed? Better diagnostics (I mean much, much, *much*, _*much*_ better > diagnostics)? New features? I mean, would you advocate that someone who > was happy on 7.23 stayed there if 7.31 was available? Even if you discount > large chunks and extensibility…
DB comes down w/ BUFFERS > 350000 ... UR down to 95%
"Anthony Presley" <anthony@zoraptera.com> wrote in message news:a55ad738.0411292101.1bb665a8@posting.google.com... <lots of diagnostics> OS and IDS version?…
HDR and Blobs
Scott, I agree that secondary should not crash with blobspace blob update on primary. If you have a test case, you should open a case with IBM support. I tried couple of simple scenario and could not reproduce it. Having said that, I am not sure how are you going to handle your…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Re: RE: Informix : Bladelet Exec causes IDS Engine to crash !!
Thanks, All these sqls run without problem under my 9.30 IDS. In my case, there is no dbaccess core-dump, but an IDS Crash with a memory dump chown in my last mail. This is caused by the "Exec" Bladelet. It seems like that this datablade is considred as a part of the IDS Engin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
-211 file not open
During a very long process in SQL (almost 36 hours ...) inserting rows (about 150000) in two database tables Informix returns this error: -211 Cannot read system catalog (systables) ISAM error -101: file is not open. and then any new access on database (with this process) fails…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor, A piece of tuning advice that has many times hit this list, is that you should have one CLEANER per LRU. So, having LRUS = 8 implies that you should have CLEANERS=8 also, to keep up with the overhead. Ben Thompson wrote: > Dalibor Krleza wrote: > > I may have missed i…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
RE: ONCONFIG for 9.40 offered for comment
what about.... 1. setting OPTCOMPIND to 2 instead of 0 2. set TBLSPACE_STATS to 0 3. may need to increase DS_TOTAL_MEMORY, if you are using PDQ 4. fyi, LTXHWM & LTXEHWM need not be set if DYNAMIC_LOGS is set in the ONCONFIG -----Original Message----- From: owner-informix-list@ii…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
dbschema fails
Hi all, I have a 7.3 installation on Linux and we are getting ready to upgrade to 9.4. This week we tried running a dbschema to ready our test server and it failed reporting an ISAM failure. Further diagnostics with oncheck and we found out that a few temporary tables that were …
RE: Very slow onbar restore
"Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message news:c92q8v$iou$1@terabinaries.xmission.com... > > Neil, > > My suggestion is to always switch off KAIO on HP > at least during database restore. I saw very bad problems > with (ontape) restore in the past with KAIOON. P…
RE: Maximum Server Connections
I'm sorry, I guess my onconfig file didn't attach. I've included it in the text here. I have tried the several variations of NETTYPE. Thanks for any help you can provide. Jane Vohden Database Administrator jvohden@co.fairbanks.ak.us informix:/apps/informix/etc $ more onconfig.d…
RE: Maximum Server Connections
I'm sorry, I guess my onconfig file didn't attach. I've included it in the text here. I have tried the several variations of NETTYPE. Thanks for any help you can provide. Jane Vohden Database Administrator jvohden@co.fairbanks.ak.us informix:/apps/informix/etc $ more onconfi…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Update Statistics 597 errors and assert failures
> > > We just installed IDS 9.40.FC3 on a 64-bit DEC Alpha server > running the True64 operating system (uname -a: OSF1 odb1 V5.1 > 2650 alpha). The server has 2 CPUs and 4 Gig physical memory. > The following relevant Informix environment variables are set: > > When I run UPDATE…
Core dump
This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C42653.BF24AF50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi All, I have a core dump & the back trace is as follows. The stacktrace is shown below: #0 0xdbbac in Check…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
RE: Core Dump
Vijay, What is a "close cursor"? Are you refering to the "close cursor" statement? Seems likely that fetching from a closed cursor will dump core. From the Informix Guide to SQL: Syntax, p 2-70: "Use the CLOSE statement when you no longer need to refer to the rows that a select…
Core Dump
This is a multi-part message in MIME format. ------=_NextPart_000_0047_01C41D8E.F96D2DE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I have modified my code to include some close cursors. The other team has modified the shared library cod…
RE: Using sqgetdbs core dumps program
Hi Snorris. Sample core is a here. Execute esqldemo7 OR $INFORMIXDIR/demo/esqlc/sqgetdbs.ec HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: scott0@snet.net (snorris) >Reply-To: scott0@snet.net (snorris) >To: informix-list@iiug.org >Subject: Using sqgetdbs cor…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
HDR hardware requirements and capabilities
Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<toS3c.14343$%06.11688@newsread2.news.pas.earthlink.net>... > T.Paakki wrote: > > I have a 7.31.UC6X2 engine running on a HP L3000 with 4 (750), 6G > > Ram processors. The server is running HDR and replicating across…
VPCLASS entries in onconfig when adding logs
Hi, I've got a strange problem. IDS 9.30 UC1 (or UC2) on Solaris 8 I install IDS (using ids_install) and creates an instance. Add a new dbs for logs. I move the physical logs to this dbs, restarts. Everything is fine. I then add a logical log: onparams -a -d logdbs .. but addit…
Re: Isql core dump
Srinivas Sreekumar wrote: > This is a multi-part message in MIME format. Don't post MIME. > When I try to conect to the database using isql , it throws me out with > a memory fault. I uses "isql -s" , select "Database" and then "Select" > to select a database and the below mes…
IDS v7 -> v9 upgrades
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:c10l5u$1bm0ui$1@ID-64669.news.uni-berlin.de... > Neil Truby wrote: > > > such as? > > datablades? > > Functional indexes, better diagnostics, more parameters, bigger chunks, > yadda yadda yadda Well, this goes to th…
Re: dbschema Core Dump
Michael Hoffman wrote: > We are running IDS v7.31.UD6W1 on an AIX 4.3 box. There are currently > 4 instances active with several databases inside each. Did you get any response? > Recently I was finally given permission to experiment with Index > fragmentation. I created an …
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
dbschema Core Dump
Hi all, We are running IDS v7.31.UD6W1 on an AIX 4.3 box. There are currently 4 instances active with several databases inside each. Recently I was finally given permission to experiment with Index fragmentation. I created an new dbspace and ran "alter fragment init" on all…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Performance
Hi, I have problems with the performace of my Server,especially with the yield the CPU, The server is a HP R390, whith 1,9 GB RAM, and one procesador, SO, HPUX 11.00. My question is since I do in order that some processes do not consume the total yield of the CPU, Attach the c…
Re: Informix 9.40.FC2 Crash.
yes, i am told there is a bug with the b tree cleaner in this version. support mentioned reading the release notes but i don't know the specifics yet. the next version is supposed to be available next week. tom "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message ne…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
RE: Informix 9.40.FC2 Crash.
Hi Marino. 9.40.xC2 has a following bug with bescanner. 163521 ASSERT FAILED: NO EXCEPTION HANDLER WHEN RUNNING DQUERIES STRESS TEST 9.40.xC3 is fiexed version. I do not know whether you encounterd this bug. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "…
DBimport terminates without any warnings
I have setup a brand new instance on a production box with 5 instances already there. No problems when setting up the instance - such as adding dbspaces, logical logs, physical log etc. But when I try to import data from a copy of a database, dbimport terminates when it encounte…
RE: java app shuts down Informix Server
Mel, if what you're seeing looks like this: 07:00:42 Assert Failed: No Exception Handler 07:00:42 IBM Informix Dynamic Server Version 9.40.HC2 07:00:42 Who: Session(10, informix@myserver, 0, ce9ed5a0) Thread(15, btscanner 0, ce9bd26c, 1) File: …
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
What is DS memory used for?
Can someone tell me exactly what DS memory is actually used for? Yes, I know it's for DS queries, but what does it hold? Session blocks? Execution paths? Data? Temp data? Sort files? And how exactly does the amount you have affect a query? Can anyone explain exactly what was goi…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
[Error 252] Exception during a simple count
On Mon, 20 Oct 2003 10:49:18 -0400, jsanson wrote: Using get diagnostics you need to loop until all errors have been retrieved, see the ESQL Programmers manual for details. Using Informix specific syntax you can check the sqlca error structure (same docs) immediately after the …
Re: esql core dumped !
"Abhishek Mathur" <abhishek@us.ibm.com> a �crit dans le message de news: biijeq$hqi$1@terabinaries.xmission.com... > > Hi , > Guess, the picture is clear now. First thing, you are right - > ESQL/C does NOT recommend the use of $ include or EXEC SQL include <*.h> > within …
Re: esql core dumped !
Hi , Guess, the picture is clear now. First thing, you are right - ESQL/C does NOT recommend the use of $ include or EXEC SQL include <*.h> within the BEGIN/END declare section. Only because, it works with some ESQL/C version on some platforms, does not warranty it to wor…
Re: esql core dumped !
>Hi Hobbes, Hi ! > I have been reading though the chain of mails. Just wanted to >clarify one more thing - you said that your include files are all #include >*.h (header files) right? That's right >They are not $include (header file). Am I right? That's right too >If t…
Re: esql core dumped !
Hi Hobbes, I have been reading though the chain of mails. Just wanted to clarify one more thing - you said that your include files are all #include *.h (header files) right? They are not $include (header file). Am I right? If this is the case, then ideally you sho…
Re: esql core dumped !
>The only thing you have left is to start by commenting-out everything in the header and then uncomment section by section until you find the one that kills it, alas. Well. I've try it... The result is that when enough line were removed => it compile. I can remove or put any .h …
esql core dumped !
Hi ! Again a little problem.... I try to compile a source in C langage. but esql return me a core. while including .h in my code.... i think that the file created is too big ... Under WinXP it compile and run fine. But under AIX , it fails .... INFORMIX-ESQL Version 9.51.UC3 …
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
RE: performance problems due to lock waits?
Try turning on the "NOAGE" in the config file...... Wayne Martin Database Administrator Kmart Corporation -----Original Message----- From: Jay [mailto:remove:jay@td.ca] Sent: Monday, July 21, 2003 9:49 AM To: informix-list@iiug.org Subject: performance problems due to lock wait…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: error number -1263.
Juan Ignacio Carbajal Rivera wrote: > Hello: > is there anyway to filter rows that fail to satisfy column type > so my load transaction doesn't stop? Have a look at using violations and diagnostics tables. That way you will have all valid records loaded into your table and all t…
Re: Please help: problem with index
ART KAGEL, .... wrote > > Here are the steps: > > - create a new table with the same structure but no indexes > or constraints > - add triggers to the original table to maintain the copy > up-to-date if needed > ie INSERT, DELETE, and UPDATE triggers which should use > stored pro…
onbar problem
Hello all, I am using onbar on IDS 7.31 on HP-UX 11.0 and Veritas Netbackup. The onbar was configured by the System Admin. Now I am testing backups and restores in my test instance that I have setup and noticed that every time I run a backup, it seems to complete fine. I see no e…
problem with lock of a record
Danny De Koster wrote in message <93fgl9$u5l$1@rivage.news.be.easynet.net>... > >When I want to use a table in which somebody has locked 1 row, the system >answers that the record is locked. > >It seems to me incredible that there is no possibility to delete a record >in a table …
RE: DR: Failure
We are running HDR on Digital unix. Informix 7.31FC6 had a bug where HR usr to fail on secondary . It is fixed on Informix 7.31FC7X5. The bug was to fix the recovery problem (the secondary server is always in fast recovery). Thisis what we got from Informix : The bug that we su…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
huge files "shmem.xxxxxx.0"?
In article <9055u2$n1b$1@news.xmission.com>, Woi Yew Fong <yfwoi@tpl.com.sg> wrote: Hi Woi. Sorry my poor English(I am Japanese.) Please DUMPSHMEM to 0 in ONCONFIG file, if you do not need shmem.xxx. Please look at following line. # DUMP*: # The following parameters control …
Re: shahid.mehmood@aku.edu
here is the information you required. -------- onconfig.ows ------- #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.ows # Description: INFORMIX-OnLine Configuration Param…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Performance issues vis a vis checkpoints and uhhh what am I doing wrong...
-- Tony Flaherty Snr. A/P, Informix DBA, HpUx Admin, Gimmi a broom! MFS Ltd. [SNIP] >># For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No. >>DUMPDIR /tmp # Preserve diagnostics in this directory >>DUMPSHMEM 1 # Dump a copy of s…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Core dump in EXEC SQL DECLARE xx_cur CURSOR FOR xid
We compiled our application in Informix 9.2 on HPUX 11. Everything was working. We compiled the same code in Informix 7.31. Now we get core dumps in different executable and all of them are in "EXEC SQL DECLARE ..." code. The stack from the core file indicates BUS ERROR in 0xc…
System is slow ...
OS: SCO UNIX -- OPEN SERVER 5.0 IX: OWS 7.20.UC2 I have one box with OWS installed on it. This instance contains 4 dbspaces, and 4 respective databases. All the users connect to their respective databases through application written using Informix 4GL (c-code version). The users…
performance with very active threads
During a checkpoint you only have 8 cleaners utilized to flush 63 LRU's. That's 4 passes. Make LRUS=64 and CLEANERS=64. That's one pass. Let the disk subsystem figure out any contention. They're pretty good at that:) Also increase CKPTINTVL to every 30 minutes. Why have a …
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: Code Errors - Scripts for import them !!!
ok, my table definition was a example! But, i need only extract the code error and message error of Informix. Example: -899 Too many violations. -898 Cannot alter a table which has associated violations/diagnostics tables. -897 Cannot modify/drop a violations/diagnostics table.…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
IDS 7.31 on DEC Unix
About month ago I have performance problems on 2 CPU DEC Alpha and one of advises was to add more CPUs. So we change old one Alpha with new one. New is Alpha 4100 with 4 CPUs and 2G of RAM. KIO is enabled. Now I have some problems: *************** 1. problem *******************…
Re: Unload
From: "Craig Blanzy" <cblanzy@aperion.com> > >When I try to unload a large amount of records to an ascii file I get a >memory fault core dump. I'm running SCO Unix 5.05, SE run time v 7.23.uc13 >and SQL V 7.20.ud7....The core dump happens at different point during the >unload pr…
Re: Unload
From: "Craig Blanzy" <cblanzy@aperion.com> > >When I try to unload a large amount of records to an ascii file I get a >memory fault core dump. I'm running SCO Unix 5.05, SE run time v 7.23.uc13 >and SQL V 7.20.ud7....The core dump happens at different point during the >unload pr…
Re: Unload
From: "Craig Blanzy" <cblanzy@aperion.com> > >When I try to unload a large amount of records to an ascii file I get a >memory fault core dump. I'm running SCO Unix 5.05, SE run time v 7.23.uc13 >and SQL V 7.20.ud7....The core dump happens at different point during the >unload pr…
Unload
When I try to unload a large amount of records to an ascii file I get a memory fault core dump. I'm running SCO Unix 5.05, SE run time v 7.23.uc13 and SQL V 7.20.ud7....The core dump happens at different point during the unload process on two different machines. On one it happe…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Help! FILTERING WITH ERROR and START VIOLATIONS aren't working
Your problem is related to "FILTERING WITH ERROR". This object mode will cause the offending row to be logged in the violation & diagnostic table AND return an error. Your 4GL does not seem to be handling this error. One simple way to resolve your problem would be to change the …
RE: memory fault, core dump
Dee Wampler Technical Leader > -----Original Message----- > From: David Williams [SMTP:djw@smooth1.demon.co.uk] > Sent: Saturday, May 13, 2000 8:03 AM > To: informix-list@iiug.org > Subject: Re: memory fault, core dump > > In article <8fhch5$sfo$1@news.xmission.com>, Wampler, De…
RE: memory fault, core dump
Dee Wampler Technical Leader > -----Original Message----- > From: David Williams [SMTP:djw@smooth1.demon.co.uk] > Sent: Saturday, May 13, 2000 8:03 AM > To: informix-list@iiug.org > Subject: Re: memory fault, core dump > > In article <8fhch5$sfo$1@news.xmission.com>, Wampler, De…
RE: memory fault, core dump
We did use make and recompiled all of the modules at the same time. When the variable was just in the globals.4gl, and the program was compiled using make, it was fine. When the "LET g_item = 0 " was added and the program compiled with make, we got dynamic linker: program name…
memory fault, core dump
We have upgraded to INFORMIX-4GL Version 7.30.UC1X2 We added in one global variable (smallint) to an existing program, compiled using -shared, and it ran fine Then we set the variable = 0 and got the following error dynamic linker: program name: invalid relocation type 72 at 0…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: need additional data from get diagnostics
From: Eric.Egdorf@mci.com > >We have an insert failing on a foreign key constraint in an ESQL >program but can't figure out how to retrive the FK name from get >diagnostics. The msg_text field doesn't contain the data. Strictly from memory, I think the constraint name is in sql…
need additional data from get diagnostics
We have an insert failing on a foreign key constraint in an ESQL program but can't figure out how to retrive the FK name from get diagnostics. The msg_text field doesn't contain the data.…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Esql/C Set Descriptor
I'm having trouble setting a descriptor for numeric types. I get a message that says: "Character to numeric conversion error." Here's what I'm doing: // allocate descriptor area, set count long l = 34; EXEC SQL BEGIN DECLARE SECTION; int index = 1; int type = SQLINT; char* d…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Help : Segmentation fault (core dumped)
Hi, We have some problems since we migrated to IDS 7.30.FC7, i4gl 7.20.UE1, platform Compaq Alpha (formerly DEC). Programs which were fine don't work anymore and produce the message "Segmentation fault (core dumped)" without any other kind of information. Hereby the part of th…
error message - unable to open input file 's'
Hi, You are right Art, I need to give some details on what I actually wanted to say. When I say that "I get this message when my server crashes" - what I meant was that whenever I have a case wherein a server-crash/assertion-failure is reported, an af.<num> file is dumped to /…
IUS segmentation fault
Hi, Informixers, I installed Informix Universal Server following the instruction and tried to run oninit or onmonitor, I got "segmentation fault" immediately without core dump. Does anybody have similar experience or any idea as of what is wrong? My platform is SiliconGraphics O…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: Problem : cfglgo on Linux
Cecilio Albero wrote: > Thank you. fglgo works !! > > But fgldb still generates a core !!! Can you generate a stack trace from the core dump? gdb myfgldb core <<! where quit ! If it shows up as a core dump in fgl_init(), then go back to the edits in cfgldb and check that you…
Re: Problem : cfglgo on Linux
Cecilio Albero wrote: > Thank you. fglgo works !! > > But fgldb still generates a core !!! Can you generate a stack trace from the core dump? gdb myfgldb core <<! where quit ! If it shows up as a core dump in fgl_init(), then go back to the edits in cfgldb and check that you…
Problem : cfglgo on Linux
This is the stack trace of gdb myfgldb: #0 0x80980c5 in _addstr () (gdb) #0 0x80980c5 in _addstr () #1 0x8098086 in addgstr () #2 0x80975e1 in addfunc () #3 0x809762f in addcf () #4 0x80976e1 in addcfuncs () #5 0x809b9a9 in loadone () #6 0x809b892 in loadfile () #7 0x80…
RE: Informix 4GL, HP, function C ... and core dumped !!
I had the same problem a few months back.. The fix was this: A non-initialized variable was being passed back to a calling function. This was causing a core dump. If I put a sleep or a display stmt in a certain place in the code the core dump went away. The wierd thing is wher…
RE: Informix 4GL, HP, function C ... and core dumped !!
When this sort of thing happens to me, more often than not, the problem is caused by an earlier (dodgy) piece of code. If as you say the core dump disappears when you put a prompt in, then this often an indication that something in memory is not as it should by. I suspect that p…
LOAD FROM error handling
Another possible solution (apart from "dbload") could be the use of a violation table: you could set your constraints and indexes to mode 'filtering without error' and create a violation table for the table to load the data in. After loading the data into your table you have to…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
Re: IDS on Linux (Core dump when using custom runner)
I'm assuming that my problem in running 4gls on Red Hat 6.0 is similar to this one. We ran gdb test.4ge core today and the program bombed complaining about iosetbuffer.c --------------------------------- > I have a problem with creating a custom runner for rds. It seemed …
4GL not running on Linux Red Hat 6.0
We can create a 4gl object module and a 4ge but when we attempt to run 4gl program we get a core dump. Running Informix 7.2 for Linux 5.2 on Linux 6.0 Isql works fine, compile forms and reports. Do we have incompatibible c libraries? only on a IDN web page did w…
IDS on Linux (Core dump when using custom runner)
Hi, I have a problem with creating a custom runner for rds. It seemed to compile ok but whenever I use it to execute a program I get a core dump. Using the standard runner 'fglgo' with the same program works ok. I also have a core dump with programs compiled with 'c4gl'. Looks…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
all error codes
My System: SCO UNIX 5.0.4 OWS 7.22 Does anybody know how to get all error codes when I detect several errors with the GET DIAGNOSTICS statement ? I know how to get each SQLSTATE value and the accompanying error messages, but the error number in SQLCODE always stays the same ( fo…
Online 7.3 and 4gl core dump
Seems to me that an INPUT command in 4gl on solaris is core dumping for no reason. i.e. DATABASE ipa@tater DEFINE state like bil.state MAIN OPEN FORM form1 FROM "form1" DISPLAY FORM form1 INPUT BY NAME state END MAIN The above began core dumping after an upgrade to …
Informix ON-Archive Y2K test
Hi all, Anybody out there faces problem when you try to do a On-archive with dates set after year 2000? Care to share some insight.. I had a core dump!!!…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Re: PANIC: Attempting to bring system down
In article <3777A55E.89C3C04B@bloomberg.net>, kagel@bloomberg.net wrote: > kccnews@my-deja.com wrote: > > > > Hi guys, > > My customer' online is down without causes of this event. It > > down more than two times per > > days. I see some message in $INFORMIXDIR/onlin…
Sr Technical Architect Position
Postings The following positions are available now. If you are interested please visit our web site at http://www.citirec.com and apply online through Candidates section (http://db.citirec.com/candidates/add_resume.html). Technical Architect - Senior Reference # 767 Location: S…
Re: Performance tuning - Configuration files
Aplogies for the lack of information : Here are the configuration files : ONCONFIG File for CSV_JC #************************************************************************** # # INFORMIX SOFTWARE, INC. # Title: onconfig.norm # Description: INFO…
dbaccess segfaults when username not "informix"
Malcolm Beattie wrote: > > I've installed IDS 7.3UC7 under Red Hat Linux 5.2 (2.0 kernel). It > works fine when I use dbaccess to connect as the "informix" username > but trying to connect as any other username just makes dbaccess seg > fault and core dump. This is at the stage w…
Re: ErrorCode = -27002
Hi, Thanks for the reply. I tried onmode -my. the server waits there for ever doing nothing. I am not sure what's happening. Here's my onconfig file. ========================================================= INFORMIX-Universal Server Version 9.13.UC3 -- Fast Recovery (CKPT R…
ODBC problem
Christian Stoellinger wrote: > Hi all, > > We run informix dynamic server on Linux, our client is NT. After about > 36.000 queries we > get errors like > > Connection does not exist > Network function call failed > or crash in SQLFreeStmt > > The ODBC-driver is Intersolv 3…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: oninit / oninit -i
Try oninit -svy, the output might interest you. It displays what the engine is doing as it is coming up. It's also good as a diagnostic tool. Don't forget to onmode -m to put th engine in multi-user mode. Terry Hillick CSCS, Inc. Leroy Janda wrote: > Andreas Lommel…
TBLSPACE_STAT / LBU_PRESERVE
prashant naik wrote: > > Hi Users, > > I am working on Sun Solaris 2.51 / IDS 7.3. Have some queries for which have > not found answers in Informix Answers Online : > > 1. TBLSPACE_STAT set to 1 in ONCONFIG .... what is its use. Your other questions have been answered adequately…
RE: Question about IDS scalabiltiy
You should have NETTYPE parameter (2) for DBSERVERNAME and DBSERVERALIASES. Suggest you turn Read Aheads OFF (0) until you have the system running. Are all parameters the same as recommended in your release notes? Murray Wood -----Original Message----- From: Obnoxio The Clown…
Re: Question about IDS scalabiltiy
I'm kidding about the scolding...... Carlos Bolden <cbolden@harrahs.com> wrote in message news:374c458d@hwilkins.harrahs.com... > After getting scolded by Art, I must post these files also > > > > Carlos Bolden <cbolden@harrahs.com> wrote in message > news:7ih01q$r6a$1@news.xmis…
RE: Question about IDS scalabiltiy
I don't remember, are you doing OLTP or DSS? From: Carlos Bolden <cbolden@harrahs.com> > ># Root Dbspace Configuration See embedded comments. >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /dev/prodi/prod-100 # Path for device containing root >dbspace >R…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Cannot init shared memory and no diagnostics as to why
Last week the AIX administrator made some changes to a running AIX system (at the direction of a consultant doing a security audit). The admin is quite new and 'just changed a few things the consultant told me too'. He doesn't really understand all that he changed, nor does he r…
RE: Backup toooo slow.
What performance do you expect from your tape drive? How fast can you get other backups going to that drive? (Gb/hour). What is the optimum block size writing to that device? and set TAPEBLK to that block size. Is there a problem with the tape or tape drive - doing re-writes…
Re: Backup toooo slow.
Hello Gursoy, How long takes your backup ? We use ontape and need for 11 GB Data on a UNIX/AIX 2 1/2 hours for backup an LEVEL 0 Archive. Regards harald.lutz@telecom.at Gursoy YERLI <gursoy@ata.net> schrieb in im Newsbeitrag: 7hi3qf$jcm$1@news.xmission.com... > > Sorry guys, …
core dump with rds 7.20
We are testing the rds 7.20 for y2k compliant. After installing rds 7.20 on an Alpha box we get a core dump on define statements: define myvar like mytable.myfield. Is this a bug or is it something that we missed? Did anyone out there experienced this problem? Thanks in adva…
cannot Connect through ODBC
Hi Prasad, in your onconfig I'm missing an explicit nettype-entry for soctcp or tlitcp. I'm not sure what are the defaults. There should be also an entry in the sqlhosts-file for the tcp-connection. nettcp seems to be the right service for the tcp-connection. On the Windows-PC …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Update stats...running slow
IDS 7.30 UC2 on SOlaris 2.5.1 Suddenly my update statistics start running slow. Nothing has changed on box. Before it used to take 2 hrs, now it's taking 8 hrs. It's a simple update statistics medium command. Following is my onconfig file. #************************************…
48 oninit processes, when informix started
You have NUMAIO vp's blank. By doing this it uses the default. Which I believe is 2 per chunk, without checking the admin guides.... Darin xuejinw@shubertorg.com wrote: > Hello: > > We are running Informix Dynamic Server Version 7.30.FC4. recently we > noticed that wh…
Re: NET or CPU VP Class
Sean Kelsey wrote: > Good morning Informixers. > > We have been going through a series of conversations with Informix technical > support and I thought I would like to test all you DBA's out there as to > what the general consensus is regarding the VP class that the soctcp poll …
turbos core dumping everywhere
Hi all, We've just moved from 16 bit only apps to 16 bit and 32 bit apps on clients. However, the turbos from the 32 bit connections are dumping very regularly. This is a large concern for us. Informix Engine: 5.06 running on Dynix/PTX 16 bit turbos - 5.01 32 bit turbos - 9.20 …
core dumps from 4GL programs
We have a situation where we are suddenly getting core dumps from one of our 4gl programs, which didn't used to have a problem. This only happens less than 1/2 of 1% of the time it is used. Sometimes it supposedly dies as soon as the user goes into it. Other times it …
Informix JDBC driver causes core dumps
I have a Java application that uses the JDBC:ODBC bridge to access a SQL database. When I have this running on a database other than Informix (MSAccess, Oracle) it works fine. When I have it running on Informix (HP-UX 10.20) I get periodic core dumps. About once a week on a fa…
Informix 6.X Client
kmem wrote: > Hello. > > I run a Informix 6.X server, and I need an ODBC driver to connect to it > under Win95. > I have an old 16-bit ODBC driver that does the job, but I want it to run > with odbc32. I downloaded the SDK > but it gives support for 7.x and 9.x DBS. > …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
engine crash with 408 error
Do you have any VARCHAR fields? If so, Informix views those as Blobs and you have to do some special handling with those. Informix should tell you to do the following to capture the exact statement causing the problem but our problem was with VARCHAR fields. The problem was the…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Shared memory isn't cleaned up after onmode -ky
The first thing I'd do is look at the log file to see if there is some error in the log. I'd then run oncheck with various parms to see if the db is corrupted and the engine couldn't be shut down for that reason. RG wrote in message <01be676c$3bb996e0$7b0501cf@rgriffin>... > > >…
Archecker
Luse Harold wrote: > > Does any one know the command to get archecker to verify a tape backup? > I have messed with it a bit, but I can't seem to get it to run. Instructions should be in the release notes. You have to set up the archecker config file which specifies drives and …
Re: anyway to optimize this query?
query only. Obnoxio The Clown wrote: > >let's see... > > > >there are 61772773 rows in the table. > > > >The table is indexed on three fields, let's call it f1,f2,f3, it is a > >composite index, the reason I do that is because > >there is also a where clause in the query which…
Re: anyway to optimize this query?
>let's see... > >there are 61772773 rows in the table. > >The table is indexed on three fields, let's call it f1,f2,f3, it is a >composite index, the reason I do that is because >there is also a where clause in the query which uses all three fields as >criterias. > >update satis…
Re: Informix 07003 error
On Thu, 11 Feb 1999, Art S. Kagel wrote: > Yang Yang wrote: > > I am new to Informix, could someone tell me what does the above error > > means and preferably point me to a reference of all error codes? > > There is no such Informix error. All Informix message numbers are > neg…
Performance Tuning
Well, the first thing to do is to determine what your performance goals are, then do a comprehensive audit on the current system (os, database and network) under load. The system or db parametes you change will depend heavily on where any performance goals are defecient. When…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
dumpdier getting full
Hi all, We are Using Informix Online DSA 7.13 UC1 in ICL TEAM SERVER envrionment. OS & Version DRS/NX 7MP 5.5 The Problem is in the /var/tmp directory which is the Parameter value of DUMPDIR in the Onconfig file. The DUMPDIR Parameter value is as follows: DUMPDIR /var/tmp …
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Re: Informix v7.24 on HP-UX 10.20
Hi Dave, 7.30.UC6-1 is available on HP-UX 10.20, David... P.S.: here is a the list of bugs corrected since 7.30.UC5 (maybe not critical bugs but the list is quite impressive). We solved several problems by migrating from UC2 to UC6 (I asked for UC5 but informix sent UC6. W…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix error - Shared Memory
Dear Sir, I=B4ve installed Informix On-line 7.13 in our server running AIX 4.2 successfuly, but when I try to initialize the system (onmonitor -> Modes -> On-Line) the following error occurs: Unable to attach to shared memory. Invalid argument What=B4s wrong ????? I hope yo…
Please Help ! Can not attach to shared memory
Dear Sir, I�ve installed Informix On-line 7.13 in our server running AIX 4.2 successfuly, but when I try to initialize the system (onmonitor -> Modes -> On-Line) the following error occurs: Unable to attach to shared memory. Invalid argument What�s wrong ????? I hope you ma…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Re: Help - Informix RDS 4GL 7.20
I've had major problems with strings in 7.2. It's not just globals either - I've had strings truncating and I've had (stil got) core dumps. I've worked around some of the problems I've identified (for example LET gv_str = gv_arr[1].str truncates but LET gv_str[1,80] = gv_arr[1…
4gl RDS 7,2 on hp-ux 10.20 -- string handling errors
A warning to others and a plea for ideas or help. Just upgrading to 4gl RDS 7,2 UD4 running on hp-ux 10.20 and I'm having problems with simple string handling causing errors. Is anybody else having similar problems and have they managed to determine what is happening ? Example …
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
tbload core dumps
See below for versions etc. I'm trying to re-build by database server with sensible naming conventions. I've done a tbunload to raw disk. When I try to reload the data the tbload crashses with a core dump after a few seconds. Any ideas? Alternatives (I've already thought of …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: Part II: Revenge of the CoreDumps
John, I'd rather work with your core file than try to recreate the problem. I might not be able to successfully recreate the problem. Let's work with the evidence that we have. Please create a compressed tar file containing the executable and core file. Notify the case owner …
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
Memory Dump(core) on Unix
We have been having a problem with some 4ge (4gl executable) programs lately. We will run a program that has worked in the past and now it gives us a dump. The only error message in the dump is "ERROR:mmap failed for dld". Anybody else seen this? Informix 4GL version 7.20.UD1. HP…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Netscape NSAPI Informix application core dump on HP-UX
We are modifying our application to be Y2K compliant by upgrading all the layered products our application depends on. Our application formerly ran on HP-UX 9.04, Netscape Commerce Server 1.1, and Informix 7.11.UC1. We need to run it on HP-UX 10.20 using Informix 7.23.UC11 and …
Re: isql dumps a huge core
Ph. Chantry wrote: > > Hi. > > Sometimes, isql dumps a very huge core (between 80 MB and 150 MB). > We do not know the context of this problem. Probably isql was idle for a > long time. > > Have you encountered such a phenomenon ? > > Thanks in advance for all information. Why i…
isql dumps a huge core
Hi. Sometimes, isql dumps a very huge core (between 80 MB and 150 MB). We do not know the context of this problem. Probably isql was idle for a long time. Have you encountered such a phenomenon ? Thanks in advance for all information. Philippe. INFORMIX-SQL Version 6.04.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
page faults of sagent.exe
hello, pmon.exe is saying that sagent.exe is using 10920K memory and that it had 467365338 page faults. since this means ( i think ) that he is retrieving memory pages from disk this is slowing down the server NT diagnostics shows me that we have 2GB memory ( which is correct ) …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: HPL Core Dump
In article <36017DC9.7CE51C57@weideneder.de>, stefan@weideneder.de (Stefan Weideneder) wrote: > jh wrote: > > > > Does anyone out there has tried running HPL by this command : 'ipload > > -n' > > and core dump ??? Just wondering what could have cause it ?? > > > > Joshua > > ..…
Re: HPL Core Dump
jh wrote: > > Does anyone out there has tried running HPL by this command : 'ipload -n' > and core dump ??? Just wondering what could have cause it ?? > > Joshua ... try to analyse the core by "adb", find and fix the problem :-)) Stefan Weideneder…
HPL Core Dump
Does anyone out there has tried running HPL by this command : 'ipload -n' and core dump ??? Just wondering what could have cause it ?? Joshua…
Re: Connection core dump
. wrote: >Hi, > >Have installed informix and can run onmonitor and dbaccess ok ( with user >informix ), but other >userids get a permission denied in dbaccess. Message 387: no connect >permission, 111: ISAM error: no record found. > It seems that you should grant connect to data…
Connection core dump
Hi, Have installed informix and can run onmonitor and dbaccess ok ( with user informix ), but other userids get a permission denied in dbaccess. Message 387: no connect permission, 111: ISAM error: no record found. Running a java application to get a connection gives a core du…
Reducing checkpoint intervals...
I run a very busy OLTP system. Currently, checkpoints are taking between 10 and 20 seconds, and are happening every 5 minutes (as the result of the checkpoint interval being hit.). For obvious reasons, I would like to reduce this. Currently, I see a couple of things to try: * …
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Backup & Restore
We have a new informix database based application and we were following the vendor's backup and restore procedures (as best we could) and we have run into a few problems. First, what we did: onmode -k (offline?) ontape -s (archive level 0 backup, no logs) drop a user table ontap…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
dba tools
Has anybody experience with PATROL-TOOLS ???? - It is a good tool to perfrom : Diagnostic Reporting, Database Tuning, Importing/Exporting Data, Data maintenance, database change management, Database recovery and back ups. How is this tool compare with PLATINUM ?? Regards, He…
Re: dbaccess output formatting
Mike Morris wrote: > Hello! > > As a new user to Informix, I wonder if there are any tools for > formatting the output > of dbaccess selects to make rows easier to read (spreadsheet-like)? I want to thank all those who replied to my dbaccess request. We tried the reform_sql & …
RE: dbaccess output formatting
I don't think you can change dbaccess, but the windows-based SQL editor returns results in a spreadsheet-like format. SQL Editor is part of the Relational Object Manager toolset. Search the Informix web site. I may be part of the free NT stuff - I haven't looked. -----Origin…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
dbaccess output formatting
Hello! As a new user to Informix, I wonder if there are any tools for formatting the output of dbaccess selects to make rows easier to read (spreadsheet-like)? TIA ----------------------------------------------------- Mike Morris Sterling Diagnostic Imaging Ro…
Re: ILogin demo NT client -> Unix Server. -931 error & setnet32
Hello Klaus, Where can I find the service name and port number on the unix side? I am VERY new to Informix and do not know which config file will have this info. TIA --------------------------------------------------- Mike Morris Sterling Diagnostic Imaging Roads go…
Scripting dbaccess
Is it possible to script dbaccess on the sun?. Is there a man page? -- Mike Morris Sterling Diagnostic Imaging *************************************************** He should not vow to walk in the dark, who has not seen the nightfall. ********************************…
Connect to Informix 7.2
Hello! I'm attempting to connect to an Informix 7.2 backend. I loaded the INET stuff but my profile generates a -25567 error which translates to: -Internal communications buffer management error detected. -Memory corruption or incorrect use of buffer-management routines usually…
Re: Get Diagnostics from Stored Procedure
David Samson wrote: > > Hi All, > > Is it possible to call "GET DIAGNOSTICS" from a stored procedure? I > need to get the error code and the number of rows effected by the > stored proc. > If it is doable, what's the syntax? David, the command GET DIAGNOSTICS is strictly for u…
Get Diagnostics from Stored Procedure
Hi All, Is it possible to call "GET DIAGNOSTICS" from a stored procedure? I need to get the error code and the number of rows effected by the stored proc. If it is doable, what's the syntax? Thanks! David -- David Samson, Senior Database Researcher dsamson@ndsisrae…
ONINIT Command Failing
Dear All, Today we installed INFORMIX-OnLine Dynamic Server 7.13.UC3 on AIX 3.2.5 version (IBM RS6000 machine ).The installation was correct. After the installation when we were trying to initialize the database server using ONMONITOR utility or ONINIT command we are getting the…
Re: DB Cockpit with Informix 7.23UC4
KENDRICKS CHERYL wrote: > > We have installed INFORMIX-OnLine Version 7.23.UC4 on a Sun SPARC E3000 > and E4000. I can not find the DB Cockpit program. Does anyone have any > ideas? I been able to find "onperf". But not "onprobe" or "oncockpit". > > TIA > Cheryl L. Kendricks > S…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
RE: SIEMENS experiences with 7.X Dynamic or Work Group
> -----Original Message----- > From: Alexander Selg [SMTP:alexander.selg@siemens.at] > Sent: Wednesday, March 11, 1998 10:50 AM > To: informix-list@iiug.org > Subject: Re: SIEMENS experiences with 7.X Dynamic or Work Group > > MARTIN wrote: > > > > Please tell me what kind of con…
ISAM error Blob stamp incorrect
I would like to thank everyone who responded to the following problem. --blob stamp incorrect found during during diagnostics --AIX 4.1 --Informix 5.0 --Single cpu IBM microchannel box Tech. support fixed the bad blobs! I am now going to: 1. level 0 archive for safety 2. run d…
Re: SIEMENS experiences with 7.X Dynamic or Work Group
MARTIN wrote: > > Please tell me what kind of config you use with Siemens/Nixdorf Unix > boxes and On-Line engines 7.x. > > -What config. > -What box , RM-300, RM-400, RM-600, ... > -How big is your data base , ... > > Thanks in advance Box: RM600-E20 Engine: OnLine Dynamic Se…
Re: Re:tbcheck -cD <database>
Umesh, What version of the engine are you running and what platform? We had similiar problems on DG platform running DGUX 3.10 and Informix Online 5.03. It had to do with blobs in the database. Evidently there was a bug with using tbcheck -cD <database> option on databases th…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re:tbcheck -cD <database>
When I ran tbcheck -cD dbname, it checks 60-70% database table and core dump (segmentation fault). I ran that command twice and it stop and core dump exately same place it core dump earlier. So I ran tbcheck -cD dbname:tabname ( last tabname before core dump) Finally I got ta…
lock table overflow
hi i'm running ods7.23uc1 on hp-ux10.20. this application is an off-the-shelf manufacutrin gpkg which runs on top of informix. whenever a particular trnasaction the application bombs out with the errors below: %SQLCODE: -244 Could not do a physical-order read to fetch …
BLOB Stamp Incorrect
Hello, Enviornment- AIX 4.0, single cpu, IBM MicroChannel box, Informix On Line 5.01.UD2. Two chunks of BLOB spaces, 1st 1,999,496 rows, second 599,496 rows. Symptom- Running Diagnostics on data returns the following: "ISAM err: BLOB Stamp is incorrect.." Attempted Solution- R…
Re: - BEAUTIFUL BLONDE!! --(picturepost)blo0045.jpg[1/1]
deambqig@BeauBlonde.com wrote: > [ vasectomised ] (<-poor attempt at pun). Please - no references to BLOBS here. Richard. ~~~~~~~~ 14,29,22,21,13,11,23,5,10 - core dumped (POSIX). -- The Open University is not responsible for content herein, which may be incorrect and is used …
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
Re: Can not alter table. Associated violation/diagnostic
The violations and diagnostic tables are created by the start violation table command. To remove association use the "stop violation table" command. Check the SQL manual for details Deepa Francisco Reyes > I was trying to change a table and got an error -898. "Can not alter > …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Esql/c Error Diagnostics
Hi. Users.... My env.. Informix OWS 7.20.UC2 Esql/C 7.23. I am using the diagnostic area to find the result of my last executed sql. EXEC SQL get diagnostics exception 1 :message_text = MESSAGE_TEXT, :message_len = MESSA…
Re: QUESTION: INFORMIX STATE IX000 in an ESQL/C PROGRAM
cbolden wrote : >Randomly I recieve and SQLSTATE of 'IX000' and doing a get >diagnostics >reports MESSAGE_TEXT having a value of 'Success'. Is this a true >statement, did the previous sql complete successfully. If not ( a >true >statement ), how or what could I use to show a r…
Re: QUESTION: INFORMIX STATE IX000 in an ESQL/C PROGRAM
cbolden wrote : >Randomly I recieve and SQLSTATE of 'IX000' and doing a get >diagnostics >reports MESSAGE_TEXT having a value of 'Success'. Is this a true >statement, did the previous sql complete successfully. If not ( a >true >statement ), how or what could I use to show a r…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: ESQL/C Error check in Informix 7 opinions?
Mark Palumbo wrote: > Do you think it is "ok" for us to continue our ESQL/C development > using the SQLCODE to check for Informix errors as opposed to the > new GET DIAGNOSTICS and SQLSTATE method? > Will SQLCODE support go away in future versions of Informix? > The Informix-E…
ESQL/C Error check in Informix 7 opinions?
Do you think it is "ok" for us to continue our ESQL/C development using the SQLCODE to check for Informix errors as opposed to the new GET DIAGNOSTICS and SQLSTATE method? Will SQLCODE support go away in future versions of Informix? The Informix-ESQL/C "Programmer's Manual Vers…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Creating Logical logs
Hi users, Thanks for the solution. I created a database with log, and could load the schema of another db. I know only few things of the DBA stuff. But can anyone please tell me 1.how to know how many logical logs are there & what are their sizes. 2. How to i…
Re: Slightly offtrack
Are you sure that the a.out that core dumping is not an old one lying around on the path somewhere -- Paul Watson WF Software Ltd. Tel: +44 1436 674729 Fax: +44 1436 678693 Email: paulw@wfsoftware.co.uk "S.Sathish" <ssathish@getafix.cmc.net.in> wrote in article <662kqa$514@cssu…
Slightly offtrack
Hi, I was compiling an ESQL\\C program and generate an a.out, when i execute a.out - Core Dump Memory Fault. If i rename the a.out to something else and execute,it works .What could be the problem. SCO Unix openserver running ODS 7.1 ****************************************…
memory release
Hi We are running Online 7.23UC4 on HP O/S 10.20 with 229 MB physical memory, 6 physical diskes, 1 CPU and KAIO-enabled. It seems that the Informix 7.23 requires a lot of memory. It dymanically allocates virtual memory all day long and frees very little until the user logs out.…
Re: Online 7.12 Tunning
How many CPU's does the system have? Is is a dedicated server; or does the app run on the same machine? From your NETTYPE settings I'd guess decicated server. If you need no network access them remove the onsoctcp NETTYPE setting. You proably want to set OPTCOMPIND=0. This can b…
Online 7.12 Tunning
Hello, I've just upgraded from Online 5 to Online 7.12, on a RISC6000 with 128MB RAM, and I'm having some performance problems. The database is about 400MB and I have 32 users running an MRP application. Can someone give me some hints on this? Thanks in advance. This is my onc…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Find out database
Rob J McAllister wrote: > > If you are using 7.x ESQL/C you can use GET DIAGNOSTICS to fetch > several types of information including the current database name. RTFM > No, actually there is no way to get the name of the current database from GET DIAGNOSTICS or anywhere else by qu…
Informix 4.15.UC1 gives strange results on HP-UX 10.20
Hello All We recently migrated from Informix 4GL 4.11.UC3 with Online 5.02.UC1 = running on HP-UX 9.04 to Informix 4GL 4.15.UC1 with Online 5.08.UC1 = running on HP-UX 10.20. The application functioned without any errors on = the old configuration. However on the new configurati…
Newbie Informix CLI and AIX question!
Hi all, I have been having a problem with (7.x) CLI and AIX. Everytime I try to run the SQLConnect() function I get a core dump. I know in general this could be anything, but I am pretty certain that it isn't in the simple test code I wrote. Thanks David Ingham (remove nospam…
Re: Retrieve current connection
Johannes Plassmann wrote: > > Hi there, > I have a question concerning connections (CONNECT to, DISCONNECT from > commands). During program execution we set a connection to a database > server through (e.g. CONNECT to '@soc20_1'). In other parts of the > program (running in a sha…
Re: Retrieve current connection
Johannes Plassmann wrote: > > Hi there, > I have a question concerning connections (CONNECT to, DISCONNECT from > commands). During program execution we set a connection to a database > server through (e.g. CONNECT to '@soc20_1'). In other parts of the > program (running in a sha…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: 7.21.UD1 Perf. Problem
In article <5oai41$5ue@dfw-ixnews7.ix.netcom.com>, Kerry <dino@ix.netcom.com> writes >Greetings! > >We are upgrading a Version 5.03 OLTP system to Version 7.21.UD1, also >upgrading to 4GL 6.05 (pre-release due to bugs in 6.04). > >We have a group of programs that are doing a lot …
7.21.UD1 Perf. Problem
Greetings! We are upgrading a Version 5.03 OLTP system to Version 7.21.UD1, also upgrading to 4GL 6.05 (pre-release due to bugs in 6.04). We have a group of programs that are doing a lot of "behind the scenes" processing. They were optimized for indexes, etc., under Version 5.…
Informix v7.12 and DEC ALPHA 2100
I've just done an upgrade on a DEC ALPHA 2100 with 2 CPUS and a GIG of memory from Informix 5.05 to 7.12 and performance is terrible!!!! I would appreciate ANY advice anyone can provide. Below I have included a copy of the onconfig file and selected system output from several t…
Re: 4GL & gcc
Richard Stanford wrote: > > On Wed, 7 May 1997, V.Salvador wrote: > > > I'm trying to compile 4GL programs with gcc 2.7.2 on Solaris 2.5 but > > when I open a window, program does core dump. > > Which window .. your xterm is coredumping? Or is gcc graphical now? > > Oh. Or do y…
Re: 4GL & gcc
On Wed, 7 May 1997, V.Salvador wrote: > I'm trying to compile 4GL programs with gcc 2.7.2 on Solaris 2.5 but > when I open a window, program does core dump. Which window .. your xterm is coredumping? Or is gcc graphical now? Oh. Or do you mean that the programs compile corre…
Re: Diagnostic & Violations tables
stiglich@promarkone.com wrote: ||Hello, || || Is there a way to give extent sizes for diagnostics & violations ||tables that are created by High Performance Loader? It seems to ||default to 8 pages. This is not good when you have a very large ||load because you get extents…
Re: Diagnostic & Violations tables
stiglich@promarkone.com wrote: > > Hello, > > Is there a way to give extent sizes for diagnostics & violations > tables that are created by High Performance Loader? It seems to > default to 8 pages. This is not good when you have a very large > load because you get extents…
Re: Diagnostic & Violations tables
}>From ilist@rmy.emory.edu Tue Apr 22 15:35:52 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (940816.SGI.8.6.9/930416.SGI.AUTO) }> for <settler@dbintellect.com> id PAA17732; Tue, 22 Apr 1997 15:35:51 -0600 }>Received: (from ilist@localhost) by rmy.r…
Diagnostic & Violations tables
Hello, Is there a way to give extent sizes for diagnostics & violations tables that are created by High Performance Loader? It seems to default to 8 pages. This is not good when you have a very large load because you get extents scattered all over the place. TIA Pete --…
MS SQL vs Informix Online Workgroup (7.12) on NT observations
We are trying to compare performance of SQL server vs Informix for our application, which mostly do querying rather than updating. Both SQL Server and Informix are on the same machine, dual P133 with 224 M. MS SQL Server has 80 M allocated to it, Informix's BUFFERS is set to 150…
Informix startup (oninit) problem
I get the following errors when trying to do an "oninit -i" to bring up the informix instance for the first time. ---------------------------------------------------------------------- oninit: Cannot open chunk ''. errno = 2 oninit: Fatal error in shared memory initialization ---…
Open Windows and Core Dumps
UGH! I hate Core dumps!!! Can anyone tell me exactly what I am supposed to look for in a "core" file? Well, that's besides the point... although helpful. Here is the problem: I am running a application that puts message windows on the screen at various times. It seems that…
Re: ESQL/C v 5 on SCO Open Server 5
When writing ESQL/C in 5.0 ONLINE I would get core dumps when tring to fill an array which was defined to small to hold the incomming data. Do not know if this is your problem but is some thing to look at......... Gregg…
Screen Forms puking under Solaris
Greetings, I have created a -very- basic screen form only to find out it croaks when run under Solaris. "Segmentation Fault (core dumped)" is the only error, and since I'm not that adept at reading core dumps I'm fairly much in the dark. The best I can muster out of trying to e…
Re: help with RUN RETURNING
In <32ccd453.76034431@pubnews.demon.co.uk> nabson@derwent.co.uk (Nick Abson) writes: >Running RDS 6.03 on Solaris 2.5 (recently upgraded from 2.2 on SCO) >I can no longer get any OS commands to return their exit codes to my >applications when using RUN RETURNING - the variable …
Re: Onperf core dump problem
Was there any error message? We had a similar problem on HP which we solved with this one-liner... ln -s /stand/vmunix /hp-ux This solves the problem because onperf expects the unix kernel to be in the root directory and called "hp-ux" but HP moved the kernel to "vmunix" in /st…
Onperf core dump problem
I have a Sparc10 running Solaris 2.5.1. The database engine in Informix OnLine Dynamic Server 7.x. I can not get the onperf utility to come up. When the onperf command is entered, the prompt returns immediately and a core dump is left. I have loaded both 7.13 and 7.20, experi…
NO RESPONSE FROM SERVER PROCESS
Montree Saengchannukul wrote: } } Help me,please !!!!! } I use INFORMIX V.7.2 on IBM RISC/6000,AIX V.4.1.4. } (memory 256 MB,2 cpu) } I have some problem: } When my user can't connect to database (through ODBC) he tells me. } And in that time I call "onstat -i" it…
Re: NO RESPONSE FROM SERVER PROCESS
Montree Saengchannukul wrote: } } Help me,please !!!!! } I use INFORMIX V.7.2 on IBM RISC/6000,AIX V.4.1.4. } (memory 256 MB,2 cpu) } I have some problem: } When my user can't connect to database (through ODBC) he tells me. } And in that time I call "onstat -i" it…
Re: Informix 7.2 core dumps in GET DIAGNOSTICS
In article <56f8oo$8qa@atlas.aethos.co.uk>, Philip Coombes <phil@aethos.co.uk> writes >Greetings All, > >We have a slight problem with Informix 7.2 running on HP-UX 10. The >application is a C/C++ program created with ESQL/C. > >It's very simple, basically we do a GET DIAGNOSTICS…
Informix 7.2 core dumps in GET DIAGNOSTICS
Greetings All, We have a slight problem with Informix 7.2 running on HP-UX 10. The application is a C/C++ program created with ESQL/C. It's very simple, basically we do a GET DIAGNOSTICS (as detailed in the ESQL/C manual) after most if not all operations to check for errors. Th…
i4gl, wordwrap arrow keys & core dump
On SCO UNIX an application core dumps if the user presses the arrow keys (a lot) to navigate around a wordwrapped field. i4gl is 4.12 SE is 5.01. If you are careful (i.e. use arrow keys sparingly and slowly), this does not occur Any ideas chaps & chappesses ?…
Re: core dump at dbload
BTW = by the way -- _________________________________________________ Woodson J. Martin wmartin@businessobjects.com Program Manager phone 011.331.41.25.31.72 Technical Relations fax 011.331.41.25.31.00 Business Objects - Paris, France "first in …
Re[2]: core dump at dbload
Steve, Thanks for you info. What is "BTW"?. When I added pipe to end of records, I was able to go up "-n 500" (I only tried upto 500) without have Memory fault. Have you had this kind of problem in Dynix 4.1.2 with Informix 7.12.UC2? T…
Re: core dump at dbload
Susik, On my Sequent I get a Memory fault with dbload with "-n 10000". I usually use "-n 1000". I never tried to track down the problem. BTW Informix 7.13.UC2 is available for Dynix 2.1.5 Good Luck, Steve Berg - spb@masada.nb.com On Thu, 10 Oct 1996, =?US-ASCII?Q?Susik_Lee?…
core dump at dbload
We have Sequent ptx 3.2.0 v2.1.5 running On-line 7.10.UC5. When I do dbload with "-n 300" option, I get Memory fault(coredump). But, if I use smaller size of commit "-n 100", it loads data o.k. Any ideals? dbload command: dbload -d database -c cmd…
rgetmsg (esql/c) can lead one astray
hello in esql/c if you call the rgetmsg function which "converts an Informix error mesage number into the corresponding message text string" and then send the string straight out via {f,v}printf, you will get a core dump in certain cases as what you get back can contain format s…
Help restoring a dbspace with Online 7.12
I get a segmentation fault (core dump) everytime I try to restore a dbspace with: ontape -r -D dbspacename I can do full database backups and restore. Informix Support can't seems to trace the problem. I am using Online 7.12 on HP unix 9.x Thanks in advance! e-mail: pho@bnr…
US-CA-Pasadena TECH SUP WIN 95, TCP/IP, NOVELL SMCI
Keywords: TECH SUP Term: CFH 6 months State: CA 3rd Party Recruiter Job Id: #060 Title : Technical Support Representative Skills: TCP/IP, PC, NOVELL, WIN 3.1, WIN 95, NETSCAPE, Understanding of networking concepts. Location : Pasadena Start Date: Immediate Pay Rate : …
Online 7.12 and 7.20 on SCO OpenServer 5 - CRASH - HELP
This is a multi-part message in MIME format. ------=_NextPart_000_01BB9F69.29F19020 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Wel, Informix let me down again. About a week ago I posted a message about crashes of Online 7.12 UC1 and 7.12 UC2 ru…
Re: Help! Corrupted sysprocbody (7.20.UC2)
In article <321490ED.1259@csc.com>, "Chao Y. Din" <cdin@csc.com> writes >We just had a hard disk failure on a Solaris 2.5.1 NFS file system. Somehow it >caused "out of swap space" problem. At >the same time we got sysprocbody error. They may be coincidence. Anyway, the >onlin…
Help! Corrupted sysprocbody (7.20.UC2)
We just had a hard disk failure on a Solaris 2.5.1 NFS file system. Somehow it caused "out of swap space" problem. At the same time we got sysprocbody error. They may be coincidence. Anyway, the online log messages are as follows. ========== online.log ========== 13:58:41 …
dbCGI
Has any successfully compiled CorVu's dbCGI program for the Informix Online 7.12 database? The program appears to compile fine with no errors or warnings, but when I execute it from the command line, I receive a segmentation violation (core dump). I am running on a Sun Sparc v5…
Re: onspaces (digital unix 3.2, informix 7.12)
gtravis@richmond.infi.net (Glenn Travis) wrote: >Running onspaces on digital unix 3.2 and online 7.12 produces a core dump. I >am not even passing anything, just running onspaces --. anyone else see this? >know of a fix? It works fine on our suns. Try looking at the (maybe t…
onspaces (digital unix 3.2, informix 7.12)
Running onspaces on digital unix 3.2 and online 7.12 produces a core dump. I am not even passing anything, just running onspaces --. anyone else see this? know of a fix? It works fine on our suns. Thanks. ----------------------------------------------------------------------…
c4gl core dump on IRIX 5.3
Hi I'm getting a segmentatio fault and core dump trying to use c4gl on Irix 5.3. Anyone know of any problems/pitfalls with Irix 5.3 that my be causing this? Thanks, Marc…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
HELP - fglc dumps core
I sure hope someone out there can help me... We're running INFORMIX-4GL Version 4.12.UE1 under DEC OSF/1 3.0b on a DEC 3000/600. In this configuration, fglc consistantly generates an unaligned access error then dumps core. When I look at the temp file that fglc was writing at …
Segmentation Fault (core dumped) on tbcheck -cc
Nightly, a tbcheck -cc is performed on an Informix 5.0 database. An error message of "Segmentation Fault (core dumped)" is passed.This check occurs when no users are connected to the database. Also, the database's statistics is updated frequently. There are over 100 tables in t…
Informix 7.1 Mirroring question. -Reply
Original post below sig. You can use onmonitor/diagnostics to set an alarmprogram that is called in the event of an incident. Mine is a shell script that filters out lowlevel events and mails me on the rest. The chunk will also come up as 'down' on an onstat -d. I Check mine…
Help: Segmentation fault, core dump
Hi, We are running Informix 4GL (ver 7.1) on SunOs release 4.1.3_U1. We are dealing with about 30 tables and writing code in ESQL/C. However, it seems like giving a core dump whenever it tries to open a cursor. Note that this is happening with one ESQL/C program (so far) but oth…
Bad System Call: Core Dump???
Has anyone experienced a "Bad System Call: core dump" from the statement "let lv_timevariable = current" where lv_timevariable is a datetime year to fraction? J.G.…
Re: I/O error, Primary Chunk offline
adel@q8petroleum.com.kw wrote: : Hi informix 'ers : In the morning I found Informix online 5.0 offline and a message in turbo.log : says : : I/O error 'read': expect 32768 actual -1 addr 0xaad errno 5 retrys 0 : I/O read() chunk 1, pagenum 2733, pagecnt 8 --> errno = 5 : -- Onli…
Re: known problems/bugs of INFORMIX 7.11?
>>>>> "Klaus" == Klaus Rehm <Klaus.Rehm@extern.uni-regensburg.de> writes: Klaus> a friend of mine needs some information about possible Klaus> problems or known bugs of INFORMIX 7.11. Well, *I* know about this one: l, *I* know about this one: char message[255]; EXEC…
Re: Apologies for multiple message
tvarnas@compulink.gr (Apostolos Varnas) writes: >X.400 Gateway wrote: >} >} Subj: X.400 Delivery Report >} From: X.400 Domain: (c=US;a=COMPUSERVE) >} >} Delivery report for message 960206102602 515664.456256 FHS38 >} Subject: Re: NEXT FIELD e >} >} To: X400:…
Mixing 4gl and C Functions, How ?
Hello All and Happy New Year, Can anyone provide an example of calling the PUTENV "C" Function from a 4gl program? We have tried a little bit of everything to get it to work, but we only get a core dump when we run the 4ge. Environment is: DEC ALPHA UNIX SCO INFORMIX 4.1 Appr…
(no subject)
Hi, I'm trying to port my C applications to Informix 7 from Informix 5. The applications compiled without errors, but when I try to run them, I get the following errors : /lib/dld.sl: Unresolved symbol: ASF_Call (code) from $INFORMIXDIR/lib/esql/libsql.sl IOT trap (core …
Re: DEC ALPHA core dumps
> >Subject: DEC ALPHA core dumps Yeah, but I bet it does it faster than the other RDBMS. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _________________…
HELP : CORE DUMP on select sum ..
I have Problem when selecting aggregates from a table. Please have a look at these statements which describe the problem : The Table looks like that : create table t_core ( i1 integer , i2 integer , i3 integer ) ; INSERT INTO t_core VALUES (1,1,1); Here are some (simple ?) s…
DEC ALPHA core dumps
Has anyone experienced "memory fault - core dumps" when running Informix 4GL programs on a DEC ALPHA 3000? We are using the following products: INFORMIX-OnLine Version 5.05.UC1 INFORMIX-SQL Version 4.13.UD1 INFORMIX-4GL Version 4.13.UD1 INFORMIX-4GL Version 4.13.UD1 The proble…
Re: HELP: tbcheck -cr dumps core!
In article <451hke$adj@nezsdc.fujitsu.co.nz>, steve@nezsdc.fujitsu.co.nz (Steve Chell) says: > >I'm trying to run tbcheck -cr against a customers Online system >(version 5.02.UC6), but it dumps core half way through. Here's >the output: I have seen something like this recently.…
Re: HELP: tbcheck -cr dumps core!
This sounds like a bug that I ran across quite some time ago. Is your physical log located in a non-rootdbs? If it its, tbcheck -cr will core dump. I can't recall the bug number -- but it has been fixed in newer versions. Good Luck.…
HELP: tbcheck -cr dumps core!
I'm trying to run tbcheck -cr against a customers Online system (version 5.02.UC6), but it dumps core half way through. Here's the output: > Validating INFORMIX-OnLine reserved pages > > Validating PAGE_PZERO... > > Validating PAGE_CONFIG... > > Validating PAGE_1CKP…
CORE dump with a RUN command
We are having a problem with an existing 4GL application where we are doing a UNIX test command in an Informix RUN statement and the application is coring. We pretty much isolated the core problem with the test command. The application used to work fine until this weekend when w…
R4GL - Pcode size
I work with the following INFORMIX Products: R4GL development system Ver. 4.10.UD2 Run time Ver. 4.11.UC2 OnLine Ver. 5.00.UC2 My problem is that, If I have a 'prog.4gi' with more…
Help Mac to Informix
I am running system 7 on the Mac and can connect to Informix through Informix-Net using ilogin. A third party data access tool hangs when it attempts to ping the database. Are there any log files on the informix side that I can look at the may give some information, or parameter…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
DBLOAD field length limit??
I've been trying to use DBLOAD to load a delimited file with some HUGE fields is it. I get "segmentation fault (core dump)". I think this has to do with the large fields since I'm resonably sure there are no illegal strings in the file. What is the limit? If it's system depen…
Help-dgrealloc,_sqinitdiag() problems
Hi, Is any one out there who got memory allocation problems with _sqinitdiag() or dgrealloc() functions? If so, how did you resolve it? Please do send me a email. I am getting segmentation fault at the line "exec sql database dbname" I have tried the database with dbaccess and …
ISQLperl on HPUX 9.0.5 and Perl 4.035 or 4.036 ? Anyone?
Anyone one been able to get the 1.2 version of isqlperl to build on this platform? i FINALLY managed to get the thing to compile (pain in the tail), however, it still core dumps on &isql_execute. Has anyone successfully built this on an HP? -- Nathan --------------------------…
Re: Core Dump in Dbaccess
>Nick Nobbe (nnob@loc.gov) wrote: >>On Wed, 22 Feb 1995 xrizzi@arcride.edu.ar wrote: >> >>> I need create the following tables; the create is ok, but I can't >>> run DB-Access, because I receive 'core dump' when execute the options >>> >>> Table --> Info --> Indexes. >>******* …
Re: Core Dump in Dbaccess
Nick Nobbe (nnob@loc.gov) wrote: >On Wed, 22 Feb 1995 xrizzi@arcride.edu.ar wrote: > >> I need create the following tables; the create is ok, but I can't >> run DB-Access, because I receive 'core dump' when execute the options >> >> Table --> Info --> Indexes. >******* stuff de…
Re: Core Dump in Dbaccess
On Wed, 22 Feb 1995 xrizzi@arcride.edu.ar wrote: > I need create the following tables; the create is ok, but I can't > run DB-Access, because I receive 'core dump' when execute the options > > Table --> Info --> Indexes. ******* stuff deleted ****** My $0.02 worth: If you…
Re: Core Dump problems
In article <3iin12$es9@hippo.shef.ac.uk>, S.Woolrich@Sheffield.ac.uk (Sally) wrote: > Our product is written & distributed in RDS (4.1x) and run with SE > 5.0x. We have problems at some sites (both ICL DRS6000 and Motrola) > with occasional core dumps. Our favorite difficult-to…
Core Dump problems
Our product is written & distributed in RDS (4.1x) and run with SE 5.0x. We have problems at some sites (both ICL DRS6000 and Motrola) with occasional core dumps. We used to think it was due to a fron-end program we used back in the days before DBESCWT existed, but removing it …
Memory corruption on NCR 3000
We are running Informix Online 5.02.UC6 on an NCR 3000 SMP, OS version 2.02, and we seem to experience a lot of strange problems. For example, a 4GL module might dump core at a very non-volatile point, such as calling an errorlog function. If we modify the code, the core dump oc…
[Q] Esql/c Core Dumps
hi! My platform is esql/c 5.0 on sunos 4.1.3. I am using the descriptor facility available to insert the records. Basically I set the data values of the descriptor with the values read from a file. If any field is not available i set the value to zero (note: It will be a charct…
Re: Debugger & Arguments
Sco Unix 3.2.4 Informix R4Gl 4.11 UC2 SE 5.0 If you try ru "fred is wild" in the debugger, we get a core dump. Quotes seem to be the problem Anybody else? Single quotes is used so we're not moaning, just curious. Neil @ storm@aztec.co.za…
4gl for Solaris/SPARC dumps core [?]
It seems impossible, but r4gl and i4gl both dumps core when executed (Segmentation fault). Environment: SUN SPARC Server 10/51 Solaris 2.3 SunPro SPARCompiler C 2.0.1 INFORMIX-4GL 4.11.UC3 INFORMIX-4GL RDS 4.11.UC2 INFORMIX-OnLine 5.02.UC8 INFORMIX-STAR 5.02.UC8 If you read my …
Has Informix OnLine and ESQL/C been ported to HPUX 9.05
I would like to know which version of Informix OnLine, ESQL/C and other tools will work with HPUX 9.05. I was using version 5.02 with HPUX 9.03 and I did not have any problems. But now with HPUX 9.05 my applications don't execute successfully. they dump core at some select calls.…
Converting Word Perfect Files
I have an Informix database that tracks and bills our medical cases. We have been keeping our results in Word Perfect 5.1 files. I wanted to integrate the 2 to allow for keyword searches and codifying each diagnosis. Does anyone have a way of converting and parsing these files…
Re: Tbcheck hangs OnLine 5.0 (UC3) engine
> > I have reported this problem to Informix tech support, but I have not yet > gotten any answers, yet. The problem is that when I (we) run the tbcheck > utility to collect extents, data & index page .... information, it hangs > the OnLine engine. Tech support indicates that t…
sqlexecd dumps core!
This is on a Sun 690 running SunOS4.1.3 with version 5.0 UC4. The stack trace is: realloc() malloc() yp_match() gethostbyaddr() _netaccept() sqaccept() main() This looks to me as if sqlexecd was compiled with a buggy version of malloc(). We know about (and have) a malloc() pat…
Re: I-Star/Isql
Tom Hogarty (hogarty.pad@sni.de) wrote: : >>From: db@med-in.uni-sb.de (Dieter Becker) : >>Informix-Online seems to work properly, but any attempt to start : >>isql or i4gl leads to a core-dump with error-message: : >>segmentation fault. If you are using NIS and I-SQL version 4…
I-Star/Isql
>>From: db@med-in.uni-sb.de (Dieter Becker) >>Informix-Online seems to work properly, but any attempt to start >>isql or i4gl leads to a core-dump with error-message: >>segmentation fault. Dieter we had a similar problem and found that when I-Star was installed last, it was n…
run 4ge with crontab; dumps core
We have a script that runs our batch jobs, and this script is run by crontab at night. Many of our programs do screen i/o (including "open window"). When these programs have been compiled with 4gl 4.1 (RS6000), they dump core instantly. We have set TERM and TERMCAP in the scri…
4gl Intermittent core dumps
Hi Folks, Just a question to see what kind of comments I may get, if any. We are a site that is running the following: a) 4gl RDS 4.10.UC1 on Sun SPARC 2. b) SE 4.10.UC1 engine c) Users access the Sun from telnet sessions from various platforms. We are having the follow…
ESQL 5.01UD1 core dumps.
We're trying to upgrade some software that we can esql -e with both 2.10 and 4.1 ESQL. It has numerous string * variables, and several fetches. We can reduce the problem to a simple fetch with one string * variable, and two long host variables. If we DELETE this fetch, or chan…
Esql-C Problem
I am having a problem using ESQL/C (embedded C) under SCO Unix with Informix SE 5.01. Here is a code snippet: // cursor declared here $open sched_cursor; $fetch sched_cursor into $ctbkno, $ctcasub; // host variables while (sqlca.sqlcode == 0) { // do some processing …
Segmentation fault (core dumped) HELP!!!
We have an Informix Online database. We are having a problem with two of our databases. They are up and limping. When I run a tbcheck -cc dbname on the database, I get the following: Validating database dbname Validating systables for database central ISAM error: no record …
sqlexec core dump
I am using INFORMIX-SQL Version 2.10.03K for Xenix sqlexec is core dumping during an index call with a return code of 141. What does this error code mean? Does anyone have any experience with sqlexec core dumping? What can I do to get around this problem?…
Re: zerofill dumps core.
}From: thompson@netcom.com (Eric Thompson) }Subject: zerofill dumps core. }Date: Thu, 14 Oct 1993 01:38:58 GMT }X-Informix-List-Id: <news.4597> } }Perhaps this is a known bug, I haven't called it in yet.. but I'd like }to hear either workarounds or similar stories that this doesn…
zerofill dumps core.
Perhaps this is a known bug, I haven't called it in yet.. but I'd like to hear either workarounds or similar stories that this doesn't work. I'm JUst writing a standard form with Informix-SE engine, using a integer column in the table, and in the form the line is: ben = table.co…
Re: CORE DUMPS w/SE...?
In article <2502pr$ch3@access.digex.net> briang@access.digex.net (Brian Gallagher) writes: > >I have strange problem that occurs on the Informix standard engine >only. I'm having a similar problem to which I posted a couple of days ago. I received 1 response saying my problem wa…
Bug using 'now' as variable name in 4GL
Using 4GL 4.10.UE2 on SCO 3.2.4 I tried using a variable called 'now' in a 4GL program ... core-dump city! The word 'now' is in the list of reserved words ... anyone know what is it for, or what it does? Either of the following will dump core when run: ----------- define d dat…
Large character fields core dump
We're running Informix SE (5.00.UC2) & SQL (4.10.UD2) on a Data General Aviion and having some problems whenever we have large character fields in our tables. We generally can't use character fields greater than 250 or so characters without running the risk of having it core dum…
Informix 4.00.UG1 compatibility with SunOS 4.1.3 (Second call)
I am about to install SunOS 4.1.3 on a SparcStation 2 which is running Informix Online, SQL and 4GL versions 4.00.UG1. Is anyone running this combination? What has your experience been? Please email me below. Thanks. -- Doug Konrad, P. Eng. Dr. T. A. Kasper and Associates Medic…
Is Informix 4.00.UG1 compatible with SunOS 4.1.3?
We are going to replace one of our database applications. We are currently using the Informix-Online engine, 4gl and isql programs. Before we install the new application, I want to upgrade SunOS from 4.1.1 to 4.1.3. Are our Informix 4.00.UG1 products compatible with SunOS 4.1.3? …
5.0 bugs (Was: tbcheck core dumping)
In article <HOLDER.92Sep18093635@gourde.positron.med.ge.com> holder@gourde.positron.med.ge.com (Kacy Holder) writes: > >In article <1992Sep15.010353.7889@anasaz> naomi@anasaz (Naomi Walker) writes: >=> > >data. 5.0 has a few *much* more serious problems we would >rather they fix…
Re: tbcheck core dumping
In article <1992Sep15.010353.7889@anasaz> naomi@anasaz (Naomi Walker) writes: => => We have two AS400 386 machines, using Interactive unix. On one box, => where the database was originally built, we were running 4.0 Online. => Unfortunately, we had a problem and overflowed the d…
tbcheck core dumping
We have two AS400 386 machines, using Interactive unix. On one box, where the database was originally built, we were running 4.0 Online. Unfortunately, we had a problem and overflowed the dreaded lock table. I ran tbcheck -cd, and it core dumped. Since 4.0 was not the most stab…
Informix SQL reports core dumping :-(
Gentle Netfolk, We've recently moved from Informix SQL 2.10.03 to a set of SE (4.00.UE4) and SQL (4.00.UE1). One ofthe big 'wins' of the new software is the implementation of the DATETIME type. However, using DATETIME variables or PARAMs in an ACE report when said variable or p…
Control-X bug in WORDWRAP
Path: emory!att!pacbell.com!ames!elroy.jpl.nasa.gov!sdd.hp.com!zaphod.mps.ohio-state.edu!qt.cs.utexas.edu!cs.utexas.edu!uunet!mcsun!uknet!slxsys!ibmpcug!tab From: tab@ibmpcug.co.uk (Andrew Beattie) Newsgroups: comp.databases.informix Keywords: 4GL wordwrap Message-ID: <1991Nov18.…
Re: 4GL core dump
Path: emory!samsung!cs.utexas.edu!utgpu!watserv1!watmath!mks.com!john From: john@mks.com (John Postma) Newsgroups: comp.databases.informix Message-ID: <1991Nov7.191331.17084@mks.com> Date: 7 Nov 91 19:13:31 GMT References: <1991Nov2.051551.6084@ipars.cts.com> Organization: Mortic…
Re: 4GL Core Dump
Quoting Scott O'Connell, Spectrum Data Services, Carlsbad, CA: > A little over a year ago I upgraded my 4GL, SQL and SE database development > products to 4.00.UE1. The software was running under SCO Xenix 2.3.2. > Right after doing that I wrote a program from scratch using t…
Re: 4GL core dump
Path: emory!swrinde!cs.utexas.edu!usc!ucla-cs!ucla-mic!agsm!ggordon From: ggordon@agsm.ucla.edu (Glen Gordon) Newsgroups: comp.databases.informix Message-ID: <ggordon.689120653@uclagsm> Date: 2 Nov 91 22:37:53 GMT References: <1991Nov2.051551.6084@ipars.cts.com> Nntp-Posting-Host…
4GL core dump
Path: emory!swrinde!cs.utexas.edu!usc!sciences.sdsu.edu!ucselx!berick!optigfx!crash!ipars!scotto From: scotto@ipars.cts.com (Scott O'Connell) Newsgroups: comp.databases.informix Message-ID: <1991Nov2.051551.6084@ipars.cts.com> Date: 2 Nov 91 05:15:51 GMT Organization: Spectrum Da…
Re: Informix error -208
I had this problem before. The fact that you are getting a memory-allocation error is a plus. All I got was a memory fault and a core dump. I had to find the error using dbx. Make sure that you CLOSE and FREE all cursors and PREPAREd statements whenever you no longer need the…
4GL Core Dumps. Help!
Path: emory!att!cbfsb!cbnewsb.cb.att.com!nll From: nll@cbnewsf.cb.att.com (neal.l.leitner) Newsgroups: comp.databases.informix Message-ID: <1991Sep23.141552.27704@cbfsb.att.com> Date: 23 Sep 91 14:15:52 GMT Sender: news@cbfsb.att.com Organization: AT&T Bell Laboratories Originato…
Re: Informix 4GL 4.0 on ISC 2.2.1 BUGGG
Peter Ziobrzynski <peter@modtor.uucp> writes: > Anybody using Informix-4GL 4.00.UE1 on ISC 2.2.1 or SCO ?NIX ? > If you don't and plan to do it ($2000+) LOOK at the following fatal BUG :-((. > > Any attempt to use QBE (query by example) is doomed on failure in this product. > If …
Re: c4gl Core Dump
David E. Brooks Jr, in your mail you wrote: > > > main > > define startcol smallint > > open window xwin at 10,startcol > > with 2 rows, 40 columns > > end main > > > > Apparently, the parser in the C4GL compiler doesn't like identifiers > that start with reserved words (star…
Re: c4gl Core Dump
> > The following 4gl code will cause the c4gl compiler to core dump. It > appears as though it doesn't like the variable name "startcol" because > if you change it to something like "xstartcol" it compiles fine. It is > also interesting to note that the RDS compiler has not pr…
c4gl Core Dump
The following 4gl code will cause the c4gl compiler to core dump. It appears as though it doesn't like the variable name "startcol" because if you change it to something like "xstartcol" it compiles fine. It is also interesting to note that the RDS compiler has not problems wit…
Informix QSTEP Core Dump Bug
Yep, it's known. > > Here is a sure-fire way to crash qstep on my terminal. I am running qstep > version 4.00.UE1. > > abort - core dumped. > > and be back at the $ prompt. > > ========================================================================= > Is this a known bug? I …
RE: Assert Failed on NT system
There are more details at the Techinfo center. http://www.informix.com/informix/services/ilink/alerts/123099_117981.htm The case notes say that this only happens when a "DNS/router problems which result in unreliable domain name resolution." is used. WORKAROUND A potential wo…