Database Forum - Informix Topics

Thread preview

Thread	Last Post	Replies

RE: size of rootdbs (unofficial SURVEY thread :))	30 Nov 2006 17:41 GMT	1
Ooooo, you got me beat.... My rootdbs is 150MB in production. Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services
temp dbspace	30 Nov 2006 16:42 GMT	2
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
size of rootdbs	30 Nov 2006 15:44 GMT	6
What should be the size of rootdbs .I mean the optimum size. How does the size of rootdbs affect the IDS performance? It is takijng a lot of time to initialize ..Is it normal(as per my configuration) ?
Level 0 archive info. from onstat	29 Nov 2006 22:16 GMT	3
Greeting All, HP-UX B.11.11 U 9000/800 IDS 9.21.HC2 Though it's not an issue but it is bugging me on & off. I am sure some
ontape -r failed: code -1 errno 2	29 Nov 2006 16:47 GMT	11
I'm new in these newsgroup. I habe a big problem! Our server is crashing yesterday and I can't restore the database. I copy the last backup and the act. onconfig on the server and start
Anybody know if this could be an informix version 9.3 to 9.4 error?	29 Nov 2006 00:32 GMT	2
So I've got this application running on AIX 5.0 Informix 9.3 I'm testing on Linux, but I've only got Informix 9.4 (uc 2 & uc 8) for Linux. We keep getting this crash in the module, I did an SQL Trace Log
problem with select count(distinct	29 Nov 2006 00:24 GMT	25
Running 10.00.UC5I1 on linux With the following schema and static data i.e. I am the only user create table 'informix'.phone ( id SERIAL not null,
BIG big table ....	29 Nov 2006 00:14 GMT	10
In informix, how do we define a big table? In other words, normally a big table should have how many rows? I have a table that consists of 2M rows. Do you think that a continuous sequential scan over a 2M table for around 2M times will create performance issue? If yes, what can I
Convert existing INFORMIX 10.x Database from en_US.819 to en_US.utf8	28 Nov 2006 23:24 GMT	3
Calling ALL INFORMIX GURUS, how could I convert existing massive database of close to 25 Million rows which is sitting as en_US.819 to en_US.utf8 without export and import again. Any help on this is greatly appreciated and THANKS IN ADVANCE FOR ALL
Trouble restoring database on test/recovery system	28 Nov 2006 19:15 GMT	3
Trouble restoring database on test system (IDS 9.40.HC3 on HP-UX 11i (11v1) Yesterday when I was restoring the production database on the test/recovery server I got some errors I never gotten before. I have
HDR Question	28 Nov 2006 15:57 GMT	1
>From IBM Informix Tech Notes, why would you want to do this? Problem This article describes how to disable parallel clearing of the physical and logical logs on the secondary of a HDR pair during its logical recovery. Solution
Are there any training institutes for Unidata/ Universe?	28 Nov 2006 11:28 GMT	1
Are there any training institues in India for Unidata/ Universe database?
How can I disable a foreign key???	28 Nov 2006 09:04 GMT	5
Hi to all. I have problems to unload/load a table to set extents correctly (I have table with more than 500,000 records and more than 100 extents). I need to disable foreign keys to unload and load the main table but I don't know how. Please help me.
Constant online log errors on all servers	28 Nov 2006 01:34 GMT	4
This is a repeat of a problem I posted a couple of months back. Searching for inspiration really. IBM Informix Tech Support says it's a network error (PMR 04123,019,866 refers). RedHat tech support say it's a database error. The network administrators have no idea.
find oncheck output in the sysmaster tables	27 Nov 2006 12:11 GMT	3
Hi - i need help, the Output form "oncheck -pt my_database:mytable" is: TBLspace Report for my_database:informix.mytable