Oninit® Archive
Results for “ON_RECVRY_THREADS”
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 ------------…
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…
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…
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…
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 …
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 --------------------…
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…
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…
Informix 7.30 failed to start
Mohammad, 1. If there is a level 0 archive image around you can simply restore using that image with NO logical log recovery as there is most likely logical log corruption. 2. If not then tech support has the ability to null out fast recovery providing you have a valid support …
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…
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 …
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 avoid blocking checkpoints?
Gustavo: Are the chunks RAW or COOKED? If cooked then you should have at least 1.5 AIO VPs per active (non-temp) chunk and you only have one. You have seven CLEANER threads, now many non-temp chunks do you have? You should have at least one CLEANER per actively modified chunk (t…
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…
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…
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)…
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/…
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?…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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…
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?…
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.…
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 …
Fast Recovery (CKPT REQ) state
Hi all, Our database is in Fast Recovery mode, waiting for a checkpoint. The Logical Logs got full, and apparently LL number 317, the next to be freed, is corrupt. We are not able to back it up (with on "tape -a"), nor delete it (in this state), nor skip it. We cannot add new l…
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…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
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: …
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 …
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…
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.…
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…
ontape -p/r with changed ROOTPATH
hey again thanks guys - with all this info I've managed to make this restore w/rename working like now…
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…
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 …
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…
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…
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…
HDR Problem
If i am not mistaken,Once you restore the DB from primary to secondary,logical log number should be same. rgds schillache…
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…
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…
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…
Informix 7.31 (Alpha Unix TRUE64) hangs in "Alloca
Was the IDS software validated against TRU64 UNIX or DEC OSF UNIX? They were different under the hood and I seem to remember that IDS supported OSF not TRUE64! Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that …
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 …
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…
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…
Poor Performanc with Multiple DB's in one Instance
2009/1/30 ANEES AHMAD <aanees@i2cinc.com>: > Hello, > > Please see my comments below. > > What OS and what versoin of IDS are you using? > [Anees Ahmad] We are using SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v sparc > SUNW,Sun-Fire-T200 and the IDS version is 10.0. It's a 6 core…
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…
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…
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…
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…
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…
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…
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.…
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 --…
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: 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?…
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…
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 …
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…
Re: suggestion reqd Perf tuning
is there any more suggestions? Please post your view. regards madhu darko wrote: > madh wrote: > > this my onconfig file. I am using Informix Dynamic Server Version > > 7.31.UD6W4, HP-UX 11.11 , > > no of cpus- 2, REPORT SERVER (used for creating report purposes). > > Memory 1…
Re: suggestion reqd Perf tuning
madh wrote: > this my onconfig file. I am using Informix Dynamic Server Version > 7.31.UD6W4, HP-UX 11.11 , > no of cpus- 2, REPORT SERVER (used for creating report purposes). > Memory 1387036K(1260472k) real, 1847708K (1682688k), virtual 4262876k > free pages, > Just want see so…
Re: Can I bypass fast recovery?
Just out of curiosity, could you post the af file?…
Can I bypass fast recovery?
I have an instance stuck in fast recovery. Here are the last few lines from the online log: 15:27:27 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 15:27:27 Physical Recovery Started at Page (2:32908). 15:27:27 Assert Failed: Physical log recovery erro…
Performance tuning suggestions needed
You want performance tuning suggestions, is there a particular problem you are trying to solve or do you just want it to "go faster"? if so, is there any more bandwidth available on the machine? Also, I note you want it to go fast but you don't appear to care if it all goes wr…
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…
Informix
I have ids7.3 runninig on hpux.I have the following error when i run oninit: Fatal error in shared memory creation'.I got this error message after sucessfully restoring the database with last year's tape.I tried to reboot the server so that i can free the shared memory but ,this …
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 …
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…
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: …
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…
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 …
Performance issue after 732 to 94fc6 upgrade
Doug See embedded comments below Keith -> -----Original Message----- -> From: Doug Fossmeyer [mailto:DougF@SpokaneSchools.org] -> Sent: Tuesday, June 13, 2006 1:04 AM -> To: ids@iiug.org -> Subject: Re: Performance issue after 732 to 94fc6 upgra.... [6934] -> -> -> -> Part 2 o…
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.…
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: 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…
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…
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.…
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
sounds bad; and restore time... what is in the online log file and the af.xxxx files Superboer.…
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…
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
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.…
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: 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…
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. Estoy de…
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
I find onstat -a output to be better to work from, otherwise you're guessing. I will also say that of the tuning knobs, $ONCONFIG represents many of the finer control knobs. Disk layout and fragmentation can be much more important. oncheck -pe output can be very revealing here. …
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 …
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…
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…
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…
Re: -25572 Network driver cannot bind a name to the port.
The problem is solved...thanks a lot for all ur support Added and modified following entries in ONCONFIG file, SQLHOSTS and services file ONCONFIG DBSERVERNAME kam940shm # Name of default database server DBSERVERALIASES kam940q1 # List of alternate dbservernames NETTYPE ipcshm,…
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…
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…
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…
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: 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…
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 - …
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…
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…
HPL loader question
When HPL loads into a table with indexes it can disable/re-enable the indexes. When the indexes are re-enabled how does HPL determine how many threads to use? Does the onconfig parameter ON_RECVRY_THREADS affect this? What about when oncheck rebuilds indexes single threadedly. …
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 ?…
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…
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.…
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: 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-…
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@…
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…
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 …
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…
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…
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 __________________________________…
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…
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.…
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 …
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…
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 …
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.…
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 …
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…
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…
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 …
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…
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…
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 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…
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 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…
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…
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…
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…
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.…
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
Looks like you did a restore using ontape -r and said 'NO' to restore logfiles. When the restore completed the engine was in Quiescent mode and then you shut it down. If you do not restore logs you MUST bring the engine to full ONLINE mode with 'onmode -m' before you can shut i…
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: Question about IDS scalabiltiy
You should have NETTYPE parameter (2) for DBSERVERNAME and DBSERVERALIASES. Suggest you turn Read Aheads OFF (0) until you have the system running. Are all parameters the same as recommended in your release notes? Murray Wood -----Original Message----- From: Obnoxio The Clown…
Re: Question about IDS scalabiltiy
I'm kidding about the scolding...... Carlos Bolden <cbolden@harrahs.com> wrote in message news:374c458d@hwilkins.harrahs.com... > After getting scolded by Art, I must post these files also > > > > Carlos Bolden <cbolden@harrahs.com> wrote in message > news:7ih01q$r6a$1@news.xmis…
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…
RE: Question about IDS scalabiltiy
I don't remember, are you doing OLTP or DSS? From: Carlos Bolden <cbolden@harrahs.com> > ># Root Dbspace Configuration See embedded comments. >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /dev/prodi/prod-100 # Path for device containing root >dbspace >R…
Re: Out of buffer?
Xavier wrote: > > On Wed, 26 May 1999, Mark D. Stock wrote: > > > Xavier wrote: > > > > > > On Wed, 26 May 1999, Mark D. Stock wrote: > > > > > > > Xavier wrote: > > > > > > > > > > Hi, > > > > > > > > > > I got the following error message from an Informix IDS 7.30: > > > > > > >…
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 …
Informix slower than MS Access ?
How much memory did your NT have? 62M ? You're limiting the Informix Engine to 20,000 buffers. That means that you are limiting the total memory space for tables to 40 Meg. With a 512 MB system, you probably would want to set this to 150,000. Access works by "loading" the en…
Ontape Restores
Does anyone have a Unix script to automate the Ontape -r (archive restore) function? Thanks for any assistance.…
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…
48 oninit processes, when informix started
You have NUMAIO vp's blank. By doing this it uses the default. Which I believe is 2 per chunk, without checking the admin guides.... Darin xuejinw@shubertorg.com wrote: > Hello: > > We are running Informix Dynamic Server Version 7.30.FC4. recently we > noticed that wh…
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…
Re: INFORMIX and utilization of system resources on HP-UX 10.20
Ho Andrzej, on HP-UX systems, be sure also to have PHKL_16751 (in fact it is PHKL_13261 included on it) It is really important for performance improvment when using raw devices through LVM. David... Andrzej Piotrowski a =E9crit : > This is a multi-part message in MIME for…
RE: INFORMIX and utilization of system resources on HP-UX 10.20
You are probabli very low on buffers > -----Original Message----- > From: Andrzej Piotrowski [SMTP:a.piotrowski@apexim.com.pl] > Sent: Thursday, April 08, 1999 12:28 PM > To: informix-list@iiug.org > Subject: INFORMIX and utilization of system resources on HP-UX 10.20 > > This i…
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 …
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…
Re: Still Slow LOAD & SQL
1. And what is the query plan in sqexplain.out for OPTCOMPIND=0 ? 2. What is the read %cached in onstat -p? 3. Can you try to increase the RA_PAGES ? Best Regards, Octav On Tue, Mar 09, 1999 at 04:13:00PM -0200, Sebastian Paul Avarvarei wrote: > Still me, with the same problem.…
Cached reads percentage too low
Your read cache rate seems to exceed the 95% specified, so i don't know why you're getting the message. My experience is that IDS benefits from KAIO on HP-UX. However, due to general crapness of the product you can't safely run with KAIO enabled. I seem to remember that you sh…
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?…
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 ??
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…
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…
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…
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:…
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,…
RE: Reducing checkpoint intervals...
Pat, I would reduce the number for LRU_MAXDIRTY/LRU_MINDIRTY before looking at the number of buffers. I personally don't believe that you can have a cache hit rate that is too high. If you do reduce the number of buffers do it in stages and stop if you drop your read rate below …
Reducing checkpoint intervals...
I run a very busy OLTP system. Currently, checkpoints are taking between 10 and 20 seconds, and are happening every 5 minutes (as the result of the checkpoint interval being hit.). For obvious reasons, I would like to reduce this. Currently, I see a couple of things to try: * …
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: 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…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
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: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
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…
Re: SIEMENS experiences with 7.X Dynamic or Work Group
In article <6eior8$5bo$1@news.xmission.com>, Hamzova Katarina <Katarina.Hamzova@swh.sk> writes > > > >> -----Original Message----- >> From: Alexander Selg [SMTP:alexander.selg@siemens.at] >> Sent: Wednesday, March 11, 1998 10:50 AM >> To: informix-list@iiug.org >> …
RE: SIEMENS experiences with 7.X Dynamic or Work Group
> -----Original Message----- > From: Alexander Selg [SMTP:alexander.selg@siemens.at] > Sent: Wednesday, March 11, 1998 10:50 AM > To: informix-list@iiug.org > Subject: Re: SIEMENS experiences with 7.X Dynamic or Work Group > > MARTIN wrote: > > > > Please tell me what kind of con…
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.…
Re: listener-thread err
In article <6d4go9$3rs$1@news.xmission.com>, Scott Black <sblack@elsouth.com> writes > >HP-UX 10.20, OnLine 7.22.UC1X2 > >Throughout the day the engine will temporarily hang up, there will be >zero ISAM calls. No one can do anything with Informix. This condition >will last anyw…
Re: lock table overflow
The application is apparently running quite a long transaction and the database is probably using row level locking. The locks on the rows are not released until the transaction is completed. Note that many locks can be held for each row if there are indexes. You could try to in…
Re: lock table overflow
Hello, You should increase the number of LOCKS. You have already using 200000, this is a very big number. Should you look at your code and change in order to use less locks. hope that helps Serafim Fonseca > > hi > > i'm running ods7.23uc1 on hp-ux10.20. this application is a…
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…
Re: informix mirroring
In article <6aq168$eh6@bgtnsc01.worldnet.att.net>, Philip J. Mutino <pjmbhc@postoffice.worldnet.att.net> writes >------ ONSTAT -A ------- > >INFORMIX-OnLine Version 7.20.UC3 -- On-Line -- Up 8 days 21:44:07 -- 70536 >Kbytes > >Message Log File: /usr/informix/online.log >06:50:…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: 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…
Re: Online 7.12 Tunning
In article <19970917025700.WAA00456@ladder02.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >I'm including some remarks at the end as well as embedding some things >within the copy. > >M.Pruet > >> >>Hello, >> >>I've just upgraded from Online 5 to Online 7.12, on a RISC6000 wi…
Re: Online 7.12 Tunning
I'm including some remarks at the end as well as embedding some things within the copy. M.Pruet > >Hello, > >I've just upgraded from Online 5 to Online 7.12, on a RISC6000 with >128MB RAM, and I'm having some performance problems. Is there a reason that you chose to go to 7.12…
Re: Online 7.12 Tunning
How many CPU's does the system have? Is is a dedicated server; or does the app run on the same machine? From your NETTYPE settings I'd guess decicated server. If you need no network access them remove the onsoctcp NETTYPE setting. You proably want to set OPTCOMPIND=0. This can b…
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…
Re: Informix v7.12 and DEC ALPHA 2100
In article <5lg45a$fm2@cssun.mathcs.emory.edu>, Ken McCoy <kenm@apscn.k12.ar.us> writes > >I've just done an upgrade on a DEC ALPHA 2100 with 2 CPUS and a GIG >of memory from Informix 5.05 to 7.12 and performance is terrible!!!! > > >I would appreciate ANY advice anyone can provi…
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…
Re: MS SQL vs Informix Online Workgroup (7.12) on NT observations
In article <3311D294.75F8@thetsn.com>, Gregory Trubetskoy <grisha@thetsn.com> writes >We are trying to compare performance of SQL server vs Informix for our >application, which mostly do querying rather than updating. > >Both SQL Server and Informix are on the same machine, dual …
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: 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…
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: 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: 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…
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?…
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: 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…
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
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…
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…