Oninit® Archive
Results for “MIRRORPATH”
Not enough room in ROOT DBspace
Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTNAME ts_datadbs1 …
IBM Informix Standalone Container v2.0.0 - Images not found in cp.icr.io/cp/
I believe I found where the invalid path is being interjected into the resource yaml files. Investing a workaround using an image mirror configuration. ------------------------------ Daniel Weber ------------------------------…
Logical log's and initialize new instance
Hi group, The logic for 6 small log's at initialize a new instance and in root dbspace is : we know that dbspace will be there. A lot of on config values are set to small / starting values to get instance up and initialized. Then set up instance: add new dbspace's / chunks Move …
Extending chunk capacity
Thanks for the follow up John. Just to explain my reasoning for only marking the last chunk in the dbspace for extending: Today with filesystem chunks, I usually set up clients to mark the initial chunk of a dbspace as extendable. Typically most chunks will be allocated in a sing…
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 ------------------------------…
Want to DROP an empty rootdbs chunk
David: From the oncheck output it looks like this is an extended chunk table page mapping your last six chunks. The only way that I know of to clear that would be to drop those six chunks, drop this chunk, then recreate those chunks which will hopefully be able to live on reserve…
Move rootdbs Informix 14
In v14.10.FC6 and later, in addition to redirected restore (as Andreas mentioned) you can use mirroring to move a chunk. Just add the new chunk as a mirror of the current chunk, let it catch up, then use the SQL API function to swap the primary and mirror chunks. At that point yo…
stat() failed for chunk file
HI, Check the chunk files exist. Check the permissions on the chunk files and all folders related to the chunk files. Regards, David. ------------------------------ David Williams ------------------------------…
Undocumented logical log flags
Is it similar to the X flag on onstat –d you see when you add a mirror to a critical space and is only removed after a backup ? Cheers Paul…
ontape error
Hi Paul My reasoning for null'ing the dbspace chunk files is that in the past I have gone around in circles with FULL_DISK_INIT. I note your point however. Perhaps removing the root chunk file on the RSS node and then fallocate'ing to create it afresh might be an option. --------…
Logical Logs/Physical logs
why not just monitor the chunk writes to the phys & logi chunks with onstat -D for a definitive period of time ... should know very quickly.…
Decrease Size of Root Dbspace
IDS 12.10.FC12 IDS 14.10.FC3 (upgrading very soon, so if it can be done in 14 that would be great) Solaris 10 1/13 Consider the following scenario: Many years ago an experimental Informix instance is created. The Oracle S.A.M.E. (Stripe and Mirror Everything) method is adopted, …
Block during checkpoint
Hi, "Since the site is on v12.10 you cannot migrate the data to faster storage without downtime. If the site can be upgraded to v14.10 then the storage can be migrated online using the Informix mirroring feature because v14.10 allows you to switch which of the mirror chunks is pr…
down chunk
Mark, Thanks. Both servers have same settings for mirroring - no mirroring enabled. Still searching. ------------------------------ Mark Collins ------------------------------…
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…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
Moving the logs, or not?
Hello. There are no performance benefits on your case. But, as a best practice, is always recommended, easing administration (you can even use an auto-extendable dbspace for your logs and their chunks). It might be painful to grow your root dbspace, let it simple. My opinion? K…
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…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Creation of another IDS instance
Similar to the existing build. 1. Select a new servername 2. Decide on new storage paths for the new instance 3. Decide on new network port/servicename for the new instance. 4. Add required sqlhosts entries for the new server. 5. Create a new onconfig file check each entry if it…
Moving Instance
What about chunks? Can you move them to a different directory as well?…
Chunk Files
Where is the best place to put the cooked files? In the informix home directory? This is just an Informix server we are using for training and messing around. Is there a best practice type of thing for this?…
Creating a dbspace with a non-default page size
Hi, My environment : IDS 12.10 FC6 with HP-UX 11.31 I'm creating a new instance for a datawarehouse and I want to use the option -k pagesize of the command "onspaces". I want to use the non-default size only for data dbspaces, not for root, logical, physical or temporary dbspac…
Chunk symbolic links
Hi, I have a question about creating chunks with simbolic links: I can't figure it out how it's done. Let's assume that my chunks are on a separate storage. I did ln -s for all chunks to $INFORMIXDIR/storage/chunks but Informx doesn't start after I set the rootpath to $INFORMIXD…
storage pool doubt
Hi and thanks beforehand. Is there a way to split between raws or chunks in the storagepool new chunks added for a dbspace? I dont want all chunks added to be from same disk.…
renaming chunks with ontape?
I would like to replace a drive with a larger drive (with larger chunks). Is it legal to create larger chunks on the new drive, and then use the rename option of ontape to do a cold restore, and use the new and larger chunks, in place of the former chunks? Is it legal to combin…
Adding a chunk
Hi, Is there a problem if I add a cooked chunk to a raw dbspace ? Thanks in advance.…
Database hanging
Hi, I have 60 chunks, one chunk is being write when I launch onstat -D but why the dbaccess mydb hangs, is that logik if there is a slow IO ?…
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 ?…
Dbspace with 2 chunks
Hi, I have a dbspace with 2 chunks. The first chunk is almost full, the second has a lot of space. What will hapen when the first one is completaly full ? Informix will show a 0 on onstad -d command for this chunk ? Enviado desde mi iPhone…
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)…
End chunk mirror on two serves doing er
Hello: Which one is the best way to end chunk mirroring on two database servers? Maybe, end chunk mirror for root space on slave server and them on master server? And end chunk mirror for other space as final stage. Thank you. --001a113ecbee87c9c5052616cb37…
Insufficient space in temporary dbspaces
Hi, >>>> My IDS log is reporting "Insufficient space in temporary dbspaces" and I think I have enough space. IDS: IBM Informix Dynamic Server Version 12.10.FC5WE Platform: CentOS release 6.6 Spaces: | [informix@lpsalxids ~]$ onstat -d | | IBM Informix Dynamic Server Version 12.…
Offline a chunk
Hi, How to offline a user space/chunk created. I have tried, onspaces -s testDB1 -p /tmp/testDB1 -o 0 -D. But no use. Flags still shows it online. 45ff1028 13 13 0 1046575 1044760 PO-B-D /tmp/testDB1 I am checking restore scenario using onbar.…
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…
Dropping a chunk
Hi, Recently I added the ldatadbs02 chunk to the dbsdata01 dbspace, but now I like to drop the chunk in this way: onspaces -d dbsdata01 -p /opt/informix/data/ldatadbs02 What am I doing wrong? Thanks in advance. Enviado desde mi iPhone…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Chunk Size
Hi we are running 11.70.FC7 on Solaris 10 and we just got new storage for our database. For the first time our storage admin asked what size chunks we want for our raw DB storage. HIstorically we have always had 2 GB chunks. Any suggestions on a good chunk size for an OLTP system…
Chunk Size
Hello Group, Do you have a recommendation on what to set the raw chunk size? Currently we are using raw devices and are split into 2GB chunks. Our storage admins would prefer to give us larger chunk sizes for future disk allocation and want us to recommend a chunk size. Is there…
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…
Performance impact with different page size
Hi, I am using informix 11.5 on Solaris and the database storage structure as one datadbs is with 16K page size second datadbs is with 4k page size and third datadbs is with 2k page size while log dbspace ,root dbspace and physical log dbspace is with 2k page size . My question …
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
server migration from windows to linuxu
hello: my doubt is about chunks. can i copy chunk files from windows to linux? can linux manage right chunk files from windows? my doubt is about to export data fully with two informix v11.7 from windows 2008 64b to linux 64b. thank you and regards. --047d7bb04cf2188a3904d02c…
Adding chunks ISAM error 137
Chunk table overflows are virtually impossible to occur in v11 unless you have over 32k plus something chunks allocated. Sounds to me like there is some corruption in the Informix reserved pages , run on oncheck -cr to see if all your chunks are listed/any errors reported and che…
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,…
LRU Queues - more or less
onstat -F shows 0 LRU Writes 8314165 Chunk Writes…
reduce size of root dbspace
How to reduce size of root dbspace in Informix 11.7 ? Currently I have moved logical logs, physical logs, databases, temporary dbspace all out of root space. Currently only 6% of my root dbspace is used after importing required databases and there is slim chance that the database…
Mirroring ?
We currently use hardware mirroring ... IDS 11.50xc5 and idx 11.70.fc3xc ... Aix 5.3, 6.1 and 7.1. Our Unix guys are looking to get rid of the HW mirroring .. and go to OS level mirroring ... Mirrored disks will be offsite, actually same disks that are the current HW mirror... Do…
IDS 7.31 UD5 data(base) recovery
Hello Marcin, when i read this: > # ontape -a > Performing automatic backup of logical logs. > Please mount tape 1 on /usr/informix/ltapedev and press Return to it sounds like that your LTAPEDEV is set to /usr/informix/ltapedev in your onconfig file. if that ist the case you …
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 …
how to get all the instance's chunks free space
I created several informix server on a host. To monitor each server's chunk space,I have to setup environment parameter then run 'onstat -d' to check the chunk's free space. Anyone can write a shell script that get all informix server's information ( like 'onstat -g dis' do) and…
11.5 UC7E crashes
Hello Joerg, production and test systems are identical. Linux-Version: Linux tefix 2.6.26-2-686-bigmem #1 SMP Fri Aug 14 01:52:30 UTC 2009 i686 GNU/Linux Linux version 2.6.26-2-686-bigmem (Debian 2.6.26-17lenny2) (dannf@debian.org) (gcc version 4.1.3 20080704 (prerelease) (Debi…
Archive Behavior Change???
First confirm to see if dbspace r1 was actually backed up during the prior level 0 by checking both the online msg log and the onbar activity file I recall that the engine confirms the time stamp of the most recent level 0 from the dbspace root reserved page. So something could …
oninit: Not enough room in ROOT DBspace.
Requested 9661038K, ONCONFIG value 'ROOTSIZE' 2097152K. using onspaces -c rootdbs -p /database/chunk03 -o 0 -s 2097152 onconfig has ROOTNAME rootdbs # Root dbspace name ROOTPATH /database/chunk03 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace i…
Onbar's Handling of "Empty" Chunks
How does onbar handle "empty" chunk files during backup and (especially) restore? Is it intelligent enough to determine that a chunk contains no data at all and can be handled differently (perhaps more efficiently?) than one that contains user data? Or is this an irrelevant co…
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…
stupid question time
Informix 11.50.FC6 on HP-UX 11.31 ia64 (Integrity server) BL870c I have a nightly cron job that run Jacob Salomon's monitor-space script to check how full dbspaces are. Well this morning I got a report that root is 91% full. Root dbspace has one 2GB chuck. Since it has been ove…
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.…
rootdbs mirror
Hello, We are running Informix 11.50.FC4 on HPUX 11.23. The instance was initialized without the rootdbs mirrored. Can I use onspaces -m to add a mirror chunk for rootdbs and other critical dbspaces after instance initialization? I seem to remember in older releases you needed t…
Recovering database from dbspaces
Hi, I have dbspaces(root, data and log) of an instance. I want to recover the database from these physical files on some other machine having same OS and hardware. Is there any way to get it done? Thanks, Anees…
need to know when was a dbspace went down.
Hi All, I would like to know when my dbspace went down... I didn't find from the log... is there a way i can find from the systables? 70dc0318 10 10 0 524287 0 PD-- /chunks/chunks024_device0000 70dc0498 11 10 0 524287 0 PD-- /chunks/chunks024_dat0102 70dc0918 14 13 0 512048 0 P…
Changing physical log size in non-rootdbs
Found the answer by doing. FYI... Take IDS 11.5 to admin mode (quiescent)using onmode -j. Use onparams -p to move log from its non-root-dbspace to another dbspace (where there is enough room for a physical log of the same size). Run fake archive. Drop the dbspace where the ph…
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…
oninit -ivy error Warning: stat() failed for chunk
Please verify that all the directories in the rootpath are tranversable (x) by user informix. Regards. On Sat, Nov 27, 2010 at 3:52 PM, BILL MARSHALL <cwm@stober.com> wrote: > I have just installed informix 11.5.FC5 on a red hat enterprise 5 (64 bit) > machine that is currentl…
Cannot open chunk ''
The errno - 2 says there is a chunk that does not exist. Try oncheck -pr. It will either point you to which onw it is or fail if it is the 1st chunk.…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
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…
Re: mirroring - pros & cons
On May 12, 9:50 am, Art Kagel <art.ka...@gmail.com> wrote: > What is the underlying disk structure? If the chunks are mirrored (say > RAID1 or RAID10) on disk then the Informix mirrors are redundant and are > costing you throughput. If on the other hand, your disks are not mirr…
mirroring - pros & cons
We have mirrored db spaces on our production OLTP system - rootdbs, physical log dbs and logical logs dbs. I can see the value for doing this on rootdbs but am unsure of the other two so much. The reason our system is as such is more out of years of habit from past DBA's, sysadmi…
How to calculate page size + chksize into bytes, m
chknum smallint Chunk number dbsnum smallint Dbspace number nxchknum smallint Number of the next chunk in this dbspace chksize integer Number of pages in this chunk offset integer Page offset of the chunk in its device or path pagesize integer Page size (in units…
onbar restore hanging
Hi, Do onstat -g iof moving or not on individual chunks? rgds schillache…
Re: On Dropping chunks
Reorg the tables in this dbspace so that all of the free space is in the last chunk which should not have any TABLESPACE entries in it. Then you can drop the last chunk and add it to the other dbspace. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board o…
On Dropping chunks
Hi there. I have the following question. Can I drop a chunk which is not the initial for dbspace, but it's not the last one either? Because I am in this situation: the second of three chunks on the same dbspace is empty according with Server Studio, but with TBLSpace entries …
Re: Informix Mirroring
eherber wrote: > On 3 Feb., 19:04, Dave <in4mix...@gmail.com> wrote: >> Hello, >> >> I was reading up on Informix Disk/Chunk Mirroring and was wondering if >> anyone has any experience using Informix mirroring versus O/S or >> Hardware mirroring relating to performance? >> >> Als…
Re: Informix Mirroring
Thank you both Art and Eric for your input on informix Mirroring. have a great day. --Dave On Wed, Feb 3, 2010 at 3:57 PM, Art Kagel <art.kagel@gmail.com> wrote: > On performance, Informix's testing back in the 90's showed that > hardware/firmware mirroring was fastest follow…
Informix Mirroring
Hello, I was reading up on Informix Disk/Chunk Mirroring and was wondering if anyone has any experience using Informix mirroring versus O/S or Hardware mirroring relating to performance? Also, is this a typo in the Informix documentation for mirroring? See the sentences, "On t…
chunk offline
Hi All, We had a situation were a non-critical chunk went offline. This was a cluster setup and during some testing/disk alignment by Unix, this chunk went offline. It was marked PD. This chunk contains only a portion of one Index.( Checked before using oncheck –pe ). Used onspa…
is possible multiple instances with the same dbspace?
Hello, I have 5 different servers replicating in other server. I would like to have only this root server and other instances running together and sharing the root dbspace. I can run different instances with differents dbspaces, but i would like not to duplicate data. Is it p…
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??…
Re: Large chunks versus small chunks.
> > I'll see if I can rustle up the disk testing tools because it would be > interesting to see the results from contemporary machines or arrays. I can't find my stuff - stupidly entrusted it to a geocities hosted web page which has been absorbed by Yahoo and now thrown away. H…
Large chunks versus small chunks.
All, I would like gauge opinion on whether or not it is better, worse or does not matter if you use fewer larger chunks or more smaller chunks. I am trying to find out if you have any experiences or better still evidence that chunk size matters. I not over concerned about the am…
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…
Raw devices softlink to dbspaces were lost
You can also try to run oncheck -pr - there will be a section that shows all of your chunks and chunk paths.…
Removing and adding disks to a mirrorred system
I am a bit rusty on Informix mirroring because I only use hardware mirroring. And speaking of that, each SAN is RAID 5! So, after reading the "fine" manuals, I would probably shut down that one SAN, do the maintenance, and then re-mirror (informix mirror) from scratch. Others …
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…
what is the 0x40000 meaning
0x040000 means Blobspace contains Big Chunks…
Re: Moving dbspaces to larger chunks
Hi Kagel, Is it possible to move/migrate rootdbs(root chunks) also from small chunk to large chunk? rgds schillache…
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
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 …
Informix page cleaners (w/ a SAN)
James, are you experiencing any issues, long checkpoints maybe? You have 90ish chunks and 128 CLEANERS. During checkpoint each cleaner gets assigned to one chunk (in the order of chunk creation) so you're on the safe side there, the extra cleaners should just idle. Regards Dav…
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 ?…
Help : Assertion Failure Type: CRASH
I've start with oninit -r and then launch oncheck but got this : ISAM error: Primary and Mirror chunks are bad…
ibm and data mirror
hello all does anyone know if data mirror now incorporates informix as both source and target? thanks…
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…
Re: Rename "demo_on" db server and create new db server?
On 5 Mrz., 16:31, epsilon <cesm...@gmail.com> wrote: > All: > > We use Informix where I work and I have built a virtual Debian server > to become more acquainted with the database. My question is how do I > rename the "demo_on" server and also create a new db server on the > sam…
Re: Rename "demo_on" db server and create new db server?
the changes you have to make are: in $INFORMIXDIR/etc/$ONCONFIG: change DBSERVERNAME demo_on to DBSERVERNAME yournewserver $INFORMIXDIR/etc/$INFORMIXSQLHOSTS when set or $INFORMIXDIR/etc/ sqlhosts change demo_on onipcshm vm-debian-4 demo_on to yournewserver…
Rename "demo_on" db server and create new db server?
All: We use Informix where I work and I have built a virtual Debian server to become more acquainted with the database. My question is how do I rename the "demo_on" server and also create a new db server on the same box. I have read through the documentation but have not found…
Smoke and mirrors...
So far, in responding to the king of wankers, we have found out a couple of things. 1) Confirmation that Janet Perna did actually leave IBM 2) No one can confirm any numbers from IBM and the numbers in Jerry K's slides were taken out of context and therefore hold no real value a…
ER Error Enterprise Replication
bozon wrote: > Enterprise Replication is giving the following message when I do a > simple cdr list server > > ndl12:ndl12a common_reporting$ cdr list server > SERVER ID STATE STATUS QUEUE CONNECTION > CHANGED > --------------------------------------------…
rename chunk's
Hi all: I need to change the PATH of all my chunks in my body. For this I must do the following: 1. backup online full: $ ontape-s-L 0 2. rename file to create chunks: -- sintaxis: old_chunk old_offset new_chunk new_offset archivo_rename.txt: / usr/informix/devices/chunk1 0 …
How can I resize a chunk?
Hello, is it possible to resize a chunk? I know i can do it the long way by exporting the data, drop tables, drop the chunks, create new chunks of smaller size, recreate dropped schema, import data. However this is a very long, convoluted and error prone process. So does anyone …
Re: Smoke and mirrors...
DA Morgan said: > Obnoxio The Clown wrote: >> DA Morgan said: >>> Obnoxio The Clown wrote: >>>> DA Morgan said: >>>>> Serge Rielau wrote: >>>>>> Da Moron wrote: >>>>>>> One logical (potentially physical) I/O to undo. >>>>>>> Commit. >>>>>>> One physical write to the log file. >>>…
Smoke and mirrors...
While some IBM insiders are saying that "things are changing but we can't really talk about it...", here's a simple fact. IBM on 9/15 released two new benchmarks. A TPC-C and TPC-E on their new(er) hardware and Microsoft SQL Server. Seems that no one from IM Is trying to get th…
slow views on IDS 11.50FC1
Hi, changing from 10.00FC4 to 11.50FC1 causes a "select * from view_XXX" to run more than 2 hours. On 10.00FC4 this select took not more than 10 minutes.An unload directly from the tables with the same select statement doesn't take more than 10 minutes on 11.50FC1 The reason to u…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Re: Long checkpoints
On Sep 10, 4:47 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > askel wrote: > > Hello there, > > > I've been reading about long checkpoints issue for a while but haven't > > found solution for our case. > > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fir…
Long checkpoints
askel wrote: > Hello there, > > I've been reading about long checkpoints issue for a while but haven't > found solution for our case. > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fire V1280 > with 8 UltraSPARC-III+ 1.2 GHz and 16 Gb of RAM on board. The database …
Re: Copy Informix Chunks using dd ?
> Jarrod, > How can I change the status of Mirror chunk as Primary > chunk ? > -- D mirror the whole dbspace in question. bring down the chunk you want to move using onspaces.(primary) relink the chunk to be moved to a new unused raw device.(make sure permissions are o…
Migration to a new storage
My chunks on RAW-devices.…
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…
Analysis of activities during checkpoint.
"If you are using a few large chunks instead of a larger number of smaller chunks, you will have only one flush thread per chunk running at checkpoint time. More chunks means more flush threads means less time to flush." Dang, is this still true as of 10? We may have caused our …
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.…
understanding oncheck -pp
Yes, chunks can be shared by multiple instance on same machine. I tested that IDS supports it. My machine is on local disk and there is no chunk sharing. Thanks to you and apologies to Art. vartika.…
chunk is down
My box is aix 5.3 , ids 10 FC3R1. I start my ids and run 'onstat -d' 700000031d801c8 14 10 0 512000 0 PD-B /dev/ rtmpdb1 tmp dbspace is down. $ ls -l /dev/rmptdb1 crw-rw---- 1 informix informix 10, 20 Feb 25 13:39 /dev/rtmpdb1 owner , group name…
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…
ontape -s using too much temp space
I'm running IDS 11.10.HC2 on an hp-ux 11i machine. We just upgraded from 9.40 3+ weeks ago. Previously, we had no problem running level 1 backups during the day. However, now I am noticing that my temp dbspace will sometimes fill up during the level 1 backup. I just aborted the b…
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!…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
Re: Moving a chunk - a related question
On Nov 28, 8:28 am, "Rosie Rhodes" <rosem...@spider-networks.net> wrote: > Hi, > I'd like to ask a question about this method (at the risk of appearing > dim) - but in relation to having a broken disk affecting a primary chunk of > a mirrored pair. You're working too hard. If a…
Moving a chunk from one logical Volume group to another.
If not too many chunks and MIRROR is enabled... enable mirroring for the dbspace. bring down the chunk you want to move using onspaces. relink the chunk you want to move to the new device. bring online the chunk using onspaces. then remove mirror using onspaces.... (hopefully y…
Re: Strange error when initialising (long)
i guess file /informix/data/ returns a directory oninit: Cannot open chunk '/informix/data/'. errno = 21 > ROOTPATH /informix/data # Path for device containing root dbspace -----------------------------------------^^^^^^ should be a file or better a char mode raw dev …
Chunk not dropped. ISAM error: No such chunk
I've performed this drop chunk command and process several times in the past, but this time I'm receiving an error. Do you see anything wrong or is there a bug. Hopefully the chunk will still be written to once the main chunk is full: IBM Informix Dynamic Server Version 7.31.UD8…
restore a single table from tape
Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and de…
Informix on iSCSI
That is, having the chunks on an iSCSI device. Any thoughts?…
HDR - Adding chunks
You need to add chunk only on primary. But make sure that the chunk path exists on machine where secondary reside. For better performance you should also grow the file on secondary to required size before adding chunk on primary.…
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
shared memory not initialized
Please try disable randomization of the virtual address space. On CentOS and RedHat 5 this can be done for a new shell: setarch i686 -R sh or setarch i686 -R -L sh from which IDS can be started. On some CentOS and RHEL5 systems users reported shared libraries are loaded near…
oninit -i failure
Found the problem I had $ONCONFIG=/opt/informix/etc/onconfig. Should have been $ONCONFIG=onconfig On Aug 8, 2:03 am, tom.pri...@gmail.com wrote: > I'm trying to startup informix for the first time on a CentOS 4.5 > server. When I run oninit -i , I get the following error: > > …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
chunks overlapping?
Yesterday our system went down with the log file showing this below: quote 16:18:33 Informix Dynamic Server Version 7.30.UC6 Software Serial Number AAC# J540938 16:18:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 16:18:35 Physical Recovery Started. 1…
renaming a chunk
Hi, We are using IDS10.0FC5 We would like to rename a chunk to satisfy a link checking script that we have running on startup. It seems that the recommended ( apparently only available ) way is to do a rename during restore. That is not an option for us. I was wondering if it wo…
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…
Adding new chunk/free up used chunk
Hi, I am currently having a table that is stored in rootdbs and it almost used up all the available pages inside that space. So I decided to add a new chunk to it but it was unsuccessful. The error given is: Cannot add a new chunk to the DBspace. ISAM error: no free disk space …
Adding a Chunk
I was wondering, when you add a chunk to a dbspace that is already using part of the raw device and need to specify an offset is the offset expressed in pages or kilobytes? Thanks…
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…
Files in /tmp
Hi, Could it be something like temporary sort-work-files ? No place anymore in temp dbspace so files are created in /tmp ? Do you have DBTEMP and PSORT_DBTEMP variables set ? Jacques Lapeire -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] …
Error while access Tables using Crystal Reports
i would look in: C:\\tmp\\af.414fe6c which has more info. also phone tech support. it sounds like the optimizer barfed on something. an example could be that npused on the partition page of the accessed tables ended up being negative or???? this may cause bad stats. you could t…
Primary/Mirror Issues
Hi all, Someone please advice me, when i drop a table from the primary chunk, or delete data inside tables from the primary chunk, will the tables or data get restored back automatically from the mirror chunks? What about if i drop a dbspace from the primary chunk, will this ag…
Clarification (Primary/Mirror chuncks)
It will automagically re-synch. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of PAUL GATHOGO Sent: Monday, February 05, 2007 1:38 AM To: ids@iiug.org Subject: Clarification (Primary/Mirror chuncks) [8345] Hi all, Can someone …
oninit startup failure
Is this the first time you've tried initializing after installation or is this an existing instance which has just stopped working? How much physical memory on this machine? Disk space ok? What is the exact IDS 10 version? Are you running this directly or via Remote Desktop or s…
size of rootdbs
On 30 Nov 2006 01:26:14 -0800, doitman <sunil.saggar@gmail.com> wrote: > Hi all, > > What should be the size of rootdbs .I mean the optimum size. > How does the size of rootdbs affect the IDS performance? > It is takijng a lot of time to initialize ..Is it normal(as per my > con…
Re: suggestion reqd Perf tuning
is there any more suggestions? Please post your view. regards madhu darko wrote: > madh wrote: > > this my onconfig file. I am using Informix Dynamic Server Version > > 7.31.UD6W4, HP-UX 11.11 , > > no of cpus- 2, REPORT SERVER (used for creating report purposes). > > Memory 1…
Re: suggestion reqd Perf tuning
madh wrote: > this my onconfig file. I am using Informix Dynamic Server Version > 7.31.UD6W4, HP-UX 11.11 , > no of cpus- 2, REPORT SERVER (used for creating report purposes). > Memory 1387036K(1260472k) real, 1847708K (1682688k), virtual 4262876k > free pages, > Just want see so…
Performance tuning suggestions needed
You want performance tuning suggestions, is there a particular problem you are trying to solve or do you just want it to "go faster"? if so, is there any more bandwidth available on the machine? Also, I note you want it to go fast but you don't appear to care if it all goes wr…
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…
Informix
Hi, for restore you don't need to start or initialize the instance, i.e. you don't need to do "oninit -i". The only thing you need to do is to make sure that the devices or files exist where the chunks will be located . Of course there also needs to be enough space on the devic…
Re: Backup Very Slow
I suggest you to check the contention level of your database first. Your configuration shows that you put everything in rootdb DBspace. This is not a wise move, espeically you have a lot concurrent users online all the time. It's difficult to prevent users from accessing the sa…
Re: Backup Very Slow
Prior to moving to a data center (few months back) my backups were to Ultrium 3's. I could backup 330 gigs in 2 hrs (HP 11.11 IDS 9.40 ,7420). Before the move to Ultriums I was using DLT 320's with the backup taking 5+ hrs. Thanks "DORN B" <varadorn@…
Re: Backup Very Slow
Use onstat -V to discover exactly which version of 7.31 you are using. You may be hitting bug 101062 - Archiving very Old Pages. If so there is a simple fix, but the exact version needs to be identified first. Keith On 05/09/06, DORN B <varadorn@gmail.com> wrote: > Another way …
Backup Very Slow
PapaKiKi wrote: > have Informix IDS 7.3 on an Rp4440 server with UNIX 11.0 I am using > DLT Tape drives and 80gig tapes to do my back up on a 98gig database. > My problem is that a level 0 backup takes 24hrs to finish. Using > ontape . I need to reduce the time.My database has …
Re: tblspace tblspace extent size calculation for
You'll need one page for each table or index fragment in a dbspace. So, if you can guestimate how many tables/indexes/fragments you will ultimately have you can figure it out fairly precisely. Otherwise, ... Art S. Kagel ----- Original Message ----- From: Peter J Diaz De Leon <i…
tblspace tblspace extent size calculation for IDS
Does there exist calculations (or rules of thumb) for determining what the initial and next tblspace tblspace extent sizes should be for both the Root dbspace and non-Root dbspaces. Thanks Peter…
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…
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…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
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…
ONCONFIG and AIX
Also in SMITTY -> Devices -> Asynchronous I/O -> Asynchronous I/O (Legacy) ->Change / Show Characteristics of Asynchronous I/O Change / Show Characteristics of Asynchronous I/O Type or select values in entry fields. Press Enter AFTER making all desired changes. …
Re: Upgrading server - Do i need to change config ?
F. LACROIX je napisao: > "Neil Truby" <neil.truby@ardenta.com> a écrit dans le message de news: > 4i96mgF2jfl9U1@individual.net... > > "F. LACROIX" <soft @ datacolfrance.com> wrote in message > > news:44bf5959$0$891$ba4acef3@news.orange.fr... > >> Hello, > >> > >> I was running I…
Re: Upgrading server - Do i need to change config ?
Could try that if i can persuade my manager to upgrade the os. Many thanks "Jean Georges Perrin" <jgp@iiug.org> a �crit dans le message de news: mailman.35.1153412200.20706.informix-list@iiug.org... > > You may consider XP (not 2K3) instead of Win2K. I got better result with > …
Upgrading server - Do i need to change config ?
You may consider XP (not 2K3) instead of Win2K. I got better result with it, however, I am not sure 7.31 is running on XP (> 9.4 does). > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of F. LACROIX > Sent: …
RE: HDR problem with Windows
Some minor comments: > ROOTPATH D:\\IFMXDATA\\ol_server1\\rootdbs_dat.000 You've moved the root dbspace to D:\\IFMXDATA\\ol_server1 on ol_server2 as well right? > NUMAIOVPS 4 # Number of IO vps Not relevant to your problem, but this seems a bit high on Windows…
cant bring database after os sync from other serve
Hi David, The sync is thru disk mirroring (EMC)…
Re: Reducing checkpoints
hope NO RAID 5 NO RAID 5 NO RAID 5 for starters: CKPTINTVL 360 # Check point interval (in sec) i would set it much bigger so you get a checkpoint each half hour be aware that fast recovery may take longer in case of a crash. also i assume that > PHYSFILE …
RE: Reducing checkpoints
Have you got KAIO turned on? How many dbspaces/chunks/disks have you got? Are your chunks cooked or raw? onstat -d Keith -> -----Original Message----- -> From: PapaKiKi [mailto:agwanzura@okzim.co.zw] -> Sent: Monday, June 19, 2006 9:13 PM -> To: informix-list@iiug.org -> Subjec…
Reducing checkpoints
Post the results of onstat -a onstat -g iov please. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "PapaKiKi" <agwanzura@okzim.co.zw> wrote in message news:1150748005.559…
Informix mirroring
We have an Informix 7.31.UD6 database running on HPUX 11.11i. For various reasons, the parituclar machine that this database runs on has had quit a few issues with failing hard drives. Our database use software raid for some HPUX volumes and Informix mirroring for the database. I…
A question about informix 7.31.UD6 Mirroring
from the online docs : Recovering a Mirror Chunk To begin mirroring the data in the chunk that is online, you must recover the down chunk. http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.admin.doc/admin615.htm#sii-20umirr-19632…
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/…
Chunk space
Hi, Sorry for my poor english. And yes, im newbie width informix. I run this: copy nul filechunck.000 onspaces -c -d namedbs -p c:\\infxData\\infxserver\\filechunk.000 -o 0 -s 2000000 .... and all is ok. But when ... oncheck -pe ... Chunk Pathname …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
RE: move data to new disk
That mean config the Raid 1+0(100GB). And mirror the data from 9G to that 100GB HD? Use the Solaris volume manager to mirror or another method? Please advice. Thank you…
Performance tuning: troubling long checkpoints and other issues
OPTCOMPIND 2 # To hint the optimizer for oltp do not set it to 2 set it to 0 instead!!! Superboer. Jim Kenedy wrote: > Hello All, > Here's some quick history... Recently the number of users has > increased to over 500 sessions. All our users are now comp…
drop a chunk in v10
I understand that enhancements have been made to V10 so that you can control the tblspace tblspace and thereby reduce some of the situations which lead to not being able to drop a chunk. But is that all situations? What about if some extents of one of the system catalog tables …
Re: Performance issues on HP-UX
Mike Peters said: > > We are currently suffering performance problems with our Informix > server running on HP-UX. The server appears to be paging heavily with > sar -q showing %swpocc running at or close to 100. > > The server is an HP 9000/800 with 1Gb RAM, running: > IBM Infor…
Optimizing a BaaN installation
Jaime Casanova wrote: > Hi, > > i'm just starting in an enterprise that has BaaN IV c with the > following specifications: > > Server: > 3 RAID5 (with 4 disks each one) > 4 processors > 4Gb Ram > > OS: NT4 > > DataBase: Informix 9.2x (i don't remeber the exact number right now :)…
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.…
dbspaces/tempspace shows up with a "B" flag
The database server has been enabled to use chunks >2Gb. These dbspaces probably use large chunks (greater than 2Gb).…
Chunk Not empty
Hi, I am trying to drop a dbspace (named conversion). That dbspace originally was consisted from 10 chunks (conv_dat.000 to conv_dat.009). I have dropped successfully up to conv_dat.005 chunk. When I try to drop conv_dat.004 chunk (using the onspaces -d conversion -p E:\\\\IFMX…
Re: ipload hangs
Possibility for errno = 36 in online log could be an operating system error message OR the database server exited without shutting down properly OR a chunk(s) down. Run oncheck -pr and check the chunk reserved page to determine if any chunk is down. Hari…
Relocate Informix database from Raw slices to filesystem
Mirroring ..? Can you clarify what you mean...? At what level..? 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…
Using Topio with IDS
By itself it is not since Informix requires disk writes to different chunks to occur in a certain order. E.g. physical log pages must be written before data pages. When the software says the write has made it to the disk it may not actually be on the physical media. However thi…
Re: chunk reserve page extent
A minor correction... Basically, the reversion routines take care of putting the extents back into the root chunk when you are reverting to a system that doesnt understand chunk reserve pages not on the root chunk of the root dbspace. So, there is no issue during reversion. If t…
Re: chunk reserve page extent
On 9/14/05, Rastislav Janac <rastislav.janac@dignitas.sk> wrote: > > I intuitively understand what this message in online.log means, > <>11:02:56 chunk reserve page extent is allocated from non-root chunk: > (51:13292,42) > 11:02:56 chunk reserve page extent is allocated from non…
Re: Informix/TSM Point In Time Restore
Not sure... but doesn't informix need to ensure the whole instance is consistent? Therefore it'll need to recover all dbspaces to the same point-in-time. Is "time1" in the past? That may not work. After the physical resotore, can you apply logical recovery to just those dbspa…
Chunks down
Hi, I have a dbspace named calms13_dbs and a number of chunks in that. SOme of which have become down with status PD. I have 3 databases in that dbspace .I have some questions here. 1. How can i know reason for the chunks going down? 2. When i drop the database in that dbspace, …
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
Re: ontape vs onbar
"Superboer" <superboer7@planet.nl> wrote in message news:1123830503.185843.157390@g49g2000cwa.googlegroups.com... > -->Root, log log, phys log (3 x temp), one large application dbspace. > > i would create more dbspaces... one big dbspace will not be done in > paralel. Thanks. I…
Re: Config for OLTP system
Neil Truby wrote: > IDS 10.0 v3 on Solaris 9. > > I'd be grateful for any comments on this OLTP system onconfig about to go > live on a SunFire v480 with 2 processors and 8GBytes of RAM. I have only 6 > extrenal disks fo the 60GByte database server. I've striped the database > …
RE: Config for OLTP system
Neil, You are using /usr/informix and /opt/informix PA_PAGES and RA_THRESHOLD are blank Is 1Mb logs big enough, I use 100Mb and we can fill a log in <15 mins when busy, you won't need 819 of them if you make them bigger LTAPEBLK = 32 are you sure? seems a tad small to me SHM…
RE: Config for OLTP system
> -----Original Message----- > From: Bill Dare > Sent: Thursday, August 11, 2005 8:44 AM > To: 'Neil Truby'; informix-list@iiug.org > Subject: RE: Config for OLTP system > > BUFFERPOOL > size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=1 > 0.000000 > Maybe spe…
RE: Config for OLTP system
BUFFERPOOL size=2K,buffers=1024000,lrus=33,lru_min_dirty=2.000000,lru_max_dirty=10. 000000 Maybe spending too much time flushing 8% of the LRUs when LRU writes kick in? Might try lowering lru_max_dirty. Shorter checkpoints and your LRU writes should be spread more evenly over t…
Re: Change chunk name
on 7.31? thought you could only drop chunks on 9?…
Change chunk name
not really no. At minimum, assuming its not a critical dbspace 9root, physlog or loglogs) the you'd need to 1/ unload all the data from the dbspace 2/ drop the dbspace 3/ recreate the dbspace and all its chunks using the new patch fo rthe chunk 4/ reload all the data sorry…
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…
One Chunk vs. Many Chunks
Hello All We finally upgraded from 9.21 to 9.40. We are planning to add two 50 GB dbspaces to an instance. There are already many dbspaces in this instance and most are around 50 to 60 GB. One dbspace is 256 GB and we are trying to rearrange the data so we can reduce the size of…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
ONCONFIG comments
Can you post the output from onstat -g iov please. "Bono Vox" <in4mixperu@hotmail.com> wrote in message news:1115714331.fe81cde2ee8f8402d2a791d65e041327@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my co…
Re: Server won't initialize
Hi, setting SHMBASE to 0 certainly will not help. This is valid on HP-UX, but not other platforms. Check the "Machine Specific Notes" in "$INFORMIXDIR/release/en_us/0333/" directory for the recommended setting of SHMBASE for your platform. A letter "L" or "l" (for long) added t…
Server won't initialize
What is SHMBASE set to? Try setting it to "0" "Steven Weiss" <sweiss@iafrica.com> wrote in message news:d4ae07$b0l$1@ctb-nnrp2.saix.net... > > Hi, > > We seem to have a problem getting the server to initialize. We get an > error > shmat: [ENOMEM][12]: out of available data spac…
Re: Re: Need help!! Sql to Informix Migration
Your onconfig shows that you are using the default informix configuration... if it is so then some work to do because the default instance the installer configures is just for testing purposes *** not for production *** You have to plan your deployment, ie: The amount of ram you…
Fw: Need help!! Sql to Informix Migration
you may update your BUFFERS, how much memory do you have? you may send your machine configuration for tuning onconfig file. ----- Original Message ----- From: "Unholy" <dcalleja@gmail.com> To: <informix-list@iiug.org> Sent: Monday, April 18, 2005 11:10 AM Subject: Need help!! Sq…
Re: Need help!! Sql to Informix Migration
Unholy said: > Hi, I have developed a program that runs under sql Server, and it runs > really fast...... The problem is that now, I have to change the DBMS to > Informix. > > I installed Informix under W2000, and also under W2003, and with it the > program is really slow, as muc…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
large chunks
Is anyone running IDS 9.4 on a SAN with large chunks? Is performance satisfactory? sending to informix-list…
dropping chunk
Hello all, IDS9.40.FC4 HP-UX 11.11 I have successfully dropped an empty chunk from the database and tried to allocate it to another dbspace (after a Level 0 Archive) I am getting the message "The chunk specified already exists.". However, when looking for the chunk using "onsta…
dropping chunk
Hello all, IDS9.40.FC4 HP-UX 11.11 I have successfully dropped an empty chunk from the database and tried to allocate it to another dbspace (after a Level 0 Archive) I am getting the message "The chunk specified already exists.". However, when looking for the chunk using "onsta…
Re: Restore without mirror chunks available
> At initialisation time it complained (reasonably) bout the absence of the > mirror chunk, but other than that, no. You can just set the MIRROR flag to 0 in the onconfig on the non-mirrored system you're restoring to in order to avoid this. Jon.…
Re: Restore without mirror chunks available
> At initialisation time it complained (reasonably) bout the absence of the > mirror chunk, but other than that, no. You can just set the MIRROR flag to 0 in the onconfig on the non-mirrored system you're restoring to in order to avoid this. Jon.…
chunk access
Hi, The chunks are created with user and group informix. Theoritically only users in this this group should be able to access the chunks. But i have created a user "dummy" which is not in informix group. THis user is still able to access the data in the database. How is this poss…
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…
temp tables in IDS
I have a vendor application that appears to be creating temp tables in the root dbspace. I'm baffled. I don't want their temp tables pounding IO in the same dbspace at the system catalogs. There are 2 temp spaces, and the application database is created in dbspace 'dbs1'. They ma…
Re: Complete Backup on Windows NT
> Quick question, after adding new chunks, do I have to do anything to > ensure the database server uses them? After you add chunks with onspaces server will use then when needed. You can not really control which chunk will be used by server. Best regards, V.K.…
Fwd: RE: oninit: Not enough room in ROOT DBspace. [4035
How about simply an ONCONFIG paramter, ONINITLOCKED 1, means oninit -i is disabled! One would have to edit the ONCONFIG file to remove or disable the parameter (ie set to zero) in order to purposely init an existing instance. AND, oninit itself could add the parameter, initialize…
Re: DBStudio for Informix NEW FREE version online for download!!!
SteFetS <NOSPAM.gagnon_s@hotmail.com> wrote in news:Xns95E253C2BFE07NOSPAMgagnonshotmail@207.35.177.135: > > Do you have a mirror because the download rate is 0.4K ?…
Re: DBStudio for Informix NEW FREE version online for download!!!
myinformix@narod.ru wrote in news:1106058496.882858.283900 @c13g2000cwb.googlegroups.com: > I have no mirror. If you advice me software site with free upload, I'll > upload my tool. > I will check for a mirror. I'll keep you in touch.…
oninit: Not enough room in ROOT DBspace.
I have [or, more appropriately, had] a version of IDS 9.4 UC2 running under Solaris 9 on a Sun 280 server. Before bringing the system up in production, I wanted to allow more logical logs (the system was initialized with 11). The documentation said the only way to increase LOGFIL…
Big Chunks vs Small Chunks
Hi, All We just upgraded our data warehouse database(1TB) from 7.31FD2 to 9.40FC2, the instance is running on a partition of HP Superdome attached to EMC storage with 8GB memory cache. There over 500 2GB raw logical devices allocated to the instances with in 66 dbspaces right now…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: Stripe and Mirror Everything?
"Claus Samuelsen" <csa@eye-bee-em.com> wrote in message news:41494202$0$212$14726298@news.sunsite.dk... > > I would certainly consider two dbspaces - the root dbspace and a > temporary dbspace. In a logged database transaction record writing > (which is typically the most io inte…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-2003821237-1092088394=:10165 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Tha…
onspaces -m ... -f parameter
Found it myself - by trying a guess at the format, if you are wrong it tells you what the format should be. For every chunk in the dbspace to be mirrored you need a line like this: primary-chunk-path offset mirror-chunk-path offset…
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…
How to find the creation date of a chunk ? (not a dbspace, a chunk ?).
--0-504143858-1091557308=:68591 Content-Type: text/plain; charset=us-ascii Hello all, Could some one tell me the fastest and easiest way to find the creation date of a chunk ? Creation date of a chunk ? (not a dbspace because I can get it from oncheck -pe |grep Created) Than…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
cannot initialize root dbspace
$ oninit -iv This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine server run modesucceeded Reading configuration file '/informix/etc/on…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Logical logs from rootdbs to own logspace
"Geezer From The Freezer" <Geezer@Freezer.com> wrote in message news:40E135DB.477DB7E9@Freezer.com... > I want to set-up a logspace dbspace - easy enough. But how do I tell informix > to use this logspace dbspace instead of rootdbs? RTFOVFM. Quiesce the database onparamas to ad…
Adding chunks
I'm a long-time developer who has suddenly been handed a DBA hat to wear. I understand I should make a link to some raw disk space and use onmonitor to add the chunk. What I'm unclear on is allocating the raw space, and I apologize in advance since this may be more of an OS (AI…
Re: database market share 2003
Enor P <enor_1@hotmail.com> wrote in message news:<2jbdr8Fvfu29U3@uni-berlin.de>... > > You have looked in mirror? All shit is coming from you and Daneil Morgan. I don't look at mirrors to post on Usenet, unlike morons like you.…
Down chunks
Client is suffering from chunks being marked down due to incorrect ownership and permissions on some of the chunks. Some meathead must have gone in and changed them. Will they be able to get the data back once this has been corrected? Any clues how? (It didn't work when I tried …
mirroring
When, in the process of setting up a mirror of an existing chunk, does = it start writing to the mirror? As soon as the mirror is set up through = onmonitor? When I bounce the engine? Is the database still available = to users? I am running IDS 7.31 UD7 on AIX4.3.3. I plan on set…
Informix mirroring
Hi all, Have any one tested out informix mirroring. Well I run Informix 9.4 (linux version) and had mirroring turned on....followed the doc and was successful in making it work. I tested the mirroring by taking the primary chunk of the database down and running insert/select sql…
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: Where to put logs in a RAUD 1+0 system
> an RDBMS whose name escapes me which Oracle - the SAME (Stripe And Mirror Everything) paper. That's 2 for 2 in the naming department :-)…
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…
Can I use UNC file shares for dbspaces?
Hi informix specialists, I have a filer that offers plenty of disk space and I would like to use it for root and other dbspaces. To be independent from any disk drive letters, I would like to use the UNC notation like \\\\filer\\share\\dir1\\rootdbs_000. Has anyone been able to…
Informix data files interchangable btw Unix & Win?
Hi, What kind of Data Files ? (DB Chunks ?). If DB Chunks, it's not possible. Try DBEXPORT and FTP to Windows and DBIMPORT or (table level) Unload to file Load from file or (replicate transactions) Use Replication (CDR)…
move a chunk
hi, we have to move location of all chunks (root, tmp, data,...), how can i do that ? 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,…
Rootdbs gets filled
Hi bro, rootdbs seems pretty small: ROOTSIZE 30000 # Size of root dbspace (Kbytes) - Consider a bigger rootsize (256M, 512M, your milleage may vary) - I suppose you've set up a temp dbspace, right? its almost a basic rule for an installation. - move logical logs to its own dbs…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
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…
RE: chunk removal
Yes, this chunk can be removed without corrupting the dbspace. When you add a chunk to the system 1 page is allocated for chunk free list page and 2 pages are reserved. sending to informix-list…
chunk removal
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 chunk. Can I remove this chunk without c…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
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…
chunks down
Hello, I am using Solaris 7 (sun4u sparc SUNW,Ultra-4) and running Informix Dynamic Server 2000 Version 9.21.UC1. In the period from 22nd Sept to 3rd Oct 6 chunks went down - fortunately Informix mirroring switching seamlessly to mirrored chunks (which are now online). Among th…
DROP Chunk
Hi, We added some weeks ago - successfully, thanks to you all ! - a new chunk to a dbspace. We tried to drop this chunk using "onspaces" command but he said "no such chunk !" ... :-( It seems the corresponding file has been removed in between : is it possible to drop the chunk i…
Mirrored Chunks ....
I need to change my Primary Chunks to Mirrors and vice versa, to get my primary chunks on faster disks. I can always archive, change device links and restore. Is there an easier way? Thanks.…
Dropping chunks
Hi, I have created a copy (gemsnew) of a database (called gems), renamed the = gems database to gemsold and renamed gemsnew to gems. Thanks for your = help. They reside on different dbspaces, protodbspace and gemsdb1. I now = want to drop the chunks from gemsdb1 and also the dbs…
Performance and Mirroring
IDS 9.4 on Sun 450R, Solaris 8 ... My primary chunks are on two internal disks and mirrored to an external RAID. The RAID is about four times faster than internal disks, as measured by pfread. The reads seem to be using the mirrored chunks because the performance (for some of th…
ontape - All pages or just used pages
To calculate the size of a dump, do i take all pages on all chunks or just used pages in chunks ?…
Resizing chunks
Ok I have 6 chunks on a system that use only 25% of an available disk partition. I want to resize to use all of the disk partition Can I do this without interrupting the data. Note: each disk partition is only being used once at the moment. OR do I have to backup, delete, recr…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Re: Clarfication on reorg of critical dbspace...
"Brice Avila" <briceavila@hotmail.com> wrote in message news:c46e3ec5.0307301040.33fdfe@posting.google.com... > How about restoring the rootdbs to a different location? > > Another thought: mirror the rootdbs, and then break the mirror. I > don't like this suggestion so much as i…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Re: Changing the path of a chunk from onstat -d output.
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:<be0s1m$9e4$1@terabinaries.xmission.com>... > Why not create a mirrored chunk(chunks), drop the original > crate a new chunk with corrct name, > drop mirrors > > Mirroring is you friend :-) How's that going to work th…
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…
Adding chunks
Hey all -- Running IDS 9.3 on AIX. My initial root chunk was 30 MB, now have 3 chunks totalling 120MB. Plenty of space now. I have also successfully added several 1GB and 2GB chunks to my dbspaces. But now when I try to continue adding chunks to my dbspaces, I am getting this mes…
Re: Disk Layout recommendation
"zdavek" <zdavek@hotmail.com> wrote in message news:640ad61c.0305280547.467c0f42@posting.google.com... > Unfortunately, the hardware is JBOD and we haven't purchased the HP > Mirror-UX option so neither HW or OS mirroring is an option. Tight > budget, informix has mirroring so …
mirrorring question
Hello, we have an AIX server with Informix Dynamic Server 2000 Version 9.21.UC4 all informix chunks are mirrorred using informix mirrorring sample : disk 1 rootdbs, dat1dbsm, ... disk 2 rootdbsm, dat1dbs, ... our disks are becoming to small so we have to replace them …
finding the tables within a chunk
hi all, how can i find the names of tables within a certain chunk? Simply, i = want to find which tables or table fragments a chunk contain?is there a = sql statement for it? Thanks in advance.…
Mirroring question
Hi I don't understand the relation between Solaris disk mirroring and Informix mirroring. Can someone please explain? For example, what would be to impact of running Informix on a Solaris platform that is equipped with mirrored disks without implementing mirrored db spaces? I…
Migration of Chunk
Hi all, Current I have informix 7.31 running with about 10 active chunks. How to I migrate those chunck to new and faster harddisk space on the same server instead of doing import/export and load/unload. Thanks and Regrads, Tham.…
chunk transplant
> I thought Robert said his server OS mirrored the chunks, so if the > hardware fail, he has other server with the same configuration and > hardware able to bring on-line a new Ifx server by using the mirrored > chunks. It works, but if the IDS get a unrecoverable crash, this sch…
chunk transplant
We have been investigating ways to keep data current on a local and identical backup server. We are aware of IER and HDR. My boss suggested that we keep a mirrored chunk on a cross mounted drive that resides on the backup server. Then in the event of a failure of the primary se…
Tables for a chunk
Hello, I need to find the tables for a chunk. Is it possible with SMI tables? Regards Enrico Sent via Deja.com http://www.deja.com/…
Re: location of logs
oncheck -pe From: rsalido@my-deja.com > >Is there a way to find out where my logs are? I mean onstat -l gives me >a bunch of information regarding the logs but I dont think it shows in >which dbspace they reside in.....any ideas? > I just started working on this database and …
location of logs
Is there a way to find out where my logs are? I mean onstat -l gives me a bunch of information regarding the logs but I dont think it shows in which dbspace they reside in.....any ideas? I just started working on this database and I'd like to know if the logs physical and logi…
Data migration
jimm@burton.com wrote in message <906kb0$rt6$1@nnrp1.deja.com>... >I am going to move a 300G+ Informix database from one system to another, >and due to several constraints (that I am not pleased about but must >deal with), I am thinking of doing a dd copy from one set of disks to…
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…
Re: Root DBspace confusion
Mark, I like your suggested clarifications for this paragraph -- to not say "resize", but instead say "use a minimal log size when you first initialize the database server", and then do all the steps to move and resize the logs after initialization to keep the root dbspace small…
Re: Root DBspace confusion
> > Hi Michael and Mark, > > Yes, this paragraph does not address what to do when you resize the > root dbspace after you've already defined your dbspaces, chunks, etc. > This section addresses sizing estimates BEFORE you start the > database server the first time. We recommend …
Re: Root DBspace confusion
Hi Michael and Mark, Yes, this paragraph does not address what to do when you resize the root dbspace after you've already defined your dbspaces, chunks, etc. This section addresses sizing estimates BEFORE you start the database server the first time. We recommend elsewhere tha…
Re: Root DBspace confusion
Michael Hoffman wrote: > > Hi all, > > A bit of confusion upon reading the Administrator's Guide prior to > installing IDS 9.2. (After reading the following I went back to the 7.3 > manual and found the same passage) > > In Chapter 14 (Data Storage): > If you plan t…
Root DBspace confusion
Hi all, A bit of confusion upon reading the Administrator's Guide prior to installing IDS 9.2. (After reading the following I went back to the 7.3 manual and found the same passage) In Chapter 14 (Data Storage): If you plan to move the physical and logical logs, the init…
RE: pls help, mirror chunk down
You should not have manually added the MIRRORPATH path-name to your $ONCONFIG file. That method will not populate the contents of the mirror path. Instead, you should use "onspaces -m ..." to initiate mirroring for a dbspace. You could try to using "onspaces -r rootdbs" to end…
bad primary chunk?
I keep encounter this message "Bad primary chunk /s7/mysblobs" when i do a onmonitor mode -> startup or oninit -s. I also noticed that the bad chunk (/s7/mysblobs) is offline. What could cause a chunk to offline? How do i bring the chunk up/online? YFWoi…
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…
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…
Informix/Baan/AIX Performance
"Anderson, Andy" wrote: > > We are experiencing performance issues since upgrading to AIX 4.3.3 from > 4.3.2. The Informix database configuration has not changed and all the > latest patches/fixes have been applied to the OS. We are running on a > AIX4.3.3 / Informix7.31.UC3X1 / …
RE: On the behalf of another hapless soul, v.5.10 issue
This sounds like an OS tcp configuration problem, the users that can't reconnect are problem being blocked in some sort of FINWAIT type problem, what are you seeing on the netstat when this occurs and what are your kernel tcp settings Paul Watson WF Software Ltd Tel: +44 1436 67…
mirroring feature in IDS 9.2
Thanh wrote: > > I have not seen much discussion about the mirroring feature > in IDS 9.2. Can it be used as a low cost Informix solution for RAID-1 > (software/hardware) ? Yes. Be sure to place a chunk and its mirror on separate spindles and preferably on separate controllers …
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…
Put on line a dbspace
Hi, a client of mine has compressed some of his chunk:) so the dbspace and the chunk where put down. I have taken on line the chunk (onsapces ....) but now I have the dbspace down. There is a way to force it online? Many, many thanks.…
Re: Performance comparison btn Informix and SQL Server
From: wu@paris.dvs1.informatik.tu-darmstadt.de (Ming-Chuan Wu) > >I include the outputs of the onstat's cammands as follows. >The onstat's commands are given, while the IUS is running my test queries. > >---include begin >==========================================================…
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…
IDS 7.31 on DEC Unix
About month ago I have performance problems on 2 CPU DEC Alpha and one of advises was to add more CPUs. So we change old one Alpha with new one. New is Alpha 4100 with 4 CPUs and 2G of RAM. KIO is enabled. Now I have some problems: *************** 1. problem *******************…
Split AIX mirror to bring up HDR replacation
Has anyone split an AIX mirrored VG, to bring up HDR replication. If so what are the steps. -- Kevin H. Hunt khhunt@triplecrownsvc.com…
To mirror or not to mirror
IDS 7.31.UC3 running on IBM RS6000 G40 running AIX 4.3.4. We have a fully mirrored system at the moment (in Standard Engine 5.x) that, at 7:00am each morning, the mirror is split so that reports can be executed against the copy, whilst the live system chugs on. The Mirrors are t…
Re: Removing a TEST Informix Instance
From: "Sue Athey" <sathey@bepc.com> > >I have a second instance of Informix on a single Unix server that I would >like to remove. Besides dropping the databases and dbspaces (not including >sysmaster, and root, temp and log dbspaces) what else do I need to do? Is >there an unin…
Removing a TEST Informix Instance
I have a second instance of Informix on a single Unix server that I would like to remove. Besides dropping the databases and dbspaces (not including sysmaster, and root, temp and log dbspaces) what else do I need to do? Is there an uninstall feature or do I just have my tech su…
Slow loading/lots of checkpoints
First please do not post MIME, this is a text only newsgroup. Also your attachement is not easily retrieved. The too frequent checkpoints (I assume you have CKPTINTVL set to 10-15 minutes {600-900 secs}) are caused by the PHYSICAL log being too small. Check this by running onst…
Down chunk
Il s'agit d'un message multivolet au format MIME. --------------7D33438D52CB1F419DA8B8A5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Recently I had a disk failure on my HP-UX server, and the chunk file of my Informix db went down. I tried …
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…
Add chunk.
Hello, I am a newbie. Working with AIX 4.3.2 and IDS 7.30 UC7. After adding a second chunk to a dbspace I got the error message: extents overlap(oncheck -ce). Chunk was successfully added and onstat -d shows the new chunk. What is the problem? Thanks in advance, Fredo David…
Re: Mirroring with OE 5.0
---- you wrote: > Group: > > I am running Informix Online Engine version 5.05.UC1 on a UNIX platform and > I want to enable mirroring (via Informix, not RAID). I have duplicate disk > partitions set up for each of my existing dbspaces, but I fail to see how to > "turn on" mirro…
Mirroring with OE 5.0
You should just be able to change the TBCONFIG parameter MIRROR to 1, restart, then use tbspaces to add the mirror chunks to each existing chunk using the -m option. Lastly once the ROOTDB chunk is mirrored update the TBCONFIG parameters MIRRORPATH and MIRROROFFSET (if non-zero)…
RE: new ids config
Scott Black wrote: > > "Art S. Kagel" wrote: > > > * I don't know if HPUX can mirror RAW space but I doubt it > [clipped] > > John Carlson wrote: > As far as I know, HPUX can mirror at the rawspace level, through LVM. > [clipped] > > This is correct. We use it without any proble…
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…
Restore Granularity with onbar
I am using Informix 7.31 on Solaris 7. If you have a dbspace with 50 chunks, you lose three chunks, so they are now marked down by informix, when you restore from tape (using onbar) will it only restore the 3 down chunks or all 50 chunks for that dbspace? Thanks…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
Dropping a chunk by force
how do u drop a chunk by force in IDS 7.31…
Bad Chunk
Hi, When I am trying to initialize the shared memmory using oninit -s. I get the following message in the online.log: shmget: [EEXIST][17]: key 526a4801: shared memory already exists 00:11:21 mt_shm_init: can't create resident segment 00:11:38 shmget: [EEXIST][17]: key 526a…
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…
Recover a bad chunk
Hi If one chunk goes bad, what are the various methods to recover the chunk or how to copy one chunk to another. Any suggestions? regards usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.…
Hardware Mirroring
Hi We are using Baan and Informix 7.24UC1 on Solaris 2.6. We have setup hardware mirroring using disk array A1000 having total 6 disks[3x3]. We created approx. 6 logical disks from 3x18.2GB because of Informix 2GB limit. The Informix was installed before we setup the hardware m…
Role of DBSPACETEMP (II)
Henk van der Geld wrote: > If I create a temp table and DO NOT specify the WITH NO > LOG option, the temp table will ALWAYS be created in the root dbspace, > even if I specify DBSPACETEMP=tempdbs in my environment. BUGS FIXED IN THE 7.31.TC5 RELEASE 116590 TEMP TABLES WITH L…
Re: Setting up Rootdbs on a raw disk
Could you post the exact error message (just copy&paste) you receive from oninit and any messages you get in your online.log file ? On Thu, Jan 06, 2000 at 08:21:33AM -0700, Anne Shelp wrote: > > > >>>> Octav Chiriac <com@netinfo-moldova.com> 01/05/00 11:47PM >>> > >It could be …
Chunks and Offset.
Hi Gurus, I have a query, what will happen if I add another chunk (cooked file) and the offset is not zero. Regards. Jojo…
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
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…
Dropping a chunk
I want to drop the chunk featured below, but it has a phantom tblspace in it. Does anyone have a foolproof method of eliminating the recalcitrant tblspace, with recourse to informix Tech Support? thanks Neil Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size …
RE: Best way to config OWS on SCO box
Thanks for the help Art and Rick... Just to fill in the blanks...see below... >> > MIRROR 0 # Mirroring flag (Yes = 1, No = 0) >> > MIRRORPATH /data2/IFMXDATA/pcca/ROOTMIRR.000 >> >> You must set MIRROR to 1 in order to enable Informix mirroring. >> …
Setting up onconfig
Does anyone know how to or have an example setup file (onconfig) to setup informix for linux. Also can you use a file for the database or do you have to use a partition? Thanks ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/hda3 # Path for device containing root d…
When IDS need reinstall.
My IDS on sco .My chunk is use raw disk.no backup.When My IDS need reintsall ,How can I reuse the chunk,restore the data? Sent via Deja.com http://www.deja.com/ Before you buy.…
rootdbs offset change
Need to change the primary chunk rootdbs offset from 0 to 5. We were going to mirror the chunk and have the mirror have the new offset then drop the primary and then copy back from the mirror. Informix will not let us delete the primary chunk even if it is mirrored (this is onl…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Informix Mirroring
I have a question about mirroring. I am running Informix 7.24 on a 3 processor Sun ES3500. Disks are fiber attached drives. My question is: (1) Which is better --- Informix mirroring or mirroring thru Veritas volume manager? (2) If I use Informix mirroring are there any pr…
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: 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? Not even that way. On UNIX you would use symbolic links but these are not available on NT. You stuck with the original disks. Art …
move dbspace/chunks on NT
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,…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Restore to different chunk-paths?
Art S. Kagel wrote in message <37F28C5D.377EF0BE@bloomberg.net>... >I suppose Informix could give us an option to recreate the chunk list >using some file containing the new chunks ... Well, quite! But thanks for the reply. Neil…
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…
mirroring
Does anyone have hard data (or gut feelings if nothing else), on the performance gains of using mirroring?…
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…
Mirroring tempdbspaces
Hi all I have a customer who is fairly insistent on mirroring (at OS level) temp dbspaces. I think this is a bad idea, especially as I don't really have enough disk to play with. Whilst all my other systems are mirrored, I've never mirrored temp dbspaces before. What does the …
Root partition
Root partition? If you mean root dbspace, then you can add a chunk without any problem. I don't know about increasing the size of the initial chunk. -- Bashar Chalabi CTL, London Webber Valerie H wrote in message <7oumlp$ib$1@news.xmission.com>... > >Has anyone had experience i…
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.…
Re: Table Creation
Alvin The DBSPACE where the database was created. Murray Wood ----- Original Message ----- From: Alvin Palacios <apalacio@mnl-hub.dhl.com> To: Informix Mailing List <informix-list@iiug.org> Sent: Friday, 30 July, 1999 17:15 Subject: Table Creation > > All, > > Here's the scen…
# 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…
Contentets of a chunk
> > We use DBSPACETEMP=temp different of root dbspace. > > We have a problem with a chunk in root dbspace. Sometimes it grows When you are using SELECT INTO TEMP WITH NO LOG - this goes to the tempdbspace, but when SELECT INTO TEMP - this goes to the root dbspace. In other words…
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.
How can i drop a chunk. regards.…
Re: Performance tuning - Configuration files
mark@orbell.demon.co.uk wrote: > > Aplogies for the lack of information : Here are the configuration > files : You say you have a Pentium system running Solaris 7. I thought Solaris 7 is the 64bit version? Anyway... In addition to what you have provided it might help if you p…
Sequencing chunk population in dbspace
Tom Smith wrote: > > I am using IDS 7.23 on Solaris 2.5.1. I have defined a dbspace with > three chunks and create a table in that dbspace. I then proceed to load > the table using a migration utility. How will the engine decide in > which chunk to store the data? It begins u…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
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…
Down Chunk
Gentlepersons: My understanding of Down Chunks is less than complete! I would invite comments or further explanations. On p. 13-15 of 7.3 Admin Guide, it says "You can prevent the database server from markng a dbspace as down while you investigate disabling I/O errors." 1) Ho…
Re: Creating mirrored chunks
Jon Your logic is not correct. Where did you tell the mirroring process that there was nothing in the primary? Anyway the mirror would need to be set identical to the primary, hence it needs to read and write every little bit. BTW Why are you using Informix mirroring? Does t…
Creating mirrored chunks
I'm in the middle of building a server and it strikes me that onspaces is a bit daft when adding new mirrored chunks. It takes an *age* to do this which suggests it's actually copying everything from primary to mirror, even though both should be empty. Is this what's happening? I…
No primary chunk
Hi, When restarting Informix, I received the following message, no primary chunk / bad primary chunk Does anybody know what the problem is? What procedures do I need to recover the data in the database? Many thanks. Sunny…
Deleting a chunk
Dear Jonathan, Art, and Informix list friends: I saw a recent post to the list regarding deleting a chunk. My situation is this. We decided not to use a certain table in a dbspace any more. The dbspace now requires much less space. How do I get rid of a chunk or two? or is there…
Re: Q:multiple mirrors
Hi Art, everyone, Q: Say you put this third set of mirror on a dual ported storage array. After breaking the mirror, could another instance of IDS on another box with the same Informix configuration be able to use these mirrors/chunks? In article <372DC93C.52DD@bloomberg.net>, …
Q:multiple mirrors
Ivars Strazdins wrote: > > Hi all, > > though it has been mentioned somewhere that Informix now supports more than > two mirrored chunks I haven't found out how to implement this. Could you > please point me to appropriate documentation on explain in the list? I think that you a…
dbspaces for Temporary tables
I am running IDS 7.3 on NT sp 3 24x7 web OLTP environment. Do people use onspace -t type dbspaces in this environment (no mirroring?), regular dbspaces, or filesystem (no mirroring on NT Wks) for their temp tables. I don't have a lot of disk spindles to play with either unfortu…
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…
New database from HP mirror disk?
I have a database which resides on a mirrored disk (using hardware mirroring). I want to split the mirror and perform lengthy read only calculations on the mirrored (secondary) data before remerging. This is so that other processes can update the database without affecting the c…
Cleaners
Please forgive me if this is posted twice ----------------- Online 7.24UC3 Solaris 2.5.1 Given that Cleaners are assigned to chunks in the order that the chunks are created (and I don't know the order) how can I determine which cleaner from onstat -F) is assined to which chunk? …
DBA problems
How long have you been a DBA Mukund??? The mirrored chunk always takes up the entire allocated size of the primary chunk, regardless of how much free space exists in the primary. You never look at the mirrored chunk for space usage metrics, use the corresponding primary chunk. …
follow up-- rename chunks
What do mean rename chunks? Do you want a new path for a chunk? The supported way of doing this would be to empty the chunk and then drop it and create a new chunk. Any other way could be dangerous leading to some corrupted chunk information. Brandon David Grove wrote in mes…
change chunk name
Could one change chunk name by editing the appropriate reserved pages (primary and mirror chunk pages-- 8th, 9th, 10th, & 11th reserved pages, I believe). David Grove…
Rename Dbspaces
Thomas J. Girsch wrote in message <3702c2a7.0@newsfeed.one.net>... >Moving a chunk is somewhat easier. If all you're doing is moving a chunk, >you can create a mirror on a linked device where you really want the chunk >to live (these can't be the same slice!). Then, after it sy…
Chunk writes
Hi, I am in the process of creating the layout for a database. I will have 6 physical disks to work with (plus another 6 for mirroring). I understand that CLEANERS should be set to the number of disks, in this case 6. I also gather from messages that this scheme would perform op…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: How to find out tables in a dbspace?
>My root dbspace is getting pretty huge. Logs are in their own dbspaces. >How do I findout what tables are there in a given dbspace? >There should be away to figure this out by looking at sysmaster? I'm sure you can, but I don't have manuals to hand. However, oncheck -pe (or tbc…
How to find out tables in a dbspace?
Hi: My root dbspace is getting pretty huge. Logs are in their own dbspaces. How do I findout what tables are there in a given dbspace? There should be away to figure this out by looking at sysmaster? Any pointers will be appreciated. System config: IDS 7.24 UC6 IBM AIX 4.2.1 …
Re: Help: oninit -i
Elizibeth : You are gonna have to do this at least the once ( and only the once if you get it right! ) - however do be warned : Check in your onconfig.new file and ensure that the 'ROOTPATH' and 'MIRRORPATH' (if used) are NEW files/disk partitions and are DEFINATELY NOT USED by…
Performance Tuning
Well, the first thing to do is to determine what your performance goals are, then do a comprehensive audit on the current system (os, database and network) under load. The system or db parametes you change will depend heavily on where any performance goals are defecient. When…
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…
Offline Chunks
Besides a bad spot on a disk what are others reasons for an informix partition to be put offline? Thanks -- Kenny Broezell Motorola Cellular Support Center e-mail: broezll@cig.mot.com 1501 Shure Drive phone : (847) 342-5633 Arlington Heights IL. 60004 …
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?…
How define the dbspace where an index must to be created?
When I created a table with primary and foreing key informix define an index automatically for each key, that is fine to me but I need to define these indexes in other dbspace than root dbspace. Somebody know how to do it? Thanks. -- Luis M. Ramos V�lez GM GROUP, Puerto Rico lram…
Create DBSpace...
i have never worked with this gui-tool but on unix platforms there is a difference between creating root-dbspaces or adding another dbspace to the system because the root-dbspace would be something like "formatted" Gursoy YERLI schrieb in Nachricht <77fldb$isc$1@news.xmission.co…
oninit: Fatal error in shared memory creation
Can someone please point me in some direction on this? I am trying to set up Online Workgroup Server v7.2+ on a Sun Ultra2 running Solaris 2.6. We are attempting to use a cooked file (which seems to be generated fine for the root). I am configuring through onmonitor-->Parameters-…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: Can't drop dbspace?
On Mon, 16 Nov 1998, Kit Nevin wrote: > Due to a couple of circumstances, a dbspace we've created can't be > dropped...we're running online 7.22 on Solaris 2.6 using raw disks > partitions. The circumstances were a) root was still the partition owner > when the dbspace was creat…
Can't drop dbspace?
Due to a couple of circumstances, a dbspace we've created can't be dropped...we're running online 7.22 on Solaris 2.6 using raw disks partitions. The circumstances were a) root was still the partition owner when the dbspace was created (and was changed to informix prior to the at…
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: TEMP Tables
Shew Leong wrote: > > Hi, > > Is there a limit to the number of temp tables you can create? > > My stored proc creates 5 but Informix errors out with error -131 - basically > ran out of space. > > Stats - Solaris 2.6 - Informix 7.2.3 No no limit, however, temp tables not created…
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.…
Re: Fw: ADDING ADDITIONAL INSTANCE!
Datamas wrote: > > -----Original Message----- > From: Datamas <datamas@batelco.com.bh> > To: informix-list@iiug.org <informix-list@iiug.org> > Date: Sunday, October 25, 1998 10:19 AM > Subject: ADDING ADDITIONAL INSTANCE! > > >Hi all, > > > >Can any one tell me that how to add a …
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…
Informix on SCO
Where can I get some information on how to configure Informix Onlie Dynamic server on SCO. I'm stuck on the Root DBspace chunk. when tring to initialize the shared memory.…
Re: Reconfig dbspace with mirroring?
Ruiming Chen wrote: > > Before we configurated dbspace and rootdbs without mirroring, because > we have only one of disk spaces. Now we bought new disk. So we want to > mirror the dbspace and rootdbs to the new disk with "onmonitor". But I > get > message says "dbspace was initia…
Re: How to add space to a database??
Saleem Mohammad wrote: > > Hi > Can someone tell me how to add space to a database instance? You can either create a new dbspace or append more space (additional chunks to use the vernacular) to an existing dbspace. You can do this using the onspaces utility (onspaces without…
Re: Cooked Files
Go ahead and specify the offset. The additional chunk will overwrite neither files on the existing file system nor the tables in the existing cooked files so long as the chunk you are adding is for the same instance of Informix that you created the initial cooked file. Rene…
Re: Strange error in Informix
Try to put the name of the chunk in big LETTERS. Pascal…
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…
Adding a Chunk
We are doing the rather mundane task of adding a chunk to a dbspace. Unfortunately we have very little experience with Informix because we only use it for one application called Permits by Sierra. Additionally since Informix runs so well, we rarely have any problems and we only h…
chunk permissions
Hello Everyone, Im getting the following message in my server log, but the file permissions are set to informix, informix. Any ideas ? The chunk '/u3/GAP/informix/dbspaces/rootgapdbs' must have owner-ID and group-ID set to informix. -rwxrwxrwx 1 informix informix 0 S…
Re: Moving Chunks
Perhaps a "hindsight". I use Unix/AIX llinks for all my chunks, including root space. Then If I need to move, you only have to change the link after physically moving the chunk. Works great for cooked space.…
Moving Chunks
I have an Informix Database on cooked disk space. Now I would like to change the path to the chunks (datafiles). Is there any way except unload/load the whole data? Yours Sigrid Ehrenreich seh@carus.de…
Re: Informix 7.24 with SAP R/3 : EMC2 : striping / fragmentation
Ashby, David wrote: > > I don't believe you can use striping with mirrored disks (configuration > specified in original message). Stripping is for higher raid levels. Of course you can, either that or my >500 striped mirrored disk drives are not really there! This is called eit…
Re: dbimport and size of rootdbs
Neil Truby wrote: > > Maybe I've misunderstood what you've done. but it seems to me that the most > likely explanation is that on System A the database resides in a dbspace > other than root and, when you've run the dbimport, you've failed to use > the -d option. Thus the utilit…
Chunk down
The Online Admin guide for Informix says that if a chunk is down, to "Use UNIX utilities to determine what is wrong with the down chunk and then to correct the problem and bring the chunk back to on-line mode." Can someone expand on this and suggest what UNIX utilities are perti…
Installation of ID 9.1.4
Hi, I am trying to install IDS 9.1.4 on a Solaris 2.6 box. Using raw devices for the root dbspace. Installation went on fine but when it came to oninit -i I get the error message - root dbspace not owned by userId Informix and group Informix. As suggested somewhere in the Admi…
Re: rearranging chunks
In article <6rjg9i$obl$1@news.uni-lj.si>, zdravc@fe.uni-lj.si (Zdravko Balorda) wrote: > Hi, > > is there a way to rearrange disk partitions and > chunks once dbspaces are initialized and data > loaded? I am not quite happy with what i did. > I want to, say, copy a chunk to ano…
rearranging chunks
Hi, is there a way to rearrange disk partitions and chunks once dbspaces are initialized and data loaded? I am not quite happy with what i did. I want to, say, copy a chunk to another one so that the first one could be dropped. Or is this chunk layout frozen, once you created i…
Move chunks
Hi all, I have IUS 9.x on an Ultra 1 box, running Solaris 2.5. I want to move the chunks of all of my dbspaces to another disk. Chunks are stored into cooked files. I thought that if I move them to my new disk and create some symbolic links (with same names as the original cooked…
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…
Re: RAW-Device - oninit
Edward, The permissions have to be granted on the physical (raw) device and not the symbolic links.The permissions on /dev/rdsk/c0t1d0s6 should be informix:informix and on /dbspaces/rootdbs should be root:sys and nothing else..!! Hope this helps, Regards, Girish Punjabi giris…
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…
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: Database and RAID
Some of the logical volume managers also support 'split mirrors'. The EMC Symmetrix supports extra mirrors (locally in the same box and/or remotely over fibre) that can be split fairly quickly. One nice option is that the 'split mirrors' can then be assigned to a secondary host …
Re: Database and RAID
David Kosenko wrote: > > Matt Reprogle <mcreprog@ictest.delcoelect.com> offerred: [SNIPPED] > Version 7.3 of IDS allows the use of external backup mechanisms. While the server > can be technically "on-line" during such a backup, in fact all update activity is > blocked. Effecti…
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…
Down Chunk
Is there a way to drop a down chunk from a dbspace which has only one chunk? The down chunk is a cooked file which has been removed from the file system. When I tried to drop the dbspace which contains only one chunk, onmonitor returns with an error (ISAM error: Unexpected inte…
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: +…
Coalesce Chunks
Hi, A dbspace has 3 chunks.These three chunks are on different disks.I want to place the three chunks contiguosly on another disk.How to go about doing this ? Dbexport/Dbimport works at Database levels only i believe. TIA, Sathish _____________________________________________…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: HP vs Informix mirroring
I had the same expirience as Irwin. HPUX 10.20 INF-ONL 7.14UC? We made a mirroring with informix. And the reads has all gone to one (the first, the original disk) disk. after the explanation from Irwin its clear why!!! Therefore HP-Mirroring is much much better/faster and so on. …
Re: DBSPACEUP Environment Variable
Jay Aymond wrote: > > If the environment variable "DBSPACEUP" is set to indicate the size of sort file > for distributions during an "update statistics" --- what dbspace does it use for > the sort file? If there is a temp dbspace, does it use that? By priority: PSORT_DBTEMP (l…
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…
Re: dbimport - 512MB RAM not enough?
Don Miller wrote: > = > Greetings, all: > = > I've run into a problem using dbimport to re-create a large existing > database in a new dbspace on new disks - although the database unloaded= > using dbexport just fine, every time I try to use dbimport, it complete= s > less tha…
Re: How can I create DBSCAPES in 20GB RAW partition
: Anyway a dbspace can have as many chunks as needed and the 7.xx engines : support 1024 chunks or 2TB. Chunks can be less than 2GB and the actually, the limit is much larger. i'm not sure that there is one. as you allocate more chunks, the system allocates more pages to the…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: 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…
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…
chunk archiving
hello everybody!! i've got the very common problem of archiving out of date data, let's say the production data older than 3 years. my plan was like this: grouping the data onto yearly changing dbspaces like ar1997, ar1998 ... each dbspace is designated to a distinct chunk, whic…
Mirroring and Archives
We currently use Informix DS 7.22 on AIX. All of our chunks are mirrored (approx. 17Gb). We do a zero level ontape archive each week and a level 1 daily. If there is a problem with the database and we have to perform a restore, can we restore to a machine with the same primary…
Mirroring and archives
We use Informix Online 7.22 on AIX. All of our chunks are mirrored (approx. 17Gb) and we perform a zero level ontape archive each week and level 1 archives daily. If there is a problem with the database and we need to restore from tape, can we restore to a machine without mirro…
Re: mirroring
In article <EnHznM.3yy@gatekeeper.transre.com>, Juan R. Guzman <jguzman@remove_this_transre.com> writes >What dbspaces should I mirror? Of course rootdbs is a give. thanks > > The ones containing physical and logical logs... -- David Williams Maintainer of the Informix FAQ …
Re: mirroring
Juan R. Guzman wrote: > What dbspaces should I mirror? Of course rootdbs is a give. thanks Easy. ALL DBSPACES. and ALL OTHER DBSPACES. My experience: do not rely on RAID5 for database disks. Use Hardware mirroring, OS level mirroring or Informix mirroring. Prefer Hardware…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
informix mirroring
i am having a problem with disk i/o - i am currently utilizing an ibm ssa with 8 disk (4x4) with informix mirroring when i run an iostat (aix) it shows my hardest hit drives are the ones that are mirrored. i have hardly any hits on the regular disks - i have also split my data ac…
Re: root dbspace chunk offline how recover ?
In article <34CE1679.5F6C@credo.ie>, Peter Groarke <peter.groarke@credo.ie> writes >Hi, >Informix 7.23 installed. I have the root dbspace (containing >the logical + physical logs) on one disk which is now >banjaxed. > The other dbspaces are on a separate, good disk. >I know the s…
root dbspace chunk offline how recover ?
Hi, Informix 7.23 installed. I have the root dbspace (containing the logical + physical logs) on one disk which is now banjaxed. The other dbspaces are on a separate, good disk. I know the steps for bringing back a non-root dbspace chunk when it goes offline, but how do I bring …
help.
Hi, is there anybody that could help me? I had to install Online dynamic Server on a Tandem machine (mips processor). Everithing seems goes right until we give the "oninit" commadn, when we receive a message that we did not initialize shared memory and there is'nt root dbspace. …
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: the new bie with the share memory problem
SaTriGuy wrote: > > Is the chunk's name /work/data or /work/data/root_chunk ? > Madison Pruet Can you 'dd' this chunk as informix?…
Re: the new bie with the share memory problem
Is the chunk's name /work/data or /work/data/root_chunk ? Madison Pruet…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: root dbspace full. Question?. Informix 5.00 UC3
Gabriel Leglise wrote: > > The aplications (Dbaccess) running on Informix 5.00 > UC3. > > In one moment the root dbspace is completed very fast > and > the others programs can=B4t run. > > Ej.: tbstat -d|grep rootdbs > > Space …
root dbspace full. Question?. Informix 5.00 UC3
The aplications (Dbaccess) running on Informix 5.00 = UC3. In one moment the root dbspace is completed very fast = and the others programs can=B4t run. Ej.: tbstat -d|grep rootdbs Space Free dbspace …
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…
Chunk Writes
Hi, I have been reading the "online Dyn. Server Sys. Adm 1" training mtrl -by Cindy Lee Dowling,Elizabeth Suto. Chapter 10 -270 which discusses Chunk Writes. it says " All modified buffers are flushed to disk.The page cleaner threads read thro' the buffer headers looking for…
Re: stale dbspace info
David Williams wrote: > > 1. dbexport all databases > 2. shudown online > 3. Edit onconfig file and remove any references to dbspaces > other then you root dbspace. (check PHYSDBS,LOGDBS,DBSPACETEMP) > > 4. Note the dbspaces and chunks you wish to keep. > (pathn…
Re: stale dbspace info
In article <64v5ht$ffl@cssun.mathcs.emory.edu>, chris@dvs1.informatik.th-darmstadt.de writes > >Hi ! > >Recently we had a power loss which caused a hard disk damage in turn. >The disk contained several primary chunks as cooked file space for >dbspaces. > >Although the dbspaces ar…
Re: Q: Mirroring - what is the better way
David Williams (djw@smooth1.demon.co.uk) wrote: : According to the person at Informix UK Training who gave my : Performance Tuning course....there is no difference. Mirroring is : mirroring. : YOu have to remember some OS's do not including OS mirroring. On : these ma…
Re: Q: Mirroring - what is the better way
In article <19971112051101.AAA17902@ladder02.news.aol.com>, VFraenkle > <vfraenkle@aol.com> writes > >I have heard many different statements about mirroring. The one say > >"You allways have to use OS mirroring" - the other say "It is better > > to belive in INFORMIX mirroring". …
Re: DBTEMP variable and sorted rows
> There are about 150 MB of free disk space. We're only sorting about > 10,000 rows. > Could it be some file system limitation? Are the files really created in $DBTEMP or is a (root-)dbspace used instead ? (you could check the free space in sbspaces using an "onstat -d" frequent…
Re: Q: Mirroring - what is the better way
In article <19971112051101.AAA17902@ladder02.news.aol.com>, VFraenkle <vfraenkle@aol.com> writes >I have heard many different statements about mirroring. The one say >"You allways have to use OS mirroring" - the other say "It is better to >belive in INFORMIX mirroring". > >An her…
Re: Mirroring - what is the better way
The last time I discussed this with the UK ITS they said that there no difference officially but unofficially they believed hard mirroring to be quicker. -- Paul Watson WF Software Ltd. Tel: +44 1436 674729 Fax: +44 1436 678693 Email: paulw@wfsoftware.co.uk VFraenkle <vfraenkle…
Q: Mirroring - what is the better way
I have heard many different statements about mirroring. The one say "You allways have to use OS mirroring" - the other say "It is better to belive in INFORMIX mirroring". An here is my final question, now: INFORMIX build in mirroring vs OS mirroring, what is the better way and …
Deleting Chunk..
Hello Everybody., We are working on Informix Online 5.03 on HP-UX 10.10. I have a DBSpace which has a chunk. I need to remove this chunk from the DBSPACE. Is there way do that. -------------------------------------------------------------------- RSAM Version 5.03.UC5X1 -- On-Lin…
Re: Informix disk mirroring
John Coyle wrote: > > Hi everybody! > > I'm investigating the efficiencies of disk mirroring for our Informix > 7.23.UC3 engine on an HPUX 10.2 box. I am currently mirroring the root > dbspace as well as the physical and logical logs. We are thinking of > mirroring an entire 12…
Informix disk mirroring
Hi everybody! I'm investigating the efficiencies of disk mirroring for our Informix 7.23.UC3 engine on an HPUX 10.2 box. I am currently mirroring the root dbspace as well as the physical and logical logs. We are thinking of mirroring an entire 12Gb database. What are the effi…
Re: Changing size of RAW space
Curt Narvesen wrote: > > I inherited an Informix database that has a large chunk of space allocated as > raw. Is there any way decrease the amount of space allocated as raw without > unloading the database? I am running version 7.1 No there is no way to reduce the size of a sing…
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…
Tables on a particular chunk.
I'm looking for a query which will list all the tables which spill over onto a particular chunk. I am able to list all tables on that dbspace, but this dbspace has two chunks to it, and I want to know which tables are on the second chunk. Any help would be greatly appreciated. …
Re: Help - 567: Cannot write sorted rows. 28: No space left o
> On 26 Aug 97 at 13:54, Bill Bertovich wrote: > > > Error: > > 567: Cannot write sorted rows. > > 28: No space left on device > > Uhhh, sounds like you're running out of disk space... How is your > temp space set up? Can you monitor it at the time you're running the > que…
How to bring up an unmirrored chunk?
Hi, I am faced with a DOWN chunk with no mirroring. Does anyone know a way of bring it up? Thanks! Cheers, Cheng…
Re: Mirroring
Jay Aymond wrote: > Is there some rule for defining how many LRU queues to have for a > certain number of buffers? Well, this came up in the optimization tutorial. One thing that we're going to try, as advised, is ramping up the queues to 128 for "large buffer" installs (or al…
Re: Mirroring
Jay Aymond wrote: > > "Art S. Kagel" <kagel@bloomberg.com> wrote: > > >Jay Aymond wrote: > >to wait for page flushes during checkpoints. I run my busiest servers > >with > >LRU_MAX_DIRTY=3 and LRU_MIN_DIRTY=0 90% LRU Writes, these puppies fly! > > > >Art S. Kagel > > Thanks for …
Re: Mirroring
"Art S. Kagel" <kagel@bloomberg.com> wrote: >Jay Aymond wrote: >> >> I am adding mirroring to my Informix Online 5.x installation. Right now, I have >> Cleaners set to 2 for my two primary disk drives. Once I have enabled >> mirroring, should I change the number of Cleaners fr…
Re: Mirroring
Jay Aymond wrote: > > I am adding mirroring to my Informix Online 5.x installation. Right now, I have > Cleaners set to 2 for my two primary disk drives. Once I have enabled > mirroring, should I change the number of Cleaners from 2 to 4 since I will have > more disk drives, ev…
Re: How do I initialize the root dbspace?
Bill Bertovich wrote: > However, I ran into a problem (running out of space again) while loading up > a customer's database. So, I thought that now would be a good time to > clean up some of the crap. So here is what I did. > > 1) I exported the databases (2) we needed to save a…
Re: How do I initialize the root dbspace?
In article <5ras3u$2io@cssun.mathcs.emory.edu>, Bill Ennis <ennis@ssax.com> writes >Hi, > >You've a several things mesing you up. Hopefully, I will identify >them all. > >For starters, the rootdb space will be used as the home of your >logical and physical logs when you reinitial…
Re: How do I initialize the root dbspace?
Hi, You've a several things mesing you up. Hopefully, I will identify them all. For starters, the rootdb space will be used as the home of your logical and physical logs when you reinitialize. This means that you need enough space for all logical and physical logs plus space fo…
How do I initialize the root dbspace?
Hi, Informix 7x, Solaris 2x. Being new to Informix, we made a lot of typical novice mistakes when we first installed it, 2K logical log sizes, underestimated db sizes resulting in dbspaces with many chunks, etc. Since we are a development company and we only use the databases …
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…
Moving rootdbs
How about making the "new" rootdbs a mirror of the old one and then taking down the the old rootdbs? -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait…
Re: Droping an unused chunk
Hi Chris, Winson Kwok wrote: > > Dear Gurus, > > If I have a chunk that's not used (but added to the dbs) is it possible > to drop it to free space. Starting with version 7.x there is a way to drop unused chunks, if the chunk to be dropped is not the primary chunk of a dbspace …
REQ : how do I add space to a 5.0 database?
Hi We are using a network monitoring system (Strataview), which uses an Informix database as repository (Apparently it is a 5.0, on a Sun machine). We have some space problems with the database, and we don't want to be purging tables monthly, so the other solution is to add mor…
mirroring doc's
Does anybody have any idea where I can point my finger to find doc's on Informix Mirroring. My sales person (I know, I should have asked here first) says that Informix does mirror. I found a page or two in the SQL Tutorial manual but nowhere else. I am looking to do as they adver…
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…
Mirroring: Informix or AIX 4.1.5
We want to implement mirroring on an RS/6000 J40. Should we let Informix mirror the drives or AIX 4.1.5? We are currently using Informix 7.12 and are writing to a raw partition through the LVM. Since it is going through the LVM, the OS should theoretically be able to mirror it…
Re: Best Tune for Online 5.02
Consider making the memory resident. I'd reduce the PHYSBUFF and LOGBUFF sizes dramatically -- to 64 kB or 128 kB each, usually. Allocate the saved memory to BUFFERS. You could verify that this is a good idea by looking at the tbstat output which reports on how those buffers a…
Re: OnLine 7.13 performance problems - comments please?
Ntruby@netcomuk.co.uk wrote: > > . .dra.com!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com� > . !rill.news.pipex.net!pipex!netcom.net.uk!not-for-mail > From: Neil Truby <ntruby@netcomuk.co.uk> > .Newsgroups: comp.databases.informix > Subject: OnLine 7.13 perf…
Re: OnLine 7.13 performance problems - comments please?
Hi, Your output shows quite a few waits in several areas. One thing you can try if you can spare the resources is to change your lock level on database tables to row level locking (if not set there already). This will ease contention for the tables. Your read cache is about as …
Re: OnLine 7.13 performance problems - comments please?
Neil Truby wrote: } } We're running OnLine 7.13 under Solaris 2.4, on a Sparc 20 with 160M of } memory. The load is increasing, and the users are complaining about } performance. } } Here's my onstat -p in the 12 hours since I zeroed the stats: } } Profile } dskreads pagreads bu…
Patching Chunks
I am looking for a tool or utility that informix seems to have. I need to be able to patch chunk headers on the raw devices. Platform: DEC ALPHA os: 3.2G db: On-line 7.12uc1x8 Please email me : mdeegan@logistix.com -------------------==== Posted via Deja News ====-------------…
Re: Cleaners-Mirror and Temporary Chunks
Milan Vesely wrote: > > According to Informix chunks should be added to system > in a successive way - to be cleaned correctly by > CLEANERS. The number of CLEANERS should be the same > as the number of disks to be cleaned. > But: How to consider TEMPORARY and MIRROR chunks? > …
Re: 48 out of 58 chunks down
Is it possible that the CHUNKS paramater in your tbconfig file got changed to 10 during the upgrade? This parameter sepcifies how many chunks the instance will support. HTH, Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com…
Re: Mirroring
In article <3313D72E.77A70447@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >cburton@gte.net wrote: >> >> I am currently on 7.11.UC1 on HP-UX 9.04 >> >> To experiment (before implementing), I created a mirror of the >> root_dbs. Both the root and the mi…
Re: Mirroring
Chris, I had the same "problem" here, to simulate a device error I had to have my sysadmin physically pull the disk out, quite a simulation :) Once the link is resolved informix will not recognize the rm of the link until it needs to resolve it again (when you bounce t…
Re: Mirroring
Stefan Weideneder <stefan@www.weideneder.de> wrote answer to mirroring problem. :cburton@gte.net wrote: :> :> I am currently on 7.11.UC1 on HP-UX 9.04 ...snip... :> I called INFORMIX help, and their answer was that I had :> to bounce the server (at least once a week, according t…
Re: Mirroring
cburton@gte.net wrote: > > I am currently on 7.11.UC1 on HP-UX 9.04 > > To experiment (before implementing), I created a mirror of the > root_dbs. Both the root and the mirror are seperate logical (and > physical) devices. The links to the devices were created in > /usr/informi…
Mirroring
I am currently on 7.11.UC1 on HP-UX 9.04 To experiment (before implementing), I created a mirror of the root_dbs. Both the root and the mirror are seperate logical (and physical) devices. The links to the devices were created in /usr/informix/dev. t_root_dbs and t_root_mir A…
Re: Informix startup (oninit) problem
Verify that informix informix 660 is the ownership/permissions on /informix/devices and make sure it is a valid partition, then try an offset of 2 for ROOTOFFSET. Rob Donat. ptsui@aptnet.com wrote: > > I get the following errors when trying to do an "oninit -i" to > bring up th…
Re: root dbspace
In article <5da2pk$brh@cssun.mathcs.emory.edu>, tr-2959@necadmin.necvenues.co.uk ("Tony_Reynolds(Accounting & Purchasing)") wrote: > > 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 sp…
Re: root dbspace
Tony_Reynolds(Accounting & Purchasing) wrote: > > 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 i…
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…
Re: mirroring in OnLine 5.03
Im Artikel <5b37kn$6m2@geog5.umd.edu>, mheinick@Glue.umd.edu (Mark Heinicke) schreibt: >We have MIRROR set to 1, and a valid MIRRORPATH, as far as I can see. >However, when we try to initialize (tbinit), we get the following error: > >Mismatch in configuration file : MIRRORPATH=…
mirroring in OnLine 5.03
We have MIRROR set to 1, and a valid MIRRORPATH, as far as I can see. However, when we try to initialize (tbinit), we get the following error: Mismatch in configuration file : MIRRORPATH=/dev/mirror_root Root chunk was not mirrored. Add mirroring using tbspaces or tbmonitor. tbi…
creating a chunk
system: sco unix 3.2.4.whatever db: informix online 5.03 usage: testing system Problem: system had recent disk problem. Reinstall started but no recent system backups could be located - at least not complete. root filesystem pieced backed together. Now missing cookedspace…
Re: help: Shared memory init error
Do you have mirroring turned on. 7.1.2 and 7.1.3 does not allow ontape restores when mirroring is turned on due to a bug.…
Re: Online V7 and Parallel Queries
> > Is it true that PDQ, parallel queries in OnLine V7.x will use both > primary chunks and mirror chunks to retrieve data concurrently when > performing a query expected to return large volumes of data??? > It is true Michael Strother…
Online V7 and Parallel Queries
Is it true that PDQ, parallel queries in OnLine V7.x will use both primary chunks and mirror chunks to retrieve data concurrently when performing a query expected to return large volumes of data??? The reason for asking - trying to determine whether software mirroring has advant…
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…
Informix and MP
Will Informix 7 take (effective) advantage of multiple processors? On an HP 9000 running HPUX10, if it matters. Also, anyone have any disk-mirroring suggestions for this platform (approx 25GBto mirror)? Many thanks... John "a bewildered dec/ingres weenie" Hascall…
Re: ontape/ondatartr restores
---------- > From: ntruby@netcomuk.co.uk > To: informix-list@rmy.emory.edu > Subject: ontape/ondatartr restores > Date: vrijdag 1 november 1996 19:49 > > It's well known that OnLine demands that a restore requires the original > chunks to be available, or at least the same symbol…
Re: Informix vs. AIX Mirroring
In article <52p08p$68c@cssun.mathcs.emory.edu>, Jack Parker <jparker@boi.hp.com> writes > >I disagree. Filesystem damage can 'take down' a primary drive. Since >it is generally a raw device - hte Unix mirroring will never notice a need >to switch over where the Informix mirrori…
Re: Informix vs. AIX Mirroring
John Morton wrote: > > Hi there. We're just moving from a RAID5 box onto some SSA disk, so we > have to think about mirroring. Informix recommends Informix mirroring, > and IBM recommends AIX (what a shock!). We are running AIX 4.1.4 and > Informix 7.20 on an 8-way RS6000. > > Se…
Informix vs. AIX Mirroring
Hi there. We're just moving from a RAID5 box onto some SSA disk, so we have to think about mirroring. Informix recommends Informix mirroring, and IBM recommends AIX (what a shock!). We are running AIX 4.1.4 and Informix 7.20 on an 8-way RS6000. Seems to me that AIX mirroring on …
Re: Rootdb
I just wanted to point out that currently we are using unix filesystem mirroring not Infomix's chunk to chunk mirroring. Rootdb is a raw space allocated for Informix and is managed by Informix. I am a bit confused as to why I need to do a dbexport. I was under the assumption t…
Re: Rootdb
I am making this public since I didn't see a lot of other answers float across and because it is a good thing to know how to do. If y'all would be good enough to comment on this we can clean it up and stick into the FAQ. ---- cya ---- I hope you understand that this note is st…
Re: Online 5.05 - bringing on mirrored dbspaces at a later date?
We didn't initialize our dbspaces as potentially mirrored, what can we do to get around this?…
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…
Informix 7.1 Mirroring question.
Hey all Informix 7.1, SCO Unix With Informix mirroring, if a chunk fails it's mirror will kick in seamlessly. How is the system notified of this event? Will it be a cryptic message in online.log?, will the console be informed? Any help greatly appreciated.…
Freeing up temp dbspace
I have on-line 7.11UC1 on Solaris 2.4 and I would like to know how I can free up temp dbspaces without bouncing the engine. It seems like one of my developers has a bad select statement and it fills up my temp dbspaces and crashes, but on-line does not clean after the crashed pr…
Mirrorring
Can anybody tell me how easy or difficult it is to convert unix (HPUX) filesystem mirroring to informix chunk-to-chunk mirrorring. Currently we have our raw data mirrored using the unix filesytem mirrorring and had couple of disk crashes and we had to restore the entire database…
Newbee with questions about physical and logical log allocations.
Does anybody have a good rule-of-thumb calculating the size of the physical and logical log sizes. Informix said the total physical and logical logs size should be 20% of the total dbspace dedicated to online. Informix also indicates that the ratio of logical to physical logs si…
Raid vs. Mirroring
Does anyone have any info reguarding Oracle7 and Disk Mirror or RAID. Pro's and Con's of using either one. Thanks in advance. Steven Ray SeatonCorp…
Re: Primary chunk - a misnomer
Keith Fang (fang@netcom.com) wrote: : >The chunks are known as primary chunk for the first chunk : >in a dbspace and secondary chunk for any additional chunks added. : >(This is not an exact quote, to avoid possible copyright infringements.) : > : >Bunk. Bull. Incorrect. : > : >…
Primary chunk - a misnomer
I was reading in the "Informix Systems Journal" dated July/August 1995. In particular, I was reading the excerpt from Joe Lumbley's book in this issue. He makes the following claim: The chunks are known as primary chunk for the first chunk in a dbspace and secondary chunk for an…
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: 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…
down chunks
Dear Calvin, About your question below. I have had a similar thing happen when a chunk was marked as down due to the UNIX file table overflowing. I was able to change the chunk status using dd and writing over the reserved pages. Hope this helps. But - this should only be done …
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?…
your CHUNK status is DOWN..!!
hi INFORMIX'ers what do U have 2 do when U come in the monrning and found the not mirrored chunk is down...!!!…
Re: Restructuring root dbspace.
shawn.raymond@CCGATEWAY.AMC.EDU ("shawn raymond") wrote: Please correct me if I'm wrong... Shawn I believe the only way out of this one is to re-initialise the rootdbs. Unless Informix have a tool I don't know about, you can't drop chunks. > Hi, > > We have 4 chunks in …
Restructuring root dbspace.
Hi, We have 4 chunks in our root dbspace and I would like to remove the last 2 and recreate the first 2 on seperate disks. How do you keep the reserved pages, the system catalogs and any other important information intact? Thanks for any feedback! …
Does mirroring slow down Backups?
Fellow Informix'ers, We have a database that uses Raw disks wit some blob chunks. This db is completely mirrored, and backups on this DB are really slow. There is another installation which is similar, except no mirroring. Backups at that site seem to be almost twice as fast. …
Re: dbexport/dbimport problems
On Wed, 25 Jan 1995, jerry wrote: > If I am not mistaken, the default location for a table is the same > dbspace as the database was created it, this is not always the > root dbspace. True. To clarify, If you create a database without explicity specifying a dbspace, it ends up…
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 …
mirrored chunks
Help please. We are running Online 5.02 for Interactive Unix. All of our database chunks (we have 11) are mirrored. Twice in the past four months, chunks have gone off line and we have had to restore from tape. Why would the mirrored chunk not have been used instead? When the c…
Re: HELP - Hardware mirroring versus dbms mirroring
> Cathy Kipp (ckipp@vth1.vth.colostate.edu) wrote: > : Joe Lumbley writes: > : -> > : ->Hardware mirroring is usually best, as it's faster. Next is HP-UX. > Last: ->comes OnLine mirroring. OnLine mirroring contains a little bit > of logic: ->regarding how to handle chunks that …
Re: HELP - Hardware mirroring versus dbms mirroring
> Question 1: For the disk array system I already have, is there a way to manage > the 4 disks, i.e. place dbspaces on each? Yeah - rip out the RAID architecture. Seriously though, you have just hit on the very reason why RAID architectures are (more often than not) bad news fo…
Re: Mirroring
}From: ckipp@vth1.vth.colostate.edu (Cathy Kipp) }Subject: Re: Mirroring }To: johnl@informix.com }Date: Thu, 18 Aug 1994 09:34:19 +22305606 (MDT) } }Hi John, } }Given all of the interest this topic seems to be getting, would you mind }if I sent out your reposnse to me publicly? …
Re: HELP - Hardware mirroring versus dbms mirroring
On Wed, 17 Aug 1994, Will Hartung - Master Rallyeist wrote: } } }From: ckipp@vth1.vth.colostate.edu (Cathy Kipp) } } } }Not to disagree with an expert, but I think it's important to mention here that } } }while hardware mirroring may be faster with the OnLine engine, under the 6…
Re: HELP - Hardware mirroring versus dbms mirroring
} }From: ckipp@vth1.vth.colostate.edu (Cathy Kipp) } }Not to disagree with an expert, but I think it's important to mention here that } }while hardware mirroring may be faster with the OnLine engine, under the 6.0 } }DSA engine, Informix miroring will offer some performance adva…
Re: HELP - Hardware mirroring versus dbms mirroring
Cathy Kipp (ckipp@vth1.vth.colostate.edu) wrote: : Joe Lumbley writes: : -> : ->Hardware mirroring is usually best, as it's faster. Next is HP-UX. Last : ->comes OnLine mirroring. OnLine mirroring contains a little bit of logic : ->regarding how to handle chunks that are down,…
Re: HELP - Hardware mirroring versus dbms mirroring
Cathy Kipp (ckipp@vth1.vth.colostate.edu) wrote: : Joe Lumbley writes: : -> : ->Hardware mirroring is usually best, as it's faster. Next is HP-UX. Last : ->comes OnLine mirroring. OnLine mirroring contains a little bit of logic : ->regarding how to handle chunks that are down,…
Re: HELP - Hardware mirroring versus dbms mirroring
}From: ckipp@vth1.vth.colostate.edu (Cathy Kipp) }Subject: Re: HELP - Hardware mirroring versus dbms mirroring }Date: Wed, 17 Aug 1994 09:03:53 +22305606 (MDT) }X-Informix-List-Id: <list.4531> } }Joe Lumbley writes: }->Hardware mirroring is usually best, as it's faster. Next is …
Re: HELP - Hardware mirroring versus dbms mirroring
Joe Lumbley writes: -> ->Hardware mirroring is usually best, as it's faster. Next is HP-UX. Last ->comes OnLine mirroring. OnLine mirroring contains a little bit of logic ->regarding how to handle chunks that are down, but with any luck the HPUX ->or hardware mirroring will ne…
Re: HELP - Hardware mirroring versus dbms mirroring
John Kozel (jkozel@bisfs01.den.mmc.com) wrote: : We have a HP 9000\\877 (I40) running HP-UX 9.04 with Informix OnLine 5.01 and : am pursuing purchase of additional disk storage and need some help. Currently, : we have a disk array (C2250A) which contains 4 drives and I, as DBA, a…
HELP - Hardware mirroring versus dbms mirroring
We have a HP 9000\\877 (I40) running HP-UX 9.04 with Informix OnLine 5.01 and am pursuing purchase of additional disk storage and need some help. Currently, we have a disk array (C2250A) which contains 4 drives and I, as DBA, and unable to do any data spreading since the 4 disks …
Need help, lost connection to dbspace |
Hi, I have an access problem with Informix Online V 5.01. I destroy my old root-dbspace, if I call tbinit. (Yes, I know that was a stupied operation) All database have their own dbspaces. My Question is, can I change internally the root-dbspace that I can recover my old database…
mirror sections
Based on our experience I'm not sure why I'm doing this, BUT I'm planning the layout for our new G30 system to include Informix mirroring. It's possible that I may not have exactly matching sections. Is that a problem as long as the mirror section is larger than the primary? Y…
"Manual" Mirror?
in Message-Id: <2shfoa$3it@raffles.technet.sg> scornd3@solomon.technet.sg (SCO R and D) writes: > Can anyone offer some ideas on the following. > > I will have two servers A and B. A is online committing transactions. > B is offline. At some point, a full backup of A's db wil…
"Manual" Mirror?
Can anyone offer some ideas on the following. I will have two servers A and B. A is online committing transactions. B is offline. At some point, a full backup of A's db will be effected to be duplicated into B. This is done, probably, with a tape. B is then relocated to a remote…
Mirrors
ID>Are we the ONLY ones experiencing this? Well, we have 8 drives mirrored using 4.1. Recently we had two drives fail (same mounting kit, same dodgy connector). The backup drives took over perfectly. When we replaced the primary drive connectors, Informix re-mirrored (about 1GB …
Mirrors
I understand that a few months ago, before I attained membership in this august group, there was quite a discussion going on regarding Informix mirroring versus hardware mirroring. Sorry I missed it. We're having a bit of fun on our own. Informix mirroring is NOT working for u…
Mirrors
I understand that a few months ago, before I attained membership in this august group, there was quite a discussion going on regarding Informix mirroring versus hardware mirroring. Sorry I missed it. We're having a bit of fun on our own. Informix mirroring is NOT working for u…
pathname of chunk
I recently changed the disk array which makes up my 1 raw device (1 chunk) with my rootdbspace and another dbspace. The chunk is slightly bigger than the one it replaced. 2 gig now instead of 1.8 gig. I dbexported the database before replacing the disk array, then re initialized …
Mirroring rootdb
Does mirroring rootdb make sense since the MTBF of hard disks are often over 100,000 hours? Mirroring rootdb is mainly for hardware failures. Are there any other advantages to mirroring rootdb other than for a hardware failure? Does mirroring degrade performance to any signif…
Re: tbcheck problems HP9000 G30
[ Bill Glidden writes: ] > Joe, > > It is because the physical log is not located in the root dbspace. It is a known > problem, and can be duplicated by creating an OnLine instance and moving the physical Can I have more specifics here. We are currently running many engines non…
Re: >RE:"Could not write to a temporary file" error
Every time that I've seen the Could not write to temp file error, it's been the root dbspace. Do 'tbstat -d' while you're running the pgm and see if any chunks get near 0 free ??? Bill *8o\\…
Re: On-line engine startup failure
Hal Wigoda (hwigoda@seg7.arlingtonhgts.mnc.mot.com) wrote: : We're trying to install the on-line engine on a new machine. : I think we've done everything right in terms of setting : environmental variables and tbconfig parameters and slicing and dicing : of the hard disk. : But w…
Unix or hardware mirroring vs. Informix Online mirroring
Is either one better than the other? Any comments or suggestions? -- Tom Lowe tomlowe@speedway.net or tomlowe@delphi.com…
Re: Aix Mirroring Vs Informix Mirroring
Tim Cargile writes: } >>Ellen K. Osinski (ellen@hpbs2571.boi.hp.com) wrote: } } >>: I can put in a plug for Informix mirroring. We have implemented mirroring } >>: on an HP9000/750. We had the primary go down due to repeated disk write } >>: failures and did not realize it fo…
Mirroring continued
} >>Ellen K. Osinski wrote: } } >>: I can put in a plug for Informix mirroring. We have implemented mirroring } >>: on an HP9000/750. We had the primary go down due to repeated disk write } >>: failures and did not realize it for a day or two. Informix chugged merrily } >>: al…
Re: Aix Mirroring Vs Informix Mirroring
>>Ellen K. Osinski (ellen@hpbs2571.boi.hp.com) wrote: >>: I can put in a plug for Informix mirroring. We have implemented mirroring >>: on an HP9000/750. We had the primary go down due to repeated disk write >>: failures and did not realize it for a day or two. Informix chugg…
Re: Aix Mirroring Vs Informix Mirroring
In <1993May20.144932.24838@ncar.ucar.edu> miker@ncar.ucar.edu (Mike Reetz) writes: >It is my understanding that in 6.0 Online with do reads from both the >primary AND the mirror. Of course this will only work if Online knows >about the mirror...so I think that at least under 6.…
Re: Aix Mirroring Vs Informix Mirroring
In article <C7BIIp.7r7@newsserver.technet.sg>, scornd7@technet.sg (Tang Chang Thai) writes: |> At my site, we are using hardware mirroring for HP workstations. It also |> works transparently. |> |> Ellen K. Osinski (ellen@hpbs2571.boi.hp.com) wrote: |> : > In general, operating s…
Re: Aix Mirroring Vs Informix Mirroring
At my site, we are using hardware mirroring for HP workstations. It also works transparently. Ellen K. Osinski (ellen@hpbs2571.boi.hp.com) wrote: : > In general, operating system level mirroring and hardware mirroring are : > more efficient than Informix mirroring, if only becau…
Re: Aix Mirroring Vs Informix Mirroring
> In general, operating system level mirroring and hardware mirroring are > more efficient than Informix mirroring, if only because they can schedule > writes to both the primary and the mirror disk concurrently, whereas > Informix has to write to the primary and then write to th…
Re: Aix Mirroring Vs Informix Mirroring
} } Jonathan Leffler (obelix.informix.com!johnl@emory.mathcs.emory.edu) wrote: } } : In general, operating system level mirroring and hardware mirroring are } : more efficient than Informix mirroring, if only because they can schedule } : writes to both the primary and the mirror…
Re: Aix Mirroring Vs Informix Mirroring
>From: uunet!GAN03X!spitz (Richard Spitz) >Subject: Re: Aix Mirroring Vs Informix Mirroring >Date: Wed, 19 May 1993 09:08:57 GMT >X-Informix-List-Id: <news.3374> > >Jonathan Leffler (obelix.informix.com!johnl@emory.mathcs.emory.edu) wrote: >: In general, operating system level mi…
Re: Aix Mirroring Vs Informix Mirroring
Jonathan Leffler (obelix.informix.com!johnl@emory.mathcs.emory.edu) wrote: : In general, operating system level mirroring and hardware mirroring are : more efficient than Informix mirroring, if only because they can schedule : writes to both the primary and the mirror disk concu…
Re: Aix Mirroring Vs Informix Mirroring
>From: uunet!evolving.com!gst (Giri Tirumale) >Subject: Aix Mirroring Vs Informix Mirroring >Date: Wed, 12 May 1993 21:21:19 GMT >X-Informix-List-Id: <news.3312> > > We are currently running on IBM RS6000 AIX 3.2 with Informix Online > 5.0. The database is on a raw disk. Does any…
Aix Mirroring Vs Informix Mirroring
We are currently running on IBM RS6000 AIX 3.2 with Informix Online 5.0. The database is on a raw disk. Does anyone out there have a preference for AIX Mirroring versus Informix Mirroring? Thanks in advance -- Giri -----------------------------------------------------…
mirrors
Naomi writes: > > [much talk about archive restoral limitations deleted] > > > This is why disk mirroring is provided. If you mirror your disks, it is > > extremely unlikely that you would lose both copies of any one disk at > > the same time, except as part of some much larger …
OnLine Mirroring
When you INITIALISE an OnLine system you can enable/disable the disk mirroring capability. If you enable mirroring you can later, optionally, enable disk mirroring of dbspaces. We have now decided not to employ mirroring of dbspaces. What performance overhead have we incurred be…
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. -- +--------------------+-------------------------------------------------------+ |…
Mirroring with Online
If, when setting the Online parameters, you request mirroring, and for the mirror's path you enter a link to a directory on another machine that is attached over a net, will it work? Nate…
Re: Performance in chunk vs. chunks?
>From: uunet!neptune.dsc.com!jbh (J. B. Hendrix) >Message-Id: <jbh.705287859@neptune> >Subject: Performance in chunk vs. chunks? >Date: 8 May 92 01:17:39 GMT >X-Informix-List-Id: <news.1216> > >My boss from the old school is concerned that a heavily used >DB spread across multipl…
Performance in chunk vs. chunks?
My boss from the old school is concerned that a heavily used DB spread across multiple chunks on separate partitions in the same disk will suffer performance degradation as compared to a single chunk for the whole DB (obviously a large chunk, about 150 Meg). My cohorts and I hav…
dropping a chunk
>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 thi…