Oninit® Archive
Results for “onstat -g arc”
Will ontape backup to disk damage the disks?
3 instance on AIX 5.2 ids 9.4 box. I do label 0 backup and compress to disk file daily and then tar all the disk files to tape in crontab. It spare me a lot of time to backup 3 instance archives. But I wonder that It will damage the disks after thousand times's file creation a…
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 ------------------------------…
Odd restore failure
Andreas: Thanks for expending brain power on this for me. Yea, onstat -g arc shows what's expected, the last onbar level 0 and level 1 archives which were both full server archives. Also, as you note, both my ontape archive and ifxclone runs were full server so that's not it. Her…
Logical Logs - Flags and backups
The log files get zero out when the current log wraps around to reuse each one. Best practice is to keep the latest two level 0 archives and all of the logical log backups going back to that older archive you are keeping. So say you archive on Saturdays. You would currently have …
archecker utility on ontape level 1 archive
Hello Gaurav, I am not restoring; I am using archecker to verify the integrity of a backup archive, which is, as far as I understood, one of archecker's purposes. Best, Arjen. ------------------------------ Arjen Van Drie ------------------------------…
Slow running backup
You'd monitor an ongoing archive through 'onstat -g arc'. This, between archives, has the spaces' Archive Status only, yet, during an archive, starts on a block detailing spaces' before images temp partitions and current physical position of archive processes scanning the spaces …
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…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Informix backup question
Sorry - misread your question about PIT. If you want to restore to a time AFTER the archive checkpoint, then you must apply the logical logs created after the archive checkpoint. I thought you were wanting to do a restore to the archive checkpoint time. Madison Pruet Retired and …
Backup is Blocked:ARCHIVE when temp space being us
No, it hadn't even got to the "Archive on rootdbs...etc started" message. Nothing in onstat -m (and no "Fuzzy Checkpoint completed" messages, and no af's On Tue, Apr 19, 2016 at 4:39 PM, Marcus Haarmann <marcus.haarmann@midoco.de> wrote: > Hi, > > pls post if the backup has rea…
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)…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
ontape backup and restore
Informix archives are always as of the beginning of the archive process. If you run onstat -g arc the reported date/time is the state that the server will be returned to when you restore that latest archive unless you also roll forward logical logs in which case the server state …
ontape error message
My daily cron ontape backup job threw a error message last night , Archive failed - buc_fe.c : Archive API processing failed at line 307 for msgtype Any comments for reason ? Thanks Frank --001a11c16cfe5d72b404fadd485e…
Ontape and onbar
Yes. You can use onbar and ontape at different times to archive the instance. You just have to keep track of which is the most recent if you need to restore since you will have to locate the archive and restore it with the same tool. Onstat -g arc will only be able to tell you wh…
Level 0 restore successful but Level 1 having issu
Hi All, Level 0 successfully restore from file system and Level 1 giving below error Physical restore failed - function read archive backup failed code -1 errno 0 Restore a level 1 archive (y/n) y Ready for level 1 tape Restore will use level 1 archive file /ifx_backup/pmhx001_…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Query to get the name of archive file
Hi, I am required to find the name of the archive/backup file which is created after executing the backup command: ontape -s -L 0 Can someone tell me the any (sysmaster) query using which i can find the recently created file name in the backup directory? I am writing a script …
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.…
ontape restore and page writes
Tracy onstat -g arc will show where you are with a restore, and also approx how far you have to go. Generally I've found a restore - to the same machine - takes about 10% longer, to a different machine will depend entirely on the io sub-systems, disk speed/layout etc. Keith On …
Database backup Archive 0 and Logical Log backup
Hi All, Currently, we are doing database backup Level 0 and Logical Log backup on to tape drives. Is it possible to change to NAS disk instead of tape drives. We are using Informix 11.50 on HP-UX machine. If yes, please let me know the statement or script for this Thank you …
backup IDS windows
Can you help me to schedule some archive and backup of logs using IDS Windows 11.7? tks henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Unable to start the storage space backup: Smart La
Hello, I'm running IDS 11.50.FC9W1 on Solaris 10, and doing level 0 backup and encountering this error, note that, with "whole system" backup, this error does not so up?? So basically, the only one dbspace that did not get backed up is this smart large object dbspace, (sbdbspace)…
Logical logs backup to Disk
Art, Actually, I am interested in hearing from others that have been successful with disk backup of DB archive and logical logs and I'd be willing to assist anyone with their questions if they are trying to do the same. Larry…
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,…
ontape restore failed code -1 errno 0
It looks like you compressed the archive using the BACKUP_FILTER set yo gzip. Make sure that the RESTORE_FILTER is set to gunzip to restore the archive. It looks like you have it set to gzip. Art On Oct 16, 2012 6:32 AM, "KLAUS BURGER" <edv@hatico.de> wrote: > Hello, > > we mad…
Logical Log backup during L1 archive
Morning all An odd one which I have a faint bell ringing at the back of my head about... IDS9.30HC5, HP-UX11i We run our L1 backups using onbar -L0 -w via ISM to disk, for dbspaces and for logical logs. This is usually started at around 8.30 pm when all the users have been logged…
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…
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 …
Re: Restore + Logical log - caution
I will comment/answering the messages of Fernando , Madson and Art... Fernando, I will try keep simple... When you take a Archive Level 0 , as far I know the idea is, all logical logs backuped (file/tape) before this archive could be lost and you don`t need to worry because all …
Restore + Logical log - caution
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you restore an archive with logical logs , maybe you needed the files/tapes of logical logs backuped before the Archive Level 0. The rea…
Restore + Logical log - caution
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you restore an archive with logical logs , maybe you needed the files/tapes of logical logs backuped before the Archive Level 0. The rea…
Archive backup terminated prematurely
Problem: The last several level-0 backups (using ontape s L 0)have failed, with the only clue being an Archive backup terminated prematurely message. Normally, the backup creates 639 2G backup files; now, it terminates after 110. I also noticed that there are some missing pag…
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…
Request for BACKUP_FILTER archive times correction
Hello, my friends. IDS 11.50.FC8W3 and 11.70.FC2, both on linux_64 machines. I had to apply a backup and restore filter, and notice that my "onstat -g arc" times are not correctly updated. As follows: 1) onstat -g arc output Dbspaces - Archive Status name number level date log l…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
onstat -g arc x systable
need to know which table stores the information displayed in osntat-g arc, must know the date of execution of the last backup…
Next backup of DBspace rootdbs must be level-0
Hi over there, I've found the following warning in my 9.40.FC9 IDS dataserver online.log : "Next backup of DBspace rootdbs must be level-0 backup" The paper "https://www-304.ibm.com/support/docview.wss?uid=swg21429486" explains that this is due to a timestamp used by IDS to ide…
Archive failed - buc_fe.c : Archive API processing
Hello , I am getting following error while taking backup manually from command prompt. Archive failed - buc_fe.c : Archive API processing failed at line 307 for msgtype IDS Version : IDS11.50.FC6 Database Size: 700G OS Version: SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v spar…
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…
How long did the last level 0 backup take?
Andrew: I would like to suggest a different solution to your problem. If a user backups to /dev/null directly this is considered a "fake backup". Fake backups to not update the last backup time of a dbspace. I would suggest looking at the last backup time. You can use oncheck -p…
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…
onstat -g arc vs select statement output ------Web
Hi All, I'm just curious about this.. If i execute onstat -g arc, it shows the wrong date.. => onstat -g arc IBM Informix Dynamic Server Version 7.31.FD8X5 -- On-Line -- Up 2 days 19:57:04 -- 4074880 Kbytes num DBSpace Q Size Q Len Buffer partnum size scanner 1 rootdbs 0 0 0x…
IDS9.4FC8 backup problem
Dear all update something new... I looked the article from IBM and checked the report between onstat -pr and onstat -g arc. Logical Log Position is the same. Is any idea about this problem? it really drive my crazy...…
onstat -g arc select statement
Hi All, is the someone who knows the onstat -g arc select statement equivalent? Thanks,…
Re: Onbar problem
Art Kagel wrote: > Contact IBM tech support. > > Art > > Art S. Kagel > Oninit (www.oninit.com <http://www.oninit.com>) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect…
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…
ontape -s to local directory on UNIX
Hi Gurus, I am trying to backup to local directory (TAPEDEV = /mn/dbbkp) but the following message is being given. Please mount tape 1 on /mn/dbbkp and press Return to continue ... could not write archive tape. Please mount tape 1 on /mn/dbbkp and press Return to continue ... …
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…
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
Out of the 3 databases, i do rarely use the other 2. Hence i decided to go for archiving a single database. If there is no other way, i can use dbexport command to archive the single database! But i have a concern that whenever i do a restore with backup tape obtained by "ontap…
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…
Backup & Restore confusion
OK, the level zero archive contains the last logical log as of the moment that the archive started. When you restore you want to restore to the moment of a crash (or at least as close as the last archived logical log) so you have to restore logical logs starting with the last lo…
External Restoration
Vikas, You need to perform an ontape backup with chunk rename. I am assuming that you have correctly setup the onconfig of the destination. Here ensure that the servernum of the source and destination are different. Create a text file with the following structure, called dest_re…
I/O errors during backup
Hi Guys, on an old installation I inherited, I have the following issue : Informix Dynamic Server 7.31 UC6 Mips Platform running Reliant Unix. 2 I/O errors (with a history) appear during the backup with ontape. But backup seems to complete anyway. 116942 20:02:26 Level 0 Arch…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Physical restore failed - read archive backup
Hi everyone. We have the following: IDS 10.00.FC5 Linux Red Hat Kernel 2.6.9-42 on an x86_64 Tape Params: TAPEDEV /dev/nst0 # Nonrewind tape device TAPEBLK 32 TAPESIZE 400000000 We use "ontape -s -L 0" as fifth partition of seven that the tape contains. This wor…
Full Proof way to determine if ontape is restoring
On 12/05/2008, Art Kagel <art.kagel@gmail.com> wrote: > Onstat -D or onstat -g iof are the only ways to monitor the progress of a > restore, unfortunately. > > Art S. Kagel > Oninit > > On Mon, May 12, 2008 at 3:47 PM, WILL LANDSTROM <willlandstrom@yahoo.com> > wrote: > > > Hey s…
Re: Can Disk mirroring/db snapshots replace the usage of taking database backups?
> Rightm, but all these snapshot-based technologies use "consistency group" > functionality so what you describe above doesn't apply. > I still don't understand - referring to the implication in Art's original > reply - why a database block/unblock is necessary for an external ba…
Ontape backup failed in new instance
Hi all i am using informix 7.31 FD10. i have two instance in the server. i have created new instance in the server.i can take log backup with ontape -a command in new instance,but whenever i try to tabke Level 0 backup (ontape -s -L 0) in newly created instance it shows following…
Onbar and LTAPEDEV
Thanks for all the responses - Whole system parallelism is what we are looking for - maybe this will inspire us to move to v11. In the meantime we'll make sure we have LTAPEDEV set before we kick off our parallel backups so we have a restorable, if not gnat's arse granular, arch…
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…
Newbie onbar vs ontape question..I hope that's ok
Most of your assumptions are correct. But you may have missed a big caveat. A restore of an archive taken by either onbar or ontape will probably be followed up by a lower level archive or logical log restore. An example would be to have a LEVEL 0 archive then a LEVEL 1 from a c…
Re: Onbar fails to restore all dbspaces
On 16 Nov, 22:32, "TBP (The Big Potato)" <T...@NotHere.Co.Uk> wrote: > jpier...@chubb.com wrote: > > There is a parameter that sets/governs the interval time between the > > restore of each dbspace object. In other words, once an object is > > restored, the storage manager might …
ontape restore fails on second tape
Running HP-UX 10.20 IDS 7.24. I have several multi-tape archives that all fail on the switch to the second tape with the error: Physical restore failed - The archive backup is corrupted. The latest archive is one that I created with no problems. I think I have seen this proble…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
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…
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…
Problem while taking backup
What about the message log file, is there anything usual, errors/ checkpoint duration? If you do a file system backup to the tape drive, say of a 4G data how does it behave ? If you do onstat -g arc -r 1 does the scanner value increment? Kenneth Penza Technical Services Officer …
Re: Level 0 archive info. from onstat
Floyd Wellershaus wrote: > I just checked my onstat -g arc, running 9.4FC3 on aix5.3. > For all of our dbspaces it shows the time the archive BEGAN. > It's the same time that is shown in the bar_act.log for the instance. > We are doing a whole system backup. > > There are severa…
Re: Level 0 archive info. from onstat
I just checked my onstat -g arc, running 9.4FC3 on aix5.3. For all of our dbspaces it shows the time the archive BEGAN. It's the same time that is shown in the bar_act.log for the instance. We are doing a whole system backup. ======================== -<<Floyd Wellershaus>>- Da…
Level 0 archive info. from onstat
Greeting All, HP-UX B.11.11 U 9000/800 IDS 9.21.HC2 Though it's not an issue but it is bugging me on & off. I am sure some one here will be able to explain this. We have got 4 dbspaces as rootdbs, llogdbs, plogdbs, superdbs. We do level 0 archive every night. superdbs dbspace …
snapshots of db disks on SAN
You will need to read the manual about "external backups" You have the ability to use a blocking check point "onmode -c block" and once the snap is complete you issue the "onmode -c unblock" This will let the DBSEREVER know there is an external backup (there are directions to do…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
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?…
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/…
/usr/informix/bin/onbar[84]: 22716 Memory fault
John Carlson <jwcarlson1@yahoo .com.invalid> To Sent by: informix-list@iiug.org informix-list-bou cc …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Re: How to get the Status history of the backups
<snip> onstat -g arc gives you these info. (IDS V10) and I normally use following script for this: <snip> onstat -g arc merely shows that a backup has started and not that it has successfully completed or even failed. I would be interested to know if in IDS 10 it does actually…
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 ?
What can I say but "it's always fun to play around with your backups and try risky unsupported stuff. It's always fun until the restore doesn't work!" I'd hate to think what situation this would leave you in if you then backup logical logs via onbar and the instance fails befo…
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.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: any way to know the progress of a level1 (or level0) ontape save?
If an archive is running the following select statement from sysmaster will tell you which dbspaces still have pending archives. select dbsnum, name from sysdbspaces where bitval(flags, '0x4000') <> 0 order by 1 You can also get this information from onstat -d where the flags c…
ontape failed
hi, i've made a level 0 archive using ontyape on a remote filesystem TAPEDEV host2:/backup/SL0 when i try to restore the archive on host1 with ontape -p (for HDR) i've got an error message : Please mount tape 1 on host2:/backup/SL0 and press Return to continue ... Physical rest…
RE: ontape -s to disk
onstat -g arc will show the last successful archive date -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of wcottishpoet Sent: Tuesday, December 07, 2004 7:12 PM To: informix-list@iiug.org Subject: Re: ontape -s to di…
restore with ontape
Hi to all; MachineA 9.3 FC2 --SunOs 5.8 MachineB 9.4 FC4 --SunOs 5.9 We defined MachineA archive tape to be MachineB:/dev/rmt/0. Although the backup operation ontape s is succeeded the restore operation ontape r is failed with the following message physical restore fai…
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…
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'?…
Question regarding the Level 1 archive using ontape
I think there are a number of adminstrative tasks that means you have to perform a level 0 archive for example , if you added any dbspaces probably worth reviewing the info in the backup guide. "> > We take the level 0 backup every week and level 1 backup every day. But > somet…
Re: any way to know the progress of a level1 (or level0) ontape save?
You may not do archives regularly, but you were right about being able to use onstat -g arc for tracking in progress archives. Although the datetimes for each dbspace are not updated during the archive, the top part of this report is totally dedicated to the in progress archive …
Re: any way to know the progress of a level1 (or level0) ontape save?
I haven't noticed this -g previously, so I'm trying to figure it out. All my dbspaces show the same datetime for Level-0 and Level-1 respectively. These times look to match up to initiation time of the last successful level-0 and level-1. I'm running a level-0 on a test system,…
backup help/understanding needed with transaction logs
On Wed, 15 Sep 2004 08:48:40 -0400, Gary Quiring wrote: > I have a 7.31UC6 Informix DB where I backup using ontape daily using the cmd > ontape -s -L 0. Currently LTAPEDEV is /dev/null. I do not have two tape > drives. > > The backup is hot and the DB is changing during the ba…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Why there is no controlfile in Informix like Oracle ?
You are pretty much right. Most of the Information is kept in sysmaster. The backup information is kept in sysutils. i.e Onbar backup utility similar to RMAN. Also the backup info found in sysutils is in a flat file found in $INFORMIXDIR/etc/ixbar.<servernum>. Contains the logic…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
RE: how informix archive works?
Yes Miyaki, Keith is correct. Provide us more information please ! 1. Is this a one time deal or does this happen each time you perform this archive ? 2. What is the reason for you to run 2 archives one after the other ? 3. What is the time difference between the two archive…
how informix archive works?
Hi all, I have some doubt on the informix backup. I'm using ontape command to perform level 0 backup on my Test database (7.31.UC2). The first level 0 backup took around 2 hours to complete and the second time of level 0 backup only took ~45min. The second time of the backup beg…
how informix archive works?
Hi all, I have some doubt on the informix backup. I'm using ontape command to perform level 0 backup on my Test database (7.31.UC2). The first level 0 backup took around 2 hours to complete and the second time of level 0 backup only took ~45min. The second time of the backup beg…
RE: Timestamp of last archive
Good idea. Exact SQL to retrieve the time stamp of the last LO archive is: SELECT stamp0 FROM sysmaster:sysdbstab WHERE dbsnum = 1 It gives exactly the same data as 'archive' page of the 'oncheck -pr' output ------------------------------------------ Alexey Sonkin > From: Da…
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.…
Timestamp of last archive
R�diger M�hl wrote: > Hi folks, > > is there any way to get the timestamp of the last > archive from any [system] table? > > I know about oncheck -pr. > > TIA, > > R�diger Not sure about a system table, but onstat -g arc will show the last (2 I think) archive details.…
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: Incremental Archive performance issue......
"Five Cats" <cats_spam@[127.0.0.1]> wrote in message news:Hc7W+WA3NmeAFwKT@[127.0.0.1]... > In message <c56p0h$cfc$1@terabinaries.xmission.com>, Alexey Sonkin > <alexeis@grandvirtual.com> writes > > > >For L1 archive, the backup speed is mostly limited by the > >disk array throu…
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,…
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…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Backup/Restore check w/ ONTAPE
On Mon, 20 Oct 2003 12:50:07 -0400, MF wrote: > Hi, > > Does informix have some sort of system commit number (like Oracle) that I can > verify a backup after restoring onto another machine? > > I would like to backup a system, get a CRC, check#, etc., do a restore and > recheck …
Re: Re: RE: Backup/Restore
Hi brother - ontape ALWAYS asks for logical logs recovery when you perform a restore. Of course, you MUST keep backing up your logical logs in between archive backups :-) - Informix (ontape) DO KNOWS which logical log to recover. A suggested routine could be this: archive backu…
Re: list ontape backups
Simmons, Keith wrote: > Yasela > > You cannot use ontape to list the archives taken, however each archive start > and stop time is recorded in the online log file so simply examin that. There's also onstat -g arc, don't know if that helps you. Cheers, -- Mark. +--------------…
ontape in 9.4
Hi. I am in the process of migrating from IDS 7.30 to 9.4 on HP-UX 11. We currently run a full archive nightly and backup the logical logs every hour. We archive to tape and backup the logs to disk. The logs are handled by a=20 cron job, while an operator handles the archive. For…
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…
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: onbar question
Hi, The answer is quite easy, her some explanation: 1. A serial back-up (ontap and onbar -w ..) will start the backup of all dbspaces at the smae time. So the dbspaces are consistent at that time 2. With a parrallel back-up Informix will starts a back-up thread for every …
Bug arc_very_old_pages()
Hi Milena, CCFLAGS will have to be set in the onconfig to CCFLAGS 0x400000. You wont have problems with the speed of level 0 or 1 anymore... Here is the workaround: ARCHIVE TIMESTAMP PROBLEM AND PERFORMANCE - Document Number: 253 Summary: This article discusses bugs 101062 …
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…
RE: onstat -g arc
Stardate. Mine don't look like that at all. Looks suspiciously like an overflow, is this affected by DBTIME settings? Sorry - never really played with -g arc. cheers j. > -----Original Message----- > From: Andreas Kumpf [mailto:ak@a-w.de] > Sent: Thursday, November 30, 2000 …
RE: onstat -g arc
What version of Informix are you running? It may be an old one, which is not Y2K compliant. -----Original Message----- From: Andreas Kumpf [mailto:ak@a-w.de] Sent: Thursday, November 30, 2000 01:27 To: informix-list@iiug.org Subject: onstat -g arc Hi, how could I resolve the ob…
onstat -g arc
Hi, how could I resolve the obtained date from 'onstat -g arc' ? It's sth. like: 101/10/190.29:22 Greets, Andi…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Backup/Archive
On Dom 05 Nov 2000 22:26, Ronald Cole wrote: > "Joe Terry" <jterry@xmission.com> writes: > > What does > > echo "\\n\\n" | ontape do? > > Exactly what was asked for: "unattended online backup/archive of the > database". Aren't there any options missing there? Like something like…
Re: Backup/Archive
From: "Joe Terry" <jterry@xmission.com> > >Help --- > >I am using IDS 7.30.UC7 on a Linux box and am having a great deal of >trouble >trying to find out what Informix tool/utility is required to do an >unattended online backup/archive of the database. The CD talks about >onbar, …
Backup/Archive
Help --- I am using IDS 7.30.UC7 on a Linux box and am having a great deal of trouble trying to find out what Informix tool/utility is required to do an unattended online backup/archive of the database. The CD talks about onbar, onarchive, etc. -- these are not available with t…
ontape and LTAPEDEV = /dev/null
rsalido@my-deja.com wrote: > > 2.- Can users be working on the system while I do the backup??? > Keep in mind that the backup will be consistent as at the time that it was started. That is, all changes after the Archive checkpoint will NOT be in the backup. Rudy…
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 …
Location of last archive in reserved pages
No onstat -g arc in 7.2x, Michal! Art S. Kagel Michal Hajek wrote: > > Ian Taylor wrote: > > > > Hi Everyone > > > > I'm developing a script which requires the date/time of the last level 0 > > archive from the reserved pages (IDS 7.24 on HP-UX). I've tried using > > oncheck -p…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: 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…
Questions about ontape
What kind of backup is ontape? How does it work? Is it a "dd" or something else? I have read we can work through the backup with no ill-effects, but will processing be slowed? Are tables or other structures locked, other than blobs fields, when the archive is running? We want to …
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…
dbserver resources used during archive
Perigrine White wrote: > > Greetings. I use IDS 7.3.0.UC6 and am wondering what resource is needed to > handle database transactions during an ontape archive. We sometimes have to > run batch during the archive. Is there some dbspace that can be increased > to handle the amoun…
Archive Backup
hello everbody, i want the steps for performing archive operation??????? * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: Backup Timings
abhay@cheerful.com wrote: > > Hi, > I want to find the duration for the ontape backup. > I know, I get this info in a message log but if I > get the start and end times in Date-Time format, I can > subtract easily. Why not get them from your script then? > Is there any sysmaste…
Backup Timings
Hi, I want to find the duration for the ontape backup. I know, I get this info in a message log but if I get the start and end times in Date-Time format, I can subtract easily. Is there any sysmaster table for this info ? Where does onstat -g arc gets the info from ? TIA -------…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
Re: onstat -g Question
onstat -g arc undocumented. In versions 7.30.uc5 and earlier the date xx/xx/2000 displays as xx/xx/10 (bug). |--------+-----------------------> | | Jochen | | | Platzer | | | <jps@magnet.a| | | t> …
onstat -g Question
Yuri Dovgart wrote: > Use onstat -g arc. This must help. Note that backups to /dev/null will also be "recorded". Rudy…
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…
ondblog cancel won't work
I submitted a ondblog buf <database name> to a database, and then it locks until I do a level-0 archive backup. Since there is a problem doing backups (the backup hangs) I can not do it, therefore, my database is locked. I tried doing a ondblog cancel <database name> and it…
OnTape : archive backup is corrupted
Hi, I have 2 SCO 5.0.5 machines running IDS 7.30UC2. The primary machine has a DLT tape drive connected to it on which I have created a 0 level backup with ontape -s. I am trying to restore this backup on the other machine (to create to identical machines) i.e. from the networke…
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…
ontape or on-archive question
You could backup your logical logs to disk to resolve this issue. Rudy Paul Jazwierski wrote: > When doing an archive with either of these utilities and doing automatic > log backups, can the level-0 archive and log backups go to the same > tape? At what point do I change the …
Can the BTree cleaner thread block a user transaction? -Help
Informix7.24 UC7 on Solaris 2.6, ESQL/C 7.24UC7 Hi everyone! We have a process that used to run fine on our server for over a year. What the process does: unload about 200 rows to a file delete the same number of rows from the table begin work lock table in exclusive mo…
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…
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…
RE: archive and transactions
NOT. The state is as at the checkpoint of the Archive start. Murray Wood -----Original Message----- From: . [SMTP:krebs26@sprint.ca] Sent: Monday, November 15, 1999 11:19 AM To: informix-list@iiug.org Subject: archive and transactions Hi all, My question is : After executing …
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Level-1 backup after level-0 using ontape
Hi there! I use ontape -s to create archives in order to perform backups. I don't really use any tape device to make the archives. Instead, I have TAPEDEV pointing to the path of a Unix flat file. So, my archives are not segments of tape, but Unix files, one per archive. This sc…
Level-1 backup after level-0 using ontape
Hi! I use ontape -s to create archives in order to perform backups. I don't really use any tape device to make the archives. Instead, I have LTAPEDEV pointing to the path of a Unix flat file. So, my archives are not segments of tape, but Unix files, one per archive. This schema …
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…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
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 …
"Assert Failed: Temporary Partition used in archive has been corrupted"
HP-UX 10.20 IDS 7.22.UC1 The following happened on my level-0 archive this morning: ---------------------------------------------------- 12:30:59 Assert Failed: Temporary Partition used in archive has been corrupted 12:31:00 Who: Session(50989, informix@ndrmain, 5180, -607803…
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: Warm recover failure question
> But LTAPE parameter is '/dev/null'. I think the "Inconsistent Status" is > logically right whether the engine is restarted, or not. > I think so because the logical recovery cannot make the dbspace up to date.. > > Am I correct ?? You are partially correct. Without log backup…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
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…
DBA probems
Hi this is mukund ! I am doing backup thru ontape utility as follows ontape -s -L 0 everyday. (logfiles backup thru ontape -a is not done) Is archive level 0 backup without logfile backup thru ontape -a command is sufficient ? If not what is correct method ? Favor me with correct…
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: ISM and OnBar Users
Milton, Glad to hear you can use IECC, we don't use it because we can't get it to install on our NT Workstations. Too many network requirements prevent it from installing on our corporate network. Your problem is more related to the release of XPS 8.21.UD2, and not having the…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
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: Req. Informix Statistics (for Db Management)
dengelsen@my-dejanews.com wrote: > Hello, > > I'm a new Database manager. In order to check Informix i've created a > script that checks the following > > environment > diskspace (bdf) > dbspace (onstat > -dD) > tablespace (onstat -t) > logical logs (onstat -l) > messages (conso…
Re: ontape -a
Girish Kagrana wrote: > When U run the 'ontape -a' command on same tape for 2nd time, > will it append th the first backup or it will overwrite the > 1st time backup taken by same command > > Does the device name for eg. /dev/rmt0 or /dev/nrmt0 make diff. for that Yes, it make…
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: Appending to Informix backup
WF Software wrote: > If you are trying to put Informix backups on one tape then, AFAIK, you > can't 'cos Informix always rewinds the tape. Not quite true. You can put multiple archives on a tape by setting TAPEDEV to a non-rewind device. The archive doesn't rewind the tape fi…
Re: Appending to Informix backup
WF Software wrote: > If you are trying to put Informix backups on one tape then, AFAIK, you > can't 'cos Informix always rewinds the tape. Not quite true. You can put multiple archives on a tape by setting TAPEDEV to a non-rewind device. The archive doesn't rewind the tape fi…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Archive level 0 stopped.
Milen Metodiev wrote: > > Hi! > > On the 4th tape of the archive (level 0) I stopped ontape program, because > all logical logs was full. The time for archive is a long, so I started > archive level 1 instead of archive level 0 again. So, my question is: will > my new archive (le…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Archive / Logical Log Backup To Disk
Sujit.Pal@alltel.com offerred: : Logical logs and archives can be done to tape or to disk using the : methods described in this NG. If they are done to disk, they are : **always** done to cooked file system space. The choice of using raw : space or cooked space is…
Re: Archive / Logical Log Backup To Disk
Glyn, Your right the OS can hold back writes to disk and cause you grief. But the advantages of not having to buy an extra tape drive and the much higher reliability of disk drives over tape drives far outweigh this. If the OS had not written out all the…
Re: Archive / Logical Log Backup To Disk
Glyn Logical logs and archives can be done to tape or to disk using the methods described in this NG. If they are done to disk, they are **always** done to cooked file system space. The choice of using raw space or cooked space is for dbspaces. HTH…
Archive / Logical Log Backup To Disk
I have been following this thread with some interest of late. I was always under the impression that if you backup to disk rather than tape then you are at the same risk as if you use cooked files rather than raw disk, i.e. (quoting from the Informix OnLine Ad…
Re: informix tape content
ANTS wrote: > > Hi, > > 1- Is there a way to tell the content of an Informix backup/logical log > numbers and so on?? Like the archive number? The backup tapes begin with a partly ASCII header that you can dump with dd (on UNIX) or other tape dump utility. The header specifies …
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.…
Mirroring and archives
We use Informix Online 7.22 on AIX. All of our chunks are mirrored (approx. 17Gb) and we perform a zero level ontape archive each week and level 1 archives daily. If there is a problem with the database and we need to restore from tape, can we restore to a machine without mirro…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Pb backup DB
When I backup databases I have this message. ----------------------------------------------------------------- Level 0 archive is 100 percent completed. date: Mon Dec 8 16:09:52 1997 Tapes required to restore the system to the state at the beginning of this archive: ^ ^ |-> W…
Backups
Hi there, I'm new to informix and unix, so if the question is vague sorry in advance. We are looking at the backup situation w/ the informix 7 . We have 2 tape drives rmt0 and rmt1. We would like to do a archive level 0 backup daily on rmt0 and run the continuos backup on rm…
Re: Informix backup/archives
In article <343E27B2.2FFC@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Allen Jantzen wrote: >> Is it a true statement that I will never need any logical log tapes >> that were written *before* my last level 0 archive? In other words, >> when I do a level 0 archiv…
Re: Informix backup/archives
On Fri, 10 Oct 1997, Allen Jantzen wrote: } Art S. Kagel wrote: } } > BTW and FYI I recently did a warm restore from an Archive taken on one } > machine to its sister machine. It worked great! One caviat: you } > cannot } > safely roll forward the logs when you do this because…
Re: Informix backup/archives
Mark Collins wrote: } > Is it a true statement that I will never need any logical log tapes } > that were written *before* my last level 0 archive? In other words, } > when I do a level 0 archive, I am getting essentially a snapshot of } > my database right then, so any logical …
Re: Informix backup/archives
Allen Jantzen wrote: > Is it a true statement that I will never need any logical log tapes > that were written *before* my last level 0 archive? In other words, > when I do a level 0 archive, I am getting essentially a snapshot of > my database right then, so any logical log tap…
Re: Informix backup/archives
} Is it a true statement that I will never need any logical log tapes } that were written *before* my last level 0 archive? In other words, } when I do a level 0 archive, I am getting essentially a snapshot of } my database right then, so any logical log tapes made *before* then…
another archive/backup question
I am using 7.22.UC1 ODS on an HP J200. and am testing a warm dbspace restore. When I do the "ontape -r -D testdbs" to restore my test dbspace, once it did the physical restore, it asked me if I wanted to restore log tapes. I had made absolutely no changes to the database or tab…
Informix backup/archives
I am using 7.22.UC1 ODS on an HP J200. I finally got the nerve to test a warm dbspace restore, and it has resulted in several questions: Is it a true statement that I will never need any logical log tapes that were written *before* my last level 0 archive? In other words, when …
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…
dbBRZ/Informix
Is there anybody using the SCH Technologies product called dbBRZ/Informix for archive and backup and how has been its performance ... Thanks in Advance for any information Munaf…
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…
Ask about On-Archive
Hi !!! I want to use On-Archive with On-Line 7.1, but I want to know one thing... Is it possible to put databases archive and logical-logs backup on one tape ? Is it possible to create two different vsets on one tape ? If somebody know answers, please help me. I'm waiting also …
Re: How do you turn off logginf in ODS?
ontape -s -L 0 -N databasename you may want to change your archive tape to /dev/null if you are not interested in a real backup and are looking to speed up the archive. To turn logging back on replace the -N with a -B Jorge :)…
Archive Timestamp
I'm trying to retrieve the timestamp of the last Online Backup and do no know how. I wonder if someone can help me. I tried doing a tbcheck -pr and got 2 time. According to the manual, 1. Real time archive began is the date and time of the last checkpoint and timestamp. 2. Tim…
Re: backup and archive
Larry Weissman wrote: > > > > > > > >Area: comp.databases.informix > >From: curtis@pencom.com (Curtis Preston) > >Date: 6 Feb 1997 06:35:24 GMT > >Reply-To: curtis@pencom.com > > > > > >In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" > ><jguzman@transre.com>, the…
Re: backup and archive
> > >Area: comp.databases.informix >From: curtis@pencom.com (Curtis Preston) >Date: 6 Feb 1997 06:35:24 GMT >Reply-To: curtis@pencom.com > > >In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" ><jguzman@transre.com>, the following was written: >> >>> Curtis Preston…
Re: Archive failed
In article <330393DE.CF8@ix.netcom.com>, "Robert D. Miles" <bm_cecs@ix.netcom.com> writes >I received the message > >Archive failed - function read archive backup failed code -1 errno 0 > >while trying to do a level 1 archive using "ontape -s -L 1". > >Does anyone know where the …
Archive failed
I received the message Archive failed - function read archive backup failed code -1 errno 0 while trying to do a level 1 archive using "ontape -s -L 1". Does anyone know where the backup is failing? Thanks for any help or hints, Bob bmiles@catmktg.com…
Re: backup and archive
In article <09970105221619.OUI28.curtis@pencom.com>, Curtis Preston <curtis@pencom.com> writes >In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" ><jguzman@transre.com>, the following was written: > >Wow, someone actually more paranoid than me. Cool! I agree, and >b…
Re: backup and archive
Any chance of seeing you script? Regards Silvester Valiente Informix/Ingres DBA TNT Australia Ltd (02) 9319 8545 curtis@pencom.com (Curtis Preston) wrote: >In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" ><jguzman@transre.com>, the following was written: >>> >>>…
Re: backup and archive
In Article<09970105221619.OUI28.curtis@pencom.com>, <curtis@pencom.com> writes: > Path: news1.neo.lrun.com!news-out.internetmci.com!newsfeed.internetmci.com!dciteleport.com!europa.clark.net!news.bbnplanet.com!cpk-news-hub1.bbnplanet.com!news.sprintlink.net!news-peer.sprintlink.ne…
Re: backup and archive
In article <32F219CB.7446@transre.com>, From "Juan R. Guzman" <jguzman@transre.com>, the following was written: >> >> Curtis Preston writes: >> >> I know that OFFICIALLY Informix does not support it, but have you >> ever thought of sending your archive logs to disk? It solves al…
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…
Re: backup and archive
Curtis Preston wrote: > > In article <32DD43D0.134C@hotmail.com>, From Valery Fouques > <valou@hotmail.com>, the following was writte > > > We are trying to use one tape drive for the archive and the log > > backup. > > I know that OFFICIALLY Informix does not support it, but hav…
Re: backup and archive
In article <32DD43D0.134C@hotmail.com>, From Valery Fouques <valou@hotmail.com>, the following was writte > We are trying to use one tape drive for the archive and the log > backup. I know that OFFICIALLY Informix does not support it, but have you ever thought of sending your a…
Re: tbtape reports wrong archive date.
In article <jlumbleyE46EAv.Iq9@netcom.com>, From jlumbley@netcom.com (Joe Lumbley), the following was written: > The date/time of the archive is actually the date/time of the last > checkpoint prior to the archive. Try running a checkpoint right > before the archive and you'll f…
Re: tbtape reports wrong archive date.
jlumbley@netcom.com (Joe Lumbley) wrote: >Mickey Mestel (mickm@infogain.com) wrote: >: boris, >: > Recently I've noticed that my archive utility reports wrong time or even >: > date of the archive done. I run tbtape -s from cron doing backup at >: > night and redirecting the ou…
Re: Ontape to Disk - HP_UX
There was a discussion on this very reasantly (within the last week). You should be able to find it at http://www.deajnews.com MGSCHORNHEUSER@FARMLAND.COM (Melissa Schornheuser) wrote: :We are currently running Informix 7.2 on HP_UX 10.01. We are using :ontape as our archive/b…
Re: tbtape reports wrong archive date.
Mickey Mestel (mickm@infogain.com) wrote: : boris, : > Recently I've noticed that my archive utility reports wrong time or even : > date of the archive done. I run tbtape -s from cron doing backup at : > night and redirecting the output msgs to a file. The system starts : > back…
Ontape to Disk - HP_UX
We are currently running Informix 7.2 on HP_UX 10.01. We are using ontape as our archive/backup utility. We are looking into writing our archives/ backups to disk and then using HP's Omniback product to write the archive/backup to tape. This will help us to manage our tapes wi…
Re: backup and archive
Ian Goddard wrote: > > Jane Johnson wrote: > >Date: Tue, 07 Jan 1997 14:15:05 -0800 > > > >We are trying to use one tape drive for the archive and the log backup. > >we wrote a script to do the backup log first, when this is done, do the > >archive. The probelm is that when to sw…
Re: backup and archive
Jane Johnson wrote: >Date: Tue, 07 Jan 1997 14:15:05 -0800 > >We are trying to use one tape drive for the archive and the log backup. >we wrote a script to do the backup log first, when this is done, do the >archive. The probelm is that when to swap the tape from log tape to >arc…
Re: backup and archive
Jane Johnson wrote: >Date: Tue, 07 Jan 1997 14:15:05 -0800 > >We are trying to use one tape drive for the archive and the log backup. >we wrote a script to do the backup log first, when this is done, do the >archive. The probelm is that when to swap the tape from log tape to >arc…
backup and archive
We are trying to use one tape drive for the archive and the log backup. we wrote a script to do the backup log first, when this is done, do the archive. The probelm is that when to swap the tape from log tape to archive tape without physically checking to see if the log backup ha…
ON-archive to disk
I am an ORACLE DBA that must write a functional backup of dbspaces by 12/06/96. My knowledge base is what I have read in the 'Archive and Backup Guide'. A sample script to handle a dbspace and to handle logical-log backups would be a great help. Thanks.…
Re: Automatic Backups
Thom Hadley wrote: | > Does anybody know how to perform a complete backup from the shell prompt. > I want to do automatic backups and I don't know how to force the return > after the prompt for the insertion of the backup…
Archive/backup issues
What are the best senarios and software to use for archiving/backing up Informix dbs running on Solaris or OSF? I would like them to be automated as best as possible. What are the common ways to do this?…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Backing Up SE - Questions
>The first chapter states "In general, every transaction log file must >have a corresponding archive copy of the database." I took this to mean that it was necissary to have a transaction log and database backup that are synched (i.e., one logfile=one backup). Not that you must…
Re: backup/recovery
I may not be quite undestanding your question. However, the examples you included in your note seem to indicate that you desire to backup specific Unix files. The tbtape (or ontape) utility is used to backup an instance of the engine (data) which is usually physically located i…
Re: Running tbtape from cron on AIX
SYSTEMS@br-media.ccmail.compuserve.com wrote: : : problem is the date on the archive is wrong. My backup from this : morning was dated yesterday (I did a restore yesterday). The backup : from yesterday morning was dated the day before that (The exact time : …
Re: Logical log backup and Archival of data
Clem Akins writes: -> ->} [...] ->} I would like to hear from people on the net about how they are backing up ->} their logical logs and the doing the archive of the data on one tape ->} device. I am sure there are quite a lot of you out there who have ->} done this. ->} ->} What…
Logical log backup and Archival of data
} [...] } I would like to hear from people on the net about how they are backing up } their logical logs and the doing the archive of the data on one tape } device. I am sure there are quite a lot of you out there who have } done this. } } What I am thinking of doing is to back u…
Logical log backup and Archival of data
Hi ! Please excuse me if the following is a FAQ. I would like to hear from people on the net about how they are backing up their logical logs and the doing the archive of the data on one tape device. I am sure there are quite a lot of you out there who have done this. What I a…
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…
Re: archiving strategies with OnLine 5
: In article <3rkqme$8n0@mojo.eng.umd.edu> mheinick@eng.umd.edu (Mark Heinicke) writes: : We have low-volume use and one tape drive available for archiving. Level : 0 archives with repeated logical log backups in between seem to have met : our archive needs; the one re…
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?…
Archive and Backup using Onarchive Utility
I am testing my archive and backup procedures. I am using level-0 to archive and backing up my logical log file #2 where the checkpoint is. The status in the utility shows "COMPLETED". I bring online to offline. I use the ondatartr utility to retrieve level-0 and backup and salv…
On-archive backups to DISK anyone??
We are also about to start using on-archive, and are just beginning into the development cycle of this project.... I am most interested in any doing backups to DISK using onarchive.... Please respond! Remember, My views do not reflect my company's , etc. Your mileage may vary, et…
Re: Lockups!
Informix Sysadmin (informix@asl3.asl-labs.bc.ca) wrote: : Nope...just various queries/updates...No tape action - archives backups or : otherwise. I'm obviously grasping at straws, but was anyone creating an index that they might have interrupted?…
Re: "Informix archive to tape system"
Shanthi Naresh (fbap4110@leonis.nus.sg) wrote: : I am looking for information on creating database archive using Informix : archive utility on tape cartridge systems. The database is expected to be : about 40-50GB on a HP T-500 system and conventional DAT tapes requires : operat…
Informix ON-LINE archiving
On Informix ON-LINE, is it posssible to automatically archive databases. Currently, you have to manually run tb-monitor and create an archive. Is there any way to write a macro or a cron to automatically backup the database at a certain time? Can anyone suggest any utilities …
Informix backup and archive
We currently run continuous logical log backup with our LTAPEDEV being a UNIX file. Nightly, we stop tbtape, perform an archive, change the LTAPEDEV to the new filename (with a $DATE extension), and restart tbtape. Does anyone have a script I could put in the cron that will do …