Oninit® Archive
Results for “LOG_STAGING_DIR”
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…
Technological Differences between HDR & RSS
You might want to try RSS with log staging / delayed apply of 1 second. With 11.70 we implemented the ability to pre-load pages on the primary which means that the impact is much less - on the order of 10 times faster. From: "SHAHZAD SALAM KASI" <skasi@i2cinc.com> To: ids@iiug…
Error in COMMIT WORK when trying to add a chunk
@Jacob, I may be misremembering, or maybe things have changed in recent versions of Informix, but in general, it is better to have several smaller logical logs than a few (or a single) large ones. This is because the LTXHWM and LTXEHWM percentages are based not on the percentage…
Oninit engine won't start: log staging directory is not secure
Hi Y'all. Interesting (i.e.. frustrating as all blazes) problem I have trying to start up on a bug-fix copy of oninit. I start up oninit and it dies right away with the error message: Secondary Delay or Stop Apply: The log staging directory (/usr/informix/< subdir >log_staging_di…
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 ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
You also need to indicate which Informix version you're using. In addition to the obvious resource differences Art has highlighted, significant changes to the communication and other H/A cluster technologies occurred in v.14. Off the top of my head, I can't remember the exact fix…
Odd restore failure
Andreas: Thanks for expending brain power on this for me. Yea, onstat -g arc shows what's expected, the last onbar level 0 and level 1 archives which were both full server archives. Also, as you note, both my ontape archive and ifxclone runs were full server so that's not it. Her…
Logical Logs - Flags and backups
Hi Mark, The "B" in the 3rd position means that the logical log has been backed up, which is good! The log backup will be triggered by the script referenced in your onconfig file with the parameter ALARMPROGRAM. It is called each time a logical log is filled or logical log is sw…
Replication of Informix
Koonjul It's because your last excerpt from the Message Log contained... Primary : 02:49:30 rolling upgrade Invalid Level 15 12 02:49:30 rolling upgrade version mismatch ol_norwaysoc HDR Secondary : 02:49:29 rolling upgrade Invalid Level 12 15 02:49:29 rolling upgrade version mis…
Undocumented logical log flags
Hi Milan. That flag means we are currently in the process of flushing a log buffer to that log file on disk. An individual flush should be extremely brief but if you've got a lot of logging activity we're constantly writing out log buffers, so you may see that flag under load. It…
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 -----------…
Long Running Purge Script
Hi Art, Thank you and appreciate your suggestion. As the job has been running for nearly 3days, it is not clear, whether it can be killed in this intermittent state, as it might leave the database in an inconsistent state? The creators of this instance have configured this databa…
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…
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?…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Archecker logical table-level restore on 11.70.FC7
Greetings, I am attempting to do a table level restore on IDS 11.70.FC7GE and passed the logical restore options to archecker but I get the message below that I can only do a physical restore. The IDS documentation (Backup and Restore Guide) implies this option works with a sto…
Switching HDR to RSS replication
This is a follow up to my earlier post on IIUG (July 19, 2017): HDR-Distance and Latency Our HDR distance is changing from 40 miles (NEAR) to 1200 miles (FAR) after 2 months. After testing with a set of simple update/delete statements on triggerred and non-triggerred tables I co…
Re: New RFE
I had played around with doing this for ER as well so that we could include it with the GRID automatic replication. It might actually be in the product if you are connected to the grid when you convert the table from RAW to STANDARD. Now for the technical issue. The copy of the…
HDR Solution
Hi, Currently we have used informix IBM Informix Dynamic Server Version 11.50.FC8GE workgroup edition running on hpux. Our production load already full utilize during peak hour. To reduce load on production server, we plan to separated process to another server, means OLTP proce…
IDS not writing to online.log
Hi Art, tried that already. When I add a logical log I will see the corresponding entry in online.log and a checkpoint, and nothing happens after that. And I can't switch the logical logs because onmode -l is not working…
Removning Log staging in RSS server
Hi, since a problem today with Primary server wich are propagated to RSS server, I decide to apply the DELAY_APPKLY on my RSS server, I put for the test perpuse 5S, but the problem is the logs in the staging directory are not removed after apply those logs, is there any way to re…
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.…
Ebexport
Here are the steps to be followed if you want to perform a *dbexport* on a secondary sever. 1/ Make sure that a dbspace of type TEMP is available * before doing a dbexport , you have to have a TEMP dbspace 2/ Make sure the secondary server is RSS or make it RSS if you are in H…
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.…
dbexport on RSS Secondary
Im running IDS 12.10.FC6 on SLES 11 SP 4 with a primary and RSS secondary on separate boxes. At http://www.oninit.com/presentations/v117.pdf I see the following: Enhancements To Dbschema, Dbexport & Dbimport It is now possible to use the dbschema and dbimport utilities on all …
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)…
new features about dynamic parameter added in 12.1
Attention, this is not documented. For Informix 12.10, another way you can get the list is to use the cf_flags column on syscfgtab to determine which onconfig parameters are dynamic: SELECT cf_name FROM sysmaster:syscfgtab WHERE bitand(cf_flags,'0x1') = 0 --removes Unsupported p…
Root db space fills up
The logical and physical logs reside in there own db space.…
setup LOG_STAGING_DIR
Hello, any one have a idea about setup LOG_STAGING_DIR. can any one explain step by step with rss. in informix 11.70 Thanks…
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?…
Logical log size
Larry, You mentioned remote HDR, are you running sync or a-sync mode? If your primary shows Logical Log buffer waits "G" in onstat -u then you may want to increase the OFF_RECVRY_THREADS on the secondary to 3 or 4 times the number of CPU vp on the primary. Your will also want to…
problem creating idnex on spatial table with scri
i have logged a call with IBM support about this, AT this stage they can see no reason why the 2 methods i tried do not work. They are contibuing to look at it , THe problem only happens when creating spatial indexes…
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.…
Informix SNMP and replication
Hi, I read in the technical documentation Informix 11.50 : "The*onsnmp*utility cannot be run on HDR secondary servers, remote standalone (RS) secondary servers, or shared disk (SD) secondary servers." Do you know why ? Do you know if the replication (HDR or SDS) will be supporte…
Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"
What does onstat -l show? If you are dbimporting an export that was made without the -ss option then all tables are created with minimum extent sizing which will cause thousands of new extents to be added to the tables during the dbimport and extents ARE logged regardless of the…
IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"
Hi there I'm concious this is an old unsupported IDS version (IDS 9.30HC5) but as part of a migration I have to do a proof of concept. We've got the dbserver installed on a virtualised platform (basically it's a direct lift from $PARENT_COMPANY's installation copied onto the tar…
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 …
Re: HDR Reconstruction (with ER :-))
Hello Keith, Maybe RS Secondary is something that could work for you instead of a HDR secondary. Superboer. Am Donnerstag, 22. November 2012 10:39:21 UTC+1 schrieb Keith Simmons: > Hi all > I am going to raise a case for this query but wanted to get some community > feedback/t…
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…
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.…
RSS with DELAY_APPLY is dog slow!
On Nov 10, 2:52 pm, Nick <milesnmi...@gmail.com> wrote: > Hello, > > Does anyone have experience with RSS and the DELAY_APPLY feature? > > I am running tests, with the end goal to find the best HDR or RSS > setup that will minimize the performance impact on my primary db > server…
HDR & RSS
Hi Sergio, after your physical restore (onbar -r -p), Informix should automatically start the logical recover, until sync the two instances. (It seems you´re facing some configuration issue between them) Have you enabled SMX connection between them? I suggest you to do so.... he…
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…
951: Incorrect password error after Big Fix.
Just for curiosity, what is a "big fix"? Regards. On Fri, Jul 22, 2011 at 3:02 AM, Knox, Ernest <Ernest.Knox@searshc.com>wrote: > We had the Big Fix reverted back to the original password file on 107 > serve= > rs. That fixed the issue with the userid logins. It also affected t…
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.…
Quick Recovery
When using either STOP APPLY or DELAY APPLY, we save the logs on the RSS in a log staging directory. If using delayed apply, we will continue to apply the logs, but only after the delay. When you turn off stop apply or delayed apply, then the RSS node catches up by applying the l…
New System Config and DS8800
Hello Throwing out feelers on some questions regarding the setup of Informix OLTP systems on the new DS8800 Storage. We had drawn up a RAID 10 design for both data and logs and received feedback that RAID 5 would work out just fine. Through the years, the literature, conferences…
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…
DBEXPORT IN RSS NOT WORKS
HELLO!!! We have an environment RSS with IDS 11.50.FC7 on HP-UX 11.11. We want to do our backup method a dbexport on RSS side.. but appears the following message, after set STOP_APPLY=1, we run dbexport database command: "The operation cannot be performed on this RS secondary s…
ISM backups query
Can't seem to find the info anywhere for this one. I'm testing ISM for many obscure reasons; I've got it configured (eventually!) for backup to disk, which will be used as a staging area from whence the resulting files (and the bootstrap files, of course) will be sent to tape. I…
RE: dbexport on RSS client
Hi everybody!!!! I tried to do a dbexport with the following: dbexport basedato -o /path I followed the path Paul sent, but I got the following in the RSS node: ""The operation cannot be performed on this RS secondary server because no temporary dbspace exists. Set the DBSPACE…
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…
dbexport on RSS client
Paul, Let me suggest the following technique. 1) demote the HDR secondary to an RSS node --- This can be done online 2) set stop apply on the RSS node -- This can also be done online. Whi= le in this mode, we will stage the logs and can recover from them in the c= ase of a prim…
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 …
Suspending HDR temporarily?
informix-list-bounces@iiug.org wrote on 02/05/2010 04:13:03 PM: > From: > > pretzel <davidegrove@gmail.com> > > To: > > informix-list@iiug.org > > Date: > > 02/05/2010 04:16 PM > > Subject: > > Re: Suspending HDR temporarily? > > Sent by: > > informix-list-bounces@iiug.org? > > …
IDS 11.50.xC6 is out...
Hello, IDS version 11.50.xC6 is currently available. It has become usual for these fixpacks to bring a lot of new functionality, besides the usual bug fixing. From the release notes: 1.5 What's New in Version 11.50.xC6 of IBM Informix Dynamic Server 1.5.1 External Bac…
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…
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…
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?…
oninit taking 98% cpu
As I read it, the secondary was "down and out" and had been switched off and the recovery stage had completed on the primary(main), because it was back online. I can see what you mean, about the flood of traffic to get instances in sync. But the CPU should not increase until th…
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…
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…
Simple Password Encryption not happening
On 28 Feb, 20:48, Jonathan Leffler <jonathan.leff...@gmail.com> wrote: > On Feb 27, 1:29 pm, Jeff <jlar...@yahoo.com> wrote: > > > I have attempted to enable Simple Password Encryption yet my > > network sniffer still shows plain text passwords. > > > conscsm.cfg (copied straight…
Re: IDS 11.5 and SDS
On Jan 28, 12:01 pm, TBP <th...@Usenet-News.Net> wrote: > TBP wrote: > > Tom wrote: > >> On Jan 28, 10:14 am, TBP <th...@Usenet-News.Net> wrote: > >>> Tom wrote: > >>>> Greetings All, > >>>> Has anyone configured IDS 11.5 with SDS on any AIX platforms? I am > >>>> configuring two…
PIT Restore from directory
Hi, im not able to make a PIT-Recovery of a table from backups in directories. same problems on ids 11.50 uc2, ids11.50 fc3 on linux. The physical restore works, but the stage phase hangs. my schema file: trest.sql: ----------- database stores_demo; create table zeit ( nr…
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…
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 …
equivalent of savepoint(oracle) in informix
debadatta wrote: > Thanks for confirming the answer, but is there any other way we can > implement feature of savepoint in informix esql/c or 4gl. for example if i > have to commit a million record and i am commiting after 5000 rows. how > can i implement such that i can roll bac…
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…
libstdc++.so.5 error while installing informix
asdf wrote: > Installation of IBM Informix Dynamic Server failed. > etc/brand: error while loading shared libraries: libstdc++.so.5: cannot open > shared object file: No such file or directory > > Please read the information below. > > ***** Error occurred during installation. P…
What is ids11 new function RSS for?
Hi, also in the Administrator's Guide there is a section that is partially copied here: Differences Between an RS Secondary Server and HDR An RS secondary server is similar in many ways to an HDR secondary server. Logs are sent to the RS secondary server in much the same…
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 …
Restoring Level 1 Backup ONLY - INFORMIX 9.4
ids-bounces@iiug.org wrote on 07/31/2007 10:16:55 AM: > Dear All, > > I am trying to restore level 1 backup ( with ontape -r ) on a machine ( > solaris 8 )on which I have a level 0 backup already restored preveiously ( > while restoring I terminated restore at the point when lev…
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 --…
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…
Transaction Question
On 24 Apr 2007 07:28:58 -0700, Dave <In4MixDBA@gmail.com> wrote: > Hello All, > > We have the following transaction situation. Is it possible within a > transaction, "begin work" ......"commit work" to insert records to a > log table and have those records committed regardless o…
IDS 10.x on HP 11.23
We are toying around with the idea of a poor mans HA solution. This is our idea: Itanium is primary and PA-RISC is secondary only we don't use HDR. Volume groups are visible to both servers. If primary goes down we could bring the instance up on secondary. Will the data be read…
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…
apply TX logs after data migration
We are planning a migration from from one platform to another (both Intel/Redhat, IDS 10.00.UC4, new one is bigger, faster, stronger, etc....). We want to do the migration from a staging server to: - leave production up - move only 1 years worth of data; leave historical data beh…
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: HDR in IDS 10.0xc5: slow Secondary restart
Hi, Madison, I've submitted the problem to the ESR system. Actually, I ran into another problem with HDR on 10.FC5: When FASTPOLL is set to '1' (enabled) on Secondary, one of NETVP oninit's is consuming all available cpu resources of a single cpu on Seconsdary. I know, that it…
RE: HDR in IDS 10.0xc5: slow Secondary restart
Hi, Madison, I've submitted the problem to the ESR system. Actually, I ran into another problem with HDR on 10.FC5: When FASTPOLL is set to '1' (enabled) on Secondary, one of NETVP oninit's is consuming all available cpu resources of a single cpu on Seconsdary. I know, that it…
HDR in IDS 10.0xc5: slow Secondary restart
Alexey Sonkin wrote: > Hi, everybody, > > Long-awaited IDS 10.0xC5 (with a great FASTPOLL feature) is finally released... and appeared to be almost unusable for large installations, using HDR > > Really, really bad 'feature' was added to HDR mechanism. > > Every time, HDR Seconda…
HDR in IDS 10.0xc5: slow Secondary restart
Hi, everybody, Long-awaited IDS 10.0xC5 (with a great FASTPOLL feature) is finally released... and appeared to be almost unusable for large installations, using HDR Really, really bad 'feature' was added to HDR mechanism. Every time, HDR Secondary is restarted (that is, stoppe…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
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: AW: Mirror / Raw device / Informix
What happens whihlst you are doing this the machine is rebooted e.g. hardware failure, panic, power failure? When IDS (+possibly ISM) restart what happens? Model-Bosch, Tilman wrote: > There is a third option, you may use the perpetual restore method > where you keep a secondar…
AW: Mirror / Raw device / Informix
Art Kagel wrote: > > There are better solutions however. As hinted by others, > Informix provides > two levels of database replication that can be used to > maintain a secondary > server which is either a hot backup system for failovers only > or which is > indeed a live server …
RE: Moving Informix TableSpaces between databases
Hi Simmon and Superboer thanks you for your suggestions. I tried out the RAW table and it works like a charm, it was exactly what I was looking for. Thanks a lot. Regards, Aash -----Original Message----- From: owner-informix-list@iiug.org [ mailto:owner-informix-list@iiug.org <…
RE: Moving Informix TableSpaces between databases
Hi Uday, We did considered using the HPL but only because that was the only thing available and it takes a lot of configuration work, we are kinnda short on time and the product we are working on will be deployed to various other clients so we were looking for a generic solution.…
Re: Moving Informix TableSpaces between databases
I think your best bet would be to use HPL to unload data from the logged db and load it into the non-logged db as long as they both have the same schema(=table definition). Regards, Uday. "Aashish Ramsinghani - ASDC, Chennai" …
RE: Moving Informix TableSpaces between databases
Aash You don't tell us which version of IDS you are using, however have you investigated RAW tables (if they are avaialable in your version). They can be created in logged or unlogged dbs and can allow the type of access you require. RAW tables cannot be indexed or have constrai…
Moving Informix TableSpaces between databases
--staging has it disabled. the tables in there you could potentially create them to be raw tables and make staging logging enabled. you can alter the table to be logged again followed by a lvl 0 archive or a fake lvl 0 archive another thing: you could create tables in a log…
Moving Informix TableSpaces between databases
Hi I am using Informix for one of my DW projects. We are loading data from the source system into the staging area both are separate Databases. Source has logging enables and staging has it disabled. The problem comes when I try to access data across both these databases. I canno…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: External backup/restore - an idea - comments please
> Is this what you are talking about: > onmode -c block > <get permanent copy of chunks in some way> > onmode -c unblock Basically, yes. I'd use dd, gzip and netcat for dumping all chunks (all of them in raw devices) to filesystem on a remote host. > The onmode -c puts all of t…
-243 Could not position within a table table-name.
deepak.singhal007@gmail.com wrote: > hello friends > This is the error message I got in my DATASTAGE log file. > my job is running so many times fine and many times it is dispalying > above warning message. > so can u please give me any solution to resolve this issue > Thanks > D…
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?…
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:…
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…
RE: Adding logical logs problem..7.31UD7
Kadu You should change back LOGFILES to the actual number of log you have. run onstat -l if you are not sure. LOGFILES will be updated automatically by onparams utility. The parameter you must change is LOGSMAX, if you need 30 log change it to 40 just to be on the safe side. Ur…
Adding logical logs problem..7.31UD7
Thanks it helps! I've not been awared of this. kadu wrote: > Hello, > I've installed informix from scratch and need move logical logs from > rootdbs to llogsbds, I've created at initilazition stage 3 llogs in…
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…
shmget: [EEXIST][17]: key 52564801: shared memory already exists
Hi guys! Need some help with informix... here is what happens. on our Linux Red Hat 7 machine we have 3 versions of informix(7.3, 9.2, 9.4) 7.3 and 9.2 work fine after initialization, but 9.4 doesn't want to initialize. I also checked onconfig(s) and found that 7.3 and 9.2 use t…
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: 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.…
Channelling Madison Pruett
Rob Vorbroker <rvorbroker@yahoo.com> wrote in message news:<c6m9hu$t7c$1@terabinaries.xmission.com>... > For those of us venturing out into the DB2 UDB world > can you give us a summary of tools similar to HDR and > ER (which we love so much). Thanks ---- ;-) > > Trying to supp…
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.…
Re: information integrator & informix
Madison, Can you explain a little more about that? Why exactly would this not work on a HDR secondary? Does it have to do with the Read-Only aspect? Does DB2 use triggers to populate staging tables on the DB2 box? Are they Temp Tables? Sorry to hit you with so many questions but…
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…
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…
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…
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…
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…
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.…
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…
Ontape Restore
Some questions that may help broaden the understanding of your problem :- Is your "mirroring" Informix mirroring or hardware/os level mirroring? What commands did you run for the restore? Diff the onconfig files from the instances. Complete the restore? At what stage did the er…
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: Insert into ... select from , and logging
Neil Truby wrote: > > IDS 9.20 (lw_coline); IDS 7.31 (coline). > > The "staging" database is a "datamart" arrangement which will be refreshed > each night, and which does not therefore need to be logged. However, the > statement below will not work unless staging is logged, beca…
Insert into ... select from , and logging
IDS 9.20 (lw_coline); IDS 7.31 (coline). The "staging" database is a "datamart" arrangement which will be refreshed each night, and which does not therefore need to be logged. However, the statement below will not work unless staging is logged, because londis_syn must have logg…
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…
Re: logging change error
OK, let's do this quickly: 1. In your onconfig file, set: TAPEDEV /dev/null # if UNIX or TAPEDEV NUL # if NT 2. ontape -s -L 0 -U ausatst Aside, do you really need unbuffered logging? It's quite slow compared to buffered logging, and if this is just a test database.... The c…
logging change error
Hi I am a new Informix DBA - and have never use Informix before :) (I have an Oracle background) Yesterday I dbimported a database (ausatst -thank god it is a test database, but still v. important at this stage of the project). I had not set logging on (didn't know I had to) a…
Re: (2) Onconfig Tweak Problem
From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: wyn441 <wclindenNOwcSPAM@mbf-law.com.invalid> >> >> >>I've been tweaking my onconfig file to enhance performance and >> >>today I see an warning error in my online log. >> >>"Physical Log size 20000 is too small. Physical L…
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, -- ------------------------------------…
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…
Question about database recovery
When recoverying an Informix database, I need level 0 archive tape and logical backup tape . I have two informix databases with same configuration(one is working database ,one is backup database) and I want them to keep same , If in an time point , I have recovered two databa…
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…
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…
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…
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…
RE: Transaction within a Transaction
Tom, You could create a temporary table *with no log* before you start the transaction. Insert into that temp table all the control information that you want to keep. Then, when the transaction is rolled back you simply copy the information from your temp table into a permanent …
Transaction within a Transaction
Tom Jones wrote: > IDS 7.31.TC5 on NT 4.0 SP 5. > > We have an application that, within the space of a single financial and > database transaction, performs a number of lookups and updates (nothing like > rocket science there then...). A 'control' row is created right at the sta…
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…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: Replication and HDR
In article <38552dce_3@news.delphiauto.net>, "Michael K Anderson" <michael.anderson@eds.com> wrote: > On Tue, 30 Nov 1999, Greg wrote: > > <gresmi@yahoo.com> wrote in message news:821u53$dir$1@nnrp1.deja.com... > > We are looking at implementing replication between 2 of our ser…
RE: Replication and HDR
OK, here's my .02... I am currently responsible for four HDR-pairs of servers -- three production pairs and one development pair. All servers are HP boxes, but I'm sure that most of this will apply to AIX, too. For each production server-pair, one server is in Sacramento, CA, …
Replication and HDR
We are looking at implementing replication between 2 of our servers, a primary in Ft. Lauderdale and the secondary in L.A., possibly using Informix's High Availability Data Replication (HDR) tool. Our questions are these: 1. The Informix manuals state that the hardware and OS mu…
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…
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…
HELP!!!
im looking at every logical log at 100% and naturally a blocked checkpoint. whats the best, and next best thing to do in a case like this!!!…
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…
Error writing to the log file
Hi, I am using Informix-SE version 7.10. I have a report that creates a temp table and then updates a certain field in it before sending the content of this table to a report. It seems that when the report parameters cover too many records the report gets the following error at…
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…
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…
dbaccess segfaults when username not "informix"
I've installed IDS 7.3UC7 under Red Hat Linux 5.2 (2.0 kernel). It works fine when I use dbaccess to connect as the "informix" username but trying to connect as any other username just makes dbaccess seg fault and core dump. This is at the stage where you choose a database (eithe…
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.…
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…
Continuous log backup in the background
John Bejarano wrote: > > All, > > Currently, we have an Informix server where we perform periodic logical > log backups using ontape -a. We're thinking of moving to continuous > logical log backups using ontape -c. We do have a tape drive that can > be dedicated to this. > > My…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: Logical Recovery Failure 7.24/HPUX10.20
Colin Taberman wrote: > > Engine Initialization Problem > > HPUX 10.20 > IDS 7.24.UC4X3 > > I am experiencing a problem during logical recovery stage of engine > initializisation, see online log snip-it below. > Has anyone any ideas how I can resolve this issue without going to >…
Logical Recovery Failure 7.24/HPUX10.20
Engine Initialization Problem HPUX 10.20 IDS 7.24.UC4X3 I am experiencing a problem during logical recovery stage of engine initializisation, see online log snip-it below. Has anyone any ideas how I can resolve this issue without going to backups. I have used 'tbzero' (an Info…
Re: Informix 7.24 Temp Tables Not Dropping
jeffm@lysander.co.uk wrote: > > In article <7d74rd$hrt$2@news-1.news.gte.net>, > June Tong <june_t@hotmail.com> wrote: > > jeffm@lysander.co.uk wrote: > > > > > I have a system running IDS 7.24 on HP-UX 10.20. Some software is creating > > > temporary tables using 'SELECT...IN…
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…
Informix 7.24 Temp Tables Not Dropping
Not true. If you list LOGGED dbspaces in DBSPACETEMP, temp tables WILL go there. Also, if you don't have any logged dbspaces listed, and you don't specify WITH NO LOG, then the temp tables go to the database's home dbspace (the dbspace in which the database was created, systabl…
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…
HELP: HDR Restart Fails after upgrade
Platfrom: IBM RS/6000 J30 & J40 Informix: IDS 7.24.UC1-1 Earlier this morning I upgraded both boxes to the above version from 7.23UC1 We had HDR running with no problems. Now when I attempt to restart the severrs I get this message on the primary DR: Primary server connect…
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…
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.…
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…
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…
Planning an Informix Database disk layout
Hi everyone.... Can anyone advise me if there have been any articles written, and ae available on the web, about a disk layout strategy? We are in the process for planning the disk layout of a 150Gb system with 300+ tables. 1. Do we put the data into multiple DBSpaces? 2. Do we…
Re: Informix database reorganization
You may want to check out the alter fragment statement. Art Kagel have posted several times on this theme so you should look for that at http://www.dejanews.com What I write here is based on what Art has posted and he may correct errors in this: It sounds like you have all your …
Informix database reorganization
We're looking for a way to dump and reload our Informix database (right now 7.22UC3) that will cause the minimal amount of downtime to our users. Our machines are RS/6000 F50s, AIX4.2.1, and we use SSA disk drives. Our database server is a three-way box with 2GB of RAM. We have 6…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Informix and large databases
>We're dissatisfied with our current DBMS and are looking for information >about how Informix would handle the following scenario: > >We have tables that have approx 77 million rows that occasionally get >full batch updates. We have no particular requirement to have our >update …
Re: Informix and large databases
Robert Lada <rllalex@mediaone.net> writes: > Our question is two-fold: > > 1. Does Informix support some kind of "batch" updating that would allow > us to update single fields from a staging table without dividing the > transaction into parts, and without carrying the overhead o…
Informix and large databases
Hi, We're dissatisfied with our current DBMS and are looking for information about how Informix would handle the following scenario: We have tables that have approx 77 million rows that occasionally get full batch updates. We have no particular requirement to have our update t…
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: 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: 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: +…
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…
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…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Transaction logs and audit trails - quick overview required
Ian Clark <ian@tubeway-army.demon.co.uk> wrote in article <34c85f8c.72776308@news.demon.co.uk>... > Hi All, > > I've just joined a company who are running an in-house developed > application written in Informix RDS and looking though the code I am > amazed to find that there is n…
Transaction logs and audit trails - quick overview required
Hi All, I've just joined a company who are running an in-house developed application written in Informix RDS and looking though the code I am amazed to find that there is no transaction logging going in. That means no BEGIN WORK, COMMIT WORK or ROLLBACK WORK. Without these, in a…
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…
Re: Creating Logical logs
In article <3498326C.660B@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >PRAVEEN MOHANAN wrote: >> >> Hi users, >> >> Thanks for the solution. I created a database with log, and >> could load the schema of another db. I know only few things of the DBA >> …
Re: Creating Logical logs
PRAVEEN MOHANAN wrote: > > Hi users, > > Thanks for the solution. I created a database with log, and > could load the schema of another db. I know only few things of the DBA > stuff. But can anyone please tell me > 1.how to know how many logical logs are there & w…
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/…
(Fwd) InternetWeek Newsletter - Sept. 25
I got a kick out this. Hope y'all do to. --------------------------------------- No Network, No Demo; Oracle's NC Demo Dies Onstage Oracle chairman and CEO Larry Ellison began his keynote earlier this week at Oracle OpenWorld signing the praises of the Network Computer and Net…
Re: How does one count free logical logs in 7.23?
>A company I work for uses INFORMIX Vn. 7.23. As one of >its future administrators, I have a problem with checking >how full the logical logs are, since {onstat -l} now says >all logs but the current one are "used" (and 100% "full"), >once they have been used at all since the ini…
How does one count free logical logs in 7.23?
Hello A company I work for uses INFORMIX Vn. 7.23. As one of its future administrators, I have a problem with checking how full the logical logs are, since {onstat -l} now says all logs but the current one are "used" (and 100% "full"), once they have been used at all since the i…
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/…
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: 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: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Thanks for your suggestion. However, we had already set the logical log backup device to /dev/null. In this case, what causes logical log full? Sincerely yours, Xiaohui Shen…
logical 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 …
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: 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: Passing Information from 4ge's?
In article <3ku3or$r2n@dale.goodeal.msk.su>, Vadim J. Nikitin <nvj@goodeal.msk.su> wrote: > > 4ge, used as a function, may return its results into standard >output, like other UNIX processes (if it's not interactive), or into >text file that must be read by calli…
Re: Logical log write volumes
> Piggy-back COMMITs are a real event. All this means is that the logical > log buffer in shared memory is flushed to disk periodically. If a > second commit occurs before the log buffer is flushed it will continue > flushing the log buffer to disk. This does not alter the amo…
Online Problem
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM wilson %SYSTEM DHLNET %SUBJECT Online Problem %VERIFY y %REGISTERED y %DATE 23/02/95 16:50 %REFERENCE 82494 Dear Informix users! Is there any ONLINE tools readily available to…
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…
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…
IBM Publishes First TPC-C Benchmark on Open Systems
Subject: IBM Publishes First TPC-C Benchmark on Open Systems On Tuesday, February 2, 1993, IBM released the FIRST TPC-C benchmark results executed on open (non-proprietary) systems. The next day, February 3, 1993, HP released the second set of TPC-C benchmark results on open sy…
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 …