dbTalk Databases Forums  

Sponsored Links


comp.databases.informix comp.databases.informix


Discuss in the comp.databases.informix forum.



Post New Thread
Threads in Forum : comp.databases.informix Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
This is really silly to have to ask this.... When we do a level 0 archive, does the process start with a checkpoint? I always thought it did but...
Cats
06-01-2012 03:43 AM
Cats Go to last post
2 104
Related to this old...
Francesco Veroni
05-30-2012 05:36 AM
Art Kagel Go to last post
1 63
In a very old training doc I found this: http://dl.dropbox.com/u/3605787/sqlhosts.JPG I would ask: what kind of sense have to configure more than 1...
Francesco Veroni
05-25-2012 02:43 AM
Francesco Veroni Go to last post
2 75
IDS9.30HC5, HP-UX 11i We're running DR testing and have a backup of type "file" we're trying to load onto the DR box. I've done an ism_catalog...
Malc P
05-23-2012 02:57 AM
Malc P Go to last post
2 67
I have a table called club_members. It has 3 columns first_name,last_name,club_name Write a query to summarize how many clubs each student is in. ...
Floyd Wellershaus
05-10-2012 10:23 AM
Araujo, Daniel Go to last post
4 69
Hello all, Can anyone shed any light on the following error..... Thanks in Advance.... HP-UX sleepy B.11.11 U 9000/800 2262126760 unlimited-user...
howie.lfc@googlemail.com
05-04-2012 05:40 AM
Art Kagel Go to last post
1 86
Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR...
Cesar Inacio Martins
05-03-2012 06:36 AM
Cesar Inacio Martins Go to last post
9 68
Morning all An odd one which I have a faint bell ringing at the back of my head about.... IDS9.30HC5, HP-UX11i We run our L1 backups using onbar -L0...
Malc P
04-30-2012 08:38 AM
Jason Harris Go to last post
8 70
New Fastest Informix DBA Contest 2012 1,000 OLTP users benchmark run on a Apple Mac Mini Server Andrew Ford is the Grand Prize Winner of a new...
Lester Knutsen
04-30-2012 07:07 AM
Malc P Go to last post
1 58
Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who...
Cesar Inacio Martins
04-25-2012 09:39 AM
Cesar Inacio Martins Go to last post
1 55
hi, i'm looking for any solution which allow me to get database server online or export data from dbspace the state is as follows: # onstat...
Marcin Tomczyk
04-21-2012 12:16 PM
Superboer Go to last post
7 101
hello all, according to this article (http://www.jfmiii.com/informix/?paged=2) We’ve also added a new algorithm for gathering statistics to...
tomcaml@gmail.com
04-20-2012 05:16 AM
Fernando Nunes Go to last post
3 62
To keep a database normalized should a one to many relationship always use two tables? The data in the following table is used as a master record,...
loc
04-16-2012 01:32 PM
Art Kagel Go to last post
3 76
hello, one of our developers wanted to use a function natively in Informix that behaves like DB2's row_num function. seq_num would be returned from...
tomcaml@gmail.com
04-12-2012 09:30 AM
Art Kagel Go to last post
1 72
Hello, I'm currently working on expanding my knowledge and would like to work more on the database side of things. I would like to learn more about...
Kimomaru
04-09-2012 01:55 PM
Art Kagel Go to last post
1 62
Just for completeness - you could also try Aubit4GL ( http://sourceforge.net/projects/aubit4gl/) We *do* use normal ncurses , and because its open...
Anders Molander
03-28-2012 02:16 PM
Mike Aubury Go to last post
5 80
IDS Innovator-C V11.70UC4IE Fedora Linux V16 running on a Lenovo thinkpad T500 I've had this installation running for a month or more now but on...
Malc P
03-26-2012 08:47 AM
Malc P Go to last post
5 83
Depending on your needs and performance requirmentes there may be an easy solution. AFAIK the standard COALESCE function takes arguments that may...
davidegrove@gmail.com
03-24-2012 03:46 PM
Fernando Nunes Go to last post
3 84
Tom: Try instead to turn the SQLTRACE feature on and query sysmaster:syssqltrace instead. That accesses a different area of memory in the server...
tomcaml@gmail.com
03-23-2012 09:19 AM
tomcaml@gmail.com Go to last post
2 85
"ON 64 BIT UNIX PLATFORMS INFORMIX ODBC SHOULD HAVE SQLLEN CHANGED FROM 4 BYTES TO 8 BYTES." Does anyone know when this is going to be...
Ian Goddard
03-18-2012 04:17 AM
Ian Goddard Go to last post
4 62
On 15/03/12 13:57, Todd Roy wrote: Assuming that the logs haven't wrapped - the only way to achieve this is for advanced support to dial in and...
Marco Greco
03-16-2012 12:29 PM
Todd Roy Go to last post
8 52
Dear Informixers, why is a query containing outer joins written as LEFT JOIN so much slower than when written using the Informix-specific OUTER...
rspitz.md@googlemail.com
03-14-2012 10:34 AM
Richard Spitz Go to last post
8 79
Hello all. I'm running IDS 11.50.FC6. I have a situation where it would be very useful to Base64 encode a string to store in the database. ...
Sean Baker
03-13-2012 05:38 PM
Art Kagel Go to last post
1 59
System: IBM Informix Dynamic Server Version 9.40.UC6W4 Hi guys, sorry for my bad language but i'll try to describe my problem. Where is the...
Michael Weber
03-13-2012 09:07 AM
Art Kagel Go to last post
1 49
On Mon, Mar 5, 2012 at 05:45, David Linthwaite <dlinthwaite (AT) lintel (DOT) co.uk>wrote: I'm not aware of a specific problem with ON-Monitor,...
Malc P
03-05-2012 09:15 AM
Jonathan Leffler Go to last post
9 59
Good Morning - Some questions regarding using different languages. I am only familiar with English within the Database. If we currently have all our...
Tom Lehr
03-05-2012 08:56 AM
tomcaml@gmail.com Go to last post
2 51
Hello, the 2 tables fyar1sta and fyar2sta are 1:1 related with the field artikel I must copy bewprs to aktvkp in the table fyar2sta but only for...
Ralf Hackmann
02-28-2012 05:37 AM
Ralf Hackmann Go to last post
3 84
We recently moved from a physical to a virtual host (VMware) for a data warehouse DB. The migration was used Tivoli Bare-Metal Restore for O/S and...
red_valsen
02-25-2012 08:20 PM
Art Kagel Go to last post
1 68
Hello, We have a need for a non-informix user to be able to connect to the Informix DB via dbaccess while the DB is in Single-User Admin Mode...
Informix DBA
02-22-2012 02:28 PM
Informix DBA Go to last post
3 73
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...
Laurie Gustin
02-20-2012 09:10 AM
Art Kagel Go to last post
1 58
Hi all, I have two Informix istances: IDS 11.50 - root node of ER, replicates some tables to IDS 9.40 - leaf node of ER (read-only). A few...
Francesco Veroni
02-12-2012 10:19 PM
mpruet Go to last post
4 69
Is there a utility in either Informix or Solaris that will let me inspect RAW disk, when Informix isn't running? And will I see the name of the...
Cats
02-09-2012 01:36 AM
Cats Go to last post
4 83
Great! To make life a bit easier (so you don't have to change INFORMIXDIR or PATH in any users profile or in various scripts and cron jobs, make...
Malc P
02-07-2012 10:30 AM
Malc P Go to last post
3 62
Fair but hard question :) In fact it depends on the database size and the kind of data and usage... But I assume you want numbers, so I'll risk to...
red_valsen
02-02-2012 08:49 AM
Fernando Nunes Go to last post
4 73
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you...
Cesar Inacio Martins
01-31-2012 12:26 PM
Martin Fuerderer Go to last post
4 59
Hello All Have been doing some reading about clustered indexing and wondering what experiences other folks have had with them? We currently do not...
Tom Lehr
01-31-2012 10:23 AM
Art Kagel Go to last post
2 84
Why is it a bad idea to grant DBA to all developers? On one project I support, the programmers all use the same project-level account 'projectXdba'...
red_valsen
01-30-2012 06:43 PM
Jonathan Leffler Go to last post
1 49
hi all, one of our informix servers starting abnormally. the services on Widows starts ok but with no access to the database. one of the chunks seem...
Omar Gassama
01-30-2012 12:30 PM
Superboer Go to last post
1 67
Yes. Also a properly designed application will use Optimistic Locking Protocols and not perform SELECT ... FOR UPDATE, insert, update,...
BeGooden-IT Vercelletto
01-30-2012 07:44 AM
Fernando Nunes Go to last post
8 76
Ben: The DB2 driver does not understand any Informix specific types like BOOLEAN. Fortunately Informix has some built-in casts that you can...
Art Kagel
01-26-2012 05:49 PM
Art Kagel Go to last post
2 55
hello all the manual states "This mode denies other processes both read and write access to the table". Does it also affect the dynamic allocating ...
Tom Lehr
01-25-2012 03:42 PM
Tom Lehr Go to last post
3 47
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.
red_valsen
01-23-2012 11:50 AM
Fernando Nunes Go to last post
1 41
Hello, We are being asked to archive off some data from very large tables. They want to keep 2 years worth in the main table and move the rest to...
Floyd Wellershaus
01-22-2012 02:03 PM
scottishpoet Go to last post
3 49
Would normally simply test this but I don't have my test system at present due to hardware failure, and I'm not going to have it for a few...
Cats
01-12-2012 09:09 AM
Cats Go to last post
2 50
Hi Folks, I have to move around a terabyte of a blobby table (not TEXT or BYTE) to another machine. I'm trying without success to make the HPL...
aclarke
01-11-2012 12:23 PM
Art Kagel Go to last post
5 55
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver...
red_valsen
01-08-2012 02:08 AM
Jon Ritson Go to last post
1 50
Over complicated things: select ( select MAX(t1.col1) from table( set{t0.zipcode::integer, t0.customer_num::integer} ) t1(col1) )...
Tom Lehr
01-05-2012 08:12 PM
Fernando Nunes Go to last post
3 53
Hi all, we have running in a lot of trouble with 64 bits OS servers and desktops that are clients of IDS11.5x This servers have several applications...
eferreyra
01-04-2012 09:23 AM
Rajendra H Kamath Go to last post
2 47
The DRDA driver suite infact has two drivers underneath, the recommendation is to use the DB2.NET driver (supports Informix as well...
eferreyra
01-04-2012 08:22 AM
Art Kagel Go to last post
9 85
Hello, Does anyone have a list of the current possible values for the sysmaster:sysseglst table for the seg_class column? I searched through...
Dave
01-03-2012 03:46 AM
Stuart Brooks Go to last post
1 47
Post New Thread

Display Options
Showing threads 151 to 200 of 6944
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.