Oninit® Archive
Results for “ALARMPROGRAM”
Online log: Process exited with return code 255
Thank you All! The bug in the log backup script is fixed. Frank On Mon, Jan 27, 2014 at 2:44 AM, Marcus Haarmann <marcus.haarmann@midoco.de>wrote: > Hi, > > seems to me your perl script does throw an error when invoked by the > alarmscript mechanism. > I would suspect either pe…
Upgrade from 10.00.FC6 - 11.70.FC1
Hi, I added more chucks into the dbspaces, and ran the conversion again. Here is the latest message. Any ideas would be appreciated. 11:47:25 Succeeded 11:47:25 Converting Partition Header Page 284:2017. 11:47:25 Converting Partition Header from version 10.00 11:47:25 Succeeded…
How to configure alarmprogram.sh to trigger only on errors and replication failures?
Hello, The alarmprogram.sh is just a shell script. You need to look into it and tailor it to your needs. This script was meant to help you to have a basic example. You could enrich it the way you want by either adding things or adapting things to alter the way y…
LOG FILES
Eduardo: In your ONCONFIG file the ALARMPROGRAM parameter should be set to alarmprogram.sh. If you edit whichever file is set there, there will be a line: BACKUPLOGS=N Just change the "N" to "Y". If you are using ontape -s to make archives, then you also need to change this line:…
Extending chunk capacity
A couple more notes. If the server creates a chunk from a directory entry in the storage pool, as you know it will create a new cooked file in the directory and use it for the chunk. If its space is a regular dbspace we'll automatically mark that new chunk as extendable, so you s…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Logical Logs - Flags and backups
I see that you are using ontape to do the system archiving. Just make sure that the ALARMPROGRAM was changed to use ontape as well to back up the logs (the default in there is to use onbar). There should be a line: BACKUP_CMD="ontape -a" not BACKUP_CMD="onbar -b -l" You cannot mi…
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…
Repliction Checking
Dan, IMO not really much you can do other than rely on HDR/RSS faith along with instance monitoring (onstat -g dri , DRLOSTANDFOUND and ALARMPROGRAM). If really concerned consider periodic HDR refreshes if feasible. CDR has cdr check, maybe a feature request for something simil…
-951 trap
Folks, IDS 11.70 AIX 7.4 Is there any way/method etc. to trap for the following authentication error and send out an alert to security admins ? (other than greping the msg log ) 951: Incorrect password or user is not known on the database server. Preferably would like to have…
systemd centos7
Hi All, we configured systemd on CentOs7 to start and stop informix server 12.10.FC10. Im not sure of the type of the service so I tried oneshot, simple and forking. Informix starts in all cases. I see no difference. But we have an issue: If starting informix via systemd, the …
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…
transation logs problem
Hi, I have todo some frequent changes to database structure, on some customers the operation hangs because the transaction logs became full. I am using /dev/null for LTAPEDEV and configured alarmprogram script to do backups, is anything missing? There is any option to disable it…
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…
Backup Help
On your production server, confirm which script is called when a log backup event is called - perhaps it's using something other than alarmprogram.sh. Confirm this by checking the value of ALARMPROGRAM in the onconfig. Also confirm that LTAPEDEV on production is NOT set to /dev/…
LTAPEDEV
In the literature, I found Edit the ALARMPROGRAM script ($INFORMIXDIR/etc/alarmprogram.sh Set the BACKUPLOGS parameter within the file to Y. Change the backup program from onbar -b -l to ontape -a -d. but on our prod server, it is set to N. I went into the onconfig file, and the…
alarmprogram.sh errors
ALARMPROGRAM not executable? S.a. http://www.ibm.com/support/docview.wss?uid=3Dswg21635728 HTH, Andreas From: "STEVEN AB" <alexsuru1457@gmail.com> To: ids@iiug.org Date: 05.01.2017 10:28 Subject: alarmprogram.sh errors [38434] Sent by: ids-bounces@iiug.org Hi, good day,=20 …
Capture event of adding shared memory segment
Hi, IDS 12.10 FC4. I only want noteworthy event ( ALRM_ALL_EVENTS 0) But, It seems "adding a virtual shared memory segment " is not a noteworthy event, 16:42:36 Dynamically allocated new virtual shared memory segment (size 1000KB) 16:42:36 Memory sizes:resident:114076 KB, vir…
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)…
ALARMPROGRAM: Event Alarms Filtering?
Hello, IDS 11.70 I need to find out if there is a way to force ALARMPROGRAM not to trigger itself whenever certain types of events happen. For example, I am making dbexport backups of all dbs during night, and I need to temporarily stop ER. This event is with type WARNING and …
Process exited with return code 0
Frank, I do not see an error. The alarmprogram.sh script is provided by default in the $INFORMIXDIR/etc directory It receives 6 parameters and depending on the alarm, a different action is executed. In your case you are getting the following 6 parameters: *2 23 Logical Log 218…
IDS 12.10 on Ubuntu 14.04 LTS Server
OK, the only outright errors I see are when the logical logs fill the ALARMPROGRAM is being executed to back them up, but there was some problem. Most likely the default in the default ALARMPROGRAM is to use onbar to back up the logical logs and you probably did not configure any…
RFE request for session details during virtual shm
Thanks a lot, Jacques. From the manual page, SHMVIRT_ALLOCSEG it says that: alarm_level: Optional. An integer value from 1 to 5 that specifies the level of the event alarm to raise: 1 = Not noteworthy, 2 = Information, 3 = Attention (Default), 4 = Emergency, 5 = Fatal. The event…
Error Message in online.log file
The alarmprogram is returning non-zero. Art On Nov 1, 2014 5:58 AM, "André Luiz Rufino" <andre_rufino@msn.com> wrote: > Hy everyone, > I really don't know what is different in my environment now, but I since 3 > weeks ago my online.log always get the follow message > 07:45:54 L…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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 logs - push or pull?
Thanks for the responses. Personally, I wouldn't do it any other way than to use ALARMPROGRAM and push the logs to the storage manager as they fill. But I'm the "new guy" here so it helps to have other opinions to back up my decisions. Thanks.…
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.…
Alarmprogram
Hi, I have create a new alarm program and I have used cases from the original alarm program. I set cases 20,22 and 23 . I manage to reproduce alarm for the cases 22 and 23 BUT I didn't manage to reproduce an alarm for the case 20 which is "Logical Logs are Full" . I have stopp…
Alarmprogram
Hi, I have create a new alarm program and I have used cases from the original alarm program. I set cases 20,22 and 23 . I manage to reproduce alarm for the cases 22 and 23 BUT I didn't manage to reproduce an alarm for the case 20 which is "Logical Logs are Full" . I have stopp…
some questions about Art's utils3_ak to backup logical log to disk
os: redhat 5.x ids version : 10.uc3 Thanks to Art's tool utils3_ak to backup logical log to disk. I copy log_full.sh to $INFORMIXDIR/etc and modiy LTAPEDEV , ALARMPROGRAM according to the instructions. It work now! I have 2 questions about it 1. How to do the restore from the …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Initializing shared memory
Here is what I get if I don't set the FULL_DISK_INIT to 1: Fri Jan 18 07:24:06 2013 07:24:06 Event alarms enabled. ALARMPROG = '/opt/informix/etc/no_log.sh' 07:24:06 Booting Language <c> from module <> 07:24:06 Loading Module <CNULL> 07:24:06 Booting Language <builtin> from mod…
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,…
Interpreting event alarm messages
we are on 11.7.FC5 on AIX 6.1 seeing many instances of dynamic lock allocation - however, that is the only thing that gets written to the online log and the ph_alert table: "dynamically allocated 1000000 locks" however, the manual states that " if a thread attempts to acquire a …
alarmprogram.sh when LTAPEDEV /dev/null
2 dr-xr-xr-x 92 bin bin 8192 Apr 6 2011 /opt 61926 drwxr-xr-x 38 informix informix 8192 Sep 13 2011 /opt/informix 61927 drwxrwxr-x 4 informix informix 8192 Aug 13 09:34 /opt/informix/etc 83027 -rwxr-xr-x 1 informix informix 19932 Aug 4 2010 /opt/informix/etc/alarmprogram.sh head…
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 …
alrmprogram
On Tuesday, June 26, 2012 9:28:44 AM UTC-5, tom...@gmail.com wrote: > hello > > we recently upgraded from version 11.7.FC4 to 11.7.FC5 on AIX 6.1. > The scripts we use for the backups and alarms are the same (except for the new paths, of course) and we have ADMIN and PAGER set to…
Logical Log backup during L1 archive
Sorry, to clarify, logical logs are backed up continuously using a script called by ALARMPROGRAM. Oh hang on..the output from our ALARMPROGRAM script says "Logical log backup already running" for the period in question, once for each of the 5 logs filled. Hmmm…
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…
Re: HDR - Alarmprogram when down [26640]
I see this in the secondary's log: 10:58:04 Rollforward of log record failed. iserrno = 126 ISAM error 126 is bad rowid. I think that there is some corruption on the primary and it would be good to run oncheck -cDI there before you do anything else to check it out. What was in…
HDR - Alarmprogram when down
Our HDR is up and running onstat -g dry all looks good. Then it drops and on the primary server log we get this. 12:35:00 Maximum server connections 62 12:35:00 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 200, Llog used 236 12:38:35 DR: Send e…
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 …
event trigger/alarm
Hi, Folks, IDS11.50 FC8, Redhat Linux. I am going to narrow down which job peoridically caused IDS to add new memory segments. Basically, the plan is, whenever IDS is adding a new memory segment( as in the attached online log messge) , the event will trigger my script to take …
IDS Monitoring tolls
I'm administering a large number of IBM-DB instance under HP-UX, with version IDS 11.50, XPS, some DB2 databases. Today, I use HP-Open View (OVO) to monitoring. with this tool, I generate logs and alarm events via e-mail. My organization ask me if exist another monitoring tools…
backup logical log to directory automatically
:o) 1. Ensure : ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh 2. Ensure alarmprogram.sh has : BACKUPLOGS=Y BACKUP_CMD="ontape -a" Works for me :o) You modified ALARMPROGRAM to log_full.sh and changed alarmprogram.sh - i.e. log_full.sh will be called instead of alarmprogram.…
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…
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.…
Enterprise Replication event alarm code question
IDS 11.50.UC5 RHEL 5 We have the alarm program picking up event 71 for ER node disconnected and alerting through to our support system to go find out where the node went (network fault etc). The question is what is the event code to say "connected again"? I can't find it in the …
Automatic Log backup
I think I found my problem. ALARMPROGRAM parameter was pointing to the wrong path.…
out of virtual shared memory
We are running IDS 11.5FC6 on Solaris. Today memory consumption started increasing on our production database and within few minutes it reached the shmmax limit. We found message in online log "out of virtual shared memory", so we restarted the database instance. There were a lot…
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…
Logical Log Files are Full -- Backup is Needed
After changing the ALARMPROGRAM in $ONCONFIG to /usr/informix/etc/alarmprogram.sh it works. Now I am not getting the message "Logical Log Files are Full - Backup is Needed". Thank you all Kanti…
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…
Alarm for New virtual shared memory segment
Hello, I was wondering if there is any way for Informix to alert us if it "Dynamically allocated new virtual shared memory segment". I tried getting the ALARMPROGRAM to alert, though it seems that this action does not trigger the ALARMPROGRAM. Any ideas? 16:17:26 Requested s…
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…
alarmprogram.sh
Good Morning My Informix dbs are all IDS 10FC4 and my alarm program in configure with the following parameter: ALRM_ATTENTION=3 In order to identify an issue the Im having with some particular session that is causing a excess of additional shared memory segments I would like t…
Informix and Commvault
Thanks for the response Ralph, I am not clear as to what role the ALARMPROGRAM plays here. Our alarm program is a pretty standard one, simply controls how errors are handled - who gets emailed etc. Does Commvault rely upon ALARMPROGRAM? Regarding the job being registered - does…
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…
IDS 7.13 Monitoring tool
Is there any event ALARM program comes with informix 7.13 for monitoring Database server. What are the software/application that I can use to monitor our Database server health which is running on HP-UX 10.01. Please help me.…
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…
alarmprogram! how to trigger
Hi, sorry for such very basic question, but I am feeling desperate as I am unable to test how can we use alarmprogram. We want to use alarmprogram for routine monitoring, but it seems that alarmprogram.sh is not triggered so script written in it does not get executed. Here is the…
alarmprogram.sh on deleted enviornment scripts
Hi, Last night someone accidently deleted the files on "/" directory. So envionment scripts for Informix instances, soft links and some other files are deleted. The instances were ok and application was able to read write in the databases, but CPU load was very high. We found tha…
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 …
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…
log_full.sh exit with code 163
what is the value of ALARMPROGRAM parameter? can you show that script. ________________________________ From: Mockey Chen <mockey.chen@nsn.com> To: ids@iiug.org Sent: Wednesday, January 14, 2009 1:39:45 PM Subject: log_full.sh exit with code 163 [14516] Hi, I saw online.log so…
Looking for comprehensive list of all IDS event class id and message parameters with associated severity
Does anybody know where I can obtain a comprehensive list of all of the IDS version 11.10 event class id and message parameters WITH the associated severity in regard to the alarm program? I have the separate lists, just need to know that what each individual CLASS ID has for a…
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…
Audit Logs
If you have your own ALARM script, try trapping *all* alarms, including the 'message' ('info'?) type and just dumping the text to a file in /tmp. There *might* be a 'message' type that shows switching audit logs. -- Bob -------------- Original message -------------- From: "Fern…
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.…
Using log_full.sh for running ontape -a
Hello, IDS 11.10 FC2W1, solaris 10 V490, 16 GB RAM, 4 dual core processors On my test server i have set the ALARMPROGRAM to the path of log_full.sh script and in that script i have set BACKUP_CMD="ontape -a -d" (backup using directory feature). i have been observing the logical…
onmode -cuky not working
Thank you Nilesh ! but the worst thing had already happened and dont know why and what exactly went wrong. tried to work with logical log backup using directory feature of IDS 11.10 and making it run through alarmprogram on my test server. i have edited the alarmprogram ( not su…
Info req "ontape -a backing up of logical logs"
Hello, i tried the logical log backup to directory feature, it works but with a contrain that the logical log directory should be on the same server where restoration is initiated. it did not worked for remote restoration :( Pls help me with the ALARMPROGRAM setting as i intend …
RE: alarmprogram.sh for IDS 7.31
LARRY SORENSEN wrote: > Where, exactly, were you able to find the scripts? > There are several packages of such scripts in the IIUG Software Repository (www.iiug.org/software). Among these are: alarm - a package or Perl scripts alarm_space - a package of shell scripts a a PP pr…
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…
Feature request (minor but useful)
We've just had our (very) occasional mad allocation of extra V- segments. 7 allocated over a 10 minute period, and the only indication as far as informix is concerned is a one-liner in the online log. It would be nice if it could trigger an ALARMPROGRAM event - a new class code w…
Restore from Tape Failed
When you are doing the restore it is trying to write at byte position 931971072 (455064 pages) into chunk 7. The problem is the file associated with chunk 7 does not exists (errno = 2). I would locate which chunk is associated with chunk 7 and sure that it exists and is large eno…
Erroneous event alarm 7 "Initialization failure"
Just a gripe, really - a little while back our alerting system raised the above alarm (via ALARMPROGRAM) and initiated a callout, and all we found was "WARNING! Physical Log size 15000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physic…
Performance Question - Loading of Database and LTAPEDEV
I have a question regarding LTAPEDEV being set to /dev/null and performance, and will not have a chance to test until tomorrow. During a mass load process, will having LTAPEDEV set to /dev/null increase performance significantly over having LTAPEDEV go to a disk file backup trig…
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…
RE: error on initilization
Execute:User root:# ipcs -ma send tha exitThe freedom of Linux ... The power of InformixDate: Tue, 15 May 2007 16:30:29 -0400From: yunyaoqu@gmail.comTo: heathn@infobase.co.zwSubject: Re: FW: error on initilizationCC: informix-list@iiug.orgYou already have a instance running or th…
FW: error on initilization
_____ Hi this is after a restore ? Can anyone help ? Thanks Heath Zimbabwe Tue May 15 09:29:23 2007 09:29:23 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 09:29:23 Booting Language <c> from module <> 09:29:23 Loading Module <CNULL> 09:2…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Re: return code for onbar backups
Thank you very much for the concise and thorough explanation Martin. I am assuming, based on your explanation, that the reason I get a Return code of 127 on the 10.5 instance, instead of a 1, is simply due to the different interpretation that the engine gives to the onbar return …
Re: return code for onbar backups
Hi, OK. Your IDS Version is not quite the newest ... :) There were a couple of things in the area that got fixed in the meantime. That is why the messages are, well not so straight forward to grasp in the old version. :-( You are doing whole system backup (denoted by the "-w" i…
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…
Alarmprogram & Dynamic Server resource overflow:Locks
Hello All We have alarmprogram turned on but unfortunately, when the Server runs out of locks we recieve hundreds or even thousands of emails stating so - " Attention! : Dynamic Server resource overflow: 'Locks'." Is there a way to configure the alarm so that we get a limited …
Informix KAIO Error
Hi people !! I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO initialization. Following the online.log Tue Jul 4 08:57:38 2006 08:57:38 Event alarms enabled. ALARMPROG = '/sgbd/informix/etc/log_full.sh' 08:57:44 DR: DRAUTO is 0 (Off) 08:57:44 Informix D…
Lock Table Overflow
Get my package utils3_ak from the IIUG Software Repository and compile and install the eventalarm.c in ALARMPROGRAM instead of log_full.sh. It will handle multiply occurring events like the lock table overflow event by ignoring all by the first to arrive in a given configurable p…
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/…
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…
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
It means you have ALARMPROGRAM set to log_full.sh but do not have onbar setup correctly so it is returning an error exit code which the script is returning to IDS. The code is being misunderstood by the oninit process and reported. If you want to back up each logical log as it f…
Re: Need Help with recovery of 7.31
"Superboer" <superboer7@planet.nl> schrieb: >ahum most likely in log_full.sh which is configured as >alarmprogram in $ONCONFIG. > >having this is a recept for disaster... Please explain. What's wrong with calling "ontape -a" from log_full.sh? Regards, Richard…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Shared Memory not Initialized for INFORMIXSERVER on Informix IDS 7.31
For more informatio in my Log file appears: 09:23:21 (3) failure, system out of semaphores 09:23:21 Dynamically allocated new message shared memory segment (size 352KB) 09:23:21 Requested shared memory segment size rounded from 344KB to 352KB 09:23:21 Requested shared memory seg…
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: Process exited with return code 142: -logical logs [5300
FYI, if you DO want the ALARMPROGRAM to archive your logical logs as they fill, you can get my package, utils3_ak, from the IIUG Software Repository it contains a replacement log_full.sh that uses ontape and a alternate executable ALARMPROGRAM eventalarm which not only archives t…
Re: Process exited with return code 142: -logical logs [5300
You did not change the ALARMPROGRAM entry in the ONCONFIG file. It is pointing to the default value, log_full.sh, which tries to use onbar to archive logical logs as they fill. If you do not have onbar configured you will get this spurious 142 error in the MSG log every time a lo…
Process exited with return code 142: -logical logs
Hi All, thanks for UR support in this issue . I have changed the ALARMPROGRAM to no_log.sh . It is running fine without error. thanks for UR support. regds, Rao "ART KAGEL, ...." <KAGEL@bloomberg. net> To Sent by: ids@iiug.org forum.subscriber@ cc iiug.org Subject Re: Process…
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…
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'?…
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: 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…
cannot initialize root dbspace
$ 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 server run modesucceeded Reading configuration file '/informix/etc/on…
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: Reg Informix Alarm events.....
On Wed, 23 Jun 2004 10:09:56 -0400, Rajasekaran, Rajesh wrote: Check out my package utils3_ak contains my alarm program executable source eventalarm.c It is configured to handle most critical events out of the box and adding handling of lower priority events is trivial (support…
Reg Informix Alarm events.....
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_01C4592A.D26B7E18 Content-Type: text/plain; charset="iso-8859-1" Hello all, I have a requirement to track some of th…
Re: Error with OnBar on NetBackup.
Yes, you can confirm your ALARMPROGRAM variables by placing an "env > env.out" inside your ALARMPROGRAM script and running the script by manually switching to the next logical log with a "onmode -l" command. The basic steps for connecting an Informix instance to Veritas' NetBack…
Re: Error with OnBar on NetBackup.
"Brice Avila" <briceavila@hotmail.com> ha scritto nel messaggio news:c46e3ec5.0406110620.4752244a@posting.google.com... > What version of NetBackup? 4.5GA > NetBackup usually relies on the ALARMPROGRAM (usually > $INFORMIXDIR/etc/log_full.sh) file to backup the logical logs. If…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
RE: Do I need more KIO's
You shared buffer pool is extremely small: 6000 pages -> 12MB (with 2k page on SUN and HP) This is why You have such a high I/O activity. How much RAM do You have in Your server? ------------------------------------------ Alexey Sonkin > -----Original Message----- > From: Tugge…
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,…
alarmprogram.bat and ontape
In alarmprogram.bat, I set: SET BACKUPLOGS=Y SET BACKUP_CMD=ontape -a the onconfig file has ALARMPROGRAM C:\\PROGRA~1\\Informix\\etc\\alarmprogram.bat When the logs filled up, the log file showed 15:38:44 Logical Log Files are Full -- Backup is Needed but a backup did N…
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.…
HDR Replication and event alarm log backup
Hi Folks, I got replication up and running finally. The process was as described in the manuals and everything looks good for now. The on bar alarm program ( /etc/log_full.sh ) which backs up the log files when they fill up is failing though. The message is: 07:46:47…
Re: Log Message - Retun code 142
On Thu, 18 Sep 2003 19:55:22 -0400, KalpanaPai wrote: <SNIP> > Message Log File: /usr/informix/online.log 11:52:03 Logical Log 1278 > Complete. > 11:52:04 Process exited with return code 142: /bin/sh /bin/sh -c > /usr/informix/etc/log_full.sh 2 23 "Logical Log 1278 Complete." …
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…
Alarm program on IDS9.30UC1
abdoell@yahoo.com (abdoell) wrote: Hi abdoell, > Dear All, > I have a problem, I have installed alarm program on my IDS9.30UC1 > running on Solaris 8, but it never work ?, I have using script that > work fine on my IDS7.31, when installing on IDS9.30UC1 no response at > all ? …
ALARMPROGRAM
My production instance is no longer calling the ALARMPROGRAM. This is = causing the logical logs to no longer get backed up. What can I do to get the instance to call the = Alarm script? It's worked in the past. Btw, this is ids 9.30uc3 on Sun Solaris 8. Terrence Mullins=20 www.…
Enhanced ALARMPROGRAM for backups
Hi There, I want to be able to create a new file for every log backup switch. I was thinking of doing the following 1) have the script use perl:dbi to get current log number 2) run the ontape -a 3) copy the file to contain the log_number 4) touch a new file for LTAPEDEV 5) have…
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…
Fw: alarmprogram.sh
Thanks Markand Brice, we'll work on it.. Regards ----- Original Message ----- From: "Mark D. Stock" <mdstock@MydasSolutions.com> To: "Sadi G�rsoy" <sadi@login.com.tr> Cc: "IIUG" <informix-list@iiug.org> Sent: Thursday, June 05, 2003 1:06 PM Subject: Re: alarmprogram.sh Sadi G�r…
Re: alarmprogram.sh
Sadi G�rsoy wrote: > Hi all, > Our platform is: > IDS 9.40 FC1 > AIX 5.2 > > We want to modify alarmprogram.sh. We want the program to work like > ontape -c. That is, when one logical log becomes full, we want it to be > archived, not wait until all logs are full. The default al…
Long transaction problem!!
Today I had a problem with a Long transaction that blocked production db for 20 minutes, Actually I detect de LTX with the ALARMPROGRAM, but I would like to detect before this appear in order to prevent it, transactions to be candidates for a Long transaction. Does anyone know h…
Database events!!
Hi Friends!! I'm already using the ALARMPROGRAM to check the events in my database and it work, but actually an "I/O read chunk ... page num ...errno 5" appear in my online, not the same as error 11 "Cannot open chunk" because also it work, does anyone know how to monitoring thi…
Fatal error asfcode = '25507'
Hi! I have a problem to initialize my informix 9.30 on linux(red hat 7.3 on intel) it is a freshly installed 9.30.UC2E3 with a demo licens. This message is all that i get when i start the ids: oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507'.…
Ontape - Onbar - Ontape
Hi Guys, I've been working with this problem since 1 week ago, we have a Storage Manager that was Set up last month, before this we used ontape to make full backups and for logical logs, the software(Legato) was configured on the server and then we migrate from ontape to Onbar .…
ALARMPROGRAM and Linux IDS 7.30.U
Can't get an alarm program to work with my linux IDS 7.30.U I took an INFORMIX SA class and it worked fine there using solaris IDS. I created a cheap little perl script like so ... #!/usr/bin/perl open(ALARMERR,">> /home/dja/rpt/alarm.err"); print ALARMERR join("\\n",@ARGV),"\…
Re: 7.31 performance problem
Embedded in the post are the main things I see. The last one is the most important. In article <Pine.GSO.4.30.0012191456560.18042-100000@loisto.uwasa.fi>, <SNIP> > > Segment Summary: > id key addr size ovhd class blkused blkfree > 41476 1381517313 …
Re: Paging
Jay, I use a modified ALARMPROGRAM to page/e-mail the DBA staff when any Informix problems occur. John John F. Coyle Senior Database Administrator Yankee Candle Co. jfc@yankeecandle.com >>> Jay Singh <jsingh87@hotmail.com> 12/05/00 10:55AM >>> I would like to setup a paging s…
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…
Automated Backups using ALARMPROGRAM
Hi, I am trying to set up automated backups of our Informix Database using an ALARMPROGRAM. We are running Informix v. 7.22 on HPUX 10.20 and have been using OnArchive to perform manual backups of the logical logs. I have followed the steps in the documentation that we have to s…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
RE: Whence cometh these log backups?
Your ALARMPROGRAM is set to the log_full.sh script. Unless you have modified it, this script will automatically invoke an "onbar -l" every time a logical log completes (fills). Since you are already using "ontape -c" to backup your logs continuously, I'd suggest setting your AL…
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…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: Informix initializing in Linux.
From: "Marcos Alves" <marcosaoalves@ig.com.br> > >I'm try to install Informix IDS 7.3 in Linux Red Hat 6.2. The installation >was all OK. But, when I try initializing the database with oninit command, >I receive the message below: > >Event alarms enabled. ALARMPROG = '/usr/inform…
Assert Failed: semop: errno = 36
Looks like you may have a sweeper in a cron that removes shared memory segments or semaphores! Have your ALARMPROGRAM script run: ipcs -a and output to a file and compare the report in one you took the evening before. If any of the informix owned segments are missing bingo now…
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…
Error 139 in logical log backup (resubmitted with additional info)
ram wrote: Neil, you misunderstand Pierre's problem. He, like many, did not know what to do with the ALARMPROGRAM parameter in the ONCONFIG file and left the sample value of $INFORMIXDIR/bin/logs_full.sh which is an example alarm event handler script that only handles the log f…
Re: tuning questions
Allen Jantzen wrote: [SNIP] > I cannot seem to get my onstat -F LRU write / Chunk Write ratio > any higher than 1:1 or 1.5:1. During the day my checkpoints average > only 3-4 seconds: > > 08:04:01 Checkpoint Completed: duration was 4 seconds. > 08:09:04 Checkpoint Completed: …
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?…
Re: IDS Alert -> Mobile Phone Text Message
Mr Creosote Most mobile phone or pager companies have a website from which you can "email" pages to them. The one we use (Skytel) even has a mail-to-page interface, so if your pager number was 12345678, then you could email your pager at 12345678@skytel.com. We use this feature …
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: IDS Alert -> Mobile Phone Text Message
You could check out www.genie.co.uk. They allow you send an email to somebody@sms.genie.co.uk and have it land on their phone. Most of the time it's okay, but it can be slow slow slow sometimes. As in: a day late (did I mention that they use Informix :-) If you need the message…
Re: IDS Alert -> Mobile Phone Text Message
From: Mr Creosote <glynboNOglSPAM@lineone.net.invalid> > >I am aware that there are systems out there that have been set >up such that when an event is detected by the ALARMPROGRAM it >pages an administator. I am UK-based and would like a similar >mechanism but have the ALARMPROG…
IDS Alert -> Mobile Phone Text Message
I am aware that there are systems out there that have been set up such that when an event is detected by the ALARMPROGRAM it pages an administator. I am UK-based and would like a similar mechanism but have the ALARMPROGRAM send a Text Message to a mobile 'phone (porbably via emai…
ALARMPROGRAM
Hi, Can the alarmprogram be used if LTAPEDEV is set to /dev/null? This is a portion of my onconfig : Diagnostics MSGPATH /opt/informix/log/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /opt/infor…
RE: Blocked:DDR
That's what I had thought initially, but when I looked at onstat -g act only the polling threads were active. It couldn't have been that easy, experiencing a problem that I had just read about in the news groups. It's seems to be fixed, I just wish I knew what caused the proble…
Re: Blocked:DDR
Andrew: If you were to look at the active threads running, onstat -g act, you might notice that CDRGeval# threads are consuming a sh*% load of CPU time. This was a bug in prior versions of IDS, ie. 7.30 family. It has to do with the sorting algorithm used by the evaluator thre…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
RE: onbar??
thank you! That is it exactly...our LTAPEDEV is /dev/null and ALARMPROGRAM is log_full.sh and I guess should be no_log.sh... and no, we dont back up the logs... -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf…
onbar??
What this is telling you that onbar_d -l try to run. What that does is backs up your logical logs. Do you have logical log backups turned on or off? If your LTAPEDEV is set to anything else than /dev/null then when your logical log fills up informix will automatically kick off a…
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…
Can I set a directory or file as logical log tape (backup) device?
Darrel Davis wrote: > I'd like to set up continuous logging of logical > logs to a disk file. > > Any help or pointers appreciated. > Better to use an ALARMPROGRAM to backup each log as it fills. If you use onbar, Informix delivered a script, log_full.sh, that does this using …
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…
Oninit problems with IDS 7.31 on Solaris
After a new install, I try to run "oninit -ivy", it gets quite a ways through, then bombs during the following phase: Initializing Dicitonary Cache and Stored Procedure Cache ... cannot find message file. Check INFORMIXDIR and DBLANG.FAILED My INFORMIXDIR is set correctly, as …
Unable to start engine sometimes...
Howdy, I get this message sometimes and Informix "support" has not been able to give me an answer as to why...just guesses. If I reboot the server, it works 99% of the time. After the engine starts, I see no problems at all! Has anyone ever seen this before? SCO 5.0.4 OWS 7.20…
Serious oninit -i problem?
oninit -i produced the following lines in the online.log on Solaris 2.7 The bit about the unusable chunk doesn't look healthy to me! BTW, rootdbs is a symbolic link to a raw meta device i.e. /dev/md/rdsk/d30 Any ideas? Advice greatly appreciated. 17:19:19 Event alarms enabled.…
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…
More Info about Backups
Christian Schröder wrote: > > Hello, > i've got some examples for Backups of DB and Logfiles from Informix. > Know i want read more about this. OK Full Archive is done by > 'ontape -s -L 0', Logs will be saved with 'ontape -a'. > I already realized that there's a 'log_full.sh' bu…
RE: Informix 7.31 Event Codes
Event alarm codes are documented in the Administrator's Guide for Informix Dynamic Server (section 29 in IDS 7.3 manual). They are also shown in Appendix D of the Informix Administrator's Reference, September 1999. -----Original Message----- From: jaymond@communitycoffee.com [m…
Re: problem on initialization
Yes, I have the INFORMIXDIR environment variable. The system work very well before system crash. Chris McKay ���g��峹 ... >Do you have the INFORMIXDIR environment variable set when you run oninit ? > >Chris > >"W. J. Hsu" <wjhsu@pti.com.tw> wrote in message >news:88a6oa$h5f@netne…
RE: WARNING: A log backup is already running. Can't start another
If these messages are occurring at the end of an OnBar archive, there is nothing wrong. The last step in an archive rolls the current log file and then offloads it. The alarmprogram traps the message that the log file filled up and tries to start another OnBar session to offload …
WARNING: A log backup is already running. Can't start another.
Hello, I've two servers on same machine. Server A, Server B. I've two scripts: ALARMPROGRAM for server A and ALARPROGRAM for Server B. "Onbar -l" in server B run OK. But "onbar -l" on server A don't run. When this message ocurred, I test server with "onbar -u, onbar -g act, o…
Re: Shared memmory initialization
From: Manoj Narayanankutty <mnarayan@crosskeys.com> > > I am using Informix dynamic serrver version 7.31 on solaris 2.6. When I >am trying to reinitialize my shared memmory using oninit command, my >system gives an error >indicating fatal error in shared memory initialization. >…
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…
Shared memmory initialization
Hi, I am using Informix dynamic serrver version 7.31 on solaris 2.6. When I am trying to reinitialize my shared memmory using oninit command, my system gives an error indicating fatal error in shared memory initialization. The online.log gives the following message: 21:17:54 E…
Re: Periodic extremely slow ontape archives
Further to what Neil had said we have been advised that DLT tapes have a useful life of 5 years max after that they need to be replaced (you can tell the date of manufacture by the SH line on the back of the tape i.e. SH7 (1997) SH8 (1998)). We also suffer from long backups norm…
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…
RE: onbar question
Phillip, (1) Make two copies of the current log_full.sh script. Call them, for example, log_full_A.sh and log_full_B.sh. (2) In the log_full_A.sh script, insert some lines in the area where PROG, USER_LIST, and BACKUP_CMD environment variables are set. In that same place, inse…
RE: onbar question
I have a similar setup on one of my servers, i.e., 2 instances, same INFORMIXDIR, using ALARMPROGRAM to backup the logs (except that I'm using ontape -a to disk for the backups). I use a different ALARMPROGRAM script for each instance. And I don't leave any of the environment p…
onbar question
Hello, I have two instances of informix running on the same machine. Let's call them instance A & B. They have the same INFORMIXDIR but obviously different INFORMIXSERVER and ONCONFIG variables. Both instances are set to use onbar to automatically back up the logical logs whe…
onbar -l
Ron, I'm not sure who you are referring to as the "user". Anyway, this may be what you're after. Informix will generate an "Event Alarm 23" when a logical log fills up, if you have the ALARMPROC set to some shell script in your config. Informix will execute it for every EVENT AL…
FW:
In article <81ch3m$lg9$1@news.xmission.com>, Ron Schwingel <rschwing@ndsltd.com> wrote: > > Addition to last e-mail--- How does "ontape -a" work? > Can I use it automatically run "ontape" at certain time? > Can I run it cron on a periodic basis to backup Logical > Logs?? Try n…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
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…
Pb with initialization. System: SUN Solaris 2.6 Informix 7.31
Hello, I'm installing an Informix Dynamic Servr for the first time. I have a problem with initialization of Informix. When running 'oninit -iy' I have this message: "Cannot find message file. Check INFORMIXDIR and DBLANG" I have checked INFORMIXDIR, it's "/opt/informix" (good) …
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.…
watch stat
The easiest way is to write an ALARMPROGRAM that will notify you when the engine issues any alerts through it. In addition you will want to monitor the free space in the chunks by parsing the output of onstat -d or the sysmaster tables. That will take care of MOST of what you n…
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.…
How could I set up IDS 7.30 to send me an email/page me when it is shutting down?
I guess it has something to do with the alarmprogram/sysalarmprogram script. But I do not exactly how I could do it. Does anyone know if there is sample script out that would ask the dynamic server send an email or page someone when it is shutting down? Thanks! Bryan Chung…
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…
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…
25591:Transport control received an invalid connection address.
Hi, Thank you very much for pointing that out. :) Regards, Keith Art S. Kagel wrote in message <37613A6D.AF365FC5@bloomberg.net>... > >The problem is you have installed the engine in /opt/informix but the >ONCONFIG file still says to look for the ALARMPROGRAM in /u…
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…
Re: Re[2]: An alarm program from the online.log
> Yea, I'm thinking I could rsh to the other machines and check the > logs, or am I nuts? Don't ask me, you might regret it! :-) Why don't you write an event-handling script to e-mail/fax/page you and just install it on every box in the network? That *sort* of approach …
Re[2]: An alarm program from the online.log
Yea, I'm thinking I could rsh to the other machines and check the logs, or am I nuts? Thanks, Kevin ______________________________ Reply Separator ____________________________ _____ Subject: Re: An alarm program from the online.log Author: obnoxio@hotmail.co…
An alarm program from the online.log
Hi group! I am trying to write a script that will periodically check the online log for certain events, through egrep and awk, and eventually mail and page me. I checked the alarm program in /etc and would use it, but I need the program to look at several instances across the net…
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…
Shared memory isn't cleaned up after onmode -ky
The first thing I'd do is look at the log file to see if there is some error in the log. I'd then run oncheck with various parms to see if the db is corrupted and the engine couldn't be shut down for that reason. RG wrote in message <01be676c$3bb996e0$7b0501cf@rgriffin>... > > >…
ALARMPROGRAM
Hi, my Informix is 7.22 UC1 on HP 10.20 I do not want to use /informix/etc/log_full.sh as an alarmprogram because I have 4 informix server running on the machine. For each I have a shell script that starts ontape -c to a file on disk. (extra file for each server) I want to deacti…
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…
RE: OnBar/ADSM/IDS 7.3
What error message are you getting when backing up logs to ADSM? After upgrading from IDS 7.30.UC3X3 to ODS 7.30.UC6-1, we starting getting the following messages in our online.log: 07:55:45 Process exited with return code 255: /bin/sh /bin/sh -c /informix/7.30.UC6-1/bi /infxal…
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…
Re: [Q] Informix Server Panic Error ! (Help needed!!!!)
�̺��� wrote: > > Hi > > We are developing a message processing application > (, which should handle upto 200,000 messages/hr) > on Informix Dynamic Server for NT. [SNIP] Questions: 1) What are the contents of that af. file (af.9c41a)? They are normally the same as the …
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: Informix engine will not initialize
sda@arentfox.com wrote: > > I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am > recovering the database. The ontape -r runs fine. > > 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' > 08:50:26 DR: DRAUTO is 0 (Off) > 08:50:26 INFORMIX-OnLine Initial…
Re: Informix engine will not initialize
sda@arentfox.com wrote: > > I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am > recovering the database. The ontape -r runs fine. > > 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' > 08:50:26 DR: DRAUTO is 0 (Off) > 08:50:26 INFORMIX-OnLine Initial…
Informix engine will not initialize
I am running Online v7.22 on a HP 10.20 box. We lost a drive and I am recovering the database. The ontape -r runs fine. 08:50:24 Event alarms enabled. ALARMPROG = '/dev/null' 08:50:26 DR: DRAUTO is 0 (Off) 08:50:26 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 08…
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: infxalrm?
Larry Kemmerling wrote: [SNIP] > In the online log, I see: > > 07:36:40 Process exited with return code 137: /bin/sh /bin/sh -c /home1/informix/bin/infxalrm 2 23 "Logical Log 38613 > Complete." "Logical Log 38613 Complete." This is not an errno. Return code 137 is the result o…
infxalrm?
--Drove_of_Sheep_030_000 Content-Type: TEXT/plain; charset=us-ascii Content-MD5: j+i36o5oDaPTLkJxGmkZCA== Listers, I've checked the faq, the unofficial faq, and the TechInfo center's "Product Defect Query" for references to infxalrm. I've found no references thus far. The engi…
Re: Req. Informix Statistics (for Db Management)
Ditmar den Engelse wrote: > Are there more parameters that i must check on a day to day > basis in this script? > Where can I find userfull informix sys-admin scripts? > Ditmar, You may want to make use of the ALARMPROGRAM onconfig parameter which should point to a script that…
Re: alarm handler bug on OWS 7.22?
On 13 Oct 1998, ProzessDV wrote: > Here is a part of the ONCONFIG file: > > # Diagnostics > > MSGPATH /informix/etc/online.log # System message log file path > CONSOLE /dev/console # System console message path > ALARMPROGRAM db_alarm_prog # Alarm pro…
Re: alarm handler bug on OWS 7.22?
In article <19981013095206.04001.00000027@ng13.aol.com>, ProzessDV <prozessdv@aol.com> writes >Here is a part of the ONCONFIG file: > ># Diagnostics > >MSGPATH /informix/etc/online.log # System message log file path >CONSOLE /dev/console # System console mess…
Re: alarm handler bug on OWS 7.22?
Here is a part of the ONCONFIG file: # Diagnostics MSGPATH /informix/etc/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM db_alarm_prog # Alarm program path The event handler db_alarm_prog is …
event-alarm-error ?
I've got some problems with the event alarm feature of OWS 7.22. I have written an event handler and set the onconfig paramter correctly as I can see from online.log. Also, I can see from online.log that my event handler is sometimes (it depends on the event class) called by: /b…
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…
ON-Bar: automatically truncate logical logs?
Hi guys, On a Solaris box without tape drive, I would like to automatically send all my logical logs to /dev/null when they're full. Inside ONCONFIG, there is an ALARMPROGRAM which is set to log_full.sh. However, ON-Bar complains about some missing /usr/lib/ibsad001.so whenever …
Re: tuning questions
Allen Jantzen wrote: [SNIP] > I cannot seem to get my onstat -F LRU write / Chunk Write ratio > any higher than 1:1 or 1.5:1. During the day my checkpoints average > only 3-4 seconds: > > 08:04:01 Checkpoint Completed: duration was 4 seconds. > 08:09:04 Checkpoint Completed: …
Re: Any BAD effects
Richard Spitz wrote: > > insight@shabakah.com wrote: > > In doing continuous backup, you need a console, is there any bad effects if > > you run it through telnet? > > I did exactly that: Run tbtape -c in a NT telnet session. Then one late > Friday afternoon, the NT machine crash…
ALARMPROGRAM: bug in informix ?
OWS 7.2 on SCO UNIX: There might be a bug in executing the ALARMPROGRAM. Sometimes OWS calls the program via 1. /bin/shell /bin/shell -c ALARMPROGRAM ... and sometimes 2. /bin/shell -c ALARMPROGRAM ... You can see that in the message log file. 1. This does not work. 2. This wo…
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…
Re: Question: Continous Log
Mario, Continuos logical log backup needs a dedicated terminal. I usr 'automatic backup' of the logical logs instead. The log_full event alarm triggers the log_full.sh script in $INFORMIXDIR/etc. This script then can activate an onbar -l command. Hope this helps. Carl in Atla…
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: ALARMPROGRAM with return code 133
Martina Lang wrote: > > Hi! > > If you use log_full.sh as alarmprogram, every time a log gets full and a > log switch is made a onbar -l command is done (out of the script) to > perform a automatic backup of your log. logs. > > Return code 133 means "faild to load XBSA shared lib…
Re: ALARMPROGRAM with return code 133
Hi! If you use log_full.sh as alarmprogram, every time a log gets full and a log switch is made a onbar -l command is done (out of the script) to perform a automatic backup of your log. logs. Return code 133 means "faild to load XBSA shared library". I suppose you dont have a …
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…
Re: ALARMPROGRAM with return code 133
Kenneth Ma wrote: > > Hi all: > > We just moved to a new HP10.20 platform with Informix engine > 7.23.UC7-1. > Today is the first time a logical log file get fill. Following are the > messages in > online.log file: > > Logical File 4 Complete. > Process existed with return code 1…
ALARMPROGRAM with return code 133
--------------E84895DAC8BF2A6BEE59F495 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all: We just moved to a new HP10.20 platform with Informix engine 7.23.UC7-1. Today is the first time a logical log file get fill. Following are the messages in…
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…
Announcment of new utility package - utils3_ak
I have submitted my event alarm handler program and the simple script to backup logical logs to disk using ontape that were discussed last week. If you did not get that package directly from me and still want to give it a look it is now available in the IIUG Repository under: M…
Re: ontape for logical log backup
z. heavener wrote: > > 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. I have either a script or an executable ("C") either of which can be installed as t…
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: Trapping Informix Crashes ??'s
Glenn Travis wrote: > > You can set AFDEBUG=1, then start the instance. This will cause the [SNIP] > David Parent wrote: > > Wondering what tools DBAs are using to > trap Informix crashes (at any level, OS > or Informix). > > For instance, Informix crashes at…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Logical Logs
Hello, When I do a restore using ontape and then rollforward the L.logs . When finished with the Logical logs, the message into the logfile is "Logical Log nnnn Complete" where nnnn is The first log with which the rollforward started and not the last log which was rolled forward.…
Problem with kaio
I am having a problem bringing up my database for the first time. I am on a HPUX 10.20 running Informix version 7.20.UC2. I have verified that the asynkdsk driver is loaded and linked into the kernal. I have created the /dev/async node according to the release notes and I contin…
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…
Backup strategy with Onbar
Hello, I am currently working on an onbar/Omniback II 2.10 backup solution on an online7.23.UC4/HP-UX 10.20 system (datawahrehouse of ~20Gbytes). I would like to exchange information and remarks with somebody who has already implemented such a solution. Particularly about logic…
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: Question about ALARMPROGRAM
Yes I have done it. Works fine with a basic 'sendmail' of the output from your alarm script.…
Re: Question about ALARMPROGRAM
Sujit Pal wrote: > > Hello All > [cutting] > > So my question is: Has anyone done this sort of thing? Do you think = > (from your knowledge of Unix and event handling) that this is workable? = > If not do you have workarounds short of calling wrappers for each = > instance or wor…
Question about ALARMPROGRAM
Hello All The FM says that the script pointed by ALARMPROGRAM takes 4 arguments, = ie EVENT_SEVERITY, EVENT_CLASS, EVENT_CLASS_MSG and EVENT_FILE (aka See = Also). I have multiple databases residing on the same machine, so I need = the instance name as well to identify an alarm.…
(Fwd) Re: Re:ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
From ilist Tue Jan 27 15:33:41 1998 > Received: from skyserv4.med.osd.mil (skyserv4.med.osd.mil [199.10.65.6]) by rmy.rmy.emory.edu (8.7.1/8.7.1) with SMTP id PAA11700 for <informix-list@rmy.emory.edu>; Tue, 27 Jan 1998 15:33:40 -0500 (EST) > Received: from ae1266.med.osd.mil by…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
At 04:53 PM 1/26/98 -0800, Clem Akins wrote: }>Mark Collins wrote: }[...] }>> It seems that for some reason, under 7.23.UC6 at least, that a blank }value for ALARMPROGRAM }>> may cause the engine to default to $INFORMIXDIR/etc/log_full.sh, whether }you want it or not. }>> Rememb…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
David Williams wrote: > > In article <34CCDE21.64D4@bellsouth.net>, W. H. SMITH > <carlson1@bellsouth.net> writes > >Right here . . . we upgraded from 7.13 to 7.23 and that was one of the > >first things I noticed; it really cluttered up the online.log. > >Unfortunately, the no_l…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
Clem speaks . . . } The release notes for 7.23 mention bug #67335, described as "ONCONFIG.STD } ALARMPROGRAM SETTING INCORRECT." At the moment I'm web-impaired, so I'll } leave it as an exercise for the reader to research more about that bug. } I'll check it out . . . never kn…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
>Mark Collins wrote: [...] >> It seems that for some reason, under 7.23.UC6 at least, that a blank value for ALARMPROGRAM >> may cause the engine to default to $INFORMIXDIR/etc/log_full.sh, whether you want it or not. >> Remember, I said I left the ALARMPROGRAM blank in the onco…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
At 07:06 PM 1/26/98 GMT, W. H. SMITH wrote: }Mark Collins wrote: }> }> > No help there errno 5 is the dreaded generic "I/O error". Anyway there }> > are three problems here: }> > }> > The first problem (at 14:43:33) looks like a failure of a pipe }> > connection. This is either…
Re:ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
Mark, This happens to be a known "feature" in Informix ver 7.23 UC1 onwards. If you do not want the ALARMPROGRAM to kick in, you need to set it to "no_log.sh", as you rightly did. Sujata ____________________Reply Separator____________________ Subject: ALARMPROGRAM (was D…
Re: ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
In article <34CCDE21.64D4@bellsouth.net>, W. H. SMITH <carlson1@bellsouth.net> writes >Right here . . . we upgraded from 7.13 to 7.23 and that was one of the >first things I noticed; it really cluttered up the online.log. >Unfortunately, the no_log.sh was the only way to go. It …
ALARMPROGRAM (was DSA 7.22 UC1 on HP-UX 10.10 Crash )
> No help there errno 5 is the dreaded generic "I/O error". Anyway there > are three problems here: > > The first problem (at 14:43:33) looks like a failure of a pipe > connection. This is either a bug or someone/something destroyed a pipe > connection. > > The second problem a…
Re: DSA 7.22 UC1 on HP-UX 10.10 Crash
In article <34C7B3AD.263E@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >David Williams wrote: >> >> In article <34C636BC.282E@mcmail.com>, Paul Watson <watson@mcmail.com> >> writes >> >Timothy Jones wrote: > >> >> 14:29:53 Checkpoint Completed: duration was 4 sec…
Re: DSA 7.22 UC1 on HP-UX 10.10 Crash
David Williams wrote: > > In article <34C636BC.282E@mcmail.com>, Paul Watson <watson@mcmail.com> > writes > >Timothy Jones wrote: > >> 14:29:53 Checkpoint Completed: duration was 4 seconds. > >> 14:34:33 nsfpipe.c, line 2028, thread 19, errno=5, spipe error. > >> 14:34:34 in…
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…
Re: Replication Error : HDR,
In article <68tu49$852$1@gte1.gte.net>, Hitesh Dave <davehit@vsol.com> writes >Hi folks, > > We have informix ver 7.23 running on solaris 5.5.1. We have two >informix instances configured in data replication pair (HDR). > > When we tried to build new indexes on couple of tabl…
RE: alarmprogram
David, Have you been able to get the branch of the case statement for Logical Log Complete to work correctly. Whenever the alarmprogram is executed on my instances, there are no values for Curr_Pct or Max_pct when the alarm program is executed. If that branch of the alarmprogr…
Re: alarmprogram
I use it with great success. The only "trick" (and it isn't much of one) is to identify which errors you want to be notified of and which can be simply ignored or stored for later use. The doc will tell you (on 33-8 or so in mine) what all the values are for severity and class …
Re: alarmprogram
I've used the alarm program extensively, and I've found it invaluable. At first, it's a bit trial-and-error, but once you get a polished program it can be a life saver. The keys are to know which messages to ignore, and to know how to distinguish what messages you need to know …
alarmprogram
Was wondering if any one had used the ALARMPROGRAM parameter with any success. I currently have a script which will use the command line parameters have not had any use for the messages received. Also when an exception occurs the script will be called many times , is there an…
Re: log_full.sh script exits with code 139
I just dealt with this -- In our distribution IUS 9.12UC3 on IRIX 6.4 there is a no_log.sh script in the etc directory, replace the ALARM_PROGRAM entry with the full path to no_log.sh and that should do it. We just made that change, and we have not had a problem in 2 hours! Da…
Re: log_full.sh script exits with code 139
Hitesh Dave wrote: > > Hi Everybody, > > We are running sun solaris 5.5.1 with Informix 7.23. > > I am seeing following messagaes in my online.log file. > > 11:26:25 Checkpoint Completed: duration was 1 seconds. > 11:27:15 Logical Log 1701 Complete. > 11:27:18 Process…
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…
Informix wg server 7.20.uc2 on SCO 5.02 halts with 25580
I'm installing informix online workgroup server 7.20.uc2 on SCO 5.02. As recommanded by Informix, I've modified kernel parameters and relinked the kernel. Installation have completed but when I launch oninit, the systems replies : oninit: Fatal error in initializing ASF with 'ASF…
Re: Error in shared memory initialization
At 10:18 AM 10/15/97 -0400, you wrote: >I initialized my online 7.2 on Solaris 2.5.1. Then I tried to add >dbtempspace and logical logs. Now when I do oninit it gives me the error > >oninit: Fatal error in shared memory initialization >The online log says >10:16:26 Event alarms …
ODS hangs on startup
Since I've upgraded to ODS 7.2, I've had this nagging problem when I bring the engine down and then restart it. It hangs on the way to quiescent mode. The log indicates event alarms enabled, then three VP processes start, then nothing. I control-c out of the process, take th…
Shared Memory Initialization
I initialized my Online 7.2 on Solaris 2.5 successfully. Then I tried to add logical logs and temp space and now it does not initialize. Any ideas? oninit: Fatal error in shared memory initialization 10:16:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarm.sh' 10:1…
Error in shared memory initialization
I initialized my online 7.2 on Solaris 2.5.1. Then I tried to add dbtempspace and logical logs. Now when I do oninit it gives me the error oninit: Fatal error in shared memory initialization The online log says 10:16:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alar…
Problems installing Informix DS on ScoOpen 5
I'm running a ScoOpen 3.2v5.0.2 and I have installed an Informix Online DS 7.22.UC3. The installation went ok, but when I run the command : oninit -iy I receive the error message : oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '- 25580'. $ The lo…
ALARMPROGRAM
In my ALARMPROGRAM, I tried to modify the Log Complete part of the case statement, to page me if the logs where greater than a certain percentag full. It is not working. The alarm program is called, and this part of the case statement completes, but the page is never sent. I p…
OnLine 7.20 problem
We have Informix ODS 7.20 UC2 on machine: HP9000 K260, HP-UX 10.20. The onconfig was copied form onconfig.std to the new and names were changed. The ROOTPATH is a cooked file. I initialized online 7.2 oninit -i and database engine not started. I get the following in the log: 1…
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…
Online hangs during oninit after reboot.
Folks, Sorry I should have provided a few more details initially. Here is the squence of events: 03:00 1. We shut down the engine with onmode -ky (probably no users present) 2. The RS6000 box is rebooted. 3. We restart the engine with oninit It during step 3 that the onli…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Event Alarms
Felix Koshy Mathews wrote: > > In <33B7F989.2C97@arrowintl.com>, Chad Laity wrote: > >Does anyone out there have an event alarm that warns you via > >email when the logs are a certain %age full?? > > > >I tried to alter the script logevent.sh to accomplish this but > >it did not …
Re: Event Alarms
In <33B7F989.2C97@arrowintl.com>, Chad Laity wrote: >Does anyone out there have an event alarm that warns you via >email when the logs are a certain %age full?? > >I tried to alter the script logevent.sh to accomplish this but >it did not work. > Chad, You have to add the follo…
Event Alarms
Does anyone out there have an event alarm that warns you via email when the logs are a certain %age full?? I tried to alter the script logevent.sh to accomplish this but it did not work. Thanks, Chad Laity mailto:chad_laity@arrowintl.com…
Re: Do alarms work in 7.20 ?
ctreptow@aol.com wrote: > > Hi. I am trying to write an alarm program for Informix, but it doesn't > appear to work. We are on HP-UX 10.01 running Informix Online version > 7.20. I have written the following script, but it doesn't ever appear to > get called by Informix. Acco…
RE: event-alarms
---------- From: Stuber[SMTP:sstuber@intrlnk.com] Sent: Thursday, August 15, 1996 3:22 PM To: informix-list@rmy.emory.edu Subject: event-alarms The Administrator's Guide (7.1) states "When any of the events in a = predefined set occur, OnLine invokes=20 this executable" wher…
Re: event-alarms
Hi, There was an articule in our last user group newsletter on Alarms which has an example of how to use Alarms. You can view it at our user group web site www.access.digex.net/~waiug Regards - Lester > The Administrator's Guide (7.1) states "When any of the events in a prede…
event-alarms -Reply
I don't have the answer to your question but basically everything which writes an alarm to the log will call alarmprog. It is a handy utility except that at present it doesn't work to well. If alarmprog gets passed a string longer than a predefined length (512 bytes?) then it wi…
event-alarms
The Administrator's Guide (7.1) states "When any of the events in a predefined set occur, OnLine invokes this executable" where "this executable" refers to ALARMPROGRAM. Is the "predefined set" referring to figure 33-2? In other words any event of a sort listed in that table wi…
Help! OnAutomatic backup using Informix...
Hello I work with Informix 7.10.UC1 on Solaris 2.4 I have a program that forks and execs ontape, communicates on a pipe to feed "return" to it and continues doing some other work. It needs to be informed when and with what status ontape completed. I tried using the event-al…
Help! OnAutomatic backup using Informix...
Hello I work with Informix 7.10.UC1 on Solaris 2.4 I have a program that forks and execs ontape, communicates on a pipe to feed "return" to it and continues doing some other work. It needs to be informed when and with what status ontape completed. I tried using the event-al…
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:Timeout in 4GL Programms
tvarnas@compulink.gr (Apostolos Varnas) schrieb : tv>I want to implement a timeout of a 4GL application from inside the tv>application.I tried to use alarm() but I found out that alarm() is used tv>internally from Informix and thus resetted after each keyboard stroke. tv>This po…
ALARMPROGRAM and Perl scrips
Has anyone been able to get the 7.x ALARMPROGRAM parameter to use or execute a Perl script, or something other then a 'sh' script?? OnLine doesn't like more then 1 argument specified in ALARMPROGRAM, and the engine invokes ALARMPROGRAM with '/bin/sh sh -c' I could have ALARMPROG…
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?…