Oninit® Archive
Results for “LTXEHWM”
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
Those are very small logs and not very many of them. It could be that other stuff is running, writing to the small amount of log space during the time it takes to add the new chunk. Basically, you are going to need to add more logical logs. I see that these logs are in the root …
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
If I'm getting this right, onmode -Z is meant for I-Star 2-phase-commit distributed transactions, whereas onmode -H is for XA global transactions. The later (XA transactions) typically are not owned by Informix and should be taken care of by the XA transaction manager that initia…
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
There is no formula. But note that by changing the parameter to a lower value you will probably get more long transactions (or sooner). It will not solve the issue where the logs are not enough for the DDL changes you're doing. The good thing is that by lowering LTXHWM and creati…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
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…
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.…
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.…
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?…
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…
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.…
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_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
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
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
Hi, when long transaction being rollback, could others execute SQL select that don't write logical log? thanks.…
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…
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 …
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 -…
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…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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.…
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…
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)…
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 …
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 …
long transaction, onstat -l, flag A----
mohitanchlia@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 to big tables. But even after that we gotlongtransaction. >>> When I l…
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…
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 …
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: 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.…
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…
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…
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 …
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…
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: 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: 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,…
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: 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…
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…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
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…
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???…
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: 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…
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!!
Hi, I think you can't. At least not really. The problem is, that a transaction is detected as being long when the log files become "pretty full". This in turn depends on your setting of $ONCONFIG file parameters LTXHWM and LTXEHWM. Now the filling of logs is usually not only du…
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…
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 …
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…
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…
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…
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…
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…
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…
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 …
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
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…
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…
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…
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…
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…
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…
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…
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.…
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: 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…
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…
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 …
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…
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: 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…
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: 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…
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: 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…
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 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: 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: 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…
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: 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: 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…
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?????
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…
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!!!
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…
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: 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 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…
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…
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.…
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: 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: 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…
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 …
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…
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?
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 …
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…
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
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…
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…
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…