Oninit® Archive
Results for “ROOTOFFSET”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
Re: Checkpoint durations
Hate to say the obvious, but... you could try upgrading to IDS 11 and not worry about checkpoints at all since it has nonblocking checkpoint technology. It also includes automatically configuring LRU flushing and lots of nice performance features. Just a suggestion :) On Nov 29…
Re: Checkpoint durations
>> "Art Kagel" <art.kagel@gmail.com> wrote in message >> news:mailman.400.1228011609.874.informix-list@iiug.org... It's telling you that it takes about 3.2 seconds to write 500,000 Informix pages to disk on your SAN Taking half of the dev/null time as reading time and half as wri…
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 …
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 ------------------------------…
Informix recommended setup for storage
Hi everybody, we are planning a new database server (pair, should be HDR) for a huge customer. Our admins started a discussion on how to configure storage. We want to have ~6TB of space and are planning to be running with a set of NVME Raid (Raid 10, 5 disks e.g. 5x3.8TB like Sam…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
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. --------…
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, …
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Spaces and Spindles: Thought Experiment
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
Moving the logs, or not?
Hello. There are no performance benefits on your case. But, as a best practice, is always recommended, easing administration (you can even use an auto-extendable dbspace for your logs and their chunks). It might be painful to grow your root dbspace, let it simple. My opinion? K…
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Creation of another IDS instance
Hi, assuming you want to create the second instance with the same version of Informix: - use the same directory where informix server is installed, i.e. $INFORMIXDIR is the same. - choose a different SERVERNUM (server number), - choose a different server name (and set $INFO…
onload questions
IDS 11.50.FC5 Solaris 10 I sent this in a couple of days ago, but I never saw it posted. --- I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace infor…
onload - onunload
IDS 11.50.FC5 Solaris 10 I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace information? How does it know to send the tables to the different dbspaces?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
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…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Informix 12.10 Segfault on CentOS7
Get 12.10.FC6X5 from Fix Central: the root offset bug in 12.10.FC6 is quite nasty; it's only safe to use this version id ROOTOFFSET is 0 in your onconfig. Ben.…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
Some help around ontape restore errno = 2
Hi, the layout of data (and its structure) on disk are fundamentally different between a 32-bit and a 64-bit Informix server. Therefore restoring a 32-bit archive to a 64-bit server does not work. Using "dd" to disk or similar attempts will not change this. To restore this arch…
Performance issue
The stacks that you printed are from writes to the physical log and the logical log. If you are seeing them a lot, then I would suspect the following... 1) your logs are on the same physical device as chunks that you are doing a lot of reads from. 2) Your logical/physical log bu…
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.…
dbspaces corrupted
We have Version 11.70FC4 sitting on a Red Hat 5.9 server that is, in turn virtualised. All dbspaces are on cooked file systems. We had a process that blocked the server using "onmode c block" followed by a level 0 backup using "ontape s L 0". At some point during the backup,…
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
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…
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,…
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…
IDS 7.31 UD5 data(base) recovery
Hello Marcin, when i read this: > # ontape -a > Performing automatic backup of logical logs. > Please mount tape 1 on /usr/informix/ltapedev and press Return to it sounds like that your LTAPEDEV is set to /usr/informix/ltapedev in your onconfig file. if that ist the case you …
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
chunk list when system down
Oncheck -pr should work fine if your system is down. If you are core dumping, I suspect wherever your rootp[ath at rootoffset is pointing to in your onconfig is corrupt. Assuming you have the onconfig set correctly??? Dan -----Original Message----- From: ids-bounces@iiug.org [m…
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
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 …
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
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…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
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…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
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.…
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…
Onload, the "fast" alternative
Hello Neil, my 2 00.1 first: do not use onload/onunload unless there is really no alternative. in the past you could not put tables in different dpspaces etc. i would gofor scripting using HPL etc. a decade ago i helped migrate a database using HPL and simple sql which was 1 T…
dbspace planning
Hello, I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices. Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP? I'm planning layout below: disk 1. rootdbspace, phys log, logical …
Performance advantage: fragment across dbspaces vs. in single space
Is there any advantage to fragmenting across multiple dbspaces instead of simply fragmenting in the same space? Aside from performance, are there any other reasons to fragment across dbspaces? Using IDS 11.50.FC4 on HPUX 11.23.…
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…
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
oninit -ivy error Warning: stat() failed for chunk
Please verify that all the directories in the rootpath are tranversable (x) by user informix. Regards. On Sat, Nov 27, 2010 at 3:52 PM, BILL MARSHALL <cwm@stober.com> wrote: > I have just installed informix 11.5.FC5 on a red hat enterprise 5 (64 bit) > machine that is currentl…
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
Config
Just glancing, but your BTR looks a little high. Some config suggestions below. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on …
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
optimum usage of resources
> sorry actually I wanted to ask "How do i make use of more Processor > Resources" Increase the workload? Informix will use your CPU resources if it needs to. You could add a million CPUVPs and get CPU utilization up to 100% because more work is being done to coordinate these m…
Raw Devices
Currently we are using our database on IDS 11.50.FC6 and our dbspaces are on UFS file system.Can we transfer our existing dbspaces on raw disk and how we do it , Also how much down time is expected.…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
My Mul-Threads Data Export Tool
Hi, everybody, I'm a new guy here. First of all, my English is poor, I'll try my best to explain my tools. Ignore my spell and grammar errors please :D In these days, I study IDS socket communcation package and disk storage structure, and write 2 tools. One is fake a user and co…
Informix Chunk Size - 1 big or manysmaller
If you are talking about multiple chunks on a single spindle, you may be correct, however, if the chunks are allocated from a RAID array located on a SAN with extensive non-volatile cache memory, then you can absolutely push more data down to it than a single thread can handle. A…
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
Data migration Brainstorm.
Hi, focussing on the term UPGRADING (all at once - Servers, OS, Informix). If the hardware is compatible (CPU and OS-Type the same, or 100% compatible for data like PA-Risc and IA64 under HPUX) and you are happy with your database layout (chunk names, dbspace sizes, etc. ) you …
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…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: how many logs do i need
Hi. Details are in the Administrator Guide of the corresponding version. Even there are formulas which lead you to a concrete number, but it's focused on day-to-day performance tunning. I've had same problem - rebuilding huge tables under a transactional database - and I …
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
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…
ER Error Enterprise Replication
bozon wrote: > Enterprise Replication is giving the following message when I do a > simple cdr list server > > ndl12:ndl12a common_reporting$ cdr list server > SERVER ID STATE STATUS QUEUE CONNECTION > CHANGED > --------------------------------------------…
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
onint - cannot open chunk error 2
Also - is ROOTOFFSET set to something other than 0? if it is account for that in your dd cmd. It's either seek or skip - kind of important to figure out which one :-) Mike…
slow views on IDS 11.50FC1
On 7 Oct, 22:30, ralf.blankenb...@eurotaxschwacke.de wrote: > Hi, > changing from 10.00FC4 to 11.50FC1 causes a "select * from view_XXX" > to run more than 2 hours. On 10.00FC4 this select took not more than > 10 minutes.An unload directly from the tables with the same select > s…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Re: Long checkpoints
On Sep 10, 4:47 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > askel wrote: > > Hello there, > > > I've been reading about long checkpoints issue for a while but haven't > > found solution for our case. > > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fir…
Long checkpoints
askel wrote: > Hello there, > > I've been reading about long checkpoints issue for a while but haven't > found solution for our case. > > We're using IDS 9.40.FC6 on Solaris 9 for OLTP. It is Sun Fire V1280 > with 8 UltraSPARC-III+ 1.2 GHz and 16 Gb of RAM on board. The database …
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > I presume tha…
Re: informix 9.3 to 9.4 issue
analog todd wrote: > Hello, > I'm having some serious issues with a production instance of Informix > and I can't figure out why. > I'd been running 9.30.UC7 for over a year solid, no complaints. > Monday night, I installed 9.40.UC8 and its been awful. What am I > missing? I've…
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…
Informix 10.0 FC4 & Solaris 10
Hi, I do not think there is a "correct" way to set up a Solaris 10 for Informix. If you have a dedicated server for one instance, there is no need to have multiple zones defined. We have some Solaris 10 machines running very good without any zone definition (dedicated to one ins…
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…
Disk layout for new install of IDS 10 on Linux (SLES 10)
On Jan 16, 6:16 pm, Richard Spitz <Richard.Sp...@med.uni-muenchen.de> wrote: > Dear Informixers, > > I'm about to install IDS 10 on a shiny new server running under SuSE Linux > Enterprise Server 10 (SP1). The predecessor machine had IDS 7.31 under SuSE > 7.2, so I was restricted…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
Re: Strange error when initialising (long)
i guess file /informix/data/ returns a directory oninit: Cannot open chunk '/informix/data/'. errno = 21 > ROOTPATH /informix/data # Path for device containing root dbspace -----------------------------------------^^^^^^ should be a file or better a char mode raw dev …
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
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…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
shared memory not initialized
Please try disable randomization of the virtual address space. On CentOS and RedHat 5 this can be done for a new shell: setarch i686 -R sh or setarch i686 -R -L sh from which IDS can be started. On some CentOS and RHEL5 systems users reported shared libraries are loaded near…
oninit -i failure
Found the problem I had $ONCONFIG=/opt/informix/etc/onconfig. Should have been $ONCONFIG=onconfig On Aug 8, 2:03 am, tom.pri...@gmail.com wrote: > I'm trying to startup informix for the first time on a CentOS 4.5 > server. When I run oninit -i , I get the following error: > > …
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
Re: IDS 9.4 instance can't initialize dbspace
Gary Quiring wrote: > Continuing the saga from my ontape restore to a different server I am > taking the suggestions to use archecker and IDS 9.4 to do a table > restore. My current server is 9.4. > I created an IDS 10 directory and changed all the paths and ENV vars to > use …
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…
Sysprocbody is full - how to get more space???
Bret Schuhmacher wrote: > Thanks very much, Jonathan! I think I've done what you recommended, but I'm > still getting the same error. I did the following: Please post the following: onstat -d Output from the following select: dbaccess sysmaster - <<EOF select dbsname, tabna…
Re: New IDS Server: 32 or 64bit?
Do you know where I can download IDS 9.4? Thanks. On Mar 28, 7:34 am, Richard Spitz <Richard.Sp...@med.uni-muenchen.de> wrote: > Dear Informixers, > > we've been running IDS 7.31 engine on a Linux machine (SuSE 7.2) for over > 6 years without any larger hassles. Now I have an o…
New IDS Server: 32 or 64bit?
On Mar 28, 7:34 am, Richard Spitz <Richard.Sp...@med.uni-muenchen.de> wrote: > Dear Informixers, > > we've been running IDS 7.31 engine on a Linux machine (SuSE 7.2) for over > 6 years without any larger hassles. Now I have an opportunity to upgrade > to IDS 10 on a new(er) machi…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Files in /tmp
Hi, Could it be something like temporary sort-work-files ? No place anymore in temp dbspace so files are created in /tmp ? Do you have DBTEMP and PSORT_DBTEMP variables set ? Jacques Lapeire -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] …
Error while access Tables using Crystal Reports
i would look in: C:\\tmp\\af.414fe6c which has more info. also phone tech support. it sounds like the optimizer barfed on something. an example could be that npused on the partition page of the accessed tables ended up being negative or???? this may cause bad stats. you could t…
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
oninit startup failure
Is this the first time you've tried initializing after installation or is this an existing instance which has just stopped working? How much physical memory on this machine? Disk space ok? What is the exact IDS 10 version? Are you running this directly or via Remote Desktop or s…
IDS 10 instance can't initialize dbspace
HI, Reduce your PHYSFILE 1008538 # Physical log file size (Kbytes) to a small value! Frank On 5 Jan 2007 13:52:28 -0800, Gary Quiring <gquiring@gmail.com> wrote: > > Continuing the saga from my ontape restore to a different server I am > taking the suggestio…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
size of rootdbs
On 30 Nov 2006 01:26:14 -0800, doitman <sunil.saggar@gmail.com> wrote: > Hi all, > > What should be the size of rootdbs .I mean the optimum size. > How does the size of rootdbs affect the IDS performance? > It is takijng a lot of time to initialize ..Is it normal(as per my > con…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Re: AIX and Informix
Hi, With regard to an ROOTOFFEST of zero. This is because the LVM uses the first 4 Byte for information. If you use a root offset of zero is used, and any LVM work is done, like a lv copy for example, the 4 Bytes will be written back to the device, resulting in the engine fail…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: tblspace tblspace extent size calculation for
You'll need one page for each table or index fragment in a dbspace. So, if you can guestimate how many tables/indexes/fragments you will ultimately have you can figure it out fairly precisely. Otherwise, ... Art S. Kagel ----- Original Message ----- From: Peter J Diaz De Leon <i…
tblspace tblspace extent size calculation for IDS
Does there exist calculations (or rules of thumb) for determining what the initial and next tblspace tblspace extent sizes should be for both the Root dbspace and non-Root dbspaces. Thanks Peter…
mirroring dbspaces
Hi all, anyone having experience with mirroring ? I inherited an informix config from a former collegue, and it looks very strange and insecure to me. In short : system running Solaris 8, 2 disks. All slices EXCEPT slice 6 (used for Informix raw-devices), are mirrored with Sol…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Can't drop down dbspace
I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Quick Ontape -r rootdbs question
Hi, If you attempt to use the ontape -r with redirection of the chunk names parameters for a specific database, is there any effect on rootdbs for the other databases? In other words if we have a 2 server set up described below and restore one dbspace, will ontape also restore th…
TEMP DBSPACE
Hi we have two quries like below create temp table tmp_table_no ( sl_no serial, lang_a char(2), lang_no char(14), rec_cnt integer) with no log second one is insert into tmp_table_no (lang_a, lang_no , rec_cnt) ", select distinct language_a, lang_no, count (lang_no) from ti_lang…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
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…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: 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…
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…
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…
IDS 10 disk configuration
We are migrating one of our HP-UX 11i database servers to a new disk array and upgrading it from IDS 9.3 to IDS 10 at the same time. Current disk array is an attached SCSI RAID 5 array, forgive me Art. The new array is a HP XP128, RAID 5 as well but it was installed before I had…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Database and no dbspace
Help. The dbspace is drop but now the database can't be drop. How do I drop/remove the database. I have created the dbspace but no luck. error: 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
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
Should have qualified my comment on rootoffset. I assumed you are using KAIO and raw disk because your NUMAIOVPS is so small - in this case rootoffset is important. Especially since the first 13 pages of rootdbs are the crucial pages. If, on the other hand, your are using AIO (in…
Re: RE: New installation
Yes. In fact, one can automate the process with onparams, which automatically (it or by side effect) change your onconfig file appropiatly. J. -----Original Message----- From: Mike Dunham-Wilkie <mike@barrodale.com> To: "Murray Wood \\(IList\\)" <ifxmaillist@quanta.co.nz>, <in…
RE: New installation
Brian You have told Informxi to create a dbspace on 60Mb. Yet the initial contents of rootdbs in your ONCONFIG add up to 161Mb. It will not fit. Think you may want to set ROOTSIZE to 512000 MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Re: Informix dbexport & dbimport Problem
Oh man, you REALLY need to take my internals class in Denver, this is all covered there. It looks like someone sent you their chunk files. Do you even know what version owned that engine? If not you can guess by running the following: dd if=csdata/ifmxdata/rootdbs_dat.000 bs=…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Multiple informix installations.
Hi, I found a file named "onconfig" and other named "porto.onconfig" that have both defined this variables: ROOTNAME rootdbs ROOTPATH /dev/ridsporto ROOTOFFSET 4 DBSERVERNAME porto MSGPATH /informix/portoonline.log ... > dd if…
Multiple informix installations.
Nuno Paquete wrote: > Hi group, Look in any onconfig files you find, usually named onconfig.<servername> and stored in the installation's etc subdirectory. In each is a config paramater ROOTPATH. This is the first disk space allocated to the server. Step one, see if ANY of tho…
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…
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…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: Config for new live system
On Fri, 17 Sep 2004 03:28:11 -0400, Neil Truby wrote: Hi Neil, All good advice, but reading it all to filter my own responses takes to much time, so here's my partially redundant, take: > I'm implementing a brand new system for a brand new Informix customer soon. > It's an on-…
Config for new live system
"Davorin Kremenjas" <davorin.kremenjas@inet.hr> wrote in message news:cie5jj$8lk$1@bagan.srce.hr... > I suppose I won't be much of a help but I'll try... > > > ROOTOFFSET 0 # Offset of root dbspace into device > > We had problems on Solaris 9 with zero offset. …
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…
Re: Questionable IDS 9.21 performance on HP-UX v11.11
On Fri, 27 Aug 2004 02:19:47 -0400, Jason wrote: > Greetings all, > > We're having severe performance problems with our OLTP Delphi app that > connects to IDS via ODBC. > Having researched the problem I can find no glaring operating system or > database-configuration issues > as…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: IDS9.4/AIX5.2 performace degradation
Dalibor Krleza wrote: I may have missed it in your long post, but I didn't see anything about disc layouts or number of CPUs. Also I may have missed it as well but I couldn't see any output from "onstat -g iof" or "onstat -g iov". I have commented on your onconfig anyway. > OK …
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
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
Unable to initiliaze informix instance
I have found the problem. It was with the slice, which my system admin has configured it for informix chunks were not properly configured. thanks for ur help, advice and suggestions. Regards, Shailesh M Jonathan Leffler <jleffler@us.ibm. To: "Shailesh.Mo...." <Shailesh.More@ril…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: high buffer wait ratio
Hi all, Thanks for the advise given to me. I have made some changes as below and seen some improvement on the database engine. 1)Increase Buffer by double. 2) Reduce the RA values by half. 3) Reduce the LRU_MAX and MIN to 1 and 0. At the same thing, we also going to re-configu…
RE: Performance advice
On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp tabl…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
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…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
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…
dbspace destroyed
Hi! On one machine dbspace was destroyed by unwary sysadmin who repartiioned disk with informix chunks on it (raw devices). Now, informix can be started (it complains about missing chunks though). What is the procedure for removing staled information for chunks? I should remov…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
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…
big dbspace
Hello, I need a very big dbspace (at least 15Gb) for my database (IDS 9.4) but the limit for a single dbspace is about 2Gb. How can I increase this limit? thank you…
SPINCNT configuration parameter in 5.10
L H wrote: > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > news:blnfj7$ef7j6$1@ID-64669.news.uni-berlin.de... >> L H wrote: >> >> > Informix Version 5.10 >> > Hardware: HP-K 4-way that was upgraded from a single cpu. >> > OS: HP-UX 10.20 >> > >> > The applicatio…
break one dbspace in to two dbspace
Hi all I have one dbspace where I have all data and indexes I wanted to created one more dbspace one dbspace has the data in it one dbspace has the indexes in it how do that ? regard sending to informix-list…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Reg: Max size allowed in creation of dbspace
Hi , I need to create a dbspace of abt 5-6 GB. on using onspaces to create the dbspace i am limited in size to about 2.09 GB is there a way to create a dbspaces of about 6 GB or is there a size restriction ? Thanks for any help Sudhir sending to informix-list…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
RE: Split Up PSApBTAB dbspace [1336]
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_01C3340F.D2B8B520 Content-Type: text/plain; charset="iso-8859-1" Hello all, I have some clarification queries on th…
Split Up PSApBTAB dbspace
Hello all, I have some clarification queries on the above topic. It will be great if someone can clarify my query. In our setup, We use the LVM say VERITAS volume manager for database volumes configured with RAID 10 and striping . We created the volumes using LVM in such an ord…
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
RE: Informix Hardware setup help
Michael, We use HDR here in a critical production environment. HDR is easy to set up and maintain, and is very bullet-proof. Yes, HDR can be run across slightly different hardware platforms, but they should be similar. We run ours on HP K-class boxes; different model numbers,…
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…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Re: Root DBspace confusion
Mark, I like your suggested clarifications for this paragraph -- to not say "resize", but instead say "use a minimal log size when you first initialize the database server", and then do all the steps to move and resize the logs after initialization to keep the root dbspace small…
Re: Root DBspace confusion
> > Hi Michael and Mark, > > Yes, this paragraph does not address what to do when you resize the > root dbspace after you've already defined your dbspaces, chunks, etc. > This section addresses sizing estimates BEFORE you start the > database server the first time. We recommend …
Re: Root DBspace confusion
Hi Michael and Mark, Yes, this paragraph does not address what to do when you resize the root dbspace after you've already defined your dbspaces, chunks, etc. This section addresses sizing estimates BEFORE you start the database server the first time. We recommend elsewhere tha…
Re: Root DBspace confusion
Michael Hoffman wrote: > > Hi all, > > A bit of confusion upon reading the Administrator's Guide prior to > installing IDS 9.2. (After reading the following I went back to the 7.3 > manual and found the same passage) > > In Chapter 14 (Data Storage): > If you plan t…
Root DBspace confusion
Hi all, A bit of confusion upon reading the Administrator's Guide prior to installing IDS 9.2. (After reading the following I went back to the 7.3 manual and found the same passage) In Chapter 14 (Data Storage): If you plan to move the physical and logical logs, the init…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Informix/Baan/AIX Performance
"Anderson, Andy" wrote: > > We are experiencing performance issues since upgrading to AIX 4.3.3 from > 4.3.2. The Informix database configuration has not changed and all the > latest patches/fixes have been applied to the OS. We are running on a > AIX4.3.3 / Informix7.31.UC3X1 / …
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
RE: On the behalf of another hapless soul, v.5.10 issue
This sounds like an OS tcp configuration problem, the users that can't reconnect are problem being blocked in some sort of FINWAIT type problem, what are you seeing on the netstat when this occurs and what are your kernel tcp settings Paul Watson WF Software Ltd Tel: +44 1436 67…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
RE: 2-disk layout
If you were doing RAID 1, you would have 9GB of usable space. This is because you would mirror 1 9GB drive to the other There would be no ability to spread the load across the drives. This would be fine with me seeing I am a bigger fan of not doing restores than I am of a some…
2-disk layout
In article <8muoik$ttd$1@nnrp1.deja.com>, Thanh <tqma@my-deja.com> wrote: > I need to come up with a 2-disk (2 9GBs) layout for IDS 9.2. > Let's say I have a database of up to 6GBs. I have identified > 4 other chunks (each with its own slice of 50 MB) that can > be added to the…
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…
Re: How Much space do I really have?
From: "Loven, Isaac" <Isaac.Loven@team.telstra.com> > >An ontape -s to disk takes up 500Megbytes. >If this is so, why does onstat show we have used 49.8% of the disk >????????? Because you have your physical and logical logs in the rootdbspace!!!!!!!!!! >We have a 2 Gig Disk a…
How Much space do I really have?
ontape backs up only thoise pages that have ANY data in them. You may have a fragmented database with many pages substantially less than 100% full. nonetheless, these will show up as "used2 by an onstat. Also, your logical and physical logs may not be backed, depending upon the…
Re: Performance comparison btn Informix and SQL Server
From: wu@paris.dvs1.informatik.tu-darmstadt.de (Ming-Chuan Wu) > >I include the outputs of the onstat's cammands as follows. >The onstat's commands are given, while the IUS is running my test queries. > >---include begin >==========================================================…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
IDS 7.31 on DEC Unix
About month ago I have performance problems on 2 CPU DEC Alpha and one of advises was to add more CPUs. So we change old one Alpha with new one. New is Alpha 4100 with 4 CPUs and 2G of RAM. KIO is enabled. Now I have some problems: *************** 1. problem *******************…
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: RE: Error: dbspace chunk
From: "Richard harnden" <harndr@russelleurope.com> > >Nah, he's just following Joe's advise - which was to touch a file called >rootdbs >in a newly created /chunks directory. > >So /chunks/rootdbs will have a size of zero. Which is less than 20000. :-) oninit -i will grow the f…
Re: RE: Error: dbspace chunk
Nah, he's just following Joe's advise - which was to touch a file called rootdbs in a newly created /chunks directory. So /chunks/rootdbs will have a size of zero. Which is less than 20000. :-) >>> "Obnoxio The Clown" <obnoxio@hotmail.com> 06/09/00 10:35am >>> Uh. /chunks/root…
RE: Error: dbspace chunk
Uh. /chunks/rootdbs isn't what's in his "extract from onconfig". So he must be using a different onconfig..... >From: Watson Paul <Paul.Watson@fefc.ac.uk> > >Can you dd in from /chunks/rootdbs as informix?? If you can't you have a >permissions problem. > >Paul Watson …
RE: Error: dbspace chunk
Can you dd in from /chunks/rootdbs as informix?? If you can't you have a permissions problem. Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # forever www.wfsoftware.com # --…
RE: Error: dbspace chunk
Jerry finderr 2 will tell you that the file /chunk/rootdbs does not exist All this information is on your server to help you. Read the admin guide, release notes on setting up a new instance. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-…
Slow loading/lots of checkpoints
First please do not post MIME, this is a text only newsgroup. Also your attachement is not easily retrieved. The too frequent checkpoints (I assume you have CKPTINTVL set to 10-15 minutes {600-900 secs}) are caused by the PHYSICAL log being too small. Check this by running onst…
Re: Error: dbspace chunk
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. # A warning that all existing servers will be dropped appears Assertion Failure Type:\\t\\c Warning Hostname:\\t\\tpluto # hostname=pluto Database…
Re: Error: dbspace chunk
To initialize Informix you must be user informix and the environment variables must be correct. Please refer to my responses below. Don Jerry Chimutanda wrote: > Hi people, > > I'm in my 4th weeek trying to get Informix up and running! > > The following are extracts from some…
RE: Error: dbspace chunk
> Hi people, > > I'm in my 4th weeek trying to get Informix up and running! :-)). The value of manuals ? > > The following are extracts from some of my configuration > files that I think > will help you diagnose my situation: > > Extract from /opt/informix/etc/onconfig > > ROO…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Cooked File system question
Don Bryant wrote: > > My site is using Informix DWS v.7.3 on a Sun 3000 running Solaris 2.6. Our > data is stored on an A5000 disk array with 14 drives. We are considering > upgrading the SCSI controllers so that we can have redundancy to that device > in case one channel (contro…
Layout disks
Christian Kondo wrote: > Hi everybody, > > I´ll have to configurate the layout disks in my system. We are upgrading our > machines, and we´ll use SHARK storage server. (its works the same way EMC). > My database size is about 400 Gb with SAP, I´ll have to use an IDS 7.30.FC10 > …
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Role of DBSPACETEMP (II)
Henk van der Geld wrote: > If I create a temp table and DO NOT specify the WITH NO > LOG option, the temp table will ALWAYS be created in the root dbspace, > even if I specify DBSPACETEMP=tempdbs in my environment. BUGS FIXED IN THE 7.31.TC5 RELEASE 116590 TEMP TABLES WITH L…
Re: Setting up Rootdbs on a raw disk
Could you post the exact error message (just copy&paste) you receive from oninit and any messages you get in your online.log file ? On Thu, Jan 06, 2000 at 08:21:33AM -0700, Anne Shelp wrote: > > > >>>> Octav Chiriac <com@netinfo-moldova.com> 01/05/00 11:47PM >>> > >It could be …
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
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…
Re: checkpoints taking as much as 25 secs
Try modifying your LRU's to something like 63. Make your page cleaners equal to your LRU's value. I find I get considerable performance from my server set this way. As well, checkpoints on high end machines running hundreds of users using ~10GIG+ databases range from 1 -2 secs. …
Setting up onconfig
Steve burk wrote: > 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 # P…
RE: Replication and HDR
OK, here's my .02... I am currently responsible for four HDR-pairs of servers -- three production pairs and one development pair. All servers are HP boxes, but I'm sure that most of this will apply to AIX, too. For each production server-pair, one server is in Sacramento, CA, …
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…
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
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: Using Large Disks under Solaris
Define chunks of any size, but use offset and length when defining dbspaces, will that work ? depends on informix accepting offsets greater that 2GB. -----Original Message----- From: Paul watson [SMTP:watsop@russellcorp.co.uk] Sent: Tuesday, October 26, 1999 11:24 AM To: rich@ai…
Re: Using Large Disks under Solaris
Firstly you can have 8*2GB paritions, slices 0-7 inclusive, so you'd loose 2GB per disk. To use the whole disk you need some form of LVM, either DiskSuite (free with Solaris) or Veritas (you have to pay for it). Apart from cost element DiskSuite and Veritas have other differenc…
dbspace not empty
Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I ca…
Re: move dbspace/chunks on NT
Jay Walters wrote: > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? > > TIA, Sure. Save data from the dbspace containing your chunk (dbexport, unload, onunload). Remove all data from the dbspace. Drop …
Re: 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…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
Root partition
Root partition? If you mean root dbspace, then you can add a chunk without any problem. I don't know about increasing the size of the initial chunk. -- Bashar Chalabi CTL, London Webber Valerie H wrote in message <7oumlp$ib$1@news.xmission.com>... > >Has anyone had experience i…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: Table Creation
Alvin The DBSPACE where the database was created. Murray Wood ----- Original Message ----- From: Alvin Palacios <apalacio@mnl-hub.dhl.com> To: Informix Mailing List <informix-list@iiug.org> Sent: Friday, 30 July, 1999 17:15 Subject: Table Creation > > All, > > Here's the scen…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Re: Initialization question
Could you post the results of following command: ls -l /INFXDATA/ol_chunk Additionally: ROOTSIZE and ROOTPATH from ONCONFIG and the amount of free space on the filesystem when ol_chunk is located (of course if it not a link to a raw device file). And what do you mean by …
Re: Initialization question
So, here's the oninit -ivy output: Reading configuration file '/home/informix/etc/onconfig.ol_andris'...succeeded Creating /etc/.infxdirs ... succeeded Creating infos file "/home/informix/etc/.infos.ol_andris" ... "/home/informix/etc/.conf.ol_andris" ... succeeded Writing to inf…
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…
Re: Initialization question
Ok. I don't remember when this error message happenes, but you could try checking: 1. The file ol_chunk has the right ownership and group (informix) and the right permissions (660, rw-rw----) 2. There is enough disk place on the filesystem you have create the file ol_ch…
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…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
Problems with Informix on NT - Please Help
You had a disk error on the 6th at 17:07:38 which may or may not have been corrected and your ONCONFIG file has ONDBSPACEDOWN=2 which means pause all operations and wait for the chunk to be repaired and marked back online. Does onstat -d show any chunks and/or dbspaces with a 'D…
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…
Re: shared memory error SCO install
Brian, You didn't specify what version of the engine/OS you are running. But you should change your SHMBASE to 0x82000000 aand SHMVIRTSIZE to 8192. Then check your release notes. With SCO you may have to install a patch or make changes to your kernel. HTH Joe ------------------…
Re: Performance tuning - Configuration files
mark@orbell.demon.co.uk wrote: > > Aplogies for the lack of information : Here are the configuration > files : You say you have a Pentium system running Solaris 7. I thought Solaris 7 is the 64bit version? Anyway... In addition to what you have provided it might help if you p…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
dbspace and the table
How can I identify in which dbaspaces the table is located?…
DBSPACE
Author : T.Jalaludeen E-mail : jala@hpsgm99.sgp.hp.com Hai, I created a database in INFOMRIX 7.23 - HP UX. I created tables also. But later I found thatthe transaction logging has not been turned ON for this database, so droped the database and created using "CREATE DATABASE <d…
Re: DBSPACE
"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the databas…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
DBSPACE size
It is possible to create a rootdbspace during instalation larger than 30 Mb ?…
Rename Dbspaces
Does anyone know of a safe way to rename a dbspace? I can't drop and recreate the dbspace, because it's the "home" for a database, and the database is too large for dbexport/dbimport.…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
Chunk writes
gheppes@my-dejanews.com wrote: > > 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 > fro…
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
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…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
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 …
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
Performance Tuning
Well, the first thing to do is to determine what your performance goals are, then do a comprehensive audit on the current system (os, database and network) under load. The system or db parametes you change will depend heavily on where any performance goals are defecient. When…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
How define the dbspace where an index must to be created?
When I created a table with primary and foreing key informix define an index automatically for each key, that is fine to me but I need to define these indexes in other dbspace than root dbspace. Somebody know how to do it? Thanks. -- Luis M. Ramos V�lez GM GROUP, Puerto Rico lram…
Create DBSpace...
Hi folks, We're trying to automatize our database installation throughout hundreds of sites and it is straightforward to use onspaces command to create desired dbspaces. In an NT 4.0 (SP3) box with Informix 7.23 TC1, a 500 MB of dbspace can be created in as long as 20 *MINUTES*.…
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-…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: 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…
Re: DATAWAREHOUSE DISK SETUP
BEATRIZ ROCHA wrote: > > We are currently setting up an HP-UX box with the following configuration: > HP-UX 10.20 > 20 Disks each of 8.8 GB with 2 controllers > 1,048 GB RAM > 4 CPUs 200MHZ > > This machine is to be used PRIMARILY for a datawarehouse database. The > database …
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Re: Fw: ADDING ADDITIONAL INSTANCE!
Datamas wrote: > > -----Original Message----- > From: Datamas <datamas@batelco.com.bh> > To: informix-list@iiug.org <informix-list@iiug.org> > Date: Sunday, October 25, 1998 10:19 AM > Subject: ADDING ADDITIONAL INSTANCE! > > >Hi all, > > > >Can any one tell me that how to add a …
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Informix on SCO
Where can I get some information on how to configure Informix Onlie Dynamic server on SCO. I'm stuck on the Root DBspace chunk. when tring to initialize the shared memory.…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
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: Informix database reorganization
John, My replies are imbeded. Regards, David Ashby Joe Lumbley <jlumbley@netcom.com> wrote: : There's one very troubling point about your situation. You are demanding : 100% uptime and your development is "still in progress". Surely you have : separate developm…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Re: 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…
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: 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: RAID5 and Informix Online 7.23
Welson R. Jacometti - Development Manager wrote: > > Hello there, > > We have a problem on configuring a RAID5 HOST-to-SCSI Storage Unit using > Solstice DiskSuite (Sun/Solaris 2.6, Solstice DiskSuite 4.1). > > The storage is 8x9.1GB (~72GB). With RAID5 over all the disks (wh…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Re: RAW-Device - oninit
Edward, The permissions have to be granted on the physical (raw) device and not the symbolic links.The permissions on /dev/rdsk/c0t1d0s6 should be informix:informix and on /dbspaces/rootdbs should be root:sys and nothing else..!! Hope this helps, Regards, Girish Punjabi giris…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: checkpoint interval
This is a multi-part message in MIME format. --------------F55B77F7AA2B03C5B6B13061 Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit Sahrul Hidayat wrote: > Dear All, > > I'm ru…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Sizing dbspaces
Does anyone have any recommendation or guidelines we can use in determining a base sizing strategy for rootdbs and physicaldbs. I am most conerned about physicaldbs. I used the formula in the Admin guide to determine a size for physicaldbs but I am not sure if the result was in…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
corrupt dbspace
I am running Informix ODS 7.22 on AIX V 4.1. I accidentally removed a file from AIX that Informix ODS had listed as a chunk in a dbspace (that I was about to remove anyway). I don't back the system up since it is our test system. All I want to do is remove the dbspace and all…
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: DBSPACEUP Environment Variable
Jay Aymond wrote: > > If the environment variable "DBSPACEUP" is set to indicate the size of sort file > for distributions during an "update statistics" --- what dbspace does it use for > the sort file? If there is a temp dbspace, does it use that? By priority: PSORT_DBTEMP (l…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
Re: dbimport - 512MB RAM not enough?
Don Miller wrote: > = > Greetings, all: > = > I've run into a problem using dbimport to re-create a large existing > database in a new dbspace on new disks - although the database unloaded= > using dbexport just fine, every time I try to use dbimport, it complete= s > less tha…
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…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
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: Extended checkpoint times
In article <6a56qu$omb@cssun.mathcs.emory.edu>, Felix Koshy Mathews <fmathews@systems.DHL.COM> writes >anonymous wrote: > >> <snip> > >> We are trying to investigate a series of overly long checkpoints on one >> of our informix databases, here is >> a snippet of the online.log fi…
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: Replication on INFORMIX ?
Bharat Onso wrote: } } Hi Guys, } } I'm new in this nw and need u'r help ... } we're trying Informix Dymanic Server 7.22 on SCO and soon also for our SUN } Solaris ... } it's running well but I have difficulties with the REPLICATION Features ... } this's actually the reason we mi…
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…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Re: Replication on INFORMIX ?
Bharat, I am currently using Informix 7.23 to replicate between NT and DEC Unix. We are using 7.23 because we require Update Anywhere replication. We were using 7.22 in the same environment to do one way replication before the Update Anywhere requirement…
Replication on INFORMIX ?
Hi Guys, I'm new in this nw and need u'r help ... we're trying Informix Dymanic Server 7.22 on SCO and soon also for our SUN Solaris ... it's running well but I have difficulties with the REPLICATION Features ... this's actually the reason we migrated to SQL my quez are : (as s…
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: DBTEMP variable and sorted rows
> There are about 150 MB of free disk space. We're only sorting about > 10,000 rows. > Could it be some file system limitation? Are the files really created in $DBTEMP or is a (root-)dbspace used instead ? (you could check the free space in sbspaces using an "onstat -d" frequent…
Re: onload/onunload and corruption in Informix 7 online engine
In article <878940844.24181@dejanews.com>, jjtest@ismi.net writes >I am moving an instance of version 7.20.UC3 Online engine from a Sparc10 >(sun4m architicture) running Solaris 2.5.1 to an Ultra enterprise 3000 >(sun4u architecture) running solaris 2.5.1. After configuring the n…
Re: Restore to test env
Cosmo Lee wrote: [SNIP] > And that's another issue. If restoring w/ `ontape` you're going to have to > have almost all the ONCONFIG parameters the same in your development DB. > This can be a great: HASSLE. > > This brings up another issue: how will you restore from `ontape` (or…
invalid dbspace
I have been receiving this message for awhile..it hasn't seemed to affect normal functionality...but, I still would love to know what this message means: Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> /d…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: 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: 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: 7.21.UD1 Perf. Problem
In article <5oai41$5ue@dfw-ixnews7.ix.netcom.com>, Kerry <dino@ix.netcom.com> writes >Greetings! > >We are upgrading a Version 5.03 OLTP system to Version 7.21.UD1, also >upgrading to 4GL 6.05 (pre-release due to bugs in 6.04). > >We have a group of programs that are doing a lot …
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: help: oninit -i -> error
In article <33970E81.2335@dvs1.informatik.th-darmstadt.de>, Christoph Liebig <chris@dvs1.informatik.th-darmstadt.de> writes >Hi ! > >Recently our disk holding the informix raw partition failed :( > >We are using online dynamic server 7.1 on solaris 2.5. > >Currently I am trying t…
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Re: Online 5.03 real slow performance
In article <5j8qq8$m5h@cssun.mathcs.emory.edu>, Thuc Nguyen <thucn@email.utcourts.gov> writes > >Hi everyone, > >I have spent a few days looking at the REAL slow performance problems >and have tried LRU_MAX-DIRTY/LRU_MIN_DIRTY,LTXHWM/LTXEHWM, >and BUFFERS adjustment. Nothing work…
Re: Best Tune for Online 5.02
Consider making the memory resident. I'd reduce the PHYSBUFF and LOGBUFF sizes dramatically -- to 64 kB or 128 kB each, usually. Allocate the saved memory to BUFFERS. You could verify that this is a good idea by looking at the tbstat output which reports on how those buffers a…
Re: OnLine 7.13 performance problems - comments please?
Ntruby@netcomuk.co.uk wrote: > > . .dra.com!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com� > . !rill.news.pipex.net!pipex!netcom.net.uk!not-for-mail > From: Neil Truby <ntruby@netcomuk.co.uk> > .Newsgroups: comp.databases.informix > Subject: OnLine 7.13 perf…
Re: OnLine 7.13 performance problems - comments please?
Hi, Your output shows quite a few waits in several areas. One thing you can try if you can spare the resources is to change your lock level on database tables to row level locking (if not set there already). This will ease contention for the tables. Your read cache is about as …
Re: OnLine 7.13 performance problems - comments please?
Neil Truby wrote: } } We're running OnLine 7.13 under Solaris 2.4, on a Sparc 20 with 160M of } memory. The load is increasing, and the users are complaining about } performance. } } Here's my onstat -p in the 12 hours since I zeroed the stats: } } Profile } dskreads pagreads bu…
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: Informix startup (oninit) problem
ptsui@aptnet.com wrote: > > I get the following errors when trying to do an "oninit -i" to > bring up the informix instance for the first time. > ---------------------------------------------------------------------- > oninit: Cannot open chunk ''. errno = 2 > oninit: Fatal error…
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…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
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…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
Re: ontape/ondatartr restores
---------- > From: ntruby@netcomuk.co.uk > To: informix-list@rmy.emory.edu > Subject: ontape/ondatartr restores > Date: vrijdag 1 november 1996 19:49 > > It's well known that OnLine demands that a restore requires the original > chunks to be available, or at least the same symbol…
Re: Making a copy of a database
Ian Goddard (igoddard@netcomuk.co.uk) wrote: : Reposting article removed by rogue canceller. : trubyn@aol.com wrote: : > : > Can anyone suggest a technique for copying an OnLine database to the : > same server? : > : > An archive attempts to restore to the dbspace - I don't know …
Informix/NCR/partition table problem
We have recently had a serious problem with one of our NCR 3555 systems. Please read the following and let us know if anything similar has happened to you, or if you've heard of similar. We're especially interested in causes and/or solutions. This system is configured as such: …
Re: Help on SPACE REQUIRED BY ONLINE
Fernando.Collalti@orbit.net ("Collalti, Fernando") wrote: >Hello and Thanks in advance, >I need to configure and test Informix OnLine 7.12 UC3 >on a HP9000 E35 server with 64MB RAM(HP-UX 9.04) and 1CPU. >Actually I'm using Informix-SE 5.04, and the database is 450MB. >The server…
Help on SPACE REQUIRED BY ONLINE
Hello and Thanks in advance, I need to configure and test Informix OnLine 7.12 UC3 on a HP9000 E35 server with 64MB RAM(HP-UX 9.04) and 1CPU. Actually I'm using Informix-SE 5.04, and the database is 450MB. The server has 3 HD of 2GB each, for a total of 6GB of disk space. Questi…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
RE: Rootdb
On Friday, June 07, 1996, Mike Segel wrote... > Devkant N. Kulkarni wrote: > > > > I just wanted to point out that currently we are using unix filesystem > > mirroring not Infomix's chunk to chunk mirroring. Rootdb is a raw > > space allocated for Informix and is managed by Info…
Re: Rootdb
Devkant N. Kulkarni wrote: > > I just wanted to point out that currently we are using unix filesystem > mirroring not Infomix's chunk to chunk mirroring. Rootdb is a raw > space allocated for Informix and is managed by Informix. I am a bit > confused as to why I need to do a db…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
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: Online 5.1, How to remove a chunk
Hi, You have to drop the dbspace in order to free up the chunk and the dbspace has to be empty when you drop it. Thanks Ryan…
Re: Online 5.1, How to remove a chunk
You can't remove a chunk in version 5.x. This is possible in version 7.x. If the chunk is in a non-rootdbs dbspace, you could remove all data from the dbspace, then drop the dbspace to reclaim chunks.…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
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! …
Find names of all databases in a DBSPACE
Is there a way to get a list of all of the databases in a dbspace? My dbspace is very dynamic and I need a way to get this list. Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c David Clough…
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…
dbspace Q
i am looking for any pgms that might help monitor "space hogs". it would be nice to be able to get a listing of databases found under a specific DBSPACE along with its owner and size. i thought i saw a news thread along this topic a few months ago. thanks, jim ________…
Re: Mirroring
Ti Lian Hwang writes: |We have a new HP9000 machine with 2 fast SCSI disks and 2 slower |disks. | |We are using informix mirroring on them. | |Is there advantages or disadvantages if the mirror copies are both |in the in the slow disks, or a mix of slow and fast disks ? | |I mea…
Mirroring
We have a new HP9000 machine with 2 fast SCSI disks and 2 slower disks. We are using informix mirroring on them. Is there advantages or disadvantages if the mirror copies are both in the in the slow disks, or a mix of slow and fast disks ? I mean Disk A (slow) Disk B …
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
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…
Re: AGAIN: Cannot start Online Engine
In article <Cnsn0L.GHG@informatik.uni-muenchen.de> spitz@GANS1X.ana.med.uni- muenchen.de (Richard Spitz) writes: -> Dear Online Gurus, -> -> a while ago, I posted the following problem, but didn't receive any -> helpful replies. Since I cannot believe that the collective net.wis…
dbspace lost
Platform: Everex 486 running Interactive 3.2 and Informix Online 4.00.UE1. Recently, we took a power hit that caused some damage to our file system. Specifically, the device file Informix writes to was lost. Should I reinstall Online or can I just re-create the device file? Al…
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…
Prevent users from creating databases?
Is there any way to prevent users from creating databases? Or at least to prevent them from creating databases in the system dbspace? Or even a way to change the default place for databases from system dbspace to another dbspace? Thanks in advance. -- Rick Hamel Database Admi…
tables in dbspace (Online 5.x)
Is there a simple way to find which tables are in a dbspace? (Or, what dbspace a table is in?) -Brian ------ brena@hcia.com…
Re: >RE:"Could not write to a temporary file" error
Every time that I've seen the Could not write to temp file error, it's been the root dbspace. Do 'tbstat -d' while you're running the pgm and see if any chunks get near 0 free ??? Bill *8o\\…
Re: On-line engine startup failure
Hal Wigoda (hwigoda@seg7.arlingtonhgts.mnc.mot.com) wrote: : We're trying to install the on-line engine on a new machine. : I think we've done everything right in terms of setting : environmental variables and tbconfig parameters and slicing and dicing : of the hard disk. : But w…
DBspace Question
I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select h…
dbspace for database
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 o…
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…
Cooked dbspace...
A client of of ours was playing with OnLine, and created a chunk on the cooked file system. When he was done, he decided "Okay, I'm through." and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace inside of OnLine. So now he has a dbspace that OnLine thinks …
Dropping a dbspace
Hello, I am currently using the Informix Turbo engine. I tried to drop a dbspace the other day and couldn't do. Does anybody have info on how to do this? Thanks ! Brian MacWilliams USAMC - SIMA LEAD CHAMBERSBURG PA…