Oninit® Archive
Results for “onstat -P”
Row count by rowid does not add up to actual rows
Eric: While Jacob has solved his original problem differently, I have to respond to you and the others who commented on ROWIDs for partitioned tables. Let me repeat my previous post: THERE ARE NO ROWIDs AVAILABLE FOR A PARTITIONED TABLE! At least not "real" ROWIDs simply because …
Table /fragment size monitoring
Gábor: You will find the partition/fragment name in sysfragments.partition. Witness: > select fragtype, partition, evalpos from sysfragments where tabid = 344; fragtype T partition p1 evalpos 0 fragtype T partition p2 evalpos 1 fragtype T partition p3 evalpos 2 …
Recently appended logged partitions
Hello all and wish you happy new year. Is it possible to list tables/partitions for which (fake) level0 backup must be run to allow writing to it? There is a flag with value 32768 in sysptnhdr but this flag is on even after L0 backup is finished. Thank you Milan Rafaj Senior Lead…
Large memory segment vs smaller ones
Hi Dennis. Yes: " vmo -p -o v_pinshm=1". You must have RESIDENT 2 or more for large pages as they must be pinned. The "rsam" pool is in the dynamic segment. You need RESIDENT 2 or more. It doesn't sound like the problem is with the buffer pool but the "rsam" pool. Your BTR is fin…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
sysmaster/systabnames not refreshing
So what you're describing sounds like, despite its name, this is the partition of a regular table created in said database, yet well after the dbimport. The only logical explanation for such partition surviving the drop of the containing database, in my view, is: it wasn't part o…
Errors occurred while cleaning dbspace
Then it seems to have been a case of some internal activity having allocated a temp partition early on, before/during temp partition cleaning (hence iserrno 113 ), and the partition got cleaned up automatically once that activity completed. ------------------------------ Andreas …
INFORMIX TABLE SIZE
Indika: First, except for VERY OLD tables that were created before v7.20 (where index pages were part of the table's partition - since 7.20 indexes have had their own separate partitions) the page counts for a table only include the table data itself and internal overhead, no ind…
Want to DROP an empty rootdbs chunk
David: No. The tablespace tablespace in each dbspace is treated like any other table. It has extents linked to its own partition page (the first page in the tablespace). That partition page holds a list of extents. If the space for extents on the initial partition page fills, THE…
A lot of extents in temp tables
Leandro: You can defragment tables and indexes most easily using the "defragment" SQL API function in the sysadmin database. For tables: execute function task( 'defragment', 'database:owner.table' ); For indexes (or to defragment a single partition of a partitioned table): execut…
Phantom rsccompdict table
Hi David, I know there's logic to prevent a dbspace from appearing non-empty because of only remaining rsccompdict partition, but on chunk level there's no way such rsccompdict extent could be made to go our of your way when trying to drop such chunk. And no, unfortunately there'…
%Cached using onstat -p vs %Cached using onstat -g buf
I am on Informix 11.70, and I am grabbing metrics to record. One of them is the buffer write% for each server. When running onstat -p , it shows the %cached as 90.60 . However when actually calculating the %cached, it yields 80.20. The 80.20 value aligns with the value from onsta…
Buffer wait occurs when performing INSERT in multiple sessions
You have to only peripherally related problems. The issue about not enough KAIO resources is an operating system tuning parameter. You can read the maximum value and set it here: $ cat /proc/sys/fs/aio-max-nr 65536 echo 131072 >/proc/sys/fs/aio-max-nr # set new maximum And see …
Index page size recommendations
16 k for indices is a good starting point. After that is depends on the data. If I am using TS then I would tend to have dedicate spaces as well. And yes you need a buffer pool for each page size. Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trade…
Partition number for external tables?
Hi Family. Enlightenment requested: I am working on a far better version (a considerable rewrite) of my FragmentList.pm package and fragments.pl utility tha tI had put up on IIUG some years ago. In the process I have made an interesting discovery in the sysptnhdr table in sysmas…
Table or index partition? Flags in sysptnhdr
Hello, would not help this info from sysmaster.sql (from 12.10.FC13)?: insert into flags_text values ('sysptnhdr', 262144,'Index Partition'); ------------------------------ Milan Rafaj ------------------------------…
sysblobs.spacename: partition, dbspace, or family
Hi Y'all. My current client has a fair number of tables with text and binary blob columns. However, no blob spaces; all blob column are in the TBLspace with the row. (Of course on pages separate from the row.) So I got curious about the way they are tracked and I ran this quer…
What is the maximum number of pages for an index in Informix 11.70?
I guess that answers the question definitively then. Ben was correct, indexes were limited to 2^24 pages per partition prior to v11.70 but no longer. Art ------------------------------ Art Kagel ------------------------------…
Table partition, ONLINE detach/attach issues.
Hello César, You're making a confusion between attached indexes ("in table") and indexes that follow the same strategy as the table. The attached indexes are, as you correctly state, deprecated and should not be used. What the feature requires is indexes that follow the same stra…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Problem with backup
Original post: Hello, every time we release a copy with onbar , the Database server gets blocked one to three minutes. Is this normal ? Our version is 12.10.FC3WE and the command is onbar -b -w Thank Response: The answer is possibly. At the start of every backup, the server…
Partition Blob page warning
Hi all, I m new to informix, kindly correct me if am wrong. our environment is linux and informix version is IBM Informix Dynamic Server Version 11.50.UC6WE Recently we had a table corruption in our database, so we ran "oncheck -cDI -y datbase:schema.tablename" for that partic…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
BUFFERPOOL Configuration
Oh, one more reason to use multiple page size buffer pools: - To be able to isolate the IOs against some objects from those of other objects so that, for example, index IO activity does not flush data pages from the cache.…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
partition limit
Hi, I have one server that my company use to give support to our clients. The server is using 12.10.FC10 version and we are facing one problem with partition limits. As we use one partition for all database and index also, the problem is that have dbspaces have less than 50% occ…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Informix 12.1 Blocking Checkpoints
> On 7 Nov 2017, at 10:48, NATYURAL HORACIO <horacio.natyural@gmail.com> wrote: > > Hi, > > > Based on the current workload, the physical log might be too small > to accommodate the time it takes to flush the buffer pool during > checkpoint processing. The server might block tran…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
identify what is allocating memory
original post: Hi , How identify what/who is consuming memory in a specific virtual memory segment ? With onstat -g ses , there is no session with high memory allocated. The amount of users sessions is keeping at regular average... No buffers pool was allocated automatically (I…
Buffer pools in 11.50.FC5
IDS 11.50.FC5 Solaris 10 Sparc I need some guidance on BUFFERPOOL. I am receiving the WARNING: Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user threads. I am not sure how that translat…
Solaris Slice 2?
It has nothing to do with partition 2 per se. It has to do with the Solaris partition software program fdisk which places the partition table in the first block of the device and the default partition 2, unlike the other pre-defined partitions, includes that partition table in it…
Long lasting dostats
Reinhard: Welllllll, you've got a table that, at least on the surface, seems to have on the order of 10^10 rows and you don't have PDQPRIORITY or PSORT_NPROCS set so this is a single threaded operation on a table that has well over 30 partitions (I keep losing count). It's just …
Add disk slice, live?
Thank you, Art. Good idea... I'll run it by Oracle tech support (the partitioning would be via Solaris 'format' command). DG…
Odd Bufferpool Behaviou
Original post: AIX 6.1 IDS 11.70.FC8X8 I have a new machine with a lot of extra memory. Given that, I added a bunch of new buffers (4k, 8k, & 16k) and went to town testing away. Long story short, with all those new buffers, I get virtual segments added at startup. In onstat -g …
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
systabinfo ti_flags and index partition
Greetings. Solaris 10, IDS 11.5 I am trying to write a utility to examine some internal structures within sysmaster. Specifically, a query concentrating on systabnames and systabinfo. I need to treat index partitions differently from a table partition. But how do I tell the dif…
Long checkpoint
A good start is to monitor 'onstat -F' continuously through the checkpoint. This will show which chunks are being flushed during a checkpoint. A common scenario is having everything waiting on a single chunk to flush towards the end. You can also monitor 'onstat -u' and check th…
Session "Waiting on a transaction"
Hello, I'm using Wildfly application server (JEE server) together with Informix 12.10.FC5 as the database on Oracle Solaris SPARC 10. It's using distributed (XA) transaction using 2 databases on the same instance in this case. On start up the server gets stuck at some point and …
Informix upgrade Error
Hi, I am getting following error during IDS version upgrade From IDS11.50.FC8W3 to IDS12.10FC4W1. 22:53:58 IBM Informix Dynamic Server Version 12.10.FC4W1 Software Serial Number AAA#B000000 22:53:58 Conversion from version 11.50.xC6 Started 22:53:58 Checking partition header pa…
Partition Blob Page Sharing???
Morn'n Folks, IDS 11.70.FC8 O/S Linux I want to know if different text columns from the same table will share the pages they use for the actual blob data. IE... If column1 is text and has a length of 1200 bytes, and column 2 has another text column with a length of 800 bytes, w…
Compression Question/Understanding
I suspect the ability to reclaim the free space does not come along until version 12 for partition blobs. I found a white paper out on IIUG on Compression: http://www.iiug.org/library/ids_12/IFMX-Compression-WhitePaper-2013-03-22.pdf Coalescing (repacking) the rows After a par…
Rename a partition
Greetings. I may let the IBM manual writers off the hook on this one owing to a 12.1 manual when I'm using an 11.5 server. I'm trying to rename a partition within a fragmentation strategy. My practice table, before I try this surgery on the production server, is defined as: cre…
ALTER FRAGMENT to a dbspace with a differnt page s
[ ... snip ... ] > Does that mean all the dbspaces of the various partitions must all have the > same page size? This seems unlikely, since it is common practice to have data > and index partitions with different page sizes. Yet, this is exactly my worry. Hi Jacob, all DATA pa…
Long Blocking Checkpoint Duration And IDS 12.1 Msg
Is the previous message just an informational message or could the checkpoint have been long and blocking due to the Partition Extend. Do partition extends affect checkpoint duration ? Thanks A Lot!…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
wait for mutex
Folks, Normally I do not see S---- in output of onstat -u, but now I see. Any comments? Thanks Frank RHEL 6 [informix@walter ngdc_er_20140820]$ onstat -u IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:38:50 -- 11847728 Kbytes Userthreads address flags sess…
fragment estimate_compression Partition is not in
Hi, We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version 12.10.FC3E I get lots of this kind of error messages, where could i start finding reason for them? 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243371 15:…
Physical Log Size
IDS 11.70.FC8 AIX 1 6 00CC96664C00 I received the following message in the online.log file ..... is it something to be concerned about ? Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoi…
new bufferpool
original post This concerns ids12.10TC3IE . These are the old lines in my onconfig... #BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 #BUFFERPOOL size=4K,buffers=100000,lrus=8,lru_min_dirty=20.00,lru_max_dirty=30.00 #BUFFERPOOL size=16K,buffers=…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Buffer Size and Use
Folks, We recently had a conversation with a well-respected name in the Informix world, recently, concerning our bufferpool configuration. When exported, our database takes up only about 18 GB. We had a buffer pool of 12 GB, figuring that the more memory resident, the better. Al…
partitioning performance
IDS 11.70.fc3xc Aix 6.1 Having to rework some fragmentation that was designed several years ago .. and had a question .... in a fragment by expression clause...arethe following going to perform the same ... fragment by expression transaction_date between '01/01/2014' and '01/15…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
onstat -g ckp Question
When we are transferring an index from the primary to the secondary we = have a problem. All the work and maintain a clean buffer pool on the primary= is done all the index is being built. However on the secondary there is no= way to keep the buffer pool clean. If we do not keep …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Bufferpool max size in Windows Server 2008 64bit
Hi, I restarted engine once more and now it looks right. So, probable user error! Are there other memory parameters that would benefit from very large values? Thanks, Lauri d:\\\\Program Files\\\\IBM\\\\Informix\\\\11.70>onstat -X IBM Informix Dynamic Server Version 11.70.FC…
Query: Extents of a Fragment/Partition
Does anybody have a query that produces a listing of extents by fragment in a partitioned table -- something like what oncheck -pT reports for the fragmented table? I need to determine how large each partition is via SQL, but haven't been able to determine what sysmaster & syste…
buffer pool and dbimport (11.70FC5)
Hi, I'm facing a problem and i don't understand how is it possible ... I'm loading (dbimport) a big table (> 3 Million records) and my buffer pool becomes quickly full (700000 buffers with LRU min = 0.50 and max 1.00). Checkpoint is not trigger until CKPINTVL (180) and you can im…
shared memory
This concerns IDS 11.70.TC5IE on Windows Server 2008 . This article http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm .perf.doc%2Fids_prf_750.htm defines buffer_value = (BUFFERS * pagesize) + (BUFFERS * 254) + 250000and goes on to say: âIf you hav…
Disabling LRU flush
Hi, IFX 11.70 FC 5 Innovator-C , Linux 64bits OpenSuse. I'm working with database load. Basically I'm using HPL, unfortunately some tables have huge rowsize0 (1 row size = 2 pages) and lvarchar datatype which force use deluxe mode. Consequently use buffer pool , and then LRU fl…
BTR on each buffer pool?
This concerns IBM Informix Dynamic Server Version 11.70.TC5IE . I have a 16k page size space where I put a temp space and all primary and foreign key indexes. Since I can select nbuffs, bufwaits, bufwrites, pagreads from sysmaster:sysbufpool I can get the BTR on each pool. Should…
Problem when adding a partition
We have had a table partitioned by month for years. We have a script that rolls the partition, dropping the oldest and adding a new one, each month. The script has run unchanged for well over a year. But suddenly adding the next partition causes problems. within 15 minutes of ad…
Table Partitioning
Is it possible to partition/fragment a table while keeping it in a single tablespace.…
Hmmm ... when detach partition rebuilds indexes ...
create table tab1_jj ( id serial8 not null , cr_date datetime year to second default current year to second not null , acc_id integer not null ) fragment by expression partition tab1_part_2009_q3 (cr_date < '2009-10-01 00:00:00' and cr_date >= '2009-07-01 00…
Fragmentation not supported in 11.70??
You're using Growth Edition. That's one of it's limitations. Previously it was called Workgroup Edition Regards On Jul 30, 2012 7:51 PM, "JEFFREY GENEGA" <jeffrey.genega@spirent.com> wrote: > Hi All, > > I am running IBM Informix Dynamic Server Version 11.70.FC5GE > > I get thi…
Best page size 1TB-HD (4K sectors/64K cluster)
Configuration: Informix 11.70.TC5 on WinVista SP2. Intel Pentium Dual Core. 8GB RAM. One 250GB Phys disk, NTFS partition as logical drive C: One 1TB Phys disk, NTFS partition as logical drive D: (Both drives are formatted with 4K sectors and 64K cluster size) Questions: 1. Wil…
Correct method of sizing resident pool...
Hi all, I have a script that reads an onconfig file and outputs an estimated memory footprint of the instance. However, I am finding it hard to accurately predict the resident section size. According to http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com…
Fragmentation: Detach Attach partition
Hello All, Informix 11.50.FC6 on HP-Unix create table myfragment ( date_stamp date ) with vercols fragment by expression partition myfrag_1 ((date_stamp <= DATE ('12/31/2011' ) ) AND (date_stamp >= DATE ('01/01/2011' ) ) ) in els_legal_dat, partition myfrag_2 ((date_stamp <= D…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
ZFS and Informix
I'm well aware that the buffer pool has nothing to do with the underlying file system. We're just trying to figure out what scales better. We know that ZFS's ARC scales very well (the algorithms come from IBM !!). I trust though the people that have been out in the trenches worki…
Best way to move table contents to another
oh this is nice. maybe what we need. is it equivalent to oracle's partition? or is it a different concept…
Informix Status Explanations
hi, can anyone shed light on this for me. what does this mean? status yield bufwait- does it mean i'm lacking buffer pools? what does this indicate? cond wait netnorm - session is not doing anything. running- does it mean the sql is currently running. yield lockwaits - does th…
question about fragment
Hi, I have one table need to be fragmented, totally it's 8 partitions,I have two choises,the first one is all those partition on the same dbspace, the second one is use 8 different dbspace to do the fragment. What's the performance difference between them? thanks for your time.…
Information in partition header page
Hi, I want to know What's information being stored in partition header page, thanks for your help.…
Increase buffer pool size
Dear All, i found the following line in the message log of an IDS 10.00 on a Linux Box having 3GB memory: WARNING: Buffer pool size is too small for read ahead operation I would like to increase this parameter, as obviously it has the default size of 5000 buffers with a 2k page…
Informix question
Original Post: Hi, I have two confused question. 1 When a update SQL will update totally 3 pages in bufferpool? How many mutex IDS will allocate for this thread in the buffer-head entry in the buffer table? 2. What the temporary sbspace will be used for? thanks for your time.…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
LC_MONET
Hi, I have session in informix which contain 'LC_MONET' in TTY field of onstat -u i cannot understand what is LC_MONET Userthreads address flags sessid user tty wait tout locks nreads nwrites 1544675a8 ---P--- 1644033 informix LC_MONET 0 0 0 0 0…
FInd Row Id in Partition Table
Hi, How can we identify RowId for a Partition/Fragmented Table in IDS 11.50.FC6. Thanks.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Maximum number of pages for a partition
10.0FC10 on Solaris I have a table fragmented round-robin over three dbspaces,. close to hitting the 16775000 page limit (see oncheck below). In order to avoid it stopping when it hits the limit I can obviously refregment the table over more spaces (or use a larger page size). …
Queries waiting for mutex
Hello all, Yesterday afternoon we ran into a problem. All sessions selecting or modifying data stopped responding to users. Onstat -u showed all of these sessions in a status of waiting for mutex 'S--P---'. After gathering onstat -a and onstat -g all information, I restarted Inf…
wait for mutex ... IDS hang....
Hi, Folks, Build Version: 11.10.UC2 Build OS: AIX 5.3 We had IDS hang that seems caused by Waiting for Mutex. I attached some info and question embedded below. Hope experts can give some ideas. Thanks a lot! Frank (1) No waring info in Online log. (2) onstat -u's output in…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
SMI table to read the 'onstat -P' information from
Hi all, I was wondering if there's a way to read the 'onstat -P', i.e. the 'Print partition buffer summary' information from a SMI table? I wrote a script to print out the contents of the buffers, but it would be more elegant to be able to do everything on SQL, instead of having…
why so many informix threads on idle systems ?
Please post the output of onstat -g ath. It's better than onstat -u wh= en looking at threads. M.P. = From: "KARL OLIVER" <karl.oliver@maf.govt.nz> = = To: ids@iiug.org = = Date: 04/06/2010 06:32 PM = = Subject: why so many informix threads on idle systems ? [19509] = =…
RE: Long Checkpoints with HDR and 11.5.
Art Kagel wrote: No, Jacques, IDS secondaries do not share buffer pool updates with the primary. Only the logical log buffers are transferred, so only the server's transaction rate would affect the data transfer rate between the servers and that would be about the same regardles…
How to check informix DB bottlenecks
I am using IDS 9.4, AIX 5.4. onstat -p shows => onstat -p IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line (Prim) -- Up 23 days 15:06:08 -- 2251504 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1220612817 3198664750 2251555606 45.…
Max No of Partitions
Hi, May i know what is the max no of partitions we can have on a table ? We are using 11.50.FC6 & 11.50.FC3W1. Thanks…
Network Buffer Pools
IDS 11.50.FC5 AIX 5.3 For HDR replication between two AIX 5.3 servers, is there a suggested value for the following environment parameters: 1. IFX_NETBUF_PVTPOOL_SIZE 2. IFX_NETBUF_SIZE 3. Sqlhosts option b (client buffer size) The primary has 64GB of memory while the second…
Re: indexing with partition question(s)
Fragment elimination on the table is independent of that of the index for the most part. Also, you certainly could fragment the index by rec_typ as well essentially dividing it into an index on deleted rows and a separate index on active rows. Fragment elimination on the index …
indexing with partition question(s)
Hello, We are going to have a long denormalized table soon. It will be filled with records that get marked deleted ( rec_type=d ), and of course other rec_types. But the largest part of the table that I want to eliminate in queries are the deleted records. So I was thinking of f…
can't kill a session using "onmode -z session id"
Hi All, I encountered problem on my DB. I am dropping a table and it hanged. I decided to close the window by clicking the "X" button. When i checked, the table still exists when i use dbaccess-> table-> info. But when i try to select from the table, the message is table does no…
sysmaster query help
Does anyone have a query that will provide the Number of pages allocated for each partition in the database, along with the tablename/indexname that the partition belongs to, and the partiton name itself ? Thanks. Floyd…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
physical log might be too small
Hello, We are getting following error while checking checkpoints "Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool during checkpoint processing. The server might block transactions during checkpoints. I…
How to truncate the data in one partition
On the partitioned table, How to truncate the data in one of the partitions? (not using the detach)?…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Buffer Pool
Hi, We are running informix 9.4 FC5xs with SAP. Our SAP admin recently advised that the INFORMIX buffers were set to low. Based on some SAP recommendation, we increased the buffers parameter from 301049 to 501049 (about 600Mb to a little les than 1Gb. 2 days later I found the fo…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
Question about sysindexes.clust
I can provide you with a copy of the onstat -p but don't have the others. I will get them in future tests (I'm hoping we are almost done for now). On Tue, Nov 18, 2008 at 3:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Eric Rowell wrote: > > Any suggestions would b…
IDS 11.0 throws "Warning -33208: Runtime error..."
Is it possible to import the database from a raw partition to a file system partition?…
Database import from Infomix 5.0 to IDS 11.0
Is it possible to import the database residing in a raw partition to a cooked file system?…
Re: Best Use of Free Memory
David, I see the confusion now. The English phrase, "Needs to acquire a buffer," is too vague. There are really two major cases, but the manual is only addressing one (the rarer one). The cases are: 1. The required data is already in the buffer pool. In this case the thread nee…
Best Use of Free Memory
BUFFERS is generally a good place place to use extra memory, subject to a couple caveats: 1. If the working set already fits in the current buffer pool, adding still more buffers will not produce any noticeable performance increase. Check "onstat -g buf" output for your %cached.…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Where records the fragment table's partnum ?!
True dat Art - In addition if you look at the output from oncheck -pt the part that says... Partition partnum 11534338 Partition lockid 10485815 ...Will tell you if the table is fragged or not. The Partition partnum entry corresponds to the first fragment's partnumber, the Par…
H E L P!
Dear All, I shall be grateful if someone can tell me how to kill the user process (stop the process the user is running)as some time the users forgets to sign off. Follwing is the onstat -u output, ( the preview compress the mail,individual columns will not appear, for example. …
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Real basic oncheck onmonitor question
With oncheck you're safe with the -p options, with onmonitor you're safe as long as you don't go into the Parameters menu (which is disabled for users other than informix) or if you do, don't save any changes. To safely look what config parameters are being used use onstat -c.…
Number of Pages per Partition
Hello All, We have occasionally hit the maximum number of pages per partition (16,777,215) in our IDS 9.40.UC4 instance (Sun 2.8). I have searched in vain to see if this limit changes in 10.0 or 11.1. It looks like it is still the same limit in 10.0, but I am not sure. Does anyo…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
Partition dilemma
Version: IDS 10 I am having some difficulties understanding few things such as: 1. I know what indexes to fragment but it's creating data skew, which then makes it difficult to compute the size of dbspace. So I thought instead ot fragmenting it in different dbspaces, why not fr…
Disk partitioning for RAW space
I am busy setting up a development server to run IDS 9.40 The server has three identical disks with software raid as follows: 1GB RAID 1 /boot 4GB RAID 1 swap 350GB RAID 5 Linux file system 236GB RAID 5 raw My question is this: Is it better to break up the raw spaces into small…
How to find the location of logical log file
On Aug 20, 8:32 am, Veeru71 <m_ad...@hotmail.com> wrote: > Given a logical log file, wow can we find out its location > (dbspace) ? > onstat -l doesn't show this info. > Thanks It actually is in the onstat -l output. The "begin" column is the physical address of the begining o…
Buffer waits
HI, Folks, Just curious, we have a quite number of buffer waits(onstat -p) and we know they were caused primarily by a sequential scan of a large table. As I observed, the percentage (onstat -R) of the free buffers was still high (> 90%) when the session claimed a buffer wait(o…
table wise statistics
onstat -g ppf and onstat -f iof ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 7/31 10:27:53 Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall stati…
Re: 9.40FC9 BUFFERS limit
On Jul 25, 4:41 pm, <eshkambx-i...@yahoo.com> wrote: > Hi > > Does anyone know what is real maximum number (not from release notes) of BUFFERS parameter for IDS > 9.40FC9 for Solaris 10? Exact Solaris version is: Solaris 10 11/06 s10s_u3wos_10 SPARC. > > Situation: > > We have ne…
description of onstat -g ntt
Hi Karl, From IBM Performance Guide v9.4, we can find this explanation on the q-exceed field: << output output field Description -------------------------------------------------------------------------------- -------------- onstat -g ntm q-exceeds Number of times the free buff…
Re: Strange behaviour of the buffer pool
On Jul 17, 8:57 am, RoB <pluma...@gmail.com> wrote: > >My post to the news group is taking forever. In any case, I looked > >around a bit and it seems like the easiest way to get your resident > >section to become larger, other then BUFFERS in the $ONCONFIG, is the > >LOCKS para…
Re: Strange behaviour of the buffer pool
On 17 Jul, 12:10, RoB <pluma...@gmail.com> wrote: > Hi all, > > IDS: 9.40.FC3W2 > OS: HP-UX 11.11 > > What am I missing here? An instance is unexplainably allocating 224 MB > of buffer pool in addition to the amount configured. > > The BUFFERS onconfig parameter is set to 6250 (=…
Re: Strange behaviour of the buffer pool
Looking at a larger instance on the same versions I can see the "resident" pool being 354MB while the "res-buff" being the same the BUFFERS setting: onstat -g mem|grep " R " res-buff R c00000001669d040 1280004096 2848 2 2 resident R c000000000491040 …
Strange behaviour of the buffer pool
Hi all, IDS: 9.40.FC3W2 OS: HP-UX 11.11 What am I missing here? An instance is unexplainably allocating 224 MB of buffer pool in addition to the amount configured. The BUFFERS onconfig parameter is set to 6250 (= 12.2MB): onstat -c|egrep "BUFF|SHM" BUFFERS …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Slow database creation and loading
On Jun 18, 10:50 pm, "Jack Parker" <jack.park...@verizon.net> wrote: > If you are using HPL, that grabs it's own memory. Data does not go through > the normal buffer pool (unless you are using deluxe mode). You might not > want to increase buffers. I need to double check but I…
tty value
HI, Guys, I am wondering the TTY values from onstat -u. It is normally a number, but the folowing looks..... Any idea? AIX 5.3, IDS10 UC5 Tahnks, Frank IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39 -- 77088 Kbytes Userthreads address flags sessid …
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
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…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Finding table names from the output of onstat -g p
I'm having a brain lapse this morning. How do I convert the partnum in onstat -g ppf into a table name? DT…
Rogue user session
Hi, Informix Dynamic Server Version 7.31.UD7, solaris 8 I've got a rogue user session connected to my instance that I need to remove, if possible without bouncing the engine. snippet frm onstat -u 4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0 0 4ef1d618 T--…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
Total length of columns in constraint is too long
Hi, We recently migrated our application from MySQL to IDS. While the migration (post DDL and few other code changes) worked just fine in a dev. environment on windows, while executing DDL scripts on Linux, IDS throws this error. Basically I have a unique constraint on 3 columns…
onstat -p stats
Hi We are having IDS 7.31 UC3 on HP-UX when I entered onstat -p, %cached(4th column from left) is showing 0.00 ,it is for reads i think. But earlier it was showing 90%. What could be the problem? Is this normal? How to get it back to 90%? Pl help.. Suresh…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
A question of load . . .
( Unfortunatly, none of us thought to save any of that data when things started slowing down, so all we've got is what we can remember. ) In answer to several: 3 oninit processes were the only things really eating cpu time. There were a few other processes that would show up us…
record locked
a combination of onstat -k and onstat -u…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
fragmentation and partition
I have fragmented table ds_archive. Originally, the "remainder" was stored at dbdata02 dbspace( not defined as "partition"). After I altered the fragment( used "partition" and moved the "remainder" from dbdata00 to dbdw01), somehow a piece of data is still left at dbdata02. …
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
who locks a record?
onstat -k followed by an onstat -u…
How do it get writes form the lrus in V10
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Bill > Marshall > Sent: Wednesday, May 03, 2006 7:21 AM > To: ids@iiug.org > Subject: How do it get writes form the lrus in V10 [6648] > > > I have a new HP Intel 32 bit chip mach…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I have the following fragmentation strategy that I am testing on a table, but it doesn't do what I want. I want to have 24 fragments that represent the hour of the timestamp. That way the query that clears records away that are over some number of hours old will only have to look…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Check INFORMIXDIR and DBLANG.FAILED
Hill, what could have caused it ? angel:/opt/informixids/msg/en_us/0333}oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informixids/etc/onconfig.angel'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating …
FW: Informix versus Oracle Spatial
Dirk Moolman wrote: > > My question: is this true ? Does it really mean downtime ? I am > asking this, because our Oracle DBA confirms that in Oracle you do not > need downtime for this, that you can build partition indexes which > eliminates the need for downtime. > > Any co…
Optimizing a BaaN installation
--- onstat -u --- Informix Dynamic Server 2000 Version 9.21.TC7 -- On-Line -- Up 05:42:45 -- 1078592 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 25e63018 ---P--D 1 informix - 0 0 0 186 3067 …
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
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…
oninit: Dictionary Cache and SPL Routine Cache error
I am having some trouble initializing shared memory on Solaris 9 with Informix IDS 9.4. --------------- $ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/dbms/informix/etc/onconfig.site'...succeeded Creating /INFORMIXTMP/…
partitioning
Does anyone have an example of fragmenting a table into the same dbspace ... using the new v10 feature of naming a partition ...…
RE: Onstat -P output
Hi Leona. If anything I say in here evokes a response 'I know that dummy'(-:)) I apologize. Given your profile, Onconfig and the fact that you are running an OLTP I would suggest you make the following changes to your onconfig. Some are calculations, some out of experience: You…
RE: Onstat -P output
Based on your description, it sounds like you're hitting a table without an index that has grown in size and a single SQL/SPL/UDR is to blame. I've attached a script called "qio" to the bottom of the post, it will show you the SQL's in the system that are the biggest I/O users. …
RE: Onstat -P output
Hi, The processing is OLTP. A SUN 4800 server with 4 CPUs at 750MHZ each. The overall CPU activity is about 65%. The server has a total of 1.8TB (18 disks of 73GB). Out of this 400GB is allocated to the file system and the rest is configured like this: 6 for RAID 10 and 5 for RAI…
RE: Onstat -P output
What, precisely, is it that you are unhappy with? Are you OLTP, DSS? How many CPU's? How many hard drives? What is your overall CPU activity? What does you I/O look like? Etc, etc, etc ... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-lis…
Onstat -P output
--0-1958201504-1124376709=:23030 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition: inline Hi, I'm using IDS9.21 UC6 running on a SOlaris 8.0 Operating system. The output of the onstat -P is not acceptable and I would ap…
Max Locks Forever
How would one find out the "maximum number of locks in use" for a period. lockreqs from onstat -p does me no good. I have a system that is stressed for memory and I'm running 100000 locks. They probably could do ok with less. This is 9.40.TC2 on Windows sending to informix-list…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: Re: oninit error .. [5496]
$ oninit -ivy Checking group membership to determine server run modesucceeded Reading configuration file '/opt/informix/etc/onconfig.padbv2'...succeeded Creating /INFORMIXTMP/.infxdirs ... succeeded Creating infos file "/opt/informix/etc/.infos.padbv2" ... "/opt/informix/etc/.co …
Installation problem
I am attempting to upgrade an Informix installation from 7.3x on Sun 5.7 to 9.4 on Sun 5.9. When I run oninit -ivy I get the following: Creating buffer pool 200002 kbytes...succeeded Initializing rhead structure...succeeded init_alarm failed fyi: I installed a new version of IS…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Reading co…
error the running INSTANCIA
Hi: Cuando inicio la instancia me sale el siguiente mensaje de error.... alguna idea, se los agradecere. Me pueden dar una pista ??? saludos ============================================================= Checking group membership to determine server run modesucceeded Readin…
Transaction Rollback
onstat -x…
How to determine optimum buffer size?
Hello, how do I (or how do you) determine the optimum buffer size (on IDS 9.40, but I think it's a generic question) ? I have a machine with almost 'unlimited' memory (96 GB RAM). Therefore I could define a large number of buffer pages. But I'm not sure if at some point the adm…
What counts sysbufhdr.reusecnt ?
Hi, I found the table sysbufhdr in the sysmaster database apparently containing information about the database buffer pages. One column has the name 'reusecnt' - does anybody know what exactly that column counts? Most entries have reusecnt=0 and I have one system (with a very la…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: RESIDENT and BUFFERPOOL
David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? I'm no sure whether you understa…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: Opinions on usercpu & syscpu in onstat -p
Darren_Jacobs@carmax.com wrote: > Just wanted to get some opinions on the usercpu and syscpu meaning in the > onstat -p output. I can't remember if I read in Lumbley's guide or not, > but if usercpu exceeds the amount of lapsed time this indicates the system > could benefit from…
Re: Expert advice needed on Buffer management
jpierrot@chubb.com wrote: > Hi gang, His per-session buffer pool requirement calculation is completely bogus since most sessions will be sharing the use of the same pages of data and which pages are shared and which are uniquely used by a single session will differ from server t…
RE: Opinions on usercpu & syscpu in onstat -p
On a 6 way box, assuming you have say 5 CPU VPs, then no. 150951 + 5282 = 156233 total CPU usage over a period of 67740 seconds you would have 5 * 67740 = 338700 total seconds of CPU usage available So, your using a little less than half. If you are trying to determine if you…
RE: Opinions on usercpu & syscpu in onstat -p
On a 6 way box, assuming you have say 5 CPU VPs, then no. 150951 + 5282 = 156233 total CPU usage over a period of 67740 seconds you would have 5 * 67740 = 338700 total seconds of CPU usage available So, your using a little less than half. If you are trying to determine if you…
Fw: Opinions on usercpu & syscpu in onstat -p
Sorry, the total elasped time is 11.5 hours or 41400 seconds. TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 04/07/2005 01:03 PM ----- Darren_Jacobs@car max.com Sent by: To …
Fw: Opinions on usercpu & syscpu in onstat -p
Sorry, the total elasped time is 11.5 hours or 41400 seconds. TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 04/07/2005 01:03 PM ----- Darren_Jacobs@car max.com Sent by: To …
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat -…
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat…
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
Expert advice needed on Buffer management
Hi gang, I received this below from the architecture Dept. trying to simulate Production like performance in QC and development envs. Assuming performance testing would be equal in all those environments if buffers are adjusted to a certain value. Please advise! My question to yo…
onstat -P shows high percentage of other pages
Hello, we switched recently from IDS.7.31.FD2 to IDS.940.FC5. We have 16000000 BUFFERS configured (16 Mio). 48 minutes after a database restart onstat -P showed the following BUFFER usage: Data 36.83 Btree 22.21 Other 40.96 The 40.96% other were not unused pages (partnum 0), b…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
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…
Informix Unload equivalent in Oracle
Hi Mark, > If you must do this via an 'unload', look at import and export (imp/exp). > You could perhaps export Partition X (from Table A), create a new > partitioned table with the new partitions you want, import into this > table, and then swap these partitions back into Table…
RE: Memory resident tables
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_01C4E77E.F198B930 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
Memory resident tables
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_01C4E467.C99EF9E0 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
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…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
problems of Inztallation's
Hi: I have problems with thle installation of IDS. Plataform: HP-UX 11.11 IDS: 7.31 FD8 I cannot initialize !!! If I want to iniciarlize via onmonitor .... the error is: shared memory not initialized for INFORMIXSERVER 'crazy_tcp If i want to inicialize vi command ..... the err…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Intitialization problem
Hi, I have a problem with IDS 7.31 on SCO 5.0.5 When trying to initialize IDS and it hangs. Here is the oninit -v command: # oninit -v Checking group membership to determine server run modesucceeded Reading configuration file '/usr/informix/etc/onconfig'...succeeded Creating …
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Informix IDS problem
Hi All, When I try to start the IDS 9.40 on HP PA-RISC machine, I get the following error. If I reinstall the IDS it works properly. If I shut down & restart the database it fails with the below message.. Checking group membership to determine server run modesucceeded Reading …
onstat -p - before and after some changes made in attempts to enhance peformance
Hi forum. I have pasted a before and after copy of "onstat -p" and I am hoping to get your take on what you think seems to have gotten better/worse based on just that info. I made some changes to my buffers, cleaners, lrus and check point intervals - largely based on input from y…
Relationship between Êche read and bufwaits parameters
Hi, I'm study onstat -p output and I have one question: somebody know the best relationship between Êche read and bufwaits parameters? Because I don't found too much in the performace guide, only Êche read must be grater than 90%. Thanks Paola…
RE: Clearing Buffer Pool
Informix (unlike MS SQL) keeps all pages in the buffer pool 'forever' - until page becames replaced by another page... ------------------------------------------ Alexey Sonkin > From: Dave Griffen [mailto:dgriffen@nospam.finishline.com] > > I do mean to remove all non essential…
RE: Clearing Buffer Pool
To clear the buffer pool from dirty pages, generate a chackpoint with 'onmode -c' If You mean to remove all pages from it, then it's impossible. ------------------------------------------ Alexey Sonkin > -----Original Message----- > > Does anyone know if there is a way to clea…
Clearing Buffer Pool
Does anyone know if there is a way to clear the buffer pool without bouncing the engine?…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
BUFFERS! Arghhh!!! Please help before I do something silly!
On Tue, 27 Apr 2004 16:29:36 -0400, sumGirl wrote: My last should say (about using the onstat -P output): "and you can drop BUFFERS by the number shown in 'other' on that line with no production effect" Sorry about that. Art S. Kagel…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
partitioning a database into multiple dbspaces
I'm attempting to partition an existing database into multiple dbspaces so that I can assign the dbspaces to different physical disks in hopes of improving I/O performance. Unfortunately, I'm doing something wrong. My strategy is to perform a dbexport, modify the sql schema fil…
Performance is getting worst after turn on the LRUAGE
On Sun, 28 Mar 2004 22:40:01 -0500, miyaki wrote: Other is usually 'unused pages'. Look at the top of the onstat -P report. On the line for address zero (0), is the value under Other very large? Those are unused buffer pages, ie no data pages have been loaded into them. There…
Re: how to tune buffer allocated to index data?
Nebojsa Sevo <DELETE_mips@zg.htnet.hr> wrote in message news:<qp0b50hrfiu73mgtt9unvvs9cnpccv84bk@4ax.com>... > How did you get those informations? > From "onstat" (which option) or something else? > > Thanks > > nebojsa >> Simple.. onstat -P | tail -5 >> Cheers…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Buffers and LRU.
Madison, the standard interpretation of LRU is Least Recently Used. The standard usage of such a queue is as follows: Each queue has an MRU (Most Recently Used) end and an LRU end. When a buffer is touched (either read or written) it is moved to the MRU end of the queue. When a…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Buffers and LRU.
The buffer pool is the page cache of the engine. The LRUs are simply a means of chaining the buffers together. There are two chains per LRU - the free and the dirty. (Actually a free buffer has a page in it, but it is not dirty.) There are multiple LRUs so that if a thread tri…
Re: DiskRead-Cache always 0.00%
Manuela Biel wrote: > Hi, > > since a few days without any revelant changes in the informix-configuration, > out Disk-Read-Cache is always zero. > > Example: (onstat -p) > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 803475051 834961363 238…
DiskRead-Cache always 0.00%
Hi, since a few days without any revelant changes in the informix-configuration, out Disk-Read-Cache is always zero. Example: (onstat -p) Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 803475051 834961363 238511699 0.00 5432438 16547952 67235…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
RE: 9.40 buggy!
"Alexey Sonkin" <alexeis@grandvirtual.com> wrote in message news:bpj3ms$ee0$1@terabinaries.xmission.com... > > On many platforms (Solaris, Linux, etc) You > can't break large disk (70 GB or 140 GB) into > proper number of partitions (raw devices) > > On Linux, the limit for SCSI …
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
onstat -P buffer percentages
Percentages: Data 28.23 Btree 36.69 Other 35.08 What is in Other and why would it be so large?…
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…
how to use onstat -P
How to use onstat -P(not -p) to tell informix server's performance question:? -- Posted via http://dbforums.com…
Re: onstat -p Funny
On 04 Okt 2003, Paul Watson <paul@oninit.com> wrote: > OS: Solaris 9 > > Everything is working fine, no problems as far I can tell then > all of a sudden our monitoring picks up a read cache drop and > I get the following onstat -p. The DBserver is for a website, > traffic leve…
RE: onstat -p Funny
Payl, Just make 'onstat -z' to correct the problem, which is caused by the 'bufreads' couter overflow ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Paul Watson [mailto:paul@oninit.com] > Sent: Saturd…
onstat -p Funny
OS: Solaris 9 Everything is working fine, no problems as far I can tell then all of a sudden our monitoring picks up a read cache drop and I get the following onstat -p. The DBserver is for a website, traffic levels haven't changed, and there are no background jobs, and I'm see…
ontape -r. How do i know its working ?
OK. It bombed. Any idea what the stuff below means ... oninit: Fatal error in shared memory creation Physical restore failed - could not fork server connection Program over. "Jack A" <jacka8@excite.com> wrote in message news:79cb48187430df1afa179eb63392bbc3@news.teranews.com…
Re: lock table overflow
After bringing the server online for about 2 hours, onstat -p shows" ovrlocks = 12 ovrbufs = 23 bufwaits = 265372 lokreqs = 64million+ In onconfig: LOCKS = 20,000 BUFFS = 200 Does this seem reasonable? If not, what values would be appropriate? What other parameters should I che…
Resizing chunks
Ok I have 6 chunks on a system that use only 25% of an available disk partition. I want to resize to use all of the disk partition Can I do this without interrupting the data. Note: each disk partition is only being used once at the moment. OR do I have to backup, delete, recr…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
about chunks and raw partition
Hello, (first, sorry for the html tags, I can't remove them) We have a little DB with a bizar chunk configuration. And I'm wondering why should my predecessors splitting up unix partitions in several chunks ? Unix partition /dev/rdblv03 (1Giga) is added as 1 big chunk in DBspa…
Informix & raw partitions
I'm new to Informix and entire db world, so please hang with me while I explain: I have Solaris 8 running with one 14GB raw partition for Informix data. I'm running Informix Dynamic Server 7.31 Installation of IDS have created rootdbs chunk on that partition for about 600MB Can…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
onstat -p all zero
Thanks for your reply Jonathan Leffler, I do have a performance problem, some users have complained of 'slows' with the OLTP part of the application. But this hasn't been quantified yet. Without an accurate definition of 'slows' I decided to investigate the performance anyway. T…
RE: equiv to onstat -P in systables?
sysprofile > -----Original Message----- > From: Big Swifty [mailto:kevin_burdish@timeinc.com] > Sent: Thursday, February 08, 2001 1:29 PM > To: informix-list@iiug.org > Subject: equiv to onstat -P in systables? > > > Hey all! > > Is there an equivalent to onstat -P in systables …
equiv to onstat -P in systables?
Hey all! Is there an equivalent to onstat -P in systables I can't seem to find anything in the documentation. Thanks in advance!! Please respond to kevin_burdish@timeinc.com as well as the group. Thanks, Kevin…
regarding concept of physical logging??
hello, i have a serious confusion regarding tha concept of physical logging, this might sound silly for an expert kindly bear with me and explain.. according to what the book says.. physical logbuffer contains the before images of the data that taken from disk for modification..…
RE: what is light scan and look aside??
All of these 'advanced' questions. Are you retreading from some other vendor? You should consider a course. Light Scan: Normally when you read a table, you go through the buffer pool. That is your row is retrieved from disk, stuck into a buffer, an LRU entry is made to track…
Re: 7.31 performance problem
Yes I have. KT > Have you run update statistics? onstat -p shows a lot of sequential scans.…
Performance: where should I look ?
Hello to the masters of IFX, Since Sep-2000 I'm reading this newsgroup regarding performance problems. I managed to double the performance thanks to you all. Even if the users weren't complaining about the performance, checking some parameters/ratios at a daily/weekly basis mad…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
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…
Linux Cannot attach to shared memory. errno = 43:
I've recently installed IIF 2000 with IDS 9.21.UC2 on a Mandrake 7.1 Linux box. After I initialized the DB and started oninit I can do 'onstat -p' once and everything works great. The second time I do 'onstat -p' I get: onstat: Cannot attach to shared memory. errno = 43 I can't…
RE: dbexport /dbimport regarding partitioned tables
dbimport and dbexport will work regardless if your table is partitioned across dbspaces. However is you run dbexport without the -ss option the resulting "create table" statement for the partitioned (fragmented) table will not reflect the partitioning strategy you used. So when …
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Raw Partition layout on Linux
Hello, I am now jumping into raw partitions on Intel Linux. I have 2 nine gig drives. I would like to use 3 gig for the OS and applications. The last 6 gig for informix. On Intel hardware you can have 4 primary partitions. 3 partitions for the OS. Can I create a partition s…
onmode -F
Has anybody been facing a problem when running onstat -F We had problems with logical logs, they didn't got backed up. We are using onbar. After rebooting Informix everything has been always ok !. Now I tried onstat -F, because I think it's a kind of memory fragmentation problem.…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Partition question: Device not configured?
IDS2000, RedHat Linux 6.1, kernel 2.2.12-20smp. I have 52G of RAID0+1 space. I used cfdisk to create 2 primary partitions (for user filesystems) and the remainder is divided into 2G logical partitions to be assigned into dbspace as needed. I've read a lot about raw/cooked file…
poor performance revisted
Obnoxio The Clown wrote: > > > >onstat -P | tail -5: > > > > > > > >Percentages: > > > >Data 6.77 > > > >Btree 92.40 > > > >Other 0.82 > > > > > > This looks ugly. What is the output of > > > > > > onstat -B | grep " d0 " | wc -l > > > > 0 > > Hmmmm...what's the smiley for rai…
raw device on linux
OS: Red Hat Linux 6.2 IDS For Linux. I created a partition on the hard disk and wanted to give it to IDS, but didn't find the special charater file for the partition, does Red Hat linux support raw device at all? Regards, Carl Y. WU…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
FW: Mystery Session
Kirk, We first experienced this with 7.31 TC2 and the problem is still observed in 7.31 TC5. My discussions with informix technical support suggest a buffer overrun on the logon name of the session. So instead of displaying user 'informix' it displays garbage. AFAIK it is a…
Re: Performance Tweaking
From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: "AJ" <aj@acck.edu> >> >>I have an HP9000-800 series D270 two way running HPUX 11.0 and Informix >>7.3 >>Dynamic Server. >>I also have 1 Gig of memory installed, 3x 600 meg swapspaces, 100000 >>BUFFERS, 63 LRUs, NUMCPUVP=2, …
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
RE: What is bufwaits (onstat -p)
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >"Art S. Kagel" wrote: >> >> The bufwaits indicates when a thread has to wait to read a page into a >> buffer from disk usually this is caused by the LRU Queue to which the thread >> has hashed to …
Re: What is bufwaits (onstat -p)
"Art S. Kagel" wrote: > > The bufwaits indicates when a thread has to wait to read a page into a > buffer from disk usually this is caused by the LRU Queue to which the thread > has hashed to acquire a buffer being locked by another thread trying to do > the same thing or needing…
RE: What is bufwaits (onstat -p)
I have one question. From your message: -- Pages that get both update and read activity or pages that get updated by multiple users are the source of bufwaits. The odds of two users with incompatible access modes hitting the same page at the same time is little affected by the …
Re: What is bufwaits (onstat -p)
Bufwaits have little or nothing to do with LRU contention nor with reading in a page from disk. As Vinod said it does occur when one has to wait on a buffer because another is accessing it. The counter is not incremented because one waits to get access to an LRU. It is increme…
What is bufwaits (onstat -p)
Hello friends, What is bufwaits? Is it incremented when somebody has to access a buffer but has to wait as somebody else is accessing the buffer? I have read somewhere that bufwaits can be reduced by increasing the BUFFERS parameter in onconfig. I agree increasing BUFFERS param…
problem with onstat -p "pagreads" value decrementing
Hi, Has anyone noticed a problem with the pagreads stat in onstat -p being decremented in what looks like a random way? I parse the output of onstat -p regularly and store the output into a csv file. I've noticed that after an unpredictable amount of time the value gets decrem…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Re: onstat -p
From: "Colleen M. Morrow" <Colleen_M._Morrow@jonesday.com> > >I am using IDS 7.31.UC6, recently upgraded from 7.24. When I run onstat >-p, there's an additional line of output that doesn't seem to be documented >in the Answers Online manual. Does anyone know what these fields a…
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…
Relocating raw partitions
I need to move the raw partitions that Informix is using to span more than the one drive they are on. Running under SCO Unix. What is the best way possible to do this? Should I just use OS level commands to duplicate the partitions on different drives or is there a better way to …
Re: How do I check LRU contention - onstat -g spi ????
On Tue, 11 Apr 2000 13:30:59 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >bothwellno@spam.duke.edu wrote: > >> Art S. Kagel & Family <kagel@erols.com> wrote: >> : InfoJones wrote: >> : [output SNIPPED] >> >> : To determine whether buffer contention or LRU contention is in…
Re: How do I check LRU contention - onstat -g spi ????
bothwellno@spam.duke.edu wrote: > Art S. Kagel & Family <kagel@erols.com> wrote: > : InfoJones wrote: > : [output SNIPPED] > > : To determine whether buffer contention or LRU contention is involved > : try to calculate your buffer turnover rate: > > : Buffer Turnovers = (dskread…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
RE: rootdbs size?
Hey, so I am a copy cat. I never claimed anything I said was original Will >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> ===== >From: William Rice <ricew@operamail.com> >> >>onstat -c >>onstat -m >>onstat -d >>onstat -D >>onstat -p >>onstat -P | tail -5 …
RE: rootdbs size?
From: William Rice <ricew@operamail.com> > >onstat -c >onstat -m >onstat -d >onstat -D >onstat -p >onstat -P | tail -5 >onstat -R >onstat -F >onstat -g seg I feel like I'm stuck in a time loop! ______________________________________________________ Get Your Private, Free Email a…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
Re: How do I check LRU contention - onstat -g spi ????
Art S. Kagel & Family <kagel@erols.com> wrote: : InfoJones wrote: : [output SNIPPED] : To determine whether buffer contention or LRU contention is involved : try to calculate your buffer turnover rate: : Buffer Turnovers = (dskreads + bufwrits) / BUFFERS : BTR = (Buffer Turnove…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: Sysprofiles + onstat -p : ovuserthreads
D.Penfold@Libertel.nl wrote: > > I hope you cheeky chappies at IIUG have a moment or two to answer my > question: Well none of the chaps or chapesses at IIUG are very cheeky and the Clown is not around at the moment. ;-) > I'm comparing onstat -p + sysprofiles, ovuserthreads is…
Sysprofiles + onstat -p : ovuserthreads
I hope you cheeky chappies at IIUG have a moment or two to answer my question: I'm comparing onstat -p + sysprofiles, ovuserthreads is not in sysprofiles. I assumed that ovuserthreads would be incremented every time someone tried to connect after max connections (NETTYPE) had be…
Re: Informix-NT performance
From: ivon4388@my-deja.com > >I have big problem with HP LXr 8000 with >4xprocessors Xeon 400, 1Mb, 2048 RAM, NT 4 Server >Enterprise Edition, SP4 and Informix Database. >After rising user sessions over 1000 the average >CPU time on all processors(all thy are allowed >for Informi…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: Raw vs Cooked space?
> > But you can fdisk the drive for 4 partitions, each having 7 per partition > to allow 28 chunks per physical drive. Add to that a raid controller, most > allow many logical partitions. I'm using MegaRaid with 4 logical drives, > each logical is broken down in 4 partitions an…
onstat -u ....waiting on condition
Hi I was just looking at the output from onstat -u 3b706d2c Y--P--- 97984 3b70d958 Y--P--- 121881 3b710860 Y--P--- 100957 3b71167c ---P--- 121893 3b711fe4 Y--P--- 113791 3b71b1b0 ---PR-- 121842 3b7230ac Y--P--- 100952 3d96c014 S--PR-- 121894 3d96fd38 Y--P--- 104413 3d9714bc Y--P…
Re: Urgent-ontape backup problem.
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Well you've likely got this problem licked by now but in case you haven't, <br>I've seen something like this before on one of our engines. If I remember <br>correctly I had to backup the logs first (check <i>on…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
RE: checkpoints taking as much as 25 secs
Scott Huppert wrote: > > It's logical that turning the entire buffer pool every 10 minutes is > probably bad, but what is a reasonable time frame? Is there any rule of > thumb? On a busy server that is NOT primarily a DSS/DW server I'd like to see the buffer pool turnover rate …
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Tracking conditions
If a thread is waiting for a resource which is a "condition", is it possible to find out what that condition is? informix@Lawson $ onstat -u | grep robink e2bdf798 Y--P--- 55397 robink - e62c2608 0 1 101 0 informix@Lawson $ onstat -g con | grep e62c2608 …
Buffer Partitioning
Hi, all Our production OLTP server is 7.31.UC4 on Solaris 2.6 (Sun E-4500, 6 cpus, 4 gig memory). Our batch processing went at a snail's pace all weekend, and it occurred to me only this morning to check the output of "onstat -P". Here is what I found: Informix Dynamic Server V…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
ovbuff vs. fgwrites question
This may be a stupid question but you know the old saying..... I noticed an increase in 'ovbuff' on the onstat -p. This is a very small database running on NT and so I increased my buffers. I then realized that this number is the same as my 'fgwrites'. Is this one and the sa…
Rename a chunk's partition in OnLine?
OK, OK, I did the most bone-headed thing in the world. When I added a chunk to a dbspace (in Informix OnLine), I accidently used the /dev/rdsk name instead of the symbolic link to the disk partition (which I had just set up moments before the big mistake). Is there some way to …
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: Performance Problem with many buffer wait
Hi all informix expert, Thank you very much for all of your advice. And I have tuned the informix parameter to BUFFER=40000 (old 20000) LRUS=32 (old 16) CLEANERS=16 (old 8) and the database is still under monitoring, see whether it have improvem…
RE: Raw Partition Sizes
The maximum size of an individual chunk has remained unchanged. It is still 2GB, whether the chunk is RAW or cooked. -----Original Message----- From: rgrann2 [mailto:rgrann2@tampabay.rr.com] Sent: Monday, October 18, 1999 7:16 PM To: informix-list@iiug.org Subject: Raw Partitio…
Re: Raw Partition Sizes
From: "rgrann2" <rgrann2@tampabay.rr.com> > >Does anyone know what the largest raw partition size ver. 7.3 supports? I >know 7.14 will only let you set a size of about 2 GB, and I can't find it >referenced anywhere in their admin docs for 7.3. It's still 2GB. _________________…
Raw Partition Sizes
Does anyone know what the largest raw partition size ver. 7.3 supports? I know 7.14 will only let you set a size of about 2 GB, and I can't find it referenced anywhere in their admin docs for 7.3. Bob…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: onstat -p, oncheck -pr
Kevin, I wrote that article for Tech notes and thought it was on my web site but it is not yet...sorry. But an older version is in our user group newsletter and that on the web at: http://www.iiug.org/~waiug/iugnew81.htm#Exploring the Informix OnLine Utility - ONSTAT I also ha…
Re: onstat -p, oncheck -pr
Yes, I checked it out and also ordered hard copies of old issue..Thanks alot. Art S. Kagel wrote: > Most recent TechNotes issues are ONLINE on the Informix WEB Site in the > TechInfo Center under <publications>. If you are not a member of TechInfo > Center you can enroll free …
Re: onstat -p, oncheck -pr
Most recent TechNotes issues are ONLINE on the Informix WEB Site in the TechInfo Center under <publications>. If you are not a member of TechInfo Center you can enroll free if you have a supported serial number or support contract number. Art S. Kagel Kevin Kim wrote: > > Than…
Re: onstat -p, oncheck -pr
Thanks, That's what I need, however I don't have "Vol8 No1" I should order it from Informix. Art S. Kagel wrote: > Kevin, there was a good discussion of most of the onstat output fields in > a TechNotes article, I think Vol 8 No 1 IMS. Check the Informix site for > th…
Re: onstat -p, oncheck -pr
Let's start again. From: Kevin Kim <Kevin.K.Kim@pop.mcit.com> > >The reason that I posted it was because manual is not comprehansive, >it doesn't discuss below paramaters in detail and not all.. What exactly do you want to know? I think the manuals are very comprehensive, you j…
Re: onstat -p, oncheck -pr
Kevin, there was a good discussion of most of the onstat output fields in a TechNotes article, I think Vol 8 No 1 IMS. Check the Informix site for the online versions on the TechInfo Center area (registration is free if you have any current support contracts on your Informix pro…
Re: onstat -p, oncheck -pr
From: Kevin Kim <Kevin.K.Kim@pop.mcit.com> > >This is a multi-part message in MIME format. >--------------9F2C17A3F05AEA91164B575F >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Can anyone tell me what all below means, I need to know all not just …
onstat -p, oncheck -pr
Can anyone tell me what all below means, I need to know all not just some. Also, if you know others (e.g. oncheck, onstat) please help.. I know most but not all.. dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached isamtot open start read write …
Re: Raw device specification
On Fri, Sep 24, 1999 at 03:54:30PM +0800, Matthew Tan wrote: > Thanks for help guys regarding the question on Raw device vs Cook device. > > Thankfully, we are getting a new hardisk soon, so I would be able to use it > as a raw device. > > I wondering is there any difference of p…
Raw device specification
Thanks for help guys regarding the question on Raw device vs Cook device. Thankfully, we are getting a new hardisk soon, so I would be able to use it as a raw device. I wondering is there any difference of partitioning it into 8 partition each of 1 GB size so that I put differe…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
RE: Root partition
Adding space to the rootdbs is very straigtfoward. You should just define an additional chunk and add that space to the rootdbs via the onspaces command. Your question, however, might indicate a deeper problem other than running out of room in the rootdbs. Be sure of what is loca…
Root partition
Has anyone had experience increasing the root partition? if you have, was it complicated/error prone? Please elaborate... thanks in advance! Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 704-569-1002 x107…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Archecker on V7.30.UC2 (SCO Openserver)
I wonder if someone could shed some light on the following. On on system (converted from 7.23.UC6) when I run archecker on a level 0 archive I get the following in the ac_msg.log file: ... TIME: [08/07/99 18:09:58] Tape 1 started ERROR: Unable to open a partition file ERROR: Una…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
RE: Performance problems
There are a very large number of sequential scans (onstat -p)!! Have you run update statistics medium as described in the release notes? Can you really run the application on 2000 buffers? There is a HUGE number of buffer waits - the obvious answer to the question is no! You w…
Performance problems
System : IBM RS6000 model suz580 AIX v 4.2.1 (Single processor) (73.3 Specint92 134.6 Specfp92) Informix : Version 7.3 UD6 We upgraded 2 weeks ago from Online Version 5.05 to version 7.3. With version 5.05 the performance was ok, but since the upgrade we have big performance pro…
Raw device, partitions, chunk...
Hi there, I install IDS 7.3 in Sun Solaris 2.6, and I am confused about the disk config. Please correct my mistakes: 1), disk partition = raw device = slice 1 raw device ( 1 partition) can have one or more chunks, as long as the sum(chunks size) <= 2GB so for disk c0t0d0, parti…
Raw device, partitions, chunk...
Hi there, I install IDS 7.3 in Sun Solaris 2.6, and I am confused about the disk config. Please correct my mistakes: 1), disk partition = raw device = slice 1 raw device ( 1 partition) can have one or more chunks, as long as the sum(chunks size) <= 2GB so for disk c0t0d0, parti…
Raw device, partitions, chunk...
Hi there, I install IDS 7.3 in Sun Solaris 2.6, and I am confused about the disk config. Please correct my mistakes: 1), disk partition = raw device = slice 1 raw device ( 1 partition) can have one or more chunks, as long as the sum(chunks size) <= 2GB so for disk c0t0d0, parti…
Online Config Changes
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_01BEA792.AEE11024 Content-Type: text/plain Hello all, Can I dynamically change BUFFERS and RA_THRESHOLD without having …
Re: Out of buffer?
On Wed, 26 May 1999, Mark D. Stock wrote: > Xavier wrote: > > > > Hi, > > > > I got the following error message from an Informix IDS 7.30: > > > > <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause > > Dynamic Server to get into > > a locked state…
Re: Out of buffer?
Xavier wrote: > > Hi, > > I got the following error message from an Informix IDS 7.30: > > <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause > Dynamic Server to get into > a locked state. Recommended minimum buffer pool size is > 4 time…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
RE: Instance Initialization Problem
Additionally, you can use Solaris' "format" command to accomplish the same thing without the use of Informix offsets. Given that "format" can only slice a disk into seven partitions, if you are only creating a few chunks on each drive you can create a 4k partition starting at cy…
Instance Initialization Problem
Art, This is good scoop, but how did you know this? where is it documented? Most Informix DBAs I know are wary of this problem, but overcompensate for it by allocating too large an offset. Is there an authoratative source for this info by OS/mfr/whatever? "Art S. Kagel" wrot…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
onstat -u problems
Whenever i run onstat -u i receive following message INFORMIX-OnLine Version 7.13.UC1 -- On-Line -- Up 5 days 01:49:50 -- 30456 Kbs Userthreads address flags sessid user tty wait tout locks nreads nwrites b028010 ---P--D 0 root - 0 …
Re: partition profile
In case anyone isn't aware of it, this is a virus. DO NOT EXECUTE THIS ATTACHMENT! eko setiawan wrote: > > Name: Happy99.exe > Happy99.exe Type: unspecified type (application/octet-stream) > Encoding: x-uuencode…
Re: partition profile
Hey, dingbat. You're infected with a virus, happy99.exe. Clean your disk and stop send virii out into the world. :-( For the rest of our viewers, please don't download and execute happy99.exe. :-) From: eko setiawan <esetiawa@jkt-co.id.dhl.com> > ><< Happy99.exe >> ___________…
partition profile
Hai.. All.. When I type onstat -g ppf, I found Partition profiles disabled Does anybody know about this ?…
Re: RESIDENT and PDQ
Chuck Renaud wrote in message <7ddp91$hpf$1@news.xmission.com>... > >As for light scans--those only happen if the table being read is >larger than the buffer pool. So if you max out your buffers, you >won't get light scans unless they're huge tables... So, would this mean that …
moving the rootdbs chunk
Neil Truby wrote in message <7d8d2s$kdb$1@taliesin.netcom.net.uk>... >If a link, you can break the link, move the data with dd, then create the >link to the new location. > QUESTION: If you use unix dd to move the data, won't it be moved as a disk image, that is byte by byte? …
Re: onstat -p output
Hey, >I was just curios to see some new things in onstat -p output which i >have not seen in any previous version. >Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 7 days >04:05:56 -- 306416 Kbytes >.... >gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs…
onstat -p output
Hey Guy's, IDS 7.30UC2 on Solaris 2.5.1 I was just curios to see some new things in onstat -p output which i have not seen in any previous version. Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 7 days 04:05:56 -- 306416 Kbytes Profile dskreads pagreads bufreads …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: priority question
Dianne I am only guessing here, since I never had to do this sort of thing, but the Unix pid corresponding to the session id can be found from onstat -g ses <session_id> where session_id = 52697 in your example. On some Unix systems priority can be increased by root by decreasin…
priority question
Hi everyone. Can the priority be raised on a particular session? For instance, if I have this onstat -u: INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 57 days 00:27:52 -- 224688 K bytes Userthreads address flags sessid user tty wait tout locks nreads nw…
Delete
Hi. I've a question. When execute a delete by where on field not indexes, it sequential scan table' s page. Before to delete records, it casche pages in buffer pool ? Tank you.…
Informix IDS & Disk Partition
I am attemting to install Informix Dynamic Server on Linux. Should the database server have its very own partition, or can you configure it to use a given directory tree in a shared partition? Any help with this question is much appreciated. Please respond to email: sparker@a…
Re: Buffer Waits
> hmm, could you go into a bit detail on the light-scan? I have a DSS system > but I am not sure how to make it use light scan. I read something on the > book about it, but it wasn't very clear on exactly how to utilize it or > how to check it. thanks yan Here's some more inform…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
configuring LRU MIN/MAX,clarification
Could You please explain this with a little more detail? Also why pagreads and not bufreads ? TIA Sathish Sadagopan <snipped> If your bufwaits (onstat -p) is more than a few % of (pagreads + bufwrits) then you are experiencing LRU contention and need to increase LRUS. N.B. - …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Best database for web backend on Linux?
On Wed, 21 Oct 1998 13:03:49 +0000, Evan Carew <ecarew@yahoo.com> wrote: >Simply put, The main reason I have selected Sybase over Oracle in the >recent past has to do with cache management. In every case, if >you try to use Oracle stored procedures in the same environment with >…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Database Partitioning
I have couple of questions regarding Database Partitioning. 1. Is it possible to take one or more partition off line while the table itself is online? 2. Is it possible to add or drop partitions while the table is online? Regards. Ravi Verma…
Re: Database Partition
Ravi Verma wrote: > I have the following questions regarding Database Partitioning. > > 1. Is it possible to take one or more partition off line while the table itself is online? Yes. You need to set the DATASKIP on. However, if there are other tables or partitions of other t…
Database Partition
I have the following questions regarding Database Partitioning. 1. Is it possible to take one or more partition off line while the table itself is online? 2. Is it possible to add or drop partitions? Regards. Ravi Verma…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Reducing checkpoint intervals...
Hi, in my opinion you must reduce LRU_MAX_DIRTY and LRU_MIN_DIRTY. It's not a good idea to reduce the time interval between the checkpoints because each checkpoint costs a lot of overhead ( thread-synchronisation and checkpoint-waits ). How about: http://www.weideneder.de/info…
Re: Performance problems with large SELECTS in 7.3x ?
Stefan Weideneder wrote: > > Hi, > > I tried to select some pages of a table that was a bit larger > than my buffer pool. I estimated that my statement will take > about 5 seconds but it took 12 seconds. > I found out, that the server spent approx. 7 seconds for > "buffer waits".…
Performance problems with large SELECTS in 7.3x ?
Hi, I tried to select some pages of a table that was a bit larger than my buffer pool. I estimated that my statement will take about 5 seconds but it took 12 seconds. I found out, that the server spent approx. 7 seconds for "buffer waits". Now I added a few buffers to the buffer…
Re: Run your eyes over this onstat -p listing
Greg, Give us a hint about what doesn't look right. At first glance, it looks like a tuning issue. Things are working, and not all that bad, but could stand for improvement. Also some waiting for locks, but if you have a lot of users that might be OK. What's your message log lo…
Run your eyes over this onstat -p listing
------ =_NextPart_000_01BDC4B8.1CFE5B20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable All, Attached is a copy of an onstat -p losting sent to me by a o/s team who = I deal with on a daily basis. This just does not look right. I have m…
Re: seqscans (onstat -p)
Number of sequential scans executed. Onstat -p has a mediocre definition in the back of Volume 2 of the Administrator's Guide. cajt wrote: > What does mean seqscans in onstat -p ? > > Thanks Cajt -- Vic Goldberg Manager, DBA Team, Acting Manager, Technical Integration Cornell…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
seqscans (onstat -p)
What does mean seqscans in onstat -p ? Thanks Cajt…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Negative cached in onstat -p
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 …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
latch/lock , buffer - questions.
Hi All, 1) When a thread needs a buffer to read in data , does it acquire any latches/locks.How is the allocation done ? 2) What is the difference between locks and latches. 3) If i want to track , the number of times a PARTICULAR user's operations caused his threads to wai…
Re: Negative cached in onstat -p
In article <35AA769E.D785208B@biztravel.com>, tomg@biztravel.com (Tom Grenier) wrote: > While looking at the stats last weekend -- my % cached was negative. > Didn't seem to have any affect on anything, and I did a onstat -z to > reset everything, but wondered what happened to c…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Negative cached in onstat -p
Tom Grenier (tomg@biztravel.com) wrote: : While looking at the stats last weekend -- my % cached was negative. : Didn't seem to have any affect on anything, and I did a onstat -z to : reset everything, but wondered what happened to cause it. Any thoughts? Tom, You've overflowed…
Negative cached in onstat -p
While looking at the stats last weekend -- my % cached was negative. Didn't seem to have any affect on anything, and I did a onstat -z to reset everything, but wondered what happened to cause it. Any thoughts? INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 51 days 08:41:21…
Re: onstat -g ses
>Hi, >In the onstat -g ses output , what is the basis for allocation of 'total >memory' ? >There is also the figure 'used memory' , why not just allocate required >memory ? Well, we could do that but then that would 1) fragment memory and 2) create bottlenecks. Memory in shared…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Online seems to be blocked
Hi, Sometimes at one of my customers Informix Online seems to be blocked. Users cannot work any more, when you try to start onmonitor it hangs too. Also, it is no more possible to shutdown Informix by onmode -ky. Most of the users are "Waiting for an event" (status Y in onstat …
Re: Bringing up Online on NCR- MP RAS
Infodata wrote: [SNIP] > >:14:33:55 I/O error , Primary Chunk '/dev/rdsk/rootdbs' -- Offline > >:14:33:55 I/O read() chunk 1, pagenum 0, pagecnt 1 --> errno=6 > > > >Error number 6 is "no such device or address". Better check that > >/dev/rdsk/rootdbs actually exists and is a va…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
Re: Transaction Throughput Analysis
The problem with onstat -p commit and rollback count, is that it only counts begin commit/rollback blocks and not standalone statements that don't use a transaction. The numbers are therefore the wrong ones to be compared against other DBMS's Art S. Kagel wrote: > darren@systea…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
New Era and partitioned Programs
How many people are running partitioned applications on their systems?? I for one am. From what I've heard (dont know how correct this is) not many people are. denzil.…
onstat -g dic output
<HTML> Hello, <P>Can somebody explain me the outcome of onstat -g dic <tablename>. <P>- What means all the output. <BR>- What can I do with it. <P>Regards, <P>Albert Wisse</HTML>…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
RE: bufreads in onstat -p output
Madison Pardon me if this is a stupid question, but how do I reconfigure the dictionary to be larger if this is the problem? TIA Sujit Pal ---------- From: SaTriGuy[SMTP:satriguy@aol.com] Sent: Sunday, August 31, 1997 5:27 PM To: informix-list@rmy.emory.edu Subject: Re: b…
Re: bufreads in onstat -p output
>Hi guys, > > I am facing a problem with an application suddenly becoming slow. The > interesting thing which I noticed when this application was running > was that the bufreads display in onstat -p output was increasing at an > alarming rate. I am setting this to…
bufreads in onstat -p output
Hi, Sorry for resending the message. I forgot to mention in my earlier message that I am running Informix ODS 7.22 UC2 on Sun Sparc 5000 on Solaris 2.5.1. and the application is an esql-c program. Ketan. >Hi guys, >I am facing a problem with an application suddenly …
bufreads in onstat -p output
Hi guys, I am facing a problem with an application suddenly becoming slow. The interesting thing which I noticed when this application was running was that the bufreads display in onstat -p output was increasing at an alarming rate. I am setting this to …
Re: onstat -p seqscans
tony edwards (tony.edwards@bellsouth.co.nz) wrote: : Hi, : : Does anyone know if the seqscans in an onstat -p increments for : sequential scans on temporary tables ? : Cheers, Tony. I don't think so. I've used a script similar to one posted on this thread to watch my scans, an…
Re: onstat -p seqscans
tony edwards wrote: > > Hi, > > Does anyone know if the seqscans in an onstat -p increments for > sequential scans on temporary tables ? > > Cheers, Tony. Try the following sql to see which tables have seq_scans. select dbsname, tabname, seqscans from sysmaster:sysptprof; Kern…
onstat -p seqscans
Hi, Does anyone know if the seqscans in an onstat -p increments for sequential scans on temporary tables ? Cheers, Tony.…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: 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 -…
Re: Onstat question
Bringing online down and up is not a solution, because the "problem" you have is kinda random. I had the same one, and I called the tech support. The message "Changing data structure..." is due to concurrent access to shared memory. I.E., onstat -u reads data from the shared memo…
Re: Choose New Era???
Nils.Myklebust@idg.no (Nils Myklebust) wrote: >Yes, but David, isn't the real advantage of NewEra coming to light >when you do application partitioning? The figures I quoted are without application partitioning. NE application partitioning at the moment doesn't give you many a…
Getting the database space
Hi, How can I know how much space is a database taking from the informix partition? Thank you in advance. Best regards Kevin Debono.…
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.…
New Era App Partitioning
Hi, We have written a front end to our app in New Era and now we want to use app partitioning so we are keen to connect with anyone that has used it. TIA ---------------------------------------------------------------------- David Paulo, InForm Group Ltd.,PO Box 1444, Wel…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Backing up then resizing RAW space
Unload the database then reload using dbload( It is much better). Bahram Fuzzy wrote: > > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> From: fuzzy@access4.digex.net (Fuzzy) > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and…
Re: Backing up then resizing RAW space
> > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way > to backup that raw partition and restore it into a 600 meg raw partition that is…
Backing up then resizing RAW space
I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way to backup that raw partition and restore it into a 600 meg raw partition that is a diffe…
Re: Good Buffer Size For Tuning Informix?
Chris Jenkins (chrisj@informix.com) wrote: : The only really important factor in determining the number of buffers is : the read and write cache hit ratios reported by tbstat -p. Keep : increasing the number of buffers until these cache hit rates do not : increase when the system…
HP-UX & raw partitions
I have run out of guesses. I am trying to install Informix onto HP-UX 9.04. How do I create the raw partition for the dataspaces? Any help would be appreciated. Reply-To: fdoss@cscmail.csc.com…
Re: Setup of disk chunks for online under AIX 4.1.3
Indeed you should be using raw partitions against the logical volumns for performance and integrity. -- Mark Sigler Client Services Engineer Fort Lauderdale, Florida Informix Software, Inc.…
Re: Recent Press Release: Developer/2000 Release 1.2
> These new features complement the second >generation functionality-drag-and-drop application partitioning and >unparalleled scalability performance-which Oracle delivered with the previous >release of Developer/2000. Drag-and-drop application partitioning is also a feature of …
Are DB Partitions in Informix 7 managed by own DB Servers
While we are awaiting delivery of Informix 7 and its documentation, could anyone tell me if separate db partitions are managed by different db server instances? If you can share your experiences of configuring db partitions with XA-compliant resource managers in a Tuxedo environm…
Re: Application Partitioning?
> In article <7479.365.uupcb@digitec.co.za>, billy.wheeler@digitec.co.za > says... > Has anyone got any scuttlebutt on how Informix intends to implement > application partitoning in NewEra. As I type this I have in front > of me an Ad for Oracle Developer/2000 that indicates an…
Re: Application Partitioning?
In article <7479.365.uupcb@digitec.co.za>, billy.wheeler@digitec.co.za says... > >-> What does application partitioning mean, from a technical point of view, as >-> applied to New Era? > >Simply put: It means that you partition bits of the application to run on >different machine…
Application Partitioning?
-> What does application partitioning mean, from a technical point of view, as -> applied to New Era? Simply put: It means that you partition bits of the application to run on different machines : GUI on the PC, number-crunching on the CRAY and DB access from the Unix server and…
Application Partitioning?
What does application partitioning mean, from a technical point of view, as applied to New Era? -- ---------------------------------------------------------------------------- Neil @ Storm. Any ideas expressed above are the feelings of my employer. I own the company. -----…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
onstat -p (compress)
[ Article crossposted from comp.databases.informix ] [ Author was Graeme Sargent ] [ Posted on 13 Apr 1995 13:40:47 GMT ] John R Worachek (jworache@jcpenney.com) wrote: : What does compress mean within onstat -p output? The number of times a page compression has taken place - i…
Re: Disk partitioning
Valery, >I think diverge rootdbs and most accessible dbspaces to different >disks. >Am I right ? Oh, yes. *Try* to put the root db space on its own disk drive, the logical log db space on *its* own disk drive, and the physical log on *its* own disk drive, if possible. Informi…
Re: onstat -p (compress)
John R Worachek (jworache@jcpenney.com) wrote: : What does compress mean within onstat -p output? The number of times a page compression has taken place - ie the number of times a slot table has been shuffled to make contiguous space out of fragmented space (within a page). -- …
Disk partitioning
Hi , people I have application that running on computer with several disks. Disk space is about 4Gb( 2 - 3 disks). There are several dbspaces ( 7 - 8 ) and I'm using Online 5.01. I will use raw device of course. I think diverge rootdbs and most accessible dbspaces to different …
onstat -p (compress)
What does compress mean within onstat -p output? RSAM Version 7.10.UC1 -- On-Line -- Up 49 days 20:55:29 -- 19768 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 499 565 157608 99.68 1169 2056 28596 95.91 isamtot …
Re: Sun Storage Array BUG
At a recent Sun configuration seminar it has been mentioned that on any Sun drive you really don't want to use slice #0 for the raw partition. You can make the raw partition as large as you like, but use #1 or greater. I'm not sure how this applies to the SPARCstorage Array, bu…
Re: NewEra partitioning
> I just received a NewEra information leaflet from Informix. > In it they say NewEra supports "application partitioning". It says > that applications can easily be partitioned to either the client > or server. Has anyone used these facilities ? How much control is > allowed? > I…
NewEra partitioning
I just received a NewEra information leaflet from Informix. In it they say NewEra supports "application partitioning". It says that applications can easily be partitioned to either the client or server. Has anyone used these facilities ? How much control is allowed? Is it a refer…
Re: NewEra partitioning
In article <794576904snz@boothbc.demon.co.uk> paul@boothbc.demon.co.uk (paul sellars) writes: >From: paul@boothbc.demon.co.uk (paul sellars) >Subject: NewEra partitioning >Date: Tue, 7 Mar 1995 11:48:24 +0000 >I just received a NewEra information leaflet from Informix. >In it th…
Re: Keeping clean pages in shared memory
> If you have a DSS app, the buffer pool does not become dirty, so the > LRU_MAX_DIRTY will not have any impact. ...unless of course you're generating temp tables. Which just about all apps do at some time or another. akent@cix.compulink.co.uk (Andy Kent) ----------------------…
Re: Size of database in Raw Partition
Hi, > How much space in a raw partition ? There are really two answers, How much space in the Informix chunk tbstat -d How much space in a prtition on disk Look at the partition size on the op system, then using the size of a page multiplied by the number of pages s…
Size of database in Raw Partition
Title says just about all. May be a simple question but I hate reading manuals. How can I tell how much space my database takes up within a raw partition? HP-UX 9.0, Informix 5.01, etc. Reply via email or post. Thanks! |-----------------------------------------------------------…
Problems with sdsadmin partitioned disks
Does anyone have any experience using Informix on HP's with SDS partitioned drives. We are using an HP 755 with Seagate Elite 3's, each elite 3 has 7 partitions created via sdsadmin. Informix is using 6 350M partitions as raw devices. The last partition on each drive has a UNIX…
DBTEMP partition for OnLine 5.00
Hi, How big should be DBTEMP partition for OnLine 5.00 .More advanced remarks are welcome. Michal Pegierski ccmp@tvp.com.pl…
Error in Initialized Partition
I have a puzzler for you. We are running Online 4.10.UD4 in a 600 meg partition, on a Pyramid 9845. Lately, the process of tbload/tbunload appeared to cause corruption in databases. After tbloading/tbunloading, an update statistics would die with errors about index corruption.…
Re: INFORMIX 5.00.UC3 & SunOS 4.1.3 cache long name performance
Are you using and Informix raw partition for the database? If not, I suggest you do. This may solve your problem.…
Informix Raw Partition backups
Hi World, I had a customer who has out grown his informix raw partition. I have lots of space i can transfer his data to, but I need to know the proper informix commands to get the database out of a raw partition and into the filesystem. Then I will need to put the filesystem …
Raw partitions / cooked files
We have OnLine databases (version 5.0) on a Sun SPARCstation 10, one on a raw partition and one on a cooked file. For a query involving a join on two tables, where one of the tables is very small (~10 rows) and we do a sequential scan through the second table (~40Mb and ~50000 r…
Re: Partition does not exist
Quoting Tony Yee Chow... -> -> I am running Informix 1.10 Turbo on a mini-system and I have some problems -> with the database. In the last two months, I have lost 3 tables and the -> error message says: -> 240: Could not open database file (FILENAME). -> 135: C-ISAM error: Part…
Re: Partition does not exist
In article <1992Apr23.123337.6884@cs.umb.edu> tchow@cs.umb.edu (Tony Yee Chow) writes: >I am running Informix 1.10 Turbo on a mini-system and I have some problems >with the database. In the last two months, I have lost 3 tables and the >error message says: >240: Could not open d…
Partition does not exist
I am running Informix 1.10 Turbo on a mini-system and I have some problems with the database. In the last two months, I have lost 3 tables and the error message says: 240: Could not open database file (FILENAME). 135: C-ISAM error: Partition does not exist. I cannot do anything …