Oninit® Archive
Results for “onstat -L”
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…
Getting Error -271 On Batch Insert Randomly
Btw, the version of Informix is 11.10 THanks…
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,…
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…
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 ------------------------------…
Innovator-C download?
https://www.ibm.com/resources/mrs/assets/packageList?source=ifxids&lang=en_US Scott Pickett IBM Informix WW Tech Sales IBM Informix WW Cloud Tech Sales IBM Informix WW Informix Warehouse Accelerator Tech Sales IBM Strategic Partnerships Boston, Massachusetts USA spickett@us.ibm.c…
How to detect if table has old-fashioned attached indexes (index pages in non-fragmented table partition)
oncheck -pT #Informix…
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 --------------------…
New utility: fcopy-table.pl, Perl application to copy/extract one table or view to another table
#Informix…
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: …
Spaces and Spindles: Thought Experiment
For extra credit, consider having two dbspaces for logical logs (odd and even). DG…
RSS over SSL
Hi, Maybe this article could be helpful https://www.cursor-distribution.de/en/community/community-informix/84-informix-t echnische-infos/1224-informix-ssl-connection Cheers Erik…
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…
Informix 14.10 Innovator-C
Informix 14.10 Innovator-C no available for download, why?…
Connection Managers not forwarding connections
There was an OS/bios upgrade not informix…
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?…
Moving a file from one server to another server
check out the the 'system' command for Informix SPL.…
Re: 12.10.FC9 1809 Error
first i've installed with root, then with informix but the same issue ls -lt $INFORMIXDIR lrwxrwxrwx 1 informix informix 12 Apr 16 10:05 /app_ifx/informix -> ifx12.10.fc9 ls -lt $INFORMIXDIR/bin/oninit -rwxr-xr-- 1 informix informix 45269121 Apr 17 08:54 /app_ifx/informix/bin/on…
Continous logical log backup stuck - primary
Informix 12.10.FC10…
Does DBD::Informix support SSL connections ?
Does DBD::Informix support SSL connections ?…
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}'`…
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.…
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…
Cannot Connect To Newly Installed Informix
141 is the IP of the informix virtual machine.…
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.…
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.…
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…
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 …
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.…
best index method for heavy update and read table
Hello, forgot to say the informix version is 11.70 Thanks pushpa…
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…
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…
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…
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…
Update fields of a table from a list
The Database is Informix SE 7.25…
Informix Training for Informix Users
Hello, Free Webcast - Database Driven Websites - Using PHP with Informix by Thomas Beebe, Advanced DataTools Corporation You are invited to attend our next Webcast on Tuesday, February 12, 2013 at 2:00 pm, Eastern Standard Time What do Wikipedia, Facebook, Wordpress, and Yahoo…
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 …
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.…
Informix diversification?
http://www.wholesale-tablet-pc.com/ViewDetails140.aspx -- Ian The Hotmail address is my spam-bin. Real mail address is iang at austonley org uk…
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…
cant start informix on windows
yes are members of Informix-Admin group Role seperation not enabled…
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.…
Newbie to Informix
Hello, I'm currently working on expanding my knowledge and would like to work more on the database side of things. I would like to learn more about Informix, as a newbie, and would specifically interested in learning how to run queries from it. My hope is to eventually t…
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…
Informix & Splunk
hi all has anyone had experience with using Informix and Splunk? if so, care to share thoughts, experiences, etc thanks…
Migrate Oracle/MSSQL to Informix
With Informix it is easier to learn also. I learned DBMS concepts easily and quicly with Informix than oracle. For me Informix is Simply the Best & Love at first sight.…
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.…
IDS 11.7 - cannot create instance
PPS: INFORMIXDIR = /housing/informix/ids11_7 INFORMIXSERVER = v6live ONCONFIG = onconfig.v6live…
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…
Using CodeIgniter with Informix
Anyone has successfully using CodeIgniter with Informix ?…
Informix ... and marketing.
Informix ... and marketing. Please read this important post! : http://t.co/k0QfC0s #Informix…
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…
PHP and Informix?
Dear Informixers, it's been a long time since I've been active in this group. Our IDS server is just running smoothly, so I didn't need assistance. But now something new has come up: We have a web application in_house that our department wants to participate in. The application…
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…
informix on windows
Hi All Has anyone ever run Informix on Windows using an account other than the Informix account? It is being suggested that we run it as a Windows Domain/System Account instead but I don't know if that will even work or not - We have always run Informix using the Informix accoun…
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…
Error starting IDS v10
mol_dev : /usr/informix/etc> ls -l /dev/rdevrootdbslv crw-rw-rw- 1 informix informix 39, 38 Oct 7 12:16 /dev/rdevrootdbslv…
"Re-indexing" Informix
My users, having been raised on whOracle, seem to believe that if we drop all 40 GB of detached indexes from our 180-GB database and recreate them, without changing anything else, it will improve performance, just like in the other DBMS. Despite my explanation that Informix use…
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.…
informix drivers
Hi all, some folks here argue that in future IBM would drop the support of Informix drivers like PDO_INFORMIX for the benefit of db2 drivers or has it already done. Would you agree with that opinion? Please, no new flame debate but a realistic estimation. Reinhard.…
ER template realization problem
Yes on both servers the owner is informix, and user informix has the same privileges too…
Informix Mirroring
Hello, I was reading up on Informix Disk/Chunk Mirroring and was wondering if anyone has any experience using Informix mirroring versus O/S or Hardware mirroring relating to performance? Also, is this a typo in the Informix documentation for mirroring? See the sentences, "On t…
Informix in the Press
Informix makes it into The Register! http://www.theregister.co.uk/2010/01/11/ibm_lawsuit_bgc_informix/ -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous…
Informix FAQ
Hi, I send this question to the list because the address which is mentioned as maintainer of the FAQ (david@smooth1.co.uk) doesn't work: I wanted to search the FAQ as member. Unfortunately the link to search (http://www.iiug.org/members/search_faq.html) does not work. The resul…
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…
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…
onaudit problems after upgrading from11.10.FC2 to
using informix . role separation not being used…
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…
Fastest Informix DBA Contest II
http://www.advancedatatools.com/Informix/…
Informix and Security?
Hi, This may be a question that Jonathan will have to answer.... If I understand some earlier posts, Informix now requires an IBM library that has to be installed in a specific directory in order to do encryption. The good thing is that this software library can do certified F…
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 …
Extracting logical logs from a level1 archive ?
Is it possible to extract the logical logs from a level1 archive to use for rolling forward ?…
Informix Blogs
http://www.ibmdatabasemag.com/blog/main/archives/informix/index.html -- }(:…
Informix Brand?
Its great to see some heated discussions about the product and marketing issues. Serge alluded to something that hasn't really hit the streets and thats the branding effort of IDS and DB2. Yes both are truly brands in the context that there are a couple of different flavors of e…
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…
Difference between 32bit Informix and 64bit Inform
What are the difference between 32bit Informix and 64bit Informix version?…
Dbspace creation
Output for /dbspace2 and /dbspace2/db1 drw-rw---- 3 informix informix 4096 Nov 7 07:31 /dbspace2 -rw-rw---- 1 informix informix 0 Nov 7 07:31 /dbspace2/db1…
Cannot issue oninit to IDS 11.5 on Windows Vista
I should say that the informix user is a member of group informix- admin. Cheers R…
Re: Logical Log files MISSING
Bigger logical log files?…
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…
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…
informix+informatica
Hi Can informix be used as repository in informatica? Regards Deba…
Informix SE is dead?
Any news on the fate of Informix SE? PN…
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 …
Informix 11
What is the best version of informix 11 at this time. We are planning to upgrade from Informix 10FC* and Informix 10FC4 ( one instance) to Informix 11. Not sure whather to go to Informix 11.1 or Informix 11.2 or Informix 11.5 at this time. Any guidance will be appreciated. than…
Sentencias preparadas en Store procedure
perdon informix 730…
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 …
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…
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…
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…
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…
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…
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…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
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…
oninit
-rw-rw---- 1 informix informix 0 apr 25 17:00 /informix/dbspaces/online_root…
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…
Deny connect over network user informix
Hi, it's possible to deny connection to the informix database over tcp with user informix? So user informix works local only. Thanks Marco…
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 …
Informix
I have ids7.3 runninig on hpux.I have the following error when i run oninit: Fatal error in shared memory creation'.I got this error message after sucessfully restoring the database with last year's tape.I tried to reboot the server so that i can free the shared memory but ,this …
record locked
a combination of onstat -k and onstat -u…
How can I import easily data from an XML file....
into Informix Database? Thanks in advance!!!!…
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…
who locks a record?
onstat -k followed by an onstat -u…
Re: Trusted Hosts facility implementation frustration
Would Informix I-spy be of any use for this?…
Need Informix IDS 9.5
I need Informix IDS 9.5 256 users.…
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.…
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: the ugly Americans and how the IIUG will save Europe
the DB2 magazine includes a reasonable section on Informix…
RE: Merry Christmas & Happy new year
"Damn it Jim I'm a doctor not an Informix marketing agent"...…
Re: Merry Christmas & Happy new year
Kwanzaa: http://www.officialkwanzaawebsite.org/ sending to informix-list…
Informix helper?
exist Informix helper?…
Cannot put Server Online in Informix 7.31
oopps it should read crw-rw---- informix informix.... Superboer.…
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…
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?…
rootdbs memory problem
agt122:(informix)/home/informix>oninit -iy oninit: Not enough room in ROOT DBspace. Requested 213638K, ONCONFIG value 'ROOTSIZE' 160000K. oninit: Fatal error in shared memory initialization agt122:(informix)/home/informix>…
Re: Horny Teen Girls
Hows their Informix?…
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…
Re: NEED RPG2/UNIBOL36 anything to do with Informix
What does this question has to do with Informix ?…
Transaction Rollback
onstat -x…
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…
RE: Oracle 9.2. on AIX 5L
I suggest you buy Informix instead of Oracle…
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 …
log files - maximum?
Informix 7.31UC4 Whats the maximum log files allowed?…
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 ______…
Informix
About Informix --> http://en.wikipedia.org/wiki/Informix Regards, Chavan Koya…
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…
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.…
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…
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…
If You have an option to move from 7.3 to 9.3 or 9.4. Which one
Thanks Basheer sending to informix-list…
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 …
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…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
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…
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 …
INFORMIX
Hello, I am an user that needs to begin in the topic of DATABASES of INFORMIX. I want to find information about that it is INFORMIX. Could you indicate me where I can find this information? Thank you for your attention. Cordial greetings. -- ***********************************…
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 …
informix
how i can find the version i have i think its 2.1 from sco thanks…
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?…
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…
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…
Informix
I'd like to know details about INFOEMIX, what is it? What is it for? I'm a student at one university and have to do my assignment about it, but unfortunately, I cannot find any books on this topics. Or it's grateful if you can recommend me sone internet sites that have details, b…
Re: set debug on : permission problem
hi there, are you refering to $INFORMIXDIR/bin ? if yes then output as below -rwxr-xr-x 1 informix informix 3150016 Jun 29 14:19 QA_cockpit -r-xr-xr-x 1 informix informix 1045675 Mar 28 1999 ansrd -rwxr-xr-x 1 informix informix 3007104 Jun 29 14:18 archecker -r…
Re: set debug on : permission problem
hi there, are you refering to $INFORMIXDIR/bin ? if yes then output as below -rwxr-xr-x 1 informix informix 3150016 Jun 29 14:19 QA_cockpit -r-xr-xr-x 1 informix informix 1045675 Mar 28 1999 ansrd -rwxr-xr-x 1 informix informix 3007104 Jun 29 14:18 archecker -r…
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…
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…
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…
remove informix-list
Remove informix-list…
remove informix-list
Remove informix-list…
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…
��� ������� ����������� � informix
мЕНАУНДХЛЮ ОНЛНЫЭ - ПЮГНАПЮРЭЯЪ Б informix РЕК:332139 e-mail:kokota@chat.ru…
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…
How to start Informix on NT when running as a "non-informix" user
Hi! When I log onto NT as informix I can start informix (oninit). When I try to start informix as a different user I get: D:\\informix\\bin>oninit Only user informix can start Informix Dynamic Server. Does anyone know of a way around this? TIA! Roger…
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…
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.…
Informix
Hi everyone, I am new to programming and Informix. What will be most helpful? Where do I go to see how each table affect each other? Should I do a sql? Trainee, John…
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?…
Test. Empty.
Informix list. Test message.…
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!!!…
Informix
We are looking for an Informix guru. 10+ years experience. The salary is open. The position is in the Dallas, TX area. Please forward your resume to dylanriedconsultants@hotmail.com…
Informix Certification Exams
There are sample questions on the Informix website.…
informix
GO HERE TO GET PAID WHILE YOU BROWSE THE WEB! http://www.gotoworld.com/getpaid/default.asp?rid=1023195981…
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…
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: …
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é…
informix ??
Quelqu'un peu-t-il m'expliquer comment utiliser la base de donn�e INFORMIX sous UNIX sur IBM RISC 6000 ? Somebody can explain me who to run under UNIX on IBM RISC 6000 ? Personne ne sais l'utiliser et moi je suis sp�cialis� enmicro PC avec quelques notions de Unix et de C Nobody…
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: 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…
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…
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 IDS on Informix
Informix has released IDS Linix Suite and is available for download (or in CD) from either RedHat or Intranetware. This is a try and buy version with 30 days eval period. I am not sure what happens after 30 days. Anyone?? Enjoy..... Happy New Year..... Idiot…
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…
INFORMIX to INFORMIX connection
Hi folks, We are using Informix DS 7.23 on Windows NT 4.0 Boxes. We have several Database servers. The problem is; I am tring to select data from one database server (e.g: server2) while connected to another one (e.g: server1) via SQL. Such as; suppose we are connected to db1@…
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…
subscription
Subscription to Informix list…
!US - Informix Positions
Informix development and DBA positions available around the US http://www.premierjobs.com/informix…
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…
US - Informix jobs
Job postings for Informix Professionals http://www.premierjobs.com/informix…
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…
Posting from the Informix-list
Subscription to Informix-list…
Informix DBA's and Developers needed around the US!
http://www.premierjobs.com/informix…
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
-Informix
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
INFORMIX
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
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…
informix
informix…
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…
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…
Girish here
I have working experience in Informix and with Informix arround 2 years on variety of Informix products. can send my resume to you. I am in OR thx comp.database…
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…
!US - Informix DBA's and Developers needed
Informix DBA's and Developers needed in Phoenix, AZ and around the US. http://www.premierjobs.com/informix…
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…
informix?
What is informix?…
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…
- Informix?
Can anyone help me? I'm looking for someone with informix and 4gl sql skills to start a six month contract in London but am having no success!! - Do these people actually exist? If you can prove me wrong (and would love this contract!!) please contact me at the below - my last …
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…
! US-Informix DBA's and Developers needed
Informix DBA's and developers needed in the US. Check us out at http://www.premierjobs.com/informix…
Informix
Hi, Where can i get ODBC drivers for Informix. I've got the Crystal Reports drivers, but they give error code 126?!!! Please help…
Informix
Is it possible to use informix databases from a Visual Basic client without using ODBC driver. And what about delphi possibilities for this question Thanks…
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/…
<No Subject Supplied>
REMOVE INFORMIX-LIST SUBRAMANYAM MEKALA THANKS…
<No Subject Supplied>
REMOVE INFORMIX-LIST SUBRAMANYAM MEKALA THANKS…
<No Subject Supplied>
REMOVE INFORMIX-LIST TERRON WRIGHT…
<No Subject Supplied>
REMOVE INFORMIX-list@rmy.emory.edu…
Informix?
Wow, this is still here so I guess the company is too.…
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…
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/…
Apple and Informix will announce merger
Apple and Informix will announce merger on Tuesday. This should cause both Apple and Informix stock to rise significantly. For details on the Apple and Informix merger, check out http://www.stocks4tomorrow.com…
Informix
Testing…
Informix
Informix…
!!! Informix DBA's and Developers
Informix DBA's and developers needed! Check us out at http://www.premierjobs.com/informix…
!!! Informix Developers and DBA's
Informix DBA's and Developers needed! Check us out at http://www.premierjobs.com/informix…
US- INFORMIX (60 Openings) informix, informix, informix, informix, informix, informix, informix, informix, informix, informix, informix, infor
JOB ID # Skill Set #Needed Location AJ 01 Informix 7.x DBA 6 Arkansas AJ 02 Informix 4GL 3 Arkansas AJ 03 C/ESQL 2 Arkansas AJ 04 Visual C++ 2 Arkansas AJ 05 Java 2 Arkansas AJ 06 Informix 4GL 5 Minnesota AJ 07 Informix 7.x DBA 2…
US- INFORMIX 7.x DBA Arkansas informix, informix, informix, informix, informix, informix, informix, informix,
JOB ID # Skill Set #Needed Location AJ 01 Informix 7.x DBA 6 Arkansas Immediate Start� ALL CANDIDATES MUST HAVE INFORMIX BACKGROUND. (Unless Oracle or another database is specified) Requirements: 1. Excellent communication skills 2. Travel 40-60% 3. Excellent written s…
!!! Informix DBA's and Developers
Informix DBA's and Developers needed. Check us out at http://www.premierjobs.com/informix…
!!! Informix DBA's and Developers
Informix DBA's and Developers needed. Check us out at http://www.premierjobs.com/informix…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
!!!Informix DBA and Devlopers
Informix DBA and Developers needed. Check us out at http://www.premierjobs.com/informix…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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…
INFORMIX
INFORMIX POSTING I.D. H01 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
WHY ?
Question... Why Informix ?…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: verify
The Informix key is NOT stored somewhere in the Informix software - contact Informix Uwe…
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: PRESS: Informix in the News
Informix reports a bad Q1.…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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~…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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: 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: 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…
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.…
INFORMIX
INFORMIX POSTING #05-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
(no subject)
REVIEW INFORMIX-LIST f=mail…
NO SUBJECT
Is there a special Informix 4GL newsgroup?…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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 …
Informix
I have a few users trying to compile 4GL modules using C. They are running Informix 4GL 4.2. The users that run the Microsoft TCP/IP hang at compile, while the ones using the Chameleon TCP/IP have no problems. Does anyone know of any solutions or known causes for this. Thanks.…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Informix
We used informix/unix for our applications and we are on the process in porting our applications to Window NT4. Does anyone know where I can get examples for converting the esql/c/unix version to Window NT, and examples for informix-CLI/ODBC using Visual C++? Thanks in advance fo…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
Re: US-FL- INFORMIX OPPORTUNITIES - CONSULTING / FULL TIME
In article <01bbe3c3$141ea0a0$8e02e3c7@gate.net.gate.net>, "Computer Careers Inc.," <careers@gate.net> wrote: > > >**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX >**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX**** INFORMIX >**** INFORMIX**** INFORMIX**** …
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
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…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 We are one of the leading recruiting firms in Informix in the USA. Our client database includes over 350 companies using Informix nationwide (in every city exceeding a population of 300,000 people). We are seeking experienced candidates at all levels…
INFORMIX
INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix DBA's should have some on-line experience, Uni…
INFORMIX
INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix DBA's should have some on-line experience, Uni…
INFORMIX
Reposting article removed by rogue canceller. INFORMIX POSTING #02-2140 International company seeks eight Informix programmers and two Informix DBA's. Programmers should have experience in one or more of the following: SQL, ESQL, C, On-line experience and Four Gen. Informix…
Subscribe
subscribe 'informix-list@rmy.emory.edu'…
Unsuscribe
Unsuscribe 'informix-list@rmy.emory.edu' apsf@server1.santafe.com.ar'…
NEED AN INFORMIX PROGRAMMER IN MPLS
Interested in working with an Informix contract programmer on a…
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 ..... …
unsub informix-list
unsub informix-list…
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…
informix
Hello, I have a problem with the connectivity between Newera on a PC, and the Informix server on the IBM platform. Situation: PC with Newera 1.0 and Windows 95. Informix server 7.1 on a IBM rs6000, AIX 4.1 The problem is when I start the tool of Newera I get the message that …
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…
Chicago Area Informix Usergroup???
Is there a usergroup in the chicago area for Informix users?? e-mail: zarion394@aol.com…
<No Subject Supplied>
Set informix-l DIGEST REVIEW…
(no subject)
Is there any good FAQ for informix?…
***INFORMIX DBA, INFORMIX DBA, INFORMIX DBA***
I HAVE 2 IMMEDIATE OPENINGS for INFORMIX DBA's in US/CA - SF Bay Area... 3-6mos. contract to join team and perform regular DBA duties as well as application development work.......Please contact Wanda Lee at (800)33-5339, or (415)788-8488, or wandal@toner.com, and/or fax resume t…
informix
Using 4.10.UC4 SE. In the reports section with 'option page length 66' and nothing fancy in tthe 'on every row', after the last line on the report is printed, informix then generates more than enough empty lines which send the report into the middle of the next sheet. It looks l…
Informix P/A, Informix DBA
We are looking for consultants for a six months contract, minimum: 2 years experience - Informix 7.0 DBA and UNIX Shell Script 3 years experience - Informix Programmer/Analyst, C/C++, UNIX Shell Script Fo…
[?]INFORMIX <--> INFORMIX
C> From: cpilot@teleport.com (cpilot) C> As the subject line suggests, my questions regard Informix to Informix > connectivity via I-Net where all Informix databases reside on RS/6000's. C> BTW, I will be running the Standard Engine on all (about 32) of these boxes. C> 1. Is …
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)…
No Informix WWW
What happened to Informix's home page? Its been screwed up for several days. Earth to Informix, come in Informix.…
Linux Implementation
Is there a Linux port for any Informix release?…
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…
Error 581 -- Need HELP
Whenever I use the 'set explain on' statement I get error 581 I can reproduce this error running Online 5.1 (SCO-Version) on my Linux box. The same error happens on Interactive Unix with Online and SE. As far as I can tell all the messagefiles are in their place in the msg subdir…
New Era & WFW
Hi Informixer's, simple question : why informix doesn't support NE on WFW...?…
FAQ on Informix?
Is there an FAQ on Informix RDBMS? Thanks.…
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 manuals online
I agree Informix should have their manuals online. Robyn…
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…
Did Price Change Happen
Did a informix price change happen???…
informix
We are in need of Informix expertise in two areas: 1) query optimization and the use of indexes, and 2) performance tuning using self-joins and outer joins. 1) We have a query that should use an index, but doesn't. When a second index is added to the table, the query now re…
Re: tblspace does not exist
this is what informix told me to do...…
Informix & Softbench
Informix users, We are using Informix & Softbench on our HP-700s. Any help on integrating Softbench & Informix? Thanx, N.Strifas…
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 …
Informix ...
Path: emory!wupost!tulane!uflorida!eng.ufl.edu!usenet.eng.ufl.edu!tsao From: tsao@tcad.ee.ufl.edu ( Tsao) Newsgroups: comp.databases Message-ID: <TSAO.91Sep15131210@neptune.tcad.ee.ufl.edu> Date: 15 Sep 91 17:12:09 GMT Sender: news@eng.ufl.edu Organization: VLSI TCAD, University …
informix
Path: emory!wupost!uunet!viusys!uxui!unislc!mrc From: mrc@unislc.uucp (Mike Cederholm) Newsgroups: comp.databases Summary: I desperately need help with importing data..... Keywords: help please with inport data Message-ID: <1991Aug29.065208.10269@unislc.uucp> Date: 29 Aug 91 06:5…
informix
Path: emory!swrinde!zaphod.mps.ohio-state.edu!ncar!noao!amethyst!hindmost!jgotobed From: jgotobed@lpl.arizona.edu (Joe Gotobed x4549) Newsgroups: comp.databases Summary: How's their support? Message-ID: <3047@amethyst.math.arizona.edu> Date: 15 Aug 91 19:27:38 GMT Sender: news@am…
INFORMIX
Path: emory!sol.ctr.columbia.edu!cunixf.cc.columbia.edu!cs.columbia.edu!news From: duanyang@cs.columbia.edu (Duanyang Guo) Newsgroups: comp.databases Keywords: Trouble-ticket, database management Message-ID: <1991Jul11.204519.9424@cs.columbia.edu> Date: 11 Jul 91 20:45:19 GMT Sen…
Informix Online <> Informix standard
Path: emory!samsung!uunet!mcsun!unido!logixwi!rcr From: rcr@logixwi.uucp (Rainer Ruppert) Newsgroups: comp.databases Keywords: informix, online, database Message-ID: <1991Jul11.114558.8396@logixwi.uucp> Date: 11 Jul 91 11:45:58 GMT Organization: Logix GmbH, Wiesbaden, W-Germany …