Oninit® Archive
Results for “ALRM_ALL_EVENTS”
Not enough room in ROOT DBspace
It looks like your physical log is taking up most of your space. I would imagine that this was moved and grown in your other instance. Dan -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of STEVEN AB Sent: Wednesday, January 04, 201…
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
You can try setting ALRM_ALL_EVENTS to 1 in ONCONFIG (requires a restart of the Informix instance). Then there will be an event triggered for a failure to authenticate: CLASS_ID=42 EVENT_ID=42001 CLASS_MSG=Event occured SPECIFIC_MSG=listener-thread: err = -951: oserr = 0: errstr…
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…
rootdbs is full message
It usually helps to include some additional information: 1) the specific lines from the onconfig pertaining to DBTemp spaces 2) 'onstat -d' output showing the root and temp space flags. 3) the section from the message log with the error, and the surrounding few minutes of entries…
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…
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…
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
Hello, Frank. I think you probably changed the default value of ALRM_ALL_EVENTS in your onconfig. Check it out. Best regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Cer…
RFE request for session details during virtual shm
Original Post: I'm not sure if I completely understand the request. But apparently you want the SID of the session that caused the new memory segment to be added. But this does not necessarily means that that session is the one consuming more memory. Specially in an high activit…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Can Alaramprogram generate alert if problem is fix
Hi Fernando, Thanks for your response. Can you provide me your script for the tailing solution? Also please suggest that if we configure the ALRM_ALL_EVENTS, then is there anything scripted in the existing alarmprogram.sh script to pick all the "Recovery/Operation/Completed" a…
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
Yes... ALRM_ALL_EVENTS set to 1 will trigger the alarmprogram.sh for each line (or nearly that) written in the online.log That's the cause for thos class ID 42 events. Unfortunately this parameter is not dynamic... But in any case I still don't know why the calls fail... Do you …
Config Help
Your biggest performance problem is that you are running your server on a VM. IO performance under VMWare is VERY VERY POOR and, as I've said several times already this month, databases live and die on IO performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.co…
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…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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…
on tape -c
ALmost, see below: Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other …
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
Hmmm.... I checked the script. It depends on another one that was written by someone else (many years ago) and almost re-written by me over the years... But as of today I cannot supply this second one. This should be solved in a couple of days. If not, I could change this last sc…
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…
Connections to Database slow - for both shared mem
REPLY 1 - ONCONFIG FILE: cat onconfig.prod #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2006 All rights …
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 …
RE: HDR monitoring
Class code 15 is a Severity '2' event. Is your script perhaps ignoring all events with a severity <3? Do you have ALRM_ALL_EVENTS set to 1? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspo…
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…
Random Server Slowdown "Redone"
There are some usual things you could do for now: 1) calc your database ratios, I think there are several NETTYPE, BUFFERS and even BTSCANNER options that could be optimized, you could download Mr. Art script to automatically know these important numbers!!! It´s on the download …
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.…
Fwd: Alarm Program Question
Curtis: Using '==' in ksh comparisons was supported officially by David Korn for many years until it was deprecated in favor of '=' several years ago in order to improve compatibility with the IEEE POSIX 1003.2 Shell and Utilities Language Committee standard. Indeed the doubled…
Alarm Program Question
11.50FC3 question I am upgrading to the new alarmprogram.sh with 11.50FC3. I was looking at the script and I came across this LINE: ALARMTESTFILE= Yes it sets the variable to nothing and it isn't in the PUBLIC section to be set by us. It is only used in one other place. if ( …
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…
Buffer Turnover Rate question
How does one go about 'estimating' this? The performance documentation says to "set the value of buffers to between 20 and 25 percent of the number of megabytes in physical memory." - since I have 8Gb total physical memory, if my math is correct, that means between 819200 and 102…
Insert into an indexed table is really SLOW!
MIKE DUNHAM-WILKIE wrote: > I am running into performance problems inserting into an indexed table, using > Informix 11.50. The following timings for loading into > compressed/uncompressed, indexed/non-indexed tables using dbload/HPL-Deluxe > more illustrate the problem. The numb…
alarmprogram! how to trigger
How are you testing the ALARMPROGRAM? It always works for me and many of our clients. To test the logical log archive you have to force the engine to switch logical logs (onmode -l) at which point the ALARMPROGRAM will fire can be called with event code 23. To test the storage fu…
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…
ER Error Enterprise Replication
bozon wrote: > Enterprise Replication is giving the following message when I do a > simple cdr list server > > ndl12:ndl12a common_reporting$ cdr list server > SERVER ID STATE STATUS QUEUE CONNECTION > CHANGED > --------------------------------------------…
Poor Performanc with Multiple DB's in one Instance
2009/1/30 ANEES AHMAD <aanees@i2cinc.com>: > Hello, > > Please see my comments below. > > What OS and what versoin of IDS are you using? > [Anees Ahmad] We are using SunOS CA-MCPDB2 5.10 Generic_125100-09 sun4v sparc > SUNW,Sun-Fire-T200 and the IDS version is 10.0. It's a 6 core…
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…
Logical Log files MISSING
Your logs are turning over at a reasonable rate... If you made them bigger then they would be slower to turn over and you might have a little more time to see who is performing IO in that directory beside ontape... And the problem might be associated with the rate... Right now …
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…
Buffer manager internal error
Hi Kevin, Here is AF file as you ask. Thanks so much for your help. 09:27:35 bf_check_stamp() Very old stamp - bp 303934bc pagenum 1:8 bf_flags 807 bf_stamp 8 pg_stamp 11 cp_stamp -2073296305 sh_stamp -2073296295 09:27:35 Very old stamp buffer header 303934bc: 00000000 00000000…
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.…
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…
Re: Strange error when initialising (long)
i guess file /informix/data/ returns a directory oninit: Cannot open chunk '/informix/data/'. errno = 21 > ROOTPATH /informix/data # Path for device containing root dbspace -----------------------------------------^^^^^^ should be a file or better a char mode raw dev …
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…
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: Mapping cpuvp's to IBM virtual processors on p
On Thu, 2007-02-22 at 16:35 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > Your assumption is partially correct. You don't NEED all 6 CPU's allocated to > CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to > CPU > VPs as needed so it's possible that one …
oninit startup failure
Is this the first time you've tried initializing after installation or is this an existing instance which has just stopped working? How much physical memory on this machine? Disk space ok? What is the exact IDS 10 version? Are you running this directly or via Remote Desktop or s…
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…
dbimport EXTREMELY slow
Quman said: > > I am doing dbimport with IDS 10UC5 on AIX 5.3. > > Watched, > > large number(100,000+) of dirty pages were SLOWLY written to disk. > > piece of online log, > > 20:08:47 Maximum server connections 0 > 20:08:47 On-Line Mode > 20:15:15 Fuzzy Checkpoint Completed: dur…
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?…
How do it get writes form the lrus in V10
Thanks to everyone for our response. I now understand that having all chuck writes is ok. Nilesh Ozarkar wrote: >> I think I should be getting LRU writes. >> > > Why ? does checkpoint takes too long to complete ? or checkpoint duration > is affecting transaction response time ? …
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!…
Re: Tool to Record Database changes (inserts, deletes, etc.)
Yes!!!!!! Something that would allow for undoing a transaction or finding out when a row was deleted, updated or table dropped. You can do this now but you really have to work at it. Also have the tool do the same type of analysis that onaudit does. This would be after the 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…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
RE: Config for OLTP system
Neil, You are using /usr/informix and /opt/informix PA_PAGES and RA_THRESHOLD are blank Is 1Mb logs big enough, I use 100Mb and we can fill a log in <15 mins when busy, you won't need 819 of them if you make them bigger LTAPEBLK = 32 are you sure? seems a tad small to me SHM…
RE: Config for OLTP system
> -----Original Message----- > From: Bill Dare > Sent: Thursday, August 11, 2005 8:44 AM > To: 'Neil Truby'; informix-list@iiug.org > Subject: RE: Config for OLTP system > > BUFFERPOOL > size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=1 > 0.000000 > Maybe spe…
RE: Config for OLTP system
BUFFERPOOL size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=10. 000000 Maybe spending too much time flushing 8% of the LRUs when LRU writes kick in? Might try lowering lru_max_dirty. Shorter checkpoints and your LRU writes should be spread more evenly over t…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
alarmprogram.sh
tomcaml@yahoo.com wrote: > Hello > > We have a dev mount onto production so the alarmprogram.sh is shared by > prod and dev. problem is, i get too many alarms from dev especially > when i run out of locks. > is there a way for me to separate the two or at least configure the .sh …
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'?…
Re: DBI connect timeout question
am not into dbi sorry; however you could try setting INFORMIXCONRETRY INFORMIXCONTIME env vars; afaik the default for INFORMIXCONRETRY is 3 and for INFORMIXCONTIME is 60 secs... hope it helps Superboer. dkosenko@hotmail.com (Dave Kosenko) wrote in message news:<d9d3b2cf.040…
Re: DBI connect timeout question
Dave Kosenko wrote: > I'm using DBI to write a monitoring program for our informix > servers. Problem I am running into is that if the database server > (to which I am always connecting via a tcp connection) is down > completely, the connect() takes a very long time before it r…
DBI connect timeout question
I'm using DBI to write a monitoring program for our informix servers. Problem I am running into is that if the database server (to which I am always connecting via a tcp connection) is down completely, the connect() takes a very long time before it returns. The same server in qu…
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: [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: 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…
Re: Alarm program on IDS9.30UC1
Mark D. Stock wrote: > Andrew Hamm wrote: >> Mark D. Stock wrote: >> >>> What do IBM Informix tech support say? >> >> ^^^^^^^^^^ >> >> Geez u have it easy! If u put that into your signature, you won't >> have to write anything :->> > > Well that's the shortest reply I've seen …
Re: Alarm program on IDS9.30UC1
Andrew Hamm wrote: > Mark D. Stock wrote: > >>What do IBM Informix tech support say? > > ^^^^^^^^^^ > > Geez u have it easy! If u put that into your signature, you won't have to > write anything :->> Well that's the shortest reply I've seen from u (sic) Andrew, and truncating…
Re: Alarm program on IDS9.30UC1
abdoell wrote: > 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 ? > > Does anybody could help please …
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…
RE: alarmprogram.sh
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_01C3302B.C2A89160 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Our platfo…
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: 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…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Process exited with return code 126: /bin/sh /bin/sh -c
frank wrote: > > Setup informix 7.3 in my linux box > I don't known what is Process exited with return code 126: /bin/sh > /bin/sh -c /usr/informix > > 15:28:15 Process exited with return code 126: /bin/sh /bin/sh -c > /usr/informix > 15:28:16 Checkpoint Completed: duration wa…
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
Hello, Our test server crashed this night and yesterday night, at the same time, but I can't find a reason ... Can anyone help ??? The errno 36 is : /usr/include/sys/errno.h #define EIDRM 36 /* Identifier removed */ but I don't really understa…
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…
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…
Informix onbar -l with Legato.
export the variables before you execute the BACKUP_CMD ? Salai Champooranan wrote: > Informix Ver: 7.31.UC2 > Machine: HP 11 > > I am trying to send the logical logs to go to Legato using > alarm program(onbar -l). When I send it from unix prompt I could send it to > right pool…
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…
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…
perl/alarm program question
Hey All! I am trying to construct an alarm program in Perl to use with Informix, the problem is some of the parameters that are passed from the engine are messages with spaces in them. ARGV interprets them as separate arguments because of the spaces. How can I read these intact. …
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…
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: Alarm program
On NT you can use this : Create a bat-file that is running the the oncheck commando's. That file is making an output file. After that output file (oncheck.log) has been created you can search for some words eg. error, ... %MAILUSER% : user that is sending the mail %MAILPASS% : …
Alarm program
I want to run oncheck commands like -cc / -cr and if there is any error send a mail to DBA. How can I do that? An example of one oncheck -cc command with event severity and sending mail to DBA will be highly appreciated. URGENT, TIA Mukund ______________________________________…
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…
SE kill safe ?
I need to kick out users that are not active after a definite number of minutes. The context is the following: - SE ( version 5 and up ) - SQL form (perform) - ESQL/C program - On SCO Open Server 5.0.5 Is it safe to kill the processes including SQLEXEC if I de…
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) …
ontape verification
Hey Keith, Open onmonitor, as in $INFORMIXDIR/bin/onmonitor. Then choose status on the ring menu, it's the first selection, then archive. This will give you exactly what your looking for. As a more systematic option you may also use the informix Alarm Program to verify backups.…
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…
oninit processes/basic architecture question
We have three instances running on the same HP 10 box. ps -elf | grep oninit | wc shows 34 oninit processes running, about half are oninit and the other half oninit -s processes. Does this sound like something gone wrong, or are these processes the result of having light thread p…
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.…
Re: need program to send an alarm to my pager
Not having a text pager (yet), I can only guess, but maybe you should check with your pager service provider. I see that you have specified a subject line, perhaps they only send the subject line if one is provided. Have you tried running the mailx commands from the command lin…
need program to send an alarm to my pager
Hi to all of you!! I�m workig with Informix DS 7.23 on an IBM RS/6000 SP (AIX 4.2.1.0). I�m using the oncockpit utility from Informix and it has been working fine. I would like to know if any of you know a program or a shell script that could send an alarm message to my beepe…
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…
Re: An alarm program from the online.log
>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 >network…
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…
what does this mean..
Abel_Johnson@doh.state.fl.us wrote: > > I run informix 7.1 on digital unix 1000 server. suddenly today I get this. > looks like I was offline for about 1 hour when I brought it back on line, > AND NOBODY COMPLAINED!!! I have never seen this one. What do I need to do to > avoid/pr…
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…
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…
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: Logical Log Backups.
Assuming you're using OnLine 7.x, you can customize the alarm program to send out an e-mail or page when the logical logs get close to full. A message automatically is generated by the engine when all but one of the log files are full. If you have an alarm program, it will proc…
Re: 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: 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?
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…
Re: backup status
Hello David, you might use the alarm program interface. It well enough documented and is very well usable for that kind of problem Klaus Nonne nsi001@aol.com…
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: 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 …
RE: Is there a Unix alarm program we can use with the Informix Log?
I wanted to post the solution I came up with in case anyone here would want to use it. The problem we were having was with our QA department. They dont necessarily watch the logs while they are testing(its so tedious), so I needed something that would alarm them when the DB had…
Re: Is there a Unix alarm program we can use with the Informix Log?
Thomas Tatum (thomas@koz.com) wrote: : Is there a Unix command/script/program that I could set up to alert me when : the following is printed out in the message log? <snip> There is a program called "filemon.ec" that came out several years ago in one of the Informix technotes t…
Re: Is there a Unix alarm program we can use with the Informix Log?
On Wed, 29 Jul 1998, Thomas Tatum wrote: > Is there a Unix command/script/program that I could set up to alert me when > the following is printed out in the message log? > > 16:44:59 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem > 16:44:59 INFORMIX-Universal Ser…
Is there a Unix alarm program we can use with the Informix Log?
Is there a Unix command/script/program that I could set up to alert me when the following is printed out in the message log? 16:44:59 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 16:44:59 INFORMIX-Universal Server Version 9.14.UC1X4 16:44:59 Who: Session(17,…
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: onbar with 7.24
I ran into this same problem when I first tested OnBar. Yes, Informix changed the behavior of OnBar between 7.22 & 7.23. Under 7.22 it was up to the alarm program to do a 'onbar -l' after the 'onbar -b' completes (current log change). Under 7.23 and greater an 'onbar -b' autom…
Re: 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…
Re: Storage managers for use with ONBar
Seth Grimes wrote: >What (XBSA compliant) storage managers work with ON-Bar and what >experiences have list members had with them? The only one I know >about is dbBRZ from SCH Technologies. I haven't done any research; >they were at the WAIUG Forum last week. > >This is for IDS…
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: 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: 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…
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…
Re: trapping a signal when informix engine fails.
In article <19970913235400.TAA12556@ladder01.news.aol.com>, SaTriGuy <satriguy@aol.com> writes >>hi, >> I was just wondering if there is a way to trap any signal when >>informix engine >>goes down. Right now, I only start getting ton's of database >>errors, so it would be good…
Re: trapping a signal when informix engine fails.
>hi, > I was just wondering if there is a way to trap any signal when >informix engine >goes down. Right now, I only start getting ton's of database >errors, so it would be good from the application point of view if I >could say the >database is down... First things first ;) …
Re: Full Chunk: No Alarm???
David Williams wrote: > In article <340E7929.7C50BFF1@echonyc.com>, Cosmo Lee <"*N O - S P A > M*cosmo"@echonyc.com> writes > >I've set up an alarm program in ONCONFIG, "alarm.sh". I'm really > >surprised that if a chunk runs out of space, no alarms are triggered, > > >and no e…
Re: Full Chunk: No Alarm???
In article <340E7929.7C50BFF1@echonyc.com>, Cosmo Lee <"*N O - S P A M*cosmo"@echonyc.com> writes >I've set up an alarm program in ONCONFIG, "alarm.sh". I'm really >surprised that if a chunk runs out of space, no alarms are triggered, >and no entries appear in the online.log fil…
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…
Full Chunk: No Alarm???
I've set up an alarm program in ONCONFIG, "alarm.sh". I'm really surprised that if a chunk runs out of space, no alarms are triggered, and no entries appear in the online.log file. On the other hand I have to filter out the many severity level 2 messages, such as a logical log …
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: 4gl timer
You said: >From: rfredet@medicode.com (Rod Fredette) >Date: Fri, 07 Feb 1997 17:37:36 GMT >X-Informix-List-Id: <news.33642> > >I need the capability in a number of 4gl applications to have a timer feature >built in, so that if the program senses no activity for a given length of …
Re: Do alarms work in 7.20 ?
Thanks to everybody who has offered suggestions. I have gotten past some of my problems by correcting the errors in the alarm handling script itself. I did not need to change permissions on the file. I am curious about something though. Mark said that in 7.10, all calls to th…
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…
(Fwd) Re: (Fwd) DB/Cockpit: can you help??
--- Forwarded mail from Vitaly Volchek <Vitaly.Volchek@applicom.co.il> From: Vitaly Volchek <Vitaly.Volchek@applicom.co.il> Date: Thu, 6 Jul 1995 12:06:35 +0300 (WAT) To: cwang@bcarh2ae.bnr.ca Cc: valery@milcse.cig.mot.com Subject: Re: (Fwd) DB/Cockpit: can you help?? You have…
(Fwd) Re: (Fwd) DB/Cockpit: can you help??
--- Forwarded mail from Vitaly Volchek <Vitaly.Volchek@applicom.co.il> From: Vitaly Volchek <Vitaly.Volchek@applicom.co.il> Date: Thu, 6 Jul 1995 12:06:35 +0300 (WAT) To: cwang@bcarh2ae.bnr.ca Cc: valery@milcse.cig.mot.com Subject: Re: (Fwd) DB/Cockpit: can you help?? You have…
(Fwd) Re: (Fwd) DB/Cockpit: can you help??
--- Forwarded mail from Vitaly Volchek <Vitaly.Volchek@applicom.co.il> From: Vitaly Volchek <Vitaly.Volchek@applicom.co.il> Date: Thu, 6 Jul 1995 12:06:35 +0300 (WAT) To: cwang@bcarh2ae.bnr.ca Cc: valery@milcse.cig.mot.com Subject: Re: (Fwd) DB/Cockpit: can you help?? You have…
(Fwd) Re: (Fwd) DB/Cockpit: can you help??
--- Forwarded mail from Vitaly Volchek <Vitaly.Volchek@applicom.co.il> From: Vitaly Volchek <Vitaly.Volchek@applicom.co.il> Date: Thu, 6 Jul 1995 12:06:35 +0300 (WAT) To: cwang@bcarh2ae.bnr.ca Cc: valery@milcse.cig.mot.com Subject: Re: (Fwd) DB/Cockpit: can you help?? You have…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Gracefull Exit
} } Chetan Anand (anand@sin-co.sin-ro.DHL.COM) wrote: } : > } : > I would also be interested in an application that will cause } : > user's to exit an application gracefully after being } : > inactive for a certain period of time. } : > } : > [ Stuf…
Re: Gracefull Exit
Chetan Anand (anand@sin-co.sin-ro.DHL.COM) wrote: : > : > I would also be interested in an application that will cause : > user's to exit an application gracefully after being : > inactive for a certain period of time. : > : > [ Stuff Deleted ... ] …
Re: Is it possible to timeout 4GL?
->Hello, ->We are looking for a way to timeout 4GL programs when there is no terminal ->response after n minutes. The problem we are having is as follows: There is no way to do this completely within 4GL. I have done something Assuming you are using i4gl: In order to call a C …
Re: Is it possible to timeout 4GL?
alan@po.den.mmc.com (Alan Popiel) writes: >->: ->John Powell (jpowell@cv.hp.com) originally wrote: >->: -> >->: ->Hello, >->: -> We are looking for a way to timeout 4GL programs when there is no terminal >->: ->response after n minutes. The problem we are having is as follows…
AIX/5.01 INET & ESQL/C Problems
A customer running AIX 2.3 is trying to upgrade from SE 4.X to 5.01, and is encountering the following: When trying to run an ESQL/C program that ran 4.X - and which contains no SQL statements (it's setting an alarm and executes a seperate program that does the database stuff) -…
[Kevin Dempsey: Problems w/Informix ESQL and UNIX sleep() function.]
Can we help this fellow with his problem? Since he is obviously not a subscriber perhaps responses should go to him. Thanks. Date: Mon, 13 Jan 92 15:28:10 GMT From: Kevin Dempsey <dempsey@worms-emh2.army.mil> Subject: Problems w/Informix ESQL and UNIX sleep() function. …