Oninit® Archive
Results for “LTXHWM”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
Error in COMMIT WORK when trying to add a chunk
@Jacob, I may be misremembering, or maybe things have changed in recent versions of Informix, but in general, it is better to have several smaller logical logs than a few (or a single) large ones. This is because the LTXHWM and LTXEHWM percentages are based not on the percentage…
12.10.FC15W1AWE Blocked in LONGTX
Could it be that the rollback was still going, but had hit the LTXEHWM threshold? onstat -x would have shown some movement if that was the case. If the logs had got to the point where the next log had an open transaction, you could have tried adding logs manually with onparams -…
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 ------------------------------…
Logical Logs - Flags and backups
Hi Mark, One statement in your post above has not been addressed - " With this setting would it be safe to also assume that we would not run out of log space etc. as backups are continuous and would just continue to cycle around in sequence?" The answer is a qualified "Yes". The…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Suresh: You do not have enough logical logs defined. Any transaction or combination of transactions that span more than the percent of logical log space documented in the LTXHWM parameter in your ONCONFIG file will trigger the oldest of the open transactions to roll back with a L…
LIMIT DELETE ROWS
Doug, using SESSION_LIMIT_LOCKS will just terminate the transaction sooner, not break it up into smaller transactions which is what the OP needs. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ---…
calculation of Required logical log
Amit: You may be able to use either my dbcopy or demove utility, both included in my utils2_ak package, to copy the data using smaller transactions! You can download the latest release of utils2_ak from my web site at www.askdbmgt.com/my-utilities ------------------------------ A…
Logical Logs/Physical logs
IDS 12.10.FC12 Solaris 10 1/13 If you had to choose having a separate dbspace for logical logs or physical logs, but not both, which would you choose? I'm uncertain which is likely to generate more I/O. Thank you. Regards, DG ------------------------------ David Grove -----------…
gTA cannot be killed
Hi SangGyu Jeong, thanks for the help and quick answer. Yes, the database then cleaned up the transaction. But I already had similar problems on development and test computers, whereby the database did not automatically abort the long transaction, even though LTXHWM was exceeded.…
Long Running Purge Script
Nice little gotcha, running single user single session with LTXEHWM > 50 without DYNAMIC_LOGS then the engine will/can break when you hit a LTX. Corner case for sure but .... Cheers Paul ------Original Message------ Thanks for the clarification Andreas Art S. Kagel, President and…
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…
Spaces and Spindles: Thought Experiment
For extra credit, consider having two dbspaces for logical logs (odd and even). DG…
Number of logical logs growing ?
This is what I've found in logs at the time of crontab ontape -a jobs ( no one was connected to the db, neither no jobs were usign it ): 17:20:01 Logical Log 47416 - Backup Started 17:20:01 Logical Log 47416 - Backup Completed 17:20:01 Logical Log 47417 - Backup Started 17:20:01…
Connections made to RSS are visible on PRIMARY
Dear All, Informix version 12.1FC10 on HP Unix and application running on RHEL 7 SET up has a PRIMARY, SDS and RSS We have a read only application that is pointed to RSS servers (direct connection to RSS server and NOT via Connection manager) When we start this application whi…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
Aborting long transaction doesn´t rollback tx
Roger, Doug explained it perfectly. There are also 2 things you can do, bearing in mind that you should be in control of the possible consequences: - add more logical logs ( raising the question: do you need just a few more or incredibly more) - long transactions are controlled …
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…
Could not do a physical-order read to fetch next r
Ok, open a case with IBM support. Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Informix on Cloud - Database Administrator - 2017 IBM dashDB Managed Service for Analytics and Transactions - 2017 DB2 Advanced DBA - v10.5 for LUW…
transation logs problem
Hi Fernando, Thanks for the information; I´ll try your suggestion to lower the values for LTXHWM, because on some servers to get bigger space for them is quite difficult. There is any formula/rule to estimate that size? Best regards, SP…
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.…
locks persists while client app is down
If you confirm that the locks belong to Global Transactions (aka xa transactions), then there is no direct way to clear them without a restart (and they will probably survive the restart??). One way is checking the RFE in: http://www.ibm.com/developerworks/rfe/execute?use_case=v…
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…
Should we close an opened cursor?
Hi, this practise will consume memory on the server side, which is never freed until the application is terminating. Unless you do this by purpose (you want to reuse the prepared cursors), I would close the cursors. Or - more problematic - it might block some rows in the databas…
How to avoid blocking checkpoints?
Dear Friends: Many thanks to all who helped me, such as Art Kagel, Jacques Renaut, Andreas Legner, etc. My configuration was as follows: ############################################################# # Shared Memory Parameters LOCKS 200000 # Maximum number of locks BUFFERS 300…
IDS not writing to online.log
You're probably going to need at least another 50 logs to complete the rollback. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are m…
Issue in transactions with informix using DRDA
Hi Roger, In case of distributed transaction, application don't need to explicitly start a transaction. The Ambient Transaction will be initiated by the Distributed Transaction Manager based on the transaction scope criteria what application has specified. That means you may pu…
Drop rowid transaction
Greetings. I am hoping I have not painted myself into a corner. I created a fragmented table with rowids. This was to prevent a problem I had encountered in a previous load of another fragmented table. With the perfect 20/20 hindsight most of us possess, I realized that the pro…
Long transaction problem
When IDS will used up all the logical log? i.e. the log file below the current logical log file has open transaction also . thanks for your time.…
Need assistance on spreading logical logs
IDS 11.70 I need advice on how to setup a spread of logical logs over at least two disks. the idea behind this is to enable one logical log to be backed up and another being used which may improve performance.…
dbimport and long transaction
Seems we got the long transaction issue when doing dbimport. Except for some known means of handling long transaction ( more logs, increasing LTXHWM), any more tips or suggestions ....? Thanks Frank --001a114f3a10fbdfd10534a03ad3…
Re: dbimport and long transaction
Forgot the version, IDS 12.10 FC4 On Mon, Jun 6, 2016 at 2:27 PM, FRANK <yunyaoqu@gmail.com> wrote: > > Seems we got the long transaction issue when doing dbimport. > > Except for some known means of handling long transaction ( more logs, > increasing LTXHWM), any more tips or …
Mutex logs on logical log flip
IDS 11.50 on Solaris We've only just started noticing this odd occurrence. I t only just have started happening or it may have been happening for ages but there's more focus upon it now. Our customer's monitoring was detecting occasional periods of slow queries, perhaps persist…
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)…
Long transactions monitor and Statistics
Hello all, IDS 12.10.FC1WE on Solaris 10 9/10 s10s_u9wos_14a The monitoring we use for Informix in our environment detected that certain session is being rolled back due to occupying more log space than defined in LTXEHWM parameter. So far so good, the engine successfully did a…
Stuck transaction
On 05/05/15 15:47, MICHAEL HOFFMAN wrote: > Hi All, > Informix 11.5.FC9 running on Solaris 10. > I found a transaction using 'onstat -x' that is definitely stuck. > > 119696f88 -LH-G 0 0 logid 81731 81763:0x189257c COMMIT 0:00 0 > > The problem is that those log numbers date back…
Root db space fills up
The logical and physical logs reside in there own db space.…
Rename a partition
Richard, Thank you. The web page provided the extra facet of information I could not find in the PDF manual. What I needed to do was to repeat the fragmentation expression, something like: alter fragment on table tfrags modify partition tfrags_21_40 to partition tfrags_21_30 (…
RSS not working
Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message?…
RE: onunload
Larry, here's one option: Drop the target database and recreate it empty with the expected extent sizing (myschema can help with that) then copy the data directly from the source database to the target database using my dbcopy and/or dbmove utilities. Make sure that the target da…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
DYNAMIC_LOGS=2 Functionality?
Hi, Silly question ... do you backup your logical logs? If you do want to backup your logs, then consider using ALARMPROGRAM to backup logical logs when complete (using onbar or ontape) - that way you should not encounter full logical logs because they are not being backed up. …
Logical log backup
Folks, IDS11.50FC8 , Linux We have a couple of boxes , all are setup to do automatic logical backup. Once the current log is full, it triggers the alarm procedure to start a backup. It works great. But, The interesting thing is, some servers do not always backup a full logical…
Database in (LONGTX) need identify case user
Yes, you can avoid the long transaction problem by doing these things: 1. Limit globally affecting transactions like massive updates and deletes. There are tools and techniques to break these operations down into smaller pieces that avoids the problem altogether. 2. Make sure…
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.…
External tables not reading all rows
Hmm, no ideas. Try a wildcard - external tables have their own wildcarding format, documented in the manuals. You'll have to rename the files xa1, xa2, xa3, ... See if that is handled better. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-m…
ER network replication state
When we have a large transaction, or a large blob to replicate, if the queue mem size is about to be exceeded, then we do two things, 1) we sp= ool the transaction to disk and 2) notify the source not to send any new transactions until the large transaction is processed. This is …
DB Tuning question
Hi Art, This is the updated configuration: I have changed SHMADD and SHMVIRTUALSIZE from 20000 to 100000. LRUS is still 16. LOCKS 300000 # Maximum number of locks #BUFFERS 150000 # Maximum number of shared buffers BUFFERS 50000 # Max number of shared buf NUMAIOVPS 1 # Number of…
need quick way to find whom is causing Blocked:LON
Thanks for the information, I have LTXHWM set to 50 and LTXEHWM set to 60, sounds like I need to increase the difference. The cause seems to be a developer added a new field to a large table that should have been defaulted to not null, when a cleanup process ran it found a larg…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Add more logical logs in IDS 9.4
Hi All, I'll be performing adding logical logs into our existing DB. My question are the following: 1. Do the DB needs to be in quiescent state? i believe, there's no need at all. Once i have added the new dbspaces to be used by the logical logs, i will drop the existing ones …
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,…
Any resolution steps for this failed llogdbs that
IDS: IBM Informix Dynamic Server Version 11.50.FC9W1X7 OS: Sun Microsystems Inc. SunOS 5.10 Generic January 2005 I'm having the Systems Admin to review the disk now. 14:13:25 Assert Warning: I/O error, Primary Chunk '/ifmx/ciboodle/chunks/llogdbs_4' -- Offline 14:13:25 IBM Info…
Lost data
Informix does not "lose data". When I have seen this it is almost always because the applications are not using proper transaction management. Look up Optimistic Locking Protocol or Optimistic Transaction Protocol. I have posted descriptions of the method on the forums many times…
help required dropping 200 gig db getting long tra
Have you tried turning off logging (use ontape) or droppin ga few tables at a tie? j. On Aug 1, 2012, at 7:43 PM, KARL OLIVER wrote: > more info=20 > LTXHWM 40 # Long transaction high water mark percentage=20 > LTXEHWM 50 # Long transaction high water mark (exclusive)=20 >=20 >…
IDS 7.31 UD5 data(base) recovery
On 18 Kwi, 19:13, Superboer <superbo...@t-online.de> wrote: > Hello Marcin, > > it sounds like that your LTAPEDEV is set to /usr/informix/ltapedev > in your onconfig file. > > if that ist the case you can set it to /dev/null. > > eq in $INFORMIXDIR/etc/$ONCONFIG search for LTAPE…
non-log and logical log buffer
Hi, If a database is non-log, do update/insert/ go into the logical log buffer? thanks for your time.…
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 …
Restore + Logical log - caution
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you restore an archive with logical logs , maybe you needed the files/tapes of logical logs backuped before the Archive Level 0. The rea…
CLR vs Long Transactions...
Immediately backing up your log doesn't automatically make it available for re-use. A long transaction is a function of how many logical logs a transaction spans (stays open) with respect to the amount of logical logs you have defined. In your situation every time you do a log sw…
Long transaction
The answer is YES for SELECTS. For UPDATES, DELETES, INSERTS, the other sessions can still do work and write into the logs if the LTXHWM is reached for the long transaction being rolledback and the LTWEHWM has NOT been reached yet; since rolling back a transaction consists of a …
Issues after upgrade
Hi, I have error messages after the upgrade from 7.31 to 11.5 In 7.31, the output of oncheck -pe was: ... LOGICAL LOG Pages - Log 52 456063 8000 LOGICAL LOG Pages - Log 53 464063 8000 LOGICAL LOG Pages - Log 54 …
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.…
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…
RE: Blocked checkpoint -
IDS 10.00.FC5 Red Hat RHEL5 We are facing a couple of problems with the Informix Engine being "Blocked", checkpoint required during a long transaction. We have faced this issue several times and each time when the Engine is shutdown and rebooted, we get into a similar situation…
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…
Re: how to terminate global transactions?
On 28.06.10 11:19, Davorin Kremenjas wrote: > On Jun 27, 6:51 pm, Frank Langelage<fr...@lafr.de> wrote: >> On my Informix instance I have two global transactions holding some >> locks. See onstat -G and onstat -x output below. >> How can I get rid of them? >> Also after a server…
how to terminate global transactions?
On Jun 27, 6:51 pm, Frank Langelage <fr...@lafr.de> wrote: > On my Informix instance I have two global transactions holding some > locks. See onstat -G and onstat -x output below. > How can I get rid of them? > Also after a server reboot they are still there. > onmode -Z <address…
Display contents of Logical Log
Is there a way to display the contents of the logical logs if the LTAPEDEV parameter is set to backup the logical logs to a directory? (LTAPEDEV /informix11/inflog) I had a look at the onlog command and in that the -d switch accepts the tape drive path. Appreciate your response…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
Have any of you experienced this? In reviewing the online.log, I discovered that AFTER a system reboot, and ONLY AFTER a system reboot, the first time the "Auto Update Statistics Refresh" begins, the following performance advisory is recorded. The Backup occurs nightly, the AUS …
RE: 4GL run-time error number -4339
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY SORENSEN > Sent: Wednesday, March 10, 2010 2:54 PM > To: ids@iiug.org > Subject: RE: 4GL run-time error number -4339 [19306] > > The load is handled by a separate process;…
Long Transaction Despite DYNAMIC_LOGS = 2
Clifton, my inputs are as followings: The transaction by the user "ifxcmgt" spanned 2.2 GB (LTXHWM=70%) out of 3.1 GB total logical log dbspace (~33000 KBx100 or 3.1 GB); therefore, it was defined as a long transaction and was rolled back. Transaction rollback and other process…
Re: Upgrade from 9.4 to 11.10
One thing I noticed is you have lots of little logs - 85 12M logs for a total of 1Gig. IDS 11 prefers larger log files so that it does not fill and switch too quickly (which might occur during the batch processes). It will give you a warning in the alert log when/if that happen…
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…
Need enlightenment regarding long transactions
Art Kagel wrote: > If there are open transactions in a logical log then it cannot be > reused/overwritten. This means that if there are many long running open > transactions, or one or more very large transactions that span many > logical log files, there will come a point at wh…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
how to free up logical logs
Hi All, I've encountered problem on logical logs once again... I'm using onbar on backing up the logical logs and dbspaces. Unfortunately, the netbackup failed and causing the "logical logs" full. Q: what is the correct solution, without losing the logical logs? Is there any wa…
SDS Mach 11
kate said: > When you are using SDS with Mach 11, how does Informix balance the load > across multiple pieces of hardware that are all using SDS to share a disk? > I assume through connection manager, but I would like to understand the > logic of how it determines how to send a t…
ontape -c
I use 'ontape -c ' to backup the logical log, if the 'ontape -c' process was terminated abnormally, for example, the machine crash or it was killed by others, do anybody know if I could restore those logical log sucessful?…
Logical logs backup
Hi Martin, Thanks for your response! Correct me if my clarification is wrong! At one point of time, the status of the logical logs is Logical log 4 to 7 -> U_B__ Logical log 8 -> U_C_L Logical log 9-13 -> U_B__ All the logical logs are 100% full When i did a level 0 backup, th…
Problem Building Tuxedo TMS with Informix 3.5 SDK
I have upgraded to Client SDK 3.5 from 2.81 I have attempted to build the Tuxedo transaction manager (TMS) with the following line in the RM file, which works for 2.81 INFORMIX-OnLine:_Odbc_xa_switch: -I${INFORMIXDIR}/incl/dmi -L${INFORMIXDIR}/lib/cli -lifcli -lifdmr -lm -ldl -…
Informix HADR - Add new Database
IBM Informix Dynamic Server Administrator's Guide Planning for HDR Before you start setting up computers and database servers to use HDR, you might want to do some initial planning. The following list contains planning tasks to perform: * Choose and acquire appropriate hardware…
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…
Reducing logical log space
I'm looking for reassurance, really ... IDS 10.0FC8 on HP-UX 11.31. HDR running. My customer is running out of disk space on its production system, and cannot provide any more at all for Informix for a couple of weeks (don't ask!). As the application dbspaces will likely not l…
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 …
Extracting logical logs from a level1 archive ?
Is it possible to extract the logical logs from a level1 archive to use for rolling forward ?…
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…
Location of physical and logical logs
This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? Thanks -- Regards Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Sh…
Re: Logical Log files MISSING
Bigger logical log files?…
Logical Log files MISSING
Hello Ive checked the online.log file for one of the missing log 20084 23:12:22 Logical Log 20083 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20084 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20083 - Backup Started 23:12:23 Logical Log 20083 - Backup Comple…
slow views on IDS 11.50FC1
On 7 Oct, 22:30, ralf.blankenb...@eurotaxschwacke.de wrote: > Hi, > changing from 10.00FC4 to 11.50FC1 causes a "select * from view_XXX" > to run more than 2 hours. On 10.00FC4 this select took not more than > 10 minutes.An unload directly from the tables with the same select > s…
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…
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…
How to Get PID to Kill IDS process
As someone else already pointed out, "onstat -g glo" will list all the oninit created OS processes. I'd like to add that in no way you should need to kill the processes. If the instance hangs you should contact technical support and you should start by figuring out what is a "han…
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…
Fragmentation - your ideas?
I am puzzled as to how you would do round robin on 10 fragments and retain your 'active flag' fragmentation on an 11th, or has the two level fragmentation scheme finally made it to 9? I was going to write a long diatribe disparaging your setup - on reflection it sounds quite rea…
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…
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.…
Parameter tuning?
Pls see the instance profile and shared memory parameters below. The problems I noticed are 1. low read-cache-hit 35% 2. low write-cache-hit 79% 3. a lots of bufwaits and seqscans What do you advice? Informix Dynamic Server Version 7.31.UD3 -- On-Line -- Up 158 days 02:30:01 --…
Understanding the Logical Log Usage
Am using version 10.00.UC7X1 and have a few *basic* questions on the usage of the logical log file. The database has a logging mode of unbuffered logging with a page size is 2048 bytes (as returned by onstat -b). I have 3 log files with each file being 5000 KB in size. I have a …
Infamous Long Transaction problem
Will, Once you hit a long transaction abort, my suggestion is to wait it out. Rollbacks routinely take 15-25 times the duration of the initial modifications. Efforts to speed the process are almost always futile and will only delay the process. No matter what you do, Informix wil…
Re: Moving a table
Roberto, I've moved a 76 million row, 5.5 million page table with this command on an instance configured with 2 million locks. I've never had a problem with "no more locks". The command looks to be grabbing an exclusive table lock. However, I have run into long transaction abor…
Creating index and none logging.
Question: Can you still receive the following Long Trnx on index enable is logging is turned off? 06:20:18 Aborting Long Transaction: tx 0x26d62388 username: informix uid: 1004 -458 Long transaction aborted. The database server (probably OnLine or INFORMIX-OnLine for NetWare)…
Potential Long transactions
Haven't looked at this thoroughly yet, but thought that I'd point out that you can get $ONCONFIG values (like LTXHWM) directly out of sysmaster. select * from sysmaster:sysconfig where cf_name like 'LTX%' cheers j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Orig…
Re: Restoring a logical log
ian.miell@gmail.com wrote: > We have some scripts which parse the output of onlog -n/-l and > produces user-friendly output. > > We've been given a log file from backup which has the header: > > [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less > 00000000 ff ff ff ff ff ff 00 00 00 0…
Restoring a logical log
We have some scripts which parse the output of onlog -n/-l and produces user-friendly output. We've been given a log file from backup which has the header: [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less 00000000 ff ff ff ff ff ff 00 00 00 0a 00 09 00 9d 07 5f |..............._| …
Re: How can fetch cause long transaction
> I have one more question: > > When DYNAMIC_LOG is set 2, does it starts to add more logical logs > dynamically when next logical log in the sequence has open > transaction. Does this become active only during roll back and next > logical log has an open transaction or could it …
How can fetch cause long transaction
On Feb 15, 5:17 pm, mohitanch...@gmail.com wrote: > Version IDS 10: > > Application throws SQL -458 and -ISAM 12204 right at the point when it > tries to fetch a row from the cursor. My question is how could it fail > at this point, FETCH and selects are not even written to the l…
checkpoints Excessively slow
hi all we have IDS 7.31 UC4 on unix with 2GB Memory Since yesterday the system has become too slow with excessive checkpoints: 01:04:38 Checkpoint Completed: duration was 5439 seconds. 01:52:52 Checkpoint Completed: duration was 1931 seconds. 04:06:37 Checkpoint Completed: dura…
Logical Log
Version IDS 10 When DYNAMIC_LOG is 2 and logical logs gets full Informix starts to write to rootdbs and Informix uses LOGSIZE from what was used initially for disk space initialization. And it appears like even if the LOGSIZE is changed using onparams or in onconfig file, Inform…
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…
Never ending Checkpoint
IDS 9.40.FC4W2 SunOS 5.8 Last Saturday we had a "never ending checkpoint". There are no loggings about the event except the lines in online.log: 11:41:01 Fuzzy Checkpoint Completed: duration was 2 seconds, 2789 buffers not flushed, timestamp: 0x60364810. 11:41:01 Checkpoint …
How HDR resync after network connection resumes
With "RETAIN_TYPE" is set to 1, HDR would be reestablished from secondary server when old primary is up once again. When the logical log backup has been performed on secondary server, how the oustanding logical log could be retrieved for resync to old primary server? 1) Do I ne…
HDR failure handling on network disconnection
Is the process of logical log rolling forward by "ontape" or "onbar" are automatic?…
Difference between Physical and Logical Logs?
It seems the work done by logical log is more than physical log. What is the point of having physical log? As logical log already including post and pre image of database chanages.…
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
Informix Engine not starting
Can you please try to increase Physical & Logical log file sizes in Onconfig.bnm Thanks Tara…
Process taking most of Logcal Log
Version: IDS 10 Is there a way to tell which process on the box is filling up the logs. I was thinking if there is a way to tell which process / thread is writing the logical logs or filling up the logical logs…
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
Does these parameters help in logical log recovery. I was wondering if increasing ON_RECVRY_THREADS help in HDR on secondary server.…
HDR Secondary mode Log transfer handling
How the transcation is delivered from Primary Database to Secondary Database? - In a full logical log ? - Any committed transaction at Primary Database? If the transaction is delivered from Priamry to Secondary Database in a full logical log, then any recommendation on the size …
Perl, DBI, and Transactions
On Aug 2, 1:15 pm, "Brian McLaughlin" <bmcla...@georgefox.edu> wrote: > Thanks for the quick reply. > > The handle ($dbh) is the same for all three statements. > > The $results -- I initially used the same for all three statements. I > was kind-of grasping at straws when I tried…
long transaction, onstat -l, flag A----
On Jul 30, 8:11 am, Claus Samuelsen <c...@dk.ibm.com> wrote: > mohitanch...@gmail.com wrote: > > On Jul 30, 12:51 am, Claus Samuelsen <c...@dk.ibm.com> wrote: > >> mohitanch...@gmail.com wrote: > >>> Recently, we added logical logs because we were performing alters/ > >>> updates…
IDS Primary down
Hi all.... In it completes week, my IDS Primary has down in 4 opportunities having shown the following message of error: 03:10:47 Maximum server connections 567 03:11:21 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 03:11:21 IBM Informix Dynamic Server Version 10…
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: Error in Enterprise Replication
On 3 May, 07:49, "Navaid Arif" <navaid.a...@access.net.pk> wrote: > Dear All, > I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? > Actually at source side of Replication environment, We are using a vendor applic…
Storage Area Network Fails for Unix/Netware
Here we are... more than enough information in the online.log; Certainly, you can see it lost contact with the logical logs drive space: I wonder if Informix is overly quick to declare a dbspace off limits? Perhaps the time it takes for SecurePath to flip still isn't adequate fo…
Logical Logs in Enterprise Replication
Hi All, I am using Enterprise Replication on IDS10 UC5. I have 33 Logical Logs for IDS, each of 5000 pages i.e. 20,000KB. Test >onstat -l IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes Physical Logging Buffer bufu…
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.…
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…
Re: Error in Enterprise Replication
Dear All, I am already using following setting. Should I increase LTXHWM and LTXEHWM to some higher value like 100 or 120 ? Actually at source side of Replication environment, We are using a vendor application which is not using dbload or other utility and I cannot force my v…
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: Splitting logical logs
news.arcor.de wrote: > IDS 9.4 WE, Sola�ris 9 > > Hi everybody, > > we use to back up our logical logs using "ontape -c", for example in a file > named "trans.log". > As a consequence, when restoring a Level-0 backup using ontape -r, we can > only restore *all* logical logs con…
Splitting logical logs
IDS 9.4 WE, Sola�ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logic…
Re: Senior Oracle DBA now Learning Informix by Request of Company:IThought Informix was Dead?
> How about 2000 POS instances with common data replicated and distributed > and managed by a team of 3 DBAs one of whom pitches in part time. I believe we can match this. I will follow up at work and see what I can find > How about 10000 replicated instances with update anywhe…
size of rootdbs
On 30 Nov 2006 02:19:10 -0800, doitman <sunil.saggar@gmail.com> wrote: > Thanks Keith. > > # LTXEHWM should be atleast 30% so that we could minimize log overrun > issue. > > DYNAMIC_LOGS 2 > LTXHWM 50 > LTXEHWM 60 > > Dynamic logs are ON. > meaning that it wil…
Logical log backups
Hi I am having a dreadful time with a autochanger tape device for which my logical logs and archives are backed up to. Problem being the device frequently stops working and unless it is fixed before the logical logs run out, I get downtime. I am using the networker software to …
need help - infformix is down - restart got index failed
this is what i got!!!! ========================================================= from the online log: Wed Nov 22 23:20:46 2006 23:20:46 Event alarms enabled. ALARMPROG = '/informix/S21/etc/no_log.sh' 23:20:52 DR: DRAUTO is 0 (Off) 23:20:52 WARNING! LTXHWM (70) and/or LTXEHW…
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: Rollback
Colin Dawson wrote: > Solaris 9 > IDS 9.40.FC8 > > A developer ran an updare on a table with 152M rows as follows: > > begin work; > lock table in exclusive mode; > update <table> set <col> = 0 where <col> is null; > > The update would have updated 122M of the 152M. I have LTXHWM…
Rollback
Solaris 9 IDS 9.40.FC8 A developer ran an updare on a table with 152M rows as follows: begin work; lock table in exclusive mode; update <table> set <col> = 0 where <col> is null; The update would have updated 122M of the 152M. I have LTXHWM set to 45 to prevent excessive trans…
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…
not write Log
Can I control the writing Logical LOG? I mean I have a large job and it will use up all my Logoical logs, so I would like to avoid writing log temporarilly for this job. Thanks, Quman…
RE: Dumb DBA mistakes
davidwrote: > - some idio^H^H^person I once trained had LTXHWM and LTXEHWM set too > high and filled their logs. 30 and 40 should be made manadatory. You > can have 32767 logical logs - use more logs. And make them all the > same size. > Tilman disagreed: > I disagree. LTXHWM an…
AW: Dumb DBA mistakes
david@smooth1.co.uk wrote: > Dumb mistakes. > > - some idio^H^H^person I once trained had LTXHWM and LTXEHWM set too > high > and filled their logs. 30 and 40 should be made manadatory. You can > have 32767 logical > logs - use more logs. And make them all the same size. > I dis…
Re: Dumb DBA mistakes
Dumb mistakes. - some idio^H^H^person I once trained had LTXHWM and LTXEHWM set too high and filled their logs. 30 and 40 should be made manadatory. You can have 32767 logical logs - use more logs. And make them all the same size. - some idio^H^Hperson I know recently managed t…
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 …
DataBlade Manager
hello all, how does one "install" Blade Manager? HP-UX 11i IDS v10 we have a developer who wants to use the datablade API to generate auditing events from transactions..........Thanks Tom…
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?…
Re: transactions between two databases different instances same sever
full server was stopped with a power cut. When we power on server again I started both instances A and B. On instance B we had one rollback and On instance A we had several commits but 0 rollbacks. there weren't opend transactions and 0 bad locks. I didn't review onlog. Both …
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/…
logical log size
Hello, The logical logs on my system are configured as 30 32MB logs. The system has been growing rapidly and currently cuts 2-3 logs every 5 minutes. Backup is to a spectralogic tape unit, which is fairly slow to spin up. In order to not run out of logs due to backup issues, I w…
Not using the 100% logical log page size alloacted to informix
No, i meant the logical log page file that i have appended in my query.…
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…
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!…
return code 164 during logical log backup
Hi all, I have following kind of problem with logical logs backup: When the current logical log is comming full, it does'nt make logical log backup and in online log of informix following message appear: -------------------------------------------------- 16:13:14 Logical Log 524…
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.…
Re: Long transaction aborted in Informix IDS 7.31
Hi. Firstly you should check how many log files has your instance (onstat -l, last line). If it has less than LOGFILES, you should add as many log files as you need. If not, you should set LOGFILES to a higher value and then add logfiles. By the way, if your database has 100…
Long transaction aborted in Informix IDS 7.31
the specific onconfig variables to review are LTXHWM and LTXEHWM, howvere if you don't have enough logical logs configured to cope with the transaction these parameters will not help and you could end up in a bigger mess such that the transaction will NOt rollback and your server…
12204:RSAM error:Long transaction detected
Yunus, I can't say much without more information, but a couple of points: adding space to rootdbs is almost always undesirable -- that space want to be "lean and mean" since it can be very active and shouldn't have much in it (at least on 9.x series -- I don't have any experienc…
Dynamic Logical Logs
I need to get a clarification on the Dynamic Logical LOgs in IDS 9.4. We having few sites running in IDS 9.4 FC6 on IBM pSeries AIX 5.3 Below are the parameter values which have been set :- # Logical Log Configurationd LOGFILES 6 # Number of logical log files LOGSIZE 2000 # Lo…
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
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…
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:…
Onbar and Storage Manager Backup to different server mpossible?
Robert A. Reissaus wrote: > We have 2 IBM P570 servers, one production one as DR. Both machine run > IDS 9.4.FC6 and are exactly the same EXCEPT for the hostname. DR? What does that mean? (I can guess, but I don't know.) > Policy of the datacenter here we have the production …
RE: long transaction job then aborted with the following error number 458
Are you using a program to do this ? Keep your transactions small - commit regularly. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Muthana.AL-Temimi@tu-harburg.hamburg.de Sent: 24 May 2005 03:09 PM To: infor…
long transaction job then aborted with the following error number 458
Dear IIUG I have a problem and it seems to me the same that I have before when I want load a table with 350000 records but now what I have is a job try to access three tables and write the result in the forth table. The job cannot be continued after ten minutes I got the followi…
HELP ME WITH THE FAQ....Please review
David, I'm qute willing to help with "What exactly is a long transaction" but it needs a complete rewrite. It currently recommends using "onarchive" and I'm not sure if that is still distributed. I don't even know if informix would recommend clearing a long transaction in that …
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…
RE: Logical Logs's
begnadigen Sie mich, Ich verstehe nicht -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bono Vox Sent: 04 May 2005 11:02 PM To: ids@iiug.org Cc: iiug-esp@iiug.org; informix-list@iiug.org Subject: Logical Logs's Co…
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log 27225 - …
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log…
Re: PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
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…
Logs Full
Hi, what is the setting of the ONCONFIG-parameters LTXHWM and LTXEHWM ??? Can you send the output of 'onstat -l' ??? Are there other hanging ontape processes ??? Regards, Andreas Kutsche > -----Ursprüngliche Nachricht----- > Von: forum.subscriber@iiug.org [mailto:forum.subscri…
RE: Logical Logs not full
Brice, What you have described is not quite accurate; The logical log is not backed up the instant the transaction is committed when in unbuffered mode, it is written directly to the logical log as opposed to being stored in the current logical log buffer. Buffered logging us…
RE: Logical Logs not full
Muthana, The logical logs are fine, I wouldn't be dropping and recreating them, there is only one reason I can think of as to why a logical log would not reach 100% and that is onmode -l (force next logical log) this may be for any number of reasons, but typically it would be a…
Logical Logs not full
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50831.81451638 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C50831.81451638" ------_=_NextPart_002_01C50831.81451638 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-E…
Re: Savepoints - Was: Isolation levels in Informix vs Oracle
Mark Townsend wrote: > Serge Rielau wrote: > >> DA Morgan wrote: >> >>> A commit completes the transaction and the savepoints evaporate. >> >> >> Thanks, that makes Oracle and DB2 compatible and SQL Server the odd >> one out. >> >> Cheers >> Serge > > > Well .... expect that Orac…
DB comes down w/ BUFFERS > 350000 ... UR down to 95%
Hello all, Our DB has noticeably gotten slower over the past few months [since Art last gave me a "hey your DB is purring along fine"]. I checked, and our Read Utilization is down around 95%, which is rather low -- the last check I did it was closer to 99.97%. In reviewing the…
Help !! - Logical Logs are full
IDS 9.21 UC4 LINUX RH 7.1 There was a long transaction aborted, an the IDS stuck in an eternal CKPT. The online.log said : "09:51:44 Waiting for Next Logical Log File to be Freed 09:51:44 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix /etc/log_full.sh 3 …
Deleting 100000 rows failed
Amit, I don't think that you mean that you want to prevent it from going to the logical logs. There are ways to do that, but I think that what you really want to do is periodically commit the deletions, so that you don't fill the logs. So my first question is, how are you doing…
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'?…
Ontape/logical logs
Hi all, I'm reasonably new when it comes to Informix, so I hope this isn't an often- asked question. I've set up a disaster recovery server for our main Informix server, to which I automatically send my level 0/level 1 backups and logical logs, as they're written to disk. I've p…
long checkpoints
Hi all, the performance on one of our Customer's production databases has decreased dramatically in the last couple of weeks. Checkpoints seem to be taking over a minute to complete. Running IDS 9.21 UC6 (which I know is no longer supported but unfortunately as it is out there i…
Re: dostats with ANSI logged database?
On Fri, 10 Sep 2004 13:56:14 -0400, Roy Mercer wrote: > Art, > > I did not change anything from your source. I just compiled it straight > from the IIUG. I run this as "informix" but the tables are all owned by > sysadm. The first table it stops on "psdbowner" has an owner o…
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: Informix Tuning Problem
Andy Leung wrote: > My server run very slow for this few weeks.. I've checked the %cache go 99%.. > > Hardware : > IBM - H80 , 4 CPU , 2G Ram , HD x 2 > > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 25899 119543 30538756 99.92 97670 146260 …
Informix Tuning Problem
My server run very slow for this few weeks.. I've checked the %cache go 99%.. Hardware : IBM - H80 , 4 CPU , 2G Ram , HD x 2 dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 25899 119543 30538756 99.92 97670 146260 2077545 95.30 ONCONFIG : - …
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…
ontape -c stop archiving logical log on 9.21UC7
Dear All, I'm using 9.21UC7 on AIX4.3.3ML11, normally "ontape -c" archives logical log when the log is full(the logical log status changes from U---- to U-B---), but sometimes, it stops archiving logical log, even if you use "control+c" to stop it and restart it, it still cann't …
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…
Re: Help with Transaction Log !! Urgent!!!
"Five Cats" <cats_spam@[127.0.0.1]> wrote > It can manage much, much bigger transactions than 100 rows. AFAIK, in SE that is very much dependent on the row size.…
RE: thank you IBM
> -----Original Message----- > From: Madison Pruet [mailto:mpruet@comcast.net] > > > "rkusenet" <rkusenet@sympatico.ca> wrote in message > news:2iu0r7Fr1n5fU1@uni-berlin.de... > > > > "Hamilton, Jerry" <hamiltoj@fleishman.com> wrote \\ > > > > > > DB2 is process based architectur…
RE: Logical logs - how to tell if full?
Notbeen on anysystem admin courses whatsoever - and unlikely to.. Is it safe to back up the logical logs at anytime?…
onbar error message
Hello! I have an Informix backup configured as an onbar + Legato Networker combination with IDS 9.40 UC3 on Solaris 9 machine. We take dbspace backups every night and continously backup logical logs using log_full.sh script. All works well except one thing: if logical logs start …
logical log record failed
Hello all, IDS 9.21 UC4 Solaris 8 We have two systems replicating through HDR. the secondary server which is receiving the logs from the primary server suddenly starting giving this error message " rollforward of log record failed" then it gives the logical log number and the p…
onbar backup logical logs
Hi All, I am using onbar to backup my informix 7.31 databases with Legato networker. I dont want to backup my logical logs. Before using onbar, with ontape, I backed up my logical logs to /dev/null. How can I do that with onbar and Legato networker. Thanks for any help ______…
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.…
Manual commit ODBC transactions?
Hello, When attempting a manual commit, I receive a "Driver not capable" error message. Is it possible to use manual transactions with Informix v9.4 and ODBC driver v3.82 ? I tried the ODBC advanced setup option "Auto commit optimization" both ways with the same result. I am …
Re: Performance advice
Richard Kofler wrote: > > no. > The application has proxies and a transaction manager is part > of what I call app here. >[SNIP ETC] anyway, nfi. I've definitely seen the load imbalance once I went looking for it after Art's postings. This is on machines with a small number of C…
ODBC Transactions
Hello, When attempting a manual commit, I receive a "Driver not capable" error message. Is it possible to use manual transactions with Informix v9.4 ODBC driver v3.82 ? I tried the ODBC advanced setup option "Auto commit optimization" both ways with the same result. I am usin…
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…
AIX logical logging question
My sysadmin wants to know if I can send the logical logs to a rewriteable DVD drive? Seems like new AIX boxes are coming equipped with these devices instead of 8mm tape drives. Anybody doing this currently? -- Phillip…
Physical and logical log placement
It's often recommended that the physical and logical logs be moved from rootdbs. Apart from performance, is there some reason I've missed why they should be kept separate? And does it make any difference if the whole instance is going in a RAID 1+0 array? Andy Kent…
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,…
RE: 9.40 vs 9.21 performance
Eric Rowell wrote > Are you running Solaris? No, Tru64 5.1B as from 2 days earlier ( The management did not want it simple:-)) ES40 2GB, 3 CPU > > What is your ONCONFIG settings? PHYSDBS rootdbs # Location (dbspace) of physlog PHYSFILE 50000 # Ph…
logical logs in 9.40.FC3
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_01C3FA52.A6808A50 Content-Type: text/plain I just went into production this weekend on release 9.40.FC3, AIX 5.2. On my…
onbar script for logical logs
Anyone have a script to perform continuous logging using onbar to filesystems? I would like to write to a separate file on disk daily. Thanks for any help in advance.…
Re: Whatcha' wanta have?????
Keep moving us towards a no-down-time server as much as possible. Such as (some mentioned by others): - Online index build - without locking the table - A dirty read is used to build the index then logical log records are replayed to clean up keys that were added, rolled back, o…
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…
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…
Calculate Logical Log Required
I have read DB Adm reference and some other Informix manuals and cannot find how to calculate the required logical log need for following cases. Can anyone tell me? Just some example :- 1. Say I need to load 1,000,000 rows with record size 100 bytes to DB. How many logical l…
Re: How to trace ODBC connection?
Perhaps onstat -g sql or onstat -g ses may help. At least that will show you the SQL statement that preceded the long transaction rollback. Andy miyaki <lcib@yahoo.com> wrote in message news:<bv245a$f5m$1@terabinaries.xmission.com>... > Hi all, > > Most of our applicatoins were…
RE: How to trace ODBC connection?
Don't you have a way of tracing the tty to a person ? Not sure, but I can trace my internal users on the tty, which gives me there computer names which I can look up. Otherwise you will have to track down the application using onstat -g sql, and then to build some code into your…
Re: How to trace ODBC connection?
Hi Firstly, what type of ODBC connection are you using here. If using the OpenLink ODBC driver for Informix, which is an alternative here to your problem, there are two ways of tracing ODBC calls, either via the Driver Manager trace option which is available via the ODBC Adminis…
How to trace ODBC connection?
Hi all, Most of our applicatoins were developed in Windows/Web platform and they are accessing my database via ODBC type of connection. I found that it's very difficult to trace the problem caused by the ODBC connection, especially from the Web based application. From the output…
Write Logical Logs To Disk
Hi, Greetings, The situation: I am trying to write the logical logs on the first instance to the disk instead of the tape so that I may transfer these to the second instance and use recovery to bring it upto date. I am trying this to implement production backup at the database…
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…
REgarding the Error in Logical Logs
Hi, We are running Informix 9.3 on Sun OS 5.8 . I cannot get my database engine up because of following error : 12:36:39 Results: Log record (OLDRSAM:HDELETE) in log 95507, offset 0xdf352c was not rolled back 12:36:39 Action: Use 'onlog' to view the transaction and repair manua…
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.…
Logical log backup on XPS
Hi All, We have XPS 8.40 installed on HP UX 11i. Ther server was initialised and we were trying to load data into a table . Now the server is in Blocked state and the online.log file mentions that we need to take logical log back. Pls let us know the process for taking logical …
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…
Shared memory problem???
Environment: RH Linux 7.1 Kernel 2.4.10-ac11 Informix IDS 9.21.UC4 Dual x86 Processor 1.5 GB Memory 8 temp dbspaces, 256MB each 100 full time users during the day My Informix shared memory parameters are as follows: LOCKS 2000 # Maximum number of locks BUFFERS 180000 # Maximum …
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?…
Re: Speed up alter-table execution
Here are several options you can test on your test box first and apply accordingly: 1. Turn off logging to the databaes or make the table a raw table. (of course if the table has constraints you will have to drop them to make it a raw table) 2. Set PDQ 100 before running the al…
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.…
RE: IDS 7.3* - Long long long checkpoint !
Most likely you are waiting on a thread in a critical section. Run the following sql against the sysmaster database while one of these long checkpoints is happening. Then use onstat -g ses SID to see what the user is doing. select username,sid,pid,is_incrit from syssessions wh…
Restore certain Logical Logs
Hi guys, restoring a Level-0-archive using ontape -r and after that restoring logical logs using ontape -l works without any problem. Now, I have to restore a database-state, given after certain logical log. Is it possible, to restore a Level-0-archive (which includes the log…
Long Transaction
I am experiencing a long transaction problem when running a stored procedure. The procedure is taking rows from a view, inserting them into a table and then updating them. The table is used for reporting purposes and contains about 60,000 rows in all, but only about 1000 rows ar…
Informix isolation levels
We don't have the same kind of rollback segments which Oracle has .... In order to alleviate your problem, you will have to use the SET LOCK MODE to WAIT <time> ; so that user2 will wait for <time> to test whether the lock is released or not ... HTH Thanx much, Rajib Sarkar Ad…
logical log recovery problem
Hi All, I'm getting the following error when trying to start up a database: 09:57:10 Results: Log record (OLDRSAM:HINSERT) in log 988, offset 0x3ab0098 was not rolled back 09:57:10 Action: Use 'onlog' to view the transaction and repair manually. 09:57:10 stack trace for pid 228…
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…
Applying Logical Logs for a restore ?
I'm an informix newbie. So my question is very basic. After I have backed up the logical logs how is the process of reapplying them to the database to get it current done ? The logs have been backed up using ontape -a Thanks, Jack…
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…
Logical log buffer
Version: IDS 7.30 UC7 Question: We have 3 logical log buffers, 32K each. And databases use buffered logical log (>/dev/null), altogether 8 logical logs. One day users complained they can't do anything and when we ran onstat -u, we found out something like this: ..... e940e864 G…
Re: Logical Logs Size
What about the following : onstat -l (LOGBUFF will be shown here) What log mode on the database (Buffered, Unbuffered, None) Version of IDS O/S running on Are temp tables in use?? Do you have temp dbspaces?? Do you use into temp with no log?? Some of the online log that shows lo…
RE: Logical Logs Size
Fred 30 Gb seems rather large for total log space (in fact almost 19 Gb seems large). What is the size of your database? How quickly are you using the logs? What are your Long transaction limits set to? How often do you hit this long transaction? Can you (should you) split these…
Logical Logs Size
Hi, Well, in order to avoid amongother things several Long transactions aborded, I have decided to increase to size of the logical logs. This is what the actual configuration is : Total Logs Size : 18957068 KB Logs Number : 375 35 Logs of 15000 KB 340 Logs of 50000 KB …
Re: restore logical log
Andrey Mischenko wrote: > How to restore logical > log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a > log If you are asking how to restore logical logs when you have thrown them away using /dev/null, then the answer is; you can't, because they don't ex…
Re: restore logical log
Hello Andrey, If you had been backing up the logical logs to the bit bucket, I'm afraid there's no way you can restore the logs.... The only way is to go to a full Level 0 backup. Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Solutions Ph: 602-217-…
restore logical log
How to restore logical log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a log…
Re: Long Transaction monitoring between LTXHWM & LTXEHWM ???
Hi, Sorry for this question which have been already asked by jphilips@my-deja.com. I did not seach with the right words. Sorry again. Thanks a lot for people who have help me. This is the summary of the answer that you can find at the following URL: http://groups.google.fr/gro…
Long Transaction monitoring between LTXHWM & LTXEHWM ???
Hi, Could someone know a mean which permit to monitor the evolution of a long transaction when it is situated between the LTXHWM & LTXEHWM ? I already know that I can based my monitoring script on the ALARMPROGRAM and the informix trigger 22 and the status of the logical logs. …
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
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???…
Re: How to determine if a remote server is up
Ortiz Manuel wrote: > This is a multi-part message in MIME format. Don't post MIME. One reason I haven't answered before is that I don't like having to undo MIME. > I need to save a transaction in two servers from a 4GL application, I > use the following code: > > Insert into …
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…
XA and WebLogic Server
We are trying to use XA transaction handling in a Informix 7.31.UD5 database, using Weblogic Server 6.1 SP5 as transaction manager. We have tried both JDBC 2.21.JC3 and JC4. The problem that we are running into is that we occasionally get locked rows in the database. A transacti…
Re: long checkpoints
How many disks? Are they on a RAID array? If so what level? Unless you have an exceptionally large number of separate disks or arrays I'd say your value for CLEANERS looks way too high. If you're using JABOD then unless they've radically changed the way these things are handled…
Re: Err 243
> Dear, > I found an err code 243 in my online.log, CPU loading at that time was > around 90%+. does anyone know what the problem is??? and solution??? > here is my config. > > LOCKS 200000 > #BUFFERS 1536000 > BUFFERS 1126400 > NUMAIOVPS 2 > …
ISA slow with logical logs
Hai, When requesting the logical log information via ISA this tool is very slow. Does anybody know a solution? Bickel…
Mysterious Rollback
Hello To All, Recently I have been experiencing rollbacks that are unexplainable. There is no indications that these sessions are exceeding the total locks (3 mil) allocated as well as exceeding the LTXHWM = 50. I have 57 logs configured. This session only exists in 2 logs. Star…
begin work ,lock table, commit work error
Ed; The -256 errors are because you do not have logging enabled for the database in question, so transactions aren't allowed. You are obviously running this from a script, therefore you are getting past the errors. If you were running this from interactive dbaccess, it would fai…
Long transaction problem!!
--0__=85256CFC004A62348f9e8a93df938690918c85256CFC004A6234 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable Hi Luis, I wrote this script some time ago to do what you are requesting. I've enclosed it. You may use it at your own risk. I dis…
Need help, OLTP vs. DSS system
hi! i have one big database(around 500 tbls, 15 tbls foreach over 1 million recs) in one instance which supports many OLTP systems and some DSS systems.The diskIO is extremely busy for some tables which belongs to project AA and resides in one SSA loop. Other tables resides in an…
Cause of long transaction?
Hi, you can see from the message that's written to the message log file (online.log), which session caused the LTX (long transaction). With that Session ID you can do "onstat -g ses <ses id>" or "onstat -g sql <ses id>" to find out, what the session is doing at the time, i.e. wh…
Logging enabling
Hi, We have a legacy system running on a non logged databases. We had a server crash and we ended up losing some vital data after the last checkpoint. {aside, I was glad that happened, bcos only then the management will realize how critical is to log the database :-) }. We have …
Re: Logical-log backup
----- Original Message ----- From: Woi Yew Fong <yfwoi@tpl.com.sg> To: <informix-list@iiug.org> Sent: Tuesday, January 30, 2001 9:40 AM Subject: Logical-log backup > > Hi there, > > I am confused with the automatic logical-log backup (with ontape -a) and > > continues logical-l…
Logical-log backup
> Hi there, > I am confused with the automatic logical-log backup (with ontape -a) and > continues logical-log file backup (with ontape -c). Can somebody clarify > the doubt for me. > > 1. Does automatic logical-log backup mean an operator need to execute the > command ontape -a…
KAIO and HPUX 11.0 with multiple Informix 7.31 instances
Has anyone seen a problem with multiple informix engines on HPUX 11.0? My question is mainly that it appears our main production engine is set to use KAIO and it looks to me like it is configured to use the entire HPUX box (K260-4way with 2.5GB RAM). The onconf.dbname for each …
Stupid DBA tricks
1) Use dbload to automatically break the load file into multiple transactions. 2) Never (on currently released versions) set LTXEHWM above 60.. This probably won't be an issue with 9.3, but I can't talk about that just yet..... Michael Hoffman wrote: > Hi All, > So, I …
dbaccess:load and long transaction
"Pentti Tietäväinen" wrote: > I'm using dbaccess to unload/load tables and like to skip the transaction > handling (read long transaction aborted). > Is there any easy way/command to do this? Don't use DB-Access. DB-Load provides for smaller transactions. So does SQLCMD. And H…
Enterprise Replication log
Enterprise Replication does not have a seperate set of logs. It snoops from the normal logical log file buffers. It only snoops from the log files themselve during recovery or if for some reason it falls behind.…
Re: LTXHWM (70) and LTXEHWM (80)
Richard Savage wrote:- This is a warning and you may never have any problems (related to this message anyway) on your server BUT there are certain circumstances in which you should beware of this message. If any users on your system have a habit of running long transactions (e.g…
LTXHWM (70) and LTXEHWM (80)
Hi everyone, The a portion of contents in online.log read like this when i restart the database from offline to quiescent mode. Fri Dec 1 16:03:31 2000 16:03:31 Event alarms enabled. ALARMPROG = '/disk03/usr/informix/etc/log_full.sh' 16:03:32 Booting Language <c> from modu…
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…
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…
Primary key uses
You can defer constraint checking until the transaction commits. You can filter constraints. This would allow you to have some inconsistancy on the constraint relationship during the course of the transaction as long as the constraint rules were intact when the transaction comm…
Drop the last transaction from logical log
Does any body know how to drop the last transaction from logical log before startup the database instance?…
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 …
Logical Log Files are Full
Is there any way to flush out the contents of the LOgical Log Files through a script or command without manually setting it ? Thanks, Gavin…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Log files full
It sounds like you have a long-running transaction - what are your LTXHWM and LTXEHWM params in your onconfig set to? Logging is used by DDL commands among a few other types of administration tasks, so even a non-logging database will do logging, just not as much. I'd suggest c…
logical logs
Hi all, How to find out which session causing the logical logs to fill up. Regards Aboo…
LONGTX message during engine startup
Not necessarily says the grim faced mja. Informix is a client of a TPM ie something else is co-ordinating the transaction. Now informix's behaviour is defined very explicitly by the Open groups XA transaction standard. Poor old informix does not know how far this thing goes so…
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…
Oninit showed zeor CPU time
Hello, When I do "ps -ef | grep oninit" I got couples "oninit" process run but at lease three on them showed CPU time is zero. I wonder why and how to I find out which oninit does what? Any ideas please let me know would be appreciated. --Wayne ps -ef | grep oninit root …
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…
Re: Logical logs?
Logical logs reside on disks. Logical log buffers reside in memory. If you want to increase the size and number of Logical logs then just add more disk space. Don "Josep M. Marti" wrote: > > Hi all, > I have a problem with the logical log. I need to add more logical logs > be…
Logical logs?
Hi all, I have a problem with the logical log. I need to add more logical logs becouse I can't run any proces, but the logical logs need memory space or disk space? If I put a lot of logical logs I needed add memory or disk? thanks all, -- ------------------------------------…
Re: Rollback transaction
You have to choose if your database will be ANSI compliant or not, regarding the transaction management you want to deal with. If you want an implicit COMMIT after each statement, choose a Non ANSI database and do not use transaction statements. Otherwise, you can manage transa…
Re: long transaction
Hi Daniel, The long transaction is not related to the physical log. It is however related to the Logical Logs. You have several options to resolve this problem: 1. Increase the size and number of the logical logs 2. Turn off logging for the database. 3. Set the LTXHWM to a h…
Re: Long Transaction
Agnes Ng wrote: > Well, if i reduce the LTXHWM, isn't it the Longtrx will occur more > frequent?? That is correct. > Or i should said i need to increase the number of LTXHWM and > LTXEHWM?? Not advisable. Rollback (of a long transaction) also requires log space. You could ru…
Questions about sysprofile in sysmaster?
In Informix << Adminstrator reference>> book, It tells me that the table sysprofile in sysmaster contains columns such as llgrecs,llgpagewrites,llgwrites and it wrote: llgrecs: Logical-log records llgpagewrites: Logical-log writes llgwrites: Logical-log page writes 1.What doe…
Logical logs
Hi All, I have a informix database of 7.30 where in the logical log is getting full very frequently. > What might be the reason. I think the "size" / "physize" of each log is > very less. I am giving below the output of "onstat -l". Is there any > parameters in onconfig tha…
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…
Re: Logical logs
Girish Punjabi wrote: > > HI Vinodh, > > Nothing wrong with more logical logs except that is is inefficient from > an administrative point of view. > Instead of having 120 logical logs of 2MB each you can have 30 logs of > 8MB each.You can also set LTXHWM & LTXEHWM are 80 and 90…
Re: Logical logs
Art, I am planning to keep LTXHWM,LTXEHWM as 50 & 60. I will increase the no. of logs from 80 to 160. We have 2 dbspaces for logs. Do you suggest any sequence to add logs like add log to logdbs1 add log to logdbs2 add log to logdbs1 add log to logdbs2 add log to logdbs1 add log…
RE: Logical logs
Girish Punjabi wrote: > HI Vinodh, > > Nothing wrong with more logical logs except that is is inefficient from > an administrative point of view. > Instead of having 120 logical logs of 2MB each you can have 30 logs of > 8MB each.You can also set LTXHWM & LTXEHWM are 80 and 90 …
Logical logs
In our system, I am noticing Long Transactions being caused sometimes. We have 80 log files, each of size 2048. LTXHWM & LTXEHWM are 50 & 60. I don't want to increase them. I am planning to increase the no. of log files to 120 or to 160. Are there any pros and cons of having more…
Transaction Log
kakkar wrote: > Hi, > > Please let me know how do I perform the following functions. > > 1. How to truncate the Transaction log when it filled up. If you are using the Online Engine, set your onconfig parameter LTAPEDEV to "/dev/null" and restart your engine. This has the effe…
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: Informix shutdown abnormally
do you think the server has not enough logical log to rollback the long transaction and shutdown itself ? the current high water mark setting is 50 % exclusive access 60 % --- Obnoxio The Clown <obnoxio@hotmail.com> wrote: > From: Lee Kwong Hong <kh71@pd.jaring.my> > > > >hey g…
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…
IDS 7.3 - Transaction in Triggered action
Arnaud ANDRIEUX wrote: > Hi All ! > > I am developping on IDS 7.31 TC2 on Windonw NT plateform. > I want to implement a trigger (After Insert FOR EACH ROW) on a table, > wich trigger executes a stored procedure as triggered action. This > stored procedure supports transaction ma…
Re: Memory problems? Please help.
From: "Vincent Kennedy" <vkennedy@torex.co.uk> > >I'm running data conversion routines on SCO UNIX 5.05 using Informix v7. > >They used to be executed during a shell script containing abotu 30 >programs. >However, this was poor for maintenance and distribution so one exe was >com…
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…
XA Interface
Hi, i'm looking for information about the XA interface. Does this database management system support XA and if it does, where is it documented ? I cannot find any information at the website. Thanks in advance Frank P.S. : I'm currently writing a thesis on middleware a…
Long Transactions and table locking
Rudy Fernandes <rferdy@americasm01.nt.com> wrote in message news:38C561B0.98C0910B@americasm01.nt.com... > The "Long Transaction" error can affect transactions that take very little log > space as well (although this rarely happens). Informix marks a transaction as > "Long" when …
question
Try backing up the logical logs with ontape. Nona…
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…
onstat -u shows "blocked: LONGTXN"
PC User wrote: > Tam McLaughlin wrote: > ... > > to "Blocked: LONGTXN". The engine was stuck for 1/2 hr so I called support > > believing that the roll back was not working. Informix suggested killing > > engine and > > bringing online with LTAPEDEV=/dev/null and then set back t…
Managing Transactions in Stored Procedures in Informix
I am writing an application using Visual Basic 5.0 as the front end and Informix as the backend database.I am using the DAO with ODBC direct as the database connectivity library.I would like to know how can I manage transactions in Informix SPL,since my clients guidelines are to …
CLI and locking in transaction problem.
Depending on whether you are using an Informix mode database with transactions (logging mode BUFFERED LOG or UNBUFFERED LOG) or an ANSI mode database with transactions (logging mode ANSI) the default isolation level is either COMMITTED READ or REPEATABLE READ. Both of these mode…
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…
Re: Logical log sizing
"Carlson@WHSmith" wrote: > > "Art S. Kagel" wrote: > > > > If you were not throwing your log files away one issue affecting the choice > > of log size would be the granularity at which you want to be able to archive > > the logs and the number of transactions you are willing to l…
Aborting long transaction
Hi Huy Vu, You have transactions that are overflowing the percentage you specified with the LTXHWM config. parameter of the logs files. For example if you have 10 logfiles of 4 Mb (40Mb in total) and LTXHWM = 50. Then informix will start an rollback if a transaction is started m…
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…
RE: Monitor Informix Longtx
>===== Original Message From Rudy Fernandes <rferdy@americasm01.nt.com> ===== >Did not work for me (7.31uc2, HP10.20). But it was fascinating enough to tinker with. >Modified like below, it worked fine on my instance. > >SELECT > (select cf_effective f > from sysconfig > …
RE: Monitor Informix Longtx
Did not work for me (7.31uc2, HP10.20). But it was fascinating enough to tinker with. Modified like below, it worked fine on my instance. SELECT (select cf_effective f from sysconfig where cf_name = 'LTXHWM') LTXHWM, (( select sum(size) FROM sysl…
Monitor Informix Longtx
I'm trying to find a way how to monitor when a long transaction is almost going to happen on an informix instance. We are using the IDS version 7.24. Can this be done using onstat utilities or via an sql query on the sysmaster database. With an onstat -l you can see the logical …
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…
RE: ontape -c
The only way I can think of is -------------------------- select longtxs, logspused, maxlogsp from sysmaster:syssesprof where sid = <session id> maxlog is the number of logical log in bytes You can try to delete one row and then calculate the total logical log required for bulk…
RE: ontape -c
On the subject of "long transactions": Has anyone got some numbers and figures on the actual size of a logical log entry when deleting a row from a table? I suppose it is a function of the row size. I want to be able to calculate in advance how many rows can be deleted from a ta…
ontape -c
Top Cat wrote: > > We have large logical logs and they don't fill up very quickly. Therefore, > it's not very often that ontape -c backs them up. In fact it's been 24 > hours and we still haven't filled up this one logical log. I guess this > makes me a little nervous, in the …
ontape -c
When using 'ontape -c', for continuos backup of logical logs, what is the proper way to terminate the command? Is it simply a CTRL-C?…
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…
it's strenge to me !! HELP
I try to do the folowing statement : alter fragment on table <tabname> init in <dbsname> after filled 5 logical logs I have a long transaction error. But I have 20 logical logs and my LTXHWM and LTXEHWM environnement variables are equal respectevly to 50 and 60, so I expected tha…
long transaction !!
hi all, I execute the next statement in my online 7.30 under AIX 4.3 : alter fragment on table <tabname> init in <dbspacename> I have 20 logical logs, 625 pages for each. When my transaction felled 5 logical logs it generate a long transaction. my LTXHWM=50 and LTXEHWM=60, so I …
Re: HELP!!!
"Art S. Kagel" wrote: > After that increase LTXHWM and LTXEHWM [...] and shutdown and restart again. Art, didn't you mean DECREASE LTXHWM and LTXEHWM? Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTER…
HELP!!!
The only thing you can do at this point is to call Tech support who will truncate your last logfile to allow room for the checkpoint and archive log records to be written (as well as the engine restart records). Then you will restart and backup the logs and count your stars that…
Long Transaction Detected message
> > Could someone please: > A) explain the difference between a "Long tranaction aborted" & "Long > transaction 'detected' " 'detected' means, that percentage of logical logs, occupied by single transaction equal to or higher than LTXHWM configuration param. 'aborted' means, tha…
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…
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…
logicallogs
Hi there In the IECC database list my databases have the status LOGGING MODE - no. But the logical logs (onstat -l) are in use. Why ??? Thanks…
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.…
Logical logs
Hi Everyone , I am new to the administrative side of Informix Dynamic OL Server and would be gratefull if someone is able to give me a clear answer pertaining to increasing the size of my logical log file. I have tried adjusting the parameters in my confiuration files that did…
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…
Log Files Full
Error message: Logical Log Files are Full -- Backup is Needed Can anyone help me? Thanks in advance, Joao…
Correct use of the X/Open XA-Interface
Hi everybody! We want to do the transactional publish/subscribe in the context of a X/Open XA distributed transaction. We must think of two application scenarios: 1) the UDR's are called through ESQL, in a global distributed transaction context managed by CORBA OTS 2) the UD…
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…
Long Transaction Aborted
In article <7lvlrp$hbo$2@uranium.btinternet.com>, "Bruce Robertson" <br@leith.walk.co.uk> wrote: > But increase it too much and you could have problems. > Onour site we have a high water mark of 40%. So if the transaction uses more > than 40% of logical log space then you get l…
xa_start TMJOIN supported ?
Thanks Mark - some more questions if I may .... You say that there can be locking problems between services in the same txn - is a "service" what is described in the manual as a "branch" ? I'm not clear of the relationship between branches and (global) transactions. Does this …
MQSeries
Has anyone out there successfully integrated Informix DSA 7.2/7.3 with MQSeries? We want to use MQ to manage the XA transaction across the queue and the database. IBM are not helpful! Running on HPUX 10.3 Thanks Mark…
Help with sql error
Simon Leigh wrote in message <7jofv2$kkn$1@neptunium.btinternet.com>... >whenever I fire >INSERT INTO rmtadmin.ISMCAMPCOMMCH (COMMSTATUS, CAMPCODE, COMMCODE, >COMMDATE, customer_id) SELECT 'P' ,'989898', '141414', '06/01/1999', >customer_id FROM sm.HLD22FL WHERE sm.HLD22FL.custom…
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.…
Datenbanken nicht l�schbar
Lieder ich kann meines Anwort nicht auf Deutsch geben, wiel meines Deutsch ist nicht so gut. This is a configuration problem. DDR blocked occured because your value for LTXHWM is too close to LTXEHWM. With ER sites the configuration of the logical log files must be done with c…
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…
Re: ESQL/C - Critical Section?
Jack O'Hara wrote: > Madison, > > Thanks for the info on "critical section". > > However, is it then true to say that one transaction may have left critical > state from an update of one record, that record flushed to disk during a > checkpoint, but then perform another update o…
Re: ESQL/C - Critical Section?
Madison, Thanks for the info on "critical section". However, is it then true to say that one transaction may have left critical state from an update of one record, that record flushed to disk during a checkpoint, but then perform another update of a different record (then say a…
Special Tuning
Bill Weaver schrieb: > > We recently did a complete redesign of a large portion of our database. The time for conversion > from the old to the new is coming soon. Obviously the major part of this conversion, beyond our > applications, is the conversion of the data from one sche…
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…
RE: dbimport - Long Transaction Aborted
When doing a dbimport of a large database (i.e., larger than your logical logs / long-transaction parameters can handle), do NOT set your logging mode on the dbimport command line ("-l" or "-l buffered"). Instead, just let it do the default of unlogged mode for the database. Af…
RE: dbimport - Long Transaction Aborted
The informix configuration has been basically left alone since we set up the system because it is not under a real heavy load. Our main database does not handle transactions so our logical logs do not fill up very quickly hence we never increased their size. I will increase the…
OnLine won't start ...
I got the following error message when I tried to startup our database. Thu Apr 8 19:16:18 1999 19:16:18 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh' 19:16:23 DR: DRAUTO is 0 (Off) 19:16:24 listener-thread: err = -25572: Network driver cannot bind a na…
Minimizing lock usage with $DELETE
>Consider these ESQL/C statement: > >$BEGIN WORK; >$DELETE FROM foo WHERE (a_date < :ctl_jdate) AND (b_date < :ctl_jdate); >$COMMIT WORK; > >Table "foo" has 1.2 million rows. Our DBA has warned me that I may blow >out the available number of locks if I attempt this statement. H…
Create index very slow
This is a multi-part message in MIME format. --------------4CF41BB9DAD092C4AEBBE3C6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi everyone, It's been awhile, but here's my riddle for today: I'm running a create index statement and its been busy …
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…
Re: ZERO Impact Performance Monitor for Informix BETA program
Chuck, Per your question, the following explains the situations under which the Sql Power SniFFFer can or cannot with ZERO required impact - monitor at the SQL transaction level an Informix database server. Please let me know if there are any scenarios I missed. A. The Sql Pow…
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…
Re: long transaction - URGENT
It seems that you try to load more data in one transaction than your logical logs can handle. Here are some hints to solve the problem: - try to increase the amount of logical logs using "onparams -a -d <tablespace> -s <size>" - try to split your data into several files and load…
Logical Log
This is a multi-part message in MIME format. ------=_NextPart_000_0084_01BE5CC0.3EFB85E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear User, I have been trying to get a large file loaded on a database with = transaction loggin…
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…
TRANSACTIONS IN INFORMIX (AGAIN)
Hello, I am developing a db management application in Java, and I am using stored procedures. The system is an Informix Online Dynamic Server 7.2 . I would like to make each execution of an stored procedure a transaction, so, if anything was wrong, I can rollback the updates.…
TRANSACTIONS IN INFORMIX
Hello, I am developing a db management application in Java, and I am using stored procedures. The system is an Informix Online Dynamic Server 7.2 . I would like to make each execution of an stored procedure a transaction, so, if anything was wrong, I can rollback the updates.…
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…
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 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: Req. solve for Lock error
You need to manage the transaction. Count the operations and periodically (by count) commit. If you are getting this in isql or dbaccess, its time to write a program to perform the task.…
How to obtain the value of MaxTXlength?
Hello, I want to calculate the total logical log space I need. I want to use the following formule to calculate this size: nr_informix_session * maxTXlenght * (100 / LTXHWM) my LTXHWM = 50 and I can calculate the number of informix sessions (6 * 5 * nr_baanusers). But how can …
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…
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: Logical Logs Size
I don't know the exact reason,but when you set the size of logical log files to a large amount,you'll get shared memory error but after enlarging your shared memory size this will work properly. --babak >From: "Billy Wheeler" <billy@west.co.za> >To: mary@anasazi.com (Mary Curti…
Re: Logical Logs Size
Hi Mary, If you send me your configuration file and size of your database server RAM,I'd send you a set of tuned combination of kernel and OnLine parameters. --Babak >From: mary@anasazi.com (Mary Curtis) >To: informix-list@iiug.org >Subject: Logical Logs Size >Date: 18 Nov 1998 …
Re: Logical Logs Size
Hi Mary, If you send me your configuration file and size of your database server RAM,I'd send you a set of tuned combination of kernel and OnLine parameters. --Babak >From: mary@anasazi.com (Mary Curtis) >To: informix-list@iiug.org >Subject: Logical Logs Size >Date: 18 Nov 1998 …
Re: Logical Logs Size
Hi Mary, If you send me your configuration file and size of your database server RAM,I'd send you a set of tuned combination of kernel and OnLine parameters. --Babak >From: mary@anasazi.com (Mary Curtis) >To: informix-list@iiug.org >Subject: Logical Logs Size >Date: 18 Nov 1998 …
Re: Logical Logs Size
Hi Mary, It's been a while since we talked. >Our experience has been with running small sized logical logs in our >continuous logging environment in the past (2k to 8k in size). At >approximately 4k size, our application will fill a log on the system >we are discussing in as l…
Re: Logical Logs Size
On 18 Nov 98, at 16:16, Mary Curtis wrote: > Forgive me if my question has been discussed recently or repeatedly. > I haven't been able to read this newsgroup for ages, but would > appreicate your input as I have a limited amount of time to research > my questions. Please respo…
Logical Logs Size
Forgive me if my question has been discussed recently or repeatedly. I haven't been able to read this newsgroup for ages, but would appreicate your input as I have a limited amount of time to research my questions. Please respond via email if possible, thanks for your help .... …
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…
Alter Fragment - LTX
Hi, I did an 'Alter fragment table xyz init in same_dbspace' to compress the table.After the statement ran for some time I got the -458 error , Long Transaction Aborted. I have continuous logging running to a tapedevice.The logs were getting backed up and freed as the statement…
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 …
Roll Forward Logical Log
Hi, Just wondering if I create my temp table 'with no log' option in my stored procedure. Do I have a problem rolling forward my logical log as the temp table will not be logged ?? Thanks JH…
Logical Logs
Hello, just two simple questions: What is a logical log ? Are the logical logs stored on tape automatically with the "ontape -s" command? Best regards Andre…
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…
Re: Best database for web backend on Linux?
--------------6B323E597B88F10B1A436F17 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thor, Its interesting to note what is happening when Oracle is doing row level locking for you. On the server, in your working cache that oracle reserves for your q…
Re: Help with "458: Long transaction aborted."
Setting LTXHWM to a higher value is dangerous to do. It just means that your transaction will continue a while longer before rolling back (and fill up more logical log space) and when it does actually roll back there might not be enough log space to do the roll back and the syste…
Re: Help with "458: Long transaction aborted."
One other possible solution would be to modify LTXHWM to a larger value, but this could cause other problems, and does require a bounce of the engine. Your best bet is to add some logical logs. This would be both the easiest and safest way, without modifying code. -- Regards, R…
Transaction log under SE v5.
What can I get away with with the transaction log under a ANSI database. The log I have is near the max file size for the OS (solaris) can I just close the database, delete the log (or archive it) and open another log. How should I be managing these log files? Any help would be…
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…
JOB OPPORTUNITY,Database Connectivity Product Manager,Compaq Computers,Cupertino,CA.
DATABASE CONNECTIVITY PRODUCT MANAGER The database connectivity product manager is responsible for ensuring that the Tandem Division's database products, NonStop SQL/MP and NonStop SQL/MX, can be effectively accessed by client tools and can interoperate with other database manag…
Re: DS 7.23 performance
Hi Niclas, first, read your Release Notes concerning the SHMBASE settings. You just have about 2000 BUFFERS, that is, 4MB of memory for your cache and about 8MB for the virtual segment. It must be possible to increase your cache. Your complete configuration file looks a bit as …
DS 7.23 performance
We have upgraded from Online 5.06 to Dynamic Server 7.23.FC1 on OSF1 ver 4.0 and have major performance problems. Some applications now are up to 6 times slower. Applications also once in a while receives error -25587 and -25588. I've tried to increase LOCKS and BUFFERS, but th…
Re: LOADING DATA INTO WAREHOUSING
On 3 Sep 98, at 0:59, Tim Schaefer wrote: > BEATRIZ ROCHA wrote: > > > > We have an ASCII file that is currently 4GB that has to be loaded into > > an Informix table. The load command takes about 8 hours. I have added a > > few things to speed up the load such as locking the ta…
Re: Large table with daily batch data load
You should have no problem with the load. Some times it is faster to drop indices, load data, and then re-create the indices if the volumn of loaded data is very large. It sounds like your logical logs are not large enough to handle the load as a single transaction. Check that…
Re: Linux Installation
On Fri, 14 Aug 1998, Nils Myklebust wrote: > On Fri, 14 Aug 1998, Rob Zook <rzook@informix.com> wrote: > >Nils Myklebust wrote: > >> On Fri, 07 Aug 1998, Pieter Huyser <pieter@netsys.co.za> wrote: > >> >I have installed the Informix on a Linux 2.0.0.0 Slackware release. > >> > >…
Logical Logs
Hello List, I have ten logcal log under IDS 7.30 and when I take backup through ontape -a and when I see the status of logical logs using onstat -l the percentage used does not change however I get a backup flage B additional. But Is it not that the %used should become Zero ? …
logical logs
Hi, The L.Logs on my system after a L.log backup normally shows a status of "U_B_ _ _ _" They are backed up as soon as they are full thro' the ALARMPROGRAM. 1) However suddenly some of the logs show a status of "F _ _ _ _ _ _".Though this might mean the same as "U_B____" , Any id…
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 …
LBU_PRESERVE and LTXHWM
Colleagues ! We are using Informix 7.23UC3. Recently I changed LBU_PRESERVE from 0 to 1 to preserve the last log for Logbackup. What I would like to know now is if LTXHWM (50 on our system) now is calculated with (number_of_logfiles - 1) or still with (number_of_logfiles) so th…
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…
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: change logging status U-B to F
Chuanlarp Satchavarodom wrote: > > Dear All, > > I tried to change the status of the log files from U-B to F. I use > onmode -uy as suggested by the manual, but the log files still retain status > of U-B. Is there a way to do this? > Hi Joseph, why do you want to change t…
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…
Shared Memory error when running tbinit -i for first time
I am installing Informix Online 5.07.UC1 for the first time as part of one of our applications and I get the following error when "tbinit -iy" is run from within a script for the first time. Initializing database, please wait... tbinit: fatal error in shared memory initializatio…
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…
Re: (Chkpt Required)
We had this problem with 5.05UCwhateverwehad. It was a bug. Upgrading to 5.07.UC1X2 got rid of it. Does 7.13 possibly have the same type of problem? rc On 18 Jun 98 at 17:11, Nick Nobbe wrote: > > My Online 7.13 occasionally locks up with a (Chkpt Required) message on the >…
(Chkpt Required)
My Online 7.13 occasionally locks up with a (Chkpt Required) message on the onstat - header line. The logs are not full, but the db just sits and waits. I think this can be cleared with a full backup (ontape -s -L 0). Can someone explain this behavior. And - checkpoint interv…
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…
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: +…
Re: Can't free logical logs
In article <6jsjp8$9it$1@news.xmission.com>, Diane Houston <diane.houston@bbc.co.uk> wrote: > > > I am running OnLine 5.01 UDS on HP-UX 9.04. > > I had a problem with all logical logs full due to long transaction. I > was unable to resolve problem by methods from manual and una…
Logical Logs
Hello, When I do a restore using ontape and then rollforward the L.logs . When finished with the Logical logs, the message into the logfile is "Logical Log nnnn Complete" where nnnn is The first log with which the rollforward started and not the last log which was rolled forward.…
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…
Re: How to size the logical log ?
In article <6gdono$8f1$1@news.xmission.com>, Timothy_Lam@crow.bmc.com wrote: > > > Hello Guys, > > Does anybody know how to calculate the size of the logical logs ? > > What does the logical log size based upon ? What are the factors ? > > I want to backup t…
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…
How to size the logical log ?
Hello Guys, Does anybody know how to calculate the size of the logical logs ? What does the logical log size based upon ? What are the factors ? I want to backup the logical logs very often to avoid disaster. How does informix backup logical logs ? …
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: alter table
Sahrul Hidayat wrote: > > Hi, > > I need an advise, i try to alter a table,to put one field, but appear msg > LONG TRANSACTION, and the alter aborted, this table has 252855 rows. > This instance configuration has LOCKS = 30000. The problem is not locks, an ALTER TABLE statement …
Re: alter table
On Wed, 1 Apr 1998, Sahrul Hidayat wrote: > > Hi, > > I need an advise, i try to alter a table,to put one field, but appear msg > LONG TRANSACTION, and the alter aborted, this table has 252855 rows. Altering table needs exclusive lock on the table. If you try to alter the table…
slow performance
Hi I am running ODS 7.23 u4 on HP 10.20 So many users complained about slow performance...I looked at "top".... IDLE has been around 21% %WCPU 36% == (command) oninit %CPU 35% == (command) oninit The partial onconfig info.... NETTYPE ipcshm,1,50,NET # Override sqlh…
Re: What is the best way to backup logical logs ?
Timothy_Lam@crow.bmc.com wrote: > > Hello, > > What is the best way to backup logical logs to remote machine? > Should I kick it off when the logical log becomes full ? > Does anyone has any examples ? > > > What is the recommend size of logical logs ? Ho…
What is the best way to backup logical logs ?
Hello, What is the best way to backup logical logs to remote machine? Should I kick it off when the logical log becomes full ? Does anyone has any examples ? What is the recommend size of logical logs ? How do you calculate ? Rdgs Timothy…
Re: Informix migrated to Solaris box
Hello, Robert Unfortunately, the program didn't show up error code or message on screen. so, operator can not report any error message to identify the problem. I will try to add it on program for examination. I want to say is, same program, same case, Why I can not duplicated the…
TP/XA Informix and Transaction Servers
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
Microsoft Transaction Server & Informix
Hi ! Follwing is a press release from Informix, dated December 10, 1996. It states that Informix will support Microsoft's Transaction Server and that they will develop integrated client-connectivity components for = use with Transaction Server.=20 I'd like to find out if this p…
Re: dbimport - 512MB RAM not enough?
Don Miller wrote: > = > Greetings, all: > = > I've run into a problem using dbimport to re-create a large existing > database in a new dbspace on new disks - although the database unloaded= > using dbexport just fine, every time I try to use dbimport, it complete= s > less tha…
Re: Long transaction
Joe Trubisz wrote: > > I think I have a problem, but I'm not sure. > I did an onstat -g ses and it said 'BLOCKED LONGTX' > I did an onstat -l and have over 50% free log files available. > > 1. Is this a critical problem? > 2. If so, what do I do about it? Check the $ONCONFIG fil…
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.…
INFORMIX DBA - LEARN SAP
Location: Just outside of Boston, MA - No travel required Excellent salaries benefits and bonuses offered to work with a leading Medical products company. Informix Database Administrator Requirements: * 2 - 5 years of experience in large scale data management environment. * Sho…
Re: aborting long transaction
> I am running ODS 7.23 on HP O/S 10.20. A few users have received some error messages. I looked at the log file and then added 14 more logs. But they got the same errors. I checked onstat -l and they were not full. > > What else I should look at? Here is the log file info. > >…
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…
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…
Re: OpenIngres API
Steven Belbin (steven.belbin@consyst-sql.com) wrote: : GODS <gods@sky.net> wrote in article <34A20002.50F0@sky.net>... : > Has anyone done any Visual C++ / OpenIngres API examples besides what : > comes with the demo cd? : > : Yes (by the way some of their examples do not even co…
Re: OpenIngres API
GODS <gods@sky.net> wrote in article <34A20002.50F0@sky.net>... > Has anyone done any Visual C++ / OpenIngres API examples besides what > comes with the demo cd? > Yes (by the way some of their examples do not even compile correctly !!!). The OpenIngres API is handful (as most …
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…
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
logical logs
Hi I am running Online 7.23 on HP 10.20 Why was logical log backed up every 2-3 minutes? Is there any hint not to make that backup too fast? Here is the info... 11:07:08 Logical Log 608 Complete. 11:07:09 Process exited with return code 133: /bin/sh /bin/sh -c /usr/informix/…
Re: High Water Mark Question
kponn@aol.com (KPonn) wrote: :Hi : :Our database was hung recently due to a long transaction. Our LTXHWM = 20 and :LTXHWM = 30 , which are pretty low. I am not sure why the database couldn't :rollback and recover from this long transaction. Anyone has any idea ? : :Thanks. :Keit…
High Water Mark Question
Hi Our database was hung recently due to a long transaction. Our LTXHWM = 20 and LTXHWM = 30 , which are pretty low. I am not sure why the database couldn't rollback and recover from this long transaction. Anyone has any idea ? Thanks. Keith…
Re: Share Mode Locking Problem...
Philippe Verdy <verdy_p@msn.com> wrote: : Whatever the choice, I think that a RDBMS could implement both strategies by : correctly using timestamps and by managing in each transaction if the : modification was applied in the database or not (to know where the original PostgreSQL…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
RE: NewEra 3 Memory leak?
We had the same problem. Fortunately, we have a connection manager class that we can call to connect and disconnect from the database. By doing this, we release the connection and the memory. We tried disconnecting after 3 transactions and found that the average amount of memo…
content management report
ContentWatch is a new analyst report dedicated to exploring the business, creative, and technological issues of managing content. For further information about ContentWatch, visit our Web site at: http://www.contentwatch.com/. The September issue of ContentWatch is now availabl…
Re: Error: -458 Long transaction aborted.
In article <5vkb3l$nvr@jethro.corp.sun.com>, yoga@peacetime.corp.sun.com (Yogesh Patel) writes: > We have ODS 5.0.2 server and we are receiving error# 458 on somewhat > long transaction. During such transcations, I have been monitoring the > log files and only 6-8 out of 16 are…
Re: Error: -458 Long transaction aborted.
In article <5vkb3l$nvr@jethro.Corp.Sun.COM>, yoga@peacetime.corp.sun.com says... > >Hi Folks, > >We really need a help here from you, experienced DBAs. > >We have ODS 5.0.2 server and we are receiving error# 458 on somewhat >long transaction. During such transcations, I have bee…
Re: Error: -458 Long transaction aborted.
In reply to Yogesh Patel's email about Error: -458 Long transaction abo, on 15 Sep 97 Hi Yogesh, > Hi Folks, > > We really need a help here from you, experienced DBAs. > > We have ODS 5.0.2 server and we are receiving error# 458 on somewhat > long transaction. During such …
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: Logical Logs on OWS 7.20 UC2
Hi Ramp! Even in a non-transactional environment, the Logical Logs will be used. The administrative tasks performed by the Informix threads will be using the logical log space, even if you don't any database with LOG. When you set the /dev/null, Informix automatically will set …
Logical Logs on OWS 7.20 UC2
What i don=B4t know is what happen when the logical logs get full in a no= t transactional evironment and with then devicel for logical logs set to /dev/null . I will get a dead lock or the logs get empty when On-Line need more space. -- = Un saludo civil http://www.svalero.es/…
TUXEDO/Informix help!
I am trying to get TUXEDO working with Informix-Online 7.20 on an HPUX V10.0 system. I have successfully built the TUXEDO transaction manager, but need help on the OPENINFO string format. I would like to know also if that are any known problems or things to look out for with thi…
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: begin works and commit works in storeprocs
Jake There are situations where issuing the begin/commit work inside the procedure is acceptable. These situations would most likely occur when you want to process large numbers of rows from different tables and the client app is accessing the db over a network. In this case yo…
Re: Problem setting LTXHWM/LTXEHWM
Also, If you are getting long transactioins with specific programs, it maybe worth reviewing the program logic to see if you can improve the way it is working. Chances are that by doing this you will improve efficiency in a number of areas. Mark MarkDenham@aol.com (home) Denha…
Re: Problem setting LTXHWM/LTXEHWM
These parameters are used by Informix to help prevent transactions from filling all available logical log space. When the LTXHWM value is hit Online will will check for a long transaction. A long transaction is defined as a transaction that spans all unfree logical logs. If onlin…
Problem setting LTXHWM/LTXEHWM
Hi, can someone explain what are the criteria needed attention most when setting for both LTXHWM and LTXEHWM to prevent long transaction in online v5.x ? regards, E-Mail:Tee.Teik.Chuang@bass.com.my…
Re: logical log cannot be freed
In article <5nqpsl$rgg@cssun.mathcs.emory.edu>, Pranadjaja <prana@rad.net.id> writes > >Hello Peter ! > >I don't think that "UB" means free. When Informix stoppped processing, we >backed up all logical log files and then brought it online again. We could >not run our applicaiton …
Re: HELP Shared memory corruption problems
Please note that the the version of Informix DS is 7.20.UC3 The machine has 1 Gig of memory... THe onconfig looks like: ----------------------- # Shared Memory Parameters LOCKS 50000 # Maximum number of locks BUFFERS 25000 # Maximum number…
Re: How to kill a long transaction?
In article <338AF18B.2789@uninet.co.cn>, Marlin <adparks@uninet.co.cn> wrote: >Hi, > I am now using Informix Dynamic OnLine 7.x on a HP-UX server, can you >tell me how I can detect and kill a long transaction? > >Thans you very much! OL usually takes care of the long transactio…
Interrupts on hp-ux 10.
We currently use a C function to ernable us to timeout of input statements. (To avoid long transactions). The function makes a call to an Informix interrupt handler called _sig_int() - Unfortunately under HP-UX 10.01 and Informix 4gl v6.xx this does not seem to exist does anyon…
Interrupts on hp-ux 10.
Andrew the name of the signal handler has changed in V6, I encountered this one too. Unfortunately I cannot remember the new name. I solved the problem you are having for both V4 and V6 versions of 4GL by writing a C function to capture the address of the current signal handlin…
Re: commit from powerbuilder to infromix 7.2
Oscar Goldes wrote: > > Hello, > reading powerbuilder 4 help, I find that autocommit is not supported for = > Informix databases, i.e., it is always set to false. Please be aware that PowerBuilder can only pass the "commit" command to Informix. PowerBuilder itself does not have…
Re: long transaction on NT
Did you try locking the table ? -- Richard Moon http://www.dcs.co.uk Ricky Williams <rwillilams@maxserv.com> wrote in article <01bc5bb5$c31d5960$b4fb4ca6@workstation8>... > Hello, > > > Does anyone know how to handle problems with long transactions on a NT 4.0 > server. > > I a…
long transaction on NT
Hello, Does anyone know how to handle problems with long transactions on a NT 4.0 server. I am trying to delete about 10,000 records from a sql statement. rwilliams@maxserv.com…
Re: Help Loading table from flat file.
Just a guess, but are you running into a long transaction? Check your online log file. The fact that you can break it into pieces and it works amkes this smell like a long transaction. You can use dbload and have it commit after X number of rows as an alternatative solution if t…
Project Manager - Software Licensing - SAP - At Synopsys
Note: If this message is an inappropriate use of your newsgroup, please accept my apologies and delete this message! Great Opportunity At Synopsys! Mountain View Req ID:610-36 Position: Project Manager SAP / Software Licensing And/Or Software / Hardware Systems Job Responsib…
Re: A question about Illustra Database
spaslib@delta.cti.unav.es (Susana Pastor) writes: >My e-mail is >} spaslib@fcom.cti.unav.es >} >} I'm working with Illustra Database for Windows NT. >} When you create a database, what's exactly the meaning of diary_size = >} 4-64Mb? The diary is like a transaction log. >} Ho…
Re: Permenant Recovery
In article <5jhr73$9c6$1@gulfa.kuwait.net>, Rudy Fernandes <rferdy@kuwait.net> writes >In article <01bc4eda$a357ab40$7ec348c2@lyndons>, > "L.Shaw" <lyndons@enterprise.net> wrote: >>I am runing Informix Online 7.13 and today the system came to a stand still >>as the logical logs…
Re: Permenant Recovery
In article <01bc4eda$a357ab40$7ec348c2@lyndons>, "L.Shaw" <lyndons@enterprise.net> wrote: >I am runing Informix Online 7.13 and today the system came to a stand still >as the logical logs passed the declared High Water Mark and the logs >completely filled. > >I made the mistak…
Re: Online 5.03 real slow performance
Thuc Nguyen <thucn@email.utcourts.gov> wrote in article <5j8qq8$m5h@cssun.mathcs.emory.edu>... > I have spent a few days looking at the REAL slow performance problems > and have tried LRU_MAX-DIRTY/LRU_MIN_DIRTY,LTXHWM/LTXEHWM, > and BUFFERS adjustment. Nothing worked. The users …
CLI Transaction Managment
We are attempting to build an CLI/DBapi application for which maintains a connection to Online. We are building a server for which services request from a web site. Some of the incoming requests require access to the ONLINE others do not; our intention is to maintain a poll o…
Re: Shared Memory allocation error
In article <5j3fd5$bt0@cssun.mathcs.emory.edu>, Mark Stannard <mws@appi.ci.in.ameritech.com> writes >All: > >I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. >When I run a query on a view that joins many tables online begins >allocating additional shared mem…
Shared Memory allocation error
All: I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. When I run a query on a view that joins many tables online begins allocating additional shared memory until it hits an illegal address. At this time the query hangs but the engine stays up. If anyone c…
Re: Best Tune for Online 5.02
In article <5hu65h$9mr@cssun.mathcs.emory.edu>, Serafim Fonseca <inf@dpx20.growela.pt> writes >Hello, > >I have an Informix Online 5.02.UC6 installation running on a >RISC6000 with 128MB Ram, with about 30 users. >The production database is about 400MB. >I'm having performance pr…
Re: Why a long transaction cannot rollback?? (2)
In article <01bc4418$a31e3120$LocalHost@madeline>, "Madeline Wu" <madeline@ms1.hinet.net> wrote: > > I test a long transaction in Online 5.0. > Only one user in this Online. That is me. > The long transaction is like this... > > begin work; > update table1 set field1='1'; > upd…
Re: Why a long transaction cannot rollback?? (2)
In article <Ak6nSiAfxqTzEwvk@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <5ii2dl$4ud$1@gulfa.kuwait.net>, Rudy Fernandes ><rferdy@kuwait.net> writes >> >>This is correct,too. On testing, I've found that OL uses Log Ids to >>detect HWM and …
SCO Unix and Informix 7 Performance
Hi all, we are currently running SCO OS 5.0.2 and Informix OL 7.11, the machine is a double Pentium Pro/200 with 512 MB RAM, 4 harddisks with 14 GB (plus duplexed). The system is mainly used as OLTP (80%), our onconfig says: MULTIPROCESSOR 1 NUMCPUVPS 1 LOCKS 300000 BUFFERS …
Re: Why a long transaction cannot rollback?? (2)
In article <5ii2dl$4ud$1@gulfa.kuwait.net>, rferdy@kuwait.net (Rudy Fernandes) wrote: Correction and clarification. > With 6 logs in my test instance, OL invariably >aborted when the transaction moved into the x+4 log. It did not >matter whether the Tx started at 5% of log x…
Re: Why a long transaction cannot rollback?? (2)
}From ilist@rmy.emory.edu Tue Apr 8 23:25 PDT 1997 }From: rferdy@kuwait.net (Rudy Fernandes) }Subject: Re: Why a long transaction cannot rollback?? (2) }Date: Wed, 09 Apr 97 03:54:03 GMT }To: informix-list@rmy.emory.edu }X-Informix-List-Id: <news.36343> } }"Madeline Wu" <madelin…
Re: Why a long transaction cannot rollback?? (2)
In article <01bc4418$a31e3120$LocalHost@madeline>, "Madeline Wu" <madeline@ms1.hinet.net> wrote: >I test a long transaction in Online 5.0. >Only one user in this Online. That is me. >The long transaction is like this... > >begin work; >update table1 set field1='1'; >update tab…
Why a long transaction cannot rollback?? (2)
I test a long transaction in Online 5.0. Only one user in this Online. That is me. The long transaction is like this... begin work; update table1 set field1='1'; update table2 set field2='1'; update table3 set field3='1'; : : : update table50 set field50='1'; commit …
Re: Why long transaction cannot rollback?????
In article <33446552.1397@xnet.com>, "William J. Mitlyng" <wmitlyng@xnet.com> wrote: >I am not sure whether this applies to your version of Informix; however, >I was told in a performance and tuning class that the system will >examine the logical logs after passing the high wa…
Re: Why long transaction cannot rollback?????
I am not sure whether this applies to your version of Informix; however, I was told in a performance and tuning class that the system will examine the logical logs after passing the high water mark and examine the processes active in the current logical log. If one has five logic…
Re: Why long transaction cannot rollback?????
Madeline Wu wrote: > > There are two IBM RS/6000. The model are 370 and 380. > They are all installed Informix On-line 5.0. The dbspaces > are same. Only Share-Memory differ in Max User#. There > are 12 logical logs. Every log is 1,024Kb. In 380, the long > transaction can rollba…
Best Tune for Online 5.02
Hello, I have an Informix Online 5.02.UC6 installation running on a RISC6000 with 128MB Ram, with about 30 users. The production database is about 400MB. I'm having performance problems. Could someone suggest me some tunning tips. The config is as follows: # Root Dbspace Config…
Why long transaction cannot rollback?????
There are two IBM RS/6000. The model are 370 and 380. They are all installed Informix On-line 5.0. The dbspaces are same. Only Share-Memory differ in Max User#. There are 12 logical logs. Every log is 1,024Kb. In 380, the long transaction can rollback. But 370 cannot. Now LTXHWM …
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Er...could you check the LTAPEDEV parameter in tbconfig ? Try /dev/null if not. Cheers Valery Shen Xiaohui <sxh@project-hope.cydf.edu.cn> wrote in article <333C5ABB.37C4@project-hope.cydf.edu.cn>... > Dear Sir, > > Our Informix Online 5.0 server's logical logs got full abnormall…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Thanks for your suggestion. However, we had already set the logical log backup device to /dev/null. In this case, what causes logical log full? Sincerely yours, Xiaohui Shen…
Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Dear Sir, Our Informix Online 5.0 server's logical logs got full abnormally and frequently, the whole system was then stopped and we can do nothing to continue but restore the whole system and data from Level 0 tape!!! At first, we suspected the "inadequate" logical logs. But, w…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Since there is no mention of when you are backing up your logical logs, I think you need to set up a mechanism to do it. Normally, that means running tbtape -a on a terminal (or terminal window) somewhere; it ties up the terminal permanently. Alternatively, if your database isn…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
In article <5hggnq$m84@cssun.mathcs.emory.edu>, Enigma <bipin@sdt.com> writes >it might be a factor of multiple things. since increasing ur >logs or changing the waterwarks is not helping ur cause, i guess > the problem has more to do with the transactions that ur running. Corr…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
it might be a factor of multiple things. since increasing ur logs or changing the waterwarks is not helping ur cause, i guess the problem has more to do with the transactions that ur running. its my guess that ur running transactions involving lotsa data manipulation at the same…
Re: question on logical log
>At the end. You could run into long xact if you are loading a large table. >You might want to increase the LTXHWM and LTXEHWM values before the load, >but be careful about loading too many large tables at once. -------------------------------------------------------------------…
Re: question on logical log
On 13 Mar 1997 07:13:08 -0500, stephane.magnan@eur.autodesk.com ("Stephane Magnan") wrote: > Hi, > > This week-end, we have to load data in a database. > > I would like to know if we will meet a problem with long transaction. > > We want use the sql statment 'loa…
Re: Informix error -346
Hal van den Assem wrote: > > An ESQL/C program, which processes a huge amount of data in one > single transaction, causes the SQL-error Code -346. > > Could someone confirm or explain that the error is caused by > a 'too large' transaction!? > How can I determine the size of a tr…
Re: Powerbuilder-Informix
> > I followed your discussion about Powerbuilder and Informix, > getting a little bit confused. > We are using PB and Informix too. > > We are using PB 4.05 (just migrating to PB5). > The DB-Connection is done by > Intersolv ODBC 2.0x and Informix NET-PC 5.01. I am not sure why…
Re: SAme Aps on 2 Servers, different performance, help!
In article <5chhg1$kje@netnews.csie.nctu.edu.tw>, ccliu <ccliu@maria2.cs ie.nctu.edu.tw> writes > > >Hi Net, > I have a very confusing situation regarding to performance for >two similar Database. > >Server 1: >HP-UX A.09.04 U 9000/887 >INFORMIX-OnLine Version 7.12.UC1X8 >7…
Re: SAme Aps on 2 Servers, different performance, help!
Hi, Looking at the memory of the 2 machines I'm not surprised at the better performance on Server 1. You also have several other configuration differences between the two machines. The NUMAIOVPS is 8 on server 1 and 3 on Server 2. Is this because you have more disks allocated t…
SAme Aps on 2 Servers, different performance, help!
Hi Net, I have a very confusing situation regarding to performance for two similar Database. Server 1: HP-UX A.09.04 U 9000/887 INFORMIX-OnLine Version 7.12.UC1X8 768 MB memory Server 2: HP-UX B.10.01 U 9000/829 INFORMIX-OnLine Version 7.13.UC1 384 MB memory Both have …
Re: How to 'clear' the full log dbspace?
Im Artikel <5c2d6q$iu7@lana.zippo.com>, ibogorad@lhr-sys.dhl.com schreibt: >Concerning setting upt LTXHWM and LTXEHWM mentioned above I should say this >settings >are bloody application specific, I usually recommend to set it to 45 and 47 >respectively >plus make sure you have g…
Re: How to 'clear' the full log dbspace?
Im Artikel <5buu1g$16o@cssun.mathcs.emory.edu>, xiaodong@secom.co.cn ("alex") schreibt: >I'm using Informix Online 5.01 on the SCO 3.2.4. > >Yesterday I executed an big transaction process that exceeded my log >volume, the log was full and everything halted, then I killed the pr…
Re: urgent! *.log question
[ [ using STANDARD ENGINE 4.1 [ [ [ The system that I administer has a directory with two files in with .log [ suffix. [ These are updated when every data is posted. [ These are presumably audit trails (possibly made by third party software [ which was installed and never used). …
Re: Logical Logs problem
This is a multi-part message in MIME format. --------------CF613D91E69 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit odsharma@hclc.hclc-ggn.hcla.com wrote: > > We are developing a project using Informix 5.0 Online and Visual Basic > 4.0. > We are f…
Re: logical logging
Thuc Nguyen <thucn@inconnect.com> wrote: >When I changed to /dev/null on the primary drive from /dev/ifmx/1m and >then turned off the B logging, then I ran the sql script after long >transaction aborted. Once the script was done, I turned the logging back >on and changed to /dev…
logical logging
Hi I have a question to ask. I am on HP 9.0 O/X with online 5.12 When I changed to /dev/null on the primary drive from /dev/ifmx/1m and then turned off the B logging, then I ran the sql script after long transaction aborted. Once the script was done, I turned the logging back …
Solutions/Customer Cons./DW/major vendor-most regions
Customer/Solutions Consultants - Data Warehousing My client is a leading provider of relational database systems. They have a broad-based offering in both the transaction and warehousing sectors and are currently seeking to expand their Solutions Consulting organ…
Re: Oracle vs Informix comparison
While both methods will work, there are distinct advantages of using log based/async replication over triggers. If we are using trigger based replication and are in a transaction, then the transaction must suffer the time-lag of the replication being processed on the remote mach…
Solutions-Customer Consultant/DW/major vendor/most regions
Customer/Solutions Consultants - Data Warehousing My client is a leading provider of relational database systems. They have a broad-based offering in both the transaction and warehousing sectors and are currently seeking to expand their Solutions Consulting organ…
Solutions Consultants/major vendor/most regions
Customer/Solutions Consultants - Data Warehousing My client is a leading provider of relational database systems. They have a broad-based offering in both the transaction and warehousing sectors and are currently seeking to expand their Solutions Consulting org…
Re: Logical consistency of archive
Dear Neil, Along with the archive of the data, Online also makes a copy of the logical logs which contain current/open transactions. It also takes the copy of the pages from the physical log into the backup tape. It uses this to rollback the transactions on restore. Regards, D…
Re: Why does 5.04 lock up when logs fill?
In reply to tom dorgan's email about Why does 5.04 lock up when logs fil, on 3 Oct 96 Hi Tom, > I guess the subject says it all. the server just quits and you have to > restore the database? This is what our admin people are doing, anyway > and its a 6 hour process and all you…
Re: Why does 5.04 lock up when logs fill?
tom dorgan wrote: > > I guess the subject says it all. the server just quits and you have to > restore the database? This is what our admin people are doing, anyway > and its a 6 hour process and all you get is what you had on your last > backup. Doesnt seem like the last word in…
DBA'S
APG-USA An Open Systems and Client Server Integrator with offices in the US and Canada, has permanent employment and/or subcontracting opportunities for DB2/6000 database professionals at multiple client sites. Experience in any of the following: DBA, Data Modeller, DDCS…
Re: Turn Transactions on?
Darin Strait wrote: > > The situation: > I'm on a short-term job at a site where there is no Informix guru. I'm > an Oracle guy modifying lots of someone else's Informix 4GL code. I have . . . > The questions: > Why would I not want to turn on the transaction log? (I assume that …
full transactional WEB access to Informix with SQL~Surfer
The middleware SQL~Surfer is a generic gateway between WEB and RDBMS (native access to DB2, Informix, Oracle, SQL Server, Sybase - ODBC access to others) on Unix and NT to any WEB browser and via any Internet Server. It transparently supports HTML 2, HTML 3, JAVA, Javascript, VRM…
Software Project Manager
PROJECT MANAGER - IMAGING SOFTWARE PRODUCT We need an experienced project MANAGER with very strong technical credentials to lead a project involving the productization of a key new imaging product. The position requires experience in managing high-level programmers and all othe…
Re: How to handle deadlocks ?
bgw@world.std.com (Bruce G Wilson) wrote: > there were occasions where they had problems with deadlock: two > processes trying to allocate two resources in opposite order. > It struck me that part of the reason why this is such a problem > is that locks are taken (and escalated…
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…
Re: Logical Logs
Dave writes: > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with …
Re: Log files in Online 5.x
cheryl, > Why so much log space? Recommendation is for physical and logical log is > 20% of your total configuration disk space. With a 3:1 ratio between the > logical and physical log space. If this is not correct (or if many of you > have found not to work), plese let me know.…
Re: Log files in Online 5.x
> Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with very small log…
Re: to many logical logs: cannot restart database
Fred Bon <fred@toplog.fr> wrote: >-- >on informix online v5.05.uc2, >when I try to restart the database in quiescent mode, the database is in >recovery mode and stop. It seems there is too many logical logs. >Previously, a process has last very long and was killed (kill -9) >How…
Re: Newbee with questions about physical and logical log allocations.
The method I use for calculating Physical Log sizes is to estimate the number of transactions in 5 minutes (CKPTINVL) and then calculate how many rows these will affect. That number of rows is the number of pages changed in 5 minutes. Multiply that nunber by 1.33 to get the phy…
Re: Logging on rollback?
> I have question on logging during a rollback and aborted > long transaction. My understanding was that activity > during a transaction is written to a logical log and if that > transaction is rollbacked, the rollback is also logged. > > Thus, if you have a transaction involvin…
Re: Problem with Temp Tables and Logging
Malcolm Weallans (onlinedbc@cix.compulink.co.uk) wrote: : By my calculation you would hit a long transaction if the query took : longer than 2.5 minutes. I would certainly suggest that you should have : bigger logs. If they fill that fast you are probably spending a great : per…
Re: Problem with Temp Tables and Logging
By my calculation you would hit a long transaction if the query took longer than 2.5 minutes. I would certainly suggest that you should have bigger logs. If they fill that fast you are probably spending a great percentage of your time handling log changeover. After all, doesn'…
Problem with Temp Tables and Logging
Mark, Aborting of long transactions occurs when the logs become full to the limit specified in you onconfig file ( or whatever you are using ) There are two solutions to this problem: Increase the size and/or amount of logs available Increase the High or Low water marks in yo…
data warehousing discussion
William Inmon introduced the phrase "data warehouse" in 1990. He defined it as a managed database in which the data is: * subject-oriented * integrated * time-variant * nonvolatile This last characteristic of the DW defined by Inmon cannot always be applied; the DW isn't com…
Using XA with Informix 7.1 ??
Are you using Informix 7.1 with a TP monitor, via XA ?? If so, I'd like to hear from you. We have developed an OLTP application, using Tuxedo and Informix 7.1. Current design includes the use of XA, to allow Tuxedo to manage transactions. However, in some of our testing, we are …
Re: Table modification transaction size problem
Rob seems to think I was making a sales pitch. That is not the case. I was merely trying to avoid posting a very long explanation which I would have made available on a one-to-one basis to the individual concerned. I also note that Rob's answer merely avoids the problem and do…
Re: RDBMS Performance figures. - please post replies
> > Well - title says it all. > > /Jacob > > Good luck. Consider, each RDBMS is going to perform differently according to what platform it is run on, the qualifications of the person settingup the environment for the test, the amount of data, how the platform is configured, yad…
Re: Transactions and Record Locking Help Needed
> We understand that if we use transactions and "commit" a detail line, we > will > lose ALL locks, including the header lock, which would then allow other > users at data which we do not want them to get at while its being > updated. Yes, a commit frees all locks. You would hav…
Re: Long-running queries
olea@hal.nta.no (Ole J. Anfindsen) wrote: >In article <3uk28e$ccg@lennon.cc.gatech.edu>, gukal@cc.gatech.edu (Sreenivas Gukal) writes: >|> Hi Folks >|> Part of my Ph.D. thesis deals with efficiently supporting long-running >|> queries (maybe Decision Support System queries) with…
Re: Which Unix DBMS?
I feel it is important to choose a software application if you can. This will lead you to the DBMS. What are your needs? Why do you need a DBMS and what will you use it for? What are your transaction processing requirements? How big will the database be? my opinion: progre…
Distributed database
Hello everybody. I've got a problem with data distribution - distributed database - over network. We've got a "star network". Each site is connected with central site. The problem is that the connection is via magnetic tape. Could You advice me how to manage transaction executio…
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?…
Re: Long transaction
I was being silly - I was thinking it was the percentage of the last log file not a %age of the whole logical log space. -- Tony McCartan Tony Mc (UK)…
Re: HELP: Long (lasting) transactions?
> >: Informix? Is there anyone who may wish to caution us on >: any potential problems that such long lasting >: transcations would present. I for one, thought that >: there could be problems with tranaction log files. > >It's a bad way to design an application if you want portab…
Re: What happens if logical logs are full
> ber@knapp.knapp.at (Erwin Burgstaller) wrote: > > >Maybe a former question was to complex. Now I'm asking only: > > >Is it possible to recover from full logical logs, with almost no loss of > >data? > > Hi Erwin, > > It depends on whether the logs were filled due to a long tran…
Re: HELP: Long (lasting) transactions?
paul sellars (paul@boothbc.demon.co.uk) wrote: ( referring to the way Informix OnLine is implemented:) : The log file containing the start of transaction (and following log files) : cannot be archived until the transaction has ended. If, after the start This is not true. It c…
Re: HELP: Long (lasting) transactions?
> In article <3makt8$sv@hustle.rahul.net> billb@lore.kla.com "Bill > > Baloglu" writes: > > > We are designing a C++ application which will initially > > run on ORACLE (and subsequently may run on Sybase and > > Informix). In this application, there will be scenarios > > under wh…
Re: HELP: Long (lasting) transactions?
In article <3makt8$sv@hustle.rahul.net> billb@lore.kla.com "Bill Baloglu" writes: > We are designing a C++ application which will initially > run on ORACLE (and subsequently may run on Sybase and > Informix). In this application, there will be scenarios > under which a database …
Re: HELP: Long (lasting) transactions?
In article <3makt8$sv@hustle.rahul.net> billb@lore.kla.com "Bill Baloglu" writes: > ... there will be scenarios > under which a database transaction may be open for a few > days ... This would certainly cause problems with the database product we use (ADABAS), where there are t…
Error -457 upon Execution of SQL Statement
I sent the following article to c.d.i on March 29.Since I didn�t get any articles at all from c.d.i. during the next days I was informed that the news provider server suffered a disk crash.As I suspect that my article didn�t reach c.d.i at all I post it again.If someone has sugge…
Re: Does Informix do Versioning Read-Only Transactions?
Tony Rothwell (Tony@santen.demon.co.uk) wrote: : In article: <3l9l2j$7bm@sword.eng.pyramid.com> graeme@pyramid.com (Graeme : Sargent) writes: : > : > The Server Concepts Manual also conveniently (but I suppose justifiably) : > omits to mention the impact of Discrete Transactions…
Re: Does Informix do Versioning Read-Only Transactions?
In article: <3l9l2j$7bm@sword.eng.pyramid.com> graeme@pyramid.com (Graeme Sargent) writes: > > The Server Concepts Manual also conveniently (but I suppose justifiably) > omits to mention the impact of Discrete Transactions or "Snapshot too > old" errors on the Read Consistency m…
Re: Which DB? PAradox, Access, other?
In <3io5i0$erk@news-s01.ny.us.ibm.net>, jsikora@ibm.net writes: >I'd take a quick look at Access with some of the add-on products. >There were several vendors producing trouble ticket like databases applications >for not a lot of money <$150. No need to write on. If you really be…
Re: Phantom Inserts
In article <pwongD4C773.F15@netcom.com>, pwong@netcom.com (Philip S. Wong) writes... . . . > >It seems to me that complete phantom protection would prevent concurrent >inserts in any table that is read by a transaction. Any thoughts? >How do different databases handle this? Thi…
Re: Miagrating Data from SE to ONline Engine
Ruchi Patel (.Ruchi_Patel@avid.avid.com) wrote: : I am miagrating Data From SE to Online Engine. I am going to use : DBEXPORT and DBIMPORT to do this eventually. Right now, I am using : Unload and Load statement to load tables into Online. Some of these : tables are very large an…
Re: Miagrating Data from SE to ONline Engine
> > I am miagrating Data From SE to Online Engine. I am going to use > DBEXPORT and DBIMPORT to do this eventually. Right now, I am using > Unload and Load statement to load tables into Online. Some of these > tables are very large and I got a message "Long Transactions". The > d…
Miagrating Data from SE to ONline Engine
I am miagrating Data From SE to Online Engine. I am going to use DBEXPORT and DBIMPORT to do this eventually. Right now, I am using Unload and Load statement to load tables into Online. Some of these tables are very large and I got a message "Long Transactions". The databases use…
Informix Perf Question
I have setup an informix database on a Sparc10. 5.00.UC3. The configuration is generally the same as other servers I have but it runs different applications. I have noticed that this server generally has 0% - 30% cache reads and 80% - 95% cache writes. On the other servers th…
Re: update question
In article <3d7ruh$8fk@emory.mathcs.emory.edu> inf_bb@hermes1.sps.mot.com "Bob Baskett" writes: > netters, > > given that you have two tables that are defined exactly that same, > table1 and table2. where table1 has 5 million rows and table2 has > 50000 rows of data. …
Database engines, Transaction Processing, and Licensing
We have a large transaction processing environment, similar to Top End, Tuxedo or Encina (but homegrown), which funnels a large number of end users into a small number of worker processes. We use Informix OnLine to run the database underlying the whole scheme. In previous versio…
Re: Informix 4gl
mdl@world.std.com (Michael D Lemon) writes: >I'm interested in perspectives on using transactions with a data entry/ >inquiry screen, and more specifically with the detail sections. >What is the best granularity to use? Start and begin before and after >each row? Before and a…
Transaction Management on Server
We're having a problem with the Informix database when a client terminates the connection in the middle of a transaction. Here is the scenario: User updates a grid control with 50 new items Client starts transaction and begins to loop through the 50 updates After about 30 se…
Physical Log and Logical Log
Hi Folks, I found some case at my friend's site. His Physical Log and Logical Log setting is : Physical Log size = 2000 Kbytes Logical Log size = 10000 Kbytes No. of Logical Log = 10 When he run daily 4GL-application with 70-80 users simultano…
Announcing ENCTALK (Encina)
Posting this for a friend --------------------------------- enctalk@imc.com Encina Transaction Processing Discussion An unmoderated discussion of transaction processing topics relating to the Encina transaction processing system. Discussions include client/ server architectu…
Announcing TE-TALK (Top-End)
Posting this for a friend: ------------------------------------------------ An unmoderated discussion of transaction processing topics relating to the Top End transaction processing system. Discussions include client/ server architecture, Distributed transaction processing, X/O…
Re: FAQ
johnl@informix.com (Jonathan Leffler) wrote: >With a reasonable log configuration (say more than 4 logs), the 70/80 limit >is very unlikely to run you into trouble. Unless you are mass inserting or >deleting extremely small records (say 1-8 bytes, though I'm tempted to >suggest …
Re: FAQ
>Date: Thu, 28 Jul 1994 15:16:11 -0500 >From: cwakins@jabba.rmc.com (Clem W. Akins) >Subject: FAQ >X-Informix-List-Id: <list.4420> > >Regarding the FAQ, here are some criticisms and comments: > >In 6.1, Configuring OnLine: >default Transaction high-water marks -- Should be less t…
FAQ
Regarding the FAQ, here are some criticisms and comments: In 6.1, Configuring OnLine: default Transaction high-water marks -- Should be less than 50%, to allow a roll-back. Have enough logs that whatever number you choose is enough for your largest long transaction. 70/80 is…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server architec…
Announcing Tuxedo Discussion Maillist Server
Announcing TUXTALK, TUXEDO Transaction Processing Discussion Mail List This is a moderated discussion of transaction processing topics relating to the TUXEDO transaction processing system and associated connectivity/productivity tools. Discussions include client/server arch…
Long Transaction with Logging OFF ???
We have a database with logging turned off (read-only system). In an ESQL-C program, we are executing a very large open cursor statement (reading 10's of millions of rows and returning 10's of thousands). When we execute the program we get a -458 (long transaction cancelled)…
Re: Two simple questions
>From: charliep@earlham.edu >Subject: Two simple questions >Date: Fri, 13 May 94 10:02:55 -500 >X-Informix-List-Id: <news.6728> > >Two questions from a neophyte: 2? I make it 5. >1. Does Informix support an API to SE and/or OnLine? I am looking for > something like Oracle…
Two simple questions
Two questions from a neophyte: Does Informix support an API to SE and/or OnLine? I am looking for something like Oracle's OCI or Sybase's DB-LIB rather than the pre-compiled ESQL. How is the concept of "user" handled in OnLine? When I looked at the ESQL demo programs there is…
Logical Logs
>Sender: news@srgenprp.sr.hp.com (News Administrator) > > We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. > Our tbconfig said LOGFILES 6 >>>>stuff deleted > LOGSIZE 500 > My question is: Is there an optimum balance between LOGFIL…
Re: Online Engine vs Standard
Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: > Addendum (should this go an our non-existant FAQ?): I nominate you as Editor-in-Chief Jack! > 4. Lower the default Transaction high water marks from: [ . . . ] > to: > LTXHWM 70 # Long TX high-water…
Online Engine vs Standard
> > Hi! > > -> ONLINE IS A COMPLETELY DIFFERENT ANIMAL FROM SE. It requires much > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > This is not an idle statement. One of the most common problems I've > experienced is that transaction logging becomes a major issue. If you > *d…
Experience with INFORMIX - C-ISAM
I am looking for anybody's experience with INFORMIX - C-ISAM product. We are currently using Raima Data Manager (dbVista) but db management tools it comes with have many shortcomings. I would like to know the following about the C-ISAM product: Performance record/file l…
Re: Why this Long Transaction?
Ken Miles (kenm@vcd.hp.com) wrote: : Joe Lumbley (jlumbley@netcom.com) wrote: : > Folks, Deleted my blah.blah, blah.... : I'm following up two days after the original post and hope you are not : still in "fast recovery" but these symptoms bear a very strong resemblance : to a d…
Re: Why this Long Transaction?
Joe Lumbley (jlumbley@netcom.com) wrote: > Folks, > Twelve hours ago my large database was shut down ungracefully, with > a monster insert operation going on. About 2 million rows in the table, > but I don't know how many were actually inserted. On restart, we went into > that …
Problems converting from S.E. to On-Line
Hello, We have recently moved our 4GL application from an AT&T 6386 running S.E. to an IBM RS/6000 370 using On-Line. We are having problems with key locks and long transactions which remain therefore locking users out from updating those records. The code seemed to work prop…
Re: Acess to "OTHER" Databases from Informix-4GL
Robert Tudor (rjtqiaa@werple.apana.org.au) wrote: : I have a requirment to access other database types i.e. Oracle, Ingres, : Progress and Sybase etc. from an existing base of Informix 4-GL programs. I had the same problem some time ago, and queried this newsgroup about it. I wa…
Re: Infinite Recovery Help Needed (Online 5.0)
From article <1993Jul23.154202.17436@informix.com>, by davek@newjersey.informix.com (Dave Kosenko): > > andrew.shaw writes: > |> Another suggestion was to lower the high-water parameters by 10 from > |> the current default values. However, it appears that this also does not > |>…
Re: Infinite Recovery Help Needed (Online 5.0)
andrew.shaw writes: |> Another suggestion was to lower the high-water parameters by 10 from |> the current default values. However, it appears that this also does not |> solve the general case; if the offending transaction spans too long a |> period, the logs can fill with other…
Re: Infinite Recovery Help Needed (Online 5.0)
From article <226qq6INNs28@emory.mathcs.emory.edu>, by inf_bb@hermes1.sps.mot.com (informix users bb): >>> This is a problem which we've experienced on out project several >>> times. Informix technical support can abort your long transaction >>> by logging into your system and r…
Audit Trails and Transaction Logs
I would like to produce an audit trail that will tell me which user modified which tables and what they did. I woulds also like to be able to rollback a transaction done by a given user. Would someone care to comment on the audit and transaction roll back capabilities of Inform…
Re: System Deadlock
Graeme Sargent writes: [Regarding LTX rollback filling up the logical logs ] |> |> To reduce the probabibility of this occurence, reduce the LTXEHWM |> parameter (5.0) or increase the granularity of your Logical Log files |> (4.x). I believe it would be clearer to say "increase …
Re: ESQL/C transaction
In-Reply-To: <1rgqc7INN72m@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) > I have multiple libraries of ESQL-C functions. A lot of them call one > another. Some functions also have begin/rollback/commit transactions. > Problem I face is before s…
Re: Problem with long transactions
Brad, yes, increasing the number of logs will help the problem. also, tuning the transaction high/low water marks and the exclusive transaction high/low water marks will help as well. the reason for the logs filling when aborting a long transaction it that informix logs the ro…
Re: Problem with long transactions
In article <1993Jan13.211431.61948@evolving.com> bpk@evolving.com (Brad Knotwell) writes: > >We currently are having a problem with "aborting long transactions." When >this occurs our logical logs (we have 6 @ 500 pages/log) fill up and tbtape >(running continuously) is unable t…
Carl Wuebkers 'recovery' problem.
Folks, After perusing the responses to Carl's problem I realized that no-one has come up with this answer, so here it is. We had this problem over and over again and started re-creating it on purpose to devise a solution. The solution wound up being to lower the high water mar…
Informix & Tuxedo
>From: Apostolos Dedes <uunet!ge!dedes!dedes> >Subject: Informix & Tuxedo >Date: Thu, 7 Jan 93 17:36:52 EST >Organization: GE Information Services >Help! >I need to get the 2-phase commit to work using Informix as the Database >Manager & Tuxedo as the Transaction manager. If som…
Re: Recovery
In article <1inm5vINN3gm@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) writes: >Welcome to the world of STUCK FAST RECOVERY ... >I have faced this problem on more than one occassion and I have been asked to >wait for version 5.0 where HIGHT_WATER…
Re: Informix & Tuxedo
Apostolos Dedes writes: >Help! >I need to get the 2-phase commit to work using Informix as the Database >Manager & Tuxedo as the Transaction manager. If someone on the net has >already done this I would appreciate a phone call or a personal message >for a couple of questions that…
Informix & Tuxedo
Help! I need to get the 2-phase commit to work using Informix as the Database Manager & Tuxedo as the Transaction manager. If someone on the net has already done this I would appreciate a phone call or a personal message for a couple of questions that I have. Thanx, -Toly uunet!…
Transactions
We're running Informix Turbo 3.5 here and we discovered a process that leaves an open transaction for an extreemly long time. (It's a Print Job manager that sleeps when there's nothing to do.) The question is: Are there any know side effects of the open transaction even if no…
Backing up physical files
Is it necessary to back up the physical files associated with an ONLINE db "outside of the environment"? Consider "raw partitions" as well. I always thought that backup of physical files was a necessity to prevent against disk failure - that you would restore your old files and…
Re: Stored Procedures, Views,
> My idea was that if Stored Procedures could be used as part of the > Create view statement in place of the select statement and the Stored > Procedures had some way of knowing whether an Insert, Delete, Update > or Select function had been used. Using this method much of our D…
Re: Report Writers, Stored Procedures, etc
> My idea was that if Stored Procedures could be used as part of the > Create view statement in place of the select statement and the Stored > Procedures had some way of knowing whether an Insert, Delete, Update > or Select function had been used. Using this method much of our D…
Backing up OE db files
Is it necessary to back up the physical files associated with an ONLINE db "outside of the environment"? Consider "raw partitions" as well. I always thought that backup of physical files was a necessity to prevent against disk failure - that you would restore your old files and…
INFORMIX online backup questions
I am currently doing a survey of online database techniques in use by major database management systems. Can anyone tell me what facilities INFORMIX has for making a backup of a database while updates are still being applied to the database and what technique does it use to d…
logical logs
I am running informix-online 4.00.UH2 on a Pyramid MIS-12/05 (OSx 5.1a). Part of the output from 'tbstat -l' is listed below: address number flags uniqid begin size used %used e0068944 1 U---C-L 5 100d64 250 66 26.40 e0068960 …
Re: NASA/Need Opinions On Informix
In article <1992Apr1.004053.1917@donner.SanDiego.NCR.COM> rayn@otl.SanDiego.NCR.COM (Ray Nieto) writes: > >rich@convergent.com writes: > >> >>barrydm@dryden.dfrf.nasa.gov (Mark Barry) writes: >> >>>We are going to be transferring some telecommunications data base software >>[text…
Re: Informix 5.0 features
> To use Informix TP/XA, you also need to have an XA-compliant > transaction manager (plug warning: such as Transarc's Encina product). ... (counter plug warning) or USL's Tuxedo /T product.…
Introduction of the Server's 5.0 manual set called "New Features."
Excerpts from mail: 10-Feb-92 Introduction of the Server'.. William Daul@uunet.UU.NE (3974) > Two-phase commit (INFORMIXSTAR only). The new two-phase commit > protocol allows you to manipulate data in multiple databases on > multiple OnLine database servers within a single trans…
Re: index files corrupt after file system full
Wim writes in Informix-List-Id: <list.418> >We are running out of disk-space now and then. >When someone is updating his database on the moment >the file-system is full, sometimes indexes on tables are >corrupted. >I would like to know if this is a normal behavior. >If not, how…
SE + machine crash
Greg Bryan (gbryan@ssf-sys.dhl.com) writes: > More sophisticated relational database managers ( such as Informix > Online - but NOT Informix Standard Engine ) guarantee that logical > groups of physical disk operations are handled in an all or nothing > fashion. This is do…