Oninit® Archive
Results for “LOG_INDEX_BUILDS”
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…
HDR : Primary et secondary OS Comptability ?
Hello, I red here (http://www.informix-dba.com/2010/08/informix-hdr-will-save-your-butt.html) that for HDR, primary and secondary servers can be on différents Opérating Systems, is there a compatibility matrix ? For my case i have a primary on AIX ans maybe a future one on Linux…
Table locked after applying foreign key
Creating a foreign key creates an index unless one already exists. Unless you have LOG_INDEX_BUILDS set to 1 the HDR secondary will build its own index after the primary finishes, but it will maintain the locks needed for the index build on the primary until the secondary's index…
Technological Differences between HDR & RSS
We want to use HDR, as we can then switch HDR to Primary. Is there any technological difference between HDR & RSS, that might impact Transaction Processing on Primary Instance. Thanks.…
No Trust/No HDR?
Is it necessary to use either a hosts.equiv or .rhosts file to maintain a "trust" between two hosts which are members of an HDR pair? Is there any _secure_ method to establish and maintain the trust which the informixserver recognizes aside from using a dated technique that has …
Unexpected RSS authentication failure for 'leap16_2_c_tcp' during the Initialization Phase.
Just an observation really, occasionally on a fully functioning cluster the following is reported leaving the RSS instance in Fast Recovery ... a simple restart (onmode -ky; oninit) of the RSS and all is good ... 13:17:22 ERROR on the following statement SQLCODE: -243 ISAM:-154…
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…
DRDA redirection to HDR primary
Hi Gerd. Thanks, but the purpose of this thread is to get automated HDR fail-over redirection working without Connection Manager. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
Informix 11.50.FC9W3 assert failed question
Hi Chuan, Did you try to `oninit` the RSS? ------------------------------ Sincerely, Dennis ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Logical Logs - Flags and backups
Hi Mark, 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…
Drop table with no-logging mode
Hello Nasiha, you are aware that no-logging tables are not transferred to the secondary server, so HDR does not work for no-logging tables? Regards the hanging HDR server you should open a case. Regards, Henri ------------------------------ Henri Cujass leolo IT, CTO Germany IBM …
Replication of Informix
Gerd I don't believe that matters. If you wanted to keep your HDR traffic separate from your user traffic, an option would be to create the HDR connection with an INFORMIXSERVER setting defined as part of DBSERVERALIASES and operating through a different port. Koonjul, Is port 16…
Manual Switch Primary , Secondary while RSS exist
ABeMie: It's the same whether you have RSS secondaries or not. When the HDR secondary takes over as primary it will reach out to the RSS secondaries and make the connection basically saying "Yo, dude, talk to me now!" All is well. Art ------------------------------ Art S. Kagel, …
informixHQ without informix
Thanks for reply Ramon, The information is excellent as I have a project with 12 instances and their RSS feeds to control. Best regards, SP ------------------------------ Sergio Peres AIRC ------------------------------…
HDR
Hello all, I'm doing the HDR setup on my personal laptop with IDS 11.50(OLD ONE) for learning purpose. I created two server on VMWARE and did FIREWALL off and both server can ping to each other. I'm facing problem when I go to create 2ndary Server. I've attached the doc for the s…
ontape error
Sorry Sergio, I was away from the keyboard. I haven't read the entire thread so apologies if I type something that's already been discussed. Run this on the node implied in the command prompt... [RSS]$ onclean -ky [RSS]$ onclean -ky [RSS]$ ipcs If you still see any Shared Memo…
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 -----------…
Promoting RSS nodes
1. Promote ifxdb03 to HDR secondary. onmode -d secondary ifxdb01 2) Promote ifxdb03 from HDR secondary to primary onmode -d make primary ifxdb03 3) Promote ifxdb04 from RSS to HDR secondary onmode -d secondary ifxdb03 ------------------------------ Nagaraju Inturi --------------…
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…
RSS over SSL
Hi, I am trying to setup one RSS server using SSL, can someone give some help about this? Thanks in advance, SP…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
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…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Connections made to RSS are visible on PRIMARY
Dear All, Informix version 12.1FC10 on HP Unix and application running on RHEL 7 SET up has a PRIMARY, SDS and RSS We have a read only application that is pointed to RSS servers (direct connection to RSS server and NOT via Connection manager) When we start this application whi…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
Page Limit
Hi Dirk, Some options: 1. Follow your plan but add a lot more logical logs to the system beforehand. 2. Compress the table: this requires Advanced Enterprise edition to be compliant with licensing. This option is really only a deferment of the problem. 3. Delete some data :-)…
Take Primary and RSS down and up, w/o reinitialize
David, You should be ok taking either one offline to do non-database work. Before taking them down run onmode -c norm on the primary to force the checkpoint so they are in sync. Also check onstat -g rss verbose on the primary to make sure the RSS server is not way behind. Look …
Updatable Secondary (RSS)
Informix 12.10.C3 Solaris 10 1/13 I would like to make a read-only RSS updatable, so I can do a dbexport. I have done this in the past. However, this time, I can't seem to make it updatable. I do the following: 1) Take the read-only RSS offline. 2) Edit UPDATABLE_SECONDARY par…
How to DROP unlogged table on RSS?
Dropping the RAW table on the primary should have been replicated to the RSS secondary. Have you dropped the table while the the "STOP_APPLY 1" was active on the RSS?…
How to tell if logs are caught up in HDR
"onstat -g dri" on both , hdr and primary to check if they are sync'ed Also, you can see in the logs messages like "DR: Secondary server needs failure recovery" "Start Logical Recovery - Start Log ..." When you'll see "DR: HDR secondary server operational" then primary and HDR ar…
RSS Encryption Performance Hit?
Since RSS is a special case of HDR, does ENCRYPT_HDR also have to be set? DG…
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…
reading committed data on hdr
We are using informix IDS 12.1 with an HDR in near_sync mode. Some applications read data from hdr. We found that uncommitted data is also read n hdr that some times rollaback and information delivered at that instance does not recoincile. One solution might be keep the hdr in fu…
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.…
RSS bring up secondary problem
RSS online log: 00:50:09 RSS: Lost connection to idsescmnsoc 00:50:10 RSS: Reconnected to idsescmnsoc 00:50:13 RSS: Lost connection to idsescmnsoc 00:50:14 RSS: Reconnected to idsescmnsoc 00:50:17 RSS: Lost connection to idsescmnsoc 00:50:18 RSS: Reconnected to idsescmnsoc 00:50…
RSS does not apply logs
hello, I have the following situation. I would be very pleased if somebody could put a light into this. Thanks a lot, JUAN Primary: amc1_rss RSS server: amc4_rss RSS DeLAY_APPLY 5M Why does RSS secondary not apply logs up to 116024, having long past the 5 minutes delay config…
Re: HDR Question
Back in business. Did a reboot and it must have freed up the port. Now back to trying to get HDR going.…
HDR Configuration
Hi Friends, After a lot of study and IIUG members help, we are ready to implement HDR in production environment. But I need your help to get move forward to successfully implement HDR without any issues. Which is the best approach to get high performance and without any data lo…
HDR scenarios
Dear Informix Guru's I have successfully implemented High availability HDR in Windows environment with auto switch-over using Connection manager with the IIUG members help. Especially Mr. ART Now pulling my hair with some sort of scenarios, which i mentioned below, because of f…
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…
Informix HDR
Hi, I'm currently running Informix HDR (IDS 12.10FC8 on Windows server 2012 R2) in Async Mode. I just have a few questions: In Async Mode, the log is flushed to disk without waiting for a confirmation from the Secondary. What happens if a transaction is committed on the Primar…
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…
New Channel of Informix Server (Tech)
Hi guys There is a new channel of Informix Server in Spanish , enjoy It -Install , Backup , Restore , HDR and more. https://www.youtube.com/channel/UCVGD_IAhd0VGntXiSh_E6ew Best regards Luis devecua.com…
Re: New RFE
No need to create a logged copy. Just put the pages of the table into the log, just as we do with index page logging. The only down side is that the table would have to be locked during that time and the conversion to standard would be considerably longer. Sent from Yahoo Mail f…
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…
Rebuid sysmaster database and effects in a HDR/RSS
Hello I need rebuild sysmaster database in our production instance. I think running the "$INFORMIXDIR/etc/buildsmi" script will not cause problems with our HDR/RSS instances, but I'm not sure. Anyone know if there is any kind of incompatibility (rebuilding sysmaster) with an H…
Re: RE: HDR replication setup on Windows
Hi, Did you got the information on HDR implementation on Windows. If, could you help me on this. I have stuck at this point since last three weeks.…
HDR Implementation
Hi All While HDR implementation on Unix My scenario: 1. Two different servers with identical hardware and software. 2. Installed IDS on both servers. 3. Created Instances manually with all onconfig, sqlhost, environment variables set. 4. set all HDR related parameters in oncon…
HDR implementation on Windows server 2012 R2
Hi Every one. Hope all are doing well. I need a assistance in implementing HDR in Windows environment. My OS is : Windows server 2012 R2. Can anyone plz provide the key parameters to implement HDR in windows environment. I had implemented in Linux environment. its successfully…
HDR Implementaion
Hello All, Need a Fast response. Thank you Advance. On implementing HDR I have strucked at one point. My Environment: Primary Server Name : primary Secondary Server Name : hdr_secondary I had configured all the paramenters in oncongif, sqlhost, services, hosts, host.equiv. I…
Configuring HDR
We have a primary and secondary setup in PROD that I am trying to mimic in dev with version 11.5 I watched Lesters webinar, and he mentions the use of an rhost file. On other searches, I see some people use hosts.equiv file When I look for both of these in our PROD environment,…
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…
Informix Database crash cause select whith between
no, I would do it tomorrow, I keep the RSS to check this, but is there any manipulation could I do before ?…
DBSERVERNAME in an HDR Environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance.…
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.…
Rss impacting performance
Hello. Please take a look at your LOG_INDEX_BUILDS and TEMPTAB_NOLOG parameters, to make sure they are following the recommendations. Regards. Em 25 de ago de 2016 7:34 AM, BENJAMIN THOMPSON <benjamin.thompson@skybettingandgaming.com> escreveu: If RSS_FLOW_CONTROL is definitel…
RSS to Primary ?
Hi, We are running Informix 11.70.FC7W2 on Solaris 11. We tested the following scenario and want to see why it works and if its recommended or not to do this. We have 1 informix "source" server with 4 RSS servers connected to it. 1) We brought down the Source server "onmode -k…
HDR - export on secondary
On an existing HDR (11.70) I'd like running an export on the secondary node while the primary server still needs to continue running. On secondary node: onmode -d standard perform the export onmode -d secondary (HDR should start re-syncing) Any suggestions or recommendation…
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.…
Load by External table commit interval
No, I have an RSS server, if I turn the table to raw, unfortunately the load does not replicate to the secondary server unless is there a way to replicate this load with an other mechanism.…
RSS INSTALLATION
Hi, I want to install an RSS standlaone server on Windows, But I have followed the steps but no way to create this replica, I want to isolate the reporting to this server and to dedicte the primary server only for transaction. Os : Windows 2008 R2 and Informix 11.70…
Data loading quesiton
I will figure out the loading time with standard table without HDR on this thursday or friday. My Ids VERSION is 12.10FC6. currently DRINTERVAL is 0,HDR is near_sync; and I will do the testing according your suggestion, convert it to RSS before loading ,and conver it back to HDR …
External table problem
There are conditions where express can't be used - only deluxe. Been so long I can't remember them - indexes exist, rows larger than a page, and a few others. Do what John suggested during the load to verify express ... onstat -g lap. A "light append" (lap) bypasses the buffer ca…
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…
RSS server is not active / Can not establish RSS -
Hi Art, I also thought it could be the problem. LOG_INDEX_BUILDS was already set to 1 and did not solve the issue. Any other hints ? Thanks in advance ! Best regards, H. MOUKOURI Le 07/09/2015 14:54, Art Kagel a écrit : > In the ONCONFIG file on the secondary set LOG_INDEX_B…
Informix temp spaces
Hi Boycho, I have TEMPTAB_NOLOG 1; Do you think it will be good practice to set it on "0"? I have configured and two RSS servers.…
tuning HDR
Hi, A customer use HDR in IDS 10.They use async mode and DRINTERVAL is 30. database is unbuffered. a batch job run below two sql. 1, insert into A select * from B where condition; 2,delete from b where condition; they found those SQL become 10 times slow after using HDR. How to t…
Error -225 when configuring RSS
Thanks Art. I found the problem. On the secondary server the command is: onmode -d RSS <primary server> (without "add") and I was typing onmode -d add RSS <primary server> The command failed because the secondary server is in "Fast Recovery" mode !!!! Regards !…
blocking checkpoint with RSS
Can you not block a secondary RSS with a blobspace in it? If there is a way I can't figure it out.…
HA Checkpoint Trigger
The physical logging performed on the primary is not necessarily going = to be the same as it is on the secondary. A common reason for this is the= creation of an index. Consider that the primary may be doing a checkpoint as the index is bei= ng created during the final phase o…
HDR
Hi Scenario: 1. Primary failed 2. Secondary changed to Primary. 3. Primary initial Recovery (Step 1). 4. Can Sincronice from Secondary to Primary initial ? Comments Please. -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec …
RSS DBSERVERNAME
Good Morning, We are running Informix 11.70.FC7 on Solaris. Is there a best practice recommendation when setting up RSS on whether to use DBSERVERNAME or DBSERVERALIASES for the communication between the primary and RSS nodes? I recall at one of the IIUG Conference sessions som…
Wakeup RSS Server
Try running the onmode -d RSS <primary> again on the secondary. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions an…
Informix RSS Monitoring
Hi, We are running Informix 11.70.FC7W2 on Solaris. We are setting up a read-only RSS node to our primary. We want to setup some monitoring to see if the RSS node is keeping up the with primary. Any way to get some of the information via a query that is similar to the onstat -g …
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…
SQLHOSTS for HDR
What are the benefits to defining groups in sqlhosts for an HDR pair? I have had some issues with multiple instances (each with an HDR secondary on a separate server) where I left the group definitions out and came across some unexpected behavior when dealing with failover. After…
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?…
Setup HDR
Informix = IBM Informix Dynamic Server Version 11.70.FC7GE Unix = HP-UX rafdr B.11.31 I am trying to set up HDR between two servers. After I successfully ran the command "onmode -d primary serverA" , I ran the command "onmode -d secondary serverB" I then get the following messag…
Connection Manager - Sessions Terminate Abnormally
let me rephrase, I have 3 instances - ifx1, ifx2, ifx3 and then each of these has a designated HDR secondary. sorry for the confusion…
Re: RSS Feed Formatting
Test Post Test Post Please ignore! Thanks!…
Error HDR
Hello There I have the following error in secondary server 16:50:58 Start Logical Recovery - Start Log 9539, End Log ? 16:50:58 Starting Log Position - 9539 0x47832e4 16:51:03 Started processing open transactions on secondary during startup 16:51:03 Finished processing open trans…
HDR
Dear folks For HDR I need de same version of OS & IDS -- Saludos Cordiales Rubén Dután Gerente APLEXT CIA. LTDA. Soluciones AX-ERP & TIC www.aplext.com.ec -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que est…
Swapping HDR
Hello, IDS 11.70.FC7W3X3 AIX 6.1 I thought this should have been simple and maybe it still is... I want to swap modes in HDR. In other words, I want my secondary to become my primary and my primary to become my secondary. I have DRAUTO set to 0 and I do NOT want to have to res…
Álter Add fragment on HDR environment
Hello: I tried to alter fragmentation on a hdr environment with no succes due long transaction. Shall I change this database to non logging and try to alter? Shall I unset hdr, do the alter and set hdr environment? Regards…
ontape and onunload on a RSS Secondary
Good morning IIUG family, Quick question for those who have a bit more experience with RSS secondaries than I do. Context: My HDR Primary is so busy 24 x 7 x 365 with users and after-hours cron-jobs processing, that performing ontapes backups and onunloads on the secondary has b…
Upgrading IDS version on PRI need rebuilt HDR/RSS?
Hi All, I have a question related to informix upgrade. If I am running Primary, HDR & RSS, then when i upgrade the primary informix version (from IDS 11.70 FC4 to FC7), then HDR & RSS remain intact or not? And does it requires the rebuilding of HDR & RSS again using level-0 back…
Promoting RSS Secondary?
Consider a cluster with three servers, A, B, & C. Server A is the primary (not HDR primary), and servers B & C are RSS secondaries. Let us say that server A fails, or is otherwise removed from service. I can change one of the secondaries (say B) to standard, and put it in service…
reconnect RSS after network outage
Hello I have just setup an IDS11.70 cluster with one primary server and one HDR secondary plus one RSS secondary. I had a network outage between the production site and the backup site, it caused the RSS synchronization to stop because the timeout set in "IFX_SMX_TIMEOUT" was rea…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
BlobSpace replication
Hello, I read somewhere that blobspace in not replicated with HDR, is it true ? and if so what informix technology to use to do so ? Thank you :)…
Switching RSS Servers
Hi Everyone, IDS 11.70.FC7W3X3 O/S AIX 6.1 I have a scenario in which I have 3 servers in RSS replication, rss1 is the "primary" where the other 2 get their changes from rss2 is a replicate of rss1 rss3 is a replicate of rss1 My question is if rss1 goes down for any reason, c…
can we have to hdr servers ?
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?…
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…
HDR question
IBM Informix Dynamic Server Version 11.50.FC8W2 Redhat Enterprise Linux 5 I have a server that is running in standard mode with 1 RSS attached. I can I do the following without bring the engine(s) down On standard onmode -d primary <rss name> on RSS onmode -d secondary <prim…
Nasty, unexpected cluster problem
I didn't do the work but I am guessing we did. From the SDS Primary: 08:09:19 Maximum server connections 1858 08:09:19 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 1, Plog used 2926, Llog used 3258 08:10:14 Error receiving a buffer from RSS ob1_db3_ha - shu…
tuning RSS
We're bringing up some RSS servers and pushing them all to one box on smaller instances that (in the case of DR) will be moved to larger boxes not currently available. How much smaller can I make these "catcher" RSS secondaries? We've had them smaller before, but they seemed too …
RSS Feed Formatting
Sorry for the off-topic post, but I haven't seen any other good ways to ask about this. The content of this forum is amazingly useful and I want to follow all the discussions using the RSS feed, but I cannot get the formatting to display properly. Even when I view the feed conte…
syslock on missing session
I have LOG_INDEX_BUILDS set to 1 on all the configs. This specific table though does not have any indexes defined. -Justin -----Original Message----- From: Paul Watson [mailto:paul@oninit.com] Sent: Thursday, September 19, 2013 10:48 AM To: Justin Killen Subject: RE: syslock on…
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.…
onstat -g ckp Question
Index Page Logging which could be caused by scheduled index rebuilds or by the Btree Scanner compressing adjacent index pages that are mostly empty with index logging enabled. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.c…
DINDEX not found in logical-logs
Original post: Hello my friends. I am trying to investigate some possible index deletion in 11.50.FC9W2GE engine. The issue is that I cannot find a DINDEX portion in my log files. I´ve tested an index creation (in 11.70.FC7GE) and a CINDEX record has appeared, just fine. But af…
HPL unload on secondary HDR
We have a backup script that does HPL unloads on certain tables throughout the day. When I run the scripts on an HDR secondary however, it hangs for a bit, then times out with error "Cannot open database 'sysmaster@servershm' - SQL error -25588, ISAM error 2". The strange part is…
redundant connection manager configuration using H
correct. since PRIMARY always has zero latency, so most time Connection Manager will route client application to the PRIMARY. if you want use secondaries and low the connections to the PRIMARY, you can define cm_sla1 as SLA cm_sla1 DBSERVERS=(RSS,HDR),PRIMARY if all RSS and HDR…
RSS and BLOBs
Quick question...maybe... We're using RSS but we have a BLOB space. According to developer works http://www.ibm.com/developerworks/data/tutorials/db2-cert9195/section9.html RSS isn't able to restore a primary if the DB contains a BLOB space. Is this still true? If so is there any…
Undocumented checkpoint trigger
It has to do with what happens on the secondary servers when they receive and process the logs. I didn't check the details, but it was done to avoid bigger problems. It only happens with LOG_INDEX_BUILDS active. And you know who can give you all the details :) Regards. On Thu, M…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
Auditing HDR server
good evening, can we audit an hdr server ? which is, by definition, on read only mode :) thanks in advance…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
ifxclone
Also, make sure DELAY APPLY is set on the RSS, not the Primary. (I've made that mistake before)…
Some strategy to resize logical-logs in HDR
Thanks a lot, I am even more impressed about Informix HDR features now. Regards, Keith!…
Add more logical logs in IDS 9.4
Hi All, I'll be performing adding logical logs into our existing DB. My question are the following: 1. Do the DB needs to be in quiescent state? i believe, there's no need at all. Once i have added the new dbspaces to be used by the logical logs, i will drop the existing ones …
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
licence question
Hi, folks, If adding a Read-Only RSS instance for a existing instance, is there extra charge for the new RSS? Thanks, Frank --14dae9340881b758dc04cc2f68a0…
Aborted index build
IDS 11.70FC4 on RHEL. Recently we came to build an index on a large, fragmented table. It took much longer than it had in test and was abandoned. It then took simply ages rolling back (several hours; many times longer than the index build should have taken in the first place!). …
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…
Upgrading HDR to 11.70
Hello All, IDS 11.50.FC8W2 on Hp-Ux 11.23 I have gone through a post for upgrading to 11.70, just want some one to help me with sequence of steps. 1) Make the HDR standalone 2) Upgrade the Primary to 11.70 3) Level 0 backup on primary 4) Upgrade the HDR to 11.70 5) Restore the…
HDR in Windows
I need do an HDR in two instance in windows. How I do it. Thanks Wanderlei…
HDR and ER Running Together
Lets try again, this may be easier to read !! Set up is as follows: IDS 9.4 on AIX 5.3 --> ER over LAN --> IDS 10 on Solaris 2.8 | |-> IDS 11 on Solaris 2.10 V Sync HDR over WAN | V IDS 9.4 on AIX 5.3 Note ER is Primary to Secondary (one way). With this setup I am seeing line…
HDR and ER Running Together
Set up is as follows: IDS 9.4 on AIX 5.3 ----------> ER over LAN -----------> IDS 10 on Solaris 2.8 | |------> IDS 11 on Solaris 2.10 V Sync HDR over WAN | V IDS 9.4 on AIX 5.3 Note ER is Primary to Secondary (one way). With this setup I am seeing lines in the error log o…
New online magazine that recognizes Informix.
Well done. Do you have a RSS feed for the column? I would like to follow any new articles.…
Query Performance on HDR instance
Recently we have faced a scenario, a query was running quite fast on primary instance but performing poorly on HDR instance. The execution plan on both instances were different as well. After running "update stats" on tables involved in query, the execution plan on HDR become sam…
242: Could not open database table
Hi John, Since we are using RSS, LOG_INDEX_BUILDS is already set to 1. Also, my script to rebuild table uses split_schema script to generate SQLs to create table, indexes (after loading data), I am not sure whether I will be able to modify it to add ONLINE bit CREATE INDEX IF N…
HDR Setup
I "was" in the middle of setting up HDR between a pair of AIX 5.3 servers running IDS 9.4.FC6 (upgrade planned), but have just noticed in the Admin Ref that the servers should be quiescent when issuing the onmpde -d primary/secondary 'server name' commands. This requirement isn't…
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.…
HDR - Alarmprogram when down
OK, so the log message on the secondary is indicating that a bad rowid in a log record could not be rolled forward. That's bad. Yes, try dropping all of the violations tables, but first you have to STOP VIOLATIONS FOR <tablename>; then you can DROP TABLE <tablename>_vio; DROP TA…
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 …
HDR not working
Newbie to Informix Cannot get HDR to work. Can anyone help? Thanks Derrick Muller Secondary stays in Fast Recovery mode. Here are configurations for both primary (runix) and secondary (backix) Running SLE 11, IDS 11.70 PRIMARY hostname:dm_runix Instance: ol_dm_runix service: …
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…
Speed discrepancy between prod and a lab
I've been over-looking the HDR Remote Secondary that prod has, so I should add that we have one. I don't think it can account for a 25% speed difference. The other production environment has the same type of HDR, and we don't see the speed discrepancy with it.…
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!
Hi Nick, FYI, RSS_FLOW_CONTROL did not come out until 11.50FC8 unless you received it in a patch for 11.50FC7. How far away is your RS server from your primary? Jeff -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Beha…
delete HDR Secondary
Folks, IDS11.50, Redhat Linux. Is there a simple command to delete/remove the HDR Secondary from the Primary server side? I saw a similar command for RSS( onmode -d delete RSS...), but did not see it for HDR. Thanks, Frank --00151747596854590f04b13b31d9…
HDR and clob/blob/byte/text/ etc.
By default, and the way things were handled prior to 11.50, indexes are build in series on primary and then on the secondary and the tables on both servers are locked until both index builds complete. In 11.50 there is an ONCONFIG setting (LOG_INDEX_BUILDS) which changes that beh…
HDR & RSS
Hi and thanks for your reply, My primary IDS is called ol_scorexdb My RSS IDS is called ol_scorexdb02 1. I have added on both server a registry SQLHOST definition for the other member pair. So in both servers registry there are 2 entries on for the local and one for the pair. D…
Issues after upgrade
On Sep 15, 11:17 am, Roger <roger_vi...@yahoo.es> wrote: > 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…
Issue creating RSS replication
Hi, I am configuring RSS replication using IDS 11.5UC4WE. On primary it is showing as ONLINE & "onstat -g rss" is showing RSS Srv name = db02 RSS Srv Status = defined Connection Status = defined but Next log to send as (0,0). In RSS it is showing as Read-Only (RSS) but logic…
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…
Could I execute ontape,onbar oronunload on HDR SEC
Hi, I want to reduce the workload in the primary server. Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
Could I execute ontape/onbar/onunload on HDR SEC
Hi, I want to reduce the workload in HDR primary server? Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
HDR setup- Network driver system error
Just to be clear. You cannot use a shared memory connection in HDR, etc as DBSERVERNAME. You may use it in DBSERVERALIASES. My HDR is operational. I have identified the problem ( with tips from Madison) and posted below.…
blobs and HDR
Is it still true in 11.5 and/or 11.7 that you can't have HDR of a blob space? Is there a way to work around that? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets you make more mistakes faster than any inv…
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.…
DB Restore From HDR Files
Hi, We are using IDS 11.50 FC6 & 11.50 FC7 on solaris sparc. We have tested the following Case 1: We've shutdown HDR and taken its dbspace files (OS files) and re-stored (using oninit -v -S) it to another machine/instance, and it was successful. Case 2: While the HDR was opera…
same ports in Primary , HDR and RSS
hi, I have a plan to use same ports at Primary, HDR and RSS servers. Is there any implication or availability or performance overhead. Kindly share the findings. anees…
Quick Recovery
Thanks for the info. If we enable STOP_APPLY, then how we need to keep RSS active (even behind primary) ? Do we need to apply logs (manually) ? Thanks.…
index creation time?
Index create's are logged, at least the event is. If you also have LOG_INDEX_BUILDS set in your ONCONFIG file, then the entire process is also logged from the point at which index pages begin to be written (so once data collection and sorting are finished). If you have a rough id…
RSS Cannot Connect
Hi, We are using 11.50.FC7 on SunOS sparc. We deleted RSS for one of our instance. When we recovered it (using Level-0), we received the following error (at Primary Instance): 02:01:29 RSS ids_net_rss2_05 added 02:01:52 RSS Server ids_net_rss2_05 - state is now connected 02:01:…
Problem with HDR
I have upgraded my database from 11.5.FC6 to 11.5.FC7 but facing some issues with HDR. Its observed that when HDR is lagging behind the primary there are number of sessions goes into " G waiting on write of the logical log buffer" and primary goes slow and lot of load on primary …
Table Locked After Index Build
Try setting LOG_INDEX_BUILDS to 1. From: "DAN MUELLER" <dan.mueller@trnswrks.com> To: ids@iiug.org Date: 02/07/2011 06:48 AM Subject: Table Locked After Index Build [22708] Sent by: ids-bounces@iiug.org Good Morning, IDS 11.50.FC5 running HDR O/S AIX 5.3 I am looking for …
how to do a full restore at HDR primary server
ids 9.40 , HDR Primary & secondary at normal status. Can I do a full restore 'ontape -r' at primary server. Is that will affect HDR functioning after ? Or I should restart the HDR setup steps ?…
create bts index long transaction
Another thing to check is the if SBSPACETEMP configuration on the server. If neither the SBSPACETEMP onconfig variable is set nor a corresponding temporary sbspace created, BTS may use large amount of log space while creating the index. In this scenario, the index is built in th…
Page Size
Art, Thanks!! We did test the bigger page sizes. We have historical nasty indexes whose index keys are VARCHAR( 255).... The tables are also big, so the index tree levels are large/high ( >6) . With a bigger page size, we saw the index level is lower and the performance seems N…
RSS Cheat Sheet???
Hello, Does anyone have a cheat sheet for initializing RSS for the 1st time? I have 2 instances that I can backup on one machine and restore to on another via ontape -r and -p so I think my config is there. I can connect to databases on 2nd machine from 1st so I think the connec…
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…
Why RSS automatically becoms standard?
Hello, Our RSS server automatically become standard while its drauto value is 0 (mannual). Following are the messages which are in message log file. 19:33:17 RSS: Lost connection to ids_net_db91 19:34:31 RSS: Reconnected to ids_net_db91 19:34:35 This server is not registered wi…
Re: DBEXPORT IN RSS NOT WORKS
I think it's a BUG. It will work if you use just one tempdbs. Set DBSPACETEMP=dbstemp1 on RSS secondary, then bounce engine (RSS secondary).…
New Feature Request for HDR/RSS in place upgrade.
In place upgrade for HDR and RSS secondary servers. Requiring a backup/restore to re-initialize the HDR and RSS servers is no longer acceptable. In the case where we have our RSS servers located in different data centers, the time it takes to send a backup is over a week. Bandwid…
HDR licenses
Hello, Does HDR (standby server) require a separate Informix license? Can anyone point me to a documentation that deals with that issue? Thanks…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
RSS - Hangs on changing RSS to standard
Informix 11.50FC7W1 AIX 6.1 I am testing scenarios with RSS. I tested setting up RSS, failing over, going back to the original setup and running the test a second time. During the second test changing the RSS to "standard" the instance hangs. I have a case open with IBM but n…
RSS Replication Questions
OS: AIX 5.3 Informix 11.50FC4 I have a few questions on RSS: In the Informix manual under HDR Requirements it states the following: "The primary and secondary servers must be able to run the same IBMR InformixR Dynamic Server (IDS) executable image, even if they do not have i…
Setting up HDR - 11.50.FC1
TRI TRINH wrote: > Hi, > > I am trying to setup HDR in two Linux servers inftest1 and inftest2. I > followed the instruction below, but step #7 below was confusing. I tried > "onmode -d primary inftest1". The result from onstat - is "On-Line (Prim)". > But I also get message from…
HDR Information
I'm getting ready to start working on setting up HDR and have gone searching google for information about doing so. There seems to be a wealth of it out there, but I'm wondering if there is one in particular that would be classified as " the best ". Jonathon Wyza CX & CBORD Syst…
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…
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…
hdr and statistics
Ever since I started HDR on a second server, the statistics have been different. After a db restart, sometimes onstat shows statistics on the primary server and the secondary shows as zeroed out, sometimes the opposite. Then it stays that way to another restart. Can't figure out …
Online Index Build and HDR
>> Any suggestions on setting the LOG_INDEX_BUILDS ONCONFIG parameter in an >> HDR >> environment and online index builds or the ONLIDX_MAXMEM ONCONFIG >> parameter? > > If I remember correctly from few months ago on our test system (in > HDR) we had to set LOG_INDEX_BUILDS to en…
Switch RSS secondary back to Primary
I did what Nilesh adviced on and here's what happenned: OAT (2.27) shows that the servers (Prim-RSS sec (updatable)) are connected. However, nothing is getting written to the RSS.online log. On RSS I see the following written to the online log when I bring up dbaccess: 14:29:31…
Backup from RSS server
I am testing on a RSS server setup for the first time. The RSS server will be used to backup the Production databases so that we can restore any one of 4 distinct instances we have on our Development box. Currently we use 'onunload/onload' process to backup/restore Production dat…
HDR failing
Hi All, I got this message from the primary that the replication failed... Please see below 19:54:42 listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken. System error = 9. 19:56:21 DR: ping timeout 19:56:21 DR: Receive error 19:56:21 ASF Echo-Threa…
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
Anyone knows if dbexport on 11.50 RSS client is possible? Paul,…
Can an HDR Secondary know if RSS is setup on Prima
Hello, I have a stored prcedure which exists on three replicating databases (HDR Primary, HDR Secondary and the RSS server). This stored procedure gets called on each server and performs different tasks depending on what mode the server is in and whether RSS is configured. It w…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
Have any of you experienced this? In reviewing the online.log, I discovered that AFTER a system reboot, and ONLY AFTER a system reboot, the first time the "Auto Update Statistics Refresh" begins, the following performance advisory is recorded. The Backup occurs nightly, the AUS …
RE: Long Checkpoints with HDR and 11.5.
Ernie Knox wrote: Well, the Informix tech replied as follows: Further research revealed that the defect fix in 11.50.xC5 is only a partial fix to the problem. The 11.50.xC6 contains another fix which is supposed to finish the job. We'll let you know how it turns out with FC6. …
HDR Error
I keep getting an error when I attempt to turn on HDR on my secondary server with "onmode -d secondary <primaryserver>." The informixserver message log reads: 16:26:23 DR: Reservation of the last logical log for log backup turned off 16:26:23 DR: new type = secondary, primary…
IDS V11.50FC6 HDR RSS level 0 archive
Hi, We are just setting up HDR with a primary, secondary and RSS servers. I have read that in IDS V11.50FC6 you can now do backups on the RSS server. I have tried testing this using ontape -s -L 0 (will be onbar in our live system) IBM Informix Dynamic Server Version 11.50.FC6 -…
HDR Problem
Hi All, I've take the whole day configuring the HDR but it didn't work. I have the same machine and OS configuration. This is the procedure i've done so far: on Primary server, i have this configuration Primary sqlhosts #Primary ipc_ross1 onipcshm ross1 ipcshm ol_ross1 onsoc…
HDR not working
Hi all, It's my first time to configure a replicated machines. I'm using the same machine specification (all hardware), same IDS 11.5, same all up to the configuration. I also performed a backup using ontape -s -L 0 and ontape -r in secondary. on primary server, i performed on…
IDS V11.50FC5: AUS error.
yes, in a HDR system..…
IDS Updatable RSS on different platforms
Jonathan Smaby wrote: > I've been asked a question by my sup. Under IDS 11.50.xC4 or better.. if I had > an RSS Primary running on HP-UX, could I have a Linux RSS updatable secondary? No. > I know that standard HDR replication isn't cross-platform, but how about RSS? > My goal …
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…
RSS Appears to stall ?
Here's an odd one... We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B Site A contains a Standalone Server S1 and RSS node S2 Site B contains RSS nodes S3 and S4 S2 and S4 stay nicely in sync with S1 ; S3 RSS applies seem to 'stall' --- the drift varies …
RSS Appears to stall ?
Here's an odd one... We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B Site A contains a Standalone Server S1 and RSS node S2 Site B contains RSS nodes S3 and S4 S2 and S4 stay nicely in sync with S1 ; S3 RSS applies seem to 'stall' --- the drift v…
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…
Question on HDR
Hi All, Just a question on HDR of Informix.. The scenario is the DB primary server went down. The secondary server is up and running. The replication is fine before the primary shuts down. Here are the questions: 1. Is the Secondary server will function right away as the Prim…
HDR
Hi Would anyone tell me on a HDR pair in IDS 7.31, if I bring down the primary server (say for 2 hours appx for maintenance ) and make the secondary server as STANDARD, after primary server comes up, do I need to restore logical logs from secondary server? I want to bring the …
RSS can only use DBSERVERNAME?
Prior to the 11 versions, HDR could be setup on a private IP or NIC and you can assign a connections listed in DBSERVERALIASES to handle HDR traffic between your servers. Now with RSS it seems like it only works with DBSERVERNAME and will not properly establish a connection if …
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…
RSS problem
Hi! IDS 11.50FC4 Sun Solaris I have Primary, Secondary HDR and RSS servers. When I run: 1. Stop HDR (onmode -d standard) 2. After 50 or more logical log files completed I start HDR - onmode - d primary ... 3. While logical files send to Secondary HDR, new logical log files compl…
ontape -c
I use 'ontape -c ' to backup the logical log, if the 'ontape -c' process was terminated abnormally, for example, the machine crash or it was killed by others, do anybody know if I could restore those logical log sucessful?…
Logical logs backup
Hi Martin, Thanks for your response! Correct me if my clarification is wrong! At one point of time, the status of the logical logs is Logical log 4 to 7 -> U_B__ Logical log 8 -> U_C_L Logical log 9-13 -> U_B__ All the logical logs are 100% full When i did a level 0 backup, th…
HDR
I'm getting ready to turn on HDR between our production site and our D/R site located 7 miles away. We are running Jenzabar CX on Informix 10 and HPUX 11i v2. Our 2 servers are connected via a 20 MB pipe. I've gone through the documentation but I have some questions below. We hav…
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…
Table and indexes extent size
FILLFACTOR is ONLY effective at the time an index is created. It has no effect on the growth of the index over time. Index extents are auto sized based on the tables extent sizing and the ratio of the row size to the index key length. Often this calculation doesn't quite work as …
I/O writes
Hi Art, These stats are of a primary node in HDR cluster with 1 secondary and 2 RSS nodes. Does HDR also has non-blocking checkpoints?…
HDR
Hello, I'm getting ready to set up Informix HDR between our primary server and our secondary server at our D/R site. We are running Informix 10.00.HC5 on HPUX. Both servers are HP 9000 systems (rp7410). I've been getting some ideas from another University who has implemented HDR…
Reverting from 11.X -> 10.X using onmode -b does n
The online log is telling you why it won't revert: 16:05:47 "Database ace_test: Must drop spl/udr (oapi_rp_cc_and_pin) before attempting reversion" 16:05:48 "Database ace_test: Must drop spl/udr (iol_update_rp_pin) before attempting reversion" 16:05:49 "Database ace_test: Must…
HDR recovery in asynchronous mode
So can someone tell what is "dr.lostfound" for? Is there something related to "dr.lostfound" w.r.t. HDR recovery…
RE: max pages allocated issue
Fernando Nunes wrote: > Neil Truby wrote: >>>> "Floyd Wellershaus" <floyd@fwellers.com> wrote in message >>>> news:mailman.110.1246489338.4791.informix-list@iiug.org... >> Thanks. >> The answer however is that removing the indexes won't help. According >> to Informix support, who…
max pages allocated issue
"jrenaut" <jprenaut@yahoo.com> wrote in message news:ef7ea59b-1514-4216-83a1-fd2f0b8c9564@f30g2000vbf.googlegroups.com... On Jun 30, 11:51 am, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Hi, > We've ran into this problem before, where we hit the limit of the number > of pag…
SQLTRACE on HDR Secondary
Is there a trick to get SQLTRACE to work on the HDR Secondary. We use our secondary for some read only applications and would like to be able to analyze the queries with SQLTRACE. This is for HDR, but also wonder if SQLTRACE works for RSS and SDS Read Only Secondaries? IDS 11.…
Re: Index fragmentation
About "create index...online" Copied from Article on IDS Support site : http://www-01.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSZ2HS&context=SSP6X2&context=SSVHPS&context=SSHPYE&q1=create+index+online&uid=swg21219742&loc=en_US&cs=utf-8&lang=en " Explanation of…
Corrupted index
That database is in un-buffered logging mode. we also found error while executing following command: ------------------------------------------------------------------ # oncheck -cdr hrms:org.messages Validating IBM Informix Dynamic Server reserved pages Validating PAGE_PZERO..…
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 …
connect through java using group_name con mgr
Hi Kamran Regarding to your first problem. Onstat -g cmsm should display information feeding by your cmconfig file. Basically, it will display SLA and FOC rule. So it will not display information from your sqlhosts file. About your second problem. You used the wrong port number…
Monitor HDR
Informix 11: We run HDR and I see waits on logbf0, logbf1. I think it's something to do with log shipping to secondary node. Is there a way to look at to make sure that log shipping is not the issue why I see some of the high response times on the user sessions. How can I monito…
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…
Tables of type raw
Is there a way to create a table with type raw on HDR primary? I get the following: 19844: Tables of type raw are not allowed in a logged database on an HDR primary server.…
Re: Building Indexs on Primary Server
On Feb 5, 10:19 pm, Mo <mohitanch...@gmail.com> wrote: > On Feb 5, 12:15 pm, e...@herber-consulting.de wrote: > > > > > On Feb 5, 7:20 pm, Mo <mohitanch...@gmail.com> wrote: > > > > On Feb 4, 10:36 am, e...@herber-consulting.de wrote: > > > > > On Feb 4, 6:30 pm, Mo <mohitanch...…
Re: Building Indexs on Primary Server
On Feb 4, 10:36 am, e...@herber-consulting.de wrote: > On Feb 4, 6:30 pm, Mo <mohitanch...@gmail.com> wrote: > > > Informix 11: > > > We have HDR servers, I am seeing that creating an index on table of > > 100M rows takes more than 16hrs. Could it be because of HDR secondary > > …
Building Indexs on Primary Server
On Feb 4, 6:30 pm, Mo <mohitanch...@gmail.com> wrote: > Informix 11: > > We have HDR servers, I am seeing that creating an index on table of > 100M rows takes more than 16hrs. Could it be because of HDR secondary > server trying to build the index at the same time? We have PDQ > …
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?…
Re: BTS index on HDR Secondary usable?
Obnoxio The Clown wrote: > Jim Tranny said: >> Has anyone else seen this? We're using IDS 11.50.FC2 (Linux). I >> created a BTS (Basic Text Search) index on the HDR primary, expecting >> to see it being created on the HDR secondary as well but the index did >> not get created. …
Re: BTS index on HDR Secondary usable?
Jim Tranny said: > Has anyone else seen this? We're using IDS 11.50.FC2 (Linux). I > created a BTS (Basic Text Search) index on the HDR primary, expecting > to see it being created on the HDR secondary as well but the index did > not get created. I can see that the index 'shou…
Re: BTS index on HDR Secondary usable?
On Thu, Oct 16, 2008 at 3:23 PM, Nilesh Ozarkar <nilesho@us.ibm.com> wrote: > >> Re: BTS index on HDR Secondary usable? >> >> Jim Tranny >> >> to: >> >> informix-list >> >> 10/16/2008 12:53 PM >> >> Sent by: >> >> informix-list-bounces@iiug.org >> >> On Thu, Oct 16, 2008 at 12:14…
Re: BTS index on HDR Secondary usable?
> Re: BTS index on HDR Secondary usable? > > Jim Tranny > > to: > > informix-list > > 10/16/2008 12:53 PM > > Sent by: > > informix-list-bounces@iiug.org > > On Thu, Oct 16, 2008 at 12:14 PM, Jim Tranny <jimtranny@gmail.com> wrote: > > On Thu, Oct 16, 2008 at 11:58 AM, TBP <theBP…
RE: BTS index on HDR Secondary usable?
Sorry to top post. What's to stop you from configuring something to manually update the BTS index on your secondary? I'm shooting from the hip, but I think you could put together something of a kludge that would work. > Date: Thu, 16 Oct 2008 14:39:01 -0400> From: jimtranny@gmai…
Fwd: BTS index on HDR Secondary usable?
Thanks Mike! So there's the proof that I didn't RTFM closely enough ;) BTS + HDR don't mix. ---------- Forwarded message ---------- From: Michael Lowe Date: Thu, Oct 16, 2008 at 2:02 PM Subject: Re: BTS index on HDR Secondary usable? BTS is not supported in any replication e…
Re: BTS index on HDR Secondary usable?
On Thu, Oct 16, 2008 at 12:14 PM, Jim Tranny <jimtranny@gmail.com> wrote: > On Thu, Oct 16, 2008 at 11:58 AM, TBP <theBP@usenet-news.net> wrote: >> Jim Tranny wrote: >>> Has anyone else seen this? We're using IDS 11.50.FC2 (Linux). I >>> created a BTS (Basic Text Search) index …
BTS index on HDR Secondary usable?
Has anyone else seen this? We're using IDS 11.50.FC2 (Linux). I created a BTS (Basic Text Search) index on the HDR primary, expecting to see it being created on the HDR secondary as well but the index did not get created. I can see that the index 'should' have been created sin…
HDR systems
Informix 11 Is there a way to determine which system is currently up among HDR secondary or primary?…
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…
log replay position is falling too far behind RSS
Hello all I am getting following error message in online.log file "log replay position is falling too far behind RSS Source" Can any one explain the reason of this message and suggestions for removing this resolving this. Thanks…
Copy instance + RSS
HI Using IDS 11.50: First of all we have an instance called idsrestore inside a machine P550. Were trying to have other instance with same information now called idsrestorebkp at the same machine P550. At the same time we want to start the RSS replication mode. We used at the …
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…
basic logical log question?
Regarding the OP first question: - No... Try to keep your logical logs on a separate dbspace (not in rootdbs). It's a good practice. I'd also suggest you to keep them the same size as this can facilitate managing and monitoring. As for your questions...: - 11.50.FC1TL?! "TL" as…
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…
Re: active-active DB
Mohit Anchlia said: > As far as I remember from presentation it's something like HDR, only that > the other node is not read only. It could be used to update data. ER can do everything HDR can do (and more) but in update-anywhere mode. This is old technology. With Redirected Wr…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
RE: HDR on IDS WE
Has anyone added HDR to a WE instance. I was wondering on what the process is once licenses have been purchased. Is there HDR software that you download to install on top of a WE installation or what? Once it is installed, does it operate just like EE when setting up HDR? Larry…
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 …
Informix Continuous Availalbility Feature Demo
This marketing video of IDS HDR, SDS, RSS and Updatable Secondary Nodes came in on my Google alerts this morning. http://www.cocktail-server.com/informix-caf/ Andrew…
Create Index Mysteriously Slow at the End - IDS 11.10.UC2W2 - Red Hat EL5
Andrew Ford wrote: > From: <jprenaut@yahoo.com> > >>If you are always catching the flush_sub threads with this stack, then >>they have submitted an I/O request to the KAIO threads > > > I thought it would be interesting if I disabled KAIO and went with AIOVPs. > > Totally differe…
Execute HPL
Hi all ... is possible execute HPL in Informix HDR ??? Thanks _________________________________________________________________ Descargá ya gratis y viví la experiencia Windows Live. http://www.descubrewindowslive.com/latam/index.html…
HDR Performance
I want to know - How to measure/estimate the Network Bandwidth for a HDR pair over a WAN ? - What will happen to the performance of the Primary server if Network slows down ? - If Primary fails during high trasaction processing will the Secondary be in Sync - Are there too…
Informix HDR and ER
Dear All, I am in the process of setting up Informix HDR on IDS 11. I need your inputs and assistance. Can you please give me the steps to configure HDR. Also would like to know whether the main requirement for HDR is two servers with identical configuration or can we setup HDR …
replication HDR
Hi, Last night I recycled informix engine 10.00 FC7 (which is also primary in hdr pair) and brought back up in half a minute. It sent replication failure immediately on secondary server online message. but when I brought primary back online, it gave this message in online: DR: F…
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 …
IDS 11 RSS promotion to a primary in DR
bill.abler@gmail.com wrote: > We are in the process of considering an IDS 11 upgrade. We'd like a > setup that addresses both High Availability, HA, and disaster > recovery, DR. We currently are on IDS 10 with HDR only. I am in the > process of proposing a business case of hav…
One temp space fills and 4gl fails
Everett -- This is the primary server in an HDR pair, could that have something to do with it not filling the temp table round-robin?…
backup replicated database
Hi, Can somebody tell me if replicated (read-only) database on HDR can be backed up ontape? or is it only primary can be backed up? Thanks, Sunita…
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…
HDR questions
Couple of questions on HDR for the wise. We are at the testing stage of an ODBC-based application and want to test failover. HDR was working fine until I shut down both the instances and set DRAUTO to 1 on both sides; now the primary and secondary just say they can't find one a…
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…
HDR to more than one secondary
Client wants to do HDR to two backup servers. Can this be done? They're going to be on 10, possibly moving to 11 Q3-ish 2008. Thanks Andy…
Informix Engine not starting
Can you please try to increase Physical & Logical log file sizes in Onconfig.bnm Thanks Tara…
HDR quirk?
IDS 10.00.UC4 RedHat AS 3 U 8 Re-org a table under HDR with the following quirky result: tab_b created like tab_a with new extent sizing tab_b loaded from tab_a without indices create one index on tab_b applications accessing HDR secondary stopped applications accessing HDR pri…
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 …
HDR recommendations
Could somebody tell me their experiences about HDR. I am reading about HDR to see where we can improve. We ran our tests and the performance was less than .5 of what we generally get. Do things like log file size make difference ? Would increasing memory help ? We have huge blobs…
RSS Feeds for Product Lifecycles
I don't know if everyone was aware of this, but you can subscribe to product lifecycle RSS feeds here: http://www-306.ibm.com/software/support/rss/db2/index.html Gotta love that FUCKING DB2 BRANDING though! :o( Grrrrr...... A more conventional summary is here: http://www-306.i…
Assert failure
Version: Informix 10 We saw following error: 22:18:32 Maximum server connections 489 22:18:56 Logical Log 360070 Complete, timestamp: 0xbdeddf86. 22:19:13 Assert Failed: read_record: decompress_row, source = 0xc00000001293901 8, target = 0xc00000001e7ea4a8 22:19:13 IBM Info…
HDR or storage remote mirroring, which is better?
I like to make a Diaster Recovery system, and just wondering which system I should choose:Informix HDR or storage remote mirroring . storage company told me that remote mirrroring can copy primary server's modifying block to the secondary server immediately. The functions that r…
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 --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
DDL with HDR
We have an Informix 10 system with an HDR mirror, and we are having trouble with DDL statements getting "non-exclusive access" errors. We have a piece of software that is used by many organisations, and each organisation has a seperate database on the server. When we have a new …
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…
Accessing the repository
Hi the home page of iiug.org has changed . To access the repository, look at list of Resources on the left of the screen . Software Repository is right below IIUG RSS Feeds Peter Wages…
IDS down while log back. is it a bug?
The 'onstat -l' showing it's a HDR secondary server. Wondering, are you trying to log backup on secondary server? When you use HDR, you must back up logical-log and storage spaces only on the primary database server. -Sanjit Chakraborty…
HDR Transaction
Hi Guys, I got a enviroment with HDR in two AIX maxhines. What is the rule for backup logs in secondary server? I try to start a logical log backup and, the only situation it was finished with sucess, the secondary server was turned to standard mode. What is the problem if I don…
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…
changing HDR dbserver names
IDS 10.00.UC5 on RHEL3 2.4.21 kernel Is it possible to change the dbserver names used for HDR without reinitializing HDR? For example, a while ago I initialized HDR like so: physical restore of serverB from backup of serverA onmode -d primary serverB onmode -d secondary server…
HDR Question
>From IBM Informix Tech Notes, why would you want to do this? Problem This article describes how to disable parallel clearing of the physical and logical logs on the secondary of a HDR pair during its logical recovery. Solution Q. How do you disable par…
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…
RE: online log on build HDR and after
The other workaround is: 0) SET LOCK MODE TO WAIT; <- To let the session wait until index transfer finishes 1) Create table A 2) Create index on table A 3) Lock table A 4) Unlock table A 5) insert data into table A -Alexey -----Original Mes…
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…
HDR questions
> What about backing up without marking the database as backed up? Isn't > that a new feature of informix 10? ontape -F in think. > > Would this allow a backup to be done on the secondary, because it isn't > updating the system tables? > > > > Yes you can run ontape on the secon…
RE: HDR and Indexes
Hi, Madison, What specific issue are you talking about? Slow index replication during the initial index creation, when Primary can't do transactions while it is replicating index to Secondary? My understanding is that the slowness of index replication is mostly due to the fact,…
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…
HDR and Indexes
Most of the folks using HDR know about the create index issue. Can I have honest reaction on this issue? Thx…
Re: Need info on blobspace blobs
We use blobspace blobs. Recently we have decided to implement HDR for that server. Now we are looking for a way to replicate our BYTE columns. It will be very useful for us if HDR can support blobspace blobs. Madison Pruet wrote: > I need an idea of the number of customers who a…
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/…
Message from the SIGman re RSS
Greetings and apologies for those of you who monitor many groups and thus will get multiple copies of this message. IIUG has implemented RSS feeds for all the Special Interest Groups. This means that you may now monitor SIG discussions using your favorite RSS reader, or manage t…
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.…
HDR on win2k
Hi All, Is anyone out there successfully running Informix 9.4 HDR on win2k (with tape backup or with out tape backup systems). I am getting an error "unable to change server type" after I type "onmode -d secondary pri_server_name". Thanks, Bes…
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: Defrag large fragmented table in 7.32
Coming in v.Next. I seem to remember seeming something about online upgrades whilst HDR is in use for v.Next but I can't find the slide again on IBM's website...…
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 …
RE: HDR Sync/Async mode
We've run HDR in sync mode across a dedicated link, didn't notice any performance issues.…
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…
HDR Sync/Async mode
Could I do a quick survey to see how many folks are using HDR Sync mode and how many are using HDR Async - and why? Thanks M.P.…
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…
Fied wtlist gt 0 _ onstat -k
Hi Masters: What is the query to get wtlist > 0 onstat -k IBM Informix Dynamic Server Version 7.31.UD7W4 -- On-Line -- Up 2 days Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 80e20b70 0 cd6a6f08 0 S 100002 204 0 820b9958 d62b1a38 d62b4cd8 80e2d280 HDR+X b0001…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
return code 164 during logical log backup
Hi all, I have following kind of problem with logical logs backup: When the current logical log is comming full, it does'nt make logical log backup and in online log of informix following message appear: -------------------------------------------------- 16:13:14 Logical Log 524…
Re: IDS cluster
IDS require that writes complete in a certain order (write ordering) i.e. logical log data gets written before data/index pages. With multiple parallel writes and IDS making sure writes to one chunk (containing logical logs) complete before writes to another chunk (data/index) h…
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.…
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…
PANIC
Is there another solution for this problem before trying to restore from backup/archive?. LINUX/IFX 7.31.UD1. 10:11:22 Informix Dynamic Server Initialized -- Shared Memory Initialized. 10:11:22 Physical Recovery Started. 10:11:22 Physical Recovery Complete: 64 Pages Restored. 10…
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
Update Statistics & dbspace not clearing
Let me get this straight... Your programmer says that the table(s) and indexes are growing without limit because the space from deleted rows is not reused for new data within the tables? And he says that if he changes the app to run update statistics periodically it will release …
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…
HDR problems
Hello , Iam doing a HDR for 2 informix servers on HP-UX :- Informix Dynamic Server Version 7.31.FD6 -- On-Line -- Up 33 days 07:46:25 - - 661824 Kbytes But when I was doing a ontape -p on secondary server , it showed or asked me "do you want to restore a level-1 backup ?" ...I …
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…
Replication question...
I'd definitely agree with that. I think Smart LOBs are replicated in HDR when they are logged, but they are so slow we can't use them with logging on! Regards, Donny superboer wrote: > > enable HDR for (s) blobs in sbpaces and blobspaces. >…
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…
IDS 9.30.TC2 Database Corruptions?! Help!
Now take a good current backup. More than likely, the oncheck found and repaired the errors Informix detected in the data and/or indexes. Everything is likely to be OK now. I suggest you monitor the logs several times daily now. Perhaps you could write a script that looks at the …
Re: Restoring a level-1 backup at a later date?
To all those who suggested we use HDR for this; there was a small bell ringing at the back of my mind and eventually I worked out why. You CANNOT USE HDR TO REPLICATE BLOBSPACES!!!!!!!!!!!!!!! (At least in IDS9.30 anyway). Why oh why oh why the hell not? Malc (seething 'cos we'd…
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…
Index corruption
Known problem, happens when index size (in particular, part of index pages allocated among previously-used pages) is bigger then 3/4 of the physical log in HDR environment. HDR/secondary is triggering an infinite checkpoint by 'physical log fullness' Fixed in 9.40uc4w4, 9.40uc5…
HDR issues
All, I had a peculiar problem with HDR last night. We had a software = upgrade, which made some changes to the db schema (columns added, indexes created). In order to = facilitate this,=20 I shut down the secondary server until the everything was complete. = When I started up th…
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 …
HDR feedback
Just a little bit of feedback (for those interested). A while back I posted a reply to an HDR mail, saying that we have loads of problems with HDR, and I was about to give up on using HDR. We kept loosing the link between the 2, and I kept rebuilding the secondary server. W…
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…
HDR Logging
Hi, I need to configure HDR on two IBM AIX servers running IDS 9.40 I cannot use Transaction Logging. Will HDR work without having Bufferd/Unbufferd logging enabled? Thanks Trevor…
HDR question
Hi all, Is there anyone know which SMI table keep track of the Last DR CKPT info? sysdri tables from sysmaster database doesn't contains the info. I need to know what is the current log id that being replicated to the secondary server. Informix Dynamic Server Version 7.31.UC2 …
HDR Interval
Hi, I'm wanting to implement HDR between two IBM AIX servers running Informix 9.4 UC3. I have 53 (2mb) logical logs. I've been asked to have a replication period of 1 hour DRINTERVAL of 3600. We do an ontape -c on the primary server. Would there be a problem if all the logical …
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: HDR unusable with 9.40
Some good news on subj Informix support told me, that bug# 167294 is fixed in 9.40uc5 and patch release 9.40uc4w4 (Intermediate release, not fully tested) IBM opened 9.40uc4w4 for download for me, and I was able to re-run my index creation tests under 9.40uc4w4 ( in exactly the…
RE: HDR unusable with 9.40
Ajay, Thank You very much for pointing to the major reason: physical log size I took a look at the 'onstat -a' output I made on both servers when I first noticed the problem: Physical log was 78% full on Secondary. That means, that blocking checkpoint was triggered by the 75% …
FW: HDR unusable with 9.40
Ajay, Thank You very much for pointing to the major reason: physical log size I took a look at the 'onstat -a' output I made on both servers when I first noticed the problem: Physical log was 78% full on Secondary. That means, that blocking checkpoint was triggered by the 75% …
Re: HDR: MULTISET gives -626 on secondary
This is a limitation on using extensibility on HDR secondary. I think workaround mentioned in release notes will work (provided you wait for DRTIMEOUT after running the query on primary).…
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…
HDR using encryption with CSM ??
HDR is using full duplex protocol. The CSM is using half duplex. That means that HDR can not be using encryption. "rvb" <rvbon@gmx.de> wrote in message news:6e9a0040.0407060058.a949384@posting.google.com... > Madison, > > I isolated HDR communication with option s=6 as follows…
HDR on Windows 2000
Has anyone tried HDR on Windows 2000. Is it even available. Version can be either 9.3 or 9.4. Thanks. Ravi…
RE: thank you IBM
"Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message news:cai8sl$11k$1@news.xmission.com... > > > > > -----Original Message----- > > From: Madison Pruet [mailto:mpruet@comcast.net] > > > > > > "rkusenet" <rkusenet@sympatico.ca> wrote in message > > news:2iu0r7Fr1n5fU1@uni-…
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 …
HDR Question
Officially, you need identical engines and operating systems to use HDR. However, during an upgrade, we tested and used HDR between identical 7.31 versions with the primary on solaris 8 and the secondary on solaris 7. Has anyone tried using HDR between 9.40 versions, one on sola…
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.…
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: Whatcha' wanta have?????
How much is Madison paying you? LOL Rob Vorbroker --- Ben Thompson <ben@nomonitorsoftspamthanks.com> wrote: > Art S. Kagel wrote: > > > - Support for multiple HDR replicants. > > This would be a boon for us as it would remove the > need for ER. The > ability to use HDR+ER togethe…
Re: Whatcha' wanta have?????
Art S. Kagel wrote: > - Support for multiple HDR replicants. This would be a boon for us as it would remove the need for ER. The ability to use HDR+ER together is useful but an all-HDR solution would be a nirvana. HDR is just so much easier to use and set up. Ben.…
RE: Whatcha' wanta have?????
See below > From: Art S. Kagel [mailto:kagel@erols.com] > > Keep moving us towards a no-down-time server as much as possible. Such > as (some mentioned by others): > > - Online index build - without locking the table - A dirty read is > used to build the index then logical log r…
RE: Whatcha' wanta have?????
See below > From: Art S. Kagel [mailto:kagel@erols.com] > > Keep moving us towards a no-down-time server as much as possible. Such > as (some mentioned by others): > > - Online index build - without locking the table - A dirty read is > used to build the index then logical log r…
RE: Whatcha' wanta have?????
See below > From: Art S. Kagel [mailto:kagel@erols.com] > > Keep moving us towards a no-down-time server as much as possible. > Such as (some mentioned by others): > > - Online index build - without locking the table - A dirty read is > used to build the index then logical log r…
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…
about HDR
This is a multi-part message in MIME format. ------=_NextPart_000_05EF_01C3BD8A.4C96BEB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there. Is there a way for me to get the HDR kit? Maybe a url to = download? Best regards, Mar…
Re: Disappointing test results from 9.40
"Rich Campbell" <rich.campbell@att.com> wrote in message news:bql0qm$q3c19@kcweb01.netnews.att.com... > Neil, > > I see the same. > > We are using 9.40 FC2 for Solaris 2.8. > > A bug has been opened for my case: > > Index builds taking 50-300 % longer then in 7.31 regardless of a…
Re: Disappointing test results from 9.40
On Wed, 3 Dec 2003 10:56:35 -0500, "Rich Campbell" <rich.campbell@att.com> wrote: >Neil, > >I see the same. > >We are using 9.40 FC2 for Solaris 2.8. > >A bug has been opened for my case: > >Index builds taking 50-300 % longer then in 7.31 regardless of amount of PDQ >resources …
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.…
HDR
hi, We are trying to setup HDR (using IDS 7.31UD3X5a) on NCR UNIX. The two enviroments are configured identically. HDR starts successfully (We also created databases and table and everything works fine), when we try to simulate a failure on the primary (onmode -ky), then the sec…
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…
HDR & backups
Informix 9.30 Solaris 8 We are planning to do the following: Have a primary server, and then use HDR to replicate this server onto a secondary server. Question: Can I do my backups by only running them on the secondary server? I haven't done this before, and 1 question popp…
HDR & backups
Informix 9.30 Solaris 8 We are planning to do the following: Have a primary server, and then use HDR to replicate this server onto a secondary server. Question: Can I do my backups by only running them on the secondary server? I haven't done this before, and 1 question popp…
Re: Clarification on ONBAR restore.....
You could try using HDR - once the level 0 has been restored to the new server (physical restore only) initiate HDR. All logged activity will be replicated to the new server. Once you are happy with the new server, switch it to standard mode, point the users at it, and then you c…
Re: WHY index can corrupted???`
There are 2 cases: case 1 (the "normal" case) The physical log before image (not logical) must be on disk before the changed page is written to disk. case 2 (a performance optimization) For some operations (updates of data rows) the logical log also contains the before im…
RE: WHY index can corrupted???`
Exactly! That is why i asked for KAIO , i am not sure but i suppose that the OS uses an intermediate-volatil cache. And the same happens with Hardware-RAID with cache, but some of these uses batteries. Informix thinks that the data is already written directly to the disk when …
Re: WHY index can corrupted???`
Hi Art, If you are using cache controllers that only write to their cache when the os writes to them, this will definitely endanger your data and index integrity in a crash even with unbuffered log. Informix software assumes that everything that was written successfully to the o…
Re: WHY index can corrupted???`
Art, I think there is a mistake in your argument. You forgot the effects of the phys log and the rollback of open transactions: Before the fast recovery starts all pages from the phys log are put back into their original location. This sets everything back to the state of the l…
Re: WHY index can corrupted???`
Madison, I agree we flush the phy log buf. But do we really flush the logical log buf (except when we do no physical logging in some specially optimized cases)? Michael Madison Pruet wrote: > Art, > > Do you have a repro/case involved where this occurred? We are supposed to >…
RE: WHY index can corrupted???`
Great Explanation Art, What if we add to this scenario KAIO? Would it be a very serious risk of getting data corruption or even lost data ? -----Mensaje original----- De: Art S. Kagel [mailto:kagel@bloomberg.net] Enviado el: Jueves, 28 de Agosto de 2003 01:28 p.m. Para: inform…
Re: WHY index can corrupted???
Hi Art and all, I don't doubt that some of you have observed index corruption in logged databases after system crashes. If this was not caused by faulty hardware or os software that corrupts disk contents directly (index and data pages, log space, etc.) it should be considered a…
Re: WHY index can corrupted???
Art, Do you have a repro/case involved where this occurred? We are supposed to be flushing the physical log buffer and the logical log buffers to disk prior to writing the data page/index page to disk. If there is a case where we aren't, then we should consider it a bug that n…
Restarting HDR
I know i've asked everything there was to this but here's some more. My server is set up for 20 logical log files. Assume the uniq ids are also from 1 to 20. I backed up my instance yesterday night and it has logical logs 14 and 15. I will restore it on the secondary today nigh…
hdr hang
Hello, ids 9.30uc1 on unixware 7.x. hdr seems to be hang when checkpoint increase on my secondary server (>200). I increase drtimeout on primary to the maximum checkpoint value. It doesn't solve the problem. hdr need to be stop an restart frequently. Any possible tuning and moni…
HDR sites
Hi, Did anyone affected by the blackout have the secondary outside of the blackout area?…
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…
HDR , logs
Hi all, (linux, 940UC2) cause of batchjob problems I have to disable HDR during job. The batch job needs ~45 logs with 10 MB, what is the better way, increas size of logs to 20MB or increase logs to 100, I have 50 logs! Thanks Sven…
HDR
Hi, I have an async HDR running under 940UC2 and linux! Wenn I am running a batchjob, a lot of tables are created and some indicies and so on, there is always a DR: Send error created, and some indicies are not transfered to secondary, and because of that some locks not disapear,…
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…
hdr installation
Hi all, I have to identical Severs on Linux and INF940UC2! both have two NIC 1x global LAN, 1x HDR LAN(direct LINK) with user informix I am able to connect from each of them to the other with no password. after HDR restore an the secondary the HDR won't establish. What is wr…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
RE: is hdr on?
Not to worry, Alex. The "Last DR Ckpt" discrepancy is a "cosmetic" bug in some versions. Can't remember the bug number, but it is fixed in later versions. What you see in the message logs confirms that HDR is still running. The "server operational" messages are the keys. HTH…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Re: is hdr on?
Thanks for reply. This is a message log fragment. As if hdr on? --------------------------------------------------------------------------- server1: 12:12:50 Informix Dynamic Server Initialized -- Shared Memory Initialized. 12:12:50 DR: Logs already cleared 12:12:50 DR: Try…
is hdr on?
Hi ! I have 2 Informix servers (7.31UC7) with HDR - server1 and server2. Is HDR on? --------------------------------------------------------------------------- server1: [informix@server1]$onstat -g dri Informix Dynamic Server Version 7.31.UC7 -- On-Line (Prim) -- Up 23 day…
HDR questions
We're running IDS versions 9.21.UC5 and 9.30.UC3, both on Sun Solaris = 2.8 We currently use "smart-blob" dbspaces (sbspace) for xml data storage. = Does HDR support sbspaces? Terrence Mullins Sr Database Administrator WagerWorks.com…
secondary server
hi, i'm using HDR with Aix5.1 and IFX 7.31 i want to make Level 0 backups on the secondary server. can i do it ???…
Informix Disaster Recovery Strategy
All, Thanks for the input. It looks like HDR is the way to go. We have a fairly flexible recovery period and most of the data is entered data enry staff. Now I just need to figure out how to implement HDR.…
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…
hdr not working
Hi, We have a HDR setup here. We rebooted the secondary server and then we could no longer make the HDR work. The error message in the primary server is: 19:18:36 DR: Failure recovery error (2) 19:18:37 DR: Turned off on primary server 19:18:38 Checkpoint Completed: duration was…
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…
what is light append??
Hope I get this correct... Normally when a row is inserted into a table, the existing pages are examined to see if there is a spot within the existing pages that the row will fit. This is done by first attempting to use the last page that an insert was done. Then we examine the…
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…
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?…
In the brown sticky stuff:-))
I've got table I can't read right through, the oncheck -cDI reports WARNING: index check requires a s-lock on tables whose lock level is page. Validating indexes for drug:viagra.order... WARNING: index check requires a s-lock on tables whose lock level is page. TBLspace data…
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…
HDR incremental backups?
Why should only level 0 backups be used with HDR databases and not incremental? Thanks Sue…
Posting from the Informix-list
Hi, I have the following errors in our online message log file, 08:48:59 Assert Failed: Archive detects that page 0x72bc92e is corrupt. 08:48:59 Informix Dynamic Server Version 7.31.UC2XA 08:48:59 Who: Session(63, informix@dp3000b, 18528, 1900152152) Thread(…
logical logs
Hi all, How to find out which session causing the logical logs to fill up. Regards Aboo…
RE: NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2
Matthew Byrne wrote: > > Thanks for the reply. There is a bug in the NOLRUPRIO that is supposed to disable the LRU PRIORITY code. This was fixed in 7.31UC6X1 and I have it and am using that for now since on the server affected here it takes about 4 hours per index to rebuild an…
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…
Server down - Assert failed - Index bad...
Our instance is down!! Errors in the online.log Assert Failed: Page Check Error in btsearch:bad btree node Results: Possible inconsistencies in index 'database:"informix".sysobjstate#objdesc When I run the oncheck -ci I get: Validating indexes for 'database':informix.sysobj…
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, -- ------------------------------------…
Split AIX mirror to bring up HDR replacation
Has anyone split an AIX mirrored VG, to bring up HDR replication. If so what are the steps. -- Kevin H. Hunt khhunt@triplecrownsvc.com…
Questions about sysprofile in sysmaster?
In Informix << Adminstrator reference>> book, It tells me that the table sysprofile in sysmaster contains columns such as llgrecs,llgpagewrites,llgwrites and it wrote: llgrecs: Logical-log records llgpagewrites: Logical-log writes llgwrites: Logical-log page writes 1.What doe…
Logical logs
Hi All, I have a informix database of 7.30 where in the logical log is getting full very frequently. > What might be the reason. I think the "size" / "physize" of each log is > very less. I am giving below the output of "onstat -l". Is there any > parameters in onconfig tha…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
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 and PeopleSoft
Art, It might be worth asking this on the Peoplemix mailing list. > Anyone have any experiences with using HDR or ER with PeopleSoft?…
HDR
Having problems initiating HDR. Platform specifics: IBM RS6000 h70 AIX 4.3.3.0 IDS 2000 9.20.UC3 Archive and Restore accomplished using onbar and the Informix Storage Manager. Problem occurs when trying to restore the archive created from the primary server on the secondary serv…
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…
question
Try backing up the logical logs with ontape. Nona…
IDS replication Solaris->Linux
Madison Pruet <mpruet@informix.com> wrote in message news:38B1A9B9.9183BF5D@informix.com... > ER can be used between solaris and Linux, HDR will not work. What's "ER"? Sorry to be a thicko, but I've only heard of CDR and HDR - and I know that I can't use CDR because of the seri…
System catalogue
Sounds like HDR to me. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
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…
temporary
The secondary in a HDR setup will let you create implicit temp tables. -- Kevin H. Hunt khhunt@hunts.com…
Problem with chunks down
Hi. I�m having some problems on a Sun machine (Solaris 2.6 and IDS 7.30 UC6). We had a problem with disk array, wich caused 2 chunks with state Primary Down (PD) on onstat -d. These chunks were filled only with indexes pages, so we decided to drop the indexes and recreate them…
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…
Excessive Llogging
I am having a problem with what I'll call excessive logical logging. The problem engine, is Informix 7.23 UC7 with HP-10.20 as the OS. When I attempt to duplicate the problem in another instance; there is a difference in pattern of logical logging. A stored procedure loads 100,…
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…
7.31 upgrade problems
I have just tracked down this issue and dropping and re-creating the indexes will help, but only for a period of time. To find out if you have this problem the following select will identify the tables. SELECT trim(dbsname)||":"||trim(tabname) FROM syspaghdr P, systabnam…
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…
Allocating Table Space
In article <378624C0.CB585A56@wsu.edu>, Dale Forrey <forrey@wsu.edu> wrote: > I have a 3.5 million row table with indexes attached. I want to > defragment the table and detach the indexes moving them to their own > dbspace on another disk. ONCHECK pT shows that there are cur…
Re: Several questions ...
> Hi, community > > Are you having a good day? You probably don't really want to know. > I've several question about Informix: > > 1. Anyone know where I can find some information about #users and #licenses > of Informix database product line(IDS, IDS with AD&XP options) vs. Or…
Re: Several questions ...
Dong Xiao wrote: > > Hi, community > > Are you having a good day? Just lovely thank you. > I've several question about Informix: > > 1. Anyone know where I can find some information about #users and #licenses > of Informix database product line(IDS, IDS with AD&XP options) vs. …
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.…
IDS 7.30 Linux ed. - Unpleasant surprise
Hi! I planned to use IDS 7.30 Linux ed. with HDR. But after unsuccessful try to install it I discovered in release notes that replications in IDS 7.30 Linux ed. are not supported at all. (oh, yes for $99 can I expect HDR!?) Any idea when (and if at all) will be replications sup…
HDR and enterprise replication
Does anyone know the difference between HDR and enterprise replication? It seems they both exist in version 7.3, but only HDR is available in 9.14. Thanks in advance, david.tamburin@protegrity.com…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Logical Log
This is a multi-part message in MIME format. ------=_NextPart_000_0084_01BE5CC0.3EFB85E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear User, I have been trying to get a large file loaded on a database with = transaction loggin…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
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…
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…
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 …
Re: no logging database - long transaction aborted
On Thu, 30 Jul 1998 16:05:31 -0400, Family Jurkovic <jurkovic@ican.net> wrote: >lblau@my-dejanews.com wrote: > >> I am trying to build an index on a very large table (> 1,000,000 records). >> The database is in "no logging" mode and the table is locked in exclusive >> mode. I am…
Re: no logging database - long transaction aborted
lblau@my-dejanews.com wrote: > I am trying to build an index on a very large table (> 1,000,000 records). > The database is in "no logging" mode and the table is locked in exclusive > mode. I am getting an error: 458: Long transaction aborted. > > Does anyone know what else coul…
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…
HDR
Hi I am trying to establish HDR between to of my 7.23UC7 Informix servers. I can connect the primary to the secondary vice versa, but my secondary server is sleeping forever on recovery. Following are the outputs from the 2 servers: Primary: 10:28:03 DR: new type = primary, se…
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.…
Numeric codes for the page types
Hi, advanced users/admins. I am writing a program to dump pages in a format I like. However, it would help if I could easily identify the page types by the value in the pg_type member of the page header structure. I have been able to conjecture some types: OnLine reserved Page…
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…
HDR
Recently we encountered a similar problem. Our primary DB was running on an HP K9000 (120Mhz) and secondary DB on an HP K9000 (180Mhz). After many OS upgrades (recommended by Informix support), the problem was still not resolved. We then moved the primary DB to an HP K9000 (180…
HDR
I have a question about HDR on the Informix online workgroup server for Unix v. 7.12 (irix). We have completed the preliminary tasks -- Both machines are O2s running Irix 6.3, We replicated chunks and dataspaces identically on the second machine, assigned a temp dbspace on both …
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
logical logs
Hi I am running Online 7.23 on HP 10.20 Why was logical log backed up every 2-3 minutes? Is there any hint not to make that backup too fast? Here is the info... 11:07:08 Logical Log 608 Complete. 11:07:09 Process exited with return code 133: /bin/sh /bin/sh -c /usr/informix/…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Share Mode Locking Problem...
>} Oracle works the same way as Sybase and *is* number 1 :-) Wrong ! Sybase uses an optimistic strategy, where requests are optimized for commits, not rollbacks. Oracle uses a pessimistic strategy, where requests are optimized for rollbacks, not commits. This means that Sybase r…
Re: Questions on INDEX(ES), TEMP DBSPACES and ONCHECK(S)
In article <344CDF6D.83F@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: >> >> Hi everybody. >> Some very general questions on the above topics ( not necessarily >> related ) >> >> >> …
Re: Questions on INDEX(ES), TEMP DBSPACES and ONCHECK(S)
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > > Hi everybody. > Some very general questions on the above topics ( not necessarily > related ) > > > TEMPDBS: > 1. what is the difference between having multiple dbspaces ( on > diffe…
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: How fast is fast recovery on V5
Subject: How fast is fast recovery on V5 From: John Clutterbuck <jclutterbuck@sbs.siemens.co.uk> Date: Fri, 11 Apr 1997 23:38:52 +0100 Message-ID: <334EBD7C.75ED@sbs.siemens.co.uk> >Hi > >We have been waiting 7 hours for a recovery to complete from what looks >like 3.75 log file…
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 …
Re: PHISICAL LOGS configuration
The inconsistency that you are pointing out is because it's really impossible to exactly determine how much log space you really need. The determining factor is really how much your typical transaction is going to update. For performance issues, the total logical log size is no…
Re: "Transaction too long", but
>> I want to create an index on a table which contains 25.000.000 rows. >> The index is of the type "varchar" with a max. length of 60 bytes. >> >> Because I got a "transaction too long" error, I turned logging off. >> Nevertheless I got the same error again (error-no. 458). …
Re: Fail Consistency Check -- newmode
No it does not necessarily mean your data is wrong. We have seen this message before. Are you using raw device? What might happened is the physical page on your disk next to the last page of table (partnum 0x03000003) is not being used, this page may contain garbage data, but so…
Re: Fail Consistency Check -- newmode
Kevin This usually means that there is something seriously wrong with the data. Are you checkpoint ok or does the same error occur in informix.log ( or whatever you have called it ) ? Running tbcheck -ci <database> will check the indexes. This would be good If you can find no …
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: Logical log write volumes
Andy Kent (akent@cix.compulink.co.uk) wrote: : > The calculation should be something like: : > : > 16 bytes + rowsize for each row inserted : > 16 bytes + indexsize for each row/for each index on the table : > (these numbers might be +/-4 in either direction) : > : >…
Re: Logical log write volumes
[Re: how much logical log space is used by an INSERT-intensive program] >If the minimum unit of work is a page, won't it be one page per insert >with unbuffered? And if you do ten inserts to the same page, won't that >mean only one *disk* i/o with buffered (as long as all ten in…
Re: Logical log write volumes
>Andy Kent writes:- >> Can anyone tell me how you work out how much gets written to the logical >> logs during an insert-intensive application? The calculation should be something like: 16 bytes + rowsize for each row inserted 16 bytes + indexsize for each row/for each inde…
Re: tbtape question
> > > Surely, 're-extenting' tables will effectively shrink them. As I > understand it tbunload/ tbload work at page level, so the only defragging > that won't get done is that within pages (of which the only examples I > can think of are pages with deleted rows, reallocation of …
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…
Re: Question About Productivity & Speed
->From: snd@inwest.donetsk.ua ->Subject: Question About Productivity & Speed ->Date: Thu, 19 May 94 13:49:31 GMT ->Reply-To: snd@inwest.donetsk.ua ->Organization: unknown -> -> Hello, Colleagues! -> -> Perhaps it's sound like newbie ( I'm ) questions, but ->problem …
Logical Logs
>Sender: news@srgenprp.sr.hp.com (News Administrator) > > We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. > Our tbconfig said LOGFILES 6 >>>>stuff deleted > LOGSIZE 500 > My question is: Is there an optimum balance between LOGFIL…
Re: Bage Pagenum
In article <2mpp7s$cu7@emory.mathcs.emory.edu>, naomi@anasazi.com (Naomi Walker) says: > >I have never really nailed down how exactly to read this error report. >From other clues in our system, we have pretty much figured out who is >the offending table, and rebuilt it. It appea…
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 …
HDR and Blobs
IDS 9.4 on HP-UX 11.11 We have been trying to get HDR running, and we have blobs located in blob pages. The following pages from the Admin Guide make it clear that blobs in blob pages will not be replicated. It does not seem to say that you can't use HDR, simply that the blobs…