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     
Hoping to get some opinions on this. We have a public website that is currently using our main production database (IDS 11.50.FC6). The main query...
Sean Baker
09-04-2012 06:41 PM
Jason Harris Go to last post
5 266
Hello, I've searched the web and don't see any clear answer on this. Any advice would be appreciated. We have always used the default character...
Nick
09-04-2012 05:32 PM
Fernando Nunes Go to last post
1 76
I have an IDS instance running 11.50.FC4 on AIX. The OS pagesize is as follows: $ pagesize 4096 The rootdbs page size is also 4096 bytes as shown...
Desmodromic
09-04-2012 07:27 AM
jrenaut Go to last post
2 83
Using dbaccess I am trying to keep a database connection open in a shell script until I want to close it. It may be easiest to explain what I'm...
Desmodromic
09-03-2012 08:33 PM
Desmodromic Go to last post
6 104
Is it possible to obtain the page version information that oncheck -pT reports in the "Home Data Page Version Summary" section from the sysmaster...
Desmodromic
08-27-2012 09:30 PM
Art Kagel Go to last post
3 144
I don't know. Marco is correct as far as it goes, but I'm not sure whether embedded SET PDQPRIORITY commands will do that. One way to check.....
John Hardin
08-23-2012 07:48 PM
Art Kagel Go to last post
7 102
Regarding this aspect, I think some examples may help to understand some differences... Not sure if I mentioned this here before... Sometime ago a...
davidegrove@gmail.com
08-23-2012 05:05 PM
Fernando Nunes Go to last post
3 87
I have an opportunity to change the fragmentation strategy on some heavily used tables. Most records on these tables are only accessed on the day...
Laurie Gustin
08-21-2012 12:20 AM
John Miller iii Go to last post
3 124
Hi, How can I write a routine in Esql/C which initialize to 0 (zero) all numeric fields (smallint, decimal, etc) and to (' ') space the other fields...
Francesco Alfano
08-16-2012 03:27 PM
Bartlomiej Lidke Go to last post
6 97
Hi, How can I determine, in ESQL, the datatype of the columns in a table without first usign a SELECT statement ? I'm looking for a sample code that...
Francesco Alfano
08-16-2012 10:27 AM
Jonathan Leffler Go to last post
3 76
I want to format data value like : let char_var = date_var using 'yy' ; ( get the year from date ) & let char_var2 = char_var1, int_var using '&&&&'...
joe
08-16-2012 09:53 AM
Jonathan Leffler Go to last post
2 93
To change non-logged database to logged database. Anything I need to change in 4gl program ?
roger
08-09-2012 09:00 PM
roger Go to last post
6 99
create table tab1_jj ( id serial8 not null , cr_date datetime year to second default current year to second not null , acc_id integer not...
JJ
08-08-2012 03:17 PM
JJ Go to last post
2 74
Does anyone have experience with SAN-level replication and its effect on Informix, especially with respect to disaster recovery/restore? We're...
red_valsen
08-08-2012 02:59 PM
mpruet Go to last post
2 90
We are planning to use DE in our development and test environment. I am aware of the limitations to CPU VP's, disk and memory as described in...
Ulf
08-01-2012 06:19 AM
KN Liew Liew Go to last post
3 92
I have IDS 10.00.FC5 running on Solaris 5.8 thus I have a default page size of 2k. One of the table (NOT my design !!) has a row size of 1079 so I...
Keith Simmons
07-31-2012 09:49 AM
Keith Simmons Go to last post
3 81
We recently upgraded two instances from 11.7.FC4 to 11.7.FC5 on AIX 6.1 Strange situation arose in that the automatic firing of backing up the...
tomcaml@gmail.com
07-30-2012 08:35 AM
jrenaut Go to last post
1 93
You could parse the output from the onlog -n -t<tblspace number> for HUPDATE, HINSERT, HDELETE entries...the Administrator's ref manual gives info on...
bunnymjh
07-17-2012 04:44 AM
malc_p Go to last post
7 133
Hi, Ifx 11.50 FC9X6 AIX 6.1 We have a table where two columns are used for filter : create table tst ( col1 int , col2 int); select * from tst...
Cesar Inacio Martins
07-06-2012 03:32 PM
Art Kagel Go to last post
4 131
This seems straight forward... hopefully someone knows a quick answer. IDS 11.7 FC5 Red Hat Enterprise Server release 6.3 (Santiago) Trying to...
Laurie Gustin
07-02-2012 02:07 PM
Laurie Gustin Go to last post
12 238
Hi, in the context of: Informix 4GL 7.50 Without C/Java procedures. Without RUN external program. Can i EXECUTE a prepared statement (an insert)...
eferreyra
06-29-2012 08:51 AM
eferreyra Go to last post
3 143
Hi every body, Help me please... I can`t do that : ----------------- select * from ecofin@e3500desa_tcp:cuentas_corrientes I get the following...
LUQUE Valdivia Omar
06-27-2012 11:21 AM
Art Kagel Go to last post
8 711
hello we recently upgraded from version 11.7.FC4 to 11.7.FC5 on AIX 6.1. The scripts we use for the backups and alarms are the same (except for the...
tomcaml@gmail.com
06-26-2012 01:44 PM
tomcaml@gmail.com Go to last post
3 187
HPUX B.11.31 U ia64 on HP BL870c IDS 11.50.FC6 We have two HP BL870c Integrity servers, one is the production the second is for testing and recovery...
John Adamski
06-25-2012 10:41 AM
jrenaut Go to last post
2 169
To serialize some kind of data modifications our application uses an exclusive table lock (lock table %s in exclusive mode). Process retrieves some...
Frank Langelage
06-19-2012 05:40 AM
Art Kagel Go to last post
2 93
Hi everybody, i just want to know, how to retrieve the current value of an serial in a table. For example, there is a table with a serial. In the...
Michael Weber
06-08-2012 12:44 AM
Michael Weber Go to last post
4 106
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 107
Related to this old...
Francesco Veroni
05-30-2012 05:36 AM
Art Kagel Go to last post
1 67
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 78
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 72
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 76
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 94
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 70
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 78
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 64
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 64
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 108
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 65
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 83
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 78
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 65
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 83
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 100
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 94
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 98
"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 68
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 59
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 85
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 66
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 58
Post New Thread

Display Options
Showing threads 151 to 200 of 6968
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.