Oninit® Archive
Results for “DIRECT_IO”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
Petty comments on Version 15 ...
Hi JJ, not seeing your 1., in none of my 6 or so v15 installations. not seeing your 2. either, after initializing (-ivy) using a 4k sector size disk for my ROOTPATH (and DIRECT_IO 1). I do see KAIO being added (queues, threads) once defining more chunks on other disks. And yes t…
Informix 15 compatibility mode
We have currently a case open (TS021681890), where reverting from 15.0.1 did not work due to very first root-chunk only having 3000 pages and the second root-chunk has 5000 pages. And we needed to add a third root-chunk for Informix 15 Migration. However, this is an instance whic…
raw disk support deprecated in RHEL 9.x
Mark: Yea, RH and a few other distributions have been trying to eliminate RAW disk on Linux forever. I think that this is the fourth time that RH has deprecated RAW support. Until now it has always reappeared after a time. In the past it was also possible to manually install the …
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 ------------------------------…
DIRECT I/O (KAIO) Disabled in RHEL 9
No. If DIRECT_IO is set then all chunks built on filesystem files, regardless of page size, are handled by the KAIO threads, one in each CPU VP. It's just that the example has only one CPU VP. The problem, and the fix, are about file on filesystems that have a block size larger t…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
How many aio/KAIO
As for AIO VPs, you will likely need between 2 and 6 AIO VPs with KAIO enabled and DIRECT_IO set to 4 (temp dbspaces processed with KAIO) rather than 0 or 1 if your temp dbspaces are not on RAW disk. If your temp dbspaces are cooked and DIRECT_IO is set to 1, you may need more. A…
Informix on RHEL on VMWare - cooked vs. raw devices recommendation
Milan: In general, if you have DIRECT_IO enabled, the performance difference between cooked filesystem files and raw devices is about 5%. Add to that the fact that the Linux folks keep trying to get rid of raw devices, and most of us are using cooked files on Linux. Art ---------…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
curious about extendable chunks
Just been corresponding with Art directly, and sent him listings from an actual IDS 12.10.FC12 instance on CentOS 7.8 proving that DIRECT_IO works just fine on Linux block devices these days. Try using them and check that the output of "onstat -d" shows "D" in the last character …
DIRECT_IO/KAIO
Hi Please give me an abstract of using these two parameters, on Linux and AIX What i know is that DIRECT_IO is recommended for coocked files (do not use KAIO) , but what about raw devices ? Thanks in advance for your knowledges ------------------------------ John Smith ----------…
Undocumented feature: DIRECTIO enabled for temp dbspaces
Apparently, temp dbspaces with cooked file chunks don't have DIRECTIO enabled from the get go. And so there is an undocumented feature that allows you to turn that feature on: starting with 12.10.xC13, 14.10.xC1 you can enable DIRECT_IO for temp dbspaces as well. - just not doc'd…
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…
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
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…
running out kaio
We are running informix 12.1 FC10 on Linux Red Hat 7 64-bit We enabled direct_io in informix configuration. But sometime instance restart fils and complaints about running out of KAIO processes. A message in online log is given below for reference: "requested number of KAIO event…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
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.…
Raw or block devices?
In most cases?.... filesystem without journaling and with direct_io set. Regards On Nov 3, 2017 6:50 PM, "FLAVIO CARDOSO" <flavio@null.net.br> wrote: > Managing a lot of chunks using raw devices is a hard job, so what kind of > disk > setup you recomend for better performance?…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
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…
DIRECT_IO
Hi, We use cooked file , Linux, IDS 11.70 . DIRECT_IO was not enabled. After We enabled DIRECT_IO, the database restore job is two times faster . I expect it would improve all other IO jobs too, fair expectation? Any experienced possible negative things related to DIRECT_IO ? Tha…
onload questions
IDS 11.50.FC5 Solaris 10 I sent this in a couple of days ago, but I never saw it posted. --- I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace infor…
onload - onunload
IDS 11.50.FC5 Solaris 10 I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace information? How does it know to send the tables to the different dbspaces?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
IDS 12.10 - Query Slow
HI, I would guess at least 5 more in addition to the 31 you have now.- What i need to to get more io, what parameter need to insert/change on my onconfig. Paul Watson, I have found with the 12.10 engines that DIRECT_IO off is often faster - that could just be my world but wort…
IDS AIX to RHEL/Intel
Linux runs Informix well. Just note the following caviats: - You need to test DIRECT_IO versus RAW as the specific configuration can affect IO performance on Linux. - Same with configuring Kernel Asynchronous IO at the OS level. Without tuning it may not perform well and DIRE…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
informix down
Hi informix is down on a backup node (clr), the logs mention a I/O error I/O chunk is inconsistent chunk 9, pagenum 345244, pagecnt 1 the chunk number 9 is member of the log dbspace can you help ?…
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)…
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
Can not start Informix on Linux
Hi, I have a informix server running on a virtual machine. The host of this VM was hung and I had to restart (that means the VM did a "forced power off"). After the reboot, when I issue the command "oninit -v", this error showed: Opening primary chunks...Bad Primary Chunk '/data…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
dbspaces corrupted
We have Version 11.70FC4 sitting on a Red Hat 5.9 server that is, in turn virtualised. All dbspaces are on cooked file systems. We had a process that blocked the server using "onmode c block" followed by a level 0 backup using "ontape s L 0". At some point during the backup,…
Raw or cook devices?
My experience is that some linux systems perform best with raw others with cooked and direct_io. I haven't been able to nail down why. Hiwever, the difference is usuallt small. Most important? No RAID5 and no journaled filesystems. So EXT2 or EXT3 with the journal disabled (same …
Assert Warning: I/O read chunk
This is the sort of issue that should be analized by tech support... but at first glance I see errno 2 and 9. 2 is file not found and 9 is bad file number or bad file descriptor.... Do you still "have" your chunk files? Can you read from them? I don't think it's "corruption". M…
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
btrFS
We have just started testing Open Suse 13.2 and perhaps this is the time to start evaluating performance on this filesystem. Has anyone done any testing with this? Any whitepapers out there? I read somewhere that ext3 is quicker than ext4 and ext2 is quicker than ext3. Our curr…
Cooked VS Raw
In my testing, with DIRECT_IO enabled, Cooked filesystem files are about 3-5% slower than RAW, Cooked devices can't use DIRECT_IO so they are still 5-15% slower than RAW devices. Some Linux systems do perform better with cooked than raw, but most do not. AIX, HPUX, & Solaris, RA…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
IDS 11 on a RedHat VM
Hi, Firstly, I would defer to Art as the information he has provided appears to be based on a lot of actual "real world" experience which is the only way to get a true understanding ... positive affirmation. Secondly, have you done some actual trials completely outside of IBM I…
Input/Output Operations
Anyone know a command that will give the Input/output operations/second(IOPs) that an Informix 11.5 instance is being asked to handle? Please understand that what I'm asking for is different than the read/write times returned per chunk from an onstat -g iof command. That command …
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
Question about chunks extendables
Hi, My environment is: IBM Informix Dynamic Server Version 12.10.FC1 S.O. RHEL 6.4 64 bits I created a dbspace with one chunk and I enabled the automatic chunk extention with the commands: onspaces -c -d tmp5 -p /tmpdbs/tmp5.dbs -s 52428800 -o 0 -t -k 4 echo 'EXECUTE FUNCTION…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
Error: DR: Couldn't send add dbspace/chunk request
hi, 92 % occupied - 8 Gb free (maybe a week). Today I run again the command and suddenly it Works (WT?) DCCPLD02:/ifxpld02/chunks$ onspaces -a datos00 -p /ifxpld02/chunks/datos00_16 -o 0 -s 4096000 Verifying physical disk space, please wait ... Chunk successfully added. Now w…
Using VMotion to move informix server
Hi Art, I will try your suggestion to check the last page of the chunk. I missed providing additional information about the server in my earlier email. OS: Linux (RHEL5) Informix : v11.50 dbspaces uses cooked file (not raw device) and with direct_io enabled. One more thing, w…
Re: Best practices for IDS on virtual machine?
Hi Art , Hmm... I would like to disagree with you... but before that I will do the write test. What I remember from tests did on the past (studying about this behave) I conclude the write I/O throughput bounds will be "defined" from the Linux kernel dirty buffers flush/sync para…
Re: Best practices for IDS on virtual machine?
Sorry, Colin, I missed your question at the end. Best not to bottom post! Yes, in part recommeding EXT2 is to avoid journaling overhead. The rest is the copy-on-write feature which physically fragments your chunks over time. As to the others, see my presentation from last yea…
Re: Best practices for IDS on virtual machine?
Gee, that response looks awfully familliar!?!?! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTo…
Re: Best practices for IDS on virtual machine?
Cesar, your timings for read-reread using the OS cache are credible and I will say something about that at the end. However, note that whether you use RAW or COOKED without DIRECT_IO or COOKED with DIRECT_IO your data is safe! When you disable DIRECT_IO and are using COOKED chu…
Best practices for IDS on virtual machine?
- IBM's Hypervisor has the lowest overhead and highest IO rates. - If you must use VMWare make sure you are using the vSphere hypervisor, it's IO is about double the older hypervisors from VMWare or running without one. - Yes RAID10. - As much as possible make s…
Best practices for IDS on virtual machine?
- IBM's Hypervisor has the lowest overhead and highest IO rates. - If you must use VMWare make sure you are using the vSphere hypervisor, it's IO is about double the older hypervisors from VMWare or running without one. - Yes RAID10. - As much as possible make s…
Best practices for IDS on virtual machine?
ext2 with DIRECT_IO worked well for me under VMWare ESXi .... however get as much memory as possible assigned to the VM and make your buffers larger than normal. Expect slower than usual checkpoints and adjust to cater. Try to persuade the VMWare admins to give your VM higher …
KAIO: out of OS resources
we are on 11.7.fc5 on AIX 6.1 i have seen posts on this topic before but they are pretty old. the message in the log is : KAIO: out of OS resources, errno = 11, pid = 14090390 it used to be that the variable IFMX_HPKAIO_NUM_REQ was a default of 1000 and it was suggested to b…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
DIRECT_IO and flags
Hello All, 11.70 FC7 onstat -d shows: 1591ee1d0 1 1 0 10000000 6942353 PO-B-D /data1/infdev/rootdbs.000 in the manual ( 11.10) it says that flag 5 says if direct i/o is enabled. i see here flag 6 being D which i assume direct io is enabl…
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,…
Efficiency of the Informix Virtual Processors
Does anyone know if enabling KAIO will cause a drop in CPU VP efficiency in the onstat -g glo output? Seems to make sense since previously the AIO VPs would have been doing all of the IO waiting and if you switch to KAIO the kaio threads will run on the CPU VPs and the waiting t…
LRU Queues - more or less
which makes sense because setup is roughly one chunk/ dbspace (and there are 10 dbspaces) so followup thought... normally, fragmentation strategies would intelligently fragment data over multiple dbspaces (chunks) to create parallel i/o capabilities commesurate with data usage.…
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…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
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 …
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
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…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
KAIO questions
Jared, No risk that I am aware of. I've been using KAIO in Informix for many years without issue. I did some benchmarks many years ago, and updated with information I've gotten from other folk about the behavior of DIRECT_IO, here's what I know performance wise: 1. RAW device 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.…
Is KAIO in use
Hi, I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched the engine after setting the following OS parameters KAIOOFF=0 and IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs configuration is Min number server=10, Max number server =…
dbspace planning
Hello, I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices. Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP? I'm planning layout below: disk 1. rootdbspace, phys log, logical …
Performance advantage: fragment across dbspaces vs. in single space
Is there any advantage to fragmenting across multiple dbspaces instead of simply fragmenting in the same space? Aside from performance, are there any other reasons to fragment across dbspaces? Using IDS 11.50.FC4 on HPUX 11.23.…
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…
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
Re: HP/UX to Linux - raw space setup question
On Wed, Nov 10, 2010 at 12:20 PM, Art Kagel <art.kagel@gmail.com> wrote: > The developer of the Linux RAW module still maintains it and it is a viable > option. However, following Linus Torvald's lead, Red Hat has deprecated RAW > (as was already mentioned). Linus never wanted…
Re: HP/UX to Linux - raw space setup question
The developer of the Linux RAW module still maintains it and it is a viable option. However, following Linus Torvald's lead, Red Hat has deprecated RAW (as was already mentioned). Linus never wanted RAW devices included in Linux and has always opposed it on philosophical bases.…
Logical log backup aborted (during ontape -r)
Hi, I have the following message in online.log during 'ontape -r' 14:50:01 Logical Log 223793 - Backup Started 14:50:01 I/O chunk is inconsistent chunk 19, pagenum 452853, pagecnt 7 14:50:01 Logical Log 223793 - Backup Aborted Error reading from the disk, Error No. = 0. The i…
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
SDS and SAN Storage
Hi all what is possible and what is the best way to create chunks on a SAN- Storage (NetApp) for SDS. We are planning for IDS 11.50 database installations with SDS feature. OS will be LINUX (SLES or UBUNTU). As Storage we have a NetApp SAN. In case of cooked files (DIRECT_…
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…
Raw Devices
Not the same. It reduces the impact from about 15-35% down to 5-20% depending on lots of factors like cache size, contiguousness, filesystem efficiency w/o DIRECT_IO, etc. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Dis…
Re: KAIO
On 12 jun, 12:05, Tom Lehr <tomc...@gmail.com> wrote: > we are on AIX 5.3 (at some future point going to 6.1 i think) with > informix version 10.fc9 (soon to go to version 11 FC6) and are using > AIO. > has anyone run into any issues turning on and using KAIO with either > inform…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
Re: KAIO
On Jun 13, 11:49 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > I should have said this earlier... The parameter can be modified online > although it does not affect the sessions already started. > Regards. > > On Sun, Jun 13, 2010 at 10:42 PM, Waldemar Znoinski <wznoin...@g…
Re: KAIO
Is FC7 officially released? Thanks On Jun 12, 12:21 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > That message means you haven't configured enough KAIO resources on your > system. Check the product machine notes for details on how to configure it > for the specific platfor…
direct i/o for cooked files in innovator-c edition
DIRECT_IO is not supported, see for example http://www.informix-zone.com/aggregator/sources/32. For me it's unclear if this means is not licensed and that you are not allowed to use it or if this feature is not available. For PDQ I can say, that I got a message on engine start …
KAIO
we are on AIX 5.3 (at some future point going to 6.1 i think) with informix version 10.fc9 (soon to go to version 11 FC6) and are using AIO. has anyone run into any issues turning on and using KAIO with either informix version using 5.3 for aix (or aix 6.1 for that matter)? years…
Re: onstat -g iof
Thanks for replying Fernando. >kaio_reads/writes are I/O operations. Each operation can read/write more than one page. Ah that makes 100% sense... >I/Os per second is a nasty number... No - no reset of the stats... (onstat -z - I thought of that too) I have some hard questions…
RE: Cooked vs Raw in 11.5 on Linux
Just to add something here doing some testing on Solaris10/IDS11.5 we saw between 35 and 80% performance DROP when we enable DIRECT_IO. Raw was quicker by 20% Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel …
How can I drop an empty chunk that is bad
Recently we stopped and started our Informix instance using onmode -yuk and oninit -vy Two non critical empty chunks did not start. The instance started ok however. The application doesn't work though, I'm thinking because of the bad chunks. So I want to drop these two empty bad …
tempdbs in raw or in filesystem
Yes. From the Administrator's Reference: Dynamic Server does not use direct or concurrent I/O for cooked files used for temporary dbspace chunks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Inf…
Re: ids11.5 enable AIO on AIX 6.1
Fernando Nunes wrote: > joe wrote: >> #onstat -g iov >> >> IBM Informix Dynamic Server Version 11.50.FC6 -- On-Line -- Up >> 00:01:14 -- 501344 Kbytes >> >> AIO I/O vps: >> class/vp/id s io/s totalops dskread dskwrite dskcopy wakeups io/ >> wup errors tempops >> fifo …
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
IDS - DIRECT I/O for cooked files problem
Hello, IDS 11.5FC5 in running on SunOS 5.10 (pagesize 8192), DIRECT_IO is enable (set to 1) in ONCONFIG. Cooked files are used to create the dbpaces with a default pagesize of 2048 bytes. When IDS is started the following messge is found in the 'online.log': 11:10:10 Direct I/O…
KAIO error or warning
IDS 11.5FC6 on RHEL 5.2. We're getting a warning, or maybe error, each time we start one of the many instances on this server. requested number of KAIO events (16384) exceeds limit (8448). using 8448. Although the "limit" number varies; sometimes as low as 128. Any ideas what…
RE: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Ian Michael Gumby wrote: > Since you purport to be a database 'guru', riddle me this... What > happens when you have a high number of rows with the same index value? Really... I don't. I found this interesting and tried to help. My first guess was right and I think I managed to…
how can i delete a bad chunk??
ids9.4/linux32 after a chunk bad,i want to delete it i try $ onspaces -d dbs02 -p /spsdb/chunk202 -o 0 WARNING: Dropping a chunk. Do you really want to continue? (y/n)y Chunk not dropped. ISAM error: Chunk not empty so how can i delete this bad chunk force??…
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…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
NAS I/O requirements
My testing: RAW versus COOKED filesystem chunks without DIRECT_IO: RAW is 25-40% faster RAW versus COOKED device chunks (ie block device) without DIRECT_IO: RAW is 15-25% faster RAW versus COOKED filesystem chunks with DIRECT_IO: RAW is 5-10% faster RAW versus COOKED device chu…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
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…
IDS instance memory
That could just be the OS allocating memory for system buffer cache, etc. IB you said you system is Sun, Solaris is aggressive about keeping most IO in cache. Are your IDS chunks COOKED or RAW? If COOKED, then they are likely being cached by the OS unless you have enabled DIRECT_…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
Informix I/O performance
On my phone so the quoting is not good. Introducing my comments with 'ASK'= . See below: Art=20 -----Original Message----- From: KAMRAN HAQ <khaq@i2cinc.com> Sent: Tuesday, June 23, 2009 5:24 AM To: ids@iiug.org Subject: Informix I/O performance [16129] Informix version: Inform…
IO problems and perf
If nothing else is running on the box then RESIDENT is irrelevant. Setting RESIDENT to 1 prevents the 'resident' shared memory segment (which contains the buffer cache and header structures for controlling shared memory) from being swapped out by other processes - you can also se…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
Adding BLOB Chunks to DBSpaces
My question is I added the following chunk to a dbspace using the following command. onspaces -a dbspacename -p /dev/mapper/rawpartition -o 8 -s 5120000 How come now when I run onstat -d update it shows the chunk as half the size? 2560000 KB. Size Free 185f9328 9 5 4 2560000 2…
JFS2 on AIX on IDS
Art Kagel wrote: > Journaled filesystems and databases are a BAD combination! Why? Note: > > * When you rewrite a page in a journaled filesystem the FS does not > overwrite the existing page, it writes the page back to a new > location and marks the original cop…
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 …
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
11.5 crashes after upgrade, data lost
Hi Art, Here are the answers you requested: Are your chunks in filesystem space or device space? FS If a filesystem what type of filesystem? ext3 Is DIRECT_IO enabled? Yes If DIRECT_IO is disabled how many AIO VPs versus how many chunks? If device space RAW (character) or C…
Esoteric Disk Issues
Cooked devices are ~4-5% slower than RAW devices with DIRECT_IO and 5-10% slower without DIRECT_IO. Cooked files (or filesystem chunks) are an additional 1-3% slower than COOKED devices with DIRECT_IO and 10-15% than COOKED device chunks without DIRECT_IO. That makes the total pe…
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…
I/O bad request chunk 0
OS version: uname -a HP-UX servername B.11.11 U 9000/800 unlimited-user license Informix version: onstat -V IBM Informix Dynamic Server Version 9.30.FC6X9 Hi all, I saw the following error messages appear in the online log 08:31:07 Maximum server connections 137 08:34:56 I/O b…
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
Re: Database import from Infomix 5.0 to IDS 11.0
You can dbexport on the SCO server, as already discussed, and import into RHEL. The storage type of the chunks is irrelevant, however, note that COOKED chunks, even with DIRECT_IO enabled are slower than RAW chunks EVEN on Linux. Art On Tue, Nov 18, 2008 at 8:30 AM, LAKSHMI DEV…
IDS i/o and Solaris
"Fernando Nunes" <domusonline@gmail.com> wrote in message news:get93l$5fm$1@registered.motzarella.org... > Neil Truby wrote: >> IDS 10.0FC8W2 on Solaris 10. >> >> We're just migrating to a new server from IDS 10.0FC8W2 on Solaris 9. >> >> The customer's SysAdmin has seen great re…
Re: Raw Disk still preferred for 11.5?
Superboer wrote: > Hello Fernando, > > does DIRECT_IO bypasses the filesystem cache??? using cooked can kill > performance because linux/unix is being hit > (to) hard. Yes, but look for further comments below. > one example is do a restore on char mode raw dev and cooked spec…
Re: Raw Disk still preferred for 11.5? - File system type for SDS
Thanks so much for all the feedback, I have learned a great deal. I think we will go with a cooked system. I think it will be better administratively, since they wont give me root access to the new servers and it will be a chance to try something new and test the performance. …
Re: Raw Disk still preferred for 11.5?
InDeep wrote: > Fernando, > > Great article you put out. Yet another great Informix feature, > DIRECT_IO. I would not have read about this other than your article. > Thanks, but DIRECT_IO is just IDS way of taking advantage of a concept that exists... > I'd still steer clear …
Re: Raw Disk still preferred for 11.5?
Hello Fernando, does DIRECT_IO bypasses the filesystem cache??? using cooked can kill performance because linux/unix is being hit (to) hard. one example is do a restore on char mode raw dev and cooked specially on Sun. Cooked restore is a factor 2/3 or more slower!!! besides …
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…
Raw Disk still preferred for 11.5?
InDeep wrote: > Fernando, > > Great article you put out. Yet another great Informix > feature, DIRECT_IO. I would not have read about this other > than your article. > Because you don't read the release notes? > but hey I could be wrong. > Well, there's a novel concept. :op …
How can i list the chunk names used in a backup?
How can i list the chunk names used in a backup? I am trying to write a script to automate the restore process of ontape backups from a variety of different 'source' databases on my test box which has a lot of disk space. I know i can run ontape -r manually etc, and it will lis…
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…
copying instance
Hi, How can I copy a instance to the same machine using ontape and putting the dbs and chunks in another location? I´m using IDS 11.5 tks henrique_lima_2000@yahoo.com.br Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
DIRECT_IO onconfig parameter
Hello, IDS 11.10 FC2W4 on Solaris 10 Pls refer me a document or help me in finding out if my file system supports direct I/O for the 2K and 8K page size dbspace chunk in my system so that i can set the onconfig parameter DIRECT_IO to 1 and use the direct I/O feature for better …
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
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…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
onstat -g rea almot 100 queue there !!!
>Yes, you've got it. You are correct, your chunks certainly do look like >they are RAW and so KAIO should be working for you, but, as I said, it's >not. Your onstat -g iov output does not show any kio threads running. KAIO >is on by default on all platforms except HPUX (because H…
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 using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
Full Proof way to determine if ontape is restoring
Thanks Art. There are actually a few I/O chunk is inconsistemt chunk messages in the online.log. However these may be due to the fact that I ran an oncheck -pr during the ontape -r just to see what I could find. Do these messages necessarily indicate a real problem? Or is it one …
onspaces question..corrected typo
I hope you don't mind-I have a simple onspaces question (I did look in manuals for the answer and did not find a definitive answer). Anyway...to bring a PRIMARY mirrored chunk online the syntax is onspaces -s DBSPACENAME -p PATHAME_OF_CHUNK -o OFFSET -O Now my question...if it'…
very simple onspaces question?
I hope you don't mind-I have a simple onspaces question (I did look in manuals for the answer and did not find a definitive answer). Anyway...to bring a PRIMARY mirrored chunk online the syntax is onspaces -s DBSPACENAME -p PATHAME_OF_CHUNK -o OFFSET -O Now my question...if it'…
Real simple onspaces question?
I have a very simple onspaces question. I know, newbie here. I did try finding out the answer in some manuals and books I have but believe it or could not find a definitive answer. Anyway....with IDS 9.4 to bring up a Primary chunk that is offline the syntax is.... onspaces -s DB…
Emergency! How to recover informix 7.4 from mirror
Hi. We have a serious outage! Our informix 7.4 IDS production crashed because a primary chunk has I-O errors! Question How can we recover from the mirror? It is mirrored? Pleas help! this is an emergency!…
checkpoints Excessively slow
thanks for your response there is a fragment on file online.log Fri Feb 8 00:47:44 2008 00:47:44 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 01:04:38 Checkpoint Completed: duration was 5439 seconds. 01:07:00 Logical Log 2…
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…
Raw device with Suse Linux Enterpise 10 and INform
Schuran, Sven wrote: > Hi, > > the raw device module is depreceated with Kernel 2.6.16. > Everyone is talking about O_DIRECT access. > > Question: IDS10 is setting O_DIRECT automatically when I am using an LVM2 > Partition? > Direct IO support is off by default. You have to set …
Tuning Checkpoints
Andreas.KUTSCHE@spar.at wrote: > Hi Art, > > you wrote > > >> Are chunks using KAIO (ie are they RAW device)? If so you may have to >> tune the HPUX KAIO subsystem. Tuning KAIO on HPUX can make a huge >> difference in write times like checkpoint. >> >> > > We are on HPUX with KAI…
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
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 …
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
ontape or IDS problem
> - Adding over 3 TB of chunks to the blobdbs. potentially it does something really inefficient trying to locate blobs in empty blobspace chunks. how many of those 3TB chunks are empty?? Suppose you have 20 empty chunks, i would drop in that case 18 chunks and look if your pro…
I/O bad request chunk 0
Hi, We have an Informix Dynamic Server 7.31.UD3 on a HP/UX 11.11 system. Recent days during onunload process (to a local file) informix started to generate the messages below in online.log file. I/O bad request chunk 0, pagenum 456, pagecnt 1 I/O bad request chunk 0, pagenum 464…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: KAIO Question [8766]
Art, I did have our Techs configure one raw dbspace/chunk that I added within the instance to see if that made a difference, but it did not. -John -----Original Message----- >From: "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> >Sent: Mar 30, 2007 7:56 AM >To: ids@iiu…
Re: KAIO Question [8763]
Art, I agree, and having checked for the env variable "KAIO_OFF=1", made sure it was removed from the .profile, and confirmed I do not see it set anywhere else. I have bounced the engine, and confirmed it does not exist, but still do not see the KIO thread. Do I need to do som…
KAIO Question
To any AIX / IDS gurus out there, Background: We are running IDS 10.00 FC4 on AIX 5.2 TL8. We have been having some AIO issues with two boxes (each is a 390 with 8 cpu's), one dev and one prod. We tuned the DEV box with min and max AIX AIO 5, and 180 respectively, and it is run…
KAIO Question
To any AIX / IDS gurus out there, Background: We are running IDS 10.00 FC4 on AIX 5.2 TL8. We have been having some AIO issues with two boxes (each is a 390 with 8 cpu's), one dev and one prod. We tuned the DEV box with min and max AIX AIO 5, and 180 respectively, and it is…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
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…
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
IDS and kaio on RHEL
10.0FCx and FC6 on RHEL 4 Be careful when installing IDS FCwhatever on very new versions of RHEL AS 4. The newest versions have the libaio module libaio-0.3.105-2 Trying to runIDS kaio with this gives: 17:43:04 libaio.so.1: cannot open shared object file: No such file or dir…
using onspaces for non-mirrored chunks
Hi all, One chunk is down on the secondary database (in HDR). The chunk is not mirrored. When I try to run the command onspaces to bring it up I get the error: >>>onspaces -s wi_d2dbs -p /informix/prod/online02 -o 1650100 ?O >>>Warning: Bringing chunk back online. >>>Do you reall…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
Block device to character device
Hi All, I have a situation here. One of my customer is configured their chunk on block device and character device. As data growth there it suffered with I/O bottleneck on some of the chunk. According to them those are block device chunk. So my questions are: 1. Is there a simpl…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Re: KAIO exceeds limit
Can't answer the original question, but try to switch off hyperthreading on that second machine and see if it helps. Intel Hyperthreading on Linux can cause some mysterious Informix (mal)behaviour, I've seen few unexplainable crashes solved just by removing Hyperthreading. "Max …
KAIO exceeds limit
Hi, I have 2 server setups, which slightly differ in specs. Both servers are IBM x336 with RAID 1 on 2 internal disks with RHEL4 installed(2.6.9-42.0.3.ELsmp). Both with IBM Informix Dynamic Server Version 10.00.UC5 1. One server is without hyperthreading and with a raw disk i…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
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…
mirroring dbspaces
Hi all, anyone having experience with mirroring ? I inherited an informix config from a former collegue, and it looks very strange and insecure to me. In short : system running Solaris 8, 2 disks. All slices EXCEPT slice 6 (used for Informix raw-devices), are mirrored with Sol…
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…
Can't drop down dbspace
I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that…
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…
Quick Ontape -r rootdbs question
Hi, If you attempt to use the ontape -r with redirection of the chunk names parameters for a specific database, is there any effect on rootdbs for the other databases? In other words if we have a 2 server set up described below and restore one dbspace, will ontape also restore th…
TEMP DBSPACE
Hi we have two quries like below create temp table tmp_table_no ( sl_no serial, lang_a char(2), lang_no char(14), rec_cnt integer) with no log second one is insert into tmp_table_no (lang_a, lang_no , rec_cnt) ", select distinct language_a, lang_no, count (lang_no) from ti_lang…
Informix KAIO Error
Hi people !! I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO initialization. Following the online.log Tue Jul 4 08:57:38 2006 08:57:38 Event alarms enabled. ALARMPROG = '/sgbd/informix/etc/log_full.sh' 08:57:44 DR: DRAUTO is 0 (Off) 08:57:44 Informix D…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Virtual shared memory: aio pool
"Who use the aio pool" Any users writing to chunks that are not using kaio. And the server read/writing filesystem files e.g. writing to message log, reading onconfig file on startup, reading message files if an error occurs. "What is place in the aio pool" I assume AIO (…
Re: Long checkpoint woe
Make sure the KAIO is working. onstat -g ath | grep -i kaio will show if kaio is working, you should have I kaio thread for each NUMCPU defined in your onconfig. Does onstat -g ioq show any values in the "len" and "maxlen" for any gfd's? Post it if unsure. Post onstat -d and ls…
Re: RE: Update statistics performance
You'd better run 'update statistics for table <table_name>(<column_name>) in paralle.Moreover, You should config KAIO for online. KAIO can reduce update statistics time in my experience.…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Re: I/O error in message log
I'd bet a few € cents on that this is bug 167020. Check your chunks (esp. the temp chunks') chunk free list pages and see if they have suspesious pg_next values in their page headers. HTH, Andreas Zev Berezin wrote: > Hi All, > > This is coming up in the message log like ev…
Re: I/O error in message log
I'd bet a few � cents on that this is bug 167020. Check your chunks (esp. the temp chunks') chunk free list pages and see if they have suspesious pg_next values in their page headers. HTH, Andreas Zev Berezin wrote: > Hi All, > > This is coming up in the message log like …
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: I/O error in message log
The Version was 9.30 FC7 not 9.30FC5 12:21:11 Btree scanner range scan size set at 100. 12:22:49 Fuzzy Checkpoint Completed: duration was 2 seconds, 953 buffers not flushed. 12:22:49 Checkpoint loguniq 8734, logpos 0x17af54c 12:22:49 Maximum server connections 242 12:23:09…
AW: I/O error in message log
Zev Berezin wrote > > I/O bad request chunk 0, pagenum 85003, pagecnt 1 > > Any ideas? This is strange as chunk 0 does not exist - Informix starts counting chunks at 1. I have seen this kind of erro before- if I remember corrctly it was some sort of corruption in the root resev…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
RE: KAIO and AIX
Turn KAIO on for AIX. MW -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of tomcaml@yahoo.com Sent: Thursday, 19 January 2006 8:50 a.m. To: informix-list@iiug.org Subject: Re: KAIO and AIX not sure i follow, Dir…
RE: KAIO and AIX
KAIO works well on AIX, last time I worked on AIX was using 4.3.x, my only experience of KAIO, HP and Informix was a "difference of opinion" between HPUX and IDS (not the companies, the software!) vwhich meant it didn't work so it had to be turned off. I'd say use it Regards C…
KAIO and AIX
hello all we are currently on hp-ux 11i and IDS 9.40 FC3 and have KAIO turned off - and all works well. Any reason to turn it back on AIX or experiences to share? Thanks, Tom…
KAIO question...
Hi there! Have a question about KAIO on Windows... Does Windows use KAIO by default? if not, how can I make it work if it is possible. And another question... If KAIO is turned on in Windows, does Informix use it automatically, or should I modify Informix parameter KAIOON=1 to …
ONLOAD crashed IDS
I just tested onunload / onload on my version (7.31FD3). The unload went ok, but when I ran the load (onload -t dirk.unl testdb:dirk2), I got an assert failure :-0 11:27:33 I/O bad request chunk 0, pagenum 13760, pagecnt 1 11:27:33 I/O bad request chunk 0, pagenum 13792, p…
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
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.…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: Failed Import, ISAM 172 Error, Corrupt Indexes
well you are getting I/O read errors on chunk 9... onstat -d ...what is chunk 9? What platform? Can you do dd if=<chunk 9 path> of=/dev/null bs=1024k count=10 ? Are the permissions on chunk 9 ok? Owner informix group informix, mode 660…
Failed Import, ISAM 172 Error, Corrupt Indexes
Working with INFORMIX 7.32, our normal import to the database failed today. Upon further investigation, I found this error (below). The oncheck -pt indicated that the table could not be accessed. I ran an oncheck to check the indexes, and it seems several of the database index…
Re: IDS 10 erratic run times
fromthe online manual Kernel-Asynchronous I/O The database server uses KAIO when the following conditions exist: The computer and operating system support it. A performance gain is realized. The I/O is to raw disk space. Block special devices are still raw devices so we should…
Re: IDS 10 erratic run times
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:3polnvFbicgoU1@individual.net... > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:3pliprFb403pU1@individual.net... >> IDS 10.0FC3 on Solaris 2.9 > > I conclude that our problem is with kaio and v10 at our …
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…
Database and no dbspace
Help. The dbspace is drop but now the database can't be drop. How do I drop/remove the database. I have created the dbspace but no luck. error: 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist…
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:…
Error when trying to Create a Database
Hello David, sounds like you have a i/o problem on chunk 6 ; replace disk and restore.. onstat -d and look for chunk 6 it probably has flags PD; if so restore time... do a dd if=<chunk6> of=/dev/null you probably get errno 5. Superboer. David Reed schreef: > Hi > > On Inf…
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…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
RE: KAIO
Under Linux, Raw devices should be used for Informix storage whenever possible. The major reason for that is that Linux virtual memory implementation is optimized for 'traditional' (like web server) file system access, not for database servers. The biggest problem is that Linux…
Re: KAIO
Mark wrote: > Thanks. In the past I remember seeing recommendations against using > cooked simply because it was not considered 'safe'. The argument was > something along the lines of needing to be sure that data was actually > written to disk rather than stuck in the cache when …
Re: KAIO
superboer wrote: > dono it this is true.... heard about this long time ago: > > -- when one has aiovp's instead of kaio and one logs one there is a lot of > -- chitchat going on between vps; making them aware of new connection??? > -- if you have a big number of these it can impa…
RE: KAIO
That safety argument was subject to discussion. Actually, even when writing to cooked files, we use a flag to the write call (I think it's O_SYNC, without checking it now ...) which means the OS shall write the buffer to disk and only afterwards return from this write call. This…
RE: KAIO
Thanks. In the past I remember seeing recommendations against using cooked simply because it was not considered 'safe'. The argument was something along the lines of needing to be sure that data was actually written to disk rather than stuck in the cache when a system failure occ…
RE: KAIO
Hi, I'm not sure. I happen to know this for Linux, but for other OSs I don't really know. I think it is always said that on Solaris you should use raw devices (rather than cooked files) for better performance, but it's been a long time that I had a look at the difference myself.…
KAIO
dono it this is true.... heard about this long time ago: -- when one has aiovp's instead of kaio and one logs one there is a lot of -- chitchat going on between vps; making them aware of new connection??? -- if you have a big number of these it can impact performance. Besides t…
Re: KAIO
Ben Thompson wrote: > Martin Fuerderer wrote: > >> For a system like this, KAIO will not have much benefit, as >> filesystem I/O is very efficiently done via Linux's file system >> caching. > > Interesting post. Can I infer from this comment that the Linux file > syst…
RE: KAIO
Are there any other OS's where the FS caching mechanism is very efficient and therefore should be taken advantage of when memory is not an object? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Martin Fuerderer Se…
Re: KAIO
No, of course not, because raw devices are not handled by the file system. That is why they are raw rather than cooked. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 21.01.2005 13:10:13:…
Re: KAIO
Markus Bschorer wrote: > ok, may be its Version 9.5, because the Beta-Tester told me, that it's not > currently released and that it will be released in the first quarter of > 2005. > What do you mean by "definite improvement" ? An improvement of 5% is not > reason enough (for m…
Re: KAIO
Martin Fuerderer said: > > a) there's no KAIO support in 9.40.x (as others have already noted). > You can use raw devices, but not KAIO. On Linux, I assume. :o) -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying …
Re: KAIO
Hi, a) there's no KAIO support in 9.40.x (as others have already noted). You can use raw devices, but not KAIO. b) KAIO will be supported with the next version. This is what the Beta-Tester most probably was talking about. c) To judge the effect/benefit of KAIO on Linux is…
RE: KAIO
KAIO is not supported in 9.4 on Linux. It should be supported in v.next (9.50?) expected soon -Alexey > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of Markus Bschorer > > Hi all, > > on some websites, you ca…
KAIO
Hi all, on some websites, you can read wonderful things concerning KAIO, like dramatically better performance in high-traffic-scenarios. Linux Kernel 2.6 supports KAIO. I talked to a Beta-Tester of IDS Version 9.4 UC5, which supports KAIO under Linux 2.6. He told me, that there…
KAIO: out of OS resource
Hi All, We are using Informix 9.4 on HPUX 11i with KAIO turned on. We are using = ESQLC Code, JDBC, Stored Procedure and dbaccess to access the database. = We have observed the following error message in the informix log file. I = have the following questions with regards to thi…
Any sense in this ...?
ids v9 what do you think to the theory that turning off kaio might relieve a cpu-bound system?…
KAIO or not KAIO in EVA 3000
hi all I have a SAN (EVA3000) active or not the KAIO, version UNIX HPUX11i V1 informix 9.40 thanks…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
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…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
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…
Logical logs from rootdbs to own logspace
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
Re: ONCONFIG for 9.40 offered for comment
Neil Truby wrote: > > Yes, it is unchanged from 9.21, although we have enabld kaio with > 9.40, having had it disabled with 9.21. hmmm - HP KAIO is such a pain in the. I don't suppose you could flick it off and see what happens?…
creating large chunks/dbspaces
I just installed 9.4FC3 on HP/UX 11 and want to use large chunks (3-5GB). I have the symbolic links setup of the correct size and am now trying to create the dbspace/chunk. Both onmonitor and onspaces tell me my chunk size is too big. I have run 'onmode -BC1 & 2. How am I sup…
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.…
RE: Performance advice
On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp tabl…
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…
Changind Status of a Chunk
Informix Vers = IDS 9.21.FC4 OS = HPUX11.0 I am trying to change the status of a chuck but I keep getting...... $ onspaces -s arcdatdbs -p /dev/vg_archive/rlvol3 -o 0 -D -y Cannot bring this chunk down, it is currently the only chunk up. This error occurs no matter which one o…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
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,…
dbspace destroyed
Hi! On one machine dbspace was destroyed by unwary sysadmin who repartiioned disk with informix chunks on it (raw devices). Now, informix can be started (it complains about missing chunks though). What is the procedure for removing staled information for chunks? I should remov…
RE: Force to drop a chunk ?
Hi Ken. You can not drop chunk force. 2 ways dropping chunk. 1. Contact IBM technical support. 2. unload all data that contains bad chunk in DB spaces. Drop DB spaces. Create DB spaces and chunk. Load data. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 …
Force to drop a chunk ?
Dear All : My platform is IDS 9.21 running on Linux OS. I made a careless mistake to delete a chunk file , then I try to drop that chunk from the dbspace that it belonged to : onspaces -d tmpdbs -p /data/tmpdbs_chunk2 -o 0 But the system gave me an error message and did not a…
Re: is it ok to use KAIO on HP-UX
http://www.smooth1.demon.co.uk/ifaq06.htm#6.20 Look for the bit starting... Here is the real story behind Informix/HP KAIO over the years... "Malc P" <malc_p@btinternet.com> wrote in message news:8c28402a.0402070238.38a7a040@posting.google.com... > Obnoxio The Clown <obnoxio@h…
Dropping/Adding Chunk - Error
Dear Adrian, The TBLSPACE TBLSPACE is an internal table used to track all tables in a dbspace. Unfortunately there are no means to control the location of extents of that tablespace. The only way to get rid of the chunk is to move all tables of the dbspace the chunk belongs to t…
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…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
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…
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
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…
Re: chunk removal
TBP wrote: > > Geezer From Freezer wrote: > > I've added a chunk which I think may be too big. Now the chunk "new" chunk is > > part of an existing dbspace. It seems that 3 blocks are used (this always seems > > the case when adding a chunk anyway) and no other data has been allo…
chunk removal
Geezer From Freezer wrote: > I've added a chunk which I think may be too big. Now the chunk "new" chunk is > part of an existing dbspace. It seems that 3 blocks are used (this always seems > the case when adding a chunk anyway) and no other data has been allocated to > this > chu…
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?…
chunks and raw filesystems
On Wed, 19 Nov 2003 14:55:42 +0000, Geezer From The Freezer <Geezer@Freezer.com> wrote: >I've been adding chunks to Informix using the incorrect size >to fully use a disk partition. I am going to start using the >correct size now (and correct the old ones at a later date). > >No…
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.…
RE: Informix 9.4 and KAIO (HP)
Tom, I had some problems with KAIO on HP (HPUX 10.20) with IDS 7.31 few years ago (with one of my customers). One of these problems was extremely unpleasant: when KAIO was 'on', 'ontape' was unable to restore Informix from archive... ------------------------------------------ …
informix 9.4 and KAIO (HP)
Greetings! had heard that KAIO was a problem (?) on version 9.4 with HP-UX 11i. Anyone hear the same or have experience that this is true? Thanks in advance! Tom…
IDS 7.3* - Long long long checkpoint !
I've noticed very long checkpoints in the online.log file. What does IDS do in a checkpoint that can take so long ? Environnement: IDS running on NT 2000 or Linux (even SCO !) with at least 128MB RAM, monoproc. IDS is usually the only big apps running on the box. "Small" databas…
big dbspace
Hello, I need a very big dbspace (at least 15Gb) for my database (IDS 9.4) but the limit for a single dbspace is about 2Gb. How can I increase this limit? thank you…
break one dbspace in to two dbspace
Hi all I have one dbspace where I have all data and indexes I wanted to created one more dbspace one dbspace has the data in it one dbspace has the indexes in it how do that ? regard sending to informix-list…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
How to acrtivated Kernel Access IO (kaio) on IDS Ver 7.31.UD2 on Linux Suse 8.0 pro
I am used to make running an engine on HPUX with KAIO... Is this fonctionnality possible on Linux Suse 8.0 pro (under a Compaq box) ? If yes, !waht should I do to activate it ??? TIA Bruno.…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
RE: waiting on flush of log buffer - try two - Assembled_onstats.
James, It seems that IDS is unable to flush logical log buffer on time. One possible reason is that You are using KAIO (I see KAIO threads in Your output)…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
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…
Reg: Max size allowed in creation of dbspace
Hi , I need to create a dbspace of abt 5-6 GB. on using onspaces to create the dbspace i am limited in size to about 2.09 GB is there a way to create a dbspaces of about 6 GB or is there a size restriction ? Thanks for any help Sudhir sending to informix-list…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
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…
'I/O bad request chunk' error message in online log
Hi All - Last night I manually shutdown and brought up the database. I verified it was online before going home. This morning, I have discovered these error messages in my production environment. Does anyone know what's causing them? How critical are they? How can I fix them? …
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
help to bring chunks off-line for recovery
I am testing new version of OMNIBACK using onbar for Backup and Restore Informix data spaces. I want to test to restore for a particular dbspace, for that I need to off-line a dbspace or chunk for recovery. What is the best/simple way to bring a chunk/dbspace off-line ? Any und…
KAIO benefit
I've been thinking of turning on the KAIO on our HP 11.0. But I just want to ask what is really the benefit I would get if I do this? The release notes just say its good for raw partitions, and other performance guides tell its good. But I want to have some data to observe before…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
KAIO
I am trying to turn KAIOON. The system administrator has enabled the kernal parameter and says I should be able to use it but check out the message below that I get in the online log when I try to run with it turned on. Any ideas of what could be causing the problem? ------------…
KAIO statistics
I am built a small test database server to test KAIO. What does it mean when one KAIO is doing nothing and one KAIO has done everything? Here is onstat -d and onstat -g ioq Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 14:46:41 -- 24576 Kbytes Dbspaces address …
Can't remove a blobspace
I have a blobspace that I'd like to get rid of. When trying to use "onspaces -d test_0_9_3_bs", I get the message Cannot drop the Space. Smart Blobs: sbspace exists but is currently down When trying to use "onspaces -s test_0_9_2_bs -p /<pathname>/test_0_9_2_bs -o 0 -O" I g…
Infomix monitoring tools
all, Anybody have come across any good and reliable informix monitoring tools, that can monitor like chunk/dbspace i/o, read write caching, dbspace info, table info and so on. Thanks and regards Tham…
KAIO and HP-UX 11
In the year of Our Lord Fri, 12 Jan 2001 21:27:22 GMT, patricia_br@my-deja.com broke a vow of silence to utter: >Happy New Year ! I just got back from Brazil and I wish you could see my >beaultiful sun tan. Anyway, back to business: Thanks to my new 14" telescope and my view of…
Residency and KAIO
Hi everybody, up to now we have been using resident 0 on 7.31FC7.But we recently added 1 Gbyte of Memory (total 3 GB).Should I turn resident 1 , and does Informix recomment using residency when using KAIO? Another question is that every time I stop and startr the database the # …
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
RE: KAIO - where is the M in RTFM ?
Bogdan, I believe you can set KAIO via onconfig.servername as KAIOON 1 #( in IDS 2000 it's set by the software default) or KAIOON 0 #( to unset it) Elena. -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Wednesday, December 20, 2000 1:28 P…
RE: KAIO - where is the M in RTFM ?
Have you set the Kernel parameters as described in the release notes? -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Bogdan Neagu Sent: Thursday, December 21, 2000 10:28 AM To: informix-list@iiug.org Subj…
KAIO - where is the M in RTFM ?
Hi all. We were the lucky ones to get a KAIO: out of resources message. We run IDS 2000 9.21 FC2-1 on Solaris 7. Is there a way to tune the kernel fto prevent this on Solaris 7 ? Can we just turn KAIO off ? Thanks, Bogdan Neagu…
KAIO variable - usage?
How does the KAIO environment variable work? When it is set to 1 in the shell that starts the database by running oninit - is KAIO used for all processes for all users? Or do I have to set it in any shell that should use KAIO? Thank you, Jens…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
KAIO - out of OS resources ..any idea
Hi I had the same problem a little while ago, also placed a call in this newsgroep and got the folowing solution: btw, i had to increase to 2048. > I know this comes to you quite late after your posting (I'm trying to > catch up on my news group reading), but I did not see …
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…
Kernel IO Acess (KAIO)
My Online is runing under Sun Solaris 5, and I would like to activate Kernel IO access. The release notes on my version say that KAIO are supported. Does anybody know the procedure, how to active KAIO ? Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
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…
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
problem using onspaces to recover chunks on EMC
It seems that I can't use onspaces to recover down chunks ( after disk failure ) after relinking the chunk and moving it to EMC Symmetrix 3700 array using the power devices provided by power path. The disks are under RAID-1 at the array level. After a hard drive failure ( Sun SS…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
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…
KAIO Error
I have a IDS 7.30 UC8-1 server running on HP-UX 11.0 system and currently have KAIO enabled. Recently when bouncing my databases I found this in my online log: 15:08:09 Informix Dynamic Server Initialized -- Shared Memory Initialized. 15:08:09 Physical Recovery Started. 15:08…
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…
Problem with kaio
IDS 9.20 on HP-UX 10.20: I have one 9.20 instance on this test server which is fine. When I try to start another I get the message below. The instance will however start fine without kaio. I've set all the kernel parameters to the port values as per the release notes. Does an…
RE: KAIO - error
> I know this comes to you quite late after your posting (I'm trying to > catch up on my news group reading), but I did not see a reply. Here's what > I know. We received this also during initial testing during an upgrade > from Pyramid DC/OSx UNIX running Informix 4.10 to Siemen…
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…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
KAIO error on a HP-UX 10.20
> > we try to activate KAIO on a HP-UX 10.20, and get the following error: > > Is the driver in the kernel? You have to add it in, re-compile, mknod the /dev, and reboot. rick…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: KAIO - error
"X. Pietje" wrote: > > Hi All, > > Does anyone have experience with the following KAIO-failure in online.log: > 14:13:05 KAIO: out of OS resources, errno = 11, pid = 1846 > 13:22:19 KAIO: out of OS resources, errno = 11, pid = 1846 > 13:22:19 KAIO: out of OS resources, errno =…
KAIO - error
Hi All, Does anyone have experience with the following KAIO-failure in online.log: 14:13:05 KAIO: out of OS resources, errno = 11, pid = 1846 13:22:19 KAIO: out of OS resources, errno = 11, pid = 1846 13:22:19 KAIO: out of OS resources, errno = 11, pid = 1849 13:47:50 KAIO: …
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…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
Urgent help needed
Hi I have an urgent problem. I tried to restore a dbspace using 'onbar -r -p dx_cdm_dbs -O' but the restore crashed right after the dbspace was set offline/down. Now I would like have this dbspace back online or dropped. But when I try this : abrudv0_TESTM>onspaces -s dx_cdm_db…
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…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
RE: KAIO in AIX
Andre, I am not sure what you mean by "more KAIO to the engine". However, IBM recommends that the following KAIO parameters be set based on your number of disks. MINIMUM number of servers = 5 * (# of disks) MAXIMUM number of servers = 10 * (# of disks) These values are s…
KAIO in AIX
Hi all!!! I came to a deadlock tying to figure this one out. Is there a way to add more KAIO to the engine? We are currently using Informix Dynamic Server 7.31.UC3 installed on in AIX 4.3. Thanks! Andre Ngo Sent via Deja.com http://www.deja.com/ Before you buy.…
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: turning on KAIO
On Sun, 27 Feb 2000, Steven wrote: > 03:17:45 Can't open /dev/async. KAIO disabled > 03:17:45 Can't open /dev/async. KAIO disabled > 03:17:45 Can't open /dev/async. KAIO disabled > 03:17:45 Can't open /dev/async. KAIO disabled > 03:17:45 Assert Failed: kaiothread() ERROR…
turning on KAIO
Hi, Just managed to upgrade my IDS from 7.24UC4X1 to 7.30UC7XB on HP-UX 11. Was trying to turn on KAIO by doing the following added setenv KAIOON 1 setenv IFMX_HPKAIO_NUM_REQ 2300 but was unable to start up my IDS. From the documentation, I seems to need HP KAIO driver "async…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
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…
Informix / Solaris 2.6 / KAIO
Look for KAIO info in $INFORMIXDIR/release/en_us/0333/<Release Specific INFOs>. You can see KAIO configuration document here. You need to setup couple of ENV Var and a device setup (/dev/async) Rgds Jay Aymond wrote: > I just upgraded to Informix 7.31 on Solaris 2.6. I am ge…
KAIO question
Is anybody running KAIO on HP-UX 10.20 with IDS 7.31.UC4? Does it run okay or is that bug still a possibility? Thanks, Dianne…
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
KAIO: HP-UX 10.20 / IDS 7.24
I am looking to canvass option on the implementation of KAIO with HP-UX 10.20 and IDS 7.24. We are aware of "Bug: 92132 HP KAIO HAS A SIGNIFICANT I/O BOTTLENECK", however, I am looking for any practical experiences. The questions which I would appreciate a comment upon if you ar…
allocating more table space
"M.J. Holley" wrote: > > I have one table (2 chunks) that seems to have run out of tablespace after > someone loaded in half-a-million rows without mentioning it (we won't > discuss why). I should know this...but what is the most efficient way to > add tablespace here? I have p…
About KAIO
Hello. My system is HPUX 11.00 and IDS 7.31.UC2, I'd like use KAIO. Anybody use KAIO in systems HPUX, what versions or patchs are used ?. Thanks.…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
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: Chunk Offset address
From: musman@my-deja.com > >I am bit confuse on the Chunk offset address. I have a 9GB disk and have >created 4 raw partitions of 2.01GB each. All these chunks 2GB each will >be used for the same dbspace [datdbs]. The first chunk should have the >offset 0 but what should be the o…
Chunk Offset address
Hi I am bit confuse on the Chunk offset address. I have a 9GB disk and have created 4 raw partitions of 2.01GB each. All these chunks 2GB each will be used for the same dbspace [datdbs]. The first chunk should have the offset 0 but what should be the offset address of second, th…
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…
Error message
Hi, I've got a problem with Informix 5.10.UC6. There is an error message in the informix log file: 13:41:36 I/O bad request chunk 0, pagenum 0, pagecnt 1 Platform is HP-UX B.10.20 C. Thanks in advance.…
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…
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
KAIO with HP UX 10.20
Hi, Gurus In a HP UX 10.20 it's better to set multiprocessor with KAIO set to one with a Informix 7.31 UC2A??? And relationed with the previous question, are there any correspondence between KAIO set to 1 and the memory used? Thank you very much.…
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…
KAIO on Sun
SunSparc 20. SunOS 5.5.1. ODS 7.22.UC2. Does anyone have experience on this platform with KAIO verses AIO? It appears that KAIO is on. I am wondering if it would be better to have KAIO off and use AIO. Here are some onstats: AIO I/O queues: q name/id len maxlen totalops …
dbspace not empty
Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I ca…
Re: move dbspace/chunks on NT
Jay Walters wrote: > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? > > TIA, Sure. Save data from the dbspace containing your chunk (dbexport, unload, onunload). Remove all data from the dbspace. Drop …
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…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
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…
KAIO with Solaris 2.6
From what I have understand, KAIO is off by default. The release note of my Informix (7.30UC5) running on a Solaris 2.6 (SunOS 5.6 Generic_105181-11 sun4u sparc SUNW,Ultra-250) tells me KAIO is supported. I have several raw devices but also some cooked files. (raw devices …
Re: informix parameters in onconfig file
pankaj wrote: > > Hi , > > Not an Informix Expert but your NUMAIOVPS seems somewhat low. Informix > recommends NUMAIOVPS (2 + number of disks used for online). > Then monitor length of aio queues. onstat -g ioq [Original message SNIPPED] Pankaj, If you have Kernel Asynchronou…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
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…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
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…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
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.…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
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…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
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…
Drop chunks.
"Martinez, Miguel (Mabe,Lav,Ti)" wrote: > > How can i drop a chunk. Note that you can only drop chunks that are entirely empty (only a few pages show used). For the last chunk of a dbspace or an entire dbspace: onspaces -d dbspace For other chunks of a dbspace: onspaces -d d…
What mean NUMAIOVPS
PASCAL_GINESTE@Non-HP-France-om4.om.hp.com wrote: > > > Hi Gurus informix, > > Can you tell me what does mean parameter NUMAIOVPS > and in which situation it must be increased ?? > > best regards > > PS: our infx administrator has increase this limit from…
KAIO Performance question
Hello, We are testing an SCO 5.0.5 server, on a dual Pentium II Xeon, 512MB RAM and 4x9GB disks, with IDS 7.30 UC2 We have a stored procedure that takes around 90 minutes to run. Enabling or disabling KAIO does not make any difference in the 90 minutes. With KAIO enabled, we …
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
KAIO on HP/UX 10.20 & Informix 7.30
Hi, Is anyone out there using KAIO on HP/UX 10.20 and Informix 7.30? Does it work? Did performance improve? Did performance decrease? Any problems with running KAIO? Thanks in advance. -- Melvin Mariney e-mail: melvin.mariney2@bridge.bellsouth.com…
IDS 7.23UC6 Chunk Down! Help request
I've read in the newgroup how to bring up the chunk with onspaces (onspaces -s dbspacename -p chunkpath -o chunkoffset -O -y) This helped. Thanks, but how can I test the database integrity? Help is greatly appreciated, Greetings Ditmar…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
NT and KAIO
We are running Informix IDS 7.30.TC2 for Windows NT 4.0 sp3 on a Dell Power Edge 2300 server with 128Meg of Ram. We have a problem with the server receiving KAIO errors and taking chunks off-line. If we reboot the server it seems to work fine, for maybe a couple days, but then …
Effect of disk striping on disk layout
Are you using kaio? (You can check this by running onstat -g ioq - if there are kio vps listed then you are). Neil…
dbspace and the table
How can I identify in which dbaspaces the table is located?…
DBSPACE
Author : T.Jalaludeen E-mail : jala@hpsgm99.sgp.hp.com Hai, I created a database in INFOMRIX 7.23 - HP UX. I created tables also. But later I found thatthe transaction logging has not been turned ON for this database, so droped the database and created using "CREATE DATABASE <d…
Re: DBSPACE
"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the databas…
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…
DBSPACE size
It is possible to create a rootdbspace during instalation larger than 30 Mb ?…
Re: KAIO and 64-bit HP 11.0 again
> today I had a conversation with Alexei Sonkin from Moscow's Informix > support center. I still cannot believe to what he said, namely: > > Informix KAIO on 64-bit HP-UX 11.0 is _absolutely_ no-go area because of: > > 1) there's no performance gain on adequately (he didn't expla…
Rename Dbspaces
Does anyone know of a safe way to rename a dbspace? I can't drop and recreate the dbspace, because it's the "home" for a database, and the database is too large for dbexport/dbimport.…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
RE: KAIO ERROR.
FYI We got the same messages for a 5 minute period on IDS 7.30FC4 about a week back. The event was as follows: 14:55:21 KAIO: out of OS resources, errno = 35, pid = 17890 14:58:33 Checkpoint Completed: duration was 1 seconds. 15:00:42 KAIO: out of OS resources, errno = 3…
KAIO ERROR.
Hello I wondered if you can help me. We currently have Informix 7.1 and in the online log I have got the following error, which has now occured twice, what can I do about it? 08:36:07 KAIO: out of OS resources, errno = 35, pid = 1060 08:36:07 KAIO: out of OS resources, errno …
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
Re: Cached reads too low
>Absolutely agree. What impact KAIO has on caching ? None of course. But see my reply to the previous message in the thread. Neil…
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…
HP, KAIO and statistics. What's wrong ?
On Thu, 18 Mar 1999 16:01:37 GMT, "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: >It used to be a 1-to-1 relationship between CPU VPs and KAIO threads. >Could there be a slight change to the engine architecture to allow a fwe >'extras' out there? I never fully understood why…
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…
Marking a chunk up
Because the chunk was marked down for a reason, usually because of some type of inconsistancy or hardware failure. If the underlying reason for the chunk being marked down is not resolved, then simply marking the chunk up will usually result in data corruption. Kai Shen wrote: …
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…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
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…
kaio problem
hi all: I am using solaris 2.6 with informix 7.22. Sometimes when I submit too many queries, I get the following in the online.log 18:29:44 KAIO: out of OS resources, errno = 11, pid = 933 18:29:48 KAIO: out of OS resources, errno = 11, pid = 931 what does…
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?…
kaio question
hi all: I got a few questions about kaio. 1. how do I know informix is using kaio instead of aiovp? 2. how do I turn kaio on if it is not on? 3. generally how much a performance boost do I get with kaio instead of aiovp? thank you. yan…
Create DBSpace...
Hi folks, We're trying to automatize our database installation throughout hundreds of sites and it is straightforward to use onspaces command to create desired dbspaces. In an NT 4.0 (SP3) box with Informix 7.23 TC1, a 500 MB of dbspace can be created in as long as 20 *MINUTES*.…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
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.…
Re: Urgent!! Question about add chunk
The issue is performance. If you use the block special device, any I/O performed on that chunk will be buffered at the O/S level. Also you may run into recovery problems if you lose power..... Mike Ng wrote in message <367b1d75.0@news1.ibm.net>... >Hi all, > >I have the ques…
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…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
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 …
Re: AIX and KAIO
Thomas J. Girsch wrote: > > In your config file, try setting KAIOOFF=1 > You might also set KAIOON=0 (in addition to setting KAIOOFF). > > Jay Aymond wrote in message <363fa059.1800529@netnews.worldnet.att.net>... > >I would like to benchmark KAIO vs. Informix AIO VP's on AIX. > …
AIX and KAIO
I would like to benchmark KAIO vs. Informix AIO VP's on AIX. How can KAIO be disabled and enabled on AIX 4.2 and Informix 7.24? It seems that setting and unsetting KAIOON does not work. ___________________________________________________________ Jay Aymond EXE Technologies jay…
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…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
KAIO Error
AIX 4.2.1 Informix Online We are regularly getting KAIO errors in the online.log file. *** _aiowrite() returning EAGAIN *** KAIO: out of OS resources, errno = 11 ,pid = 44086 Have tuned the MINSERVERS=130, MAXSERVERS=260 and left Max number of REQUESTS at 4096. Any ideas as t…
Re: Kernel Asynchronous IO on HP-UX
> We're about to move to 7.30UC2 -- I'd be interested if anyone has any > experience with KAIO w/7.30. My experience is approximately a 15% improvement using KAIO, regardless of the version of IDS. Machines include K2xx, D3xx and V2250 and OS's include 10.10, 10.20 and 11.00. …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Re: I/O Q length
Sadagopan, Sathish wrote: > > Hi, > If the I/O queue length is large for a system using KAIO and all raw devices > which parameters need examination ? > ('-g ioq') - The CPU vp queues (for KAIO) are showing large 'maxlen' values. My suggestion? Disable KAIO and return to AIO VP…
I/O Q length
Hi, If the I/O queue length is large for a system using KAIO and all raw devices which parameters need examination ? ('-g ioq') - The CPU vp queues (for KAIO) are showing large 'maxlen' values. TIA Sathish Sadagopan…
Re: AIO vp...
Art S. Kagel wrote: > > SUNIL S. SINGH wrote: > > > > Hi all !!! > > > > I have a little doubt here abt AIO vp. > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > ie performing I/O through operating system, if chunk is UNIX raw device > > and it rel…
Re: AIO vp...
Arun Shastry wrote: > > SUNIL S. SINGH wrote: > > > Hi all !!! > > > > I have a little doubt here abt AIO vp. > > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > > ie performing I/O through operating system, if chunk is UNIX raw device > > and it relie…
Re: AIO vp...
SUNIL S. SINGH wrote: > Hi all !!! > > I have a little doubt here abt AIO vp. > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > ie performing I/O through operating system, if chunk is UNIX raw device > and it relies on AIO vp for performing I/O direct…
Re: AIO vp...
SUNIL S. SINGH wrote: > > Hi all !!! > > I have a little doubt here abt AIO vp. > One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, > ie performing I/O through operating system, if chunk is UNIX raw device > and it relies on AIO vp for performing I/O direc…
Re: AIO vp...
SUNIL S. SINGH wrote in message <6titsg$k81$1@news.xmission.com>... > > >Hi all !!! > >I have a little doubt here abt AIO vp. >One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, >ie performing I/O through operating system, if chunk is UNIX raw device >and i…
AIO vp...
Hi all !!! I have a little doubt here abt AIO vp. One of the informix manual says tht IDS uses kernel AIO (kio) I/o method, ie performing I/O through operating system, if chunk is UNIX raw device and it relies on AIO vp for performing I/O directly if chunk is UNIX cooked file. …
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
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: 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…
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: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
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…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
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…
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…
Bringing up Online on NCR- MP RAS
Dear Folks, I would appreciate any feedback for the following puzzling situation: I have following error when starting Online engine. Informix Online 5.10.UC1 NCR 3000 series with MP-RAS V3.0 Following is the error reported on the screen: tbinit: Fatal error in shared memory…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
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: +…
Problem with kaio
I am having a problem bringing up my database for the first time. I am on a HPUX 10.20 running Informix version 7.20.UC2. I have verified that the asynkdsk driver is loaded and linked into the kernal. I have created the /dev/async node according to the release notes and I contin…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Sizing dbspaces
Does anyone have any recommendation or guidelines we can use in determining a base sizing strategy for rootdbs and physicaldbs. I am most conerned about physicaldbs. I used the formula in the Admin guide to determine a size for physicaldbs but I am not sure if the result was in…
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…
corrupt dbspace
I am running Informix ODS 7.22 on AIX V 4.1. I accidentally removed a file from AIX that Informix ODS had listed as a chunk in a dbspace (that I was about to remove anyway). I don't back the system up since it is our test system. All I want to do is remove the dbspace and all…
Re: chunk down
Thuc Nguyen wrote: > > Hi > > I am running ODS 7.23 on HP 10.20 > > Two chunks have been down as PD from the onstat -d information. > How can I fix them to bring up as PO? Assuming that the problem that caused them to be marked down has been corrected, you can use: onspaces -s …
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
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.…
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
Re: KAIO on HP UX 10.20
Jason Harris wrote in message <34ea2543.1361877556@10.209.30.200>... >Dear All, > >Running 7.23UC6 on HP 10.20 we so far have found KAIO to be slower >than using AIO VPs. I have seen the same with HPUX 10.10 and 7.2x There is a rumour that the implementation of KAIO on HPUX is n…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
Re: Another checkpoint situation
At checkpoint time one page cleaner is assigned to queue up the addresses of modified buffers to the global file descriptors for its assigned chunk. (This assumes that you are not using Kernel IO) It appears that all of your work between the check- point was for one chunk and th…
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…
Re: KAIO
Root (I think I know him!) writes: >Whats the real story on KAIO and HP 10.20. Most posts list better >performance with KAIO. When post report decreased performance it >usually is fixed by correcting the configuration. Is there a split >camp on KAIO?? I personally did a benchmar…
Re: KAIO
rt wrote: > > Whats the real story on KAIO and HP 10.20. Most posts list better > performance with KAIO. When post report decreased performance it > usually is fixed by correcting the configuration. Is there a split > camp on KAIO?? The concensus is that KAIO is better than AIO …
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…
KAIO
Whats the real story on KAIO and HP 10.20. Most posts list better performance with KAIO. When post report decreased performance it usually is fixed by correcting the configuration. Is there a split camp on KAIO?? Thanks…
KAIO on AIX
I just can't get this to work=2E I'm running 7=2E23 and AIX 4=2E2 (bu= t it=20 didn't work on either 7=2E12 or 7=2E22 under AIX 4=2E1=2E5 either)=2E=20= I've done=20 everything in the release notes, but still no KAIO threads=2E Anyone=20 got any ideas? …
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…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Re: AIO vs. KAIO
I thought that KAIO on HPUX10.20 was the ultimate curse from hell for performance! Does that mean the bugs have been cleared up, and it really is a benefit to use now?…
Re: AIO vs. KAIO
Simon Barber wrote: > > > > > I have just swithed from AIO to KAIO on an hp9000 10.20 and saw the > reports > >thatI was using to test run 16% faster. > > > I'm interested in getting KAIO activated on our machines (running hpux > 10.20). Could you list the steps necessary to ena…
Re: AIO vs. KAIO
> > I have just swithed from AIO to KAIO on an hp9000 10.20 and saw the reports >thatI was using to test run 16% faster. > I'm interested in getting KAIO activated on our machines (running hpux 10.20). Could you list the steps necessary to enable KAIO and also if any patches wer…
Re: AIO vs. KAIO
Thomas J. Girsch wrote: > > I understand that KAIO has better performance over AOI when doing > retrieves > > from a database. > > Could someone provide figures, ie how much faster KAIO is over AIO > > That's going to depend largely on platform. From what I understand, on at > …
Can't drop a chunk! Need help!!
I made a mistake about 1 month ago... I created a chunk with an offset of 100000 but the size of 10024. This created a 10 meg dbspace with 100 megs of unusable space!! Nothing is in the second chunk but I can't drop it using onspaces -d rootdbs -p <path>/rootdbs2 -o 100000 I'd …
Re: AIO vs KAIO
David MacAllister wrote: > > Hi Folks! > > I understand that KAIO has better performance over AOI when doing retrieves > from a database. > Could someone provide figures, ie how much faster KAIO is over AIO It is not the improvement for individual queries for KAIO (and there is …
Re: AIO vs. KAIO
> I understand that KAIO has better performance over AOI when doing retrieves > from a database. > Could someone provide figures, ie how much faster KAIO is over AIO That's going to depend largely on platform. From what I understand, on at least one platform (HP), AIO is actual…
AIO vs KAIO
Hi Folks! I understand that KAIO has better performance over AOI when doing retrieves from a database. Could someone provide figures, ie how much faster KAIO is over AIO TIA David…
invalid dbspace
I have been receiving this message for awhile..it hasn't seemed to affect normal functionality...but, I still would love to know what this message means: Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> /d…
Script to convert onstat -d to onspaces commands
#!/bin/sh #=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= # copy_spaces.sh -- A program to convert dbspace/chunk information # available from the [on|tb]stat -d command into onspaces # …
Re: Can't add chunk to dbspace (Grrr!)
Hi! This might well be a bug, I don�'t know. One little trick to figure out how bit the chunk REALLY is, i.e. how big does UNIX think your rawdevice is, is to run a dd from the devive to /dev/null and then looking at the number of copied blocks that dd reports. It's usually …
Re: Can't add chunk to dbspace (Grrr!)
Silly question: What does df -kv report? Steve -- Ignorance can be cured! scooper@thecompounders.com Cosmo Lee <"*N O - S P A M *cosmo"@echonyc.com> wrote in article <34162F6A.260239BB@echonyc.com>... > ODS 7.22, Unixware 2.1.1, Compaq Proliant 1500 > > Can someone tell me if I'…
Can't add chunk to dbspace (Grrr!)
ODS 7.22, Unixware 2.1.1, Compaq Proliant 1500 Can someone tell me if I'm doing something wrong? I am adding a chunk to an existing dbspace. I have a 4GB drive I've divided into 1GB slices. I'm trying to add a 1GB slice to a dbspace, but `onspaces` won't let me do it, telling…
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: question on moving data out of chunk
Mike Orszag <jmo@ricardo.econ.bbk.ac.uk> wrote: > Can I move the TBLSPACE TBLSPACE data out of this chunk (in a cooked > file)? The TBLSPACE TBLSPACE entry contains the TOC entries of this Chunk but no table data. Normally you can delete such an additional chunk. Try it with on…
Re: KAIO perf on HPUX / AIX
We are running KAIO on a AIX and we have not seen any degree in performance because of KAIO. The file-system is almost as fast as using KAIO. We have tested some small OLTP test and some long running bacth jobs. The OLTP test didn't show any deferance, the batch ran 10 to 15 minu…
Informix version 5.03 chunk read error
Dear Informix DBA/Specialists, Has anyone exprienced this errors before on Informix version 5.03.UC1 On-Line running on a Sequent platform. In need some help in diagnosing what is the cause of this problem. Raw disks are being used by Informix here under SVM control and the per…
Informix v5.0.3 chunk read error
Dear Informix DBA/Specialists, Has anyone exprienced this error before on Informix version 5.03.UC1 On-Line running on a Unix platform. "09:18 I/O read() chunk 20, pagenum 60881, pagecnt 4 ---> errno = 1" "09:21:04 I/O write() chunk 45, pagenum 29295, pagecnt 1 --> errno = 4" …
Informix v5.03.UC1 On-Line Error Message
Hello Informix DBAs/Support Specialists, I'm new to this newsgroup so forgive me if this is a FAQ. Has anyone exprienced this error before on Informix version 5.03.UC1 On-Line running on a Unix platform. "09:18 I/O read() chunk 20, pagenum 60881, pagecnt 4 ---> errno = 1" "09:2…
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: I/O read () chunk # Problem
In article <5portk$bqf@cssun.mathcs.emory.edu>, "Croft, Evelyn" <croft.evelyn@dorseylaw.com> writes >Hi David and All, > >Thanks for your response. > >Eve >>How often should the tbcheck be run? HPUX9.04 / >Informix 5.0 Thx. Eve >> >David Williams >> Every night. > >Eve new >…
RE: I/O read () chunk # Problem
Hi David and All, Thanks for your response. Eve >>How often should the tbcheck be run? HPUX9.04 / Informix 5.0 Thx. Eve > David Williams >> Every night. Eve new >> After the crash someone else in our group ran the tbcheck and it took 9 hours. Our full backup is 9 full ta…
Re: I/O read () chunk # Problem
In article <5pi778$kgn@cssun.mathcs.emory.edu>, "Croft, Evelyn" <croft.evelyn@dorseylaw.com> writes >Hello Everyone, > >Can anyone tell me why I would have two chunks go down within a few >hours of one another. I don't see any errno =3D codes. Here are a few >pieces of the log.…
I/O read () chunk # Problem
Hello Everyone, Can anyone tell me why I would have two chunks go down within a few hours of one another. I don't see any errno =3D codes. Here are a few pieces of the log. Problem? Solution? Also how often should the tbcheck be run? HPUX9.04 / Informix 5.0 Thx. Eve 10:0…
Re: kaio
I heard somebody tell me that when you reach about 3000 concurrent users we stop getting any performance improvement. Is this true if yes is there a way around this problem Thanks in advance Ramesh…
Re: kaio
In article <5p9q9o$klf@cssun.mathcs.emory.edu>, Clem Akins <clema@informix.com> writes >Clem pontificates: >>>But I have personally done a benchmark on a large OLTP system on HP and >saw a >>>10% reduction in average transaction time due to changing only KAIO. >>> > >David Willia…
Re: kaio
Clem pontificates: >>But I have personally done a benchmark on a large OLTP system on HP and saw a >>10% reduction in average transaction time due to changing only KAIO. >> David Williams laments: > Why? Since KAIO threads run in the same process as sqlexec threads > (which in…
Re: kaio
In article <5opn7t$ojn@cssun.mathcs.emory.edu>, Clem Akins <clema@informix.com> writes >>I am sure there are people around who's done the comparison on how KAIO >performs >>against AIO VPs. Ten , fifteen per cent faster ? >>I am interested in HP , but any platform will do. > >YM…
Re: kaio
Clem Akins (clema@informix.com) wrote: : >I am sure there are people around who's done the comparison on how KAIO : performs : >against AIO VPs. Ten , fifteen per cent faster ? : >I am interested in HP , but any platform will do. : YMMV! : But I have personally done a benchmar…
Re: kaio
>I am sure there are people around who's done the comparison on how KAIO performs >against AIO VPs. Ten , fifteen per cent faster ? >I am interested in HP , but any platform will do. YMMV! But I have personally done a benchmark on a large OLTP system on HP and saw a 10% reduct…
Re: kaio
Ilya, I've have an HP system that has about a 15% speed degredation when using KAIO instead of AIO VP's. I also have an EMC disk farm, with a 1GB cache on board,so that probably is affecting the mix quite a lot. David >Folks, > >I am sure there are people around who's done th…
kaio
Folks, I am sure there are people around who's done the comparison on how KAIO performs against AIO VPs. Ten , fifteen per cent faster ? I am interested in HP , but any platform will do. Thanks! Ilya…
Re: I/O write () chunk 1
You potentially have a bad disk, there was a posting about this recently. Basically online has attempted to write to the disk and failed. (errno 5). If it is happening repeatedly, then the only suggestion is to get a new disk. The only other suggestion I have, and its just a g…
Re: I/O write () chunk 1
On 2 Jun 1997, Croft, Evelyn wrote: > Hello Everyone, > > Can anyone tell me the cause/meaning of the following problem. Can you tell us what hardware, o/s level, informix product and level that you're running on? > I/O error 'read': expect 2048 actual -1 addr 0x16dc0 errno 5 …
Re: I/O write () chunk 1
In article <5mvavm$jg8@cssun.mathcs.emory.edu>, Croft, Evelyn <croft.evelyn@dorseylaw.com> wrote: >Hello Everyone, > >Can anyone tell me the cause/meaning of the following problem. > >I/O error 'read': expect 2048 actual -1 addr 0x16dc0 errno 5 retrys 0 >I/O error 'read': expect …
I/O write () chunk 1
Hello Everyone, Can anyone tell me the cause/meaning of the following problem. I/O error 'read': expect 2048 actual -1 addr 0x16dc0 errno 5 retrys 0 I/O error 'read': expect 2048 actual -1 addr 0x16dc0 errno 5 retrys 1 I/O error, Primary Chunk '/dev/rootprime' -- offline I/O ()…
error when trying to create a chunk
I am testing Informix Workgroup server 7.20UC2 on sco unix 3.2v5.0. When I use on onspaces to create a new chunk I am getting a file permission error. onspaces -c -d dbs1 -p /j/DATA1 -o 0 -s 500000 Receive error: The chunk '/j/DATA1' must have owner-ID and group-ID set to infor…
KAIO on IRIX
We got INFORMIX and KAIO worked on V7.20. And INFORMIX V2.20 does not work. It is said that we need a special accelerator for database from SGI which costs arms and legs. Anyone out there with this problem and how to go about doing this??? Thanks in advance...…
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Re: Mirroring: Informix or AIX 4.1.5
I prefer using LVM to do the mirroring. Informix mirroring is supposed to split reads into the primary chunk and mirror chunk, therefore distriube I/O load. However more OS's LVMs have this built-in also. If you don't use KAIO, definetly use LVM mirroring. drew wrote in artic…
root dbspace
I have a test machine running Online 7.1. On performing a VERY large query I received an error message saying that there was no free disk space to write sorted rows into a temporary table. On examining the space available in the rootdbs 32252 pages remained out of 575000. I sh…
Dropping a dbspace.
We are trying to drop a bad chunk. The chunk is a cooked file and is the only chunk in that dbspace. When I try to drop the chunk I get the following message. % onspaces -d ch_dbspace1 WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The…
Online: init problem: chunk timestamp invalid
I'm trying to initialize an Online server for the first time. I've set up my raw slices OK, I think. However, when I try to initialize the server with `onmonitor`, I get the following errors written to online.log: warning: chunk timestamps invalid I/O error, primary chu…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
KAIO on HP 10.0 -Reply
John: We are on an HP9000/800 running HP-UX 10.01 and INFORMIX-OnLine Version 7.13.UC1 In $INFORMIXDIR/release/ONLINE_7.1 ... 3. Kernel Asynchronous I/O (KAIO) is supported on this platform. However it is DISABLED by default. To enable KAIO set the environment varia…
KAIO on HP 10.0
Hi everybody, INFORMIX have informed me that KAIO is supported on HPUX 10 and ONLINE version 6 and above.......we're running on HPUX 10 and ONLINE 7.11 UC1. The release notes file ONLINE_7.1 states that Kernel AIO is not supported on this platform. Can anyone confirm what relea…
Re: NUMAIOVPS setting for KAIO
Fred Krefting wrote: > > David Samuels wrote: > > > > ==========Lin-Chuan Lee, 7/29/96========== > > What is recommended setting in general ( assume on platform > > with no KAIO) ?? A Performnace tuning guide I got in class > > states 1x number of disks but I also remeber the in…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
I/O Bad request chunk 3999 Informix 5.0
If you recreated and because it takes for ever to get a good response to fix this. Then I suggest you recreate with a reinit. This means they tapes/files you recreated from are used directly after you do the reinit. Of course you will have to do the dbspace def.... all over. That…
Re: I/O Bad request chunk 3999 Informix 5.0
In article <4oo0dt$3on@sjx-ixn5.ix.netcom.com>, proussel@ix.netcom.com (Pierre Roussel) says: > > >Got the following failure message and try to understand the problem. >The solution given by Informix did not work (unload tables, drop and >recreate database then reload the data). …
I/O Bad request chunk 3999 Informix 5.0
Got the following failure message and try to understand the problem. The solution given by Informix did not work (unload tables, drop and recreate database then reload the data). Problem recurred immediatly after recreating the database. Platform: UNIX SCO 3.2v4.2 Informix engi…
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: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
Re: KAIO problem with Online 7.12 on AIX 4.1.4
In <4joala$8ab@news.eng.octel.com> Thierry Sofia-Gabrion <Thierry.Sofia-Gabrion@octel.com> writes: >I am currently using Online 7.12.UC1 on an AIX 4.1.4 platform. >Because my dbspaces are created with raw device chunks, the I/O's should be >performed by the KAIO threads. Thus, t…
KAIO problem with Online 7.12 on AIX 4.1.4
I am currently using Online 7.12.UC1 on an AIX 4.1.4 platform. Because my dbspaces are created with raw device chunks, the I/O's should be performed by the KAIO threads. Thus, the I/O's should be performed by the CPU VP. However, when I issue the onstat -g glo command, I notice …
Re: I/O error, Primary Chunk offline
adel@q8petroleum.com.kw wrote: : Hi informix 'ers : In the morning I found Informix online 5.0 offline and a message in turbo.log : says : : I/O error 'read': expect 32768 actual -1 addr 0xaad errno 5 retrys 0 : I/O read() chunk 1, pagenum 2733, pagecnt 8 --> errno = 5 : -- Onli…
I/O error, Primary Chunk offline
Hi informix 'ers In the morning I found Informix online 5.0 offline and a message in turbo.log says : I/O error 'read': expect 32768 actual -1 addr 0xaad errno 5 retrys 0 I/O read() chunk 1, pagenum 2733, pagecnt 8 --> errno = 5 -- Online Aborting -- us=301b9c, pid=343, uid=0 IN…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
Re: KAIO clarification.
Bruce Cota (cota@dpg.rnb.com) wrote: : Hello folks, I could use a little clarification about using KAIO under : SOlaris. We are running On-line 7.11 under Solaris 2.4. An informix : engineer told us that we should set NUMAIOVPS to use more than one : AIOVP and this would have …
Re: KAIO clarification.
bruce, : - Everything I have read in the manuals and in Suto's book : indicates that we should not set NUMAIOVPS if we are using : KAIO (Kernel Asynchronous IO). that seems to be true. if you are using kaio, you only need a few aiovps. the kaio's do asynchronous i/o throu…
KAIO clarification.
Hello folks, I could use a little clarification about using KAIO under SOlaris. We are running On-line 7.11 under Solaris 2.4. An informix engineer told us that we should set NUMAIOVPS to use more than one AIOVP and this would have a major impact on performance. However: - E…
Re: Online 5.1, How to remove a chunk
Hi, You have to drop the dbspace in order to free up the chunk and the dbspace has to be empty when you drop it. Thanks Ryan…
Re: Online 5.1, How to remove a chunk
You can't remove a chunk in version 5.x. This is possible in version 7.x. If the chunk is in a non-rootdbs dbspace, you could remove all data from the dbspace, then drop the dbspace to reclaim chunks.…
Re: crashed online
: : Fri Aug 25 11:50:21 1995 : : 11:50:21 Cannot Open Primary Chunk '/dev/informix-1', errno = 6 : : 11:50:21 I/O open() chunk 1, pagenum 0, pagecnt 1 --> errno = 6 : Carol, Hi, errno = 6 --> Have you checked the chunk's owner and mode yet?. It's seem to be informix and 660.…
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?…
I/O bad request
I use 4GL,EC in the INFORMIX on-line 5.0 version. I got the messages from using command "tbstat -m" showd below: RSAM Version 5.00.UC2 -- On-Line -- Up 13 days 12:29:40 -- 5120 Kbytes Message Log File: /home/informix/inf.log pagenum 0, pagecnt 1 14:46:24 I/O bad request chun…
I/O bad request
I use informix on-line 5.0 version in the ICL 6000 machine, and I got the message from "tbstat -m" command that shows below. Does anyone knows what's going on and how to solve this problem. THE PROBLEM MESSAGES shows below: RSAM Version 5.00.UC2 -- On-Line -- Up 13 days…
table usage profile in 6.x 7.x
Folks, Is there any statistics kept within the online 6.x or 7.x system that shows how many I/O operations have been performed on a particular table? The question that I want to answer is to run a benchmark on my application and find out those tables that cause the highest I/O op…
Find names of all databases in a DBSPACE
Is there a way to get a list of all of the databases in a dbspace? My dbspace is very dynamic and I need a way to get this list. Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c David Clough…
dbspace Q
i am looking for any pgms that might help monitor "space hogs". it would be nice to be able to get a listing of databases found under a specific DBSPACE along with its owner and size. i thought i saw a news thread along this topic a few months ago. thanks, jim ________…
Re: Mirroring
Ti Lian Hwang writes: |We have a new HP9000 machine with 2 fast SCSI disks and 2 slower |disks. | |We are using informix mirroring on them. | |Is there advantages or disadvantages if the mirror copies are both |in the in the slow disks, or a mix of slow and fast disks ? | |I mea…
Mirroring
We have a new HP9000 machine with 2 fast SCSI disks and 2 slower disks. We are using informix mirroring on them. Is there advantages or disadvantages if the mirror copies are both in the in the slow disks, or a mix of slow and fast disks ? I mean Disk A (slow) Disk B …
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
dbspace lost
Platform: Everex 486 running Interactive 3.2 and Informix Online 4.00.UE1. Recently, we took a power hit that caused some damage to our file system. Specifically, the device file Informix writes to was lost. Should I reinstall Online or can I just re-create the device file? Al…
Prevent users from creating databases?
Is there any way to prevent users from creating databases? Or at least to prevent them from creating databases in the system dbspace? Or even a way to change the default place for databases from system dbspace to another dbspace? Thanks in advance. -- Rick Hamel Database Admi…
tables in dbspace (Online 5.x)
Is there a simple way to find which tables are in a dbspace? (Or, what dbspace a table is in?) -Brian ------ brena@hcia.com…
Re: Help with Dbspaces & Chunks?
>Date: Thu, 14 Oct 1993 15:40:51 -0500 >From: puleo@Cayman.COM (Michael Puleo) >Subject: Help with Dbspaces & Chunks? >X-Informix-List-Id: <list.2945> > >I have a few questions about dbspaces and chunks. We are running informix >Online 4.00 on a Sun Sparc2. > >dbspaces: > >o Do …
Help with Dbspaces & Chunks?
On Thu, 14 Oct 1993, Michael Puleo wrote: > I have a few questions about dbspaces and chunks. We are running informix > Online 4.00 on a Sun Sparc2. > > dbspaces: > > o Do you need more than one dbspace? No. But informix tells me it's a good idea to seperate your root from oth…
DBspace Question
I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select h…
dbspace for database
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 o…
online log
does anyone know what is the cause of the following message being logged in the online.log: hermes1{root}445# tbstat -m RSAM Version 5.00.UC2 -- On-Line -- Up 20:03:23 -- 54560 Kbytes Message Log File: /usr/informix/online.log pagenum 0, pagecnt 1 11:24:50 Checkpoint Comple…
Default dbspace?
This has probably already been discussed to death, so please reply by e-mail. Is there a way with OnLine v4.0 or v4.1 to make the default dbspace something other than the root dbspace? Thanks. -- +--------------------+-------------------------------------------------------+ |…
Re: Chunk Writes
Intergraph Corporation TIM ============================================================================ E-Mail Memorandum Hi all, Does anyone know what a chunk write is? Does …
Cooked dbspace...
A client of of ours was playing with OnLine, and created a chunk on the cooked file system. When he was done, he decided "Okay, I'm through." and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace inside of OnLine. So now he has a dbspace that OnLine thinks …
Dropping a dbspace
Hello, I am currently using the Informix Turbo engine. I tried to drop a dbspace the other day and couldn't do. Does anybody have info on how to do this? Thanks ! Brian MacWilliams USAMC - SIMA LEAD CHAMBERSBURG PA…