Oninit® Archive
Results for “PSM_LOG_POOL”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Encryption/compression of backups
Is onbar the only informix tool that will do compression and/or encryption of the data being backed up? Can onbar do that with the basic ISM, or do you have to purchase a storage manager from another vendor (Legato, Tivoli, etc.)? What type of encryption does the base ISM use?…
Re: Standard Engine and OnLine - Which one and When?
>Subject: Standard Engine and OnLine - Which one and When? >X-Informix-List-Id: <newsgate.623> >From: cs_e266@kingston.ac.uk (Edwin Yau) >Message-ID: <1992Jan14.134405.8825@kingston.ac.uk> >Date: 14 Jan 92 13:44:05 GMT >Sender: phyd@cix.compulink.co.uk > > Standard Eng…
Question on file systems for cooked files
Again, responding inline: A couple of follow-up questions based on your response: We're in agreement on the separate file for each chunk (as you acknowledged in your response), and I was expecting to use the EXTENDABLE option as well. My Linux sys adm (and most sys adms I've wor…
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…
Extending chunk capacity
John: The self-adjustment is that when I set up a server that way, I will also configure storage pool entries for all of the file systems designated for Informix chunk use so that if the FS supporting a chunk does fill up, the dbspace is expanded with a new chunk from one of the …
onbar is rejecting my date for point-in-time restore
Two things: Why are you doing the onbar deamon? What is the od dump of you date string? ------------------------------ wayne martin ------------------------------…
Onbar: Failed to determine archive's encryption mode. Error code 2
Hello Jacob, I would allways make backup/restore with -w (whole system backup flag). You can verify this in the ixbar file if the 4th field is set to 1 and 2nd field contains the dbspace name. It is also impossible to mix backup/restore with/without whle system backup flag... May…
How to verify all the requirements for an onbar restore
Hi Family. I've been mostly quiet on this group because my gigs of late have been Perl with little to no Informix. That has now changed. (YAY!) I have little to no experience with onbar. I performed some backups by rote and used archecker to get back a table my client had inadve…
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 ------------------------------…
Why is `onbar -v` so slow?
Hi, While `onbar -b` takes 22 hours, `onbar -r` completes for 30 hours, `onbar -v` runs 7+ days. What is wrong with it? ------------------------------ Sincerely, Dennis ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
Dennis: Tuning Informix on Power is a complex subject, but, in general, secondaries work best if the secondary is identical to the primary. Otherwise, assuming those resources are needed on the primary for normal operations, how will you survive if the secondary has to become the…
Informix vNext slides from IIUG/Scott/Karen/Shripad
Hi, Interesting IIUG talk from Scott/Karen/Shripad abhout vNext New Features https://www.iiug.org/wp-content/uploads/2023/04/Informix-VNext-New-Features.pdf "Performance better or equal than prior release: 14.10.xC1 Investigating new compiler impacts, better scaling on Linux, imp…
Logical Logs - Flags and backups
Hi, total newbie here but needing some guidance re: logical logs and what the onstat flags mean, so would appreciate anything to help improve our understanding. Been reading up on what we can, but informix DBA knowledge is a bit thin in this neck of the woods, hence the forum que…
start onbar and ontape simultaneously
You should NOT mix onbar and ontape. If you are using onbar for backup DO NOT USE ontape (except "fake" backups) otherwise you will LOOSE your backup data. Onbar is using ixbar file and sysutils database so onbar counts it can get all objects back - if you backup just one logical…
restoring informix using the onbar command. problem
Which ixbar file ($INFORMIXDIR/etc/ixbar.<server_num>) are you operating on? Was this possibly also affected and had to be restored? Does it contain the backup you're hoping to restore? ------------------------------ Andreas Legner ------------------------------…
How many aio/KAIO
Interesting discussion. I don't agree with a lot of things said here, mostly about hyperthreading and "overloading" cores with Informix CPUVPs, but, whatever works for some (test) environments has a right to be presented, I guess. Some AIX / POWER comments. On POWER you are very …
Index creation strategy when autolocate is set
Hi, AUTOLOCATE is a bit unusual in that even when set to 1 it still creates a round-robin table, just with a single fragment. You can see this because the table itself has no part number and there will be an entry in sysfragments of fragtype 'T', which a non-partitioned tables do…
A bit more clarity on LEVEL 1 backups
Quite generally, as the backup side falls into two parts, the 'physical' spaces backup (a snapshot of the used parts of your chunks - as simple as that) and the 'logical logs' backups, also the restore would first perform so called physical restore which is copying back that snap…
How to find which dbspaces are set to auto extend?
Ramon: No, there is nothing in sysadmin about extending chunks of expanding dbspaces using the storage pool either. It is all stored in sysdbspaces and syschunks. Witness: dbaccess sysmaster - > select * from sysdbspaces where dbsnum = 4; dbsnum 4 name datadbs_1 o…
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 secondary MUST be OFFLINE when you do the restore (a COLD restore). The restore of the secondary must use the backup that was taken from the Primary, so the backup MUST be copied over to the secondary BEFORE you begin the restore. Basically it should be similar to the followi…
Validate backup : archecker –tdsv and CommVault
Mike is correct. onbar -v is just a shortcut to run archecker to validate an onbar archive. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
curious about extendable chunks
Mark: Your understanding is correct. You can only do extendable chunks if you are using COOKED file chunks not RAW or COOKED devices. If you are using RAW devices you can put the devices with any existing offsets and the device size into a storage pool entry. If new chunks are ne…
Table Extent Size calculation
True, Eric. If you want to depend on the storage pool to allocate new space to a dbspace to accommodate new extents, then make sure to set the extend size for the specific dbspace large enough that the whole extent will fit in it. Otherwise the storage pool will add multiple smal…
Block during checkpoint
ABeMie: You sent me a private response that I think require a reply from me, but for some reason the site won't let me get to it to answer. So, here is a reply that can be public: I understand your issues with taking down time. However, there is no other way to implement the chan…
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…
Problem with backup
Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thanks…
Auditing?
Original post: IDS 12.10.FC12 Solaris 10 1/13 In the past, we have not been very concerned about auditing. But, things are changing, and it seems that some managers now want to "take it to the limit", auditing-wise. Having poked at onaudit briefly, several months ago, I have l…
Number of logical logs growing ?
This is what I've found in logs at the time of crontab ontape -a jobs ( no one was connected to the db, neither no jobs were usign it ): 17:20:01 Logical Log 47416 - Backup Started 17:20:01 Logical Log 47416 - Backup Completed 17:20:01 Logical Log 47417 - Backup Started 17:20:01…
raw device usage tracking
Hello, To avoid dealing with offsets, I create separate lvols for every dbspace and one of my instances is reaching > 1500 chunks/lvols (22TB). Thinking it would simplify disk usage management, I built a couple of large lvols of 1.2TB ea. and allocated them to the storage pool.…
ontape restore problem
A customer want to restore the data from the tape, the date of backup file is about 2002. and No one remember the informix version, How to know the informix version from the backup file? thanks for your help.…
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…
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…
Free Webcast - Informix and PSM - 4/12/18 @ 2 PM E
Join us for the free webcast "Getting going with PSM and Informix 12 for backups", presented by Thomas Beebe on Thursday, 4/12/18 at 2 PM EDT. This webcast will show how to set up and use the Informix Primary Storage Manager (PSM) - the storage manager included with Informix 12.…
Which is best On-Bar and On-Tape
Hi, I'd like to agree with David than onbar is very easy to configure at the Informix end, however it does need extra configuration at the storage manager end if you are using an enterprise solution. One thing I'd add is that the archecker utility can be used to verify backups.…
restoring to another server using psm
We are using informix IDS 12.10.FC7. We use ontpe for backup and trying to replace it with onbar. When we tried to restore the backup taken from one server to another server,we are facing issues like shown in below bar_act.log: ---------------------------------------------------…
Continous logical log backup stuck - primary
So you're saying that ontape -a -d will backup only the logical logs that are filled ? Didn't knew that. When I was using it it was always backing up all logs so I took it like that :) All the logs are marked with F flag and I wanted to mark them with U and B. It's been a while …
How to Restore Level 1 backup after level 0
Hi, let assume, today is Friday and i have level zero backup of Monday and level 1 backup of Wednesday. Now i restored Level 0 backup on an instance via ontape -r, it was done successfully.Now i also want to restore level 1 backup. How is it possible? to restore level 1 backup a…
Checkpoints statistics
Ok, my friend. You are running HDR in near sync mode. Hope your network between both servers have a very low latency, and that you don't need to failover, since you are not replicating indexes for the secondary server. What is the speed of the network link between them? Is it de…
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.…
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…
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, well I think I read in the Backup and Restore manual that you can from the primary, run a backup and send it over to the secondary and restore it at the same time possibly so this is a good excuse to try that. I will read up on that to see if I have that correct or not, and i…
Issues With Restore
One other option which may be easier than moving files or changing links (assuming you are using version 12) would be to use onbar and the Informix Primary Storage Manager. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids _bar_526.htm E.g. This c…
Logical Log Sizing
Hi Dan, NBU has built in slowness. With one customer I saw on average it takes 9 seconds to backup a 20MB logical log, with a fibre connection and a Veritas server that is almost dedicated to INfomrix (does so small backups once a day. All of the time was in building the XBSA co…
New Channel of Informix Server (Tech)
Hi guys There is a new channel of Informix Server in Spanish , enjoy It -Install , Backup , Restore , HDR and more. https://www.youtube.com/channel/UCVGD_IAhd0VGntXiSh_E6ew Best regards Luis devecua.com…
ownership of system processes
Are there any other states that would indicate an onbar process?…
Backup from RSS?
Over the years (maybe it comes with the age), I've become more "critic" of the options made... But I always try (this is arguable of course) to base my opinions on technical details. And there was a very good reason why a backup on the secondary wouldn't work. I don't mean what J…
onbar ism assert faliure
Hello: When I lauch onbar i receive this error in onbar log ASSERT: file bar_unix.c line 1311 - contact product support. What this error means? I'm trying to do backup in a nfs share folder which is already create, mounted and labelded on ism. Thank you. --001a113f328af77fad0…
log_full.sh getting Aborted by client.
Looks like the location got turn to read-only - have no idea how or why this happened. informix cars: onpsm -D list Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE HIGHEST --/-- DBSPOOL /opt/informix/backups/infx/spaces FILE R…
What log size is too large?
Fernando: Whenever I set up an alarmprogram to backup the logical logs to disk (so not using a storage manager) I also copy the log back up file to another machine for immediate safety. Often that's the HDR secondary's machine but some clients prefer that the remote copy go else…
storage pool doubt
Hi and thanks beforehand. Is there a way to split between raws or chunks in the storagepool new chunks added for a dbspace? I dont want all chunks added to be from same disk.…
Failed to recover the logs after restore
Thanks Art. I've restored from our backup and works good now.…
Onbar and PSM
If you put a valid path name in the onconfig file for BAR=5FBASLIB=5FPATH t= hen this error should not be seen. onbar can run in parallel across your dbspaces. This is one of its large advantages. If you only have a single dbspace then onbar and ontape will run vary close to the…
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…
DBSERVERNAME Best Practice Pri/HDR/RSS
I have not found a nice way to really trick onbar/storage manager since onbar sends the DBSERVERNAME to the storage manager as the image name getting backed up. Then when onbar requests the restore it uses the DBSERVERNAME of the first entry as the image name for the phys and log…
Backup/Restore Primary/HDR
You can restore on the secondary from an archive made on the primary if needed. Your storage manager will be providing the documentation about how you have to do that. Onbar just needs the onbar history which is in the server. Some storage managers need a command line option to d…
onbar and IBM primary storage manager
That is correct. PSM is a set of libraries containing standard xBSA functions that onbar calls to perform the IO needed to output the archive and the onpsm utility which is used to manage the storage and archive history. Art Art S. Kagel, President and Principal Consultant ASK …
Onbar output
Hi, Can I use onbar to backup to a local disk or I need to have an storage manager and tapes ? Thanks in advance.…
upgrade and onbar
hi to all i'm planning to upgrade informix, actually it contains also onbar running with tsm the new install will be in a new directory, so how can i keep onbar running, is there conf files to copy ?..etc ? thanks in advance…
storage pool feedback
Right now in every ifx server I have, space increase is managed manually. Any of you tried the storage pool options? I have done it in test servers and I'm afraid I will loose control over what is the server doing. For instance I'm thinking about creating a storage pool but not…
onbar -c -F in Windows Informix instance
Correction: onbar -b -F (Its not onbar -b -F)…
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)…
after upgrading to 12.1 log back script not workin
All you need to do is to either create the path that PSM_LOG_POOL points to or change where it points. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that…
RE: after upgrading to 12.1 log back script not wo
Well, maybe more of the psm is setup than I first thought, I found the onpsm command and did a list of the devices, objects and pools. Since I'm getting objects I assume the logs are being backed up, but because of something when I do a onstat -l the logs do not show they are bac…
load-insert with no rollback ?
HI, Folks IDS12.10 FC4 I was loading big amount of data to a table, begin work; lock table hist201511_lin_source in exclusive mode; load from hist_lin_source.data insert into hist201511_lin_source ; commit work; later, it was running of dbspace , and session was terminated by…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
OAT User Question
Morn'n Folks, IDS=11.70.FC8XB8 O/S=AIX 6.1 I am in the predicament of administering Informix on environments that I do not know the informix password on. I do have sudo rights to informix and functions that I need as root. I am setting up OAT and "thought" that by setting ADMIN…
Re: How can I resize a chunk?
Since version 11.70 you can enlarge a chunk by doing the following: dbaccess sysadmin <<EOF EXECUTE FUNCTION task("modify chunk extendable on", 1); -- 1 means chunk number in onstat -d EXECUTE FUNCTION task("modify chunk extend", 1, "400 MB"); -- extend chunk#1 by 400 megabytes …
Looking For Senior Informix DBA
I think you are too far. (-; Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Spokey Wheeler Sent: Wednesday, May 20, 2015 3:39 PM To: ids@iiug.org Subject: Re: Looking For Senior Informix DBA [35148] How remote? ;) Sent fro…
point-in-time restore
Oddly enough - it isn't the issue of the type of backup/restore (whole system versus "normal"). The engine continues to fall over with an assertion failure. Still working on it. Thanks - Mark…
Informix integration with DP
When setting debug for onbar (BAR_DEBUG in the onconfig), it could chew up a lot of disk depending on the level. If you'll post your error msgs from the $INFORMIXDIR/bar_act.log (or whatever log file is capturing onbar activity - $INFORMIXDIR/bar_act.log is the default) I can re…
Diffrences between ontape -l and ontape -l -C
My OS is RedHat 6.2 and IDS 11.7. I have some problems to restore the logical logs in the machine backup, If I use the command "ontape -l -C" the logical log are restored, but the chuncks are with inconsistent status. If I use the command "ontape -l", I can't repeat this command…
chunk extendable limit.
AIX 6.1 IFX 12.10 xF4 Hi , Today my production run with v11.50 and I'm evaluating the migration to v12.10 . Considering migrate chunks from RAW to Cooked file (with direct_io+concurrent_io) my initial plan would be export/import the database and reorganize tables and chunks. ~ …
Problem with a upgrade 11.7FC7W1
Hello everyone I updated some of my instances : After wards my tempdbs fill up like 40 gigs holy S#$%@ it was th_probe_ffffffffffffffff and th_build_ffffffffffffffff in database HASHTEMP in this instance I got this error from OAT when opening storage : specified table (storagep…
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
Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message?…
Informix/Oracle
Flip: Whoa! I've heard of salespeople streching the truth, but this is a bald faced lie! Or more than one actually. Either the salesman is lying to you or his management lied to him! I'm sure someone from IBM will join this thread, but for now here is the truth as I know it: - …
ontape backup and restore
Hi, I'm running online ontape level 0 backup on my dataserver. The ontape begin at 7 PM and lasts 2 hours While this ontape is running, there are transactions running that modify datas in my instance at the same time. At 8 PM one transaction truncated data in a table called my_ta…
$INFORMIXDIR/backups - what is it used for?
I figured it out - this seems to be the default setup for backing up logical logs via alarmprogram.sh, which has defaults of BACKUP_CMD="onbar -b -l" and using IBM PSM as the storage manager (PSM had no configuration or setup prior). Why PSM uses that directory for backups I'm no…
Ontape and onbar
Hi, Can I use onbar and ontape to backup an instance? I meant use onbar to send a backup on a storage and ontape to send another backup to the tape in diferents hours. Thanks in advance. Enviado desde mi iPhone…
Onbar Backup
Hi, If I always do a level 0 backup using onbar, Do I need to backup the logical logs to do a restore? Thanks in advance. Enviado desde mi iPhone…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
external restore 9.40.FC8X3
Reinhard, The answer to your question is going to be that you cannot mix onbar level 0 with logical logs backed up using ontape. This IDS version should have the built in ISM (Informix Storage Manager)...so you could backup the logs to disk using onbar/ISM. Mark…
DYNAMIC_LOGS=2 Functionality?
Hi, Silly question ... do you backup your logical logs? If you do want to backup your logs, then consider using ALARMPROGRAM to backup logical logs when complete (using onbar or ontape) - that way you should not encounter full logical logs because they are not being backed up. …
Logical log backup
Folks, IDS11.50FC8 , Linux We have a couple of boxes , all are setup to do automatic logical backup. Once the current log is full, it triggers the alarm procedure to start a backup. It works great. But, The interesting thing is, some servers do not always backup a full logical…
Re: storage pool configuration.
OK, here's the deal: - Chunks are marked as extendable or not extendable. Extendable means it is possible to make the underlying file bigger if needed (so no RAW chunks can be extendable). If it is extendable there is not current limit on the maximum size. The only configurable i…
storage pool configuration.
Hi, ifx 11.70 FC7 . AIX 6.1 I'm studying the best way to use the storage pool at v11.70 . Today we use v11.50 , I'm planning our migration to 11.70 and my desire is allow informix automatically admin my chunks growing and try start with "best" way already configured... I have n…
Logical Log backup
I would like to take logical log backup and I have given ontape -c L and it is taking continuous backup but I would like to run cron job and needs to complete job if any logical backup. May I use ontape -a L? I need to run once a day. If in case may be logical logs more after I h…
Chunk Size
OK, here are the trade offs: At checkpoint time Informix flushes dirty pages to disk with one cleaner thread per chunk (up to the number of configured cleaner threads of course). So, the more chunks the more parallelism at checkpoint time. On the other hand, fewer bigger chunks a…
Warning: The storage pool is out of space
Hello All, I am using the IDS 11.70 FC4, and I am not using the automatic storage pool provisioning feature. But, I have seen this message in the online.log file. I have enough free space available in the dbspaces. Can someone explain that why this warning msg has appeared an…
Warning: The storage pool is out of space
Hello All, I am using the IDS 11.70 FC4, and I am not using the automatic storage pool provisioning feature. But, I have seen this message in the online.log file. I have enough free space available in the dbspaces. Can someone explain that why this warning msg has appeared an…
Logical logs - push or pull?
Good morning folks, We have implemented On-Bar with the CommVault Simpana storage manager (love it so far!). I'm wondering if there is any advantage either way to a) letting Informix backup the logical logs through ALARMPROGRAM (push) or b) scheduling periodic logical log backup…
onbar -v
IDS 11.50FC6 on AIX 5.3. I've taken over management of a newly-migrated system. It's not that big, perhaps 300GB distributed across a bumper 106 dbspaces. It's backed up with onbar using Netbackup. A level 0 takes about an hour. We're required to run a "verify". This is taking…
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.…
Storage pool is out of space error
Hi all, I've recently inherited an Informix database, so I'm relatively new to IDS. Today I got at email telling me: Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add space to the pool. Our main databases have extendab…
informix 11.70 growth edition features
Upps, that would mean a Growth/Workgroup edition could not be part of a XA distributed transaction including other databases on different sites (not necessarily Informix, whatever edition) ? I was thinking that would be only an I-Star function in case the IDS engine itself was t…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Why Temp Table created by View using DATA dbspace
Hi, I am using IDS 11.70 FC4. I have a query which is joininig two views to pull more than 100 million data rows and sorting them. I have noticed that whenever I execute it, my datadbs free space gets consumed, instead of tempdbs. I have added sufficient tempdbs engine is not…
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…
a problem with backup a logical logs
Hello, Yesterday I have a problem with the backup the logical logs and I attached the information that I got from Informix: Can anyone help me to find the problem in order to void this in the future? Any help will be welcome Regards Muthana Here is the information I get from …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Re: Storage pool
I have received this message - at a live site and need to quickly fix - can you help with a pointer…
Logical logs backup to Disk
Was looking to eliminate the use of magnetic tape for DB archive and Logical Log backup and the need for human intervention. Back in May 2012, we had the opportunity to store information an an Avamar Backup system with terabytes of available space. It was easy to perform the nigh…
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,…
Storage pool
Today I had the chance to read up a bit about the Storage Pool. We upgraded to 11.7 only very recently, and this morning I found this message in our online.log: 10:38:32 Warning: The storage pool is out of space. To enable automatic chunk creation use the OpenAdmin Tool to add …
ontape backup/restore
Hi, I have IDS version 10: 10.00.FC10W4 and 10.00.UC11 I want to setup two new DB servers with the same versions as above. Using the ontape backup/restore I will restore the original database to the new DB servers. The setup of the new servers should be identical to the old on…
logical log backups & Net Backup
We recently upgraded two instances from 11.7.FC4 to 11.7.FC5 on AIX 6.1 Strange situation arose in that the automatic firing of backing up the logical logs stopped happening. On instance one, it eventually started working "out of the blue". Instance two is now where instance one …
ontape -r Problem
Vouching for myself, an ifx non-expert, could it be that 7.3 backup's are not compatible with 11.70 restore's? If they're not compatible, would an ETL be a viable alternative?…
ontape on windows when no tape drive attached
Sir, ontape -s works , but ontape -a & ontape -c both give error as ontape -a : Performing automatic backup of logical logs Logbackup failed - Log backup to device 'nul' not allowed Program over ontape -c : Performing continuous backup of logical logs Logbackup failed - Log…
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…
Logical Log backup during L1 archive
On Friday, 27 April 2012 18:57:12 UTC+1, Superboer wrote: > Hello Malc, > > Looooonnnggggg shot.... may be way off here... > > > ism has 4 streams max as paralelization and one can configure it how > many are available > and how many per device etc. > > if all of them are used w…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
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. =========…
Ontape backup and restore with stdio
Does anyone know or recall which version of IDS where "ontape backup and restore with STDIO" feature becomes available? Thanks. Kern --…
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 …
ZFS and Informix
How does Informix stack up against Oracle? I have never heard of any head-to-head private performance benchmark that Informix did not win on performance alone. I have personally witnessed several that Informix did win. Buffer pool performance is not dependent on the filesystem u…
Reminding everyone about the upcoming bigger and better than ever 2012 IIUG Conference
In case you haven't heard, the annual IIUG Conference for 2012 takes place April 22nd - 25th at a new location in San Diego, CA. Here is a sampling of some of the topics that will be presented at the conference: *A Guide to Securing the Database* The enterprise database infras…
reading: Bad file descriptor
I'm trying to restore an onbar backup that is done to disk does the error reading: Bad file descriptor in ism_watch refer to a corrupt onbar file or something else ?…
Re: backup logical log to directory automatically
Hi, To automatically backup logical logs using the ontape backup to directory feature: 1) In the ONCONFIG, ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh 2) Modify alarmprogram.sh script : BACKUPLOGS=Y BACKUP_CMD="ontape -a -d" This will direct ontape log backups to procee…
backup logical log to directory automatically
ids version : 11.5 os: redhat as4 I follow ids backup and restore manual 's instruction : 1. Set the LTAPEDEV parameter to a existing directory. 2. Set the ALARMPROGRAM parameter to the full path for log_full.sh on UNIX or log_full.bat on Windows. 3. Change the backup progra…
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…
Auto Logical Log Backup not working
Hi to all, IDS 11.50.FC7IE; RHEL 5.7 I set up IDS to automatically backup my logical logs by doing the following: 1 - onconfig ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh 2 - alarmprogram.sh BACKUPLOGS=Y BACKUP_CMD="ontape -a -d" 3 - Bounced the engine # onmode -k # onin…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Could I execute ontape,onbar oronunload on HDR SEC
Hi, I want to reduce the workload in the primary server. Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
Could I execute ontape/onbar/onunload on HDR SEC
Hi, I want to reduce the workload in HDR primary server? Could I execute ontape,onbar or onunload on HDR Secondary server? thanks for your time.…
Database per dbspace scheme
I want to place one database per dbspace so that I can easily restore an individual database by using onbar to restore a single dbspace. Why will this not work?…
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.…
rootdbs mirror
That would work. Other ideas: You could also take an external archive (ie onmode -c block) to copy the chunks (using dd, rcp, or a SAN level copy if the storage units are compatible at that level) if you can keep the checkpoint block long enough without disrupting operations. Th…
Backup from HDR
Hi, We are using IDS 11.50 FC6 & FC7 on Solaris Sparc. Is it feasible/reliable to get cold/hot backup from HDR ? I have tried and got successful while taking/restoring backup from HDR. Thanks.…
PIT Recovery
Thanks for the information. Can you also guide me how to use (backup/re-store) using onbar process. Thanks.…
Logical log backup SLOW to NetBackup
We are in the process of changing our enterprise backup solution from Tivoli Storage manager (TSM) to Symantec NetBackup (NBU). Our Informix logical logs average about 32mb in size and are able to backup to TSM in 5 seconds or less. The Informix databases that have been converted…
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…
Onbar Help
IDS v11.50.UC6 Solaris 10 I am trying to restore an archive of my test instance to my testfms instance. These instances reside on the same Unix host. Here is what I have done: The DBSERVERNAMEs involved are test and testfms andthe SERVERNUMS are 3 and 5 respectivley. Here is w…
New System Config and DS8800
Hello Throwing out feelers on some questions regarding the setup of Informix OLTP systems on the new DS8800 Storage. We had drawn up a RAID 10 design for both data and logs and received feedback that RAID 5 would work out just fine. Through the years, the literature, conferences…
ON-Bar parallelization
Hello folks I am looking at using onbar to take advantage of the parallelization. Looking at the example at this address http://www.ibm.com/developerworks/data/library/techarticle/dm-0611sinha/index.ht ml the implication is onbar backs up the chunks in the dbpace in parallel. I…
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…
OK Next step: ISM imported restore of onbar -w using disk-based backups
For reasons to complex to go into, we're now backing up to disk (data and logs), using onbar -w and ISM, pool names ISMDiskData and ISMDiskLogs whereas before we used an external storage manager to tape. We do a copy of our live database (300Gb or so) on a regular basis onto our …
Logical log backup aborted (during ontape -r)
Art, I'm trying to restore an production database (backup done with ontape), in a test database (using ontape -r) and I've the messages in the online log Regards…
Mach11 questions
On Wed, Sep 8, 2010 at 12:25 AM, shorti <lbryan21@juno.com> wrote: > -How UPDATE commands are routed if coming through an SDS node > Not sure about what you need to know... But there are specific threads on the primary to deal with that type of requests. It's important to check…
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…
Import restore issue
Tri, As Joe states, ontape is a lot easier. While this should not be a big deal for onbar, adding ism into the mix makes it difficult, as is it is not easy (you can do it, but it is a pain) due to the limitations in ism. If at all possible, use either ontape or get a more robust…
ISM issue.
Hi, I just setup the ISM for the new install of Linux Dynamic Server Version 11.50.FC1, and I have issue with onbar b w in the new ISM setup. Please advise. Here is the ISM setup Modified the onconfig file. ISM_DATA_POOL ISMDiskData ISM_LOG_POOL ISMDiskLogs LTAPEDEV /apps…
database backup using commvault simpana
Hi, Is anyone in the mailing list using Commvault Simpana's backup solution to backup their informix databases ?. are there any issues with this product's backup/restore procedures and is it a reliable tool ? any inputs will be appreciated Thanks Savio Pinto…
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…
stop running logical backup
Hi, We are running IDS-10.00.FC6 in HP-UX11.11. We have issue with backup device. Is there anyway to stop the running logical log backup thread? Is it safe to kill the Unix backup process?…
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…
Logical Recovery During restore
Sorry, forgot to add. Below are the log backup times from the online log of the server that is being backed up. 03:32:43 Maximum server connections 1590 03:47:43 Fuzzy Checkpoint Completed: duration was 0 seconds, 1503 buffers not flushed. 03:47:43 Checkpoint loguniq 26019, logp…
Display contents of Logical Log
Is there a way to display the contents of the logical logs if the LTAPEDEV parameter is set to backup the logical logs to a directory? (LTAPEDEV /informix11/inflog) I had a look at the onlog command and in that the -d switch accepts the tape drive path. Appreciate your response…
Re: RSAM
How come INFORMIX-JDBC has examples of RSAM calls like for rs.next()?, and "...IDS is divided into two parts: a storage manager called RSAM, and a query optimization/execution engine implemented on top of RSAM, and has a well-defined, published API...Implementing Index Stride a…
Automated Logical Backup using Netbackup Policy
Hi All, Can someone explain how the automatic logical backup is working? As far as i know, there's a ALARMPROGRAM variable and the value is "$INFORMIXDIR/etc/log_full.sh. Once the threshold is reached, it will automatically kick the logical backup. 1. Where does informix get th…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
Have any of you experienced this? In reviewing the online.log, I discovered that AFTER a system reboot, and ONLY AFTER a system reboot, the first time the "Auto Update Statistics Refresh" begins, the following performance advisory is recorded. The Backup occurs nightly, the AUS …
How to delete logic log backuped before 30 days
How to delete logic log backuped before 30 days Hello every: I backup my informix use TSM server. my policy is backup all data (0 level) every day , and opration by handwork. online logic log backup TSM use this same policyset. Becase of Informix online logic log named b…
How to delete logic log backuped before 30 days
Hello every: I backup my informix use TSM server. my policy is backup all data (0 level) every day , and opration by handwork. online logic log backup TSM use this same policyset. Becase of Informix online logic log named by id, so TSM don't know how many version has been backu…
Re: Linux LVM snapshot
> Correct me if I am wrong but with a SAN snapshot you can only recover to > the point of the last snapshot, but with HDR/RSS you always have a backup > system that is in sync with the Primary and can be made Primary in a few > seconds with a few simple onmode commands or automat…
onbar failed
Hallo, I'm trying to make a logical backup using onbar -b -l. bar_act.log says 'completed' but no log is created on file system. What does bar_srv_status: return 5 (0x05) mean? Whole log in bar_debug.log with level9: 2010-02-08 10:19:10 2460 2460 bar_get_hostname: enter 2010…
Re: Informix Mirroring
Thank you both Art and Eric for your input on informix Mirroring. have a great day. --Dave On Wed, Feb 3, 2010 at 3:57 PM, Art Kagel <art.kagel@gmail.com> wrote: > On performance, Informix's testing back in the 90's showed that > hardware/firmware mirroring was fastest follow…
Informix Mirroring
On performance, Informix's testing back in the 90's showed that hardware/firmware mirroring was fastest followed by OS level software mirroring, followed closely by Informix's mirroring. The main reasons to use IDS's mirrors are twofold: - Convenience. You don't have to dep…
logical log problem
Dear all, Currently face one problem, one of the instance logical log keep full even i try to backup everyday. But based on my understanding this instance suppose not much activities. Anywhere i can check what caused the logical log keep getting full? Thanks in advance.…
Onbar problem
Hi we have got another onbar problem : In the middle of a sbspace-backup , onbar was cut down by a sanswitch-port malfunction and now it looks like the archive-flag for the sbspace has been permanently set. When i try to start another backup on this instance , bar_act.log says…
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…
shared memory not initializing
Hi, Check the ff: env variables on informix user before doing the restore. INFORMIXDIR ONCONFIG= should be the original value PATH INFORMIXSERVER Your physical logs and logical logs does not match the backup you are trying to restore.…
onbar
Hi All, I've encountered I/O error in informix and it needs a full-restore "onbar -r -p". While performing restore, it encountered problem due to some network issues. Is there a way the onbar command will start on the location it stopped? This is to mininize the downtime of the…
onbar
I need to add some logical logs to my XPS datawarehouse. There is no ontape and I need to do an onbar to /dev/null. I don't want to take a real backup. Can anyone give me the instructions for this? onbar -b -L 0 - but how do I direct this to /dev/null instead of a usual device? …
onbar problem
Hi We have recently upgraded to 11.50.FC5 on Hp-ux 11.31.ia and have problems running level 1 backups When we tried to start a level1 backup 22 hours after a level 0 , we got this message : 2009-10-05 19:00:41 18160 18157 Unable to start the storage space backup: The exis…
how to free up logical logs
Hi All, I've encountered problem on logical logs once again... I'm using onbar on backing up the logical logs and dbspaces. Unfortunately, the netbackup failed and causing the "logical logs" full. Q: what is the correct solution, without losing the logical logs? Is there any wa…
Table structure backup/restore
Hi All, How I can take the backup of table structure and all its data and how to restore that table including all data.We are using IDS 7.13 running on HP-UNIX 10.01. Thx,…
ontape -c
I use 'ontape -c ' to backup the logical log, if the 'ontape -c' process was terminated abnormally, for example, the machine crash or it was killed by others, do anybody know if I could restore those logical log sucessful?…
Logical logs backup
Hi, We are using IDS 11.5 and OS is RHEL 5.3 We have 10 logical logs having the id from 4-13. I did a database import to the existing database and hence the logical logs becomes full. The status of the logical logs is Logical log 4 to 7 -> U_B__ Logical log 8 -> U_C_L Logical l…
Informix HADR - Add new Database
IBM Informix Dynamic Server Administrator's Guide Planning for HDR Before you start setting up computers and database servers to use HDR, you might want to do some initial planning. The following list contains planning tasks to perform: * Choose and acquire appropriate hardware…
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…
ONBAR woes :-( Advice needed
BRYAN PURKIS wrote: snip.... > > I add valid tapes to the pool and also to the scratchpool and try again. > > Whaddaya know - i get this error in the bar_act.log "XBSA Error (BSAInit): > That object already exists" > > Not good - on interrogating sysutils i see there actually IS …
Log backup failing
Hi, Our log backups are failing when the transaction volume increases. The online log shows 13:15:02 Logical Log 3614 - Backup Started 13:15:03 Logical Log 3614 Complete, timestamp: 0x283fb1f4. 13:15:04 Logical Log 3614 - Backup Aborted Aborted by client. 13:15:05 Logical Log 36…
ONDBLOG COMPLETE ,returning 18 (0x12)
Okay, can u attach the last 100 lines of onbar log file and online log file, that would help…
HDR with level 1 backup
Hi, Disk containing the log backups got run out of space. So some of logical logs were not backed up. HDR secondary got out of synch. We are trying to make the secondary node again the part of HDR, but because of insufficient logical logs we are unable to do so. We can take 0-lev…
Onbar Issue
Hi, We are trying to use "onbar" to configure our TSM. While trying to use "onbar" in our Informix instance, I see the following error in the onbar log.. 2009-06-08 07:36:54 28855 28853 /usr/informix/bin/onbar_d -b -w -p - L0 2009-06-08 07:36:54 28855 28853 (-43231) An unex…
ISA miss leading chunk status
Hi, On RedHat 5.1 32bit (Kernel 2.6.18-92.1.18.el5xen on an i686) I have install Informix Dynamic Server Version 11.10.UC1 Informix chunks are managed using lvm and reside on external disk storage with multipath connections Recentrly I have installed ISA 1.60. Everything seems t…
Help on onbar
Anyone online at this moment? I'm traying to recover from onbar, as the root dbspace and a data dbspace where lost when a disk crashed. I did an onbar -r and all of the dbspaces were recovered but the dbspace dedicated to logical logs. online can't be started becaus of Logical …
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?…
Backup logical logs
Hola, tengo un servidor en Unix con Informix 7. Yo quiero hacer backup de los logical logs a disco... En el ONCONFIG le coloque al parametro LTAPEDEV una ruta de mi disco. Luego como hago el backup? Gracias por su ayuda…
Esoteric Disk Issues
What's wrong with ZFS for databases is that it was designed for filesystems. From the OpenSolaris ZFS pages ( http://www.opensolaris.org/os/community/zfs/whatis/): ZFS presents a pooled storage model that completely eliminates the concept of volumes and the associated problems …
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…
Informix on a SAN?
Good morning Joseph, Gladly, I have two different uses of Informix IDS 10.00.FC5 in two different SAN environments. My primary use of Informix with my University's ERP system by Jenzabar. It's on an HPUX system with an EMC Clariion cx700 Fibre-channel SAN. I use LVM manager with…
Backup & Restore confusion
Hi, I'm a bit confused about backup and restore using ontape. Why do I need to take a logical log backup with ontape -a (log # 15) after a ontape -s -L 0? The full Level 0 archive says it contains the log # 15 but during restore I have to apply the logical backup also containing…
Ontape to backup Logical logs - Query
Hello, IDS 11.10.FC3 on solaris 10. #Please consider this as a query and not a problem yet. #I know the my logical logs are small in size(500+, 20M each) for taking some hectic transactions BUT not possible to to increase the log size atleast for now. In 11.10.FC2W4 i faced a …
Pretty basic onbar restore question...
Hi everyone. I know this is a pretty basic, general question. But I would like to be sure about something related to restoring with onbar. My question is...regardless of what storage manager is being used...whether that be NetBackup, or ISM, or Networker or whatever....when you …
on bar restore from machine A to machine B?
Yes, performed this several times using TSM and onbar. If needed you can rename chunk names. Regards, Bart…
Logical Log files MISSING
Hello Ive checked the online.log file for one of the missing log 20084 23:12:22 Logical Log 20083 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20084 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20083 - Backup Started 23:12:23 Logical Log 20083 - Backup Comple…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Test Restoration failed
Finally i reinitialized the test instance and started the restore using ontape -r. But the restore which was suppose to finish in 7-8 hrs on this server (as tested many times before)is not running over 15 hrs and i can see in onstat -D that one complete chunk is yet to be restor…
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…
Re: onbar
the limit is 4 sessions afaikr for ism so 4 devs each one session will hit the limit. or 1 dev and 4 sessions will also hit the limit (multiplex...) and 2 TB in 8 hours is not bad at all. Superboer. On 23 jul, 16:55, "Campbell, John (GE Money)" <John.Campbe...@ge.com> wrote: >…
onbar
Running IDS 9.40.FC5 onbar with ISM, Solaris 9 I'm planning to upgrade to 10 or 11 asap and want to use archecker for table-level restore. Currently, we have a hodge-podge of unload files and a level 0 onbar taken weekly to put the database back in case of a complete loss. I …
Re: Raw Device IO Error
Christian Schmidt wrote: > Hi, > > I have a problem with my Storage Manager and Informix. Sometimes the > Infomix DB crashes when I try to sync a mirrored rawdevice (not an > informix mirrored chunck). > > Here is a passage from the online.log: > > 14:40:51 Logical Log 1320 - Ba…
Raw Device IO Error
Hi, I have a problem with my Storage Manager and Informix. Sometimes the Infomix DB crashes when I try to sync a mirrored rawdevice (not an informix mirrored chunck). Here is a passage from the online.log: 14:40:51 Logical Log 1320 - Backup Started 14:40:55 Logical Log 1320 …
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Table design question: (var)char vs. datetime/interval
Dear Informixers, I inherited a legacy application that stores most data in one large flat table. There is a unique record ID that serves as primary key for this table. Now there is a requirement for storage and processing of additional information for each new record, most of …
incremental onbars
9.40.FC5, Solaris 9. It seems to be my station in life to inherit things. When I inherited this db, we were running on some flavor of 7.31. Someone else designed the onbar backup and currently we run 1 level 0 a week. It is running muti-threaded and takes 6 to 8 hours to run. …
Veritas Netbackup to schedule onbar
Hi everyone. I have a IDS 9.4 database that uses Veritas netbackup to schedule the onbar backups on a Unix AIX machine. General question...If I were to need to do an onbar restore there is no reason why I would not just do a typical command line driven onbar restore...is that cor…
onbar portability issues?
It depends on the capabilities of the storage manger you are using. If you are using a storage manager, the steps are listed below: 1) install storage manager client on new host 2) register client with storage manager 3) restore or copy the following files $INFORMIXDIR/etc/ixbar…
onlog and onbar
Hi all. IDS 9.40FC9W2, Solaris 9, Backup with onbar and Legato Networker (nsrdbmi). Following the manual it should be possible to retrieve Logical Logs file from backup medium by specifying the Log ID. The manual "Administrator Reference" says: You do not need to use the -d op…
Onbar and LTAPEDEV
Paul - As it relates to logical log backups, setting LTAPEDEV to /dev/null will cause a used log to be immediatly freed for reuse, if the log does not contain information regarding an open transaction - the log is not backed up at all. My question pertains only to archives and …
Restore backup and Archecker Failed...
Hi, IDS 7.31 FD2 HP-UX 11.00 first, sorry my poor english.. I tried restore a archive Level 0 and failed... When test the backup file with archecker , failed too... The backup file is create over file system: TAPEDEV /backup/L_backup TAPEBLK 1024 # Tape block size (Kbytes) TA…
Restore backup and Archecker Failed...
Hi, IDS 7.31 FD2 HP-UX 11.00 first, sorry my poor english.. I tried restore a archive Level 0 and failed... When test the backup file with archecker , failed too... The backup file is create over file system: TAPEDEV /backup/L_backup TAPEBLK 1024 # …
ontape -s -L 0 performance on Win2k3_x64
Check the volume of Logical Log usage during the backups. Is there a significant difference during the fast backup compared with the first 2 hours of the slow backup?…
Re: Backup/restore compatibility
On 18 Feb, 22:09, Fernando Nunes <s...@onlinedomus.net> wrote: > Troels Arvin wrote: > > Hello, > > > On Sun, 17 Feb 2008 23:36:27 +0000, Obnoxio The Clown wrote: > >> This is what dbexport exists for. > > > Thanks - it looks like dbexport will be of use. And the dbexport word le…
parallel backup and restore w onbar
hello, In IDS10, using onbar, can I do parallel backup and restore on an instance that has no database transaction logging ? I think I should be able to, as long as I backup the logical logs and logs will need to be restored during a parallel restore. Is that correct ? ps. I rea…
Backup/restore compatibility
Hello, In the DB2 World, there is a (very annoying) constraint concerning backup/ restore: Data backed up on a big-endian host cannot be restored on a little-endian host, and vice versa. The constraint is very illogical considering that one of DB2's selling points is the possibi…
Re: How can fetch cause long transaction
> I have one more question: > > When DYNAMIC_LOG is set 2, does it starts to add more logical logs > dynamically when next logical log in the sequence has open > transaction. Does this become active only during roll back and next > logical log has an open transaction or could it …
Logical logs backup to disk
Hello Guys, here's another one of which I'm in doubt for some time. Finally decided to post it. If backup of logical logs is written on disk, do you need to rename the existing file first before starting a new backup, or is there an "append" ? In other words, if you don't rena…
onbar label 0 backup will backup logical log ?
my box is ids10 with TSM. I issue 'onbar -b -L 0' or 'onbar -b -w -L 0' to backup label 0 archive. It will backup logical log automatically . Why It do this ? Can I backup full system not include logical log file just like 'ontape -s -L 0'?…
OnBar and ISM
Currently I am running IDS 9.21.HC6 and using On-Archive for backups. I am in the process of upgrading to 9.40.HC7 and On-Archive no longer exists. I have been trying to use OnBar and ISM but having various problems which IBM have so far been unable to resolve. Would On-Tape b…
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…
Never ending Checkpoint
IDS 9.40.FC4W2 SunOS 5.8 Last Saturday we had a "never ending checkpoint". There are no loggings about the event except the lines in online.log: 11:41:01 Fuzzy Checkpoint Completed: duration was 2 seconds, 2789 buffers not flushed, timestamp: 0x60364810. 11:41:01 Checkpoint …
How HDR resync after network connection resumes
With "RETAIN_TYPE" is set to 1, HDR would be reestablished from secondary server when old primary is up once again. When the logical log backup has been performed on secondary server, how the oustanding logical log could be retrieved for resync to old primary server? 1) Do I ne…
ontape,onbar, HDR,ER-Which tool to use?
Onbar is extremely reliable and flexible. Perhaps ISM isn't but onbar is. We've used onbar for years with Veritas Netbackup. Do you have a corporate "standard" for your backup software such as Netbackup or IBM TSM (Tivoli)? Onbar will work very well with Netbackup, I have no expe…
Onbar - performance
Dear Listers We are moving our Informix 10 instance to a new host and during backup and restore testing I have identified a problem with recovery performance. Maury Tiller wrote some tools to test various components of the onbar/XBSA interface which were available from http://…
Newbie onbar vs ontape question..I hope that's ok
Hello everyone. I have a newbie question - I hope you don't mind. I have an IDS 9.4 database, although that should not really be relevant to my question - I think. Question is using both onbar and ontape. I understand of course that one cannot use an ontape archive tape and use o…
ONBAR not working
Hello, From the ism commands below, we cannot tell what type of ISM device is this one (tape or file?). I think that, one of the steps missing here, before labeling the ISM device, is to add the device and indicate its type (file, in this case?), using the 'ism_add -device' comm…
windows-1252?Q52=65=3A=64=69=72=65=63=74=69=6E=67=
The storage manager is responsible for archive output location when onbar is used because the storage manager will have to be able to locate the files in case of a restore request. So, you'll have to set that up in netbackup if you can. Art S. Kagel ----- Original Message -----…
directing onbar to disk?
I'm migrating an Informix enviroment to the datacenter of our parent company. They use Netbackup as the storage mgr (we use TSM). The Netbackup agent for Informix is installed and onbar configured to use it. Netbackup is taken down everyday from 1100-1300 for 'maintenance'. This,…
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…
Re: Onbar backup using Tivoli Storage Manager
Hi, when you are using ON-Bar as backup and restore tool, then ON-Bar will always send all backup objects to the storage manager (SM) and will retrieve restore objects from the SM. What the SM does with these objects is a configuration matter within the SM. I do not know TSM wel…
Onbar backup using Tivoli Storage Manager
Hi guys, Is it possible to send logs backup of informix to disk using TSM? How can this task be achieved? I understand that ontape uses LTAPEDEV and whenever you use onbar and a storage manager to backup Informix, TAPEDEV and LTAPEDEV are ignored and all the mechanism control i…
Fatal error in shred memeory creation
FYI - My UNIX Administrator has restored a system backup taken before the power failure and my Database server is now up and running.…
BAR_MAX_BACKUP - not spawning parallel threads
Version : 10 We are running onbar -b -l with BAR_MAX_BACKUP = 4 and BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process I just see one onbar_d process. I was expecting atleast 4 processes. Why is it just spawning one process. Is it because our SHMTOTAL is 0.…
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…
Research into onbar
I am trying to find out if anybody has any experiences of using onbar in an "emergency" situation. Especially with an "imported" restore or a "rename files" situation. I would be interested in knowing what operating system, what versions of IDS, and what backup storage manager …
Backup worked...restore doesn't...
Hi All, I was able to get my backup done the other day just using ontape -s -L 0, everything seemed just fine, total space of backup 497 GB. Now today I'm trying to restore that same tape onto another server. Informix has been installed, onconfig file was mirrored from original …
IDS Primary down
Hi all.... In it completes week, my IDS Primary has down in 4 opportunities having shown the following message of error: 03:10:47 Maximum server connections 567 03:11:21 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 03:11:21 IBM Informix Dynamic Server Version 10…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
onbar on an inactive node?
Can I run onbar on an inactive node? We have a cluster env(ACTIVE/INACTIVE conf) and wants to run the onbar backup process on the inactive node? Thanks, Yogesh…
Re: Informix beats Oracle
DA Morgan wrote: > Ian Michael Gumby wrote: >> >> >> >>> From: Fernando Nunes <spam@domus.online.pt> >>> http://www.oracle.com/database/product_editions.html >>> >>> And guess what... We don't get the following in EE: >>> >>> - RAC (obviously) >>> - Database Vault >>> - Oracle Ad…
IDS 10.0 and Legato Networker
Thank you Javier. I have changed the variable DO_LOGFILE_BACKUPS from YES to NO in the nsrdbmi script. The database backups now complete successfully in Legato. I have successfully completed a full complete restore (onbar -r). Also I successfully completed a point in time or poi…
TSM and IDS - Any suggestions for best performance?
We are in the planning phases of a Tivoli Storage Manager backup solution implementation for our enterprise to include IDS, SQL Server, MySQL, mail and a collection of other client files here and there. Anyone have any suggestions or pitfalls to avoid that can help make this imp…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
LLOGS backup
I have a client who is running IDS 7.31 UD6 and is doing a level 0 backup each night, using: ontape -s -L0 The issue is that the logical logs do not move to a 'B' status. I suggested running: ontape -s -a -L0 with no success. Currently they are manually managing the logs; is …
Upgrade IDS 9.40 UC2 to IDS 9.40 UC7
On Apr 19, 9:21 pm, "col...@gmail.com" <col...@gmail.com> wrote: > On Apr 20, 1:15 pm, Jonathan Leffler <jleff...@earthlink.net> wrote: > > col...@gmail.com wrote: > > > We have been advised from our EDP supplier that we need to update our > > > 9.4 server from UC2 to UC7 because…
Allocation of the 80-90% of resources for dbexport
I'm use ext3 filesystem. I need this backup mechanism for restoring database on other sides/servers. Is it possible to allocate more resources for dbexport process namely?…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
RE: onbar
ISM is the storage manager. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Campbell, John (GE Money) Sent: Tuesday, March 06, 2007 3:36 PM To: informix-list@iiug.org Subject: onbar IDS 9.40.FC5 Solaris 9. I'm…
Re: onbar
John, Unfortunately you didn't mention the storage manager in use. If this is TSM, the IBM technote as per URL mentioned below might help. I remember that this could be related to dsm.sys parameter PASSWORDACCESS which should have set to value 'GENERATE'. Of course, the techno…
onbar
IDS 9.40.FC5 Solaris 9. I'm attempting to do an imported restore with onbar. I'm getting the following error: 2007-03-06 14:43:36 1164 1162 /opt/informix/bin/onbar_d -r 2007-03-06 14:43:36 1164 1162 Successfully connected to Storage Manager. 2007-03-06 14:43:36 1164 1162…
Splitting logical logs
IDS 9.4 WE, Sola�ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logic…
Informix backup & restore
We have an IDS version 10 installation containing a number of dbspaces. We have created a database on each dbspace eg dbspace1 database1 dbspace2 database2 dbspace3 database3 Is it possible to restore a database (eg restore its correspondig dbspace) to a point-in-time withou…
onbar
9.40.FC5 Solaris 9. Attempting an imported restore with onbar. I have 4 devices on disk. I am able to mount 3 of the 4 with ism but one of them is giving the error "nsrmm: error, no file label found" when I try to mount it. I tried to read it into the catalog with ism_catal…
Veritas Net Backup : on-bar IDS 10.0 AIX 5.3
Hi, what exactly do you mean when you say "we are not able to connect to the new (dummy) instance for backup."? I guess you are able to connect to the new instance using a utility like dbaccess. Is it that when you want to execute onbar commands that they can't connect? How do…
Ontape backup/restore to disk
Hello All, I would like to use the Informix ontape utility for both Level 0 backup/restore and transaction log backup/restore. Instead of using an external tape device, I would like to back it up to disk (files). Currently we are running IDS 7.31 on Sun Solaris 9 servers. To …
Total length of columns in constraint is too long
Ankur, Sorry about the previous email response. Here is what I meant to send. I am not sure what documentation you refer to, but the IBM Informix Guide to SQL: Syntax for 9.x found at the link listed below clearly states the limitations of multiple column constraints( pag…
Onbar Pools and File System with ISM
Andre, You could start by checking out the following online manuals. The firs= t link is to the IBM Informix Storage Manager Guide and the second is to the IBM Informi= x Backup and Restore Guide, both of which will be helpful to you in answering yo= ur questions. I believe the…
Re: Moving logical logs backup to disk
Hi Robert, The storage manager backup client runs on the database server, the storage manager backup server and tape run on a different server. We actually want to get rid of the storage manager backup software and just use informix to output the logs and database backups to di…
Re: Moving logical logs backup to disk
Gerry, You mentioned that the sys admin guys at your site want to retire the seperate server with tape drive. Just for clarification, does this mean that this server also is the storage manager server or is this just the configured backup target with tape devices only? If this …
Moving logical logs backup to disk
Hi, Does anyone know how to redirect our logical logs backup from tape to disk? We currently use a storage manager and onbar and a seperate server with tape drive for this purpose. The sys admin guys want to retire the seperate server with tape drive. This is our configuration:…
onbar log backups aborting w/TSM
IDS 9.40 FC2XA HPUX 11.11 Greetings, I have a very interesting situation that started about a week ago. My onbar logical log backups are being "Aborted by client" (online.log). The bar_act.log file indicates "SQL 4294967025 Could not insert new row into table." followed by "I…
Logical log backups
Hi I am having a dreadful time with a autochanger tape device for which my logical logs and archives are backed up to. Problem being the device frequently stops working and unless it is fixed before the logical logs run out, I get downtime. I am using the networker software to …
Backup Of Specific Tables
Hello All, Wondering if there is a way to script a backup operation for specific tables as opposed to an entire database? Our scenario involves backups being written to a tape drive. We would wish to backup a couple of tables to tape and then restore if a job to update said ta…
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…
OnBar
Hi, I configured onbar to generate files in a specific directory and works fine. When the directory has space works fine, but freeze when the space ends and we remove some files keep freeze. What can I do to resolve this? henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br …
Onbar problem
Hi all, I've configured an IDS database with ISM for backup using onbar; in the bar_act.log I see: WARNING: Logical Logs will not be backed up / salvaged because LTAPEDEV value is /dev/null but in $ONCONFIG the LTAPEDEV parameter is not set at all; I tried to set it <blank> wit…
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…
onbar problem
this is my bar_act.log .......... .......... 2006-07-02 22:14:20 1553 1551 /home/informix/bin/onbar_d -r -t 2006-07-02 17:50:50 2006-07-02 22:14:21 1553 1551 Successfully connected to Storage Manager. 2006-07-02 22:14:21 1553 1551 XBSA Error: (BSACreateObject) A system error o…
RE: HDR problem with Windows
Alexey Sonkin wrote: > Please, check the fillowing: > - Are you able to connect from 'informix' windows session > on Secondary machine to Primary database server without password? > With password? From Primary to Secondary? > - Did you create the hosts.equiv file under > C:\\win…
Re: checkpoint problem
On 19 Jun 2006 23:57:34 -0700, mchivaviro@okzim.co.zw wrote: > >I am runnind IDS 7.31 on HPUX 11 and my check points a taking too long. >What do I need to change. > >12:03:10 Checkpoint Completed: duration was 21 seconds. >12:09:48 Checkpoint Completed: duration was 34 secon…
restoring just from logical log tape
When I run 'ontape -r', it asks me if I want to restore from an archive tape (an 8mm tape) after restoring from level0 backup (a DLT tape). Is there any way to just go straight to that 8mm tape for restore and bypass the hour I have to wait for the level0 restore to complete befo…
Re: Upgrading to version 10 ontape question
"Table Level Restore (TLR) is based on a normal backup/archive. Normal backups/archives are platform dependent, therefore TLR also is platform dependent." That is not what John Miller III said to me at the Atlanta conference! Table level restore can restore to remote instances …
Re: Upgrading to version 10 ontape question
For a platform independent backup/restore use version 10 and table level restore to restore all tables from a level 0 archive. This is platform independent. Backup/restore will always be version dependent since each new version has more features. David.…
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?…
OnBar error.
Good morning all, thank you for your responses on my last posting, I am currently trying all the suggestions out and will get feedback for you shortly. Related to the unexpected No Response error from OnBar that stops the Continuous logging( I have a suspicion that this has to …
Onar failure
My Apologies for poor spell checking. The Title should read OnBar Failure.…
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.…
logical log size
Hello, The logical logs on my system are configured as 30 32MB logs. The system has been growing rapidly and currently cuts 2-3 logs every 5 minutes. Backup is to a spectralogic tape unit, which is fairly slow to spin up. In order to not run out of logs due to backup issues, I w…
Not using the 100% logical log page size alloacted to informix
it seems the alarmprogram executes the onbar commands onbar -b -l TIA…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
Restore Informix-Emc-Data Protector 5.1
Valeriano V.... wrote > I want to restore the logs until 13:45:00, with Omni Back > Data Protector v5.1 > > On the GUI of Omni Back Data Protector, I don´t see the > option for do this. > > What is the Unix intruction for do this ?? onbar -r -l -t <point_in_time> Read the Infor…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
return code 164 during logical log backup
Hi all, I have following kind of problem with logical logs backup: When the current logical log is comming full, it does'nt make logical log backup and in online log of informix following message appear: -------------------------------------------------- 16:13:14 Logical Log 524…
Backup on inst1 and restore on inst2
Hi all, I have 2 instances IDS 10 (inst1 and inst2) on the same machine Windows 2003. The 2 instances have the same configuration, unless DBSERVERNAME and SERVERNUM and the same structure. I would like to know if is it possible to backup the datas of the inst1 and make a restore…
TSM DB and Logical Log backups
IDS 9.40 FC2 HPUX 11.11 We are in the process of implementing TSM backups for our dev/test servers and I have a question regarding continuous logging and TSM. I would like to know if someone is currently using continuos logging to TSM and if there is anyway to define the log po…
error on onbar
Hi everybody. Im reposting this email to ids list which should be more apropiate than classics for the issue. J Leffler corrected me about. Have any off you deal with something like this? Thanks in advance for your comments. On 1/2/06, Nstor Gme.... <nestorgm@prodigy.net.mx> wro…
Onbar with Arcserve
Has anyone any experiences in using onbar with Arcserve? It's a combination I've never seen before Regards Colin There are 10 types of people in the world, those that understand binary and those that don't sending to informix-list…
ids10.force to drop a chunk
Can't onspace bring the chunk back online? Use onspaces -s <spacename> -p <path> -o <offset> -O Otherwise restore from a backup.…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Onbar physical followed by onbar logical...then...ontape ?
TBP said: > > Gentsch, Sam wrote: >> -----Original Message----- >> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] >> On Behalf Of scottishpoet >> Sent: Monday, November 14, 2005 6:50 PM >> To: informix-list@iiug.org >> Subject: Re: Onbar physical followe…
RE: Onbar physical followed by onbar logical...then...ontape ?
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of scottishpoet Sent: Monday, November 14, 2005 6:50 PM To: informix-list@iiug.org Subject: Re: Onbar physical followed by onbar logical...then...ontape ? >since you wer…
Onbar physical followed by onbar logical...then...ontape ?
since you were taught not to mix onbar and ontape the, since you archive using onbar you will have been backing up your logical logs using onbar as well, I assume this is a purely hypothetical question…
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.…
Onbar and ISM
Good day to all, I am interested in using Onbar with ISM to disk. The Informix instances are small < 10GB each. I have onbar running now but have noticed a few things and was wondering if anyone already had a script to share that performs the tasks outlinde below: 1) Level-zero …
Free space...Clustered Data
Do many companies use clustering indexes...via table data ordered by a key (clustered)? Is there a performance boost in Informix when the data is clustered -- and then retrieved via cluster sequence? If clustering helps, will Informix allow us to specify the % of freespace on a…
Onbar - URGENT!!!
The problem is that we are trying to restore database but we have not enough space to restore all storage spaces of the instance, but we have enough to restore rootdbs, phyldbs, logsdbs and docubpudbs where the entire database "bpu" is contained to recover some tables deleted acc…
Onbar - URGENT!!!!
The problem is that we are trying to restore database but we have not enough space to restore all storage spaces of the instance, but we have enough to restore rootdbs, phyldbs, logsdbs and docubpudbs where the entire database "bpu" is contained to recover some tables deleted acc…
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…
Copy more than one instance on a single tape in Informix IDS 7.31
Hi. I would like to knwo whether is it possible or not to backup more than one instance in Informix IDS 7.31 on a single tape for later restore all of them. I tried it but after each backup the tape is automatically rewinded and so the other backup superposes the first one. The …
Script failure
Problem has moved to a particular onbar -s -l that seems to be hanging. No cpu, no memory is showing as used…
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…
Both ontape and onbar on the same system?
<mweallans@panacea.co.uk> wrote in message news:1120664873.326218.218040@g44g2000cwa.googlegroups.com... > However their next challenge is that they would like to run both ontape > and onbar for a period of time to backup the same server. I don't > think that should present a p…
IDS 9.21 Backup/Recover strat with HDR
Thank you for such quick responses. I would like to upgrade Informix but have no say in the decision. The current storage manager is Legato which is unsupported at our level and is being retired. Also because there is no staff to mount tapes at its location. I inherited this sys…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
onbar
hi, i try to use onbar to backup my informix 9.40 instances with TSM. when i backup manually all works fine, but when i do it by cron, i encounter two types of error : on one instance i have in the bar_act.log : 2005-06-17 09:33:00 352242 21878 /informix/bin/onbar_d -b -L 0 2005-…
ISAM error: illegal argument to ISAM function
A couple questions. How do you restore a dbspace from a point in time? I use onbar. Since it is no longer there & I took another backup since I dropped it, I can't just use onbar -r. I've tried restoring the entire instance from the backup but then I get error messages. Shou…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: Logical Logs's
begnadigen Sie mich, Ich verstehe nicht -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bono Vox Sent: 04 May 2005 11:02 PM To: ids@iiug.org Cc: iiug-esp@iiug.org; informix-list@iiug.org Subject: Logical Logs's Co…
ONBAR Difference
Hi All Whats the difference between onbar -b -w and onbar -b -w -L 0 I think they both do the same thing ... The manual dosnt really clarify it. thanks…
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log 27225 - …
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log…
Re: ONBAR backup with only 1 tape drive.
Hi, we do not recommend such a setup. Therefore I never really tried such thing and can't say for sure whether or how it would work, but here are some ideas for a start: Probably you need to define in the storage manager that both pools go to the same media. Alternatively (or …
Re: ONBAR backup with only 1 tape drive.
Hi, we do not recommend such a setup. Therefore I never really tried such thing and can't say for sure whether or how it would work, but here are some ideas for a start: Probably you need to define in the storage manager that both pools go to the same media. Alternatively (or …
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: Restoring a level-1 backup at a later date?
No, Logical backup is backup the logical logs and all the blobs that where changed. So backup & restoring logical logs support blobs even though they are not written to the logical logs Uri -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-lis…
Onbar with 9.30
On a Windows 2000 Server. While performing a level 0 backup with onbar, = process appears to be hung. What is the process for shutting down the = onbar backup and restarting it? System was in quiescent mode when onbar = was started but was later brought on line. Onbar log indicat…
RE: Restoring a level-1 backup at a later date?
Not really. With ON-Bar the primary source of information about restorable objects is indeed the ixbar-file. (A secondary source, but only used for log files, is the storage manager itself.) The basic assumption is, that you want to restore objects that are available at the time …
Restoring a level-1 backup at a later date?
Actually, I buggered up the timing calculations <fx:chagrin>. What I meant is that if we do a level-0 on the Friday night after the last user logs off then restore this to the new box this means the users are off for 7 hours for the backup and then 12 hours for the restore to the…
OnBar & ISM
I am currently running On-Archive and am looking to migrate to OnBar & ISM. All the comments about On-Archive suggest it ought to be avoided at all cost as it is far too complicated but it has been set up here and works like a treat. With On-Archive the backup command issued co…
Restore from Level 0 Backup
With ontape, yes; with onbar, yes if you did a whole system backup, no if you used a parallel backup strategy. Take care. Clifton pamadeo@cespi.unlp.edu.ar wrote: Hi, in IDS9.21, is possible restore from backup without restore logs. When recovery starting, the process ask you …
Restoring a dbspace and what of the transactions.
vavavoom_th14@yahoo.co.uk (Traveller2003) wrote in message news:<6e21e513.0411100242.18093bc0@posting.google.com>... > Hi All , > > Informix 9.4UC4 > Solaris 8 > Onbar > Tivoli Storage Manager > > If I do a Full System Backup the night before and all the subsequent > logical logs…
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)?…
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 …
ontape forma
Hello list. Does anybody know the format of an "ontape" backup? Can it be copied to another media and still be used for a restore? To be precise: we have an ontape backup on DDS3 format but we need DDS2 . Thanks Henk sending to informix-list…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Pool Names ISMData & ISMLogs Not Created
It turns out that because we did not have the Korne shell installed on our machine, ism_startup -init wasn't working properly Many thanks to Savio for his suggestions though. "Savio Pinto (s)" <spinto@cap.org> wrote in message news:cg2okq$4eb$1@news.xmission.com... > > few year…
RE: Pool Names ISMData & ISMLogs Not Created
few years back, when i was backing up the database using ISM, i used to do the following, hope it helps 1. make sure there are no nsr processes running 2. initialize the ism using $INFORMIXDIR/bin/ism_startup -init 3. add informix as the admin user, $INFORMIXDIR/bin/ism_add -adm…
Query on informix backup strategy
It depends what type of backup you are doing. With level-0 backup, there should be any problem. In case of incremental backup, it is recommended not to mix onbar and ontape. There may not be any issue with incremental backup too. But you cannot mix level-0 backup from one backup …
Pool Names ISMData & ISMLogs Not Created
Hi, I am trying to set up ISM on Informix 9.3 and I believe the pool names ISMData and ISMLogs are not being created when I run ism_startup -init. Could anyone tell me how to fix this problem? The steps I followed to setup ISM are as follows: Initialise ISM: ism_startup -…
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…
Re: Testing backups ...
Dirk, You should test your backups, however your resources may not permit it on the system your concerned with... it's a tough sell to get the disk to restore a large DB. However if you use a storage mgr for multiple systems/databases. Do a test restore on a smaller system, one…
ONBar Restores and Tivoli Storage Manager
I am having problems with restores from ONBar via Tivoli Storage Manager (TSM). I can perform backups that complete fine according to the logs, and the verification using "onbar -v" reports successful with no errors. However when I go to attempt a restore, I get one of two situa…
Re: Testing backups ...
Yes I think you should - preferably on a TEST system of similar configuration. Document your results. I also think we should routinely check HA and DR initiatives but quite often I'm told I live in a dream world. I have a current situation (I'm the new guy so no throwing stone…
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…
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…
problem restauration ONBAR
hi all; i have a problem with ONBAR . i installed ONBAR with server ISM. when i run restauration the procedure take about 10 H for 20Go of data. have you a solution for this problem . thinks and have nice week-end.…
onbar performance
IDS 7.31.UD5 and 7.31.UC6 on SCO UnixWare 7.1.1 Can any of you give me an indication of speeds writing to disk and tape with onbar? I have onbar working ok, backing up and restoring without any problems, but it seems a little on the slow side. Backing up to tape is reporting a…
onbar error message
Hello! I have an Informix backup configured as an onbar + Legato Networker combination with IDS 9.40 UC3 on Solaris 9 machine. We take dbspace backups every night and continously backup logical logs using log_full.sh script. All works well except one thing: if logical logs start …
are these backups the same?
Are the following two backup types the same where the IDS is in logged mode but "LTAPEDEV=/dev/null" and "ALARMPROGRAM=/..../log_full.sh" ? And we don't want to backup logical logs. 1) onbar -b -w -L 0 2)onbar -b -L 0 Thanks…
Database Restore Error
Dear All, I was restoring an ontape backup of 7.31 ver and got the following errors. 1) In online.log file Aborting physical restore of ROOT DBSpace Aborted by client. Informix Dynamic Server Stopped. 2) On the Console: physical restore failed function archive backup failed c…
onbar backup logical logs
Hi All, I am using onbar to backup my informix 7.31 databases with Legato networker. I dont want to backup my logical logs. Before using onbar, with ontape, I backed up my logical logs to /dev/null. How can I do that with onbar and Legato networker. Thanks for any help ______…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Logical Log Backup Informix 9.4 linux
I have one question: I am runnig async HDR. If a logical Log is full, it normally alarmscript ist called and it is backuped. Know I see, that sometimes after log file change alarm script is not called, online.log says logical log is finished. A little while later, someteimes a…
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…
Re: The old raw devices chestnut.
"Andrew Hamm" <ahamm@mail.com> wrote in message news:c5i8fl$22chf$1@ID-79573.news.uni-berlin.de... > OK - so you are talking about SQL-Server and various issues related to a > backup tool you use? Yes, standard backup tools. > If so, we have no argument; I know nothing of your…
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,…
OnBar Question
Hi Is it possible to restore a single database using onbar or is it the complete instance ?…
onbar script for logical logs
Anyone have a script to perform continuous logging using onbar to filesystems? I would like to write to a separate file on disk daily. Thanks for any help in advance.…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
ISM on Aix
I am currently using TSM and a 3583 library to backup informix using onbar - I am trying to somplify the situation and am going to use ISM and backup to file space on a local SSA array and clone my backups to tape during the day onto an external 3580 LTO2 drive. Another setup I h…
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…
Onbar without ISM
can informix back'ed up using ONBAR without install ISM?…
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: Logical log backup on XPS
Ontape utility does'nt come along with XPS. We have to use onbar. But we need to do a bit of configuration for the same.(as mentioned by Murali). Else we can set LOG_BACKUP_MODE to NONE. Another problem was that I had just 6 logical logs with 1 mb each, which was too less. I rei…
Logical log backup on XPS
Hi All, We have XPS 8.40 installed on HP UX 11i. Ther server was initialised and we were trying to load data into a table . Now the server is in Blocked state and the online.log file mentions that we need to take logical log back. Pls let us know the process for taking logical …
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
ontape/onbar
Hi, we are proud owners of two aix pseries. On each server we have one online system with 25 databases. We use ontape (Level 0) to save the online system, but we have the problem that we can't restore one special database. Anybody better experiences, may be with onbar? Thanks f…
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…
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.…
Waiting for next logical log file to be freed
Hi all, IDS - 7.31UC2-X6 OS - Solaris 2.7 (x86 platform) Recently my database engine was halted and the online.log shown as below. Has anyone come accross of this warning message? If yes, how does it happen and what is the resolution? 05:58:43 Logical Log 17386 Complete. 05:58…
Waiting for next logical log file to be freed
Hi all, IDS - 7.31UC2-X6 OS - Solaris 2.7 (x86 platform) Recently my database engine was halted and the online.log shown as below. Has anyone come accross of this warning message? If yes, how does it happen and what is the resolution? 05:58:43 Logical Log 17386 Complete. 05:5…
Re: ISM Startup Errors
Hey, Thanks for your input. I started ISM without -init. It seemed fine. When I try to take a backup, nothing happens. This ithe ISA output ------------------------------------------------------------------ 55638 2003-10-29 10:01:09 Successfully connected to Storage Manage…
I want to re-backup logs again. Can I reset is_backed_up flag?
Hi all, Our tape died. Logs that were saved to it are lost. I want to do an onbar -b -l again, but as the logs have been saved already, nothing is backup. Can I set the "is_backed_up" field to 0 in "syslogs" table of "systmaster" so that onbar will backup the logs again ?? Than…
Onbar
Is it suggested to use ISM bundled with the IDS installation to perform on-bar backups?…
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…
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-…
onbar
Starting to test onbar backups and restores. I have an issue that I hope someone can point me in the right direction. IDS 9.21.UC5 Sun 2.8 I can successfully do a whole backup and Cold restore. Everything seem to be working fine. However, when I do a point in time recovery the in…
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 ?…
Problems with onbar
I have IDS 7.3 uc2 on SCO 5.05 and use onbar for backups. I am getting the error below in the root mail .. Informix Storage Manager Savegroup: (alert) ISMData completed, 1 client(s) (sage Failed) Start time: Mon Aug 04 09:26:16 2003 End time: Mon Aug 04 09:26:23 2003 --…
onbar hangs
IDS 9.21.UC4 Solaris 2.6 EDS takes our backup using onbar. What we have observed is that, quite frequently onbar hangs. By hangs it means, onbar processes keep running indefinitely. Since the backup is taken daily, all subsequent backups also hang until the earlier on is killed.…
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…
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…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
backuping logical logs via onbar
Dear All. Thanks for your reply for my last message. I try to backup logical logs using onbar. On the SCO Open server 5.0.6 and IDS 7.31 UC5-2. I have configured ISM (nsr). When i had being attached devices via ism_op, storadge pools wasn't created. I created ISMDiskData and IS…
Re: Multiple instances and ISM
No ;) You can have many instances using the same pools within one Storage Manager. The pools just represent where to shove the data / logs. The unique ids returned from the storage manager and placed in the ixbar.servernum are how a restore identifies what objects are needed. …
Onbar and ISM
The Informix FAQ includes the following statement by Clem Akins:- On 27th Feb 1998 clem@informix.com (Clem Akins) wrote :- The Informix Dynamic Server v 7.3 (no longer called OnLine) will have a version of Legato's NetWorker Server product bundled. This product has an interface c…
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…
Re: backup onbar
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bc5ct1$fn3tr$2@ID-64669.news.dfncis.de... > David Williams wrote: > > > > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > > news:bc52r5$fk9nk$2@ID-64669.news.dfncis.de... > >> DBA-BABY wrote: > >> > >>…
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.…
onbar clones
I'm stumbling my way through setting up onbar and everything is good except for cloning the database archive I backed up to disk onto a tape. Logs are going to 1 tape drive and the database is going to disk. Perhaps what I'm trying to do is not even possible, but I want to stor…
onbar clones
I'm stumbling my way through setting up onbar and everything is good = except for cloning the database archive I backed up to disk onto a tape. Logs are going to 1 tape drive and the database is going to disk. Perhaps what I'm trying to do is not even possible, but I want to st…
Onbar Error
Hi, Could anyone let me know, what this error related to onbar means: #define BAR_AAPI_ERROR 0x83 /* archive api failed */ The Onbar exited with return code of 131 as stated above. Informix: 9.30.UC3 and Veritas: 3.4 Version. Thanks again. Venkatesh Konnur…
Onbar Error
Hi, Could anyone let me know, what this error related to onbar means: #define BAR_AAPI_ERROR 0x83 /* archive api failed */ The Onbar exited with return code of 131 as stated above. Informix: 9.30.UC3 and Veritas: 3.4 Version. Thanks again. Venkatesh Konnur…
RE:informix log backups
HI, =20 I have a particular question about transaction logs which get backed up using ontape. =20 I know that you can do a... =20 Physical backup & restore (which is a backup/restore of a dbspace(s) or blobspace(s) Logical backup & restore (which is a backup/restore of a l…
reg: configuration of ONBAR
Hi, [ I guess you mean ISM (Informix Storage Manager) and not ISAM (Index Sequential Access Method) ... ? ] OK. ISM needs a minimum setup which for testing purposes I usually do with a script like the following : ism_startup -init ism_add -admin informix@onbarfix ism_add -d…
dataprotector + onbar
Hi all Does anybody use Dataprotector 5.0 ( Omniback - HP) with Informix 7.31 ? I use Dataprotector 5.0 , HP-UX 11.11 and Informix 7.31FD5 I would like to know how to do only Physical restore ( onbar -r -p -w ) using Dataprotector . I am asking because in Dataprotector I only c…
Onbar -restart
Hi, I try to do an onbar -restart to restart a backup. In the online.XXX.YYY.log file, I get this message : shmget: [EEXIST][17]: key 52584801: shared memory already exists in the bar_XXX.log file, i get this error : 2003-01-29 15:55:34 16033 16010 Process 16033 received sign…
Re: Logical-log backup
----- Original Message ----- From: Woi Yew Fong <yfwoi@tpl.com.sg> To: <informix-list@iiug.org> Sent: Tuesday, January 30, 2001 9:40 AM Subject: Logical-log backup > > Hi there, > > I am confused with the automatic logical-log backup (with ontape -a) and > > continues logical-l…
Logical-log backup
> Hi there, > I am confused with the automatic logical-log backup (with ontape -a) and > continues logical-log file backup (with ontape -c). Can somebody clarify > the doubt for me. > > 1. Does automatic logical-log backup mean an operator need to execute the > command ontape -a…
RE: onbar restore to another host
Make sure the name of the instances are the same (eg. if you backed up instance prod1, then you need to restore to an instance named prod1). Copy the ixbar.X file relating to the primary instance from the original machine to the restore machine. The server number can be diffe…
HELP URGENT: Level 0 backup from system A (Solaris) to be restored to System B (SCO UNIX) - IS THIS POSSIBLE???!!!
Is there a way for a level-0 backup from a Solaris 2.5 Informix Online 7.x backup to be restored to an informix 7.0 instance running on SCO Openserver 3.0. We need to test the backup of System A to another place so we can perform some system upgrades confident that our backups a…
ONBAR
Hi All, Can you tell me please how to start backup using Onbar? Before I run the command "onbar -b", I suppose to set up onconfig and ISM. Is it right? I did it based on the Informix Backup and Recovery Book, but in several parts it doesn't explain clearly, like they ask to start…
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…
Which Informix software to restore a database?
Hi all, I'm using ontape command to do backup our Informix server everynight but the Informix's ontape command only allows to restore the whole Informix engine or dbspaces. I'm looking for Informix backup software which allows to restore a single database of Informix Server. 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 …
onbar with Tivoli data Protection for informix
Hello , Does anyone know a way to use onbar to backup the database with tivoli tsm Tivoli Data Protection version 4.1? Thanks, wdd…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Onbar & Logical Logs backup
We are using IDS 7.31 UC6 with Sun E10K Solaris V 2.7 We set up onbar using Veritas Netbackup, which we use successfully on many other machines. However, we are running into a problem that I cannot find the answer to (I'm a newbie). I've looked in all the Informix docs that I h…
Re: ON-Bar Logical Logs to Disk
you can define a device in your storage manager as a filesystem and set your log pool to use that device only. however no matter WHAT you do, you will always need a storage manager and therefore if your storage manager fails, your entire backup solution fails. we have 2 storage…
Informix error 1502 running onbar from crontab
Is there any trick to running onbar from cron? I have a Sun E3500 with sun unix version 7. When I type at a command line /informix/bin/onbar -b -L0 that works just fine. However, when I schedule it in cron I get an error 1502 - message 1502 not found. Any ideas? Thanks Paul J…
RE: OnBar script needed for NetBackup
Jason, It should be possible to just replace your 'ontape -r' command in the cron script with an 'onbar -r' command. You don't HAVE to schedule the restore through the Storage Manager. Of course, you have to copy the ixbar.0, onconfig, and oncfg.... files from production to do…
RE: OnBar script needed for NetBackup
I use OnBar from the command line, without regard for the storage manager.� How�hard is 'onbar -r'? � Why would you want to use cron to restore??? � Setting up Netbackup is relatively simple with OnBar.� The Netbackup manuals explain it well. � Doug -----Original Message----- Fr…
OnBar script needed for NetBackup
Hi all, Recently, there's a lot of comments on the OnBar & OnTape command. But I can't find the info that I needed. My company is plan to use Netbackup and I'm totally have no idea on the OnBar command. According to my vendor, Netbackup has no scheduler to handle the restore ope…
OnBar/OnTape
To expand on Fred's reply vis-a-vis OnBar.. OnBar does see all the backups as being in "one place". It is the responsibility of the storage manager software (ISM, Legato Networker, Veritas NetBackup, Tivoli Storage Manager, etc.) to place the data on the media and keep track of…
Remote ontape backup/restore
Does anybody know how I can do an ontape backup/restore using a tape drive on a remote server? Thanks in advance, John.…
OnBar unsing on NT not as Informix user
Do you know how can I configure Informix 7.30TC7 to run onBar as a simple user/NT admin? Andor Rozsnyai GE Medical Systems Hungary Software Developer…
Re: ontape and onbar
Andy, ontape and onbar are not interchangeable. Once you go to one method you have to use it to do both level 0/1/2's as well as logical logs. If you want to switch to onbar, you have to discontinue your use of ontape and use onbar to do your level 0's and logical logs. We use…
ontape and onbar
Hi Everyone How can I switch continous logical log backup from ontape to onbar? I first used ontape -c to enable continous logical log backup. Then I setup ism and want to do continous logical log backup through onbar. How can I disable from ontape and enable it using onar -l…
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…
onbar onarchive or ontape which one??
onbar onarchive or ontape. Which one should we use for backups? We use IDS 7.30 UC2 Thanks, Isaac…
Logbackup failed - A Log backup is already in progress
I can't run my logical log backup because it comes back with the following message: "Logbackup failed - A Log backup is already in progress". when you run onstat -g ath | grep log, there are two threads runnings and they are: aslogflush and logbackup. How do I get rid of logback…
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.…
Backup to HP SureStore 2/20 (DLT8000)
Does Informix backup tools support this device on a HP L1000? onachive, ontape, onbar? Thank you, Jens…
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…
onbar
I have 2 instances I need to back up through onbar, and I'm wondering how many tape drives I need. They are both very small, about 1GB a piece, and should easily fit on the 4 GB dat drive I have. Of course I'm going to want the logs backed up too. I'm using onbar so that the w…
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…
No Rewind devices for Onbar on AIX
I am currently implementing Onbar on AIX 4.3.2. I have been using a no-rewind special device name (/dev/rmt0.1) to send output to. Onbar doesn't ever seem to find the end of the tape! Could someone using AIX and Onbar to tape share the device they are specifying? TIA Dave Th…
Logical logs?
"Josep M. Marti" <soft@gic.es> schrieb im Newsbeitrag news:395C69BD.8A58C80C@gic.es... > Hi all, > I have a problem with the logical log. I need to add more logical logs > becouse I can't run any proces, but the logical logs need memory space > or disk space? If I put a lot of lo…
Onbar, ADSM, and logical logs
We use OnBar and ADSM. When OnBar backs up logical logs ADSM uses the "uniqid" value as the low-level file name. The ADSM Policy Domain has been configured to keep three generations of a file so the standard OnBar backups of root and dbspaces cycle through and expire automatica…
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…
ontape
When using ontape as the backup and restore mechanism can the database be restored to a previous backup or can you only restore to your latest archive?? Keith A. Lewis The Timken Company lewis@timken.com (330) 471-4119 (330) 471-4034 (FAX)…
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…
onbar??
I noticed a bar_act.log file in our /tmp directory today...inside it had a lot of entries like this for different times during the day over a period of the last two months... 2000-05-19 10:11:00 25698 25697 /usr/informix/bin/onbar_d -l 2000-05-19 10:11:01 25698 25697 WARNING…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Can Ontape restore a database?
Hi all, I run ontape level 0 backup every night but I feel stuck in restoring a single database of the IDS 7.30UC2. Does someone know an Informix Backup software which allows me to restore a single database as need it? Thanks in advance for any advise. H.V…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Logical logs backup ?
This is a multi-part message in MIME format. --------------FEDFDA7504E0243819936D4C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------FEDFDA7504E0243819936D4C Content-Type: message/rfc822 Content-Transfer-Encoding: 7bit Content-Disposition:…
RE: Problems with logical log backup
What are your $ONCONFIG (BAR_*) parameters for onbar? The bar_act.log message implies that you have configured it for over 9677 concurrent backup threads. This would require large amounts of storage for that much concurrent activity. Did any corresponding error messages appear …
Problems with logical log backup
We have a Informix 7.31 FC2 Instance in HP-UX 11.0. We run backups with OmniBack 3.1. Logical log backups starts with log_full.sh - script. Now we have problems in backups when system is in heavy use. Backups starts normally but after a few seconds they are aborting. In the eveni…
onbar and Netbackup
Hi, i'm now using NetBackup, STK 9730 tape array and onbar to backup our database, but i encounter a problem that: How can i tell onbar which backup to be restored from STK tape array, by "onbar -r -t" option? or NetBackup can tell us? Thanks! Chen…
Logical logs backup to null
Hi, Can you suggest me script which can takelogical logs backup on /dev/null automatically when 75% of logs are full. Regards, Basaiah Basaiah Hiremath…
Changing logging mode with onbar, is it possible?
I must be missing something. With ontape I can change the logging mode of a database. Now that we have switched to onbar (using adsm) I can't see the way to accomplish this with onbar. It talks about a "fake" backup, but I don't see the -A, -U, -B equivalents. Suggestions?…
Who can make backups using onbar
Can another user besides root or informix use onbar to make backups. We are new to the onbar world and have very little knowledge of what works and what doesnt within onbar. Everytime we backup our instance using onbar, following error is recorded in onbar's log file: 2000-02-1…
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…
On-line vs Off-line Backups
Sean Kelsey wrote: > I can't even believe I'm posting this, but I've exhausted all my arguments > for performing on-line backups over off-line backups specifically within a > 24 x 7 x 365 operation. Namely, > > On-Line Backups > > Pro's > > 1. The database backup will be consist…
failed to backup logical logs
Dear IDS users, Recently I installed IDS 7.31 on Windows NT 4.0 SP 5 . I am able to create a database; next I tried with DBimport to load databases. Soon the logical logfiles are full and therefore the server is blocked during taking a checkpoint. I tried to backup the logical l…
Logical Log Backup Errors
I get the following error often. It appears to be associated with a Logical Log backup done automatically when the Log becomes full. I am currently redirecting all Logical Log backups to /dev/null, because I have not had a chance to set up my backup methods yet. Can anyone tell …
anyone good experience with IDS 7.30.TC9 on NT 4.0 ?
Hi, we upgrated Dynamic Server 7.23.TC2 to 7.30.TC9 in Dec 1999. We have some major problems. 1. onbar didn't work: NT-Error Message: Entry point "ca_hardlink_path_addr_func" in Library LIBNSR.DLL couldn't be found. Because we installed some days ago ArcServeIT as StorageManage…
Onbar
Hi ! We are using Omniback for Logical log backup. We have had many drive failures. I've been thinking if there would be some onbar parameter that logical log backup is done after 10 full logs ???. -Jukka…
Re: IECC problems with IDS Workgroup on NT
On Mon, 13 Dec 1999 10:04:02 +0100, Alain Mouligeaux <Alain.Mouligeaux@irislink.com> wrote: >2) Onbar problem: >when starting the Onbar utility for a complete backup, I have the >following message: "onbar-d.exe Entry point not found The Procedure >Entry Point ca_hardlink_path_ad…
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…
Help: Ontape Warm Restore
Also sprach "Bashar Chalabi" <bashar@ctl.com> : :Hello, : :IDS7.31 on NT4. : :I am trying to do a warm restore using ontape. I first do a cold restore :(not all DBSpaces), which works fine. I then bring the server online, and do :a warm restore of the remaining DBSpaces. After t…
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…
Informix Backup with Omniback 3.1
We restore our Informix 7.31 database with Omniback 3.1. What is the right way to do full backups every night. When configuring Informix backup to Omniback, you must choose several options. Omniback manual says that "to select a whole system backup, click Backup all DbSpaces and …
Re: Confirm backups
From: "Tony Costa" <tcosta@bellatlantic.net> > >I am a bit concerned that the ontape -s backups I am running are infact >good >backups. How can a backup be confirmed to be a quality restorable backup? Restore it? :-) Archecker? __________________________________________________…
Confirm backups
I am a bit concerned that the ontape -s backups I am running are infact good backups. How can a backup be confirmed to be a quality restorable backup? -- tony.costa@usa.net "Every man dies, but not every man really ever lives" -Mel Gibson as William Wallace…
use of ISM and ONBar
This article should guide you in setting up ISM with onbar. In order to get IECC to work, you might need to install and start the serveragent on the Unixware box. --Anil Tech Info Article Title: INFORMIX STORAGE MANAGER (ISM) 7.3 INSTALL/CONFIGURATION The following is an e…
Restoring backup on other system
Yes it is possible. I have done this successfully on a UNIX system with onbar and networker. But there was some steps to do before the restore. INF-ONL 7.24; Reliant UNIX V5.43; Networker V4.? 0, scan (networker) the backup tapes on the restore system. Maybe you have to add the…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
help on OLW 7.12
Hello all, I am now using informix online workgroup server 7.12. The command center prompt me that 'Logical Log Full - backup is needed' and so i go to logical backup. But I found that I cannot backup the logical log. The 'Logical Log backup is in process....' just showing on th…
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…
Backup of logical log to file?
How do I set LTAPEDEV in onconfigure.ifmx in order to direct ontape to backup logical logs to files instead of a tape station? --Patrik…
move dbspace/chunks on NT
Is there any way other than backup/restore to move a chunk on NT to another disk. Can I move the root dbspace this way? TIA,…
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…
ontape -c
When using 'ontape -c', for continuos backup of logical logs, what is the proper way to terminate the command? Is it simply a CTRL-C?…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
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…
Tape drive or No tape drive ?
Currently, we do not have a tape drive installed. Our setting in the onconfig is LTAPEDEV /dev/null. What are the implications of these ? I have read that the transactions are recorded in the logical logs. Now that the logical logs are backup to /dev/null, what would hap…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Re: How to do disk slicing on Sun stroEdge A3500 Boxes
--- "Art S. Kagel" <kagel@bloomberg.net> wrote: > sanjeev sagar wrote: > > > > SINGLE E10000 with 7 A3500 storage array which has > 14 internal > > controller and 24 GB RAM over 6 coserver. > > In other words have you divided the E10000 into six > separate CPU Domains > treating …
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…
Onbar using ADSM as storage manager
Does anyone out there have any experience or comments on the choice of ADSM as the storage manager used by OnBar?…
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…
ontape
Well.... You ONLY performed a level 0 backup so you CANNOT restore a level 1 backup because you do not have any level 1 backup that corresponds to the level 0 you have already restored. So? So reply 'n' no 'y'! Art S. Kagel Andreas Lommel wrote: > > Hi > I backuped my system …
Check onbar process
Hi! We are facing a problem saving our logical logs using log_full.sh. Some of our production systems run Informix 7.24, others 7.31. We use the following line, to check whether a logical log backup runs already (starting onbar -l twice leads occasionally to a hang of the first…
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.…
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: Log Files Full
Increase the size of your logical logs, by adding more of them. By default they are not big enough. And if you don't care about your logs then set your backup device to the null device. And you need never do logs backups again. > To avoid getting this message, you could use ont…
Log Files Full
Error message: Logical Log Files are Full -- Backup is Needed Can anyone help me? Thanks in advance, Joao…
Backing up tables or complete databases ?
Hello, Is it possible to make a backup from a table in one database to another (backup)database (by VB sourcecode) and restore earlier made backups ? Can I even make a backup of the complete database and also restore it by using VB-code ? I like to make an button which the use…
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…
Re: Replication!!
Dear sir. Thanks you very much! We will try your recommendations. We have 300 logical logs now for each 2MB size and we use continus logical log backup and the other are all same as your recommendations.…
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…
Re: ISM on Informix 7.3UC8
Benny, ism installation is pretty straightforward and extremely simple if you go by the article attached below....I suggest you remove the following two directories /nsr and $INFORMIXDIR/ism and start from scratch with an ism_startup -init...;-)...if you yet have problems post th…
ONBAR and SYSUTILS
Has anyone found/developed tools for managing (i.e. purging and synchronizing with ONBAR) the sysutils database when using onbar/adsm? Walker…
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.…
onbar and logical log backup to disk
Hi I am using onbar with omniback for backup. I would like to backup my logical logs to disk instead of tape. I would need to backup logical logs every hour or ad-hoc using log_full.sh. My retention period on disk is 4 days. I don't want to c…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Re: Same tape device for Logical Logs & Instance/Unix backup
> I'm planning to backup logical logs on one cassette in the days (with > ontape -s -U database1 database2 ....every morning with LTAPEDEV set to tape > device) This does not back up the logical logs. This archives the whole instance and sets the database1 and database2 to unbu…
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…
Posting from the Informix-list
Hi, For several customers I'm implementing Informix databases under NT4.0. The customers have DLT tape units and are now using ontape. We are thinking on using on bar. The problem is that we don't want to claim te tape -unit all of the time. Therefore I have a few questions. 1.…
Automatic Backup on NT
Hi, For several customers I'm implementing Informix databases under NT4.0. The customers have DLT tape units and are now using ontape. We are thinking on using on bar. The problem is that we don't want to claim te tape -unit all of the time. Therefore I have a few questions. 1.…
Re: Onbar and storage pools
When using ADSM, you define two management classes, with different storage pools on the ADSM side. Then, in the include file, you specify the databases (normally of the form /$INFORMIXSERVER/$INFORMIXSERVER/*/0) and list one management class. And specify the logs (of the form /…
Onbar and storage pools
Hi, I was wondering if it is possible to configure onbar to use different storage pools for data and logical logs when using onbar with ADSM (or anything else but ISM). The parameters ISM_DATA_POOL and ISM_LOG_POOL in the onconfig file certainly look like ISM specific. How does …
OnBar Parameter BAR_NB_XPORT_COUNT
The documentation is a little unclear on BAR_NB_XPORT_COUNT. Are these data buffers within the DB server or within the OnBar region? I assume these buffers are the same size as the database pages. What are some of you with good OnBar performance using as a value?? TIA Doug A…
onbar question
I am a little confused regarding the difference between a whole-system backup and a dbspace backup which backs up all dbspaces. If all my disks get blown away, can I use my dbspace backup (all dbspaces) to rebuild the database, or must I have a whole-system backup to recover? Th…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: Problem with onbar using Networker 5.1 on Solaris
manaloe@comcell.com wrote in message <7c3h8v$iae$1@nnrp1.dejanews.com>... SNIP---- >I implemented a whole system backup with onbar (onbar -b -w) - no logical logs >backup. Logical logs is pointed to /dev/null. SNIP--- WHY NO LOGICAL LOG BACKUP??????? If you do logical log backup…
logical logs full - server unavailable
I'm working with Informix Workgroup Server 7.22 on WinNT 4.0 SR3. After deleting several thousand rows from a table, i got the error: logical logs are full, please make a backup of logical log files. When i look at the server, the informix-server is down and unavailable. So i can…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
onbar performance and restore
Ihave problem with onbar performance. It takes more than 2 hours to backup all database using onbar -b -w. Therefore I use onbar -b <all dbspaces list> to back up dbspaces parallely. It is fast. However there is a problem restoring database from above backup up to the poit in…
Eliminating Onbar archive history
Does anyone have a process in place to eliminate rows from the sysutils tables based on keeping a set number of onbar database backups (say, 3) and identifying/eliminating unneeded database backups and log backups?? Trying to set up SIMPLE procedures for using Onbar/ADSM. TIA …
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.…
onbar
Hello I use Informix 7.23 Workgroup server. Can I trust onbar to backup and restore my data and the database ? Thanks…
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…
Re: Logical Log Backups.
If you are using continuous backup(ontape -c) and it fills up, and you catch it in time(before the logical logs fill up), you can simply swap the tapes and you'll be fine after restarting the continuous backup. You would probably want to add some logical logs though. If you are …
Re: can't drop dbspace or chunk
Mike Edelstein wrote: > Hi, > I was trying as an experiment to restore a single non-critical > dbspace with online 7.22.uc3 and aix 4.2.1. This was a test > database using ontape with logical logs set to /dev/null. I did > an ontape -s -L 0 level 0 backup to tape. Then I tried…
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: Logical Log Backups.
Assuming you're using OnLine 7.x, you can customize the alarm program to send out an e-mail or page when the logical logs get close to full. A message automatically is generated by the engine when all but one of the log files are full. If you have an alarm program, it will proc…
RE: Logical Log Backups.
--openmail-part-01a70b72-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit Hi, What happens is the database engine hangs until the tape gets changed. We have had that happen a …
Logical Log Backups.
I'm having trouble finding a solution to a rather simple question. If you are backing up logical logs to tape, what happens when the tape fills up? Obviously you would not want to write over transactions. Do you need to guess how fast the tape will fill up and swap them out onc…
RE: Backup and Restore Question
SQL Bactrack (a product from BMC) provides the functionality of restoring a single table from the backups. We tried it and it actually worked. - Sri Chava -----Original Message----- From: -=Eclypse=- [mailto:eclypse@cdc.net] Sent: Tuesday, November 17, 1998 3:26 PM To: informix…
Backup and Restore Question
Is there a good plan with Informix (we use BaaN as our app) for backing up and restoring individual tables/dbspaces? I've mentioned this to a couple of people. When we set up our new server, we're going to create a larger number of individual dbspaces so that we can restore them …
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 …
onbar : error 329
Hi I am trying to restore two sets of dbspaces using onbar. I get the error 329 and 155 while trying to restore the second dbspaceset . Looks like I hit the foll bug : #96560 The followin senerio failes on step #2 with the error message below when trying to restore: 1. …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Backup of logical logs
Hi Bill It would help if you could give the following information - Backup device type (tape?) TAPEDEV from the onconfig file, and what follows, till the end of the LTAPEDEV section what the error code is as a temporary solution, set the TAPEDEV and LTAPEDEV parameters to NUL,…
Backup of logical logs
IIUG folks, HELP!!! I'm a new user of Informix Target NT (Dynamic Server 7.30) and am having problems backing up my )filled) logical logs. I have tried using the "Backup Logical Logs" option by right-clicking the database instance, but it returns an error code. Is there anoth…
I can't lose a single transaction, how 2 backup?
I set up a very important database and I wnat to protect myself against HD failure. Every day I make a level 0 backup and I start to perform backup of full logical logs. But what happen if my HD crash before the logical log fills? All the transaction inside the last-not-filled lo…
Re: Log backup on /dev/null
Hi Jean, As per your mail, your parameter value for LTAPEDEV is /dev/null, you cannot take a restore from /dev/null, no backup is done if you use this value for the LTAPEDEV, unless and otherwise you have a tape backup you cannot recover your logical logs after you have done…
Re: Restore to previous Zero level
There are two parts to this questions: 1. How to I get a previous archive to restore, onbar by default choose the most current? You will have to add into you restore command line a "-t <date/time just after the level 0>" If you do not …
Restore to previous Zero level
Hi, I'm using want to restore my informix database to the previous level zero backup. So for example I've done a level 0, some level 1's and another level zero backup. I now want to go backup to the first level zero backup. I'm using onbar to do both backups and restores and als…
Re: Onbar restore aborted - Help!
Hi! If you start onbar -r -w, onbar does the restore of your dbspaces first. If you look at your bar_act.log, you'll see, that the restore of your dbspaces was successfully completed. After this dbspace restore, onbar tries automatically to roll forward the instance to the actua…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Re: Onbar
I understand your confusion --- took me a while to work thru this error. You have to: 1. create a directory on your hard drive. 2. go to ISM and define a device of type file, and point it to the directory 3. then hilite the device in ISM and 'label' the "volume" as belonging…
Onbar
We face a problem for which we don't know the solution. We are using Informix Dynamic Server 7.30TC3 on a Win NT 4.0 computer. Whenever we try to use onbar -b -w -L 0 the Informix Storage Manager gives the following error message: media waiting event: bachup to pool 'ISMData' wa…
Appending to Informix backup
Hello. I need to append a NT4.0 backup on top of Informix database backup (using ontape ) tape. Does this override the existing informix backup. If not, will the ontape be able to know where to restore it's previous backup? TIA, Aik Khoon…
Appending to Informix backup
Hello. I need to append a NT4.0 backup on top of Informix database backup (using ontape ) tape. Does this override the existing informix backup. If not, will the ontape be able to know where to restore it's previous backup? TIA, Aik Khoon…
Re: Backup solution for Informix Dynamic Server NT
Reiner, Have you heard anything about the new Onbar utility that comes with v7.3 of IDS? I think that it is a GUI frontend that works with Legato. Cindy Rutherfurd DBA Printronix Irvine, CA…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
Re: Help on Onbar
Nicola Terenzi wrote: > > Hello, > when trying to use ONBAR from IECC client we are getting the following > error: > can't find /usr/lib/ibsad001.so. > Where can we get it ? Do we have to buy an additional backup software ? > We are using IDS 7.3 on Solaris 2.5.1 > What storage …
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…
Re: Backup & Restore
Mike Morris wrote: > > 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?) I don't see any need to do this - …
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…
free: Backup - Restore Seminar
This was posted with unlicensed software. Please encourage the user to register this software begin 644 seminar.html M/$A434P^#0H\\2$5!1#X-"B`@(#Q-151!($A45%`M15%5258](D-O;G1E;G0M M5'EP92(@0T].5$5.5#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B M/@T*("`@/$U%5$$@3D%-13TB1T5.15)!5$]2…
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: onbar and legato
Hi David I had similar problems about 6 weeks back with IUS 9.13, Informix were saying it was Legato and vice-versa, I now have it working, my problems centered around setting up the pools, label templates etc on the Legato server. Once these are done, there are many more enviro…
Free Backup and Restore Seminar!
Target Audience: IT, I/S and CIO professionals concerned with the backup and restoration of their mission critical data. Seminar Description: This Seminar will address a growing concern among IT professionals in the area of backup and restore and define EMC's highly automated E…
Free Backup & Restore Seminar!
Target Audience: IT, I/S and CIO professionals concerned with the backup and restoration of their mission critical data. Seminar Description: This Seminar will address a growing concern among IT professionals in the area of backup and restore and define EMC's highly automated E…
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…
Veritas Netbackup and onbar.
We are trying to do backup of Informix 7 using Netbackup and onbar. The backup works fine but the restore doesn't. If ANYBODY has restored something using NETBACKUP and onbar please email lsolomonik@hotmail.com !!! -----== Posted via Deja News, The Leader in Internet Discussion …
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…
ontape for logical log backup
is there a way to implement the backup of logical logs from a script using ontape? If you have such script, and it can be scheduled with cron, I would like to see it. Thank you zeida heavener broward county zheavener@co.broward.fl.us…
deadlock: logical log full
Hi I work with Infomix Online Server 7.12 on OS Windows NT 4.0. I got the error LOGICAL LOG IS FULL now I am in the deadlock situation, because I have to backup the logical log. This is not possible because the next logical log file is already used. all log files are flaged U (…
Re: onbar with 7.24
I ran into this same problem when I first tested OnBar. Yes, Informix changed the behavior of OnBar between 7.22 & 7.23. Under 7.22 it was up to the alarm program to do a 'onbar -l' after the 'onbar -b' completes (current log change). Under 7.23 and greater an 'onbar -b' autom…
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…
Ontape - Any way to verify if the level 0 backup is any good?
Hi there, Is there any way to tell if your level 0 backup (ontape -s) or continous backup ( ontape -c) is any good. Basically is there a way to verify the data is readable without restoring it. thanks, Pat Militzer pmilitzer@ultracom.com…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: ARCCHECKER
In article <6l96t2$hn9$1@news.xmission.com>, Clem Akins <clem@informix.com> writes > >At 08:29 AM 05-06-98 EDT, MS CARLEEN C AVANT wrote: >>Hi, >> Does anyone have any experience with the utility ARCCHECKER (not sure I >>have that spelled correctly) that verifies archive tapes, …
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: Informix Backups
In article <6jbp96$iv9$1@morse.news.easynet.net>, d.berry@ukonline.co.uk writes >Im new to this Informix lark, Im predominantly a Sybase DBA (Sorry!) What sort >of backup solution to most people use for Informix e.g. scripts running ontape >(any examples please!?) or do people us…
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…
Problem with logical log backup
I'm using the Online Workgroup Server for NT V7.22.TC1 (German version) and have a problem with the continuous log backup: since log buffer 10 the system fails with following onbar log messages: 1998-04-06 14:28:09 106 0 G:\\Informix\\bin\\onbar.exe -l 1998-04-06 14:28:10 106…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How to size the logical log ?
Hello Guys, Does anybody know how to calculate the size of the logical logs ? What does the logical log size based upon ? What are the factors ? I want to backup the logical logs very often to avoid disaster. How does informix backup logical logs ? …
Re: Network Computers from Oracle
On Wed, 1 Apr 1998 21:49:47 -0600, "John Smith" <abc@123.com> wrote: >Folks, > >I wanted to start a thread to talk about NC's. Am I dreaming or do I have >an 'NC' on my desk in the form of an X-Terminal? This product seems like a >joke to me, and I can't believe that it has an…
Re: What is the best way to backup logical logs ?
Timothy_Lam@crow.bmc.com wrote: > > Hello, > > What is the best way to backup logical logs to remote machine? > Should I kick it off when the logical log becomes full ? > Does anyone has any examples ? > > > What is the recommend size of logical logs ? Ho…
Re: Logical DBA needed
In article <6fcc4s$70o$1@news.xmission.com>, david.ashby@workcover.nsw.g ov.au writes > > > David, > > > You've got it wrong they don't make work for each other, they make > work for heaps of people. You forgot about the storage controller, > production scheduler,…
What is the best way to backup logical logs ?
Hello, What is the best way to backup logical logs to remote machine? Should I kick it off when the logical log becomes full ? Does anyone has any examples ? What is the recommend size of logical logs ? How do you calculate ? Rdgs Timothy…
Re[2]: Logical DBA needed
David, You've got it wrong they don't make work for each other, they make work for heaps of people. You forgot about the storage controller, production scheduler, change control manager, repository manager, and anyone else who wants to justify their exi…
ONBAR's use of XBSA
One of the software requirements for use of onbar is a shared library implementation of XBSA. Informix documentation does not elaborate on where said shared library can be obtained. Anyone out there running onbar on Solaris 2.5.1? Where did you obtain the shared library? -- Ma…
Re: continous backup on hard disk
>> Pascal Schaefer wrote.... >> I want to backup logical log on hard disk continously. I have created a program >> that periodically checks the size of the backup file. But what am I to do when >> the backup file is big enough for backup on tape? Do I loose data when I stop >> c…
continous backup on hard disk
I want to backup logical log on hard disk continously. I have created a program that periodically checks the size of the backup file. But what am I to do when the backup file is big enough for backup on tape? Do I loose data when I stop continous backup by killing the process for…
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…
Onbar -w option
Hello, I am working on online7.23.UC4/HP-UX 10.20. I am working on an onbar/Omniback II 2.10 backup solution and I don't understand what is the difference between onbar -b and onbar -b -w or between onbar -r and onbar -r -w. Can somebody explain to me what is the use of the -w…
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: backup logical-logs
Steve Leung wrote: > Hi, > > Wonder do people in real world actually backup logical logs? > Do they use "ontape -c"? What good is "ontape -a"? > Are third-party backup/restore software popular in Informix > community? Which are the winners? > > Please share your experience. > > …
Logical-log backup strategy
Hello. I'd like to backup my logical logs to disk. I'm thinking of using ontape for backups and it also looks desirable to do continuous logical-log backups. Is continuous backup to disk doable? Would it be better to just mirror the volume where the backup files would go? Th…
Re: backup logical-logs
In article <34D6E227.377F1C07@informix.com>, Mark D. Stock <mdstock@informix.com> writes >Steve Leung wrote: >> >> Hi, >> >> Wonder do people in real world actually backup logical logs? > >Of course! That's the whole point of using transactions; so you can >recover back to the po…
Re: backup logical-logs
Steve Leung wrote: > > Hi, > > Wonder do people in real world actually backup logical logs? Of course! That's the whole point of using transactions; so you can recover back to the point of the failure. > Do they use "ontape -c"? What good is "ontape -a"? They use both. Use OnT…
Re: backup logical-logs
Neil Truby wrote in message <34D632EE.AAE@netcomuk.co.uk>... >Steve Leung wrote: >> >> Hi, >> >> Wonder do people in real world actually backup logical logs? Yes. >> Do they use "ontape -c"? What good is "ontape -a"? "ontape -a" will work fine as long as you are sure that you…
Re: backup logical-logs
We backup logical logs 5 times a day. There seems to be a really good reason for doing this -- if you want your database to continue to run, which it won't if the logical logs all fill up. We ue a script that executes ontape -a ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~…
Re: backup logical-logs
Steve Leung wrote: > > Hi, > > Wonder do people in real world actually backup logical logs? > Do they use "ontape -c"? What good is "ontape -a"? > Are third-party backup/restore software popular in Informix > community? Which are the winners? > > Please share your experience. > >…
backup logical-logs
Hi, Wonder do people in real world actually backup logical logs? Do they use "ontape -c"? What good is "ontape -a"? Are third-party backup/restore software popular in Informix community? Which are the winners? Please share your experience. /steveleung…
Restore ONBAR backup to a different host using ADSM
I am attempting to back up using ONBAR and ADSM. I have gotten ONBAR to backup the database. Now I need to restore the database on a different informix server so that I can start replication. Can someone please give me the steps to retore the database to another server? I appreci…
Re: IDS (IUS) backup and recovery??
In article <grimes.886024850@access2>, Seth Grimes <grimes@access2.digex.net> writes >Anyone have opinions to share on use of ON-Tape vs. ON-Archive for >Informix-Dynamic Server (9.12, Solaris) backup and recovery? I haven't >worked much with the Online 7.x versions of these uti…
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…
Legato dbmi (db backup module Informix) - onbar
Config: Solaris 2.5.1 Sun 4000e Informix 723.uc4 Solstice Backup (Legato 4.2.6) which uses onbar ($5K+ add on module) I occasionally get the following online.log message: 01:31:05 Checkpoint Completed: duration was 0 seconds. 01:32:24 Logical Log 1594 - Backup Started 01:32:…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
logical logs
Hi I am running Online 7.23 on HP 10.20 Why was logical log backed up every 2-3 minutes? Is there any hint not to make that backup too fast? Here is the info... 11:07:08 Logical Log 608 Complete. 11:07:09 Process exited with return code 133: /bin/sh /bin/sh -c /usr/informix/…
Logical log backup - Why!?
I understand that the logical logs must be backed up consistently in order to be freed, but why would I need to back them up otherwise? If I did a Level 0 backup once per week and then a Level 1 every other weekday wouldn't that be sufficient? We're not a mission-critical, 24ho…
RE: Backup/Restore times
I have been experiencing a strange problem with backup and restores using ontape and onbar on my HP box. I have a small test database of 300Mb on a HPUX 10.20 box running 7.23 of Informix. I can backup the database in 5 mins but it takes 23 min to complete physical recovery and…
Logical log backup problem
Hello, I'm attempting to back up my logical logs, using ontape, and I'm coming across a few problems. We've had ODS7.23 up and running for a while and, regrettably, didn't realize we needed to back the things up until just yesterday. We have about 70 logical log files, each 5M…
Logical Log Backup Method
Hello, If I'm pointing the LTAPEDEV to a tape device, and I understand if the tape is full, then logical log can't backup and the database will eventually hang. In this case, e.g., if the tape drive is bad, can I just change the LTAPEDEV device to /dev/null and do a ontape -c t…
Informix Level-0 (restore ?)
RE: Informix backup/restore, DLT4000 tape drive, HP70, HPUX9.04, Informix 5.3 Tape Device [/dev/rmt/3hc ] Block Size [64 ] Kbytes Tape Size [30000000 ] Kbytes Our Level-0 backup use to take 10 hours (DDS), we now have the DLT4000, Level-0 backup =3D 2 hours. On …
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…
PRESS:INFORMIX/AMDAHL PERFORMANCE BENCHMARK
INFORMIX/AMDAHL PERFORMANCE BENCHMARK DEMONSTRATES ENTERPRISE SCALABILITY FOR WINDOWS NT-BASED DECISION SUPPORT Industry Benchmark Result Sets Standard For Windows NT Data Marts MENLO PARK, Calif. - August 13, 1997 - Informix Software, Inc. (NASDAQ:IFMX), the leading provider o…
ONBAR
Does anyone have any experience with ONBAR, OPENVISION and HP?'s and hooking them up? Thanks Ed edbid @ cobe.com…
onbar and ADSM
>Return-Path: <ilist@rmy.emory.edu> >From: "Howard Kerr" <howardk@pavilion.co.uk> >Subject: onbar and ADSM >Date: Sat, 2 Aug 1997 06:35:07 +0100 >Reply-To: "Howard Kerr" <howardk@pavilion.co.uk> >Organization: Pavilion Internet plc >Sender: informix-list-owner@rmy.emory.edu >To: …
onbar and ADSM
Has anybody else had problems restoring using onbar and ADSM. Our backups all report ok, but we have numerous problems restoring anything otherthan smallish instances. Informix versions 7.21, 7.22 and 7.23. ADSM Version 2.1.6. IBM AIX 4.1.5 Any info gratefully received.…
OnLine 7.2 3rd Party Backup / Restore Utilities
I have been using ontape to backup my database for about a year. I only have 1 (about 2GB with 300 tables) and I do a full backup every night onto DAT. The problems I have: - I cannot restore one table only. - I cannot "verify" backups (perhaps by restoring one table) - I cann…
Onbar & Storage Managers
I am new to the Informix Online and I am trying to provide a way to manage backup and restore with On-bar. Here are some of the questions that I have: o Do I really need a storage manager (networker, netbackup). o Since onbar is a command line application, is it practical to wr…
Re: Backup and Restore Help!!!
Neal Leitner wrote: > My problem is: I want to backup my On-Line database each night to tape > and be able to selectively restore tables if needed. Ontape does a good ........... > I thought about a dbexport, but my users complained each night when I > kicked them off the syste…
Re: Backup and Restore Help!!!
Neal Leitner wrote: > My problem is: I want to backup my On-Line database each night to tape > and be able to selectively restore tables if needed. Ontape does a good ........... > I thought about a dbexport, but my users complained each night when I > kicked them off the syste…
Re: Backup and Restore Help!!!
Some salient issues for this debate: 1. onunload/onload do not support fragmented tables. 2. Why do you want to restore individual tables? If using OnBar (with 1 table per dbspace) then be aware that: a) you can only restore dbspaces that are 'down' (i.e. you c…
RE: Backup and Restore Help!!!
David, ONBAR system doesn't allow backup and restore operation at the table level. But you can backup and restore and the DBSPACE level. If you fragment your table you can backup and restore and the partition level ( That sounds good but it is still at the DBSPACE le…
RE: Backup and Restore Help!!!
Neal How about onload(tbload) and onunload(tbunload)? I haven't used it very = extensively but you can restore specific tables within a database if you = want to, and it is faster than dbexport/dbimport. I am not sure if you = need to kick your users off when you do it, but I ex…
Re: Backup and Restore Help!!!
Neal Leitner wrote: > > I have a problem, which I thought was a simple one to fix, but after > consulting with Informix, there is no current Informix utility to solve > my problem. > > My problem is: I want to backup my On-Line database each night to tape > and be able to select…
Re: Backup and Restore Help!!!
In article <33C6AC29.411B@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Neal Leitner wrote: >> >> I have a problem, which I thought was a simple one to fix, but after >> consulting with Informix, there is no current Informix utility to solve >> my problem. >> >> My …
Backup and Restore Help!!!
I can think of 2 ways to work around this problem: 1. You can redo your production database to place the target restore tables each in their own smaller dbspace. You can then restore at the dbspace level. 2. If you have the luxury of a test box, restore your produc…
Backup and Restore Help!!!
I have a problem, which I thought was a simple one to fix, but after consulting with Informix, there is no current Informix utility to solve my problem. My problem is: I want to backup my On-Line database each night to tape and be able to selectively restore tables if needed. …
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…
Can't backup logical logs to /dev/null
Went through all the logical log backup recommendations and alot said to do automatic/continuous backup to /dev/null. Logs were full at first so I added another logical log. Now when I try it I get a message saying I can't backup logs to /dev/null: Taz:/home/archive/informix/etc…
Problem recovering database (warning)
We recently have a database crash due to a disk problem. We were able to recover most of the data from tape. However, we could not recover any data (two days worth) stored in the logical logs. Further investigation showed that we have accidentally over wrote our logical log fil…
onbar
I had a problem with onbar, simply we don't know how to set it up to work. We run AIX and HPUX and the release doc said onbar is supported on both platform (7.22). But when I use onbar on HPUX, it simply returns "not support on this platform", while on AIX, it can't find a librar…
Individual database backup/restore
Does anybody know what the best way is to is the setup Informix so that I can individually backup and restore databases on an Online 7.14 UD1 engine is without restoring the other databases as well. I have about 20 or 30 databases and splitting them up into there own dbspaces is …
OnBar with Alexandria ??
The subject say's it all. We are planning to implement Onbar using Spectralogic's Alexandria, and I'm looking for anyone with experience, using either, or both together. Thanks Jon ---------------------------------------------------------------------------- --- Jon C. Vemo "Li…
ONBAR/OPENVISION
Does anyone know if there is an API available for HP 10.20 - Informix 7.22 to run the Onbar utility against Openvision Software?? Tks in advance. Ed edbid @ cobe.com…
ONBAR Error
Can not find the file ibsad001.sl in the /usr/lib directory. Where does this file come from. Thanks…
unable to start up informix
I have installed informix 7.12 TC3 on a windows NT3.51 platform. When I try to start up online, I get the following message after a few minutes: "The database server timed out before changing the mode. Try changing the mode again". I also have the alert: "Logical logs are full…
Re: differences between 7.21 and 7.22
7.21 supports onbar, 7.22 supports Enterprise Replication. Madison Pruet…
RE: ONBAR
You will NOT get OnBar working with only the Backup Guide, it works with a Storage Manager such as Legato, HP Omniback, ADSM from IBM, every storage manager hast its own procedures, they don=B4t have standard=20 configurations, but all of them keep the same principle: Administra…
Re: ONBAR
In article <3338298B.5B9C@boat.bt.com>, John Hitchinson <hitchij2@boat.bt.com> writes >Dear All, > >Has anyone got this product working successfully using only the >information supplied in the backup and restore manual? > The manual states the required syntax to perform backups …
Re: ONBAR
John Hitchinson wrote: Dear All, Has anyone got this product working successfully using only the information supplied in the backup and restore manual? The manual states the required syntax to perform backups of dbspaces blobspaces, logical logs...however it isn't…
Re: ONBAR
I have made ONBAR work with a third party backup util ADSM (Adstar Distributed Storage Mgr) I used a special publication on ONBAR itself, from Informix. I have the book at work and I could give you the title if you send me email to alan.maxwell@autozone.com re:ADSM and ONBAR. I …
ONBAR
Dear All, Has anyone got this product working successfully using only the information supplied in the backup and restore manual? The manual states the required syntax to perform backups of dbspaces blobspaces, logical logs...however it isn't clear how to specify the destinatio…
Re: Machine Configuration
Enio Roncarati wrote: > > Hi everybody. > > We have a version 7.20 of Informix OnLine Dynamic Server on a DEC 2100 with > 3 CPUs, 1 GB of RAM and 60 GB of Storage Array. > > Everything is OK, but we want to find the best configuration for the disk > array. We have 2 disks array o…
ONbar missing library
ONbar 7.22.UC1 & Solaris 2.5.1. Attempting ONBAR -b -f dbspace_name, I get no error returned to the screen, but get an error locating ibsad001.so in the log file. Can anyone enlighten us as to who develops and supplies this library? Thanks in advance John Hitchinson Open Sy…
Re: onbar
David Williams wrote: > > In article <5ekg4q$3p0@cssun.mathcs.emory.edu>, Manoj <manoj@mailhost.tw > owaytv.co.uk> writes > >Has anyone got any experience of using onbar (v7.22) ? > >If so then I would like to hear the comments (i.e. problems, etc). > > > >Thanx > >==============…
OnBar Users
This is a general call for users that have had experience (any experience counts) with OnBar. We are a Sun/Solaris shop with multi-hundred GB V7 Informix engines. I am currently in the process of evaluating Legato's Networker as well SCH's ReelLibrarian. I would appreciate any in…
Re: onbar
In article <5ekg4q$3p0@cssun.mathcs.emory.edu>, Manoj <manoj@mailhost.tw owaytv.co.uk> writes >Has anyone got any experience of using onbar (v7.22) ? >If so then I would like to hear the comments (i.e. problems, etc). > >Thanx >====================================================…
onbar
Has anyone got any experience of using onbar (v7.22) ? If so then I would like to hear the comments (i.e. problems, etc). Thanx ======================================================= Manoj Schroff TWOWAYTV Lt…
Re: ONBAR (backup and restore)
Are you doing your archive to a single dat device? Do you have spare disk drives laying around? When I was confronted with this problem I created multiple archive directories on cooked drives. Then I defined multiple dbspace groups for my archive and ran it in parallel. Then I…
ONBAR (backup and restore)
Anyone using Online DSA v7.2 onbar for backups on an hpux10.10 server? Am interested to know what third party vendor you interface with. What backup devices are you using? What kind of performance are you getting? I am currently running onarchive and ontape for level 0 archives t…
Backup & Restore Granularity
I am fairly new to Informix admin. I was surprised (and disappointed) to learn that On-Tape, On-Archive (and, I believe the up-coming On-Bar) back up and restore only at the dbspace level. WHY NOT AT THE TABLE LEVEL? If a user is in dbaccess, it is frightlenly easy to drop a tab…
onbar
Does anyone out there have any experience with OnLine 7.21, "onbar" (Backup & Recovery System) yet? I'm just starting to try and use it, with Solaris 2.5.1. I don't even know if we have an XBSA installed!? Do we need one? Does one come with Solaris or do we need to buy Legato?…
Re: Informix vs. AIX Mirroring
John Morton (mortonj@interlog.com) wrote: > Hi there. We're just moving from a RAID5 box onto some SSA disk, so we > have to think about mirroring. Informix recommends Informix mirroring, > and IBM recommends AIX (what a shock!). We are running AIX 4.1.4 and > Informix 7.20 on an…
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…
verify that backup tapes are good
I have a customer who has had some problems recently with backups that can not be restored for various reasons. Are there any products that will perform a backup and then read the tapes to see that they are correct? Many Thanks, Cecil Broom broom@best.com…
Logical Logs Archiving
I used to be able to do: tbtape -a to backup logical logs to /dev/null, but now I get the error: Logbackup failed - Log backup to device /dev/null not allowed I don't have a tape drive. Is there any work-around other than re-creating the whole database??? Thanks a lot. Yudong…
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…
PRESS: U.S. DEPARTMENT OF LABOR STANDARDIZES ON INFORMIX
U.S. DEPARTMENT OF LABOR STANDARDIZES ON INFORMIX Job Corps and Employment Standards Administration (ESA) First DOL Divisions to Modernize With INFORMIX-OnLine Dynamic Server and INFORMIX-NewEra (Vienna, VA, March 25, 1996) -- The U.S. Department of Labor (DOL) recently awarded…
Logical Log Backup to disk
Recently I got a new task to backup the logical logs to disk. How can I accomplish this task. Help. Thanks. -- ------------------------------------------------------------------------------ Dennis B. Park Internet: dpark@misdg01.med.osd.mil EDS-D/SIDDOMS …
Logical Log Backup
Hello, people out there. Recently I got a task to back up logical logs. And I don't know how to back them up to disk, and retreive them where there is a problem. Please help! - Dennis -- ------------------------------------------------------------------------------ Dennis B.…
v5.05 Logical Log Backups
Anyone out here who can answer this little conundrum? One of our customers has a v5.05 database utilizing 15 10MB logical logs (I know that they need to be increased). They do not run continious log backups because they have the entire disk mirrored on a different site, so they …
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?…
Question: Logical log backups?
> From: piet_k@apollo.HP.COM (Keith Piet) > Subject: Question: Logical log backups? > > I have a quick question regarding backups of Logical logs > to optical disk. > [...] > Has any one had any luck with sort of thing? > > Please send replies to my email address. > piet_k@apoll…
Question: Logical log backups?
I have a quick question regarding backups of Logical logs to optical disk. We are running Informix-Online ver 5.x. I have set up a korn-shell script that performs a logical log backup, tbtape -a, to an optical disk drive. When I run the tbtape -a command online, everything is …
PRESS: INFORMIX AND MICROSOFT CLIENT/SERVER PACKAGE FOR WINDOWS NT NOW AVAILABLE
INFORMIX AND MICROSOFT CLIENT/SERVER PACKAGE FOR WINDOWS NT NOW AVAILABLE Informix Value-Added Resellers Provide Database Applications on Windows NT MENLO PARK, Calif., (February 1, 1994) Informix Software, Inc. today announced the immediate availability of a promotional clie…
PRESS: SPARCSERVER 1000 RUNNING INFORMIX DELIVERS INDUSTRY'S BEST DATABASE PRICE/PERFORMANCE
Sun announced the following on Wednesday: SPARCSERVER 1000 RUNNING INFORMIX DELIVERS INDUSTRY'S BEST DATABASE PRICE/PERFORMANCE MOUNTAIN VIEW, Calif. -- January 5, 1994 -- A Sun(R) SPARCserver(TM) 1000 system running the INFORMIX-OnLine 5.01 RDBMS offers…
Re: Logical log backups
> > Logical log fans, > <stuff deleted> > > With that change in place we have had the error occur twice in the last > four days. That might suggest that we have some difficulty with the > tape hardware, but it doesn't seem to change what appears to be a bug. > The continuous log…
Re: ?: Table Restore/Backup :?
In <1993May10.141515.1374@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: >I wasn't making myself entirely clear: The restore should then restore >only those pages that reside on the dead chunk. So if table A lived on >chunks 1, 2, and 3, and chunk 2 went …
Re: ?: Table Restore/Backup :?
->From: ijk@cbnewsh.cb.att.com (ihor.j.kinal) ->Subject: Re: ?: Table Restore/Backup :? ->Date: Mon, 10 May 1993 14:13:01 GMT ->Reply-To: ijk@cbnewsh.cb.att.com (ihor.j.kinal) ->Organization: AT&T -> ->> Maybe I'm being simplistic, but wouldn't it make some sense to address ->> t…
Re: ?: Table Restore/Backup :?
Andrew Burt writes: |> |> Maybe I'm being simplistic, but wouldn't it make some sense to address |> this issue? Regardless of mirroring or raid5 type recovery ability, |> Informix still *ought* to provide a way to rebuild a table or all tables |> on a chunk that goes down. It s…
Re: ?: Table Restore/Backup :?
In <1993May10.095816.15007@pyra.co.uk> graeme@pyra.co.uk (Graeme Sargent) writes: >In <1993May8.140157.9963@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: >>keep >>track of which chunks a table is on (kept redundantly on different chunks); >>if a chunk is…
Re: ?: Table Restore/Backup :?
> Maybe I'm being simplistic, but wouldn't it make some sense to address > this issue? Regardless of mirroring or raid5 type recovery ability, > Informix still *ought* to provide a way to rebuild a table or all tables > on a chunk that goes down. It sounds simple to me: Have i…
Re: ?: Table Restore/Backup :?
In <1993May8.140157.9963@mnemosyne.cs.du.edu> aburt@mnemosyne.cs.du.edu (Andrew Burt) writes: >Maybe I'm being simplistic, but wouldn't it make some sense to address >this issue? Regardless of mirroring or raid5 type recovery ability, It depends on how you define the issue. H…
Re: ?: Table Restore/Backup :?
In <1993May7.121212.23160@pyra.co.uk> graeme@pyra.co.uk (Graeme Sargent) writes: >In <1993May05.131535.949@sco.com> chrisw@sco.COM (Christopher J. Wood) writes: >>Is it possible to perform table backups/restores with >>Informix? >No. 6.0 is reputed to have dbspace level backup s…
Re: ?: Table Restore/Backup :?
In <1993May05.131535.949@sco.com> chrisw@sco.COM (Christopher J. Wood) writes: >Is it possible to perform table backups/restores with >Informix? No. 6.0 is reputed to have dbspace level backup support. >For example: if I'm running Informix OnLine and >multiple databases over …
Re: ?: Table Restore/Backup :?
Chris, This will be available when OnLine 6.0 (scheduled towards end of '93 I believe) is released. With 6.0 administrators will have the ability to backup/restore at the dbspace level. Since you can specify which dbspace you wish to create a table or database in, you could cr…
?: 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…
table backup/restore question
I tried to post this article yesterday however I doubt it made it outside our site since our news system is flakey. Sorry if this is a re-post. I would like to be able to backup/restore a database table to/from a tarfile (actually any type of file but a tarfile is preferred). …
Introduction of the Server's 5.0 manual set called "New Features."
I have had a couple of people ask about the differences between 4.1 and 5.0. The following describes major new features. --Bill Text from the introduction of the Server's 5.0 manual set called "New Features." ====================================================================…
Sun/Informix TPC-B Benchmark Results
This come over the SunFlash mailing list today. Some of it is interesting reading, and some of it is pure "press release." More grist for the benchmark mill. Walt. -- Walt Hultgren Internet: walt@rmy.emory.edu Emory University, Atlanta, GA, USA BITNE…
Logical log backups
Logical log fans, This is an update on the logical log backup failures I reported to the net on November 3rd. First of all, a thank you to those who sent responses. Unfortunately, I have to report that the problem still exists. I will give a brief recap of the problem below…