Oninit® Archive
Results for “onstat -l”
EXTERNAL TABLE issue?
David, ask for the APAR/Issue number: it is normally a public informix on IBM's website…
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
script to check status of dbspaces & chunks
I would use the IBM provided script alarmprogram.sh in onconfig ALARMPROGRAM /opt/informix/etc/alarmprogram.sh…
Quickie question: Release 12.10: What is max size of physical log?
Before performing such a move to a new dbspace to store your physical log: 1/ Determine whether adequate contiguous space in the target chunk is available by running the oncheck -pe command before making the physical log move using onparams. …
Error in COMMIT WORK when trying to add a chunk
@Jacob, I may be misremembering, or maybe things have changed in recent versions of Informix, but in general, it is better to have several smaller logical logs than a few (or a single) large ones. This is because the LTXHWM and LTXEHWM percentages are based not on the percentage…
Resync RSS server
Hello I need to re-initiate synchronization between a primary server and the RSS. They re currently connected, active prim :/prod/dbown>onstat -g cluster ... Server ACKed Log Applied Log Supports Status (log, page) (log, page) Updates ids_tlv_rss 0,0 0,0 No ASYNC(RSS), Connected,…
Update to myschema available!
Okay Art and Community we're stumped; why would someone want to shrink a physical log within a plog space? If there's no good reason to do this we'll disallow it. TIA. ------------------------------ John Lengyel ------------------------------…
IBM Informix CSDK licensing
Hi all, IBM ILMT detects IBM Informix Client SDK 4.50 installations and identifies the licensing metric as " Authorised User Single Install", however I am pretty sure there has never been the possibility of purchasing a licence nor a requirement to keep a record of installations …
Informix 15 is out! Well sort of...
David: According to the Actian Webinar recording about the HCL-Informix v15 release, OneDB has been replaced with HCL Informix and IBM and Actian have agreed the beginning with the v15 releases, IBM Informix and HCL Informix will be identical (except for the branding). HCL Inform…
Is it possible to import the copy made with ontape from one database to another PC?
I've already checked everything, and it doesn't work. Now he also does not raise the case. Obviously the ontape has restored the logical logs but cannot do the physical restoration. ------------------------------ Gustavo Echenique ------------------------------…
What prevents a RSS to roll forward as fast as its primary?
David, (a) I was checking `onstat -l | grep C-` while the replica lagging, it showed almost same values as `onstat -g rss verbose`. (b) Could the apply contention be an issue if a single thread performs 99.99% of apply job when lagging? ------------------------------ Sincerely, D…
Informix future...
Benjamin: See my post to David's question below about OneDB and how it stands versus IBM Informix. HCL Informix is, has been, and will continue to be identical to IBM Informix in every way except for licensing and the name on the package. ------------------------------ Art S. Kag…
Logical Logs - Flags and backups
Hi Mark, The "B" in the 3rd position means that the logical log has been backed up, which is good! The log backup will be triggered by the script referenced in your onconfig file with the parameter ALARMPROGRAM. It is called each time a logical log is filled or logical log is sw…
unable to select, delete the data and unable to drop the table, response says Long transaction detected
Post your onstat -g seg, onstat -l, and onstat -d reports and we will try to help. Arr ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
V14.10.FC9 installer missing librarie(s)?
Andreas, I have same problem (libisi file is missing). Both tar files in gskit directory don't have deb package. Anyhow, unpacking rpm packages show no trace of libisi: root@mate2004:/home/informix/i1410fc9/gskit/tmp# rpm2cpio gskcrypt64-8.0.55.26.linux.x86_64.rpm | cpio -idmv ./…
Informix 14 Certification
That's up to you. The IIUG is administering the Informix v14.10 Badge Exam developed in cooperation with IBM. IBM Partners are required to maintain current badges (IBM no longer offers certifications, but the partner requirements remain), but for users it is optional though valua…
"Physical Logging while in Critical Section" in online log
I'm getting the message below in the online log, and I want to know in which case it occurs. Looking at the transaction log at that time with onlog, this message seems to occur at the time of truncate and chfree. It is currently suspected that truncate caused the message. Is this…
calculation of Required logical log
1. Read up on raw tables (beware of restrictions!) https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.admin.doc/ids_admin_0514.htm 2. Consider "smaller transactions" of inserts ... and can also use this to provide an estimate of usage (i.e. do a small subset and ch…
Undocumented logical log flags
Hello John, yesteraday I'v just installed 14.1.FC5 on ubuntu 20.04 and saw flag W in onstat -l. Can you comment this one as well? Thanks ------------------------------ Milan Rafaj ------------------------------…
Logical Logs/Physical logs
Thank you, Mark. This is something I should have thought of, as I use onstat -l frequently. A quick check verifies that there are about 3 orders of magnitude difference in writes between logical and physical logs! DG ------------------------------ David Grove --------------------…
Automatic conversion of ifx_loc_t (TEXT/BYTE) to/from ifx_lo_t (CLOB/BLOB)
Art, I have created a request but I could not find Informix in the product list... So I have used IBM AIX, https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=142665 I suspect IBM removed Informix from the product list since HCL took over. https://www.virtual-d…
Block during checkpoint
You are only using around 5000 pages of physical log space between checkpoints so you definitely do not need more log space. The problem is probably the number of dirty pages at checkpoint time. What type of checkpoints are being reported by onstat -g ckp?…
Informix 14.10 documentation
Art, So who does the documentation now? Surely IBM should be ensuring that the documenation for IBM Informix (as opposed to HCL Informix) is maintained? Regards, David. ------------------------------ David Williams ------------------------------…
IBM Champions 2020
IBM Champion nominations are now open but only until November 4, 2019! Remember this MUST be done annually , so if you are currently an IBM Champion, you must renew. If you are not an IBM Champion or wish to nominate someone else please follow the links below. For Champion renewa…
Phys Log Size Inconsistency?
IDS 12.10.FC12 Solaris 10 1/13 I am working on a test platform, and, while importing a database, I'm getting messages in the online.log suggesting an increase in the physical log size. Here is an extract from the log: [BEGIN LOG EXTRACT] 09/05/19 10:57:14 Performance Advisory: …
Physical Log size
IDS 12.10.FC9W1 AIX 7 I am trying to calculate if our Physical Log size is big enough. My reason: Checkpoint Completed: duration was 171 seconds. Sometimes we get hit by large checkpoints. From the manual: ---------------- To ensure that you have an abundance of space, set the …
Spaces and Spindles: Thought Experiment
For extra credit, consider having two dbspaces for logical logs (odd and even). DG…
Moving the logs, or not?
IDS 12.10.FC12 Solaris 10 1/13 Consider an instance in which the logical and physical logs are retained in the rootdbs. Do you think there would be any benefit in moving the logs to their own dbspaces, IF those spaces were still on the SAME SPINDLE as the rootdbs? DG…
New version Informix 14.10
We are IBM business partners, some clients have the Informix Advanced Workgroup version that includes the Informix Warehouse Accelerator product. In the new version of Informix 14.10 there is no Informix Advanced Workgroup version. My question is what happens with this licensing?…
Number of logical logs growing ?
This is what I've found in logs at the time of crontab ontape -a jobs ( no one was connected to the db, neither no jobs were usign it ): 17:20:01 Logical Log 47416 - Backup Started 17:20:01 Logical Log 47416 - Backup Completed 17:20:01 Logical Log 47417 - Backup Started 17:20:01…
4gl not ending FOR loop thru file for IDS ver 12.1
Update from IBM: 14 May 2019 3:24 PM I'm wondering if it's related to this defect which was fixed in 4GL 7.51.xC1: APAR IC93179 - 4GL: BEHAVIOR OF CLIPPED HAS CHANGED FROM VERSION 7.32 TO 7.50 Error Description -----------------------------------------------------------------…
4gl version 7.2 connection to ids 11 ?
PerLuigi, I have connected pre-IBM Informix real-life applications to Informix 12.10 without any kind of problem So yes, this is possible, and you did it!…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
IBM Informix RFE gone?
Hi, Where we should request new features? Informix just vanishes from IBM RFE pages. There is no option to filter or submit new RFE. Regards…
HCL Informix vs. IBM Informix
I'm just mildly unclear on what is happening with Informix. Is IBM in process of slow-motion divestment? I now see a mix of references to the product. For example, for AWS, I see "HCL Informix". Also, tech support comes from HCL. But, I still see references to "IBM Informix". …
Re: HDR Question
I got by that error. Now the HDR won't start and in the message log, it says the physical log is too small for automatic checkpoints. I also tried to do an oninit and the secondary will start and says it is up and running, but in the message log it says the physical log is too s…
Need help with my instance names
Hi, so onstat -g dis shows: onstat -g dis IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line (Prim) -- Up 264 days There are 1 servers found When I run: ls -l /opt/informix 2010 11.50 -> 11.50.FC6 Sep 15 2010 11.50.FC6 What does being linked mean?…
script for ontake backup in multiple files
Hi, We need to take backup (ontape) in multiple files using bash script . we are using IDS12.10FC7. currently we are using following script but it is not working properly. 1). Main script. i=inst_name level=0 . /inst_name TAP_FILE=`onstat -c|grep "^TAPEDEV" | awk '{print $2}'`…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Backup Help
When I ran onstat -, it says Blocked: LAST_LOG_RESERVED4BACKUP When I ran onstat -l grep C-, it gives me U---C-L…
ON-Bar / Last logical log saved number
Hi, Something like this. I am using "tail -50000" because ixbar files can get very large. SERVERNUM=`onstat -c | grep ^SERVERNUM | awk '{print $2}'` LASTLOGBACKEDUP=`tail -50000 $INFORMIXDIR/etc/ixbar.$SERVERNUM | grep ' L' | tail -1 | awk '{print $2}'` Ben.…
Physical Log Sizing
Hi, We are running Informix 11.70.FC7W2 on Solaris. We recently started getting alerts that the Phys Log was going over 65% used between checkpoints. Usually it will max around 35% between checkpoints though we have been having more spikes over 65% due to increased activity. Cu…
Moving from AIX 6.1 to AIX 7.1
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/W6461741b f7e8_47d7_89fc_a0a9233f3ca9/page/IBM%20Informix%20on%20POWER7…
Move phisical log
You can do this online using the onprarms utility, no problem. Consider creating a new Physical Log type dbspace (onspaces -c -p ... ) for this if you are using v12.10+. The Physical Log type dbspace is auto extending by default and can only be used for the physical log. A physic…
Waits in database
Thanks I triedseveral tomes with both, even with onstat -a | egrep 1440e1440 but nothing, No aditional info about this wait I also triyed from the database with the nex query, but idem, no blocking sessions select t.username waituser, t.sid waitsess, s.username hasuser, s.sid …
IDS not writing to online.log
Your script lines weren't so readable but I got this: -bash-4.1$ for tid in $(onstat -g ath | egrep "main loop|onmode mon" | awk '{print $1}');do > onstat -g stk $tid > done with no output. I did not say that there were not checkpoint, just I that it doesn't show in online.log, o…
Removning Log staging in RSS server
Hi, I have force a switch to the next log by onmode -l on the primary server, but on secondary onstat -m tell me that the log is completed, but the old log is still in the directory, now I have 3 logs in the directory. Log 1 wich is completed Log 2 wich is completed Log 3 wich is…
Issue in transactions with informix using DRDA
Hi Satyan, It works. It means that we can't be use synonyms in informix? It changes the way we programming. Previously, we used Informix IBM Informix .Net provider, with no problems, but it doesn't support LINQ. The IBM DataServer .Net provider is the promise of IBM for LINQ…
Re: upgrade and onbar
Hi Art the file pointed by BAR_BSALIB_PATH (ibsad001_64.so) in onconfig file exists but i have the error message when running /opt/IBM/informix/bin/onbar_d -b -p -w (-43231) An unexpected error occurred: 0509-022 Impossible to load the module /opt/IBM/informix/lib/ibsad001_64.o.…
Long transaction problem
When IDS will used up all the logical log? i.e. the log file below the current logical log file has open transaction also . thanks for your time.…
Physical log chunks almost full
Hi, I have a physical log of 2GB, but when I do onstat -d I notice that the free colum is "1179", is it risky if that chunk is full and how can I free the space from this chunk. thanks…
Need assistance on spreading logical logs
IDS 11.70 I need advice on how to setup a spread of logical logs over at least two disks. the idea behind this is to enable one logical log to be backed up and another being used which may improve performance.…
Physical log and checkpoints
All, Informix 11.70.FC5. A question about whether it is better to increase the size of the physical log or to reduce the checkpoint interval. I have an instance which has recently had some work done to it which has sped up the rate at which transactions are processed. This has …
onstat -a order
Hi All, On Informix v.12.1, what is the order of the results for 'onstat -a'? Our file is 234MB large, so I'm breaking it down into the individual pieces. I've gotten to the 'onstat -g all' section, but am stuck on the section with the heading: Thread Thread id Cancelled I/Os C…
Mutex logs on logical log flip
IDS 11.50 on Solaris We've only just started noticing this odd occurrence. I t only just have started happening or it may have been happening for ages but there's more focus upon it now. Our customer's monitoring was detecting occasional periods of slow queries, perhaps persist…
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)…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
Number of bit map pages to be logged in critcal se
Folks, IDS 12.10 FC4. Any comments on the following info ? Thanks Frank 7:47:44 Logical Log 149588 Complete, timestamp: 0xf7354a06. 17:47:50 CDR Spool transaction queue completed 17:50:54 Physical Logging during partition extend: Number of bit map pages to be logged in critc…
Informix High Availability
If you do HDR, then the network between the primary and the secondary is only dealing with the transfer of the logical logs. If you do anything requiring disk mirroring in any form (including VMWare motiong), then you also have to transfer the updated page, the physical log, any …
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
Root db space fills up
The logical and physical logs reside in there own db space.…
Number of bit map pages to be logged in critcal se
Folks, Build Version: 12.10.FC4W1X1 What does " Physical Logging during partition extend: Number of bit map pages to be logged in critcal section: 222 Remaining Phyical Log: 1659413" mean ? Thanks Frank 04:15:20 CDR Spool transaction queue completed 04:16:41 Logical Log 18192…
RSS not working
Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message?…
modify logical log size from 1 MB to 2 MB
Hi, Good Day would like to ask the best way to modify the log size in informix from 1 MB to 2 MB for (IBM Informix Dynamic Server Version 11.70.FC7). What I did so far was to add another log file with the size of 2MB and delete the 1 MB log file although after the deletion scrip…
Physical Log size 2000 is too small
Lester, You did not mention the Informix version? What is the size of rootdbs? As physical log is initially created in rootdbs it should be small, later you must move it to a new dbspace. I believe your server is online and this is just a warning you are receiving? Try moving th…
backup error
Folk, Any suggestions on the following error? Thanks Frank [informix@leslie ontape]$ ontape -s -L 0 Please mount tape 1 on /dbbackup/ontape/ontape_ncdcops and press Return to continue ... Archive failed - buc_fe.c : Archive API processing failed at line 257 for rc Program over…
backup error
Folks , any idea on the following backup error? Thanks Frank [informix@leslie ontape]$ ontape -s -L 0 Please mount tape 1 on /dbbackup/ontape/ontape_ncdcops and press Return to continue ... Archive failed - buc_fe.c : Archive API processing failed at line 257 for rc Program ov…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
IBM Data Server Provider - Db_Locale/Client_Locale
Unfortunately, I would not like to go back to CSDK since IBM is not supporting it for the future. >>The IBM Informix .NET Provider is also referred to as the CSDK .NET Provider. >>It is available for download as part of the Informix Client SDK. This .NET >>provider works only wi…
DYNAMIC_LOGS=2 Functionality?
Hi, Silly question ... do you backup your logical logs? If you do want to backup your logs, then consider using ALARMPROGRAM to backup logical logs when complete (using onbar or ontape) - that way you should not encounter full logical logs because they are not being backed up. …
Logical log backup
Folks, IDS11.50FC8 , Linux We have a couple of boxes , all are setup to do automatic logical backup. Once the current log is full, it triggers the alarm procedure to start a backup. It works great. But, The interesting thing is, some servers do not always backup a full logical…
RSS and BLOBs
Shouldn't the L flag not be present in onstat -d output then? 7000000226fd870 10 0x40811 27 2 204800 NLBB informix db Infocenter says L is Being logically recovered.…
Fwd: Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"
On 18/02/2013 19:39, Art Kagel wrote: > What does onstat -l show? If you are dbimporting an export that was > made without the -ss option then all tables are created with minimum > extent sizing which will cause thousands of new extents to be added to > the tables during the dbi…
IBM Informix 11.7 life cycle....
Hi Guys! Will IDS 11.70 be the last version of the product? This is making some noise lately! Have you heard anything on the future of IDS? Is it going to be any more development of IDS down the road. Please advise! jp…
How to install ISL?
Hi, How to install ISL(IBM INFORMIX INTERNATIONAL LANGUAGE SUPPLEMENT) in informix 11.70 TC1IE? How to add Marathi language(Indian Language) in GLS?…
Physical log size
IDS 11.50.fc6 HP-UX 11.31 PA-RISC For one of my instances, the online log file includes the following messages at startup: 19:38:04 Performance Advisory: The physical log size is smaller than the recommended size for a server configured with RTO_SERVER_RESTART. 19:38:04 Results…
Add more logical logs in IDS 9.4
Hi All, I'll be performing adding logical logs into our existing DB. My question are the following: 1. Do the DB needs to be in quiescent state? i believe, there's no need at all. Once i have added the new dbspaces to be used by the logical logs, i will drop the existing ones …
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
to IBM : Informix Gateway
Hi , Just a suggestion to IBM evaluate: Include the Informix Gateway "for free" with all editions of the product. Or at least , give a nice discount for clients who have a good amount of Informix licenses.... A reason why : Today the company where I work, we have: Informix (mai…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
Any resolution steps for this failed llogdbs that
IDS: IBM Informix Dynamic Server Version 11.50.FC9W1X7 OS: Sun Microsystems Inc. SunOS 5.10 Generic January 2005 I'm having the Systems Admin to review the disk now. 14:13:25 Assert Warning: I/O error, Primary Chunk '/ifmx/ciboodle/chunks/llogdbs_4' -- Offline 14:13:25 IBM Info…
reduce size of root dbspace
CORRECTION: The physical log can be moved to physdbs, but if physical log remains in rootdbs (default), the log should be about 30% smaller size than rootdbs size.…
location of physical log/dbspaces
Hi all I have a situation here where the previous DBA leave the company and do not document any setting. Checking with onstat -d command does not give us any clue where the actual physical log location. I been using onmonitor -->Parameters-->Physical Log to check for actual lo…
WOW, can't believe how slow iiug.org website is!
IMHO, I feel this website is the most important for Informix related topics and perhaps should be funded by IBM so that it can be properly function!…
non-log and logical log buffer
Hi, If a database is non-log, do update/insert/ go into the logical log buffer? thanks for your time.…
A raw table in Buffered DB in IDS 11.7 behavior
Greeting !! I've a IDS 11.7x running in RHEL 5.x , I've noticed that while I load a large data insert into a raw table reside in Buffered DB , the logical log does not increase size , that works fine , but surprisely physical log increase size , and finally has a checkpoint .. …
Re: Restore + Logical log - caution
true for the physical restore only.. not questioning that point. what I am questioning is the requirement (logical restore) for a user to insert a logical log tape that has transactions on it that are already on the archive tape seems to be not very efficient. What if it only ne…
Restore + Logical log - caution
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you restore an archive with logical logs , maybe you needed the files/tapes of logical logs backuped before the Archive Level 0. The rea…
Physical Log
IDS11.50.FC3 HPUX11.11 this is the error message in the online.log we have been getting WARNING! Physical Log size 300000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum …
CLR vs Long Transactions...
Immediately backing up your log doesn't automatically make it available for re-use. A long transaction is a function of how many logical logs a transaction spans (stays open) with respect to the amount of logical logs you have defined. In your situation every time you do a log sw…
Long transaction
Hi, when long transaction being rollback, could others execute SQL select that don't write logical log? thanks.…
Informix 10.00.TC5 CKPT REQ Logica Log Full
I hav'nt direct support from IBM Informix because I have Informix as a service from a supplier. My supplier support is very slow so I want to find a solution by me. Do you now how to reach directly IBM Informix support by mail od phone? Thanks…
how to calculate the label 0 backup file size
How can I know the backup file size after running 'ontape -s -L 0' . Can it tell from output of 'onstat -d'. Or select some information from sysmaster .…
Issues after upgrade
Hi, I have error messages after the upgrade from 7.31 to 11.5 In 7.31, the output of oncheck -pe was: ... LOGICAL LOG Pages - Log 52 456063 8000 LOGICAL LOG Pages - Log 53 464063 8000 LOGICAL LOG Pages - Log 54 …
HDR: ASF Echo-Thread Server error
Hello All, Primary - IDS 11.50.FC8W2 on HP-UX 11.23, 12 cores, IDS memory - 48G Secondry - IDS 11.50.FC8W2 on HP-UX 11.23, 04 cores, IDS memory - 40G 2 SDS nodes(updatable) DRAUTO 0 DRINTERVAL 15 DRTIMEOUT 90 Things were working fine until two days back we started getting foll…
Shifting the Logical Logs
I am using 11.5. I need to shift the logical and physical logs from one dbspace to another. (I am moving them to new physical disks). Can anyone give me any pointers as to how to go about this, especially any gotcha's that I need to be careful of? Many thanks…
Informix is now on facebook
Dear Informix fans, Did you know that IBM Informix is now on facebook? Stay on top of all the latest News related to IBM Informix. Hear about the latest announcements from IBM and IIUG, contests, interesting blogs, best practices, resources, as well as engage with us on top…
Transaction mode on ids 11.50
Thanks for fast respone. Database is on windows machine. I try to run that comand and im getting nothing, no error, no nothing... C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>ontape -s -B C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\…
How to know the existing external space ?
Hello, We created several external spaces in our IDS instance with the onspaces command : onspaces -x <extspace name> -l <extspace directory>. We forgot their name and their directory. I did not find how to display these external spaces (name and directory) with the onstat comm…
Smarter Questions for IBM
Folks, just discovered a new website that demonstrates how serious IBM is about Informix: http://smarterquestions.org In fact almost all questions are asked and answered by IBM itself and there isn't a single one that is covering Informix - just DB2. Well done, IBM (:- I just…
Moving from Informix SE to Innovator-C
I'm currently using Informix 4GL 7.50.UC4 with Informix SE 7.25.UC6R1 on Linux and I have two databases set up with the same database name, but each in a different path, this is because the database name is specified in the 4GL programs with the DATABASE statement. I then use th…
out of physical log
Hi All, first time happened to me that an instance has 0 phydbslog. Is there anyway i can free up physical log without adding additional space? 7000000500b9af0 3 1 3 1 N informix physdbs01 700000050081048 3 3 125001 25000 0 PO- /dev/infx/phylogdbs Thank you.…
must read.!!
way cool am baffled!!!!!! http://www.informix-zone.com/redbook-draft-version-ibm-informix-flexible-grid Thanks!!! Superboer.…
IBM Informix pages - the wrong pages....
Hi, Just putting out... Still there several pages on IBM site (US and BR) referencing to "Informix Dynamic Server" and Enterprise , Workgroup and Express Editions!! Very very very very confusing for who is starting with Informix now!!! Yesterday I have downloaded the Innovator…
Cannot alocate Physical Log
HI I have a 9.30FC2 instance under Solaris and after a power failure crash, I try to put on-line the instance, but it fail with the message 'Cannot alocate Physical log 50000 avalible 23650'. I check with 'onstat -d' my rootdbs chunk: 146a6e028 1 1 1 75000 68730 PO- /infx_psam…
IBM buys 4J's ?
There is a lot of new documents and articles on IBM Informix Support about "IBM Informix Genero" and how convert IBM 4GL to IBM Informix Genero https://www-304.ibm.com/support/docview.wss?uid=swg21474179 https://www-304.ibm.com/support/docview.wss?uid=swg27021002 Great news! b…
This looks almost like a new datablade
http://www.fuzzyl.com/news/press-releases/fuzzy-logix-and-ibm-unveil-in-database-analytics-for-ibm-informix/ -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.…
IBM Advertising
No, we won't ever ever advertise individual products: http://db2news.wordpress.com/2011/03/01/new-ibm-db2-vs-oracle-database-advertising-campaign/ This is surely true for Informix and others. However there is a single product named DB2 where we are always happy to make exceptio…
Problems with demo database
I have a problem with creating demo database on Windows 7. I have installed informix client in c:\\\\program Files\\\\Ibm\\\\Informx\\\\client-SDK directory and Ibm Informix Dynamic Server in c:\\\\program Files\\\\Ibm directory. I set the INFORMIXDIR to c:\\\\Program Files\\\\I…
Informix Products Installation
I have always installed the oldest to the new product. I also never install the engine in the same directory as the 4gl and ISQL, but that is a matter of preference. When you install them all together it is messy to upgrade only one part. So if everything is 11.5 FC4 the order i…
Physical Log Size
IDS 11.50.FC4WE Windows Server 2008 64bit I keep getting the message when I restart the Informix instance that the physical log file might be too small. It recommends 28000. I increased the PHYSFILE from 15000 all the way up to 800000, but I am still getting this message in the …
Instance Crashed !!
Hi, We re-started the instance, as it was'nt responsive. There was'nt any error message in log file as well. There was more than 3 GB of Physical Memory available at that time. Thanks for the response.…
Changing physical log size in non-rootdbs
On IDS 11.5 life is grand, but now a Performance Advisory tells me that I must increase the size of my physical log. Good. This is not raw space. Even though I moved the physical log to a dbspace that is NOT the rootdbs, my estimate of the size of the dbspace was inadequate. Sinc…
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
Re: Not using Physical Log, why?
Original Post: Hi , I already identify this situation on v11.10 xC1 and since then I not found any answer. I just forgot about this and today the situation "popup" and again I not found the reason.... v11.70 UC1DE - OpenSuse 11.2 This is a very simple test environment. - Datab…
WARNING! Physical Log size 140000 is too small.
Dear Sir, I have got the following Warning from Primary: WARNING! Physical Log size 140000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum concurrent user threads. Any help will be welcome Rega…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
HDR secondary move
Dear All, We are moving a server having Informix secondary server from one data centre to another. It is a 5 day process. Version 7.31 , OS HP-UX 11.11 While bringing up the Secondary instance I will check the following: 1) Check for last logical log in the secondary (in onli…
NTP configuration in HDR environment
Thanks for the response. Here we are using IDS 11.5 (update 6) i.e., IBM Informix Dynamic Server Version 11.50.FC6WE. And the DRAUTO is set to 2. Regards, Sridip…
esql and cygwin
Dear Art, I think that will bring on the right way, but all DOS path entries are available in cygwin. But they are changed from C:\\\\Program Files\\\\IBM\\\\Informix\\\\Client-SDK\\\\bin to /cygdrive/c/Program Files/IBM/Informix/Client-SDK/bin for example. And I think they are c…
IBM Informix Strategy
Folks, I think it would be interesting to see the mood of the worldwide Informix community after IBM published it's ambitious plans regarding a new Informix positioning and marketing strategy. Please vote here: http://www.informix-zone.com/your-opinion-about-ibms-renewed-strat…
Display contents of Logical Log
Is there a way to display the contents of the logical logs if the LTAPEDEV parameter is set to backup the logical logs to a directory? (LTAPEDEV /informix11/inflog) I had a look at the onlog command and in that the -d switch accepts the tape drive path. Appreciate your response…
Buffer Waiting ( onstat -l )
Hello, In the below mentioned output of onstat -l , there is a portion "Buffer Waiting". What does this "Buffer Waiting" mean? How could this output be useful for a database administrator? onstat -l ################################################### Physical Logging Buffer buf…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
Have any of you experienced this? In reviewing the online.log, I discovered that AFTER a system reboot, and ONLY AFTER a system reboot, the first time the "Auto Update Statistics Refresh" begins, the following performance advisory is recorded. The Backup occurs nightly, the AUS …
New Informix Blog
Folks, this might be interesting: http://informix-zone.com/bruce-weed-informix-blog Please also remember the two important Informix events that are happening soon: http://informix-zone.com/ibm-virtual-event Thank you.…
IBM Data Management Magazine Survey
Here is the chance to vote for more Informix content in the IBM DB2 Advertising Magazine: http://www.surveymonkey.com/s.aspx?sm=BMNOoeAiELQjyeKwxwPoFA_3d_3d Pardon - I meant the IBM Data Management Magazine :-)…
Long Transaction Despite DYNAMIC_LOGS = 2
Clifton, my inputs are as followings: The transaction by the user "ifxcmgt" spanned 2.2 GB (LTXHWM=70%) out of 3.1 GB total logical log dbspace (~33000 KBx100 or 3.1 GB); therefore, it was defined as a long transaction and was rolled back. Transaction rollback and other process…
Re: Upgrade from 9.4 to 11.10
One thing I noticed is you have lots of little logs - 85 12M logs for a total of 1Gig. IDS 11 prefers larger log files so that it does not fill and switch too quickly (which might occur during the batch processes). It will give you a warning in the alert log when/if that happen…
Re: adding rowids to a frag'd table
I'm very rusty, but the other guys should be able to yay or nay my scenario All changed pages go through the physical log, even for raw tables (am I right guys?) adding rowids forces a physical rewrite (right guys?) so it's going to pump a lot of pages through the physical log.…
shared memory not initializing
Hi, Check the ff: env variables on informix user before doing the restore. INFORMIXDIR ONCONFIG= should be the original value PATH INFORMIXSERVER Your physical logs and logical logs does not match the backup you are trying to restore.…
Where is informix in IBM now?
Hi All, Just want to post this question: 1. Where is informix DB in IBM organization now? 2. Are they planning to port everything to DB2? 3. I've seen some latest version in IBM website and it's downloadable but for 3 months use only. I'm worried as i've been using informix fo…
how to free up logical logs
Hi All, I've encountered problem on logical logs once again... I'm using onbar on backing up the logical logs and dbspaces. Unfortunately, the netbackup failed and causing the "logical logs" full. Q: what is the correct solution, without losing the logical logs? Is there any wa…
Alert 7 "Initialization failure", server up and running
This happens very occasionally (annually at worst) while the engine's up and running, some users complain that access is slow for a minute or so but there seem to be no detrimental effects - any clues? What does the "Initialization failure" refer to? IDS9.30HC5 on HP-UX 11i 09:…
How do you approach this problem?
Jeremiah L wrote: > The log files recently took up 100% of the file system for the > logfiles. Additional space was given but now informix is giving us > this: > > IBM Informix Dynamic Server Version 10.00.FC4 -- On-Line (CKPT > REQ) -- Up 4 days 10:31:40 -- 2258944 Kbytes > …
ontape -c
I use 'ontape -c ' to backup the logical log, if the 'ontape -c' process was terminated abnormally, for example, the machine crash or it was killed by others, do anybody know if I could restore those logical log sucessful?…
Logical logs backup
Hi Martin, Thanks for your response! Correct me if my clarification is wrong! At one point of time, the status of the logical logs is Logical log 4 to 7 -> U_B__ Logical log 8 -> U_C_L Logical log 9-13 -> U_B__ All the logical logs are 100% full When i did a level 0 backup, th…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
nonblocking checkpoints
how do nonblocking checkpoint use the physical log? when do they fire? how does fast recovery work concerning nonblocing checkpoint?…
Adding BLOB Chunks to DBSpaces
Why do you think that the physical log dbspace needs more space? Are you looking at onstat -d? Was there some message in the message log (onstat -m) that has given you concern? First, the physical log is fixed size. It is initialized when the engine is brought online during norm…
Driver ODBC ibm Informix 3.34
Hello on internet....i can FInd the Driver ODBC ibm Informix 3.34 ?? Ori can find only trial ? Tanks to All Cekke was HERE! ------------ >>> www.ceccherini.net <<<…
physical log problem
Recently I did a testing, the testing application execute three different SQL, 1 Insert and 2 updates, For every transaction the application insert into the table a record, and update that record two times, but it update different columns, I see the physical log didn't increase b…
Reducing logical log space
I'm looking for reassurance, really ... IDS 10.0FC8 on HP-UX 11.31. HDR running. My customer is running out of disk space on its production system, and cannot provide any more at all for Informix for a couple of weeks (don't ask!). As the application dbspaces will likely not l…
Monitor HDR
On Apr 14, 11:40 pm, Mo <mohitanch...@gmail.com> wrote: > Informix 11: > > We run HDR and I see waits on logbf0, logbf1. I think it's something > to do with log shipping to secondary node. Is there a way to look at > to make sure that log shipping is not the issue why I see some …
Help : Assertion Failure Type: CRASH
I've already had a look at files : /opt/IBM/informix/tmp/af.41edc39 /opt/IBM/informix/tmp/af.41bdc38 But nothing strange to me except what I've paste before is from the second file :(…
Extracting logical logs from a level1 archive ?
Is it possible to extract the logical logs from a level1 archive to use for rolling forward ?…
IBM to relegate DB2 to the mainframe and IDS (Informix) to LUW
> IBM will lead with Informix! Way ahead of you - here's the latest Oracle Training Course - http://www.youtube.com/watch?v=ByZqx30OvVs…
How many Informix Employees are Left?
Of the 2100 or so Informix employees that were taken on by IBM, how many are left? Anyone have any idea? > 100 < 100 ? -- }(:…
Informix Warehouse Feature
> > IBM announce today the availability of Informix Warehouse Feature: Why no Informix based BCU ?…
IBM 10year plan for Informix
Dear all Our client is insisting on some official document from IBM stating the 10 year plan / roadmap that they have for Informix. Apparently they got something like that from Oracle, and apparently the Oracle consultants is saying that IBM have no plan for Informix. I need s…
IDS FC3 on Windows Vista Business x64...
Hi Jean Georges, If you type "whoami /all" from that prompt, does it say you are a member of the Informix-Admin group? If the answer is no, logoff and log back in again to refresh your token information. If the answer is yes, can you paste the "PRIVILEGES INFORMATION" here. G…
Physical Log
Hi All, I am running IDS 9.40 on AIX 5.1. and have been getting the following warning over the last week in my online.log: WARNING! Physical Log size 20480 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times max…
dbcopy.ec compile on AIX5.3 gcc 4.1.1
Dbcopy.ec : Revision 1.58 AIX : 5.3 gcc : 4.1.1 esql : IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC3 A lot of error message display after I modify some and go further. Is anyone compile succeeded ? Or where I can get the binary file for AIX 5.3 ?…
Location of physical and logical logs
This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? Thanks -- Regards Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Sh…
IBM Informix Object Interface for C++
I am using the IBM Informix Object Interface for C++...or I suppose I should say that I am "trying to use" it. I'm on Windows XP and I have version 3.5. I have no problem with building the example programs I can connect to a database and in a very basic sense I can send queries…
Re: Logical Log files MISSING
Bigger logical log files?…
space used by physical logs
Hi all How do I get the space use in physical logs? I need to get the total space allocated and total used by physical logs using SMI tables. Any help on this is highly appreciated Thanks in advance Pratheep…
Informix Virtual Appliance
Fernando Nunes wrote: > IBM has made available a virtual appliance with SLES 10 SP2 and the > following IBM products installed and configured: > > IBM Informix Dynamic Server 11.50.UC2DE > IBM Informix Client SDK 3.50.UC2 > IBM Informix JDBC Driver 3.50.UC2 > IBM Informix Spatial…
Re: Smoke and mirrors...
DA Morgan wrote: > One logical (potentially physical) I/O to undo. > Commit. > One physical write to the log file. ... which includes logging of the UNDO > One physical write to the data file. I rest my case. Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab…
Logical Log files MISSING
Hello Ive checked the online.log file for one of the missing log 20084 23:12:22 Logical Log 20083 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20084 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20083 - Backup Started 23:12:23 Logical Log 20083 - Backup Comple…
Re: IBM To Sell Informix
> Yes, you are correct. a parody. But a poor one at that. Suppose that > it was actually picked up on a news report? Yeah suppose. People might actually see the product's name in print. Perhaps you should make a video about it: http://www.rootstelevision.com/players/player_dear…
IBM To Sell Informix
FOR IMMEDIATE RELEASE (AP) Armnonk, NY -- In what appears to be a complete reversal of fortune for the beleagured database division of IBM known as Informix, IBM today announced that they will indeed start marketing the entire product line of database products under the Informix…
If there were no onstat...
IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the cu…
IDS as a "legacy" system...
I'd like to know if there are 100 ( or more ) IBM customers actually using Informix. It would be great to see a list of 100 IBM customers that are using Informix.…
Just FYI on the Mac front.
Jonathan Leffler's dbaccess replacement : i.e. sqlcmd compiles and run's with almost no difficulties. There was a brief moment of PEBKAC as yours truly forgot about the following environment variable. DYLD_LIBRARY_PATH Which until I included /Applications/IBM/informix/lib and…
Understanding the Logical Log Usage
Am using version 10.00.UC7X1 and have a few *basic* questions on the usage of the logical log file. The database has a logging mode of unbuffered logging with a page size is 2048 bytes (as returned by onstat -b). I have 3 log files with each file being 5000 KB in size. I have a …
IDS 11.1UC2
Hi everyone, I try to build IDS (Ver 11.1UC2) test environment on my linux server. I try to setup physical log space for IDS. Despite I try to assign different size to physical log space, IDS always complains that the size is only 2000Kbytes. Anybody has idea? Or am I missing …
Informix and AIX P6
Anybody running Informix on IBM P6 Hardware? Has it been smooth? We are looking at it and want to know the user community has experienced. David Link…
Physical Log
Hi, My physical log is 10000kb and number of users never exceed 350, still every time I bounce the database, I get this message after few hours of recycle: WARNING! Physical Log size 10000 is too small. Physical Log overflows may occur during peak activity. Recommended minimu…
chunk is down
My box is aix 5.3 , ids 10 FC3R1. I start my ids and run 'onstat -d' 700000031d801c8 14 10 0 512000 0 PD-B /dev/ rtmpdb1 tmp dbspace is down. $ ls -l /dev/rmptdb1 crw-rw---- 1 informix informix 10, 20 Feb 25 13:39 /dev/rtmpdb1 owner , group name…
Re: Restoring a logical log
ian.miell@gmail.com wrote: > We have some scripts which parse the output of onlog -n/-l and > produces user-friendly output. > > We've been given a log file from backup which has the header: > > [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less > 00000000 ff ff ff ff ff ff 00 00 00 0…
Restoring a logical log
We have some scripts which parse the output of onlog -n/-l and produces user-friendly output. We've been given a log file from backup which has the header: [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less 00000000 ff ff ff ff ff ff 00 00 00 0a 00 09 00 9d 07 5f |..............._| …
Re: How can fetch cause long transaction
> I have one more question: > > When DYNAMIC_LOG is set 2, does it starts to add more logical logs > dynamically when next logical log in the sequence has open > transaction. Does this become active only during roll back and next > logical log has an open transaction or could it …
Please! What is the IBM Informix Help Line Phone?
Does anyone know what the IBM Informix phone line is for emergencies? Please help if you know.…
determine current transaction buffering mode?
Hi everyone. Is there are sure way to determine the CURRENT buffering mode of a IDS 7.4 database? Using onstat -l or perhaps onminitor? Thanks, Will…
Logical Log
Version IDS 10 When DYNAMIC_LOG is 2 and logical logs gets full Informix starts to write to rootdbs and Informix uses LOGSIZE from what was used initially for disk space initialization. And it appears like even if the LOGSIZE is changed using onparams or in onconfig file, Inform…
Re: Google Ads for Informix at IBM
Jonathan Leffler wrote: > I did a Google search that mentioned Informix; I got an Google Ad from > IBM for Informix that led to http://www.ibm.com/software/data/informix > (OK, it added a -306 to the www bit - but it got to the right place > within IBM). > > -=JL=- And can we h…
Re: Google Ads for Informix at IBM
My favorite is: www.informix.com It's like going home..... and finding out the parents moved and didn't tell you. ;-)…
Google Ads for Informix at IBM
I did a Google search that mentioned Informix; I got an Google Ad from IBM for Informix that led to http://www.ibm.com/software/data/informix (OK, it added a -306 to the www bit - but it got to the right place within IBM). -=JL=-…
Never ending Checkpoint
IDS 9.40.FC4W2 SunOS 5.8 Last Saturday we had a "never ending checkpoint". There are no loggings about the event except the lines in online.log: 11:41:01 Fuzzy Checkpoint Completed: duration was 2 seconds, 2789 buffers not flushed, timestamp: 0x60364810. 11:41:01 Checkpoint …
How HDR resync after network connection resumes
With "RETAIN_TYPE" is set to 1, HDR would be reestablished from secondary server when old primary is up once again. When the logical log backup has been performed on secondary server, how the oustanding logical log could be retrieved for resync to old primary server? 1) Do I ne…
HDR failure handling on network disconnection
Is the process of logical log rolling forward by "ontape" or "onbar" are automatic?…
Difference between Physical and Logical Logs?
It seems the work done by logical log is more than physical log. What is the point of having physical log? As logical log already including post and pre image of database chanages.…
Monitoring Physical logging
On Dec 10, 4:28 pm, mohitanch...@gmail.com wrote: > Informix Version 10: > > Does physical log have extents ? It may sound a dumb question, but > what I am seeing is that in onstat -d physical log show 0 pages free > but I don't see any errors. onstat -l report .05% used. So I am…
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
IBM Informix Support Exchange Program
IDS 11.10 - Monitor and analyze recent SQL statements Suma Vinod December 13th - 2007, 11am ET For Webcast and dial in details please see http://www.iiug.org/news/announcements/partner_training.php…
Replication question
Laurie Gustin wrote: > Hmmm - the replay position hasnt been overwritten. I have attached onstat -l and onstat -g ddr outputs. > > I added a bunch of logs last night to make sure we didnt block again until I could do more research this morning (and think more clearly..) > as you…
Informix Engine not starting
Can you please try to increase Physical & Logical log file sizes in Onconfig.bnm Thanks Tara…
Guy Boewerman, IBM and SAP , and Informix.
I read in Guy's blog that IDS 11 is now certified for SAP, and wrote immediately to my customer - perhpas the most famous broadcasting company in the world? - who has felt obliged to migrate away from IDS She wrote by reply: "Alas, that's only for the older SAP versions - thoug…
Informix DBA Job Opening in Lenexa, KS
On Thu, 2007-10-04 at 12:21 +0000, Zachi wrote: > In Lenexa, KS and no one from IBM-Informix there wants to join??? I imagine it would be a step down for an IBM-Informix developer to become a DBA. -- Carsten Haese http://informixdb.sourceforge.net…
Process taking most of Logcal Log
Version: IDS 10 Is there a way to tell which process on the box is filling up the logs. I was thinking if there is a way to tell which process / thread is writing the logical logs or filling up the logical logs…
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
Does these parameters help in logical log recovery. I was wondering if increasing ON_RECVRY_THREADS help in HDR on secondary server.…
HDR Secondary mode Log transfer handling
How the transcation is delivered from Primary Database to Secondary Database? - In a full logical log ? - Any committed transaction at Primary Database? If the transaction is delivered from Priamry to Secondary Database in a full logical log, then any recommendation on the size …
How to find the location of logical log file
Veeru71 wrote: > Given a logical log file, wow can we find out its location > (dbspace) ? > onstat -l doesn't show this info. > Thanks > Using the sysmaster database: SELECT l.number logfile, d.name dbspace FROM syslogfil l, syschunks c, sysdbspaces d WHERE l.chunk = c.chk…
long transaction, onstat -l, flag A----
Recently, we added logical logs because we were performing alters/ updates to big tables. But even after that we got long transaction. When I look at onstat -l it shows at least 216 logical logs having flag U-- and A--. A-- I think means have never been used by informix. So my q…
IBM Gateway
Has anyone had the opportunity to work with IBMs GATEWAY product to connect DB2 (mainframe) to Informix (Solaris)? Any issues that we should be aware of.…
long checkpoints on informix
On 13 jul, 13:37, Christine Normile <christ...@meta-today.com> wrote: > Check your Physical Log and increase the size. > On Jul 13, 2007, at 11:07 AM, Sakura.g...@gmail.com wrote: > > > 69174631 143507619 16152454169 99.57 10204375 98766167 29414237 > > 65.31 the physical log …
IDS Primary down
Hi all.... In it completes week, my IDS Primary has down in 4 opportunities having shown the following message of error: 03:10:47 Maximum server connections 567 03:11:21 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 03:11:21 IBM Informix Dynamic Server Version 10…
Re: Pb with Krakatoa on Linux
You should have at least the following lines in the /etc/ld.so.conf.d/informix.conf file: /opt/IBM/informix/extend/krakatoa/jre/bin /opt/IBM/informix/extend/krakatoa/jre/bin/classic /opt/IBM/informix/extend/krakatoa/jre/lib Sorry for not being precise in my first reply.…
Pb with Krakatoa on Linux
Thanks Claus, Well, it's better: > EXECUTE PROCEDURE sqlj.remove_jar('statbuilder', 0); SQL Error (-9431): Can't find system class or method or library (/opt/IBM/informix/extend/krakatoa/jre/bin/libjava.so). But not perfect... Of course... geo:/opt/IBM/informix # ll /opt/IBM/…
Logical Logs in Enterprise Replication
Hi All, I am using Enterprise Replication on IDS10 UC5. I have 33 Logical Logs for IDS, each of 5000 pages i.e. 20,000KB. Test >onstat -l IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes Physical Logging Buffer bufu…
Error when initializing
juanc wrote: > On IDS 10.00 when I trying to startup it remains eternally. In > another screen (onstat -) appears IBM Informix Dynamic Server Version > 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 > Kbytes Blocked:CKPT. > > That I must do? > Post the output…
IDS down while log back. is it a bug?
The 'onstat -l' showing it's a HDR secondary server. Wondering, are you trying to log backup on secondary server? When you use HDR, you must back up logical-log and storage spaces only on the primary database server. -Sanjit Chakraborty…
physbuff and logbuff utilization
Does anyone know if I can get the physbuff and logbuff utilization percent ((pages/io / bufsize) * 100) from sysmaster or can this only be retrieved via 'onstat -l'? Thanks, Andrew…
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
Re: Splitting logical logs
news.arcor.de wrote: > IDS 9.4 WE, Sola�ris 9 > > Hi everybody, > > we use to back up our logical logs using "ontape -c", for example in a file > named "trans.log". > As a consequence, when restoring a Level-0 backup using ontape -r, we can > only restore *all* logical logs con…
Splitting logical logs
IDS 9.4 WE, Sola�ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logic…
IBM seeking INFORMIX authors
Hi Informix Fellows, maybe someone is interested in this: http://www.informix-zone.com/node/123 Thank you.…
JDBC license query
Hello A potential customer of mine is running Informix and I want to approach them with a proposal to develop software for them which would connect to their Informix DB using JDBC. I understand that the JDBC client and server ships with Informix and a trial version is available t…
HDR Question
>From IBM Informix Tech Notes, why would you want to do this? Problem This article describes how to disable parallel clearing of the physical and logical logs on the secondary of a HDR pair during its logical recovery. Solution Q. How do you disable par…
Logical log backups
Hi I am having a dreadful time with a autochanger tape device for which my logical logs and archives are backed up to. Problem being the device frequently stops working and unless it is fixed before the logical logs run out, I get downtime. I am using the networker software to …
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
Whither Informix?
And it wasn't even mentioned at IBM Software Live - an IBM Software division event this week in London. But they did give pride of place to DB2 9. However, we mustn't be downhearted. Informix training in the UK is still almost impossible to find on the IBM web-site and is stil…
Re: Insider #75: Highlights: IBM Information On Demand 2006,The Next Informix IDS Release...
Davorin Kremenjas wrote: > > Seriously, we realize it is expensive, but it's an investment. > > An investment? > Who is supposed to come to Vienna? End-users who are using Informix and > Business Partners who are supporting them doing that. > Well, end-users already made an inves…
Re: Informix in the press...
eric@herber-consulting.de wrote: > Sometimes wonders take a little bit longer: > > http://www.marketwire.com/mw/release_html_b1?release_id=154242 > > A press release from IBM mentioning Informix. Great !! Go Ron Flannery! Go Cindy Lichtenauer! Go IBM! Go Informix! Art S. Kag…
record locked
a combination of onstat -k and onstat -u…
Re: Informix business grew by double digits in 2006 (Q1+Q2)
>> Yelling, ranting and complaining will not grow the Informix business and >> will not change IBM's behavior. Yes, you're right, I know. That's why I concentrate my spending on increasing Ardenta's market share amongst the existing, but declining, client base. This is quite a…
Checkpoint Question - need feedback
Obnoxio The Clown wrote: > Madison Pruet said: >> I've got a question for the user community. >> >> >> So - basic question --- Is the cost of the increased physical log file >> (maybe 3-4 times larger in some cases) totally outweigh the benefit of >> non-blocking checkpoints? > >…
not write Log
Can I control the writing Logical LOG? I mean I have a large job and it will use up all my Logoical logs, so I would like to avoid writing log temporarilly for this job. Thanks, Quman…
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
Re: Stuart strikes again - history is altered!
DE - Simple question - have you ever worked for IBM or Informix? Curious....…
who locks a record?
onstat -k followed by an onstat -u…
IDS versions & there full forms
Hi Guys , jst was looking for all the Abbreviation of Informix stuff. Can;t see an stuff at the IBM site.It was redirecting me but no page displays What all are there diff forms UC : FC SE :STandard engine rgds…
logical log size
Hello, The logical logs on my system are configured as 30 32MB logs. The system has been growing rapidly and currently cuts 2-3 logs every 5 minutes. Backup is to a spectralogic tape unit, which is fairly slow to spin up. In order to not run out of logs due to backup issues, I w…
Re: Thoughts on Logical Log use requested
TBP said: >> > Humm, > > An onstat -l (just the first bit) would be useful. > > Seems like quite a high log usage. > > Do you use unbuffered logging? > > How big is your LOGBUFF?? Darn. Beat me to it. :o| -- Bye now, Obnoxio "It's easier with pictures." -- Cosmo "But wait, …
Not using the 100% logical log page size alloacted to informix
No, i meant the logical log page file that i have appended in my query.…
Re: Informix marketing request list
The Informix marketing request list has been updated reflecting the progress IBM made on our proposals: http://www.herber-consulting.de/cgi-bin/IfxMarkReq.pl…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
RE: IDS for Solaris x86
> The response from that IBM rep *is* interesting! It conflicts with > IBM's updated support for Solaris x86. > > IBM announced last year that they now support IDS 7.31UD7 on Solaris > 2.6, 8, 9 and 10 x86. > http://www-306.ibm.com/software/data/informix/ids/requirements/solaris…
data model
IBM Informix online manuals are pretty good! Check out : http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst81.htm?resultof=%…
TRANSACTIONS WITH TOUT
On 1/25/06, Valeriano V.... <jvaleriano@ref.pemex.com> wrote: > There are some SQL to retrieve this sessions with -1 (tout column) > > onstat -u > > Userthreads > address flags sessid user tty wait tout locks nreads > > d3c0ea28 L--PR-- 51146117 gtaca655 tKg 8113adec -1 2 1786 > …
return code 164 during logical log backup
Hi all, I have following kind of problem with logical logs backup: When the current logical log is comming full, it does'nt make logical log backup and in online log of informix following message appear: -------------------------------------------------- 16:13:14 Logical Log 524…
Re: IDS 10
BigVinnie wrote: > I'm about 24hrs away from saying the heck with IBM/Informix and > converting everything to another database. Come on in the waters fine.…
Re: Informix in the news!
Michael Segel wrote: > Finally and most importantly, No mention of Informix at all within IBM's IM > strategy or product announcement.... > > -G Unfortunately: No one that came to IBM with Informix will be surprised. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washingto…
Re: IBM & Informix
DA Morgan said: > > Obnoxio The Clown wrote: > >> I'll have to keep an eye out for this "Laphroig" stuff. > > When you have nothing of substance resort to corrrrrecting > spelling errors? Impressive! At least I'm not the one waving his cock around, trying to pretend he's so suav…
Re: IBM & Informix
Obnoxio The Clown wrote: > I'll have to keep an eye out for this "Laphroig" stuff. When you have nothing of substance resort to corrrrrecting spelling errors? Impressive! -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)…
RE: IBM & Informix
Dirk- > -----Original Message----- > From: Dirk Moolman [mailto:DirkM@caretech.co.za] > Sent: Wednesday, November 30, 2005 2:55 AM > To: Everett Mills > Subject: RE: IBM & Informix > > Do you have a link where I can read more ? > > Dirk It's mentioned in Stuart's blurb in the l…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Mark D. Stock Sent: 27 November 2005 02:34 PM To: Traveller Cc: informix-list@iiug.org Subject: Re: IBM & Informix >I agree that it would be nice to hear about some o…
RE: IBM & Informix
> -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydassolutions.com] > Sent: Sunday, November 27, 2005 6:34 AM > To: Traveller > Cc: informix-list@iiug.org > Subject: Re: IBM & Informix > > Traveller wrote: > > Much as I like Informix and used it for over 10 yea…
Re: IBM & Informix
DA Morgan said: > > Actually Glenmorangie. Though I've three bottles of Laphroig in the > larder. ;-) Yes, Glenmorangie, made by taking the piss of people who drink real Scotch bottling it. I can definitely see you drinking it. I'll have to keep an eye out for this "Laphroig" s…
Re: IBM & Informix
Michael Segel wrote: > Obnoxio The Clown wrote: > > >>DA Morgan said: >> >>>And far too little sailing, scuba diving, drinking scotch, and writing. >> > Drinking Scotch? > LOL...I bet you just love Johnny Walker, Cutty Sark and Dewers. On thr > Rocks! Actually Glenmorangie. Thou…
Re: IBM & Informix
DA Morgan wrote: > I spend approximately 60 hours a week doing ... 1/10 that teaching. A 60 hour work week and you claim Oracle is easy to use? Sorry couldn't resist.... Seriously though work life balance is private thing. 66hrs/week would not be for me. Cheers Serge -- Serge R…
Re: IBM & Informix
> I spend approximately 60 hours a week doing ... 1/10 that teaching. As these 6 hours a week probably do not earn you a living, does Oracle pay for your remaining time to be on an Oracle defense team in Informix newsgroups ? Do you cover other newsgroups as well, like DB2, Syba…
Re: IBM & Informix
DA Morgan said: > > And far too little sailing, scuba diving, drinking scotch, and writing. If you count posting useless shit on Usenet as writing, then I think you have more than enough time for writing. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fe…
Re: IBM & Informix
M Segel wrote: > Whats that they say... Those who can... Do. Those who can't... teach? > ;-) That's what some say. But then they often also end up saying "Do you want fries with that" too. I spend approximately 60 hours a week doing ... 1/10 that teaching. And far too little…
RE: IBM & Informix
Personally I would choose anything ahead of SQL Server, I need my DBMS to run 24 x 7 and nothing I have seen convinces me SQL Server even comes close. I've never used Oracle, but would need a lot of convincing to convert from the ease of use of IDS. As I have a major influence in…
Re: IBM & Informix
You are right. They have had no bad press. Just no press and as you say when you do not the know the furture of a product , would you as a business make a decision to buy in Informix as a database when you have the choice of Oracle and MS-SQL server. I say nothing about DB2 beca…
Re: IBM & Informix
On 25 Nov 2005 17:42:08 -0800, david@smooth1.co.uk wrote: > >OK I substantiate it then...just wait until next week. OK? With real numbers and such . . . . ? I'm all ears . . .. JWC…
Re: IBM & Informix
Dirk Moolman wrote: > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Captain Pedantic > Sent: 25 November 2005 10:40 AM > > >>Contact your IBM representative? Right! > > > > > Sadly, in my case this is the sa…
Re: IBM & Informix
Traveller wrote: > Much as I like Informix and used it for over 10 years, I have not heard > of any new sales wins for IBM Informix in Europe. This causes rumours > and speculation to circulate and not in a good way, while also making > existing users of Informix even more nervou…
Re: IBM & Informix
OK I substantiate it then...just wait until next week. OK?…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malcolm weallans Sent: 25 November 2005 12:15 PM To: 'Traveller'; informix-list@iiug.org Subject: RE: IBM & Informix >Just because you haven't heard of any significan…
RE: IBM & Informix
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Captain Pedantic Sent: 25 November 2005 10:40 AM > >Contact your IBM representative? Right! Sadly, in my case this is the same, haven't seen my IBM account manager …
RE: IBM & Informix
Just because you haven't heard of any significant wins for IBM Informix it doesn't mean to say they aren't happening. I happen to know that there are some big wins for IBM involving Informix, including a very public win for a 2006 sports event - but the IBM marketing machine mig…
Re: IBM & Informix
Much as I like Informix and used it for over 10 years, I have not heard of any new sales wins for IBM Informix in Europe. This causes rumours and speculation to circulate and not in a good way, while also making existing users of Informix even more nervous. As a result I am anoth…
Re: IBM & Informix
Dirk Moolman wrote: > An interesting article about IBM and Informix > > > http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ But this article is now over a year old. IBM have now dropped the DB2 brand, or so they tell us. It left with JP. Of course it could take a long t…
IBM & Informix
An interesting article about IBM and Informix http://www.theregister.co.uk/2004/10/19/ibm_informix_db2/ sending to informix-list…
VMware edition
Do you know which version of VMware are supported by IBM for an implementation of Informix architecture? (the installation with Informix ER) Still thank you, Francesco…
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.…
engine blocked for Long TX
Well what is the output from onstat -m? and onstat -l? Does the output from onstat -l change? If you have lots of small logical logs you should be able to see the flags change on them as they get applied. What does onstat -x give?…
Re: Oninit from cron leaves engine in permanent fast recovery
Also check the release notes....under $INFORMIXDIR/release. On AIX do you need to create a KAIO device (aiodev??) or something. And run something like strload? Make sure NOAGE = 0 in onconfig as it may not be supported. Check RESIDENT = 0 in onconfig as I have seen it not suppo…
RE: IBM .net Driver for Informix vs MSSQL .net driver
the issue here is that the .net provider for Informix is not native but a wrapper which uses ODBC in order to fix this problem IBM would need to develop a native .net provider…
Dynamic Logical Logs
I need to get a clarification on the Dynamic Logical LOgs in IDS 9.4. We having few sites running in IDS 9.4 FC6 on IBM pSeries AIX 5.3 Below are the parameter values which have been set :- # Logical Log Configurationd LOGFILES 6 # Number of logical log files LOGSIZE 2000 # Lo…
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
Informix Upgrade Optons for an ancient Informix system
Might be able to get a Linux/Informix package deal from IBM. They were running some prgrammes toward the end of last year, not sure if they are still running.…
IDS License Terms and Conditions
Hi, Does anyone have a copy of the License Terms and Conditions for IDS (especially the Workgroup edition) as of the time IBM took over Informix? Thanks, Alan…
IBM Informix HA Agent for SUN Cluster
Hello is there anybody who has experince with IBM Informix HA Agent for SUN Cluster? Waht kind of software is nessary ? Thanks in advance Steve…
IBM Informix HA Agent for SUN Cluster
Hello, is there anybody, who experince with IBM Informix HA Agent for SUN Cluster? Which software is nessary ? Thanks in advance Stefan…
Re: Passport Advantage: Conclusion
Any chance you could stayt with IBM if I can get them to work better with you? I talked to the north europe salesman for Informix Databases today and I've got contacts in IBM now... I'M HAPPY TO REVERSE ENGINEER THE IBM CORPORATE STRUCTURE AND GET THEM TO WORK BETTER WITH CUSTOM…
Free(Open) Informix DSA
Hi. Are there any communities which develop free(open) Informix DSA over GPL or BSD licenses. How IBM looks for this. Best regards, Konstantine…
RE: Logical Logs's
begnadigen Sie mich, Ich verstehe nicht -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bono Vox Sent: 04 May 2005 11:02 PM To: ids@iiug.org Cc: iiug-esp@iiug.org; informix-list@iiug.org Subject: Logical Logs's Co…
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log 27225 - …
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log…
Transaction Rollback
onstat -x…
Informix IBM oledb driver
has anyone tried the Informix OleDb driver provided by IBM? I need to connect to an Informix DB and wondering how good are those driver, and need some information on how to use them. Thanks Andy -- Message posted via http://www.dbmonster.com…
Re: PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
JDBC Driver
Where can I get an Informix JDBC driver? The link to it on the IBM website seems broken.…
RE: Logical Logs not full
Brice, What you have described is not quite accurate; The logical log is not backed up the instant the transaction is committed when in unbuffered mode, it is written directly to the logical log as opposed to being stored in the current logical log buffer. Buffered logging us…
RE: Logical Logs not full
Muthana, The logical logs are fine, I wouldn't be dropping and recreating them, there is only one reason I can think of as to why a logical log would not reach 100% and that is onmode -l (force next logical log) this may be for any number of reasons, but typically it would be a…
Logical Logs not full
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50831.81451638 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C50831.81451638" ------_=_NextPart_002_01C50831.81451638 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-E…
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
Help !! - Logical Logs are full
IDS 9.21 UC4 LINUX RH 7.1 There was a long transaction aborted, an the IDS stuck in an eternal CKPT. The online.log said : "09:51:44 Waiting for Next Logical Log File to be Freed 09:51:44 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix /etc/log_full.sh 3 …
Ontape/logical logs
Hi all, I'm reasonably new when it comes to Informix, so I hope this isn't an often- asked question. I've set up a disaster recovery server for our main Informix server, to which I automatically send my level 0/level 1 backups and logical logs, as they're written to disk. I've p…
ontape -c stop archiving logical log on 9.21UC7
Dear All, I'm using 9.21UC7 on AIX4.3.3ML11, normally "ontape -c" archives logical log when the log is full(the logical log status changes from U---- to U-B---), but sometimes, it stops archiving logical log, even if you use "control+c" to stop it and restart it, it still cann't …
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
A "funny" on IDS 9.4
PLatforms tested : IBM AIX 5.2 sending to informix-list…
Mission Critical Database Rating
See http://www.sdtimes.com/news/103/special1.htm - there is a chart that actually compares/lists IBM Informix. -- Scott MacKenzie - Dine' College ISD. sending to informix-list…
RE: Logical logs - how to tell if full?
Notbeen on anysystem admin courses whatsoever - and unlikely to.. Is it safe to back up the logical logs at anytime?…
Re: Reg: Logical Logs Filling Up
turn logging off while you load the data!!!! ontape -s -L 0 -N <dbname> > Hi, > > I am trying to migrate and existing databse toIDS> i recreated the database and dbschema > on loading the data in the tables my logical logs > get filled up and IDS hangs > > onstat -l shows 100% …
Logical logs - how to tell if full?
I know 'onstat -l' can be used - but what am I looking for to tell me that the logical logs are full? Also if I want to archive them do I need to bring informix into quiescent mode or can it be online?…
onbar error message
Hello! I have an Informix backup configured as an onbar + Legato Networker combination with IDS 9.40 UC3 on Solaris 9 machine. We take dbspace backups every night and continously backup logical logs using log_full.sh script. All works well except one thing: if logical logs start …
logical log record failed
Hello all, IDS 9.21 UC4 Solaris 8 We have two systems replicating through HDR. the secondary server which is receiving the logs from the primary server suddenly starting giving this error message " rollforward of log record failed" then it gives the logical log number and the p…
onbar backup logical logs
Hi All, I am using onbar to backup my informix 7.31 databases with Legato networker. I dont want to backup my logical logs. Before using onbar, with ontape, I backed up my logical logs to /dev/null. How can I do that with onbar and Legato networker. Thanks for any help ______…
AIX logical logging question
My sysadmin wants to know if I can send the logical logs to a rewriteable DVD drive? Seems like new AIX boxes are coming equipped with these devices instead of 8mm tape drives. Anybody doing this currently? -- Phillip…
Physical and logical log placement
It's often recommended that the physical and logical logs be moved from rootdbs. Apart from performance, is there some reason I've missed why they should be kept separate? And does it make any difference if the whole instance is going in a RAID 1+0 array? Andy Kent…
FW: Physical Log Size
html??? The Clown doesnt like it. Informix version? Exact Message? Size of the table in Mb? How many logical logs and size? LTXHWM in $ONCONFIG? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Phillips, Rob Sent: F…
Physical Log Size
This is a multi-part message in MIME format. ------_=_NextPart_001_01C4022C.56CA4B15 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I am trying to update the structure on a table that has approx 1.8million records and I get an error th…
Question about archives
In 9.x IDS databases. Say I am doing a large dbload into a normal table and someone kicks off a level 0 archive (don't ask). Do before images from the physical log get put into temp tables on 9.21? Does this change with 9.40.UC3? Someone said that in 9.x the physical log is red…
Can someone provide link for Informix techinfo on IBM site
Can someone provide link for Informix techinfo on IBM site…
logical logs in 9.40.FC3
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_01C3FA52.A6808A50 Content-Type: text/plain I just went into production this weekend on release 9.40.FC3, AIX 5.2. On my…
onbar script for logical logs
Anyone have a script to perform continuous logging using onbar to filesystems? I would like to write to a separate file on disk daily. Thanks for any help in advance.…
IBM Informix ODBC driver
I'm looking for IBM Informix ODBC driver for windows. There are two different package available out there: CSDK.2.81.TC1.WIN.zip CSDK.2.81.TC2.zip (they even have the same release date) What's the difference between them ? Which one should I use ? Thanks a lot!…
expanding physical log failed
This is IDS 9.4 UC2 on Windows 2000. I attempted to increase the size of the physical log today with ugly results. I created the new space and checked it for contiguous space. I executed onparams -p -s 32768 -d physpace1 -y Onparams kept telling me that the server had to be i…
expanding physical log failed
This is IDS 9.4 UC2 on Windows 2000. I attempted to increase the size of the physical log today with ugly results. I created the new space and checked it for contiguous space. I executed onparams -p -s 32768 -d physpace1 -y Onparams kept telling me that the server had to be i…
Calculate Logical Log Required
I have read DB Adm reference and some other Informix manuals and cannot find how to calculate the required logical log need for following cases. Can anyone tell me? Just some example :- 1. Say I need to load 1,000,000 rows with record size 100 bytes to DB. How many logical l…
Write Logical Logs To Disk
Hi, Greetings, The situation: I am trying to write the logical logs on the first instance to the disk instead of the tape so that I may transfer these to the second instance and use recovery to bring it upto date. I am trying this to implement production backup at the database…
REgarding the Error in Logical Logs
Hi, We are running Informix 9.3 on Sun OS 5.8 . I cannot get my database engine up because of following error : 12:36:39 Results: Log record (OLDRSAM:HDELETE) in log 95507, offset 0xdf352c was not rolled back 12:36:39 Action: Use 'onlog' to view the transaction and repair manua…
Need the experts , Informix freeze or down
On Tue, 16 Dec 2003 04:52:50 -0500, shay wrote: What does the header line output from onstat show? Is it possible that your logical logs are full? If you are not sure, post onstat -l output including the header line. Art S. Kagel > Hi gurus, > > I need urgent help ,informix …
Logical log backup on XPS
Hi All, We have XPS 8.40 installed on HP UX 11i. Ther server was initialised and we were trying to load data into a table . Now the server is in Blocked state and the online.log file mentions that we need to take logical log back. Pls let us know the process for taking logical …
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
moving the physical log
According to the IDS 9.4 docs, I can move the physical log like this: set IFX=D:\\IFMXDATA\\ol_bronco copy nul D:\\IFMXDATA\\ol_bronco\\physpace.001 onspaces -c -d physpace1 -p %IFX%\\physpace.001 -o 0 -s 8192 onparams -p -s 8192 -d physpace1 -y ontape -s -L 0 The IDS bitches o…
Informix customer support outside U.S
Hi Does IBM stopped supporting informix in middle east, since they have closed down informix middle east, customer support never heard of informix when contacted at IBM M.E. Regards…
Restore certain Logical Logs
Hi guys, restoring a Level-0-archive using ontape -r and after that restoring logical logs using ontape -l works without any problem. Now, I have to restore a database-state, given after certain logical log. Is it possible, to restore a Level-0-archive (which includes the log…
Re: Fw: Company thought DB2 will be better than Oracle.
> Perhaps the biggest mistake Informix made was not hiring Mark There's a rumour that Informix (and now IBM) are actually paying my salary at Oracle.…
Customers ARE staying with IBM Informix
ALL: I can positively assert that according to a blind independent study of a statistically significant group of customers and business partners around the world, they are surely NOT migrating away from Informix in droves. In fact, 80% of respondents, in this survey which has …
Re: Physical Logging performance
"Mark D. Stock" <mdstock@mydassolutions.com> wrote: > [snip] > Yes, as far as I'm concerned, losing your pre-images before they are > written to disk is not a problem, so rather maximise performance for > those that make it to disk, which hopefully is most of them. ;-) Ok. Tha…
RE: Physical Logging performance
"Simmons, Keith" <keith.simmons@office2office.biz> wrote: > > R�diger > > 200,000 (at 4K page size) Thank you, Keith. We use 200,000 at 2k page size on the test and 700,000 on the production machine. Many regards, Ruediger…
Re: Physical Logging performance
R�diger M�hl wrote: > "Mark D. Stock" <mdstock@mydassolutions.com> wrote: > > >>R�diger M�hl wrote: >> >>>Good morning everybody, >>> >>>some time ago, I found the tip, that the pages/io should be >>>less than the bufsize (around 75%). Is that true? >> >>Certainly 75% is a good …
RE: Physical Logging performance
R�diger 200,000 (at 4K page size) Keith -> -----Original Message----- -> From: R�diger M�hl [mailto:ruediger.maehl@web.de] -> Sent: Friday, August 29, 2003 8:30 AM -> To: informix-list@iiug.org -> Subject: RE: Physical Logging performance -> -> -> "Simmons, Keith" <keith.simmo…
RE: Physical Logging performance
"Simmons, Keith" <keith.simmons@office2office.biz> wrote: > Yes, this is something I have tried to achieve, it tends to reduce > disk I/O to the Physical Log and make the I/O more efficient. I'm > currently running a PHYSBUFF of 512 (just so you don't get afraid of > big numbers…
Re: Physical Logging performance
R�diger M�hl wrote: > Good morning everybody, > > some time ago, I found the tip, that the pages/io should be > less than the bufsize (around 75%). Is that true? Certainly 75% is a good place to be. A lot less than that and you are wasting resources. A lot more than that and you…
RE: Physical Logging performance
Ruediger Yes, this is something I have tried to achieve, it tends to reduce disk I/O to the Physical Log and make the I/O more efficient. I'm currently running a PHYSBUFF of 512 (just so you don't get afraid of big numbers!). The same can be applied to the LOGBUFF parameter as w…
Physical Logging performance
Good morning everybody, some time ago, I found the tip, that the pages/io should be less than the bufsize (around 75%). Is that true? I had a physical bufsize of 16 and always a pages/io of around 15.7 so I increased the bufsize to now 32, but it still shows a high number. Do I…
logical log recovery problem
Hi All, I'm getting the following error when trying to start up a database: 09:57:10 Results: Log record (OLDRSAM:HINSERT) in log 988, offset 0x3ab0098 was not rolled back 09:57:10 Action: Use 'onlog' to view the transaction and repair manually. 09:57:10 stack trace for pid 228…
Applying Logical Logs for a restore ?
I'm an informix newbie. So my question is very basic. After I have backed up the logical logs how is the process of reapplying them to the database to get it current done ? The logs have been backed up using ontape -a Thanks, Jack…
Logical log buffer
Version: IDS 7.30 UC7 Question: We have 3 logical log buffers, 32K each. And databases use buffered logical log (>/dev/null), altogether 8 logical logs. One day users complained they can't do anything and when we ran onstat -u, we found out something like this: ..... e940e864 G…
Re: Logical Logs Size
What about the following : onstat -l (LOGBUFF will be shown here) What log mode on the database (Buffered, Unbuffered, None) Version of IDS O/S running on Are temp tables in use?? Do you have temp dbspaces?? Do you use into temp with no log?? Some of the online log that shows lo…
RE: Logical Logs Size
Fred 30 Gb seems rather large for total log space (in fact almost 19 Gb seems large). What is the size of your database? How quickly are you using the logs? What are your Long transaction limits set to? How often do you hit this long transaction? Can you (should you) split these…
Logical Logs Size
Hi, Well, in order to avoid amongother things several Long transactions aborded, I have decided to increase to size of the logical logs. This is what the actual configuration is : Total Logs Size : 18957068 KB Logs Number : 375 35 Logs of 15000 KB 340 Logs of 50000 KB …
IBM TO WINDOWS INFORMIX MIGRATION
Hello all. We are currently running the following on an IBM AIX box: ESQL/C 7.24.UC7 4GL RDS 7.20.UD6 4GL 7.20.UD6 SQL 7.20.UD6 SE 7.24.UC1 and need to port over to a WINDOWS 2000 box. Would anyone with information, experiences, and recommendations email me. Thanks. <<Sm…
Re: restore logical log
Andrey Mischenko wrote: > How to restore logical > log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a > log If you are asking how to restore logical logs when you have thrown them away using /dev/null, then the answer is; you can't, because they don't ex…
Re: restore logical log
Hello Andrey, If you had been backing up the logical logs to the bit bucket, I'm afraid there's no way you can restore the logs.... The only way is to go to a full Level 0 backup. Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Solutions Ph: 602-217-…
restore logical log
How to restore logical log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a log…
ONSTAT problmes on IDS 7.31
Morten L. wrote: > I am trying to move a 7.31 TC4 from NT4 to W2K > *** WARNING: Informix Dynamic Server is no longer running. *** Hi Morten, you should upgrade to 7.31.TD5, that works correctly with W2000. Earlier versions have the described problem because of the M$ hotfix Q3…
IIUG Insider #31 - Highlights: IIUG in HTML, Chris St. Aubin, LUG News and More...
Fans of Informix, the latest IIUG Insider has published via e-mail and will soon be available online at http://www.iiug.org/news/insider.html. Please feel free to pass on this information to colleagues and management as you see fit. This issue's table of contents includes: 1) I…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
PAM & Informix Article @ IBM
The IBM site now has a nice article on PAM & IDS. Looks like something finally happened on this front. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0306mathur/0306mathur.html#section3 sending to informix-list…
RE: WARNING! Physical Log size 50000 is too small ?? Why ? And ho
The physical log is recommended to allow for 20 pages per user to be changed between checkpoints. As the checkpoint occurs when the phys log gets to 75% full it really means that the sizing assumption is 15 changed pages per user. If you aren't making that many changes then you…
WARNING! Physical Log size 50000 is too small ?? Why ? And how to fix it ?
Dear Here, Today,I found following warning in online.log . My database OS is AIX and DB is Informix Database server 7.3. 09:05:45 WARNING! Physical Log size 50000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physi…
IBM Informix IDS Benchmarking.
Hi, So what's the story with IBM and TCO. I know the whole game is a silly PC vs. MAC contest and that its all about what works for you but.... There seems to be a push on for DB2 benchmarks from recent review of tpc.org although SQL Server seems to just beat the posted mark 10…
Adding chunks
Hi bro I'd do the following - dbexport - destroy current instance. create new instance with a large rootdbs (=>512MB) - create additional dbspaces for data, logical & physical logs - MOVE IMMEDIATELY logical & physical logs from rootdbs to new dbspaces - dbimport data, as last s…
RE: IBM Targets Low-End Database Market
> In nutshell, > IBM seems to be doing what even Oracle failed to do: kill informix completely. Perhaps Janet is Larry in drag ? <shudder>…
ISA slow with logical logs
Hai, When requesting the logical log information via ISA this tool is very slow. Does anybody know a solution? Bickel…
onstat flags
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_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPa…
SMI-Tables: Performance messaurements - l2datetime convert the Informix internal time to datetime
Hallo, I've 2 questions for useing the SMI/onstat for performance messaurements. 1.) Whar is the unit of the memory usage in onstat -g ses (bytes ??) 2.) How can I convert the Informix internal time in long in a datetime-representation, as is done with the SP l2date create proc…
regarding concept of physical logging??
hello, i have a serious confusion regarding tha concept of physical logging, this might sound silly for an expert kindly bear with me and explain.. according to what the book says.. physical logbuffer contains the before images of the data that taken from disk for modification..…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: onstat
On Tue, 30 Jan 2001 dr_pablo@my-deja.com wrote: >> I have seen vendor-supplied scripts, which use the following >> exit codes from "onstat". I do not know where they are documented. > >Here's the URL to the FAQ page containing the info: > >http://www.iiug.org/resources/faq/ifaq0…
RE: onstat
I got this email awhile back: >PEOple, > >For those of you who do not know, it is very tough to determine the *real* >status of IDS. "onstat -" will return, stating that the server is "online" >but many times it is in the process of a "fast recovery", etc. In >addition, "onsta…
RE: onstat
The exit codes were posted into a FAQ at the IIUG web site at one time. Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Monday, January 29, 2001 11:17 AM To: informix-list@iiu…
Re: Logical-log backup
----- Original Message ----- From: Woi Yew Fong <yfwoi@tpl.com.sg> To: <informix-list@iiug.org> Sent: Tuesday, January 30, 2001 9:40 AM Subject: Logical-log backup > > Hi there, > > I am confused with the automatic logical-log backup (with ontape -a) and > > continues logical-l…
Logical-log backup
> Hi there, > I am confused with the automatic logical-log backup (with ontape -a) and > continues logical-log file backup (with ontape -c). Can somebody clarify > the doubt for me. > > 1. Does automatic logical-log backup mean an operator need to execute the > command ontape -a…
RE: onstat
Hi Bernstein. Please visit following site. >exit codes from "onstat". I do not know where they are documented. http://www.informix.com/informix/iuc/ppt/ts_ids.ppt And search "onstat". Regards. -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion …
Re: onstat
At 11:17 01/01/29 -0500, Bogdan Neagu wrote: Hi Bogdan. When the meaning of the question is different, I'm sorry. onstat returns the following. The server status is expressed as a number 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort Regards. >…
RE: onstat
I have seen vendor-supplied scripts, which use the following exit codes from "onstat". I do not know where they are documented. integer inf_dwn1=255 # Informix mode is down integer inf_dwn2=-1 # Informix mode is down (60_USAP2) integer inf_init=0 # Informix mode is Initia…
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
Re: Strange Log behavior
onstat -l and onstat -x output when the logs are full? Will In article <93nrv7$dht$1@news.panix.com>, Michael Hoffman <mrh@panix.com> wrote: > > Sorry, I should have explained a little further. The program does each of > these updates as separate transactions (yes, the first…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
Enterprise Replication log
Enterprise Replication does not have a seperate set of logs. It snoops from the normal logical log file buffers. It only snoops from the log files themselve during recovery or if for some reason it falls behind.…
RE: DataBase Log Status...
In article <93dl69$1jk$1@news.xmission.com>, mosserp@WellsFargo.COM writes > >I believe that you have to take the instance down to quiescent (onmode -uy) >before you can start logging on a database. Try doing: >-- onmode -uy >-- ontape -s -L 0 -B dbname >-- onmode -m > >HTH, >Pa…
xctl problem on script
I have a script which will run across the co-servers with the informix xctl command. The script is running fine at the command prompt; but it fails if i run same when I put it on the crontab. Script: allusers=`/usr/informix/bin/xctl /usr/informix/bin/onstat -u | grep informix | w…
RE: location of logs
From: "Carlos Kobashikawa C." <ckobashi@luzdelsur.com.pe> > >Easier. Column "begin" of onstat -l . Erase the last five digits; the rest >is the chunk number (hexadecimal). >Chunk number - chunk device relationship is in onstat -d output. This must be some new meaning of the word…
Re: location of logs
oncheck -pe From: rsalido@my-deja.com > >Is there a way to find out where my logs are? I mean onstat -l gives me >a bunch of information regarding the logs but I dont think it shows in >which dbspace they reside in.....any ideas? > I just started working on this database and …
location of logs
Is there a way to find out where my logs are? I mean onstat -l gives me a bunch of information regarding the logs but I dont think it shows in which dbspace they reside in.....any ideas? I just started working on this database and I'd like to know if the logs physical and logi…
bug in onstat -t ?
onstat -t gives following output (look at column npages): Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 17 c0000000995f8908 0 1 100001 10000e -9223372036854775558 250 0 0 5 0 120 c0000000995f8d78 …
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
Drop the last transaction from logical log
Does any body know how to drop the last transaction from logical log before startup the database instance?…
Re:Informix on IBM SAN?
That is true. DBA job made simple. SAN and NAS are meant for these. They have huge cache built into them so that always you write to the cache. You dont have to worry about which physical fragmentation. You just have to worry about logical fragmentation. Bottleneck is your ne…
RE: Informix on IBM SAN?
I know Informix does support them and these are usually NFS mounts, so raw devices are out of the question. -----Original Message----- From: Martin, Wayne E. [mailto:WMartin@kmart.com] Sent: Tuesday, October 03, 2000 10:37 AM To: 'd_weber@telocity.com'; informix-list@iiug.org Su…
RE: Informix on IBM SAN?
Hi Doug, I basically had the same issue a couple of months back. And if I had my way I would have stuck with using good'all raw devices. There is definitely overhead whenever you use SAN or for some vendors NAS (network attached storage). Primary of which is network traffice. Y…
RE: Informix on IBM SAN?
Does Informix support these devices as most installs use raw devices? Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: d_weber@telocity.com [mailto:d_weber@telocity.com] Sent: Monday, October 02, 2000 11:35 PM To: informix-list@iiug.o…
Re: Informix on IBM SAN?
From: d_weber@telocity.com (Doug Weber) > >Does anyone have experience running Informix (or any database, for >that matter) on the new IBM SAN (storage area network) equipment? My >company is proposing that we move our Informix database tables to SAN, >and I've got some concerns…
onstat on IDS2000
Hello all IHAC with IDS2000 ans the output of onstat -d is the following : Informix Dynamic Server 2000 Version 9.20.UC3X4 -- On-Line -- Up 6 days 16:59:45 -- 459440 Kbytes Dbspaces 500d1d08 6 8001 6 1 N S informix usersbs0101 Chunks address chk…
Informix on IBM SAN?
Hello! Does anyone have experience running Informix (or any database, for that matter) on the new IBM SAN (storage area network) equipment? My company is proposing that we move our Informix database tables to SAN, and I've got some concerns. Seeing as these new devices abstrac…
Logical Log Files are Full
Is there any way to flush out the contents of the LOgical Log Files through a script or command without manually setting it ? Thanks, Gavin…
logical logs
Hi all, How to find out which session causing the logical logs to fill up. Regards Aboo…
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >Why don't you re-read the whole thing from the beginning. I did. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not every >possible inc…
RE: Informix for IBM S/390
From: kirk.waterhouse@cibavision.Novartis.com > >Why don't you re-read the whole thing from the beginning. No thanks, I'm bored with it. >I was describing one of the possible ways, method 3 in the list, to run >Informix on Linux on a S/390 mainframe - as I understood it - not e…
RE: Informix for IBM S/390
Why don't you re-read the whole thing from the beginning. I was describing one of the possible ways, method 3 in the list, to run Informix on Linux on a S/390 mainframe - as I understood it - not every possible incantation of mainframe configurations. I am a UNIX guy and I was …
RE: Informix for IBM S/390
--- kirk.waterhouse@cibavision.Novartis.com > wrote: >I don't know that much about the S/390. Just what I read on IBM's web site >about them running 41,000 instances of Linux on a single box - Just >because they could. > >It simply seems to be a lot of layers between Informix a…
RE: Informix for IBM S/390
I don't know that much about the S/390. Just what I read on IBM's web site about them running 41,000 instances of Linux on a single box - Just because they could. It simply seems to be a lot of layers between Informix and the metal if you run it in the mode I described - and I…
Re: Informix for IBM S/390
From: mbeattie@sable.ox.ac.uk (Malcolm Beattie) > >It might be interesting if Informix was the next out since >they were one of the first vendors to take Linux/Intel seriously. This must be a new meaning of "to take seriously", of which I was not previously aware.... (Interesti…
RE: Informix for IBM S/390
Since IBM released Linux for the S/390, maybe you can run Informix for Linux =:-) A database running on a operating system running on a virtual machine running on an operating system running on a mainframe. The performance would have to be phenomenal. Kirk > -----Original Messa…
Re: Informix for IBM S/390
From: "AM" <amatus@poznan.uw.gov.pl> > >My question is: >what Informix products are currently available for use with db management >systems running on IBM S/390 and what dbms would be of best use for those >products? I don't think *any* Informix products run on an S/390, except …
Informix for IBM S/390
My question is: what Informix products are currently available for use with db management systems running on IBM S/390 and what dbms would be of best use for those products? Best regards, Alicja Matusiak…
Re: Logical logs?
Logical logs reside on disks. Logical log buffers reside in memory. If you want to increase the size and number of Logical logs then just add more disk space. Don "Josep M. Marti" wrote: > > Hi all, > I have a problem with the logical log. I need to add more logical logs > be…
Logical logs?
Hi all, I have a problem with the logical log. I need to add more logical logs becouse I can't run any proces, but the logical logs need memory space or disk space? If I put a lot of logical logs I needed add memory or disk? thanks all, -- ------------------------------------…
Questions about sysprofile in sysmaster?
In Informix << Adminstrator reference>> book, It tells me that the table sysprofile in sysmaster contains columns such as llgrecs,llgpagewrites,llgwrites and it wrote: llgrecs: Logical-log records llgpagewrites: Logical-log writes llgwrites: Logical-log page writes 1.What doe…
OnLine Initialization failure.
Hi guys, I got the following Alarm message : Tue Jun 13 13:44:39 PDT 2000 Severity : 3 OnLine Initialization failure. WARNING! Physical Log size 40960 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times maximum …
onstat -u
I have a telnet user who consistently is walking out the door without logging off. Here's how I assume I should go about killing the user, with the problem listed below. 1. Do a who -u | grep username (identify tty port) 2. Do a onstat -u | grep username (to identify session i…
Logical logs
Hi All, I have a informix database of 7.30 where in the logical log is getting full very frequently. > What might be the reason. I think the "size" / "physize" of each log is > very less. I am giving below the output of "onstat -l". Is there any > parameters in onconfig tha…
Fuzzy Operations : Some clarity from Informix
Gang, Following up on the Fuzzy Operation issue : Specifically, if pages affected by fuzzy operations are not physically logged, how will recovery be effected in case a crash occurs during a write of a page, leaving the page "inconsistent". The matter was raised with Informix. …
Logical logs
In our system, I am noticing Long Transactions being caused sometimes. We have 80 log files, each of size 2048. LTXHWM & LTXEHWM are 50 & 60. I don't want to increase them. I am planning to increase the no. of log files to 120 or to 160. Are there any pros and cons of having more…
Re: Onstat
Are you executing onstat with -r 1 option? It happens sometimes. Try with -r 5 option. Vinod Bhansali --- Srinivas Sreekumar <SRINIVAS_SK@inf.com> wrote: > Hi all, > > I recently installed Informix dynamic server > 7.31.UC6 on HP UX 11.0 > > I am getting an error while running …
RE: Onstat
I had a low value for the shared memory kernal parameter for my unix server. When I increased it it started working.. Thansk, Srini -----Original Message----- From: Marat [mailto:maratkotik@mail.ru] Sent: Monday, May 15, 2000 7:41 PM To: informix-list@iiug.org Subject: Re: Onst…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
Fuzzy checkpoints.
"Art S. Kagel" wrote: > I'm getting a headache. Roll out the acetaminophen :-) > OK, so there are two separate issues here. One is Physical logging needed > at all, which it appears I brought up and not William. I agree with > Rudy's assessment that physical logging is need…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
Re: Size of logical logs
anil kuttappan wrote: > Hi, > > Can anyone please tell me why onstat -l displays > the size of logical logs as half the size of what i > had allocated to the logical logs. > > eg when i allocated 100MB to the logical logs, > onstat -l displays only 50MB. > > Thanks > > Anil K > …
Re: Size of logical logs
anil kuttappan <anil_kuttappan@yahoo.com> writes: > Hi, > > Can anyone please tell me why onstat -l displays > the size of logical logs as half the size of what i > had allocated to the logical logs. > > eg when i allocated 100MB to the logical logs, > onstat -l displays only 50…
Re: Size of logical logs
Hi, Can anyone please tell me why onstat -l displays the size of logical logs as half the size of what i had allocated to the logical logs. eg when i allocated 100MB to the logical logs, onstat -l displays only 50MB. Thanks Anil K ===== Anil Kuttappan Mailto: anil_kuttapan@y…
Size of Log files
I belive because the 'onstat -l' command displays information in page increments, not in K. If your system has 2K pages, then this would explain what you are seeing. Hope this helps. Brice anil kuttappan wrote: > Hi Guys, > > I would like somebody to give me an insight as to w…
question
Try backing up the logical logs with ontape. Nona…
onstat -k and tblsnum?
Folks, Need some help. An application is experiencing locking problems, and 243 errors. How can I find out which table belongs in tblsnum. Part of the output of onstat -k reports on tblsnum, I want to determine which table in which database is in trouble. Querying syslocks r…
Informix in the news
So anybody know what exactly IBM is accusing Informix of doing. Will…
When are checkpoints initiated
Chekpoint is initiated when Physical log if 75% full, so consider increasing the size of physical log if chekpoints are too frequents. regards Top Cat a écrit: > I know there are a number of things that can cause a checkpoint to be > initiated. The one I'm concerned about is…
onstat -u
I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command it shows the following: address flags sessid user tty wait tout locks nreads nwrites Under flags option: There are seven flags, the Seventh place flag is I know B,C,D,F; but it also shows M sometime. …
Re: Onbar
> > The problem with using onstat is that it will always return all logs as > full. No. It returns only the full logs if you grep them out. The flags on the output of 'onstat -l' mark the full logs, in our version (7.2 & 7.3) they look 'U--'. It is a very simple solution. It can…
RE: Onbar
A log switch can be forced before a log is 100% full. We use the following commands in our scripts. integer FULL_LOGS=0 FULL_LOGS=`$INFORMIXDIR/bin/onstat -l | grep -c 'U--'` However, I am not a korn shelling scripting expert. Therefore, there may be a better way. -----Origina…
Problem restoring from ontape -s --HELP
You could try changing your physical log size in onconfig.std…
Re: onstat -l when logging is set to "/dev/null"
From: "Piotr Wr�blewski" <ptrwrb@kki.net.pl> > >Hello! > >I upgraded a few weeks ago Online from 5.05 to IDS 7.30. > >I do not care about continuous recoverability, so I have >my LTAPEDEV set to /dev/null. > >The problem is that when I display logging state via > >onstat -l > >I …
onstat -l when logging is set to "/dev/null"
Hello! I upgraded a few weeks ago Online from 5.05 to IDS 7.30. I do not care about continuous recoverability, so I have my LTAPEDEV set to /dev/null. The problem is that when I display logging state via onstat -l I see all my logical log files are "U" (Used) "B" (backed up)…
Monitor Informix Longtx
I'm trying to find a way how to monitor when a long transaction is almost going to happen on an informix instance. We are using the IDS version 7.24. Can this be done using onstat utilities or via an sql query on the sysmaster database. With an onstat -l you can see the logical …
Light Scans and Light Appends (Light Scans/Appends)
Has anyone figured how to capture this information. Can you see it occur during an HPL Load? I've entered the commands: onstat -g lap and onstat -g lsc I do not getting any information except the headings...is it some OS Environment or Informix Configuration Variable that ne…
onstat & SMI
Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.…
RE: Physical Log size
Yuri, see below. > -----Original Message----- > From: Yuri Dovgart [SMTP:y_dovgart@tci.ukrtel.net] > Sent: Friday, October 08, 1999 6:19 AM > To: informix-list@iiug.org > Subject: Re: Physical Log size > > Link, David A. <DALink@West.com> wrote in message > news:7tjlri$ra$1@news…
Re: Physical Log size
Link, David A. <DALink@West.com> wrote in message news:7tjlri$ra$1@news.xmission.com... > > I have an OLTP database which I need to keep the checkpoints below 5 > seconds, however, my users need to load millions of records periodically. > The database needs to be available 7x24. …
Re: Physical Log size
as for OLTP environment you should set the LRU_MAX_DIRTY to 80 and LRU_MIN_DIRTY 70 so that the MLRU will be flushed to disk in between checkpoints. Setting the gap in between them smaller will encourage more LRU_WRITE and when comes to checkpoint it will have less work to do BT,…
ontape -c
When using 'ontape -c', for continuos backup of logical logs, what is the proper way to terminate the command? Is it simply a CTRL-C?…
Physical log size
How one can know correct size of physical log? Sun solaris 5.7 IDS 7.31 UC2A TIA…
HELP!!!
im looking at every logical log at 100% and naturally a blocked checkpoint. whats the best, and next best thing to do in a case like this!!!…
Re: Physical log status
---- you wrote: > I did a onstat -d, which showed all the chunks. I am a bit perplexed as > my physical log dbspace(chunk phylogdbs) shows a free of 0 pages. > > address chk/dbs offset size free bpages flags pathname > 2070482a8 1 1 0 2500…
Physical log status
I did a onstat -d, which showed all the chunks. I am a bit perplexed as my physical log dbspace(chunk phylogdbs) shows a free of 0 pages. address chk/dbs offset size free bpages flags pathname 2070482a8 1 1 0 25000 3897 …
physical log in rootdbs
Anybody have any comments about leaving the physical logs in rootdbs? I've heard some rumors about the fact that leaving them there isn't all that bad in the later versions of Informix. However, everything I've learned in class says to move them out of rootdbs. I'm running 7.30…
Re: logicallogs
From: him_lommel@t-online.de (Andreas Lommel) > >In the IECC database list my databases have the status LOGGING MODE - >no. >But the logical logs (onstat -l) are in use. Why ??? You will always have logical logs displayed in onstat -l, they're needed for DDL statements to run, w…
logicallogs
Hi there In the IECC database list my databases have the status LOGGING MODE - no. But the logical logs (onstat -l) are in use. Why ??? Thanks…
Logical and Physical Log questions
I am new to Informix, any help would be appreciated ! I have recently drop 3 logical logs as there were in the rootdbs. Then I added 3 logical logs in a different dbspace. I checked the logical log status and found it to have a 'A' flag. It seems that I have to archive it or it…
Onstat command
This is a multi-part message in MIME format. --------------DE4F14609E17179D45AF0716 Content-Type: multipart/alternative; boundary="------------73DD82890539D87E4735A41C" --------------73DD82890539D87E4735A41C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: …
Physical log size
I'm getting the following warning in my message log: 09:26:56 WARNING! Physical Log size 2000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times maximum concurrent user threads. M…
Lock Cycle Prevention for PDQ
Does some one have a meaning for the following output from PDQ (i.e. onstat -g mgm:) Resource/Lock Cycle Prevention count: 7495 What is this really telling me? Thanks Cheryl L. Kendricks Please reply to: kcheryl@notes.heb.com Since I am no longer monitoring this list!…
Logical logs
Hi Everyone , I am new to the administrative side of Informix Dynamic OL Server and would be gratefull if someone is able to give me a clear answer pertaining to increasing the size of my logical log file. I have tried adjusting the parameters in my confiuration files that did…
onstat -z
Is there any way to tell the last time someone ran "onstat -z"? This seems like it should actually be logged in the online.log file rather than having to rely upon my fellow DBA's to communicate the fact that they reset things. Especially when I have to monitor hundreds of syste…
Log Files Full
Error message: Logical Log Files are Full -- Backup is Needed Can anyone help me? Thanks in advance, Joao…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
onstat options....
Hi Users, Which is the best site(s) / Book(s) to explain in detail all the columns of different options in onstat. There are a few changes in onstat results from 7.2x to 7.3.... so need something which explains all these. Thanks in advance, Pramod ___________________________…
Re: Complete database re-org
Mark Collins wrote: > > > All, > > > > I am planning a complete database re-org for one of our Informix servers. > > The disk layout that I inherited when I joined the company is utterly > > unacceptable and must be changed. I'm drafting a step-by-step plan for this > > re-org, …
Re: onstat
In article <7hpivn$l4u$1@news.gte.com>, michael.talbot@telops.gte.com says... > Hello, > > Question from a unix/informix neophyte: > > > > When I issue the onstat command I get the following reply. Does anyone know how to resolve this? > > /tmp-> onstat > shared memory not initi…
Re: onstat
Either the environment variable INFORMIXSERVER is not set (or isn't set to the correct value) or the Informix database engine is down. What is the value of DBSERVERNAME in the ONCONFIG file? John Carlson Informix DBA WHSmith USA Hello, > > Question from a unix/informix neophyt…
Logical log question
I was wondering if anyone could give me some helpful info on logical logs. Today I encountered a problem when I did an onstat -l, it showed that I had two logical logs recieving transactions. (I had the c flag on 2 logs) What could cause this and how can you fix this. Do you d…
Informix Online on IBM Netfinity
Hi, we want to buy an IBM Netfinity 5500 M20 (2 PIII Xeon) and run Online 5.02.UC6 on it under SCO-UNIX 3.2v5.0.5. Has anybody run this constellation? I've read in this Forum about troubles with Informix and RAID. Is it so? Any warnings, considerations and/or comments a great…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
onstat columns
Does anyone have a listing, even partial, of on onstat command column meanings? Informix's references are completely unhelpful, or nearly so, in describing, for example, what the "q-limits" column of "onstat -g ntd" means or how it's calculated, except for saying that the comman…
onstat -l
When my machine is blocked in a CKPT, onstat -l shows ... Buffer Waiting Buffer ioproc flags L-1 57c6ab54 0x1 0 L-3 57c69884 0x1 0 ... which is not documented anywhere. I can guess what it means, but does anyone know what exactly it means (and what flags ar…
Any one know this?
Doug McAllister wrote: > > In whatever shell you are using set a variable equal to `onstat -|grep > OnLine|wc -l` > if the variable = 1 then the engine is up and running. You mean: onstat -|grep "On-Line"|wc -l Informix Dynamic Server Version 7.30.UC6 -- On-Line -- Up 00:43…
Logical Log
This is a multi-part message in MIME format. ------=_NextPart_000_0084_01BE5CC0.3EFB85E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear User, I have been trying to get a large file loaded on a database with = transaction loggin…
Posting from the Informix-list
Hi I am running IDS-7.3 My logical log device is set to /dev/null. The following message is displayed on my screen: "Logical Log Files are Full - Backup is needed" When I do a onstat -l I can see that all the log are full but also backed up. Am I missing the train? Can any b…
Informix on AIX
We are an AF site wishing to run Informix 7.3 on IBM's AIX on a RS6000 Are there any FAQ's or pointer or gotchas that would be useful in this environment??? thanks steve…
RE: onstat -t
onstat -t shows tblnum in hex. So you can link it with hex(partnum) of systabnames to get your tablename. HTH Sathish -----Original Message----- From: David Tamburin [mailto:david.tamburin@protegrity.com] Sent: Wednesday, January 27, 1999 4:16 PM To: informix-list@iiug.org Subje…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
Informix & IBM Data Joiner
Hi all, Does anybody use Informix DS and IBM Data Joiner If the answer positive what are the pluses and mineses Thanks ahead, Alex ---------------- TERN Technical Support mailto:alexs@tern.ru…
Re: Delete Logical Logs
jlsmith269@my-dejanews.com wrote: > > I am trying to delete some logical logs that are sitting in my rootdbs. When > I use the onparams -d -l 1 command to remove log 1, I get "Can only drop an > unused logical log". I am running version 7.3. When I look at my > logs(onstat - l…
Delete Logical Logs
I am trying to delete some logical logs that are sitting in my rootdbs. When I use the onparams -d -l 1 command to remove log 1, I get "Can only drop an unused logical log". I am running version 7.3. When I look at my logs(onstat - l), They show U_B, which is used and backed u…
Roll Forward Logical Log
Hi, Just wondering if I create my temp table 'with no log' option in my stored procedure. Do I have a problem rolling forward my logical log as the temp table will not be logged ?? Thanks JH…
Logical Logs
Hello, just two simple questions: What is a logical log ? Are the logical logs stored on tape automatically with the "ontape -s" command? Best regards Andre…
Req. Informix Statistics (for Db Management)
Hello, I'm a new Database manager. In order to check Informix i've created a script that checks the following environment diskspace (bdf) dbspace (onstat -dD) tablespace (onstat -t) logical logs (onstat -l) messages (console.log, onstat -m, online.log) How can I check the last…
onstat -h
Does anyone have any info about the meanings of the output of the onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in the 7.3 Admin manual, and I'm trying to document it. Thanks, joe -- -------------------------------------------------------------------------…
Re: Monitoring lock tables
June Tong wrote: ... > select username, sid, dbsname, tabname, l.lk_type lock_type, l.lk_kvobj > rowid, lk_keynum key_num > from sysrstcb r, syslocktab l, systabnames t > where r.txp = l.lk_owner > and t.partnum = l.lk_partnum ... The 'onstat -k' command shows 2 locks more than Y…
Logical Logs
Hello List, I have ten logcal log under IDS 7.30 and when I take backup through ontape -a and when I see the status of logical logs using onstat -l the percentage used does not change however I get a backup flage B additional. But Is it not that the %used should become Zero ? …
logical logs
Hi, The L.Logs on my system after a L.log backup normally shows a status of "U_B_ _ _ _" They are backed up as soon as they are full thro' the ALARMPROGRAM. 1) However suddenly some of the logs show a status of "F _ _ _ _ _ _".Though this might mean the same as "U_B____" , Any id…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
Re: onstat
Gabriel Weisz wrote: > > I tried to run onstat not as user informix and i got > onstat:Share memory:permission denied. > The env. looks fine , the informix server is up. > I am running 7.23. You have to have Informix priv. to run onstat ? No. Check the permis…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
onstat -t output
Hi, The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' and 'npdata' have non-zero values . Why is this so ? TIA Sathish…
how to determine the physical size should be ?
We keep getting an error on consule WARNING! Physical Log size 4000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 20 times maximum concurrent user threads. when we run the onstat -u …
Onstat -R
Can someone explain the onstat -R headings.. Is the percentage free or used. Been digging thru the texts.. examples but little explanation? INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- 36320 Kbytes 8 buffer LRU queue pairs # f/m length % of pair…
Re: Is it really necessary to mirror the physical log?
Art S. Kagel wrote: -- SNIP (Original question) -- > Truth be told the result of Logical Recovery without Physical Recovery > is the same if all logical log records are available. This is > mathematically provable. HOWEVER, having said this, the engine WILL > NOT come up if it …
Re: Is it really necessary to mirror the physical log?
Art S. Kagel wrote: -- SNIP (Original question) -- > Truth be told the result of Logical Recovery without Physical Recovery > is the same if all logical log records are available. This is > mathematically provable. HOWEVER, having said this, the engine WILL > NOT come up if it …
Re: Is it really necessary to mirror the physical log?
Jacob Salomon wrote: [SNIP] > Q: If I choose not too mirror the dbspace containing the physical log > and that DBspace gets corrupted, is recovery still possible without > going back to archive tapes? Would fast recovery still work, albeit > with the possible loss of some recent…
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.…
onstat -g ...
Hi guys, Where I can find explainations about the output format (headers and key words) reported after executing onstat -g ... In the Informix Administrator's Guide there is an explaination of all other options of "onstat", but for "-g" option I did not find detailed informati…
onstat -k
Thanks to everyone who answered the onstat -k tblsnum question. I appreciate it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-1275 Colorado S…
onstat -k
How would one link the tblsnum field of an onstat -k with a table name? Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 3008c64c 0 4004a354 0 HDR+S 100002 230 0 3008c680 0 40042814 0 S 100002 22f …
DB 7.21 (HP-UX 10.20) hangs while backup
We do a backup with onbar suddenly the Database processes hang When I start for example onstat -l the process hangs and i couldn't kill this process with kill -9. I can't kill any informix process with kill -9. I must do a reboot. After the reboot the Database starts correct unt…
onstat -u
Here's a good question. Sample: 4004d214 Y--P--- 4999 dbolte 91 40c936d8 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 …
How to size the logical log ?
Hello Guys, Does anybody know how to calculate the size of the logical logs ? What does the logical log size based upon ? What are the factors ? I want to backup the logical logs very often to avoid disaster. How does informix backup logical logs ? …
onstat and tbstat
Hi, We have just upgraded from 5.x to 7.x. Those tbxxxx files are now onxxxx files, but they still exist lots of tbxxxx like tbstat, tbmonitor, and so on, are these files different from the new version onstat and onmonitor or they are the just the same but with different names??…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: What is the best way to backup logical logs ?
Timothy_Lam@crow.bmc.com wrote: > > Hello, > > What is the best way to backup logical logs to remote machine? > Should I kick it off when the logical log becomes full ? > Does anyone has any examples ? > > > What is the recommend size of logical logs ? Ho…
What is the best way to backup logical logs ?
Hello, What is the best way to backup logical logs to remote machine? Should I kick it off when the logical log becomes full ? Does anyone has any examples ? What is the recommend size of logical logs ? How do you calculate ? Rdgs Timothy…
Long transaction
I think I have a problem, but I'm not sure. I did an onstat -g ses and it said 'BLOCKED LONGTX' I did an onstat -l and have over 50% free log files available. 1. Is this a critical problem? 2. If so, what do I do about it? Thanks in advance, Joe…
Re: physical log space problem
Mark D. Stock wrote: > > Kai Stuke wrote: > > > > With a recent installation of Informix 7.22 TC 1 on NT 4.0 SP1 I am > > experiencing a problem with the physical log space. > > When Informix starts up it issues a warning message 'physical log > > space 100 is to small, must be n…
physical log space problem
With a recent installation of Informix 7.22 TC 1 on NT 4.0 SP1 I am experiencing a problem with the physical log space. When Informix starts up it issues a warning message 'physical log space 100 is to small, must be number of user threads * 20'. The Informix manuals tell me abou…
Re: Who is blocking ?
Rainer Schaub wrote: > > I can tell you the solution for OnLine. > Make a onstat -u and onstat -k. > The one who has a L , at onstat -u at the first position on > flags, is blocked. > You have to take the "wait"-adress of this process and have too look > at onstat -k at ad…
Re: Who is blocking ?
I can tell you the solution for OnLine. Make a onstat -u and onstat -k. The one who has a L , at onstat -u at the first position on flags, is blocked. You have to take the "wait"-adress of this process and have too look at onstat -k at address. the owner-adress from this r…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
logical logs
Hi I am running Online 7.23 on HP 10.20 Why was logical log backed up every 2-3 minutes? Is there any hint not to make that backup too fast? Here is the info... 11:07:08 Logical Log 608 Complete. 11:07:09 Process exited with return code 133: /bin/sh /bin/sh -c /usr/informix/…
Onstat Utility
Hi, I'm using onstat -g ath and see threads that are slleping forever. What could this be? Are users not exiting properly from Informix? How do I kill these processes. Thanks Bob…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
Informix Online & IBM HACMP
Does anybody have any experience setting up Informix Online 7.x in an IBM HACMP environment? I am thinking about setting up a 2 node R/40 system to support a multi-database environment with about 3 to 4k users. Has anybody done this? Does it work? Is it as complex as IBM and …
RE: Logical Logs on OWS 7.20 UC2
Hi Ramp! Even in a non-transactional environment, the Logical Logs will be used. The administrative tasks performed by the Informix threads will be using the logical log space, even if you don't any database with LOG. When you set the /dev/null, Informix automatically will set …
Logical Logs on OWS 7.20 UC2
What i don=B4t know is what happen when the logical logs get full in a no= t transactional evironment and with then devicel for logical logs set to /dev/null . I will get a dead lock or the logs get empty when On-Line need more space. -- = Un saludo civil http://www.svalero.es/…
Re: Logical logs are backed up but seen as not freed in onstat -l
In article <3399DA10.C5B@columbia.edu>, Boris Niyazov <ban5@columbia.edu> writes >I've just upgraded my Online 5.07 to 7.22 DS (Solaris 2.5.1 Sparc). >What I am noticing that while I am runing continious backup ontape -c, I >see that logical logs are backed up ok , but they appea…
Re: Logical logs are backed up but seen as not freed in onstat -l
On Sat, 07 Jun 1997 18:00:48 -0400, Boris Niyazov <ban5@columbia.edu> wrote: >I've just upgraded my Online 5.07 to 7.22 DS (Solaris 2.5.1 Sparc). >What I am noticing that while I am runing continious backup ontape -c, I >see that logical logs are backed up ok , but they appear a…
Logical logs are backed up but seen as not freed in onstat -l
I've just upgraded my Online 5.07 to 7.22 DS (Solaris 2.5.1 Sparc). What I am noticing that while I am runing continious backup ontape -c, I see that logical logs are backed up ok , but they appear as not freed in the output of onstat -l . Their status remains U-B-- . They are no…
Re: oninit -r
In article <5lqin1$i9m@cssun.mathcs.emory.edu>, thucn@email.utcourts.gov (Thuc Nguyen) wrote: > Hi everyone, > >I restored a full system from the tape and then started online. I checked >onlog file. The warning message: Physical Log size 0 is too small. >Physical Log overflows…
Onstat question
When we use the Onstat -u , sometimes we get this display: onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 332c020 ---P--D 0 inf…
Re: Why long transaction cannot rollback?????
I am not sure whether this applies to your version of Informix; however, I was told in a performance and tuning class that the system will examine the logical logs after passing the high water mark and examine the processes active in the current logical log. If one has five logic…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Thanks for your suggestion. However, we had already set the logical log backup device to /dev/null. In this case, what causes logical log full? Sincerely yours, Xiaohui Shen…
onstat options
Hi, What are the best indicators of response time, trans/sec, and general load for monitoring an informix database... using the onstat program? Any help would be appreciated. Thanks Mark~…
Re: onstat
Steve Romankiw wrote: } } In onstat, what does "total" refer to. } } . } . } 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } 0 } 13 active, 128 total, 44 maximum concurrent } } Thanks. } } Steve Romankiw } Executive Risk Inc. For Online 7.1, the total fi…
Re: Physical Log Boundedness...
In article <E54x54.24r@nonexistent.com>, Jacob Salomon <jake@apparel.net> writes >Greg wrote: >> >>To clarify: by bounded, I mean being limited by the ability to write to >>the disk fast enough to not block the CPU waiting for the I/O to >>complete. >> >>> >>>Anybody got some goo…
Re: onstat
Carol Davies wrote: } } Steve Romankiw wrote: } > } > In onstat, what does "total" refer to. } > } > . } > . } > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } > 0 } > 13 active, 128 total, 44 maximum concurrent } > } > Thanks. } > } > Steve Romankiw } >…
Re: Physical Log Boundedness...
Greg wrote: > >To clarify: by bounded, I mean being limited by the ability to write to >the disk fast enough to not block the CPU waiting for the I/O to >complete. > >> >>Anybody got some good tricks to relieve Physical log boundedness when >>doing massive Insert/Update/Deletes??…
Re: Physical Log Boundedness...
To clarify: by bounded, I mean being limited by the ability to write to the disk fast enough to not block the CPU waiting for the I/O to complete. Greg wrote: > > Anybody got some good tricks to relieve Physical log boundedness when > doing massive Insert/Update/Deletes??? > > T…
Re: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
Physical Log Boundedness...
Anybody got some good tricks to relieve Physical log boundedness when doing massive Insert/Update/Deletes??? Thanks - Greg…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
logical logging
Hi I have a question to ask. I am on HP 9.0 O/X with online 5.12 When I changed to /dev/null on the primary drive from /dev/ifmx/1m and then turned off the B logging, then I ran the sql script after long transaction aborted. Once the script was done, I turned the logging back …
backup and archive
We are trying to use one tape drive for the archive and the log backup. we wrote a script to do the backup log first, when this is done, do the archive. The probelm is that when to swap the tape from log tape to archive tape without physically checking to see if the log backup ha…
physical log, was: numerous checkpoints
Hi, do I need a big physical log, if server executes only SELECT statements. Thanks in advance, Saulius, Vilnius, Lithuania…
Re: numerous checkpoints
The two most common reasons for checkpoints are 1) the checkpoint interval has been reached and 2) the physical log is over 75% full. If the checkpoints appear to be closer than the checkpoint interval, I would guess that your physical log file is too small. Madison Pruet…
Re: Physical Log Size v5 -> v7
In article <567b4m$jt5@cssun.mathcs.emory.edu>, "S. Hanson" <scott@tiga.worldaccess.nl> writes >Hello, > >I have a small question concerning the size of the physical log. >According to the Online v5 Adm. Guide the size of the physical log should >be created from > >"..is that tot…
onstat documentation
Does anybody have any good documentation for onstat? In case it varies to much from one version to the other I have online 7.11UC1. thanks…
Re: Physical Log Size v5 -> v7
S. Hanson wrote: > > Hello, > > I have a small question concerning the size of the physical log. > According to the Online v5 Adm. Guide the size of the physical log should > be created from > > "..is that total disk space allocated to the physical log and the logical log > files…
Physical Log Size v5 -> v7
Hello, I have a small question concerning the size of the physical log. According to the Online v5 Adm. Guide the size of the physical log should be created from "..is that total disk space allocated to the physical log and the logical log files should equal about 20 percent of…
DBMS Internals: Transactions vs. Redo Logs
I'm still not clear regarding transactions and redo logs, which are important in designing a backup scheme. Here's what I understand: - On-line transactions happen immediately in memory - Another writer process, working with a little delay, reads the memory and writes the transa…
Online Physical Log Question
I am working on a system experiencing slow database insert/select throughput (HP9000 Online 5). I believe part of the problem is a very small physical log file size - 1MB. (The logical logs are also small at 1/2MB). I have 2 questions: 1. What impact does the physical log fil…
RE: WARNING! Physical Log size 1000 is too small
Dan, I had a similar message from a 7.10.UC1 OnLine (on HP-UX 9.04). Instead of the "...should be increased.." lines, I had "Recommended minimum Physical Log size is 20 times the concurrent user threads". Page 24-5 of the Level 7 Admin Guide discusses the size of the Physical Lo…
Re: autochangers and ontape
We use IBM RS/6000 J30 informix 6.0 with autoloader. I have the same question and hope to know how to use the autoloader in ontape or onarchive. EricSze…
WARNING! Physical Log size 1000 is too small
Reposting since I lost news access shortly after the first post ... I recently got this error message in my log file when I was doing some testing ... 23:28:43 WARNING! Physical Log size 1000 is too small. Physical Log overflows may occur during peak activity. Phy…
Informix-4GL and Informix-CGI
is there any one using Informix-4gl with Informix-CGI on a IBM RISC/6000? i have serious problems with libraries compilation.... camara@mula.mur.hnet.es…
PHYSFILE configuration parm
Today I was experimenting with some configuration changes, and encountered the following message in the Informix message log. (Using Informix 7.10) 23:28:43 WARNING! Physical Log size 1000 is too small. Physical Log overflows may occur during peak activity. Physical Log s…
Re: Freeing logical logs
In article <347cc$f3014.14d@news.leg.wa.gov>, fry_ja@leg.wa.gov (Jason Fry) says: > >. This is the output of the onstat -l command > >address number flags uniqid begin size used >%used >88d988 1 U-B---- 16 203acd 5000 5000 etc ..... …
Onstat -g ses Output
Does anyone know where I can get a explanation of the Onstat -g ses <sessid> output for Online DS 7.10? Thanks Cheryl L. Kendricks-DBA cherylk@spamis.jcdc.doleta.gov…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…
DRDA - HELP !!!
If there are anyone who have used Informix DRDA to link to the IBM DB2 please contact men via email. Any information on this issue is highly appreciated.…
AS400 v. DB2
Does anyone have any information comparing IBM's DB/2 to Informix?…
Re: informix & IBM's AIX
Andrej Urbanc <andrej_urbanc@at.ibm.si> writes: >Hello there, >Could comebody give me an answer on which versions of informix run >on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 >and ver. 7.1 on AIX 4.1 (with SMP support) or not? >Thanks & kindest regards, Andr…
informix & IBM's AIX
Hello there, Could comebody give me an answer on which versions of informix run on which versions of AIX. Is it that ver. 6.1 runs on AIX 3.2.5 and ver. 7.1 on AIX 4.1 (with SMP support) or not? Thanks & kindest regards, Andrej…
Re: Long transaction
I was being silly - I was thinking it was the percentage of the last log file not a %age of the whole logical log space. -- Tony McCartan Tony Mc (UK)…
Re: Disk partitioning
Valery, >I think diverge rootdbs and most accessible dbspaces to different >disks. >Am I right ? Oh, yes. *Try* to put the root db space on its own disk drive, the logical log db space on *its* own disk drive, and the physical log on *its* own disk drive, if possible. Informi…
Re: DBEXPORT help
> ANSWER - look at the current locks using tbstat(or onstat) using the -l > option. It would only take one user to have opened the database and not > closed it for this type of error to have occurred. You did of course mean tbstat/ onstat -k, didn't you Malcolm? -l is logs. ak…
Experiences with organizing Raw-Devices
Are there any rules to organize a Raw-Device for an Informix-Database ? 1. In practice it is useful to place the physical- and logical-logs in the "rootdbspace". The Databases should be in separate "dbspaces". 2. The LOGspace and the DATAspace should be placed, if possible, …
Informix on IBM 9121
The machine of our customer is IBM 9121. IBM offers for it AIX-ESA or AIX-370. The local Informix people don't know if there is or not an Informix version for that configuration. What do you know? THANKS. --- Andres Marianovsky andres@dia.edu.ar…
Physical Log and Logical Log
Hi Folks, I found some case at my friend's site. His Physical Log and Logical Log setting is : Physical Log size = 2000 Kbytes Logical Log size = 10000 Kbytes No. of Logical Log = 10 When he run daily 4GL-application with 70-80 users simultano…
Informix products in IBM SP2?
Will Informix support the IBM Scalable Power Parallel System (SP2)? A trade article (RiSc World Vol. 4, No. 5) claims Oracle 7.1 and Sybase Navigation Server will be available on this platform. curtis@crl.com…
Logical Logs
>Sender: news@srgenprp.sr.hp.com (News Administrator) > > We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. > Our tbconfig said LOGFILES 6 >>>>stuff deleted > LOGSIZE 500 > My question is: Is there an optimum balance between LOGFIL…
Re: tbcheck problems HP9000 G30
[ Bill Glidden writes: ] > Joe, > > It is because the physical log is not located in the root dbspace. It is a known > problem, and can be duplicated by creating an OnLine instance and moving the physical Can I have more specifics here. We are currently running many engines non…
Informix 5.0.1 for IBM RS6000
Does anyone know if this available? If not when will it be available? Rick Hamel…
logical logs
I am running informix-online 4.00.UH2 on a Pyramid MIS-12/05 (OSx 5.1a). Part of the output from 'tbstat -l' is listed below: address number flags uniqid begin size used %used e0068944 1 U---C-L 5 100d64 250 66 26.40 e0068960 …