Oninit® Archive
Results for “OFF_RECVRY_THREADS”
Upgrade 11.50 to 12.10
Many Thanks Andreas for your suggestion. I am quite lucky at this site as I am using NetApp snapshot functionality. This provides Instant Backup before the upgrade and Instant Recovery in the event of a failure during the upgrade process. regs Mark…
move database to another dbspace
sounds like something Table Level Restore (TLR) could handle, you just have to go table by table. Mark…
Re: Restores
On Mar 23, 5:50 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > I note that there are different code streams now between IDS Workgroup and > Enterprise Edition. > > And I've just tried to restore an 11.5FC6 EE archive onto a test server > ..... > > ontape -r -t STDIO < /scratc…
Informix: oncheck -pr in Fast Recovery mode
Actually, folks, I was wrong about the HA situation. It had been refreshing from an archive, which also displays "Fast Recovery" mode. Hence my error. The recovery failed, leaving the server in that fake Fast Recovery state. I have opened a ticket with HCVL over the grossly m…
External backups/restores and logical restoring of logs passed last Level-0 backup
Thanks Art. Yes, indeed it works. We have tested it with ontape, onbar and external backups. Logical logs are independant and you can restore older backups, or external backups, and restore logs passing other backups. Best regards, ------------------------------ Jose ------------…
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
Informix 43258 error onbar logical restore
Hello All. I ran onbar -r -p to restore the database which rab successfully. But after running onbar -r -l (Logical Restore) I got 43258 and 43168 error. Please let me know how to overcome from this issue and run the restore successfully. current Informix and OS version: Online.l…
Resync RSS server
Hello, Yes I tried to restart. Andreas, effectively it expects logs from tape 14:39:25 RSS: Start failure recovery from tape ... I'll try a log recovery Thanks ------------------------------ Samuel To ------------------------------…
RSS slowing down
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Today we have a RSS replication slowed down. I mean not froze but just applying logs slower than the primary filling them. That has not happened ever in working hours. Filling pace was not any unusual for the time. After restart…
12.10.FC15W1AWE Blocked in LONGTX
Hello everyone. How is it possible that 12.10.FC15W1AWE gets Blocked on LONGTX? DYNAMIC_LOGS is set to 2 but the engine was not adding any new logs (although there was more than enough space in ROOTDBS.) onmode -ky was impossible (it just hung) so rebooting the server was the on…
Informix restore strategy
I only can second what Ben already stated: point-in-time (PIT) restore is available only with whole-system restore or with tenant restore (where everything pertaining to the tenant database resides in a well defined set of db-/sb-/blobspaces which then would be PIT restored toge…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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 ------------------------------…
Is it possible to import the copy made with ontape from one database to another PC?
I have tried starting the server with the -i switch but it has no effect. Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized. ------------------------------ G…
Restoring a table to PIT with archecker fails
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Trying to restore a table to PIT I get an error, AC_RESTORE_FILTER is set. Must do physical restore only. CRITICAL ERROR: Unable to initialize extraction With adding either '-lphys' or 'RESTORE TO CURRENT WITH NO LOG' I manage t…
What prevents a RSS to roll forward as fast as its primary?
Doug, The fact is that the replica rarely lags behind the primary during regular activities. This usually occurs when an operation is performed on a large table, such as repacking the table or building an index. Would increasing OFF_RECVRY_THREADS help in this case? -------------…
Replication of Informix
Hi Kirit, I am only simulating replication between Primary and Secondary. The primary is online state and secondary fast recovery, The primary is not able to connect to the secondary and vice versa. This is the discussion here to sort the issue. Now, i am surprised when you said …
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
restoring informix using the onbar command. problem
If you are confident that the data has been safely restored, then I would try to initiate the restore from TSM and see what happens. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com --------------------…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
archecker utility on ontape level 1 archive
Hi Arjen, Are you first restoring level 0 and then level 1. As far as i know, Archecker refer the L0 backup as baseline and perform log rollforward restore until given time which is from L1 backup. Or you are directly restoring from L-1 backup? Regards, Gaurav -------------------…
HDR
The onmode -d secondary <primary> MUST be done after the physical restore is done and BEFORE any onmode -m or oninit commands are executed on the restored server. If you do not do this, there will be activity in the logs of the restored server and you will not be able to establi…
Validate backup : archecker –tdsv and CommVault
Try –b. Commvault uses onbar AFAIK. You used –b in the restore command Cheers Paul…
ontape error
Hi Kirit, I have done the initialization of root device and even after adjusting the settings on $ONCONFIG for new server, When I try to bring it up I get errors: 17:14:38 Physical Recovery Started at Page (1:263). 17:14:38 Physical Recovery Complete: 0 Pages Examined, 0 Pages Re…
Is it possible to perform onbar backup/restore between heterogeneous platforms?
I think it has got tighter, but I have restored with minor version differences in the past.…
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
Informix 7.30 failed to start
I am maintaining a legacy system using informix 7.3. The system has crash recently. At the start of oninit, the logs file shows that there is an error after logical recovery process. Also from oncheck -cR there are invalid entries in the logical log. Is there anyway to skip logi…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Updatable Secondary (RSS)
P.S. If, after observing the log message that all transactions have been completed, I immediately down the server, edit the ONCONFIG to "UPDATABALE_SECONDARY 1", and then restart the RSS, it comes up the same. Perpetual Fast Recovery, and no "Finished with transactions" message.…
how to change the default location of rootdbs
I think you should be able to do a cold restore from backup, and use the -rename option of 'ontape'. DG…
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…
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
How to Restore Level 1 backup after level 0
Its means if i restore level 0 via ontape -r,and it completed successful. now after sometime someone said to restore level 1 too. i can do it via ontape -d ?…
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.…
Server restores
Hi All, I'm cutting my teeth on doing back up and restores. Today I did a full system restore from or production machine to a new machine we will be using as the back up after more testing is done. Today I used the command /opt/informix/bin/onbar r to restore the the server and …
Retoring the onbar backup
Hi friends, I want to restore our onbar backup from linux server to windows server, our onbar backup is scheduled through OAT.what is the procedure to restore?. Please help me on this. Thanks…
Archecker single table restore compressed ontape
Thank you Mike for the fast response. Physical restore will do for me, I'll try to restore it in a dump file or external table and get back with the results. Thank you. Aleksandar…
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…
Secondary stuck in Fast Recovery
Ok guys, I need your help again ugh. So I have this dev setup Ive been working on. Sounded simple. I have two Version 11.5F9DE instances running with a primary and secondary set with HDR replication running. I wanted to try a FULL and DIFFERENTIAL backup and restore on the pri…
Issues With Restore
Hi, this is a dev box. I made a backup and am now trying a restore, which has gotten me into a circle of issues I used ontape -p and it asks for the file, I say y to restore, n to logs, n to differential backup etc. I actually have a level 0 and level 1 backup, but just want to …
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
HDR Implementaion
But the issue is not solved still my secondary server is in Fast Recovery mode. I had run onmode -m. but still no use. I had used ontape -p to restore in secondary. Could you help me to move forward.…
how to monitor alter columns on a large table
Ok, I have stopped the operation, by onclean, and when I restart the instance , It's now on recovery, should the recovery take as long as the operation does?…
onbar restore problem
Hi, I use onbar to do the redirect restore. and I see below message twice, why? thanks for your time . Clearing the physical and logical logs has started Cleared 263968 MB of the physical and logical logs in 392 seconds 1) run "onbar -r -rename -f ./list.txt -t "2016-10-09 23…
onbar -r -l -X problem
Below are the message log in the online.log, my IDS version is 12.10FC6. 11/01/16 01:48:56 Resuming Logical Restore 11/01/16 01:48:57 Suspending Logical Restore 11/01/16 08:25:48 Resuming Logical Restore 11/01/16 08:25:48 rsrecvr.c 5028 set EOF 11/01/16 08:25:49 No logical log r…
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
Failed to recover the logs after restore
Thanks Art. I've restored from our backup and works good now.…
ISM restore problem
It appears that ism /onbar are not able to restore a recent backup from another machine this way. The new machine, not member of any domain, was not able to restore from a backup of about 620 files and a size of 1.2TB…
restore evolution
Hi i launched a restore with ontape, and i want to see its evolution, to estimate how much time it would take. thank you in advance…
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Fast recovery slow
Hi, My environment is Informix 11.70 FC8W1 on HP-UX 11.31. I shutdown a server with onmode -ky. There was a "heavy" transaction in progress. After running oninit -v, and after an hour, I see that the instance is still in "fast recovery". With onstat -u, I see that there is a thr…
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)…
oninit taking ages
Folks, this is a VMWare ESX 5. (I'll have to check) Box has 32 Gb configured I have a 2K bufferfool of 8 Gb and initial shmvirtsize of 6 Gbb (I know, it's huge but some applications pull hard on shmvirt). There was effectively some transactions are shudown, but only 4 pages Phy…
Informix Fail to Online
Hi, Our informix instance crash after server restart.refer below error message. 10:08:49 IBM Informix Dynamic Server Started. 10:08:51 Segment locked: addr=c00000000fb1a000, size=643399680 Thu Apr 16 10:08:52 2015 10:08:52 Event alarms enabled. ALARMPROG = '/usr/informix/etc/…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
Root db space fills up
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
restore question
Hi all, Is it possible to restore a backup from a 3rd party (Netbackup) into a new FS and get it the data from there using onbar?…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
Fast recovery problem
Hi, We did have database which was in nonloggin mode and checkpoint did hang. We shutted down the informix and started it up. When we started the informix, it did perform Fast Recovery. Last checkpoint was 14.8.2014(DMY) 03:00 and this happended 15.8.2014 17:49. So all that day …
fast recovery
Aix 6.1 IDS 11.70.fc3 Had a transaction reach the long transaction HWM after running for about 5 hours...I know .. error in the sql statement to switch the table to raw before doing this mass delete .. anyways ... attempted to onmode -z sessionid .. that resulted in the engine g…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
Page is corrupt during onbar
who has this problem in the future the solution was to restore the table.…
Fast Recovery (CKPT REQ)
Hi there, There was a electricity failure in my data center and my informix database server was also down. After restarting the DB server, we are facing following errors in the online.log file and below is the output of (onstat -) command: #onstat - IBM Informix Dynamic Server V…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
Database in (LONGTX) need identify case user
Hi All, i have informix 11.70.FC6X5 some time database hang with LONGTX can i track the case user at this point and is there any way to avoid this issue also in this point if i restart the engine it's taking long time to come online (it's in fast recovery status long time). Tha…
Restoring stratgies
We use 2 archiving strategies in production (SP)- level 0 archives of instance(using ontape) and onunloads. The reason for doing onunloads by database is because we have 4 Informix instances on our Dev box- SD, ST, SO, SB. The difference between the instances is in the chunk name…
Archive - Restore
Hi Folks. Dummy question. May I restore a archive that was made in 11.5 FC9WE to a 11.5 FC9DE 64 ? Thanks, André…
Problem while Performing a Logical Restore?
Hi Khan, Short answer, no, you can't use two different backup tools to perform a restore. You could add more logical logs to the primary so that you don't overwrite any during the restore of the secondary. Cheers Sent from my iPhone > On 1 Oct 2013, at 7:00 am, "O KHAN" <the…
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.…
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
onbar restore LTAPEDEV=/dev/null
We tried to restore the database with onbar -r -p -w with LTAPEDEV=/dev/null. Only the rootdbs got restored. We are unable to restore the other dbspaces. Anyone know how to get around this problem? Paul…
Strange HDR behaviour
I am using 'onmode -ky' to shut it down. I restarted the secondary server this morning and it starts to transfer logical logs again from number 1411. Current log at the primary is 1575. Here is the log from the primary: 05:05:51 DR: Primary server connected 05:05:51 DR: Using …
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
Onbar Block Size
Hello. You should look for the block size transfer generally, in your SM software documentation. Informix is configurable, through BAR_XFER_BUF_SIZE onconfig variable you can adjust to your SM. The size, in pages, of each data buffer. Acceptable values are 1 through 15 for 4 KB p…
Fast Recovery (CKPT REQ) state
Hi Art, Well, it seems it's not working in this version, or maybe it's not supposed to work in Fast-Recovery mode, and the message is misleading (saying it should be in Quiescent or Off-line). Thanks for all your help. Best regards, Florencia…
Onbar Restore of "Critical Files"?
Onbar now backs up "critical" files ixbar, onconfig and oncfg. What is the command to restore those files? Do the files get restored to the original location? If the path doesn't exist, will onbar attempt to create it? Can the file restore be redirected to an alternative loca…
why did you organize the line ?
Hello, this site seems appropriate http://www.facebook.com/pages/AW4SiS/376032499112053; why did you organize the art recovery? ciao…
Re: Issue about logical restore
> This looks to be a defect. It appears to have something to do with recovery and running out of memory, > which your server appears to be having memory issues based on the MSGPATH output you've included > (the "out of virtual shared memory messages" prior to the rest of the fail…
Re: Issue about logical restore
> This looks to be a defect. It appears to have something to do with recovery and running out of memory, > which your server appears to be having memory issues based on the MSGPATH output you've included > (the "out of virtual shared memory messages" prior to the rest of the fail…
Issue about logical restore
Original post: Hi, I need help on an issue which occur during logical restore on Informix Dynamic Server Version 9.30.UC2 can someone help me? When I run a logical restore, I get an the error message such as the one reported at the end of email. How can I limit the number of vi…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
Restore individual dbspace with ontape
Is it possible to restore an individual dbspace with ontape using only a level 0 backup WITHOUT restoring any logical logs? I have tried using ontape -r -D dbspace, and also ontape -p -D dbspace. In both instances the dbspace is restored but left "down" (and I receive messages s…
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,…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
reduce size of root dbspace
Wow... IDS is fully fault tolerant apart from serious and rare bugs. A crash will not corrupt anything and the fast recovery assures that things get to good shape on startup. And you have mirroring... On Jul 18, 2012 4:07 PM, "FRANK J. COMPUTER" <frank_in_pr@hotmail.com> wrote: …
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
onbar restore
Solaris 9. Informix 11.50 Had damage on disk and two dbspaces were offline when try to start IDS. Informix startup stays on 23:43:43 Results: DBspace bddarea1 is disabled. 23:43:43 Action: Restore DBspace bddarea1 23:43:43 stack trace for pid 10581 written to /usr1/informix1150/t…
IDS 7.31 UD5 data(base) recovery
hi, i'm looking for any solution which allow me to get database server online or export data from dbspace the state is as follows: # onstat - Informix Dynamic Server Version 7.31.UD5 -- Fast Recovery (CKPT REQ) -- Up 22:31:46 -- 98304 Kbytes Blocked:CKPT # ontape -a Perfo…
onbar restore
Hi, I am able to make an onbar imported restore (with rename option) on an Windows IDS 11.10. I have the felling that every month restore time is increased. As you can see restore started at 2012-03-01 21:17:27 and actually data restore started at 2012-03-02 05:34:39. =========…
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 …
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
Informix 10.00.TC5 CKPT REQ Logica Log Full
What option do you mean? An oprion to set in ONCONFIG or an option of ONPARAMS? Because in my situation I can't use Informix commands I can only act on ONCONFIG file that runs before the FAST RECOVERY MODE. Thanks…
Disaster Recovery testing and HDR
The production Informix instance and the disaster recovery (DR) instance are a HDR pair. The DR is a read-only secondary. We have a significant disaster test coming up shortly and I would like to break the HDR link and bring the DR instance up as a stand-alone read-write server. …
backup and restore
hello all we have a level 0 backup to disk from AIX 6.1 and were looking to restore on a Linux x86 (red hat) server, infromix version 11.50.FC7. error comes up as "Physical restore failed - function read archive backup failed code -1 errno 0" can this be accomplished between t…
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…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
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…
ONBAR performance tuning
Hello All, Is there any way to tune the performance of backup/restore using onbar and ontape?…
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.…
PIT Recovery
Hi, We are using IDS 11.50 FC6 & FC7 on Solaris Sparc. How can we make sure that we perform PIT Recovery in Informix? What are the different backup technologies available that supports PIT ? Thanks.…
RE: Archive using ontape with incryption
IDS 11.70.FC2 Solaris 10 - 64bit What is the easiest what to backup and restore to tape using `ontape` along with encryption? Has anyone restored, having used encryption for the backup, successfully and without incident? Thank you. Larry…
Quick Recovery
HI, How can we ensure quick recovery using Level-0 (or using snapshot backup) for any Instance. Also, how the performance of HDR/RSS improved if we have a huge transaction volume at Primary Instance ? Means, Is there any way to keep RSS / HDR behind Primary Instance (say for 10…
ontape -p/r with changed ROOTPATH
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
vmware informix backup
I would always choose the Informix backup. That way you can assure data integrity as well as provide PIT recovery.…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
Problem with HDR
number of cpuvps, value of OFF_RECVRY_THREADS and LOGBUFF output of onstat -l ??? M.P. From: "KHURRAM SHAHZAD" <kshahzad02@i2cinc.com> To: ids@iiug.org Date: 02/20/2011 07:09 AM Subject: Problem with HDR [22840] Sent by: ids-bounces@iiug.org I have upgraded my database …
waiting on write of the logical log buffer
Generally I recommend that OFF_RECVRY_THREADS on the HDR (and RSS) server be about 3 times the number of CPUVPs, but using a near prime number (where the number is not evenly devisable by 2,3,5,7,11. In your case, that would mean using OFF_RECVRY_THREADS to maybe 37. M.P. From:…
onbar recovery in IDS v10
I have a client's database from a several months old backup that I am trying to restore. For some reason the onbar/ism bootstrap was not written to the backup savesets when the backup was run. The backup is always a level 0 backup and I have all the ixbar.#, oncfg.*, and onconfig…
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…
Fast Recovery
I have a case that I need the help of friends to solve An instance (very badly configured) received a transaction that was to last a LONG TRANSACTION, when I did a rollback to 7828 LOG 7815, but not complete, and is an instance in the status of Fast Recovery (CKPT REQ) and not c…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
Buffers not flushed
> If the fuzzy checkpoints are not written to disk (still in memory) AND > your system goes down, you will loose the transactions. > From that standpoint, it is risky to let too many buffers accumulate > in a fuzzy checkpoint (in memory). BULLSHIT. The fast recovery mechanism w…
Tip: ontape + gzip parallel compress
Great stuff. Have you tested a restore using the same? I'd be curious how that goes, since the restore will be the most time critical process if and when it's used. Nick…
TSM and Informix 11.10 on Windows
Hi, Is it possible to explain anybody the way that TSM and onbar are related? For example in a imported restore attempt I was not able to restore anything until I ran the q backup .... command (in a different command prompt window). Why that happens? What about in the case that…
PIT Restore
Hello, I am testing PIT restores using different levels of the archives and do not seem to be able to stop at my level 0 w/o altering the ixbar file. More specifically, I am 1. level 0 archive (onbar -b -w -p -L 0) 2. change logical log and execute checkpoint 3. drop database 4…
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…
Imported Restore
Hi All, I am performing restore from our PROD to a DEV env. The configurations of dbspaces are equal and the same on both servers (DEV and PROD). I copied the ixbar .xxx and oncfg.ifxxxx and onconfig.xxx into our DEV environment. I tried a FULL restore but i'm getting error belo…
non-blocking checkpiont, physical log & fast recov
Dear collegues, I have one question related with non-blocking checkpiont. As far as I know when a checkpoint occurs, IDS blocks all transactions while flushing all dirty pages in the bufferpool to disk. When it finishes writes a checkpoint record to the current logical log and …
Re: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Applying logical logs after level 0 restored
Hi Everyone, I just restored the complete level 0 backup of informix 7.13 on hp-ux 10.01 in our development environment. At the end of restore, I didn't forget apply logical logs to the database. can anyone advise me to apply the logical logs on the database that I restored? P…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
Ontape restore : Fast recovery hangs
Hi, I've launched an 'ontape -r -rename -f <file>' to restore an instance version 940 from a tape. But since 2 hours the instance is in Fast Recovery mode as 'onstat -' shows below : informix@pcoi01:pcoipcoi_tcp:/bases/informix/pcoipcoi/var/bdump> onstat - IBM Informix Dynamic…
Physical restore failed
Needed help, we have IDS 7.31 on HPUX 11.0. We are currently encounter error message while restoring our production database: Physical restore failed - function read archive backup failed code -2 errno 0 And when I viewed the online.log, it said 12:01:00 Aborting physical res…
Logical Recovery During restore
I am encountering a confusing issue at the moment regarding a restore of IDS10. After running a physical restore, the logical restore is still asking for logs prior to the level0 backup time. Below are the details from the physical restore: Please mount tape 1 on /database/arc…
Re: Restores
Hi, it looks like the problem is caused by version checking. But this version checking is done for a reason. Not only the actual version is checked, but also the edition (which is also done by looking at the version string). This is a restriction because an Enterprise Edition ha…
Re: Restores
>> "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> wrote in >> message news:mailman.53.1269437682.1071.informix-list@iiug.org... I don't know if the onunload/onload have the same version limitation of ontape, did you tested it? AFAIK they works in a similar way from on…
Re: Restores
On 24 Mar, 12:19, Art Kagel <art.ka...@gmail.com> wrote: > I'm about to release a new version of myexport/myimport that uses EXTERNAL > TABLES. The load runs over twice as fast as a run using sqlcmd. Since the > default sqlcmd mode is about comparable to dbimport in speed which…
Re: Restores
On 24 Mar, 03:18, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Art Kagel" <art.ka...@gmail.com> wrote in message > > news:mailman.46.1269395389.1071.informix-list@iiug.org... > > >> You've never heard of #DEFINE and #if DEFINED()? Same code, different > >> compiles. That's h…
Re: Restores
Sorry, I send the message before finish... this is the complete message.. I don't know if the onunload/onload have the same version limitation of ontape, did you tested it? AFAIK they works in a similar way from ontape, dumping the used pages and the structure of the table/index…
Re: Restores
I'm about to release a new version of myexport/myimport that uses EXTERNAL TABLES. The load runs over twice as fast as a run using sqlcmd. Since the default sqlcmd mode is about comparable to dbimport in speed which would also make it about twice as fast as dbimport. If you pe…
Re: Restores
In this case, where a downgrade is needed, isn't exists a workaround from IBM support ? The client always need to export/import all databases? Technical speaking , is WG already impose a hard limitation of resources like partitioning ? what can be one reason to limit this restore…
Restores
I note that there are different code streams now between IDS Workgroup and Enterprise Edition. And I've just tried to restore an 11.5FC6 EE archive onto a test server ..... ontape -r -t STDIO < /scratch//99.dmp Backup data version is not compatible with Online version: IBM Inf…
RE: Long Checkpoints with HDR and 11.5.
ok - a couple of things. 1) You need to have the same number (or even more) cpuvps on the secondary. 2) The number of OFF_RECVRY_THREADS should be a near prime number and = at least 3 times the number of CPUVPS. You're already going to make it more difficult for the secondary t…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
Re: Dbspace recovery
Hi Art/Fernando, I have now tried som recovery attempts both warm restore of one dbspace and a could one with all dbspaces inc. rootdbs. I also have tried the rename option, but it have failed every time. Do you see what I'm doeing wrong?: WARM RESTORE: -----------------------…
Re: Dbspace recovery
Oh, to your question about the sizes and number of dbspaces and chunks: Each chunk path must exist. Although you can use ontape's chunk rename feature to restore to different chunks even with different offsets there must be a one-to-one relationship between the original chunks …
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
HDR Problem
If i am not mistaken,Once you restore the DB from primary to secondary,logical log number should be same. rgds schillache…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
Restoring a dataspace
Hi, I have two identical database installations in two identical machines. Is it possible restore one dbspace from one machine to another with ontape? I'd like to load a database to this dbspace in one machine and then move it over to another machine afterwards. Thank you for a…
No able to restore.
I am doing ISM onbar backup-restore test in ISM Version 11.50.FC5. Steps i follow is as below: My database in logging and buffered mode. 1. onmode -lc (forced logical log and checkpoint) 2. onbar -b -L 0 (0 level backup)- below is extract of bar_act.log: 2009-11-13 05:41:27 …
Waiting for Next Logical Log File to be Freed
Hello my informix instance version 9.21 is actually in fast recovery and tell me "Waiting for Next Logical Log File to be Freed", i make backup off the logical logs, i try to add new logical log, i try to move a 9.30 version but i need to close the transaction that is open, does …
$ONCONFIG Parameter: RTO_SERVER_RESTART
I set this parameter when we migrated to 11.50 and am very happy so far. RTO_SERVER_RESTART is the number of seconds you want fast recovery to take. IDS will make an educated guess as to how long fast recovery will take by keeping track of things like how fast you can write to …
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…
What is the difference oninit and onmode
Hi, I did try last night at home.. onmode -s, will put the engine into quiesent mode (from online)... oninit -s, will put the engine into quiesent mode (from offline). Thanks all for the input. oninit -j -- will put the engine in single user mode, ONly DBSA or informix can acce…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
Backup and Recovery Using Onbar
Hi All, I'm new on using "onbar" backup utility. I was able to create a backup though Netbackup, but my problem now is how can i restore it in a different instance?... Pease see example below Source (which i did "onbar -b -L 0") INFORMIXSERVER=ids1 ONCONFIG=onconfig.ids1 TARG…
oninit -r
We tried "oninit -m"... IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up 00:03:33 -- 488472 Kbytes Blocked:CKPT Some information: - before this problem, the system was in a cdr replication state and we would disable this executing an "oninit -D", wh…
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…
Logical Log Files are Full -- Backup is Needed
Hi, Informix IDS complains that the logical logs are full. I am not able to shutdown or use the database. Here is my onstat -m. Any help to bring the system out of the "full recovery mode" is appreciated! ================================= informix@berlin:~$ onstat -m IBM Infor…
Re: External backup
<tilleul17@web.de> wrote in message news:mailman.198.1248949897.4791.informix-list@iiug.org... > I guess you mix two things up - fast recovery and a restore with a logical > restore (replay of logs) > > If you just want to be able to get IDS online to the point in time when > yo…
External backup
Neil Truby wrote: > -----Original Message----- > From: Madison Pruet [mailto:mpruet1@verizon.net] > Sent: 27 July 2009 19:38 > To: Neil Truby > Subject: Re: External backup > > Neil Truby wrote: >> IDS 10.0 for example, any O/S. >> >> I've never understood why we have to an onmod…
Ontape Restore
All, I am archiving a database to disk using a script that does the 'Mount tape and Press enter' bits. Does anyone have a restore script that will do the same thing? I've checked in the IIUG Repository but didn't find anything. Regards Colin There are 10 types of people…
HDR recovery in asynchronous mode
Hi, If primary server crashes in an HDR pair (asynchronous mode say DRINTERVAL=5), How can we prevent the data loss if storage of primary server is accessible for read/write mode but IDS instance is unable to start. Can we apply the primary logs by some manual method or some othe…
HDR (crash recovery)
Hi, We conducted a test to see the business impact if primary server crashes in an HDR. We inserted 200 independant inserts in a table. And killed the informix instance session (got from "onstat -g glo" command). Here are our findings: After crash of primary server the table on s…
nonblocking checkpoints
how do nonblocking checkpoint use the physical log? when do they fire? how does fast recovery work concerning nonblocing checkpoint?…
onbar -r -n hangs in cold restore of rootdbs
Hi John, Finally after about 1 1/2 hours the restore kicked in and is now restoring the dbspaces. Thank you for replying so quick. Regards, Paul Sullivan…
Problem of restore
Hi I have problems with my engine Informix restore. If raalizo restore with the command: $ ontape -p Show me the following error message: read: I/O error 22+0 records in 22+0 records out Physical restore failed - function read archive backup failed code 1 errno 0 Thanks for t…
JFS2 on AIX on IDS
Mark Scranton (Xtivia Inc.) wrote: > Does anyone have opinions - good, bad, or ugly - on using JFS2 on AIX > for IDS? Any comments would be appreciated! > > Thanks - > Mark > Xtivia Inc. > www.markscranton.com > System crashes (someone pulls plug out of wall). JFS does "Recovery…
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 …
Control level 0 Restore Time
Hello, IDS 11.10 FC3 on solaris 10 I restore a level 0 backup using "ontape -r" on one of my instance every week using a shell script running as cron job Last week it took about 12 hrs to restore a compressed level 0 bkp file of size 60878644133 bytes (gunzip -3). This week t…
need to backup the individual database
Can i do a fake backup using onbar utility to avoid a forced level 0 backup after restore?…
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…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
Recovery Point with Informix IDS
Hi to ALL First of all I would like to inform you that we are running on Informix9.4 FC6 and at the end of this year we are planning to move to Informix 10 (latest version). A few day ago BULL company present to as the Recovery Point of EMC What I would like to know, because i…
External Restoration
Hello, IDS 11.10 FC3 on solaris 10. Problem: I have instance lt1 on my test server having 25 medium size databases (level 0 backup size of about 400 GB using ontape), now I want all these databases on the same server in another instance. Currenly the chunks of lt1 are in /dbs/l…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
ontape -r suddenly very slow
It's during the physical restore…
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…
Enterprise Replication db recovery
Hi. I have a database that uses Enterprise Replication (at least it appears to be ER as opposed to High Availability Replication) based upon the use of "cdr" commmands and CDR* onconfig parms. It is a simple setup though. It is ONEWAY with only a subset of tables being replicated…
Restore ?
IDS 9.40fc9 Aix 5.3 I currently use onbar with TSM to perform backups ... I also have restored these backups to remote servers ... Now I have the need to restore the backup to a new instance on the same server. Can this be done ? I would use the -rename option to rename the unde…
ARCHECKER Table level Recovery
A little frustrated with this utility - What is your experience? Can you help me? (Sorry for the story...) My experience: 1) if target table exists, simply appends. ;-( documentation implies it has to be a virgin table... and hence implying appending won't append... (?) but it …
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…
Onbar Restore
I am trying to do a PIT restore of a db using onbar onto a different server, it does the rootdbs and nothing else. I've copied ixbar.? & oncfg_<servername>.? onconfig is exactly the same apart from CLEANERS/LRUS and DBSERVERNAME. I use Netbackup as the storage manager and I've s…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Changing the Logging Mode
Thank you ! i think its better for me to do the activity with database in logging mode. -rw-rw---- 1 informix informix 12288000000 Jun 26 16:50 logdbs i have 586 total logical logs each of 20M. now if my single transaction fill this 586 logs ( which i backup with logful.sh) usi…
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.…
Cheetah2 connection manager and failover arbitrator
Andrew Ford wrote: > > > > This excerpt from the hdrmksec.sh script is what had me concerned > > echo " Note : -PHY is an undocumented option only used in this" > echo " HDR failover script" > > I have no problems using oninit -PHY, we use the hdrmk*.sh scripts all of th…
Info required about ontape restore
Hello, Query #1 I have completed a restoration of compressed ontape level 0 backup on my test server using the backup and restore filter /bin/gzip. the compressed level 0(on file system) used for restoration was residing on remote server. After the level 0 was restored & before…
Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?
"Madison Pruet" <mpruet1@verizon.net> wrote in message news:47FE20AE.2050404@verizon.net... > If writes to the chunks were not blocked, then while the external copy was > being made, then there would not be a consistent image of the disks. The > first part of the copy could belo…
Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?
Neil Truby wrote: > "Superboer" <superboer7@t-online.de> wrote in message > news:fffc5c22-82a8-4f19-ab32-f090f4c66179@u36g2000prf.googlegroups.com... > >>> Rightm, but all these snapshot-based technologies use "consistency group" >>> functionality so what you describe above doesn…
Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?
> That's fine and dandy, but be clear that what you are saying is functionally > identical to saying that IDS Fast recovery cannot be relied upon either. oh yes it is since writing is controled by the engine. when fast recovery crashes due to corruption then this is a bug peri…
ontape -r -t STDIO Level 1
-- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Neil Truby" <neil.truby@ardenta.com> wrote in message news:64dhh2F2bec8sU1@mid.individual.net... > Martin Fuerderer" <MARTINF…
HDR: Checkpoint Record not Found in Logical Log
I am trying to re-enable HDR on a pair of machines that I have used it successfully on in the past. Neither the configuration nor the hardware has changed on either box. After a clean restore using `ontape -p`, I restart the secondary server and place it in recovery mode with `o…
Confirmation Regarding Migrated Restore
Hi all, In a migrated restore will i be able to selectively restore the selected Dbspaces from a leve 0 back up? with the condition that the target server where i want to restore has everything identical with source except the hardware, is it always mandatory to have identical …
Re: Point in time restore with archecker
Hi, FYI regarding table-level restore to an external table (a file) -- When you specify a restore to an external table (a file), only the physical restore portion is done (restore of data from a level-0 archive). archecker cannot do logical restore for external table. This is …
Restoration error
I'm currently working with a DBA to perform restoration testing but while keep hitting into the errors below. Can someone help to decipher what the hecks is all this about??? and any resolution to it. Thanks :) ------------------- 17:46:09 IBM Informix Dynamic Server Started. …
Logical log for Temp table
falconsoon@gmail.com wrote: > From informix manual, I found that any logical database operation will > be logged in logical log. However, will any logical operation on > temporary table be logged too in logical log. I ask this question as > it is non sense to log logical operatio…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
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…
Windows XP Registry
One way to backup the registry is to create a System Restore snapshot. System Restore returns your computer to a previous snapshot without losing recent personal information, such as documents, history lists, favorites, or e-mail. It monitors the computer and many applications fo…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
Difference between Physical and Logical Logs?
DANNY NG wrote: > 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. > The physical log is ONLY used in two situations: 1- The contents are copi…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
Onbar fails to restore all dbspaces
This indeed seems to be an issue for 10.00.xC6 and 10.00.xC7. However, 10.00.xC5 and below work as you'd expect. Is there any chance of performing the restore with this version of the engine, just for the purpose of the restore?…
Re: IDS 9.4 Stuck at Fast Recovery
On 10/11/2007, Marco Greco <marco@4glworks.com> wrote: > Keith Simmons wrote: > > On 10/11/2007, Marco Greco <marco@4glworks.com> wrote: > >> Keith Simmons wrote: > >>> Anyone > >>> > >>> I havea test instance (not being archived that regularly) that > >>> suffered some disk corr…
Re: IDS 9.4 Stuck at Fast Recovery
Keith Simmons wrote: > On 10/11/2007, Marco Greco <marco@4glworks.com> wrote: >> Keith Simmons wrote: >>> Anyone >>> >>> I havea test instance (not being archived that regularly) that >>> suffered some disk corruption (crossed chunks with another instance >>> !!). It has bee runn…
Re: IDS 9.4 Stuck at Fast Recovery
On 10/11/2007, Marco Greco <marco@4glworks.com> wrote: > Keith Simmons wrote: > > Anyone > > > > I havea test instance (not being archived that regularly) that > > suffered some disk corruption (crossed chunks with another instance > > !!). It has bee running OK and Ihave been so…
Re: IDS 9.4 Stuck at Fast Recovery
Keith Simmons wrote: > Anyone > > I havea test instance (not being archived that regularly) that > suffered some disk corruption (crossed chunks with another instance > !!). It has bee running OK and Ihave been sorting issues with indexes > as they appear (the crossed chunks were…
IDS 9.4 Stuck at Fast Recovery
Anyone I havea test instance (not being archived that regularly) that suffered some disk corruption (crossed chunks with another instance !!). It has bee running OK and Ihave been sorting issues with indexes as they appear (the crossed chunks were on a dbspace containing mainly …
Unable to open input file 'c'
Informix 7.x SCO Unix When I do oninit, I get the following messages: Unable to open input file 'c' Unable to open input file 's' Informix go into fast recovery and then crash. Any advice? Regards David Reed…
Continuous log restore
Version IDS 10 I read in IBM's redbook for version 10 that continuous log restore can be used. I wanted to know the following: 1. Can onbar be used for backup and restore ? 2. What commands can be run to setup continuous log restore ? There is not enough information available a…
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.…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
Restoring Level 1 Backup ONLY - INFORMIX 9.4
Dear All, I am trying to restore level 1 backup ( with ontape -r ) on a machine ( solaris 8 )on which I have a level 0 backup already restored preveiously ( while restoring I terminated restore at the point when level 0 was completed and system was asking for level 1, my idea wa…
Re: Restoring Specific dbspaces
On Jul 18, 7:41 pm, "howie....@googlemail.com" <howie....@googlemail.com> wrote: > IDS9.40.FC4 > HPUX11.0 > > Hello all a few questions for you regarding restoring specific > dbspaces. > > The customer we support has added a test company (within baan) into a > specific dbscpace, …
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
long checkpoints on informix
Please post the output from: onstat -m onstat -d onstat -D onstat -u onstat -g iov Sakura.ggxx@gmail.com said: > hi everyone > i recently start to have some long and constant checkpoint > i did lot of change but cant reduce it > i have Informix Dynamic Server Version 9.40.FC2 >…
Onbar logical restore fails
Hi all, Many thanks to all for your suggestions. I suppose I could split up the restore to a physical restore using onbar -r -p and a logical restore using onbar -r -l. However, what I was trying to do was a complete combined restore using onbar -r. This gave the problems in fa…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
DR failover server
Hello all: This is my first posting. We are running IDS 9.40.HC3 on HP-UX B.11.11 with a small EMC RAID array and I am working on a disaster recovery document. We currently have 2 servers (dev and prod) and will be moving the dev server to a disaster recovery site which has a T3 …
Fatal error in ADM VP at mt.c:13135
IDS 10.0.UC6 AIX 5.2 Any idea as to what would cause an ADM VP termination? All activity stopped on the server. Thanks in advance for any replies. 00:06:02 Maximum server connections 129 00:08:05 Logical Log 2645 Complete, timestamp: 0xb37b9d2e. 00:11:02 Fuzzy Checkpoint Co…
Re: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
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.…
Checkpoint times
Marcus, The CKPTINTVL does not affect transactional security. The only affect a longer CKPTINTVL is that fast recovery after a crash will probably take longer. (it effects mainly rollforward phase , it does not have much affect on rollback phase of fast recovery ) SAP standard…
Error when initializing
On IDS 10.00 when I trying to startup it remains eternally. In another screen (onstat -) appears IBM Informix Dynamic Server Version 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 Kbytes Blocked:CKPT. That I must do?…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
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: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
Informix OnBar Restore
Hello all, after an Infomix level 0 restore with onbar �r �p the db is at Fast Recovery state ... do I have to restore the logical logs before I bring it online? My aim is to just check that the level 0 backup is recoverable not to bring the db at its latest condition. Or in …
NEED EXACT STATEMENTS for DB2 ONLINE BACUP.
I checked the udb Db , logretain =RECOVERY and USEREXIT=no , i need to do online backup , please help…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
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…
HP Continuous Access XP and Informix
Anyone using HP's Continuous Access product on their XP as their High Available/Disaster Recovery solution? Good? Bad? Don't care? ____________________________________________________________________________________ Sponsored Link Compare mortgage rates for today. Get up to…
Re: Can I bypass fast recovery?
Just out of curiosity, could you post the af file?…
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
Can I bypass fast recovery?
Call your support provider As the tools support have by pass fast recovery you may end up with corruption and inconsistency in you database as the recovery process will not have completed fully and any uncompleted transactions will neither rollforward nor rollback. So after an…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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: Backup Very Slow
Prior to moving to a data center (few months back) my backups were to Ultrium 3's. I could backup 330 gigs in 2 hrs (HP 11.11 IDS 9.40 ,7420). Before the move to Ultriums I was using DLT 320's with the backup taking 5+ hrs. Thanks "DORN B" <varadorn@…
Re: Backup Very Slow
Use onstat -V to discover exactly which version of 7.31 you are using. You may be hitting bug 101062 - Archiving very Old Pages. If so there is a simple fix, but the exact version needs to be identified first. Keith On 05/09/06, DORN B <varadorn@gmail.com> wrote: > Another way …
Backup Very Slow
PapaKiKi wrote: > have Informix IDS 7.3 on an Rp4440 server with UNIX 11.0 I am using > DLT Tape drives and 80gig tapes to do my back up on a 98gig database. > My problem is that a level 0 backup takes 24hrs to finish. Using > ontape . I need to reduce the time.My database has …
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
Re: SNAP & SAN
"Model-Bosch, Tilman" <tilman.model-bosch@sap.com> wrote in message news:mailman.266.1155586222.20706.informix-list@iiug.org... Neil Truby wrote: > Gesendet: 14 August 2006 21:28 > An: informix-list@iiug.org > Betreff: Re: SNAP & SAN > > "Martin Fuerderer" wrote: > > After restor…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
optimize for restore
Hi, We have a standby database here for backup purpose. Taking a backup from production db using onunload, and restoring on standby system with onload.(using IDS 7.31 on HP/UX) how can i make the restore operation go faster? i have read something about modifying onconfig paramet…
reorg by restore
Is there any disk benefit gained from doing an Informix restore ? In other words, does a restore cause data to be placed more contiguously on the OS disk ? Thanks, floyd ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: …
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
Checking database partition index... FAILED
GemaVi wrote: > Hello, > > after a cold recovery of Informix 9.40 UC2 the status remained in > Fast-Recovery. Last line of the online.log during recovery was: > > 11:50:28 Maximum server connections 0 > 11:50:35 No logical log restore will be performed. > 11:50:35 Preparing Ph…
Re: FAST Recovery problem
Anand Iyer wrote: > hi > > I am having IDS 940UC2 . It has reached into a fast recovery > mode.Also it is taking long time in the recovery mode > > IS there any way that i could bring up my INFORMIX instance ONLINE mode > bypassing this fast recovery mode. or SKIP checking this…
Re: FAST Recovery problem
Art S. Kagel wrote: > Anand Iyer wrote: >> hi >> >> I am having IDS 940UC2 . It has reached into a fast recovery >> mode.Also it is taking long time in the recovery mode >> >> IS there any way that i could bring up my INFORMIX instance ONLINE mode >> bypassing this fast recover…
FAST Recovery problem
hi I am having IDS 940UC2 . It has reached into a fast recovery mode.Also it is taking long time in the recovery mode IS there any way that i could bring up my INFORMIX instance ONLINE mode bypassing this fast recovery mode. or SKIP checking this logical log & what is the pro…
RE: HDR problem with Windows
Some minor comments: > ROOTPATH D:\\IFMXDATA\\ol_server1\\rootdbs_dat.000 You've moved the root dbspace to D:\\IFMXDATA\\ol_server1 on ol_server2 as well right? > NUMAIOVPS 4 # Number of IO vps Not relevant to your problem, but this seems a bit high on Windows…
Restore sequence ?
Hello, I have a couple of onbar related questions: I searched in the web and could not get any concrete answers. 1. what is the sequence of the restore order for the dbspaces ? Default looks like it is restored in alphabetical order. i.e. rootdbs, Critical database in alphabetic…
Point in Time Recovery Failed
Hi Folks, I Got a problem with restore point in time. I´m using IDS 9.40 FC5 for AIX 5.2 ML 8. I performed a level 0 archive 3 times. I´m using onbar and my Storage Manager is Tivoli (TSM) with TDP 5.2.1 and API 5.1.5 . The problem is that I can´t restore my archive to 30 minute…
RE: checkpoint problem
Duplicate problem?? Have you got KAIO turned on? How many dbspaces/chunks/disks have you got? Are your chunks cooked or raw? onstat -d Keith -> -----Original Message----- -> From: mchivaviro@okzim.co.zw [mailto:mchivaviro@okzim.co.zw] -> Sent: Tuesday, June 20, 2006 7:58 AM ->…
Reducing checkpoints
Post the results of onstat -a onstat -g iov please. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "PapaKiKi" <agwanzura@okzim.co.zw> wrote in message news:1150748005.559…
archecker
if in the IDS 9.30.UC4,how should i execute point-in-time table-level restores?…
restoring just from logical log tape
When I run 'ontape -r', it asks me if I want to restore from an archive tape (an 8mm tape) after restoring from level0 backup (a DLT tape). Is there any way to just go straight to that 8mm tape for restore and bypass the hour I have to wait for the level0 restore to complete befo…
Re: Upgrading to version 10 ontape question
"Table Level Restore (TLR) is based on a normal backup/archive. Normal backups/archives are platform dependent, therefore TLR also is platform dependent." That is not what John Miller III said to me at the Atlanta conference! Table level restore can restore to remote instances …
Re: Upgrading to version 10 ontape question
For a platform independent backup/restore use version 10 and table level restore to restore all tables from a level 0 archive. This is platform independent. Backup/restore will always be version dependent since each new version has more features. David.…
ontape -r error
I am trying to restore my backup done with ontape -s and I am getting this error. What could be the problem. I can bring informix online but can not restore on it. Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Physical restore failed - could not fork server co…
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: removed database
if the need to restore databases inidivdually is a requirement then you could configure IDS such that you can put each database in its own dbspace and warm restore that dbspace…
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/…
HP Data Protector restore
Hello, How can I restore informix backup on other instance with Data Protect.…
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Restore Problem
I am tyring to restore a production backup to a spare box to get some deleted rows from one table. I am getting the following error when trying to restore: 22:38:04 Event alarms enabled. ALARMPROG = '/ifxapp/informix/etc/alarmprogram.sh' 22:38:04 Booting Language <c> from module…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
help URGENT
IDS 7.32?? Je ne sais pas! onstat -V ??? i suggest you restore from archive!…
Re: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
Re: HPL
The noconversion unloads in a binary internal format that is platform dependent. Also check out Point In Time Table Restore. If you are moving from IDS 10 to IDS 10 you can use the Point in Time Table Restore to restore a complete database from one platform to another!! Since y…
Need Help with recovery of 7.31
I'm trying to recover a DB from last February 15 and roll forward to February 19 (power outage). I have all the log files from 15th to the 19th but I'm having problems finding the very first log. Here are the relevant sections of the online1.log: 21:20:29 Checkpoint Completed: …
Re: Performance issues on HP-UX
Mike Peters said: > > We are currently suffering performance problems with our Informix > server running on HP-UX. The server appears to be paging heavily with > sar -q showing %swpocc running at or close to 100. > > The server is an HP 9000/800 with 1Gb RAM, running: > IBM Infor…
PC3000 ISA and PCI
David wrote: > PC3000 ISA and PCI data recovery tools price drop already as data > recovery and hard disk repairing, all enginner and techinician must > have this skills facing future chanllenge. > Use a spell checker.…
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 …
Restore failure
While attempting to restore an ontape archive, I get this error: Continue restore? (y/n)y Do you want to back up the logs? (y/n)n 16:50:22 shmat: [22]: operating system error Physical restore failed - function read archive backup failed code -1 errno 14 Program over. Also, in…
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.…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
Cannot Open primary chunk on Informix 7.31
if it's a raw dev you may be able to relink it.... CARFULL that you do pick the correct dev!!!!!!! if not then it's cold restore time since it looks like your phys log is in there. (otherwise it;s warm restore time if you have trx log available... else its also cold restore...) …
IDS 7.30 do not start - NT
Please send also your onconfig; sounds like something has changed since last reboot???? > 12:04:10 Requested shared memory segment size rounded from 1215568KB 512 MB available and requesting 1215568KB??? hopefully this is not caused by fast recovery...you may want to check OFF…
Re: External backup/restore - an idea - comments please
Thanks Martin for these links. Extremely valuable information on EBR those who are reviewing their backup & restore process. Hari…
Re: oninit: Dictionary Cache and SPL Routine Cache error
I did the following: # truss -fr all -o oninit.log /dbms/informix/bin/oninit -ivy The results showed that there were some errors in the sub processes that were not killing the main process. One place says, in essence: Physical Recovery failed Logical Recovery faile…
Re: ISM restore to different machine
ISM is a limited functionality storage manager aka Legato Light which is intended to allow you to back up and restore on the same server using Informix Onbar. There are workarounds that allow you to do restores on a other servers (imported restore). If you have a requirement to…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
Fast Recovery locked up
Hi people. Running IDS9.4 FC4 on AIX5.2 10GB memory server used as apps and dbs server. After a bounce of the engine last week the instance got stuck in Fast Recovery. Trying to bring it down didn't work (not onmode -uy nor onmode -ky). Only the instance is using logging, and lo…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
RE: Config for OLTP system
BUFFERPOOL size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=10. 000000 Maybe spending too much time flushing 8% of the LRUs when LRU writes kick in? Might try lowering lru_max_dirty. Shorter checkpoints and your LRU writes should be spread more evenly over t…
Need help to empty data in chunk before drop it.
Try looking into archecker. Also you could do a warm restore of just that dbspace. check the back and restore guide.…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
RE: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
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:…
Fast Recovery (CKPT REQ)?
Hi, I have a database that is in Fats Recovery (CKPT REQ),,,,, ,,,, Blocked:CKPT and it will not come up! Have tried onmode -c unblock without any success,,,, How can I get around this Checkpoint state and get the database in Online state? Thankful for any help on this topic…
informix restore
I run a backup ontape -s which was saved to a file and then zipped it through gzip and then unzipped it and restored through: ontape -r -D dbsdata but I didn't restore any logical logs ? Should I have restored them. Now dbsdata shows as Disabled in DBSPACES status I get a ND f…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Can you post the output from onstat -g iov please. "Bono Vox" <in4mixperu@hotmail.com> wrote in message news:1115714331.fe81cde2ee8f8402d2a791d65e041327@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my co…
Onbar Restore HP-UX, IDS 7.3
We are in the process of doing a restore from one server to another using On-Bar and cannot get the database out of Fast Recovery mode once the physical restore has been completed. The physical restore took around 15 hours and I am reluctant to shutdown the database as I believe …
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
RE: Transaction Rollback
so what do you do if the server is still in logical recovery (ie not online) and rolling back transactions? As I said before, try onstat - x…
Server won't initialize
What is SHMBASE set to? Try setting it to "0" "Steven Weiss" <sweiss@iafrica.com> wrote in message news:d4ae07$b0l$1@ctb-nnrp2.saix.net... > > Hi, > > We seem to have a problem getting the server to initialize. We get an > error > shmat: [ENOMEM][12]: out of available data spac…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
Fw: Need help!! Sql to Informix Migration
you may update your BUFFERS, how much memory do you have? you may send your machine configuration for tuning onconfig file. ----- Original Message ----- From: "Unholy" <dcalleja@gmail.com> To: <informix-list@iiug.org> Sent: Monday, April 18, 2005 11:10 AM Subject: Need help!! Sq…
Fw: Need help!! Sql to Informix Migration
you may update your BUFFERS, how much memory do you have? you may send your machine configuration for tuning onconfig file. ----- Original Message ----- From: "Unholy" <dcalleja@gmail.com> To: <informix-list@iiug.org> Sent: Monday, April 18, 2005 11:10 AM Subject: Need help!! Sq…
Re: Need help!! Sql to Informix Migration
Unholy said: > Hi, I have developed a program that runs under sql Server, and it runs > really fast...... The problem is that now, I have to change the DBMS to > Informix. > > I installed Informix under W2000, and also under W2003, and with it the > program is really slow, as muc…
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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…
ontape -r failed.
9.21 restores restore on 9.21 9.40 restores restore on 9.40 9.21 restores do not restore on 9.40 restore on 9.21 and then upgrade or dbexport on 9.21 and dbimport on 9.40 F. David wrote: > Hello, > I need help in restoring between different Versions of Informix. > We updated…
ontape restore taking time
Hi, I am working on HP_UX 11i and IDS 9.30. When i am restoring the data using ontape the server is in Fast recovery for long time. Its hanging at Cleaning the physical logs for a long time. I am attaching the message from log here. 11:40:38 Checkpoint Completed: duration was 0…
-25572 Network driver cannot bind a name to the port.
More, Shailesh wrote: you have DBSERVERNAME = kam940q1 and NETTYPE = ipcshm,1,20,CPUin you onconfig file. But for this combinations there is no entry in sqlhosts. You'll have to switch either DBSERVERNAME to kamxpsq1.1 to use the second entry or NETTYPE to tlitcp,1,20,NET to use…
RE: Stuck in Fast Recovery
This wasn't in reference to whether linux or unix matter... Of course they do... The issue was a response was posted in unix verbage/solution but the question was for a windows situation... Dat's all... -----Original Message----- From: owner-informix-list@iiug.org [mailto:own…
RE: Stuck in Fast Recovery
Dirk Moolman said: > Oops, sorry - so used to speaking to other Unix users :-o It's OK, no-one else matters. :o) > -----Original Message----- > From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] > > Dude, > Melvin said he's on windows.... Can you 'sar' and 'vm…
RE: Stuck in Fast Recovery
Oops, sorry - so used to speaking to other Unix users :-o Apologies -----Original Message----- From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] Sent: 19 January 2005 04:59 PM To: Dirk Moolman; informix-list@iiug.org Subject: RE: Stuck in Fast Recovery Dude,…
RE: Stuck in Fast Recovery
Dude, Melvin said he's on windows.... Can you 'sar' and 'vmstat' on windows? Maybe check the services and see if something is stopped. NJ -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Dirk Moolman Sent: Wednesday…
RE: Stuck in Fast Recovery
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of TBP Melvin Perez wrote: > Hi, > > Currently, I have an IDS instance in Fast Recovery mode for more than > 19 hours! > > I have tried to perform a backup of the logica…
Stuck in Fast Recovery
Hi, Currently, I have an IDS instance in Fast Recovery mode for more than 19 hours! I have tried to perform a backup of the logical logs, but it's not allowed in this mode. I read previous posting from Art Kagel, saying this can be fixed by asking Informix tech support to dial…
RE: Informix UC7.41 - slow
What O/S What version of IDS Are you using raw or cooked disk How many users? What is your definition of slow? How do you know it is slow, what is the comparison? How much data? volatility of data? ? ? onstat -p onstat -m A buffer size of 8192 (on 2K pages gives only 16 Mb of me…
Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software )
Hi, I am a Data Recovery Specialist and Professional Data Recovery Software Developer in New Delhi. I've placed the Complete SOURCE CODE of One of my Data Recovery Software for Sale (for Educational Purpose) on the following link of my website: http://www.datadoctor.biz/3.htm …
long restores
I'm restoring level-0 backups from one server to another (IDS 7.24 & HPUX 11 on both). The archive only takes a couple hours, but the restores take over 6 to complete. When finished, the database comes online fine with no problems. I just can't figure out why the restore takes so…
RE: Performance Issues
The checkpoint intervals are 15 minutes. I don't think that is the reason for the extent of performance degradation being experienced. Am currently looking at the status of by buffers to see whether there is a need to increase them. thanks again regards roger -----Original Me…
Re: Performance Issues
I think you could benefit from lowering your checkpoint interval, but to be sure, how long do they take right now? During the checkpoint all transaction processing is suspended, maybe that is what your users perceive as low performance? -- Juan de Villeros On Tue, 7 Dec 2004 09…
Onbar - failures with pit recovery
This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C4D814.B7A8E020 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit We have implemented onbar on IBM AIX 5.2 64 bit with IDS 9.40.fc3. When we do a point-in-time recovery it stic…
log restore
hi, in order to have datas replicated on two IDS DBs , without using HDR or IER (too easy :)))) ), i wondered if it is possible to restore logical logs, of the 1st DB, onto the 2nd DB ? if so, then how ? wich version of IDS must i use ? thanks…
Cleared 1935 MB of the physical and logical logs in 1035 seconds...
--0-483730676-1101288734=:72855 Content-Type: text/plain; charset=us-ascii Hi all! IDS 9.30.UC3 on Sun Solaris 8. I have a small system with high transaction activity and near 2Gb of logical logs. During logical restore phase with ontape I see near 20 minutes cleanup: --------…
restore with ontape
Hi to all; MachineA 9.3 FC2 --SunOs 5.8 MachineB 9.4 FC4 --SunOs 5.9 We defined MachineA archive tape to be MachineB:/dev/rmt/0. Although the backup operation ontape s is succeeded the restore operation ontape r is failed with the following message physical restore fai…
Fatal error in ADM VP at mt.c:12239
Could you please post the af file /tmp/af.414c057. yjin_001@yahoo.com wrote in message news:<1100746427.235681.257520@z14g2000cwz.googlegroups.com>... > I've met the following error: > > 09:31:12 Maximum server connections 9 > 09:31:35 Assert Failed: Invalid Mutex Type > 09:31…
restore...
hi, i'd like to have a backup my Infx 7.31 DB to another of our sites for High availability reasons. i can't implement data replication (HDR) because of an unsufficient Qos on the wan link. if i transfer logs to the remote site, can i restore my original database ? how ? does any…
Help !! - Logical Logs are full
Force a checkpoint ( onmode -c ) . If you backup the logs to tape did you change the logical log tape and re-run the script to start the log to write to tape therefore freeing the logs up. John H. Caron USBC-MA 617-565-6175 508-770-8957 "ARIEL QUARIN" <finoquarin@yahoo .com> To…
RE: informix begginer on xp
Art, Is the rootsize big enough?.... Doing the basics... 51.2MB - 2 MB physlog = 49.2MB - 12MB logs = 37.2 MB. I think that's big enough in the olden days for a tiny engine on unix, but I know nothing of windows installs, and I think it was stated this is a 9.4 engine. Will i…
Re: informix begginer on xp
How are you trying to initialize it? ie what are you running? Did it hang during installation, or is it subsequent attempts to initialize that hang? Just making sure you're not trying to run oninit directly from the command line, UNIX style. Also if you run "onstat -m" from an …
Re: (Another) ontape to recover from a FIFO pipe
--If all were well with my system, it would soon finish the Fast --Recovery and enter quiescent mode. However, I have observed two bad --tendencies on this system when recovering using OmniBack (our usual --backup software): -- - Sometimes it get stuck in state "Fast Recovery (C…
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'?…
HELP - RESTORE A TABLE
Can one table be restored from a backup created with ontape -L 0 (On version 7.31UD)?…
RE: Config for new live system
Ditto on Keith's comments about the LRU config. If you are going to configure that many buffers I think you need a lot more LRUs to manage them and more CLEANERS to flush them. And the MIN and MAX dirty are way too high. You could be looking at some very long checkpoints and h…
onbar -r -t "..." -p -w, recovery not successful
what is LTAPEDEV set to? "James Zheng" <james.zheng@gmail.com> wrote in message news:7d321437.0409011012.5f59cb7a@posting.google.com... > Database was backup in "onbar -b -w", but when perform point in time > restore, say if pick a time in between two full backups, only rootdbs …
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Restore error .......................
--0-1347258965-1093452368=:97083 Content-Type: text/plain; charset=us-ascii Hello all, Informix version 9.30.FC7 Netbackup version 5.0 Operating system is Solaris 5.8 I am trying a restore (onbar -r -p) and getting the following error on my bar_act_log. 2004-08-25 11:46:41 1…
non-Informix Replication software
Does anyone on this list use Veritas or SUN replication software for failover / disaster recovery purposes ? Dirk Moolman Database and Unix Administrator MXGROUP "People demand freedom of speech as a compensation for the freedom of thought which they seldom use." -Kierkegaard …
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…
RE: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
Re: Comment on my config
Thanks Claus, Backup is no problem. I just want some comments on my onconfig. Anyone ? Thanks, Bjorn "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote in message news:5uyIc.183341$sS.8769665@phobos.telenet-ops.be... > Hello, > > > here is our newbie again :) > I've been read…
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…
Log recovery with ontape -l failed
I need restore log from backup Do ontape -l and server say error: Logical restore failed - There are no DBspaces or BLOBspaces to recover. Check the status by using onstat -d. IDS 7.31 TC5 Platform: Windows NT4 Server Help me, please…
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…
cannot initialize rootdbs
Have you updated /etc/system "NOOR ANSARI...." wrote: > > ***************************** > informix 7.3 UD1 > running on Solaris 8 with 70 Mhz CPU and > 168 MB RAM > ****************************** > > Problem : Fatal error in shared memory creation > error 156 > command : > $ oni…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
Re: ONCONFIG for 9.40 offered for comment
Thanks. Chaning OPTCOMPIND on a live system would be a brave move I'd have thought, in the sense that a decision to invite a professional liability lawsuit is "brave"! Not sure what TBLSPACE_STATS does, but Andrew Hamm also suggested it so I'll RTFM ... This is an oltp system - …
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
RE: Maximum Server Connections
Jane Vohden wrote: > I'm sorry, I guess my onconfig file didn't attach. I've included it in > the > text here. I have tried the several variations of NETTYPE. What vairiration have tried you? Am thinking the suggested I make will help, you have tried them? > Thanks for any…
Restoration Error
I am unsing a AIX ver 4.3 Server. The informix ver is 7.31. I am having problem with restoring the backup from the Live server to the test server. 1) In online.log file Aborting physical restore of ROOT DBSpace Aborted by client. Informix Dynamic Server Stopped. 2) On the Conso…
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
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.…
Re: Performance advice
Mis-posted! Meant to start a new thread! emebohw@netscape.net (sumGirl) wrote in message news:<a5e13cff.0404190558.7da91e40@posting.google.com>... > Hi all! Throwing myslef on your mercy here - I have a RS6000 with 4 > processors running IDS 9.40.FC2 and I just went from 1 gig o…
Re: Performance advice
No change you ever make will have one fiftieth of the impact of adding more BUFFERS. So add away, start with increasing it to, say 750000. Use onstat -g seg to ensure that you have no added shared memory virtual segments, and increase SHMVIRTSIZE if you do. "sumGirl" <emebohw@n…
Performance advice
Try increasing the buffers and monitoring onstat -p, if you are allocating additional segments (onstat -g seg) then up your shmvirtsize. AIX has (had??) a hard limit of 10 segments for any process sumGirl wrote: > > Hi all! Throwing myslef on your mercy here - I have a RS6000 wi…
Re: Work group edition - Unlimited edition??
> I found this > http://www-306.ibm.com/software/data/informix/ids/workgroup/ Following this link it states table level restore. I thought the only way a table level restore was possible is by putting the table in its own dbspace. Does IDS now have a true table level restore?…
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…
table/database/dbspace recovery
One of my customers has an 84Gbyte instance which contains a lare number of databases. They run this 24 by 7. For administrative reasons they require to access a copy of the database from about 2 months ago, but they can't revert the whole system. They do have a parallel machin…
Re: Long checkpoints : IDS and SCO
one way to counteracct the effects of long checkpoints is to have them more often. You can tune the LRU_MAX_DIRTY and LRU_MIN_DIRTY parameters (make them smaller) so that the LRUs are flushed more often. cl wrote: > Details : > servers : ml570 4 proc (xeon933) 2Go RAM , SCO Op…
Long checkpoints : IDS and SCO
Start with smaller LRU parameters: LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit or even smaller (2/1) Nebojsa On 2 Apr 2004 05:10:32 -0800, clegendr@yahoo.fr (cl) wrote: >Detail…
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,…
Help parameters RA_PAGES,RA_THRESHOLD
All I can say to 4000 / 2000 is ... AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAARGH! Don't do it! Try 16/4. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "Necrophilia mea…
Re: Informix Performance
Middle of the night... Maybe batch jobs are running which are retaining locks for a long time and the users are running into those locks? "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.0402261055.34916f88@posting.google.com... > Hi, > > I am …
RE: Informix Performance
What is your OS? Are you also using cooked chunks? What does top (or equivalent) show on your server during the slow times? First look in Unix to see what the limit is, if any. Then look in Informix to determine any resource contention... onstat -u Anything obvious for users …
RE: Informix Performance
> -----Original Message----- > From: daniel.castro@feliciorocho.org.br > [SMTP:daniel.castro@feliciorocho.org.br] > Sent: Thursday, February 26, 2004 1:55 PM > To: informix-list@iiug.org > Subject: Informix Performance > > Hi, > > I am having informix performance problems. I don�…
Informix Performance
Application? OS? Hardware, esp amount of physical memory? Profile of usage of application: eg times of heavy online use; times of batch job runs etc? Output of onstat -g iov also please. "Daniel Castro" <daniel.castro@feliciorocho.org.br> wrote in message news:f86fe5d3.04022610…
OnBar Question
Hi Is it possible to restore a single database using onbar or is it the complete instance ?…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
Re: Whatcha' wanta have?????
> They don't have anything to compare to the 'simplicity' of onbar > or ontape. > Hmmm - I think you may have been reading the wrong parts of the doc - please make sure to check out the RMAN (Recovery Manager) documentation. While you can use standard OS utilities to do a ba…
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…
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…
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.…
Re: Perfomance Tuning
Guys thanks for your contributions. there are some points that have helped me like, A checkpoint cannot proceed while a user is in a critical session.Have been actin on this. Thanks guys. "Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message news:<br7lpe$sc7$1@terabinaries.xmiss…
Informix Freeze or Down
It seems there is some procedure which is owned by Informix. Check-out is there any stored procedure. Thanks Zafar shay@formula-travel.com (shay) wrote in message news:<c08a9d47.0312150910.29e904ef@posting.google.com>... > Hi All, > > I need the group help on this issue (Informi…
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…
RE: Perfomance Tuning
When you say your checkpoints "should be 6 seconds", does that mean they actually were 6 seconds at one time and increased to 10? If that is the case, you need to identify what is causing this increase in checkpoint duration. Do you have an I/O bottleneck? Check sar -d during …
Perfomance Tuning
Hi, You could increase the buffers number. A memory size of 4Gb allows you to do so. In our case, we have 700'000 buffers (2048b each), which means that we almost reached IDS limits of current version (IDS 7.30, soon migrating to 9.40). We also declared strategic tables and index…
HDR Logical Recovery Problems
Hi! We are running HDR in a testenvironment with IDS 9.30FC3X3 on HP Tru64 5.1B. We got errors from HDR: teszi06 ( primary ): 04:17:30 DR: ping timeout 04:17:30 DR: Receive error 04:17:30 Checkpoint Completed: duration was 66 seconds. 04:17:30 Checkpoint loguniq 4890, logpos 0…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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?…
IDS 7.31FC1 restore problem
I am having a problem restoring level 0 dbspace backups . the restore starts and root dbspace gets restored but the system then appear to hangs while waiting for a checkpoint. please help…
IDS restore stuck in fast recovery during restore
Hi I am busy with a physical restore on all the dbspaces of a SAP system runnug on IDS7.31.FD1 on solaris8 and I am running into a problem where the engine gets stuck for hours waiting for checkpoint while in fast recovery. The output of running the onstat - command is : Inform…
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.…
Shared memory. Error.
Hi, - When starting informix the following error appears: 12:52:14 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized. 12:52:14 Physical Recovery Started. 12:52:14 The chunk '/home/informix/dbs/tempdbs' must have owner-ID "informix" a nd group-ID "root". 1…
Informix 9.40 crash.
Hi all, today the informix instance crashed. The machine configuration is the following: Informix Dynamic Server Version 9.40.FC1 Compaq Tru64 UNIX V5.1B (Rev. 2650) And this is a part of online.log... 16:59:33 DR: Reservation of the last logical log for log backup turned on…
Trying to recover Secondary using ontape -l
I have an HDR setup (IDS 7.31 on SCO UNIX). As an experiment, I shutdown the Secondary for the weekend. I have logical log backups every hour on the Primary using a disk file. On the first workday, I restarted the Secondary and it went into Fast Recovery(Sec) mode. The messag…
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…
Logical Logging error for 'OLDRSAM:HDELETE' in 'logread'
Hi, I have a problem with fast recovery logical restore. I was running delete sentences, to many, and I aborted program. For this reason, the server changed your mode: online to fast recovery. The problem is: I don`t change to online mode. I study different options and I can't r…
RE: UNIX-Box slow down while execute stored procedure
Start with ... When you run the procedure from dbaccess on the server how long does it take? Do you have the explain plan for the sqls in the procedure? (set explain on; update statistics for your_procname;) MW > -----Original Message----- > From: owner-informix-list@iiug.org …
Re: Re: RE: Backup/Restore
Hi brother - ontape ALWAYS asks for logical logs recovery when you perform a restore. Of course, you MUST keep backing up your logical logs in between archive backups :-) - Informix (ontape) DO KNOWS which logical log to recover. A suggested routine could be this: archive backu…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
Is there recovery from this?
I upgraded Informix IDS from 7.24.UC7 to 7.31.UD6 over the weekend, and = everything was fine with our production instance, but I couldn't get our = Test instance back. It seems like someone (me) forgot to shut down that instance before = upgrading....I got errors complaining ab…
Re: Physical restore that doesn't require a logical restore
Hi, if you try to move data from a host to another, you MUST perform a backup with -w option, this option is for whole backups. The Restore must also be performed with the option -w. You can try perform a Restore with the option time-of-point. Regards Glenn c-eriks@algonet.se (…
Re: Physical restore that doesn't require a logical restore
I did that but then this happened (from the message log): 15:58:54 Physical Restore of felisia_db01 Completed. 15:58:54 Checkpoint Completed: duration was 0 seconds. 15:58:54 Checkpoint loguniq 5720, logpos 0x18 16:10:39 No logical log restore will be performed. 16:10:39 …
Backup/Restore
Hello, We're running on AIX 4.3, ids 7.31. The backup of the system lasts for about 30 minutes, but the restore(on a duplicate test-system) lasts 3 hours. I heard that the restore may last 2 or 3 times the backup time, but 3 hours is too long. Nobody could find anything in soft-…
disaster recovery using ontape
Hi, We are putting in a machine to function as both our test and off-site disaster recovery box. I will need to configure the new machine to be able to come up after a restore of the database. I recall a thread but could not find in the archives, when using ontape to restore, t…
Database with buffered and unbuffered log.
On Tue, 09 Sep 2003 06:32:19 -0400, Suket wrote: > What is significance of Informix database buffered log or unbuffered log > parameter. Gorazd almost got it. Informix ALWAYS write logical log records to one of the three logical log buffers (sized with the LOGBUFF onconfig par…
Re: Physical restore that doesn't require a logical restore
Hi! How can I delete all logical log backups? Delete them from the Networker server? I don't understand what to do here! When is the ixbar.# file used by the engine and onbar respectively? I will try what you suggest when I understand more about the entries in the ixbar.# file…
Re: Physical restore that doesn't require a logical restore
After the physical restore completes bring the engine online using onmode -m. System should do fast recovery and come up. Mark ----- Original Message ----- From: "Christian Eriksson" <c-eriks@algonet.se> To: <informix-list@iiug.org> Sent: Wednesday, September 03, 2003 17:03 Su…
Physical restore that doesn't require a logical restore
Hi! How do I ensure that my physical restore, onbar -r -p, isn't followed by a logical restore, i. e. followed by applying the logical logs since the last full or incremental backup? I want to use this in database server migration, as an imported restore, and I want the migratio…
RE: Restarting HDR
Yes, that is correct. As long as the logical logs have not "wrapped", you will not need to do logical recovery. HDR will automatically "send" the necessary logical logs from the primary to the secondary. HTH, Paul Mosser -----Original Message----- From: Jack A [mailto:jacka8@…
Informix Data Replication drop after reboot
I encounter a problem during reboot the Primary server which turn off the data replication process as below: Informix Dynamic Server Initialized -- Shared Memory Initialized. DR: Trying to connect to secondary server ... DR: Receive error DR: Type exchange failed Physical Re…
Restore Problem
I did a restore on our teste server and received the output below. This was a Level 0 backup. Any help is greatly appreciated. D:>ontape -r **Removed dbspace list from output Continue restore? (y/n)y Do you want to back up the logs? (y/n)n Restore a levl 1 archive (y/n) n Do y…
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
Recovery Mode
How do I go back into online mode from recovery mode?... My 9.3 database is in recovery mode after a database restore from tape...…
Can you back up a database using ontape ?
Is it possible to backup just a database as opposed to backing up dbspaces ? I want to only backup a database and restore it on another box. Is that even possible ?…
Re: PDQ with lots of threads waiting poor peformance vs RAID5
Jay, How many rows does your statement put into temp table tmp_e06? What I suspect is that you produce lots of rows which are all sent to the sqlexec thread. It then has to put them all into the temp table. If that's so, your problem is that the temp table is not fragmented and …
Clarification regarding backup & recovery.....
Hello all , I would like to clarify regarding the ONBAR restore mechanism for a scenario which i explained below. I performed a cold restore with the most recent (level0+level1+logs). Now, the database is back to online mode. 1) Is it ok if i just continue with incremental…
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…
onbar error on openserver 5.05
when I backup small data ,backup and restore all are normal.…
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…
Re: Fast recovery question
On Thu, 31 Jul 2003 11:54:44 -0400, samir BADAOUI wrote: The fast recovery will start alllll over again. Until the engine is fully recovered nothing is written to the logical logs that would indicate partial progress. Art S. Kagel > Hi all, > After a kill process who was delet…
Fast recovery question
Hi all, After a kill process who was deleting 3 millions of records. when my informix instance goes up, she went on fast recovery. After 6 hours of fast recovery, my sys admin stoped the engine (I wasn't there this night). my question is : When the engine goes up, did the fast re…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: Spin locks bringing system to a crawl
Jay, Your spin locks look fine. The most critical number is Avg Loop/Wait which should be low. That you see a long list of spin locks is normal for a large and heavily loaded system. The profile shows a high number of sequential scans. This might be worth looking into if it inc…
RE: Too many Locks
What makes you think it's locks? You might want to first identify your performance problem. Are you bottlenecked on some OS resource? Check your sar statistics when you are expierencing this performance problem. sar -u for CPU, sar -d for disk and sar -w for memory(swapping).…
restore logical log
How to restore logical log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a log…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
Recovery from filesbackup
Hi How do i recover (setup) my informix database when i only have the database files from a filebackup ? I need to set it up on a new server. /Thanks…
Re: Disaster recovery [1405]
Better: Use the ALARMPROGRAM for logical log backup then as soon as that log archive is completed ship the file to the backup and apply it (ie keep ontape -r running constantly waiting for the next logical log file and then just reply 'Y' once the new file shows up. (You can us…
Disaster recovery
Hi, We plan to implement a simple recovery mechanism. We have primary and secondary( has same instance ) machine. Both with same versions of IDS. We plan to enable logical log backups on primary machine to a file and then enable rsync for this log backup file to remote file ( …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
Informix Disaster Recovery Strategy
HI, I have a 7.3.1UD4 Informix system running a "timesheet" application. We are in the process of setting up a Disaster Recovery site for our systems and I have been tasked with coming up with a solution for the Informix system. Does anyone have any suggestions as to the best …
ontape -r
Hi, I am trying to restore a 7.21 IDS DB on a DS10 box. The problem is that the database was first running on a DS20 dual-processor machine. Now I would like to restore the DB from a backup to the DS10 uniprocessor machine. While the restore begans (ontape -r) the machine stalls.…
Restore problem
Somebody can help me, I have the next problem: SAPComponent: R/3 Release 46B Kernel 46D parche 534 DB System Base de datos Informix DB release Informix 7.31.FD1 DBSL version 46D.00 SISTEMA OPERATIVO Sistema Operativo UNIX V4.0F Modelo True 64 Compaq RESPALDO Utlileria de respald…
Restore problem!!
Does anyone can help me with this error. APLICACION: SAPComponent: R/3 Release 46B Kernel 46D parche 534 DB System Base de datos Informix DB release Informix 7.31.FD1 DBSL version 46D.00 SISTEMA OPERATIVO Sistema Operativo UNIX V4.0F Modelo True 64 Compaq RESPALDO Utlileria de r…
Maximum server connections 0
Get following message in the online.log.All client can't connect to IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance…
Re: Fast Recovery (CKPT REQ) mode
I resend this because I got a couple of rejections from the mail-server ... Please excuse in case you get this twice. -- Hi, you can try to find out in online.log (message log), where exactly the server is. Keep in mind, that this step (mainly) involves rolling back open trans…
Fast Recovery (CKPT REQ) mode
Hi, We are restoring the backup of prd system to drs system, restoration part is successful. but drs database is not coming in quiescent Mode , it is in Fast Recovery (CKPT REQ) mode, i tried to do force checkoint (onmode -c). Any suggestion on this problem would be appreciated…
Re: What will happen if I start Archive before cancelling Logical Log.
Murat YILDIZ wrote: > > In article <3A7BD0F4.C3FBD1A0@hotmail.com>, > Brett Randall <brett_s_rREMOVECAPITALS@hotmail.com> wrote: > > > > Murat YILDIZ wrote: > > > > > > What will happen if I start a Level 0 Archive on a DLT while Logical > > > log continues on another tape devi…
RE: Fast recovery
We recently had a tbzero (truncate logical logs) done on our system. I had a down dbspace and the engine wouldn't come up, no matter what we did. The only way out was for Tech Support to do the tbzero. They did warn me that we might have problems afterwards, but so far so good…
Fast recovery
Pursuant to my question earlier regarding the dropping of an index; the engine was brought down shortly after the first index drop completed, after a few minutes of the second. It's probable that these two are in the same transaction so I expect they'll both get backed out. Th…
RE: OFF_RECVRY_THREADS and ON_RECVRY_THREADS
I recently attended an Informix Internals class. According to my instructor, the OFF_RECVRY_THREADS parameter affects logical recovery operations. Each thread is assigned for recovery of a different table. The instructor recommended the following settings: * OFF_RECVRY_THREADS …
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
Does anyone have any experience of these parameters and what their effect on restore times is ??? -- Earle A Long (Senior Informix DBA) SINGLEPOINT UK LTD…
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.…
fast recovery question
Hi all, in my message log I have found the following lines : 18:10:05 Logical Recovery Complete. 3 Commited, 2 Rolled Back, 1 Open, 0 Bad Locks Please tel me to what des the Open value during logical recovery refer ? thanks for any help __________________________________…
Database is on line ,but has warnings
WARNING: Network Down **--Recovery------- Press CTRL-W for Help. ------ Why? thank you Sent via Deja.com http://www.deja.com/ Before you buy.…
Restore problem
hi guys, I have level-0 backup on N Class HP11 DLT8000, informix 7.3. My problem is when I tried to restore onto a lower end server HP K580 DLT4000, it was aborted immediately. with error couldn't read from tape. I believe it's due to compression format was different between …
Fast Recovery Mode after ontape cold restore
I am testing a couple of recovery scenarios. After a cold restore using ontape where one disc has been replaced (non RAID) the instance comes up in Fast Recovery Mode and seems to hang there. What actually occurs in Fast Recovery Mode, there are no logical logs? How long should…
Data Restoring
Dear Useres, Ver : Informix 7.30 OS : HP-UX 10.2 I need to replicate the data from the production machine to test machine daily. Is't possible to resotore the logical logs files alone, from the production machine daily or is'any other faster way to do this. We are not in …
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Restore a table
eonder@my-deja.com wrote: > I need to restore only a table from an archive; how can I do this ? It is possible only if this table is created in it's own dbspace. So, You can restore this particular dbspace.…
Restore a table
Hello. I have Informix DS 7.31 on Digital Unix. Every night I execute a database backup ( only level 0 ) with ontape utility. I need to restore only a table from an archive; how can I do this ? Regards Enrico Sent via Deja.com http://www.deja.com/ Before you buy.…
tlipoll.c error
I've got Online 7.12 running on a SCO OpenServer 5.0.4 and loaded about 2GB of data into the database. I wanted to configure the I-Connect utillity. When I add an entry for the DBSERVERALIASES in the onconfig file, Informix do not start up. In the log file the following error a…
Ontape Restore
I am trying to restore a dbspace from one instance to another instance on another server. The instances are setup exactly the same except for mirroring -- the dbspaces have the same names, the chunks have the same names, sizes and offsets, and the logical and physical logs are t…
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Point-in-time recovery of database/dbspace
gorgos@my-deja.com wrote: > > Hello again, > I've just come across an article in technotes that mentions point-in- > time recovery of a database/dbspace. It doesn't go into any depth so > I'm asking if this is possible, and if so how. I'm sure it can be > achieved using a 2 ins…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
OnBar/OnTape
Onbar and Ontape are two different animals when it comes to logical logs. Remember that onbar is Storage manager based and the recover file it creates (ixbar.x) assumes that all the recovery media is in one location - the storage manager. With ontape, you could "mix and match" a…
performance with very active threads
During a checkpoint you only have 8 cleaners utilized to flush 63 LRU's. That's 4 passes. Make LRUS=64 and CLEANERS=64. That's one pass. Let the disk subsystem figure out any contention. They're pretty good at that:) Also increase CKPTINTVL to every 30 minutes. Why have a …
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: Backup and Restore
From: mdelerme@my-deja.com > >Does Informix support recovery of up to the last transaction? I was Yes, up to the last committed transaction. Fast Recovery. >told Oracle did, ???, wanted to know if that was true and if so, does >informix. Thanks in advance for the info. Pleasur…
Backup and Restore
Hi all, Does Informix support recovery of up to the last transaction? I was told Oracle did, ???, wanted to know if that was true and if so, does informix. Thanks in advance for the info. Marco Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: FW: Re: Database Crash...Help
From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> > > > Thanks for all your replies. > > > > I could restore the database. I did a full database restore. Then the > > database went to recovery mode. It was in recovery mode for long time. >Now > > to make it online what should I do. …
FW: Re: Database Crash...Help
> Thanks for all your replies. > > I could restore the database. I did a full database restore. Then the > database went to recovery mode. It was in recovery mode for long time. Now > to make it online what should I do. Will it change to online mode > automatically. > > Pls advic…
Problem with the restore ...
Here is the case: We have production system and a training system. Training system has data that comes from restore of production system level 0 backup. Last week our training system disk crashed. We put a new disk. Informix had to be initialized and so …
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
backup and restore
I create a demo datebase on dbspace1 and I backup the IDS with ontape -s and ontape -a then I drop the demo datebase when I restore with ontape -r -D dbspace1 online I find the dbspace1 is down but I can not online the dbspace1 with onspaces -s dbspace1 -p PATH -o offset -O sor…
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…
How to restore logical logs from file ?
hi all, my logical log files are saved to file (each logical log is one file) LTAPEDEV =/tmp/logfile will be removed each time after back up with ontape -a The Problem is that informix crashes when i try to recover them. The 1st one will be read successfully but then informix g…
Logical log full !
Our OL Database has its logical log full with a very long transaction not ended, ond it seems impossible to make a recovery of the database. Now when the database is restarted, it's launched in recovery mode and it stay in this state and there is nothing to do. Can you help us ?…
RE: restore using ontape
"Art S. Kagel" wrote: > When you do the level 0 archive it asks whether to backup the current > logical log, other than that the logical logs are archived separately using > ontape -a or ontape -c to the LTAPEDEV device or file. When you restore > answer YES to the logical logs…
Re: Slowness
Leonids, Do you use OPTCOMPIND 0 for OLTP system? I have also read that OPTCOMPIND should be 0 for OLTP and 2 for DSS systems. But I haven't tried that yet. We use OPTCOMPIND 1. Thanks in advance for you reply, Vinod Bhansali >>From: Leonids.Voroncovs@dati.lv >>Reply-To: Leoni…
Re: Slowness
Leonids, Do you use OPTCOMPIND for OLTP system? I have also read that OPTCOMPIND should be 0 for OLTP and 2 for DSS systems. But I haven't tried that yet. We use OPTCOMPIND 1. Thanks in advance for you reply, Vinod Bhansali >From: Leonids.Voroncovs@dati.lv >Reply-To: Leonids.V…
Re: Slowness
Boscia wrote: > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 8 days 14:54:51 > -- 491520 Kbytes How much memory You have? OS needs some memory too. > ROOTSIZE 1500000 # Size of root dbspace (Kbytes) You need such a big rootdbs really? Only 3 Mb …
Question about database recovery
Thank you very much. Suppose the logical log size is 2M and the log dbspace is 500M , what I want to do is: when a logical log (not logical buffer in memory) is complete, can I retrive a "single" logical log from the log dbspace (that is the key point)and transfer it to the back…
Re: ontape
Hi Keith, Informix always starts it restore using the Level-0 backup. If you have Level-0 backups from different dates. You can restore whatever Level-0 you want. Don "Lewis, Keith A." wrote: > When using ontape as the backup and restore mechanism can the database be > restor…
Problems with logs
Here is a log: 11:18:29 Checkpoint Completed: duration was 0 seconds. 11:19:06 Logical Log 140 Complete. 11:19:10 Logical Logging error in 'rollback' 11:19:10 Assert Failed: Dynamic Server must abort 11:19:10 Informix Dynamic Server Version 7.30.TC7 after oninit: 11:32:0…
Problems with shared memory
On my machine I've observed a strange thing. After initialization IDS create virtual segment (500MB!!) For now I don't now why!!! after "onmode -F" everyting is ok Here is a log... 16:26:22 Informix Dynamic Server Initialized -- Shared Memory Initialized. 16:26:22 Physical R…
Two questions
Hi 1) Is it possible to use onbar as a backup/restore solution for Informix Server instances that back up logical logs to /dev/null? I was under the impression that it is mandatory to save logical logs if onbar is to be used because logical recovery cannot be skipped with onbar…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
RE: HELP AGAIN ...
In article <8fg29u$2aa$1@news.xmission.com>, shahid.mehmood@aku.edu writes > >No, it is not synonym or view! it is definitely a table, here is the schema >of the table ... Try onstat - Is the server On-line and not in Fast Recovery? onstat -g ath are there any sqle…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
RE: Fuzzy checkpoints.
<SNIP> >To William's statement that he does not trust Fuzzy Checkpoint and so has >to restore an archive and roll forward the logical logs, I submit that that >will result in the exact same level of data loss as fast recovery OR MORE, >but never less. Since you do not trust the …
RE: Fuzzy checkpoints.
William Rice wrote: > > Comments further in > >===== Original Message From kagel@bloomberg.net ===== > >Remember that the Physical Log records are not STRICTLY needed for recovery. > >They are mostly a paranoid holdover. The physical log slapdown that starts > >Fast Recovery mak…
help with restore
We are planning to restore the database from an old tape in December since some data got deleted from a table. Some of our tables have added columns or their columns have changed since the backup. Will we need to restore the entire database including rootdbs, or can we just do a …
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…
Informix Password Recovery
If you know of any security weaknesses which would allow the recovery of administrator passwords more rapidly than a brute-force attack or are aware of any cracking programs for Informix I would appreciate hearing from you with information. Also, if you would be interested in a …
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…
logical restore
Hello, we run Informix Dynamic Server Version 7.31.UC2AX4 on SINIX-Y 5.43. Problem for normal logical restore About one case "Restore complete with Rollforward with local tapes". for SMP test execution: 1.Login as 'smsadm1' and bring down the SMP processes. 2.Exit then login …
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: RAID v Mirror
From: watawinona@aol.com (Watawinona) > >Cooked files is a good compromise amoung ease of administrating, >performance >and recovery capabilities. With all due respect, bollocks. In what way are they easier to administer, better in performance and more useful in recovery capabil…
RAID v Mirror
Cooked files is a good compromise amoung ease of administrating, performance and recovery capabilities. Nona…
switching disks then restoring with onbar problems
Try BAR_DEBUG=7 repeat the restore and check the trace for errors. Nona…
restore question
I am running Informix 7.24 and I have a question for anyone who can answer it I have been backing up my production server and restoring it on my backup system once a week for about 6 months. This past weekend I tried to restore but the restore never finished. It normally runs fo…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
RE: Ontape -r
Nigel Gall wrote: > This brings me to another question. Why does the restore process require > the lgoical logs to complete the restore process? Let me explain by giving > an example. > > I did an ontape -r warm restore recently (after completing Y2K testing) and > when I resp…
onbar restore
Hi, I am running Informix 8.2UD4 on HP-UX 11.0 and the storage manager is OmniBackII 3.1. I want to test the restore from the tapes. How to drop one dbspace and restore that dbspace using the onbar. Thanks -- Ali Wasef wasef@onebox.com - email ________________________________…
onbar restore
Hi, I am running Informix 8.2UD4 on HP-UX 11.0 and the storage manager is OmniBackII 3.1. I want to test the restore from the tapes. How to drop one dbspace and restore using the onbar. Thanks -- Ali Wasef wasef@onebox.com - email _____________________________________________…
Restore a database on another server
Hi, I should restore one database from a server SERVER1 - ol_name1 to another server SERVER2 - ol_name1. On that tape you could find four databases : ol_name1 db1 db2 db3 db4 I only need one table from db1. What is the best way to do …
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…
Data Recovery
*ESS Data Recovery Labs* ESS Data Recovery is one of the fastest and most technologically advanced data recovery leaders in the World. We have technology to recover data from hundreds of causes. We can recover data from fires, floods, computer viruses, electrical failure, faile…
ontape -r (restore error)
Hi all, I am perform test for the backup and restore by using "ontape" utility. But I am unable to restore it. I got the follow error: Physical restore failed - restore reserved pages failed The backup "onstat -s -L 0" is success completed but unable to restore. An…
Logical Restore
Is there some way of joining log files up that were created by ontape -a so that its like an ontape -c. Greg E…
Point in time recovery using logical log tapes
I have a question on point in time recovery. I backup the databases using ontape. I have a situation in which I need to restore the logical logs only till a certain point. i.e. if a logical log tape contains logs 5 - 15, and I need to restore only till log # 9. This is what happe…
RE: Stuck in FAST RECOVERY
The emailing of Tech Alerts is available. I get them (the link) emailed to me. Sorry I cannot remember where I registered, but it was through Tech Support ... and you DO need to be registered. If you need more info, email me directly and I will find out how I got it. Murray Wo…
Re: Stuck in FAST RECOVERY
If you are seeing any activity wait it out, otherwise stopping and restarting the engine sometimes sorts it. "Gregory P. Schin" wrote: > > Hi, > > I have IDS 7.31.UC2A installed on Solaris and it has been running fine > for over 1 month. I deleted some data then dropped a few …
Stuck in FAST RECOVERY
Hi, I have IDS 7.31.UC2A installed on Solaris and it has been running fine for over 1 month. I deleted some data then dropped a few primary keys on some tables and then added unique indexes. Then there was a power hit and the system rebooted. The system came back up but IDS …
INFORMIX ONLINE startup time
In article <81c0al$6l7$1@scesie13.sie.siemens.at>, "Martin Sambor" <martin.sambor@siemens.at> wrote: > hello > > I want to know which parameter have influence at the startup time (normal > oninit, no oninit -i) from informix online (7.24 or higher). > Is this based only on the …
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
backup and restore
Hi, I have an IDS 7.30 on Solaris 2.6 with 5 databases. Which is the best method to backup and restore the databases. I need to restore the databases separately.…
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…
database recovery
Hi, I had made a major mistake in history - removed a chunk file accidentally. The bad thing is that I don't even have a backup (DONT!) Now, oninit just complains that it couldn't find the primary chunk file, and never starts up the database. HELP! What can I do? I don't mi…
Database Restore...
Greetings.. I need to restore a database. I have a Level 0 backup from last night and a tape with 5 log files since that last Level 0 backup. I simply want to overwrite the existing database. What is the command to copy all full and partial log files?? Should the current da…
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…
Informix - I NEED SOME HELP
I am trying to get some information about Informix, conserning how its concurrency is functioning, and how they are dealing with recovery ... Can anyone help on this problem - I need an answer PRETTY soon.. Thanx Carlsberg…
OnBar & Ontape
Hi, Just wondering is it possible to archive using OnBar, and the logical logs to be done by ontape? In times of restoration, OnBar to restore the archive, followed by ontape for rolling forward transactions. Thanks Steven…
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…
Backup and Restore
Hello All- I am new in the Informix world. I've inherited an Informix database system with little documentation. One of the first things I'd like to do is know the procedures to backup and restore. The Informix version is 7.3. Is there something out there in print or someone…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
backup / restore
Hi I have on my IDS 7.30 for solaris 2.6 5 databases, which I want to backup and restore separately. Which ist the best method ? Thanks…
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…
recovery
I have an instance that was somewhat hosed up while testing backup/restore through ontape. It is currently offline. When I try to bring it back to quiesent mode through onmonitor it cancels out while recovering saying 'oninit: Fatal error in shared memory initialization' and it…
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.…
backup and recovery
Hi, following situation: We have a full-database dump. Now I just need the information of one table. Is it possible to import into a newly created db having the same user that did the dump just that single table? Antje -- --------------------------------------------------------…
restoring data
hi, I have a question : if I have backuped my data base (archive niveau 0) with ontape, but my configuration (in discks) has changed. how can I restore my database ?? Thanks for any response…
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…
Re: Warm recover failure question
> But LTAPE parameter is '/dev/null'. I think the "Inconsistent Status" is > logically right whether the engine is restarted, or not. > I think so because the logical recovery cannot make the dbspace up to date.. > > Am I correct ?? You are partially correct. Without log backup…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Initalisation error
> Can anyone help please? > The informix/templog file (chunk) has been deleted by mistake. A level > 0 restore was done but we cannot now bring informix online. > > INFORMIX-OnLine Version 7.13.UC7 > > The following messages appear from onmonitor:- > > oninit: Fatal error in shar…
Initalisation error
Can anyone help please? The informix/templog file (chunk) has been deleted by mistake. A level 0 restore was done but we cannot now bring informix online. INFORMIX-OnLine Version 7.13.UC7 The following messages appear from onmonitor:- oninit: Fatal error in shared memory initi…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
Time flies
In article <7ih39n$f3f$1@taliesin.netcom.net.uk>, "Neil Truby" <ntruby@netcomuk.co.uk> wrote: > I'm intending to update the time on two production servers (K460 HP-UX > 10.20). One's 5 minutes fast and one's 5 minutes slow. > > Does anyone know of any problems this might cause…
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…
Problem during OnBar restore
Doing a cold (OnBar -r -w) restore of a database backed up on one server to another server. Copied all of Informix directories from old server to new server. Started running restore, which uses ADSM as storage manager. As data is being processed (at least being sent from ADSM …
Ontape Restores
Does anyone have a Unix script to automate the Ontape -r (archive restore) function? Thanks for any assistance.…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
HELP - Logical Logs are full - Online halted
Can anyone assist with the following problem: 1) Very long transaction aborted (loading of large table) 2) Appears that logical logs are completely full and transaction can not roll back. 3) Informix Online was taken offline and restarted 4) Online will not "recover" from recover…
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…
CRASH...HELP
This happened last month, and I thought I had it figured out after some of your help. Then it happened again yesterday. I run Informix 7.1 on digital Unix 1000 server. Here is my online.log and the af. file. 09:13:05 Checkpoint Completed: duration was 0 seconds. 09:13:18 Asser…
restoring probles
Hi , I have a problem to restore OnLine archive ( Levele 0 ). I prepared this archive from a ss-20 with solaris 1.0 and It's Online version is 5.08 and I want to restore this archive to the same Online version and different version of OS ( solaris 2.5 ) but I get an Error ( sem…
is it recovery functions liks oracle's commit command in informix?
is it recovery functions liks oracle's commit sql command in informix? if it is, what command? same? ----------------------------- e-mail : soph@doit.ajou.ac.kr…
Need help w/ ontape -r
I was trying to restore a test database using ontape. It went fine when I just restored off the system tape (ontape -s -L 0), but I encountered problems whenever I tried to restore the logical logs. I ran out of room in /tmp and the restore just came to a halt! Is there a way …
not enough memory in /tmp for ontape -r
I was trying to restore a test database using ontape. It went fine when I just restored off the system tape (ontape -s -L 0), but I encountered problems whenever I tried to restore the logical logs. I ran out of room in /tmp and the restore just came to a halt! Is there a way …
is anybody listening
Ok I'll try again. Please help. I am running Informix v7.1 under UNIX on a digital 1000 server. We have been running fine for several years, with the 'normal' bumps and grinds. Lately, checkpoints will stop and then online froze, a reboot has helped as a Band-Aid only. The other …
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…
logical logs file
after restor the database by "ontape -r" the oninit fail with the message " logical log file not found Can you help me Marcel…
URGENT: assertion failure during logical recovery
Has anyone seen this before? The physical recovery succeeds but the logical recovery (log 146 and log 147 only) fails ? If I can't roll log 147 forward my users lose a days work - a disaster ! Geoff Poole Oxford GlycoSciences geoffrey.poole@ogs.co.uk onbar -r -w -p -t '1999-03-1…
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…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
Replication Error
Hi, in our online.log we see sometimes messages like 00:01:00 CDR Schedule Manager initialization complete. 00:01:00 CDR GC: catalog recovery begin 00:01:01 CDRGC: server recovery complete 00:01:11 CDR GC: replicate recovery complete 00:01:18 CDR GC:replicate pending state reco…
ontape restores of downlevel database
Trying to restore an ontape of a database taken with 7.23 to a 7.24 Informix instance. Getting 'cannot fork server connection'. Is it even POSSIBLE to do the restore, or is this telling me something else?? Doug Agnew DBA Charlotte Pipe & Foundry dagnew@charlottepipe.com…
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…
Restoring with ontape
I have to restore a database from archives which were written with ontape. The restore tapes are a couple of years old and I don't know anything about the layout of the database at this time ( dbspaces, onconfig etc). Is there any way to re-create a database based on this tape…
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
Backup/Restore Question
Hi all, Is there backup/restore system in Informix Online DS where I can restore an individual table, not complete dbspace? Thanks in advance.…
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: tbinit without logical recovery ??
Michal Hajek wrote: > > June Tong wrote: > > Art S. Kagel wrote: [SNIP previous discussion] > PS: I even found (somewhere on net) that 7.x has -p switch for tbtape > which causes not doing logical recovery during recovery .. it is true ? The -p (Physical Restore) switch to ontap…
Re: tbinit without logical recovery ??
Art S. Kagel wrote: > The ONLY way: Call Informix Tech support and they can log in and > truncate the logical logfiles so that the engine thinks the log ends > at the beginning of log file with the last checkpoint. Then you can > bring the engine up. You do need to go through…
Re: tbinit without logical recovery ??
Michal Hajek wrote: > > We fall into problems with logical logs. I know it is a dirty > action, but is it possible to initialize online with only > physical recovery and without logical recovery ? > > I believe I see potential problems after doing that, but in our > case it would…
Re: tbinit without logical recovery ??
Michal Hajek wrote: > > We fall into problems with logical logs. I know it is a dirty > action, but is it possible to initialize online with only > physical recovery and without logical recovery ? > Are you in the situation where a transaction back-out has itself run out of log s…
tbinit without logical recovery ??
We fall into problems with logical logs. I know it is a dirty action, but is it possible to initialize online with only physical recovery and without logical recovery ? I believe I see potential problems after doing that, but in our case it would be better solution than restorin…
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 …
Cannot Rollforward from Checkpoint
Hi, Could anyone give any advice on how to fix this problem with an online database (7.23 IDS). When I try to bring the database back online, I get the following log entries, and the engine remains down. HELP !! 14:38:14 INFORMIX-OnLine Initialized -- Shared Memory Initialize…
Cannot Rollforward from Checkpoint
Hi, Could anyone give any advice on how to fix this problem with an online database (7.23 IDS). When I try to bring the database back online, I get the following log entries, and the engine remains down. HELP !! 14:38:14 INFORMIX-OnLine Initialized -- Shared Memory Initialize…
INFORMIX-RESTORE
Hi Informixers, I am looking for a tool for backup/restore of = databases. I have tried : ontape and dbexport but ontape don=B4t let me = get a restore of a database (i know using arcunload, but it is carefully = doing that). On the other hand dbexport requires an exclusive lock…
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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…
Logical Restores
Gurus, I am restoring my production backup onto a DR server on a daily basis, which is working fine using OnBar (-r -w -p). However there is a requirement for intra-day restores of the logical logs as they are backed up on the prod server. Can I do regular logical restores on t…
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…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
Question on moving Online from one machine to another
I'd like to copy On-Line 7.24 from one Solaris machine ( 2.5.1 ) to another ( 2.6 ). I created an archive on the old machine using ontape -s -L 0. I created an instance on the new machine where all the chunks have the same name ( and are bigger then the original chunks ) and all …
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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…
Restoring With Onbar
This question may be relatively simple. How can I restore back to an archive beyond my last level 0? Just for example, if my last level 0 was in week 3 of the month and I wanted to restore back to the level 0 from week1, how would we do this? I am familiar with the ixbar file,…
Database Recovery?
In reading about Online Dynamic Server, it states that the database will rollforward to the last checkpoint when the server is brought to online from offline if the server crashes. If I do a restore from the day before will it read the logs and bring it up to the last checkpoint…
Re: Stuck in Fast Recovery?
Stephen Walmsley wrote: > > Many thanks for the hints June and Paul. > > Eventually, after 7.5 million reads with no write activity I gave up. I > did try a shutdown followed by a restart as Paul suggested, but the engine > just continued the same pattern of activity. I have no i…
Re: INSERT cursors
Art S. Kagel wrote: > > Jonathan Leffler wrote: > > > > On Thu, 20 Aug 1998, Carlson@WHSmith wrote: [SNIP] > BTW the latest dbcopy > has incomplete recovery code and I am working on full recover code for > it now. The full recovery version of dbcopy.ec was put online Friday. …
Re: Stuck in Fast Recovery?
On Mon, 24 Aug 1998 11:05:55 -0700, June Tong <june_t@hotmail.com> wrote: >Stephen Walmsley wrote: >> (Btw, the answer to the question "What are you running 4.10.UD2 on a >> business critical system for?" is "Waiting for Online to to be released >> on Linux"!!!!) > >Don't know t…
Re: Stuck in Fast Recovery?
Many thanks for the hints June and Paul. Eventually, after 7.5 million reads with no write activity I gave up. I did try a shutdown followed by a restart as Paul suggested, but the engine just continued the same pattern of activity. I have no idea whether it would finally have g…
Re: Stuck in Fast Recovery?
In article <Pine.OSF.3.95.980824103652.29082A-100000@sable.ox.ac.uk>, newc0571@sable.ox.ac.uk (Stephen Walmsley) wrote: > > Online 4.10.UD2 > SCO 3.2.4.2 > > At 17:49 on Saturday I started the build of a huge index. At around > 10:40 > on Sunday, around 17 hours later, the box s…
Re: Stuck in Fast Recovery?
Stephen Walmsley wrote: > Online promptly went into Fast (sic) Recovery and has been in every since. > The logs show that physical recovery completed successfully. What is in your online.log ? You don't mention how long your tbstat -u / -l / -whatever have been at those states…
Stuck in Fast Recovery?
Online 4.10.UD2 SCO 3.2.4.2 At 17:49 on Saturday I started the build of a huge index. At around 10:40 on Sunday, around 17 hours later, the box suffered a loss of power. It's essentially a read-only database; there were no other transactions in progress at the time. Online prom…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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 …
Ontape as fallback for OnBar Test...
Hey gang - some compadres of mine need to test OnBar recovery. I'm thinking an easy, safe way to do it would be to take an ontape level 0 as well just beforehand, so if the OnBar recovery craters, the ontape archive can bail them out. Anybody see any flaws in my suggestion to …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Backup & Restore
We have a new informix database based application and we were following the vendor's backup and restore procedures (as best we could) and we have run into a few problems. First, what we did: onmode -k (offline?) ontape -s (archive level 0 backup, no logs) drop a user table ontap…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Onbar & restore
Hello I've just started using onbar and omniback, so forgive me if the question is basic. I created a level 0 backup. Now I'd like to restore this. When I restore, what I think happens is that onbar salvages the log onto the same device as where my dbspace backup was. So once th…
Onbar with Online 7.23
I'm seeing a strange problem with on bar (Av 20000 / Ux 4.20) under v.23 When i issue "onbar -r", i get the following in the log (there included a page that contains the description of the log file) for example : If the backup finished at logical log 36 and then i issued "onbar -…
Re: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: HELP !!! Recovery mode
Hi ...you need to let the recovery mode get done then it should come up, if on make use on onmonitor util and change the mode...ps why did system flip out?... PiT wrote: > How I can change Recovery Mode to Quiescent mode or > free Logocal logs in this mode ??? > > Best regards …
HELP !!! Recovery mode
How I can change Recovery Mode to Quiescent mode or free Logocal logs in this mode ??? Best regards PiT pit@writeme.com…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Is it really necessary to mirror the physical log?
Art S. Kagel wrote: -- SNIP (Original question) -- > Truth be told the result of Logical Recovery without Physical Recovery > is the same if all logical log records are available. This is > mathematically provable. HOWEVER, having said this, the engine WILL > NOT come up if it …
Re: Is it really necessary to mirror the physical log?
Art S. Kagel wrote: -- SNIP (Original question) -- > Truth be told the result of Logical Recovery without Physical Recovery > is the same if all logical log records are available. This is > mathematically provable. HOWEVER, having said this, the engine WILL > NOT come up if it …
Re: Is it really necessary to mirror the physical log?
Jacob Salomon wrote: [SNIP] > Q: If I choose not too mirror the dbspace containing the physical log > and that DBspace gets corrupted, is recovery still possible without > going back to archive tapes? Would fast recovery still work, albeit > with the possible loss of some recent…
Re: Is it really necessary to mirror the physical log?
>I am about ot start configuring a new site. I am setting up for many >dbspaces but mirroring is basically a luxury here. I have made it my >policy to *always* mirror the root dbspace and that dbspace containing >the logical logs, because if either of those goes south, there go…
Re: Can't free logical logs
Your problem is, INFORMIX needs free logical logs to do it's recovery. Some INFORMIX ports have a tbinit flag, called "-F". This flag forces online to forget the recovery. But, with this flag your database may be inconsistent, after init. Yours Volker Diane Houston schrieb: > …
RE: Can't free logical logs
Hi Diane, Once I entered in a situation exactly like that and I was able to perform an emergencial logical log back-up using ondatartr utility (But my version is 7.x and I don't know if it exists in version 5). I was told that Informix Support has a utility to "bypass" the logi…
Database restore
I'm a 'thrown to the wolves' DBA owing to the sudden illness of a co-worker. Need some fundamental type advice. I need to copy a database from one machine to another, but I want to restore it as a different name. i.e. The source database is called 'aurprod'. I want create thi…
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…
Imported Restore using Onbar
Does any have any information on doing an imported restore using onbar? I have the docs for onbar, but they just have one paragraph on the imported restore, in which they say that onbar allows it as long you use a whole system backup and restore to accomplish this. What I need …
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…
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: Onarchive
I've heard OnArchive is complex, but reliable. Just testing OnBar now and it looks good, but also has complexities and limitations. Informix backup / recovery is perhaps their weakest area of support. ...Terry.…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
911 HELP
Hi there, Does anyone know what to do when the database hangs because of the following error: ----------------- INFORMIX-OnLine Version 7.23.UC1 -- Fast Recovery (Prim) (CKPT REQ) -- Up 00:37:00 -- 782096 Kbytes Blocked:CKPT ============ Or how to reach Informix 24x7 support …
verifying a (ontape) backup
Is there any way to verify the contents of a backup tape (used ontape for the backup) other then doing a restore? Chuck Wrobel Bellevue School District…
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.…
The only way to restore a single database is to do a cold
The only way to restore a single database is to do a cold restore of your archive on another system and then extract the database to restore with dbexport. Then with dbimport put it in your production system. Good luck Casper van Schie RAET Personele Systemen BV >>> Abhay Mannu…
Restore problem
Hi! We have a problem with our Informix Online Workgroup Server 7.22 (installed on NT Server 4.0). We have dropped a table, and now want to use restore to get it back. But it doesn�t seem to work correctly. We don�t get the table back using the "space-restore" (not the whole sy…
Ontape recovery ?
Hopefully, I can present this in a cohereny manner. This is the situation. We backup our 7.14 database using ontape. We have a problem where some data got blown away several weeks ago, and it was just now discovered. I have an ontape Level 0 from three weeks ago. Obviously, …
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…
Replication setup problem
Hi, secondary server hangs in Recovery Mode! We have ODS 7.22 UC2 on both machines, and SCO 5.0 All Things are identical and we start with 1. an archive Levele 0 on machine A (the primary server). 2. on machine A: Log.Log Backup 3. on machine A: onmode -d primary machine_b 4. …
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Re: Bring Online down in middle of t
>--------------------------( Forwarded letter 1 follows )--------------------- >Date: Monday, 3 November 1997 10:06pm >From: "* N O - S P A M 26894 cosmo"@echonyc.com >Subject: Bring Online down in middle of transaction rollback? >Date: Mon, 3 Nov 1997 23:55:51 -0600 >Reply-To: C…
Re: Bring Online down in middle of transaction rollback?
>What is the effect of bringing Online down in the middle of a >transaction being rolled back? Is it meant to recover gracefully from >this kind of thing? If so, in reality, does it actually do so (recover >gracefully, that is)? > >I've got a client who pulled a bone-headed mo…
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…
onbar restore trouble
I've very anonying problem with restoring Informix database. Following is the Informix log, bar_act.log and daemon.log (/nsr/logs Legato Networker). What I did is to have a daily full backup: one on 7/18 and two on 7/19. I was having no problem at 7/19 to restore the 7/19 or 7/1…
Remote restore
Hi, I need to do a restore using the ontape utility. The tape drive is attached to an NT 3.51 server and I am running Informix ODS on my NT 4.0 workstation. I don't suppose that the tape drive is a shareable device (over the network). How can I do it? Any help appreciated. …
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…
Restore problem
Hello, I am working on online 7.14 UD1. I would like to restore a dbspace but the command ontape -r -D ipptst_01 gives me the following error : Memory Fault There is no trace in the online.log file. I have checked the Unix kernel parameters that are OK. I have tried to check …
Re: Fast Recovery Forever !!
"SH Lim" <sweehock@hotmail.com> wrote in article <5oo5ek$kdo@cssun.mathcs.emory.edu>... > Guys and Gals, > Could you help me out here. I need some good solid explanation that > can convice management (non-techies) with high expectations about > Informix. > The Online Ser…
Re: Fast Recovery Forever !!
SH Lim wrote: > > Guys and Gals, > Could you help me out here. I need some good solid explanation that > can convice management (non-techies) with high expectations about > Informix. > The Online Server 7.13 configured with care and which has been > runnning for weeks su…
Fast Recovery Forever !!
Guys and Gals, Could you help me out here. I need some good solid explanation that can convice management (non-techies) with high expectations about Informix. The Online Server 7.13 configured with care and which has been runnning for weeks suddenly went into Fast-Recove…
Re: logical log cannot be freed
In article <5nou4i$74s@cssun.mathcs.emory.edu>, Peter Wang <peter_wang@yes.optus.com.au> writes >The logical log status flag "UB" really means the log is backed up and = >free to reuse. From version 7.x, OnLine would not flag a log that is = >backed up to "Free" immediately, thus…
Permenant Recovery
I am runing Informix Online 7.13 and today the system came to a stand still as the logical logs passed the declared High Water Mark and the logs completely filled. I made the mistake of shutting the system down, but what I believe I should have done was back up the logs to relie…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
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: How fast is fast recovery on V5
John just be glad it recovers at all I had a V5.2 port (Control Data EP/IX) that didn't recover at alle from the logical logs. It just came up with an illegal pointer (cannot find transaction ....) from the logical log I am on 7.12 now and are going to perform logical log recov…
How fast is fast recovery on V5
Hi We have been waiting 7 hours for a recovery to complete from what looks like 3.75 log files on Informix V5.3 with 2k page size. There had been some substantial deletes etc. just before it went down. Is this to be expected - shall we cut our losses and go back to a recent le…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Thanks for your suggestion. However, we had already back up logs to /dev/null. Now, what causes the logical logs full? Yours, Xiaohui Shen Timothy M. Hood wrote: > > If you are really desperate to get the engine going, you can always back > up logs to /dev/null. This prevents y…
Recovery Strategies
My site has a business requirement: "In the event of server failure, the database must be recovered within two hours to its state at the point of failure", and an assumption "Our disk hardware is so reliable that it is guaranteed to be 100% available" Suspending disbelief of the…
Re: SAme Aps on 2 Servers, different performance, help!
In article <5chhg1$kje@netnews.csie.nctu.edu.tw>, ccliu <ccliu@maria2.cs ie.nctu.edu.tw> writes > > >Hi Net, > I have a very confusing situation regarding to performance for >two similar Database. > >Server 1: >HP-UX A.09.04 U 9000/887 >INFORMIX-OnLine Version 7.12.UC1X8 >7…
Re: SAme Aps on 2 Servers, different performance, help!
Hi, Looking at the memory of the 2 machines I'm not surprised at the better performance on Server 1. You also have several other configuration differences between the two machines. The NUMAIOVPS is 8 on server 1 and 3 on Server 2. Is this because you have more disks allocated t…
SAme Aps on 2 Servers, different performance, help!
Hi Net, I have a very confusing situation regarding to performance for two similar Database. Server 1: HP-UX A.09.04 U 9000/887 INFORMIX-OnLine Version 7.12.UC1X8 768 MB memory Server 2: HP-UX B.10.01 U 9000/829 INFORMIX-OnLine Version 7.13.UC1 384 MB memory Both have …
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
Re: Logical Logs problem
Don't use tbmonitor to backup logical logs. Instead, login into informix and run tbtape -a. In article <5bksl9$8np@cssun.mathcs.emory.edu>, odsharma@hclc.hclc-ggn.hcla.com says... > >Hi all, > >We are developing a project using Informix 5.0 Online and Visual Basic >4.0. >We are…
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Re: Online 7.13 UC1 on HP-UX 10.10 -Reply
When you start up the catlgr, make certain it is the same userid (root or informix). You will get some strange errors if the userid is root and you try to perform some onarchive functions as informix (or as a userid of the supergroup). I am currently compiling my notes for onar…
Re: Script to shutdown ON-Line without user interventions
We also add an onmode -l and an onmode -c to go to the next logical log and perform a checkpoint BEFORE shutting down the machine. That way, we can backup the logical log before bringing down the engine and have a copy for recovery purposes. Hope this helps. Barbara Garrett…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
Log files to disk
Has anyone tried backing up transaction log files to disk, and being able to retrieve them later for recovery. Would appreciate any experiences, good or bad. Kerry Thompson…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
Restoring archive
I am trying to restore an Online 5 level 0 archive to a another machine as part of a test exercise. I am pretty sure that I have set up the chunks correctly and the whole /usr/informix is from the same time the archive was run so I have got the correct tbconfig. When ever I run…
Checkpoint never return! HELP!
Hi, I got a fatal error that cause my DB crash. the following is from online.log, which shows the "Checkpoint never return!!" please see: ******************************************** 10:31:02 Logical Log 93549 - Backup Started 10:52:41 INFORMIX-OnLine Stop…
Warm restores using ONARCHIVE
Hi, Beyond physical database corruption, is their any benefit of doing "warm" restores of selected dbspaces? In other words, does one do "warm" restores only for physical corruption? -- Dave Lahoti = DaveL@POBoxes.com…
Re: Informix Online Table Recovery: How? -Reply
This little maneuver is called "point-in-time" recovery -- a MAJOR function that should be a part of ANY relational database that allows multiple users. Unfortunately, Informix does not have a "true" point-in-time recovery. You may apply the last backup and all logs except the …
Re: Informix Online Table Recovery: How? -Reply
If Point-in-Time recovery is so important to you guys, upgrade to 7.20 now ! Informix has always taken a more conservative approach. With this new freedom comes also greater responsibility for the DBA. Check it out. Hoon-Hong Singapore…
Recovery using LOG file
Hi, Is there any other tools, Informix or other vendors, besides dblog to read log file and recover data? I need to automate some recovery process and any info is appreciated. Thanks, Siamak…
Re: logical log questions -Reply
Paulo Nunes wrote: > Copy the logs to /dev/null may cause problems in recovery work. When Informix > have critical problems one of the ways of recovery (before a perform a > tape restore) is to use a checkpoint record in the logical logs. Logs containing needed checkpoint info…
Table Restore
I am using ontape to backup my databases. I have for the larger databases one database per dbspace. Is there a way using ontape to retrieve a single table, without doing a backup current, restore good, unload table, and restore current? Currently this takes me approx. 15 hours…
Question on Archive restore
Informix allows restores at dbspace level. My question is how it are integrity constraints dealt with on a dbspace level restore ... for example, if an account table ( with foreign key to customer table) in its own dbspace is restored but certain rows in customer table have be…
Re: mt_shm_remove: WARNING: "After running oninit"
In article <31CF7F9D.67BB@avid.com>, Chris <chris_swecker@avid.com> writes > >I forced a check point with onmode -c, but no luck the server remained >in the Fast Recover state. >(I tried forcing a check point numerous times) > > >I brought the server down again; onmode -ky >and p…
mt_shm_remove: WARNING: "After running oninit"
We're running Online 7.13.UC1 on HPUX. After backing up the log files to clear them, I realized that the log files had not been freed due to a long transaction. According to the documentation, a full restore would correct the problem. The restore did free all the log files, bu…
Onarchive Warm Restore
Anyone out there using Onarchive for backing up dbspaces concurrently? Anyone out there ever used Onarchive for warm or mixed restore?…
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: TCP SOCKETS ON ONLINE 7.10.UC2 ON SILICON GRAPHICS IRIX 5.3
Serafina Raneri wrote: > > Has anybody ever tried to configure tcp/ip sockets on a Silicon Graphics > with Irix 5.3 and On-line 7.10.UC2. > I tried with this results!!!! > > Tue Apr 16 11:43:24 1996 > > 11:43:24 DR: DRAUTO is 0 (Off) > 11:43:25 Assert Failed: Internal Error - S…
Re: TCP SOCKETS ON ONLINE 7.10.UC2 ON SILICON GRAPHICS IRIX 5.3
Serafina Raneri wrote: > > Has anybody ever tried to configure tcp/ip sockets on a Silicon Graphics > with Irix 5.3 and On-line 7.10.UC2. > I tried with this results!!!! > > Tue Apr 16 11:43:24 1996 > > 11:43:24 DR: DRAUTO is 0 (Off) > 11:43:25 Assert Failed: Internal Error - S…
RE: TCP SOCKETS ON ONLINE 7.10.UC2 ON SILICON GRAPHICS IRIX 5.3
In <3173EA9F.758C@erbamatta.arch.unige.it> Serafina Raneri <sraneri@erbamatta.arch.unige.it> writes: > >Has anybody ever tried to configure tcp/ip sockets on a Silicon Graphics >with Irix 5.3 and On-line 7.10.UC2. >I tried with this results!!!! > >Tue Apr 16 11:43:24 1996 > >11:4…
Re: Database Replication - Does it work?
ken, > I've tried to point LTAPEDEV to a real file and periodically backup logical > logs 'ontape -a' on the secondary server when it has changed to standard, but > when I try to restore the primary it hangs in fast recovery and the > secondary panics - again requiring careful m…
TCP SOCKETS ON ONLINE 7.10.UC2 ON SILICON GRAPHICS IRIX 5.3
Has anybody ever tried to configure tcp/ip sockets on a Silicon Graphics with Irix 5.3 and On-line 7.10.UC2. I tried with this results!!!! Tue Apr 16 11:43:24 1996 11:43:24 DR: DRAUTO is 0 (Off) 11:43:25 Assert Failed: Internal Error - Segmentation Violation 11:43:25 Who: T…
backup/recovery
I am newly hired DBA and have looked at the informix manuals. That does not give me enough information. For only a directory like /mnt4/casemng/ I need to back up THAT directory - not whole database. Is it correct that I just type "tptape -s /mnt4/casemng/" ?? OK now I just wan…
PANIC: Attempting to bring system down
I write from Spain and I have next error working with Informix Online 7.11UC1. In online.log say: DR: DRAUTO is 0 (off) informix-online Initialized -- Shared memory initialized. Physical Recovery Started. Physical Recovery Complete: 1120 Pages Restored Logical Recovery Started. …
PANIC: Attempting to bring system down
I write from Spain and I have next error working with Informix Online 7.11UC1. In online.log say: DR: DRAUTO is 0 (off) informix-online Initialized -- Shared memory initialized. Physical Recovery Started. Physical Recovery Complete: 1120 Pages Restored Logical Recovery Started. …
PANIC: Attempting to bring system down
I write from Spain and I have next error working with Informix Online 7.11UC1. In online.log say: DR: DRAUTO is 0 (off) informix-online Initialized -- Shared memory initialized. Physical Recovery Started. Physical Recovery Complete: 1120 Pages Restored Logical Recovery Started. …
Re: online crash
rswa@perth.DIALix.oz.au (Radio Spares) wrote: >Dear All, >I have come across this problem with online 7.10.UC1 on a Spacr 5 running >Solaris 2.4. I have a cursor that does a count on 1 table with a where cause >of 1 = 1. The count works but when the cursor is closed it brings t…
Re: online crash
That's interesting - I saw that same error about two hours ago during an Informix DSA 7.1 Performance Tuning course here in Sydney (using 7.1.UD3 on an HP Kittyhawk) We thought it occured as a result of using tbmode -F (to free unused memory segments) just after an "update stat…
Re: online crash
In article <41gkhs$b69$1@perth.DIALix.oz.au>, Radio Spares <rswa@perth.DIALix.oz.au> wrote: >Dear All, > >I have come across this problem with online 7.10.UC1 on a Spacr 5 running >Solaris 2.4. I have a cursor that does a count on 1 table with a where cause >of 1 = 1. The count w…
online crash
Dear All, I have come across this problem with online 7.10.UC1 on a Spacr 5 running Solaris 2.4. I have a cursor that does a count on 1 table with a where cause of 1 = 1. The count works but when the cursor is closed it brings the engine down (see online log below). This progra…
Restore life database backup to testing database
Dear Sir, Our informix Online Engine is version 5.0 and using raw disk device. We try to restore our life database backup to testing database so as to fix a program bug. When restore start, the online engine restore the backup to life database again since the system restore acc…
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?…
Problems in Informix6.0 Installation.
Hi, We seem to have a problem with our Informix 6.0 ( Dynamic Server ) installation. I present two cases: Case : 1> $INFORMIXDIR/etc/sqlhosts file has an entry dynamic onipcshm chanakya online_1 ---- Informix when brought up by "oninit" comes up but when onmonitor is envoked it…
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
Re: onarchive question
Here are some ideas how it can be done. 1. Do an archive of the current database. 2. Restore the whole database from the tape. 3. Unload the table you need to restore to a file. 4. Restore the current database from the archive. 5. Drop and recreate the table needed with the …
Re: problem: long transaction aborted, logs full
On 23 Oct 1994, John Blomberg wrote: } Messages from log file: } } 15:22:41 INFORMIX-OnLine Initialized -- Shared Memory Initialized } 15:22:41 Physical Recovery Started } 15:22:42 Checkpoint Completed } 15:22:42 Physical Recovery Complete: 16 Pages Restored } 15:22:42 Abor…
Table Restore
I have a question on recovery of a table in informix. We are using OnLine 4.10. The question is if one of your tables in your database was corrupted or dropped while transactions are being made against the database, how can the table be recovered from an archive lets say a level…
Re: mirrored chunks
When the offline chunks are corrected (ie, hardware fixed), and you initiate a recovery for a 'down' mirrored chunk, a daemon process begins copying the contents of the primary chunk (the one that is still ON-LINE), to the chunk being recovered. ONLINE brings the chunk on-line i…
Re: Why this Long Transaction
Stuart Litel writes: |> I strongly suggest if a "revovery" takes more than short period of time you |> could be encountering this famous bug. This depends a lot on your configuration. Fast recovery must rerun all the transactions that took place since the time of the last check…
Checkpoint Recovery
Does Infomix provide me with the ability to specify a particular transaction or checkpoint to be used in rollback or recovery processing. My questions stem s from a user scenario, where the user has requested a series of database processes accidentally. I would like to be able …
Re: Un-attended Large Archives (fwd)
Graeme Sargent writes: |> Dave Kosenko wrote: |> >You imply that, by design, the system is intentionally locked during media |> >changes and this is incorrect. In fact, this problem can generally be |> |> I think you're being a bit pedantic here, Dave. The lockup effect may |> …
?: Table Restore/Backup :?
Hi, Is it possible to perform table backups/restores with Informix? For example: if I'm running Informix OnLine and multiple databases over multiple disks, would I have to restore the entire database to recover from one (1) disk going bad? Ideally I could simple restore the pa…
Re: Recovery
In article <1inm5vINN3gm@emory.mathcs.emory.edu> unifi!goofy.unifi.com!bharat@uunet.UU.NET (Bharat Shah) writes: >Welcome to the world of STUCK FAST RECOVERY ... >I have faced this problem on more than one occassion and I have been asked to >wait for version 5.0 where HIGHT_WATER…
Re: Recovery
Welcome to the world of STUCK FAST RECOVERY ... This is a known "bug" of Informix where if logical logs are about to be fully consumed, the rollback begins. If just then the client is killed, OnLine is rendered into an inconsistant state. The recovery.... will never stop. Infor…
Recovery
I'm running Informix-Online 5.00.UC3 with Informix 4-4GL 4.10.UE2 on a HP 9000 s750 computer. A process with some 4000 locks had hung trying to update the database. I killed the process (which was a very bad move). Going into tbmonitor, I tried to set the DB online again. …
Re: HELP! Online Logical Logs are full.
Quoting Niels Berner... > > I have a serious problem, with Informix Online, and I hope that someone > on the mailing-list is able to help me. > > The problem is that my logical logs are full. When I try to enter quiescent > mode, the Online-engine is trying to do a fast-recovery,…
Re: C-ISAM Corrupted Indexes (fwd)
Previously, I wrote: > > Generally, it's important to note that Informix-SE provides only a logical > log, whereas Online provides both logical and physical logs. As you point > out, the only sure way to recover from a crash with SE is to RECOVER > and ROLL FORWARD whereas Onlin…