Oninit® Archive
Results for “ROOTPATH”
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 …
Petty comments on Version 15 ...
Hi JJ, not seeing your 1., in none of my 6 or so v15 installations. not seeing your 2. either, after initializing (-ivy) using a 4k sector size disk for my ROOTPATH (and DIRECT_IO 1). I do see KAIO being added (queues, threads) once defining more chunks on other disks. And yes t…
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 …
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
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…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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
Hello. I have an Informix 14 FC8 on Windows host. I want to move rootdbs to another location. I changed ROOTPATH and moved file to another location. But the server can't start Onconfig parameter ROOTPATH modified from E:\\ifmxdata\\rootdbs.000 to E:\\ifmxdate\\ol_dohod\\rootdbs.0…
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 ------------------------------…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
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, …
down chunk
Informix 11.50.FC6 on HP-UX 11.31 PA-RISC We're working toward upgrading to 14.10 on Linux, but until then, we're running the environment shown above. Since 11.50 is way past EOL, we're kind of out of luck for support from IBM/HCL. If it was a production system, I might try to …
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
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…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
shmmax syntax in onconfig file
Despite the error in the log, shared memory is not your problem here. The file for the root dbspace does not exist. You are using the delivered onconfig file by the looks of it, and that expects an empty file to exist in the location specified by ROOTPATH - which you have set as…
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
Dear All, In my CentOS 7 linux server we installed IDS 12.10FC8. Now we need another instance for another database project. How to do this. I am very new to Informix. 1. What steps need to follow. 2. What are the prerequisites. 3. How to differentiate both configuration files l…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
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?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
Cluster project
Yes, it can be done. Each primary instance will have its own HDR secondary instance on the other machine. Set the following ONCONFIG parameters to be different for each primary server: ROOTPATH, DBSERVERNAME, DBSERVERALIASES, HA_ALIAS, DBSERVERNUM The ROOTPATH will be the same …
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…
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
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.…
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
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 ?…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Check list to Add a new instance
Just two more things: 1. set SERVERNUM to a unique number (at least unique on that machine). 2. Set ROOTPATH to a unique file 3. Create the ROOTPATH file 4. Optionally set the TBLTBLFIRST and TBLTBLNEXT parameters in the ONCONFIG file to set the extent sizing for the tablesp…
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…
Some help around ontape restore errno = 2
Hello, my friends. I am trying to help a client who wants to restore an old ontape backup, in HPUX. Informix backup was made in version 9.30.UC3, but the client installed 9.30.FC3. I can read from the tape device, even with informix user, through strings command (I can see the …
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.…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
Root db space fills up
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
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…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
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…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
upgrading 11.70 to 12.10
I want to upgrade 11.70tc3 to 12.10tc2 on a Windows server 2008R2 machine. I did this on my development server by using dbexport and then uninstalling 11.70 and then installing 12.10 and then dbimporting data. (As I recall, the installer would not do an upgrade over the top of th…
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…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
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.…
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
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…
recover SQLHOSTS file
Do the onconfig files also have that info?…
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
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 …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
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,…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
Re: help with informix on windows oncheck -pr erro
ok sounds like silly question but how do i find out what ONCONFIG variable is on windows ? which is likely to be correct set ONCONFIG=oncfg_apecert.0 ::set ONCONFIG=ONCONFIG.apecert…
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…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
IDS 7.31 UD5 data(base) recovery
hi, i'm looking for any solution which allow me to get database server online or export data from dbspace the state is as follows: # onstat - Informix Dynamic Server Version 7.31.UD5 -- Fast Recovery (CKPT REQ) -- Up 22:31:46 -- 98304 Kbytes Blocked:CKPT # ontape -a Perfo…
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 …
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
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…
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.
Look at the number and size of logical logs and the size of the physical log. Art On Oct 12, 2011 8:13 PM, "BRETT SIMPSON" <brett.simpson@actrol.com.au> wrote: > Requested 9661038K, ONCONFIG value 'ROOTSIZE' 2097152K. > > using onspaces -c rootdbs -p /database/chunk03 -o 0 -s 2…
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.…
ontape -p/r with changed ROOTPATH
Hello all. I'm having 2 IDS instances on the same Linux box here. Both of them meant to be a restored ( ontape -r or -p (doesn't salvage the logfiles) ) version of our live server. They are test00 and test01. Our live server uses /informix-live/devices/dbspaces as a ROOTPATH in …
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…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
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…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
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.…
Re: moving from raw chunks to cooked files
Oh, Forgot to mention something. You can't just change the ROOTPATH in the onconfig file and expect it to work. When the engine starts up, it reads only the reserved pages from the file pointed to by ROOTPATH to find the chunk table, once it does that the engine closes ROOTPATH…
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: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
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 …
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
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.…
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
reuse raw device
wrote: > Hi, > > the endian problem is clear, but the OS problem is not. > > When we use raw device, there is nothing to do with filesystem. Our > read/write operation on the raw disk is done by IDS itself. > So in IDS 11.5, the page size of new dbspace is configurable when it is…
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…
Configuring 2nd informix instance on the same serv
Still i am not able to solve this problem. I checked the permissions of the files and changed the ROOTPATH to /mount/fs1/informix/sportage2/server/rootdbs_sportage2 and ran "oninit -i". # ls -l /mount/fs1/informix/sportage2/server total 16 -rw-rw-r-- 1 informix informix 5478 Ju…
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 ?…
Chunk path rename - is it possible?
That's why it is ALWAYS recommended to use symbolic links for chunk paths NOT the actual device or file paths. What version of IDS do you have? If you are running IDS 10.00 or later, you can restore your last archive and remap the chunks during the restore (see the Backup and Res…
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…
Fake Informix Server
"oracle, old sherwoodian" <rana_gman@hotmail.com> wrote in message news:d8fce806-ff18-451f-9450-93a75b415f94@a39g2000yqc.googlegroups.com... > Hello, I was wondering if anyone ran into this condition! > I'm running Informix on Linux (Red Hat) OS. The boot sector and > Informix Se…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
HDR on same server
Hello all, IDS 11.10 FC3 on solaris 10 On my test server I tried to setup a HDR with 2 instances on same server using ontape and relative ROOTPATH. DRAUTO 0, DRINTERVAL 30 & DRTIMEOUT 30 for both instances. sqlhosts has entries for both the instances & corresponding entries in…
External Restoration
Hi, it only checks the value of the ROOTPATH parameter, i.e. the chunk path name. After all, this is a restore, and you can do it with the files still having a size of 0 (zero) bytes. The file (or raw device) has to exist, but it doesn't matter really, what is there. Especially…
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 …
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
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 …
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: 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.…
IDS 11 computer reboot problems
DENIS DIDEROT wrote: > My rootdbs is defined as > ROOTPATH /usr/local/ids/demo/server/online_root > However, it keeps looking for Primary chunk as /dev/online_root. > How do I prevent that? > Your ONCONFIG environment variable is not set to point to the actual ONCONFIG file, so i…
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 Restore to Different Instance - Same Host
Cynthia, For the instance that you are restoring to make the ROOTPATH the same as the source instance and use the -rename -f {filename}. Jeff Jeffrey J. Filippi Integrated Data Consulting, LLC 104 Cottonwood Dr. Streamwood, IL 60107 630-842-3608 630-497-1762 (Fax) jeff.filippi…
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…
IDS11 startup problems
ROOTPATH /usr/local/ids/demo/server/online_root…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
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…
onconfig recommendations
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 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
Moving a chunk from one logical Volume group to another.
I need to move a chunk from one logical volume group to another. I am running IDS 7.3 on HPUX 11i. My chunks were created using links to logical volume groups. Is there a command I can use to move the chunk.…
Re: Strange error when initialising (long)
< Snip > Check out what ROOTPATH should be set to when using cooked space. Admin Ref should give you the answer you seek.…
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.…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
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 …
oninit
Looks like a typo in your $ONCONFIG file for ROOTPATH. 'informix' not 'infomrix'. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of WAQAS ARSHA…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
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] …
RE: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
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…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
size of rootdbs
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 configuration) ? Find below the my onconfig file ..which i am using.. ROOTNAME …
Re: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
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…
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…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
RE: HDR problem with Windows
Guy Bowerman wrote: > 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? Yes, the directory name is the same on both servers. That is to say server2 has a ol…
Moving data between instances
You can use ontape with rename option: ontape -r -rename -f <chunklist> the format of chunklist file, for example, will be: /informix/data/instance1/rootdbs 0 /informix/data/instance2/rootdbs 0 /informix/data/instance1/dbs1 0 /informix/data/instance2/dbs1 0 /informix/data/instan…
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?…
Cannot connect from windows client to IDS 10 with sdk 2.9 on Linux
We are running redhat enterprise 4, and IDS 10. We just cannot connect via tcp from clients on our LAN. We HAVE set up INFORMIX SE on other machines in the past and had no problem. Now we are stumped. On past machines we have run SE and are used to seeing the sqlexecd demon, b…
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/…
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
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!…
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: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
Re: IDS New Feature Requests
I am wondering when you use O_DIRECT, how do you define ROOTPATH, for instance, in onspaces command. Any one can please give me some example. Thank you. On 12/13/05, Guy Bowerman <gbowerman@yahoo.com> wrote: > IDS 10.0 also has: > "Be able to use raw devices in Linux (O_DIRECT…
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…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
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…
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…
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…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > 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 tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > 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 > ====================…
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…
ONCONFIG - comments
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. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
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. Estoy dejando mi archivo ONCONFIG para…
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:…
2nd instance problem - still looking at 1st instance
After I set up one instance and everything seems to be working, I attempted to create a 2nd one. I have entries in /etc/services for both instances. I have entries in /informix/etc/sqlhosts for both. I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME and DBSER…
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
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. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
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. Estoy dejando mi archivo ONCONFIG par…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
from IDS 9.4 to IDS 10
The CHUNKPATHS (including the ROOTPATH) are independent of the installed Informix version (different INFORMIXDIR). They remain the same during an engine upgrade. Therefore you shouldn't make CHUNKPATHs dependent on IDS version directories - too late now :-) You keep the old path …
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
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…
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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…
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: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
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…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
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…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
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 …
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
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.…
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)…
create one more instance
no this is WRONG. create a new onconfig file set the SERVERNUM parameter to something other than the original (normally 0), set the new ONCONFIG INFORMIXSERVER variables in environment and onconfig script, set a new entry in /etc/services file set any other parameters you need …
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…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
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…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
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.…
Re: Problem installing IDS 9.40 on Linux
"Ph. Chantry" <nospam@nomail.com> wrote in message news:<bjn8ho$mn5$1@news-reader1.wanadoo.fr>... > > Maybe there is something wrong in environment. Try the sample sqlhosts.std > > and onconfig.std in $INFORMIXDIR/etc as templates for sqlhosts and > onconfig > > (in same directo…
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…
Re: Raw or Buffered device?
"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<bjrkjh$i2q$1@terabinaries.xmission.com>... > Hi Steven. > > It seems problem that you use Blocked device. > > Do you mean as bellow ? > > % ls -l /dev/rdbroot > crw-rw---- ....... > > % ls -l /dev/dbroot > brw…
Re: Raw or Buffered device?
It "shouldn't" cause you any problems. You could just link /dev/dbroot to /dev/rdboot if you want. However you can't just edit the config and restart it will get a bit annoyed steven wrote: > > Hi, group > > today i found another problem about my informix. The ROOTPATH pointe…
Re: Raw or Buffered device?
Hi Steven. It seems problem that you use Blocked device. Do you mean as bellow ? % ls -l /dev/rdbroot crw-rw---- ....... % ls -l /dev/dbroot brw-rw---- ....... If so, anyone can write on /dev/dbroot. /dev/dbroot is file system. It is not simple to change the ROOTPATH. I th…
Raw or Buffered device?
Hi, group today i found another problem about my informix. The ROOTPATH pointed to /dev/dbroot instead of /dev/rdbroot. in the manul, however, i see the chunks should be in a raw device. is this a problem? can i simplely correct the ROOTPATH to /dev/rdbroot with text editor …
Re: Problem installing IDS 9.40 on Linux
> Maybe there is something wrong in environment. Try the sample sqlhosts.std > and onconfig.std in $INFORMIXDIR/etc as templates for sqlhosts and onconfig > (in same directory) for minimal testing. In sqlhosts use server demo_on > with onipcshm, replace on_hostname with simple ho…
Re: Problem installing IDS 9.40 on Linux
> Maybe there is something wrong in environment. Try the sample sqlhosts.std > and onconfig.std in $INFORMIXDIR/etc as templates for sqlhosts and onconfig > (in same directory) for minimal testing. In sqlhosts use server demo_on > with onipcshm, replace on_hostname with simple ho…
Re: Problem installing IDS 9.40 on Linux
Ph. Chantry wrote: >> whats printed in the /tmp/af.3fce8fc file? > > 19688 lines... I send below the 120 first one. If you need more, let me > know. > Thanks, > Philippe Maybe there is something wrong in environment. Try the sample sqlhosts.std and onconfig.std in $INFORMIXDIR/…
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 ?…
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
Resizing chunks
Ok I have 6 chunks on a system that use only 25% of an available disk partition. I want to resize to use all of the disk partition Can I do this without interrupting the data. Note: each disk partition is only being used once at the moment. OR do I have to backup, delete, recr…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
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???…
Fw: duplicating a database
> web_djs wrote: > > >I'd like to make an exact copy of my current database and rename it to > >something else. How do I do this? > > Are you using relative pathnames for the chunks [onstat -d will show pathnames that start with a "."]...if so, Shutdown the instance -OR- use on…
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…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
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…
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.…
Migration from File Sys. to Raw Dev. storage mode
I am purchasing one tested procedure to migrate a complete Online which had been installed on a File System to a Raw device. I have an idea how I should proceed : -ontape -s -L 0 -onmode -ky -rename of the File System used by the Informix Intance -modify the ROOTPATH variable in…
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…
Re: oninit -v (Fatal error in shared memory initialization)
Grett; You are right. Thank you very much Randy In article <3A44837E.877A27F3@hotmail.com>, Brett Randall <brett_s_rREMOVECAPITALS@hotmail.com> wrote: > finderr 21 > -21 Is a directory. > > An operating-system error code with the meaning shown was unexpectedly > returned…
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…
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
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…
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…
IDS 730 Install Problem
The file /opt/informix/online_root/online_root must exists, have right permisions and MUST be FILE (not directory). I think that errno=21 is EISDIR (Is a directory). So as user informix do: cd /opt/informix/online_root rmdir online_root cat /dev/null > online_root chmod 660 …
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
Re: how to restore archive to 2 instances on same server
smooth1 wrote: > > Great until you start the instance from the wrong directory and > online flags all the 'missing' chunks as corrupt and you have to > restore from backup! > David, If you have read my original answer you should have noticed that the first sentence is a warning…
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
Re: how to restore archive to 2 instances on same server
Mladen Jovanovski wrote: > ... > > 3. In onconfig files for all instances use relative > pathname for ROOTPATH (only the basename of root chunk). > ie. > ROOTPATH=rootchunk > > 4. Initialize your instances from their respective chunk directories > with their respecti…
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.…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
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…
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…
Re: Error: dbspace chunk
From: "Jerry Chimutanda" <jerry@compcentre.uz.ac.zw> > >I have created my dbspace according to Joseph's advice (see below). >Now on running oninit -i, here is the Error message that I get. > >oninit: Cannot open chunk '/chunks/rootdbs'. errno=2 > > > > > > Extract from /opt/infor…
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…
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…
Raw DiskSpace for the first time
Hi there : This is the first time I try to use raw disk space instead of cookied disk space. My platform is RedHat Linux 6.2 and Informix IDS 7.2 . I have a SCSI disk at /dev/sdb and make a partition on it (sdb1) , and then set a link "rootdisk" to "/dev…
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…
RE: How to set up ROOTPATH's target file ??
1. I would suggest changing to a different path besides the default one. I personally do not like my chunks to reside in /dev 2. Most people use logical links to point to their chunks, making it easier to physically move the chunks around. 3. You can just use touch …
Where can I download Administrator's Guide ??
I want to thank Yndigos & Paul Watson's response to my previous post ... Now my question is how to complete ROOTPATH variable setup under Linux. The default value in 'onconfig' file is: ROOTPATH /dev/online_root The Administrator's Guide states that its permission under /dev shou…
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
Serious oninit -i problem?
In article <20000316143423.03156.00002712@ng-fo1.aol.com>, Watawinona <watawinona@aol.com> writes >ROOTNAME ? >ROOTPATH ? >chown informix:informix ROOTPATH ? >chmod 660 ROOTPATH ? > >Nona > >>Subject: Serious oninit -i problem? >>From: seanvw@my-deja.com >>Date: 16.03.00 19:53 W.…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
RE: NEWBEE: error on starting 7.31 on HP-UX 10.20
Pardon me for asking the obvious, but did you run 'oninit -i' to initialize the database???? Doug "William Rice" <ricew@operamail.com> wrote in message news:89ealf$1pv$1@news.xmission.com... > > From Admin Guide: > -- > ROOTPATH specifies the full pathname, including the device…
Dropping a chunk by force
how do u drop a chunk by force in IDS 7.31…
switching disks then restoring with onbar problems
ids udo 9.14UC8 on HP 10.20 platform i take an onbar -b -w and take offline. there are two dbspaces: "adsroot" and "adsdbs1" i rm the symbolic link to adsroot and relink to a new drive. i point the adsdbs1 symlink to another new drive. both these drives are newly created subdisks…
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.…
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…
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 …
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.…
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…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: 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…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
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…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
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…
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…
Fatal error in shared memory creation
I tried installing Informix Workgroup Server 7.30TC8 on Sun Solaris 7. i have made a user and group informix, set the path and informixdir-var, unpacked and installed the informix files, changed the onconfig (rootpath, servernum, dbservername) but when i try to initialize the ser…
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…
Initialization question
Hi! I'm trying to install IDS 7.21 on UNIX. I created file, named it 'ol_chunk' and concatenated it to /dev/null (don't know why... just follow the manual). And I set the ONCONFIG parameter ROOTPATH to this file. IS it enough? Will the oninit command create primary dbspace its…
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.…
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.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
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…
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: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
DBSPACE size
In article <37244F3E.301B4680@uco.es>, Aurelio <i52sacaa@uco.es> wrote: > > It is possible to create a rootdbspace during instalation larger than 30 > Mb ? > > Sure, Depending on how much space you have in the file listed in ROOTPATH (see your system admin?) in your $ONCONFIG…
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…
moving the rootdbs chunk
Does ROOTPATH point to the chunk itself, or a link to the chunk? If it points directly to it, I don't believe you can move the rootdbs chunk except by scrapping the server, re-building it and re-loading the databases. If a link, you can break the link, move the data with dd, th…
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…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
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 …
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
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…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
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.…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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: How to Create another instance of Informix?
dengelsen@my-dejanews.com wrote in message <6uq6ku$j3b$1@nnrp1.dejanews.com>... >Hello, > >How can I create another instance of Informix? We want Baan IV and Baan V to >work on one machine each in a seperate instance. Creating new informix instances is quite easy, and basically …
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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…
ontape question
question on how to do the following (dont have docs with me): two instances on the same machine, production and qa. take a level 0 archive of production using ontape. i want to "restore" the production data from the ontape to the qa instance but get the following message: Phy…
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: 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…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
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: replacing mounted rootdbs as raw diskspace
Neil Truby wrote: > > Art S. Kagel wrote: > > > Yes, raw space is significantly faster. To do this: > > > > 1) bring the engine down: onmode -ky > > 2) copy the rootdbs file to the raw device: > > dd if=/datafs/rootdbs of=/dev/rdsk/sd2d bs=2k count={rootsize in pages} > > > > 3)…
Re: replacing mounted rootdbs as raw diskspace
Art S. Kagel wrote: > Yes, raw space is significantly faster. To do this: > > 1) bring the engine down: onmode -ky > 2) copy the rootdbs file to the raw device: > dd if=/datafs/rootdbs of=/dev/rdsk/sd2d bs=2k count={rootsize in pages} > > 3) delete or rename filesystem copy of …
Re: replacing mounted rootdbs as raw diskspace
sukumar konduru wrote: > > Hi > > Our "rootdbs" has been created as mounted file system rather than raw > disk space. Our database is in another dbspace which is created as raw > diskspace. > > Is it really improves performance if we use raw diskspace rather than > unix file s…
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…
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 _____________________________________________…
Re: tbtape -r won't restore the online
Is the path (symbolic link) of your new engine ROOTPATH the same as it was on your old one? They must be the same path, and probably should be the same cooked size. Sean Bradley…
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…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: 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…
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
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: 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…
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: trusted user ...?
Art S. Kagel (kagel@bloomberg.com) wrote: : Zdravko Balorda wrote: : : > Now, I have another db called isp. I just patched a little : > the original config file, but now I get the following from : > server: : Sounds like you messed up the config file. Post it and we'll look it …
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: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
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…
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…
OnLine 7.20 problem
We have Informix ODS 7.20 UC2 on machine: HP9000 K260, HP-UX 10.20. The onconfig was copied form onconfig.std to the new and names were changed. The ROOTPATH is a cooked file. I initialized online 7.2 oninit -i and database engine not started. I get the following in the log: 1…
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…
Re: HELP! oninit -i fails...
OK, when you changed the names, you were just a little premature. You do have to change the ROOTPATH, but because you are initializing this new (test) instance, the engine will not know of any other dbspaces. You must first get the instance up and running with just the rootdbs …
HELP! oninit -i fails...
Hi... First off, new to Informix and medium UNIX. Machine: HP-9000 We have a version of Informix INstalled (7.1) and it runs fine. We want to put up a test version of 7.22 UC2. In doing this, we did a onmode -ky of our existing system. The target of the ROOTPATH is a cooked f…
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…
Re: Online: Bizarre disk interactions
Hi Cosmo, Okay, here is the definitive picture: 1. When accessing the primary chunk of the root dbspace, online uses the current ROOTPATH as defined in the onconfig file. 2. The value of ROOTPATH when the instance is initialised (oninit -iy) is stored in the…
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…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
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: 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: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Re: Restoring backup tape failure
jdevlin wrote: > > When I try to restore a full backup from tape I get the following > error: > > Restoring system control information, please wait ... > Rootpath = /dev/db/rootdbs,Offset = 0 K, Size = 102400 K. Mismatch in configuration file. > > My TBCONFIG environmental variab…
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: 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…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
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…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: Replication on the same box ????
David Williams wrote: > > Sometime I wish I would experiment rather than reading the manuals and > thinking I understand them. I just tried (~6:30pm today) to initailise > two Online Instances with ROOTPATH set to ./root1 in separate > directories. It worked! When the In…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: Replication on the same box ????
In article <54b8pu$2i8@news.informix.com>, Bill Glidden <glidden@informix.com> writes >: In article <3266976B.6779@geocities.com>, Manickam R Muthukumar >: <muthukumar@geocities.com> writes >: >Hi cid folks, >: > >: > I am having SUN 1000 with SUN OS, I am >: >wondering whe…
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
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…
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…
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…
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: A basic Online question
} I am trying to configure and start Informix-Online } } I have set up the environment variables.. Allocated Disk space } as Unix files.. Prepared ONCONFIG andchanged it to match the } new server name.. ROOTPATH etc.. } } } I have also modified the sqlhosts.. } } Now the quest…
Re: A basic Online question
: I am trying to configure and start Informix-Online : I have set up the environment variables.. Allocated Disk space : as Unix files.. Prepared ONCONFIG andchanged it to match the : new server name.. ROOTPATH etc.. : I have also modified the sqlhosts.. : Now the question: …
Re: A basic Online question
In article <1995Aug18.193537.22399@ccc.amdahl.com>, siva@oes.amdahl.com (Siva Ramamoorthy) writes: |> I have a real basic question... |> |> I am trying to configure and start Informix-Online |> |> I have set up the environment variables.. Allocated Disk space |> as Unix files.. …
A basic Online question
I have a real basic question... I am trying to configure and start Informix-Online I have set up the environment variables.. Allocated Disk space as Unix files.. Prepared ONCONFIG andchanged it to match the new server name.. ROOTPATH etc.. I have also modified the sqlhosts.…
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?…
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! …
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
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…
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…
Thanks: re - Online 5.02 problem
Thanks a lot for all those who responded to my call of crisis. The problem was with the way the raw device was linked and how it was referenced in the tbconfig.std file. I basically, trashed the original link (which was created using a dummy file called…
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…
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 …
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\\…
Default dbspace?
This has probably already been discussed to death, so please reply by e-mail. Is there a way with OnLine v4.0 or v4.1 to make the default dbspace something other than the root dbspace? Thanks. -- +--------------------+-------------------------------------------------------+ |…
Re: 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…