| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Given a logical log file, wow can we find out its location
(dbspace) ?
onstat -l doesn't show this info.
Thanks
Veeru71
|
08-21-2007 02:42 AM
Claus Samuelsen  | 3 | 23 |
| | | AIX 5.3
IDS 10.00.UC5
We have had reports of slow performance so I have been monitoring the
system. When I check with onstat -g glo I see that...
malcolm.iiug
|
08-20-2007 12:16 PM
Art S. Kagel | 5 | 36 |
| | | Can't we do something about this wanker?
Shame a simple DROP statement (or even a FRAGment!) won't work......
malc_p@btinternet.com
|
08-20-2007 11:19 AM
malc_p@btinternet.com | 0 | 28 |
| | | I don't know if everyone was aware of this, but you can subscribe to
product lifecycle RSS feeds...
Obnoxio The Clown
|
08-19-2007 08:22 PM
natebsi@gmail.com | 2 | 27 |
| | | Version : 10
We are running onbar -b -l with BAR_MAX_BACKUP = 4 and
BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process
I just see...
mohitanchlia@gmail.com
|
08-18-2007 02:45 AM
mohitanchlia@gmail.com | 8 | 34 |
| | | Hi,
I have been asked to research some details on Informix about which I
know very little. Please can somebody advise me or point me in the
right...
andrewr@cornasys.com
|
08-18-2007 01:08 AM
Jonathan Leffler | 12 | 68 |
| | | Hi all;
Ya - I know - but I bet the answer is on this list.
I am in HP Unix, not that I think this will influence the answer.
I run something like...
ian
|
08-18-2007 12:52 AM
Jonathan Leffler | 3 | 33 |
| | | I see this on several systems, can anyone tell me what SPLNULL is?
Thanks much
sgavette@yahoo.com
|
08-17-2007 05:28 PM
sgavette@yahoo.com | 0 | 33 |
| | | Hello,
I have large table obout 1 milion rows - 80 GB.
table_AAAA
Column name Type Nulls
id_name char(10) no
seria_name char(10) no
juliawojtkiewicz@interia.pl
|
08-17-2007 05:19 PM
Fernando Nunes | 1 | 37 |
| | | Hi All;
Is the row size the actual size layed out on the disc drive/storage
medium?
In the SE I remember that each record was terminated.
In...
ian
|
08-17-2007 01:09 PM
Art S. Kagel | 3 | 31 |
| | | Informix Technical Briefings
Date: 29 August 2007 and 21 September 2007
Location: Ardenta offices, Sunbury on Thames
Duration: 8.30 - 11.15...
Gaelle Janin
|
08-17-2007 03:17 AM
malcolm.iiug | 2 | 33 |
| | | Hi,
I've been using dbd::informix with no problem, I just upgraded to IDS
11 and CSDK 3.0 and can;t install DBD::INFORMIX.
(O.S. Centos 4.4 Kernel...
Fernando Ortiz
|
08-16-2007 06:01 PM
Fernando Ortiz | 2 | 33 |
| | | http://www.ibm.com/developerworks/eserver/articles/PerformanceandTuning.html
"Eric Rowell"
<erowell (AT) gmail (DOT) co
m> ...
kernoal.stephens@autozone.com
|
08-16-2007 04:35 PM
Priest, Darryl | 1 | 31 |
| | | Hello list,
what can I do to get timestamps having fractions of seconds into a TRACE
created using TRACE PROCEDURE.
What I have is:
TRACE...
Richard Kofler
|
08-16-2007 03:09 PM
Link, David A | 1 | 28 |
| | | All:
We're running IDS 10.00.FC6 on AIX 5.2, and have been getting these errors:
KAIO: out of OS resources, errno=12
We've got four such hosts...
Thomas J. Girsch
|
08-16-2007 03:07 PM
kernoal.stephens@autozone.com | 4 | 31 |
| | | database b;
CREATE PROCEDURE BB()
select * from table(set{1}) into temp t12345 with no log;
END PROCEDURE;
database a;
CREATE PROCEDURE AA()
EXECUTE...
Denis.Zhuravlov@gmail.com
|
08-16-2007 02:26 PM
david@smooth1.co.uk | 6 | 36 |
| | | Hi ,
Urgent Req. for actuate consultant
Location : allover UK
*Job Description:*
abc
|
08-16-2007 07:19 AM
Obnoxio The Clown | 3 | 28 |
| | | Version: 10 FC 4
I was reading about STMT_CACHE to see if this could be used to
increase the performance of repeated queries. But I see lot of...
mohitanchlia@gmail.com
|
08-15-2007 12:45 PM
Mark Jamison | 2 | 34 |
| | | Integration testing tool is available now. Integration testing in
which individual software modules are combined and tested as a group.
Help you a...
smith.michelexpert@gmail.com
|
08-15-2007 05:00 AM
smith.michelexpert@gmail.com | 0 | 31 |
| | | Hi all,
I have a web page in php that does a number of queries to pull up
various bits of information on students. Occasionally, this...
Brian McLaughlin
|
08-14-2007 08:52 PM
Carsten Haese | 3 | 33 |
| | | Integration testing tool is available now. Integration testing in
which individual software modules are combined and tested as a group.
Help you a...
smith.michelexpert@gmail.com
|
08-14-2007 04:25 PM
smith.michelexpert@gmail.com | 0 | 23 |
| | | Thanks, that's exactly the kind of information for which I was
searching.
-D
-----Original Message-----
From: informix-list-bounces (AT) iiug...
Darryl Priest
|
08-14-2007 10:41 AM
Priest, Darryl | 8 | 27 |
| | | With the Information on Demand 2007 conference just two months away, I
want to make you aware that the August 15 deadline for an early
registration...
scottishpoet
|
08-14-2007 08:55 AM
scottishpoet | 0 | 26 |
| | | Version: IDS 10 FC4
1. Is it advisable to have blob as part of tablespace even with the
fragemented table ?
2. Is it correct that if blob is part of...
mohitanchlia@gmail.com
|
08-14-2007 01:21 AM
mohitanchlia@gmail.com | 3 | 26 |
| | | Dear All,
I am from one of the largest IT organization in India. Though the base
location is Chennai, India, the project location is at...
seetharams@gmail.com
|
08-14-2007 01:10 AM
Ashish Jain | 11 | 48 |
| | | What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both
seem to be doing parallel/concurrent log backup. Which one should be
specified...
mohitanchlia@gmail.com
|
08-13-2007 05:49 PM
mohitanchlia@gmail.com | 1 | 24 |
| | | i am using informix XPS 8.5
after oninit -iy, i want to create a user dbspace.
The command i used as below:
# ./onutil
1> create dbspace dat
2>...
jeffhan
|
08-13-2007 01:33 PM
Art S. Kagel | 4 | 28 |
| | | Does anybody have a script that can determine the upper limit of extents as described in the Admin Guide ?
It's easy for me to do on a table level,...
floyd@fwellers.com
|
08-13-2007 01:28 PM
Art S. Kagel | 4 | 38 |
 | | Tom
I may have missed this in the variety of posts ! but do i understand
this is a new installation and has never run? If so have you...
tom.priore@gmail.com
|
08-13-2007 10:05 AM
Keith Simmons | 20 | 162 |
| | | Greetings All,
I am hoping someone can provide some guidance concerning the tuning
of
IDS for multicore CPU architectures. Currently, I have a...
the_omegamon@yahoo.com
|
08-11-2007 12:15 PM
pokeyman | 7 | 29 |
| | | Hello,
Wal-Mart Corporate headquarters' IT Division has outsourced their
recruiting to my company and we are currently looking for mid to
senior...
becky.franzen@futurestep.com
|
08-10-2007 02:18 PM
Jean Georges Perrin | 1 | 27 |
| | | We have a PeopleSoft 7.52 installation still running on IDS 7.31.UC4. I want to upgrade/migrate the database
to a newer version of Informix, probably...
DL Redden
|
08-10-2007 01:09 PM
DL Redden | 7 | 25 |
| | | IDS 10.0FC5 on AIX 5.3
We have a highly sporadic performance problem. Sporedically - hasn;t
happened for a couple of months but has started today -...
Neil Truby
|
08-09-2007 05:54 PM
Neil Truby | 17 | 49 |
| | | Hi
Allow me to take this opportunity to introduce to you our "TechUnified
Consulting" has been adjudged as the "Best Emerging Company" for the
year...
anjali6.borah@gmail.com
|
08-09-2007 06:09 AM
anjali6.borah@gmail.com | 0 | 26 |
| | | I have recently had my sleep disturbed on an almost nightly basis by a
repetitive problem with ISM and Onbar.
We are running ISM and onbar for IDS...
malcolm.iiug
|
08-09-2007 05:21 AM
Martin Fuerderer | 1 | 26 |
| | | looking for correct syntax to create directives inside
queries to overwrite optimizer query execution plan,
to be used in 4gl/esql, I got something...
sergio kapul
|
08-09-2007 04:23 AM
richard.harnden@googlemail.com | 4 | 29 |
| | | We ve an IDS v7.3 on Solaris Unix. I want to user accessibility to
tables based on Roles.
I've attempted to ceate a Role and add user but still user...
dungdang
|
08-08-2007 09:15 PM
dungdang | 3 | 44 |
| | | Version: IDS 10
We are fragmenting table which currently is in one dbspace with 8K as
page size. Now since we are fragmenting I wanted to ask:
1....
mohitanchlia@gmail.com
|
08-08-2007 07:59 PM
mark.scranton@gmail.com | 4 | 32 |
| | | Hi All,
I am using IDS 10:00 UC5 on AIX 5.3 and replicating my data on my DR-Site using Enterprise Replication. I am also running an important...
Navaid Arif
|
08-08-2007 07:44 AM
Madison Pruet | 1 | 57 |
| | | 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:
ONCONFIG can only...
tom.priore@gmail.com
|
08-08-2007 02:40 AM
tom.priore@gmail.com | 1 | 29 |
| | | Version: IDS 10
Informix engine threw "altering older version row to latest version
failed" error when I tried to create index on one of the...
mohitanchlia@gmail.com
|
08-08-2007 12:49 AM
Arturo Koosau | 4 | 25 |
| | | Hello,
I've tried looking for the function, or other way, to return a record
where the length of the value in the field equals a certain number.
For...
jared.hanks@gmail.com
|
08-07-2007 10:19 PM
Carsten Haese | 1 | 30 |
| | | Hi,
We have a web application deployed on a websphere 6 application server
that's used to make some queries over an informix database....
pedro
|
08-07-2007 06:53 PM
Fernando Nunes | 3 | 48 |
| | | I'm using Aqua Data Studio to query an informix idx 10 database and
I'm trying to figure out how to perform a like type condition on a
text column....
lairdnet@gmail.com
|
08-07-2007 10:34 AM
Superboer | 3 | 25 |
| | | Because of the large size of the table we recently chose to fragment
by round robin into 8 dbspaces. After inserting lot of rows we ran our
delete...
mohitanchlia@gmail.com
|
08-06-2007 03:59 PM
Art S. Kagel | 8 | 30 |
| | | I am trying to replace some of our old document# generators that were written back before IDS had sequences.
They just cause unwanted contention.
It...
Bill64bits
|
08-06-2007 10:39 AM
Bill64bits | 0 | 25 |
| | | Version: IDS 10
I was reading about HDR and it looks like in HDR blobs are not
replicated to secondary server if they are of type simple...
mohitanchlia@gmail.com
|
08-06-2007 07:05 AM
Superboer | 1 | 31 |
| | | Version: Informix 10
We saw following error:
22:18:32 Maximum server connections 489
22:18:56 Logical Log 360070 Complete, timestamp:...
mohitanchlia@gmail.com
|
08-06-2007 06:58 AM
Superboer | 1 | 30 |
| | | IDS 10.0FC5 on AIX 5.3
Don't suppose much can be told from this, but has anyone any ideas about
this failure yesterday?:
11:00:32 Maximum server...
Neil Truby
|
08-04-2007 09:10 AM
Neil Truby | 5 | 50 |
| | | Hello everyone,
I'm preparing new database server to take over our current production
one. The servers are not at the same location and copying...
askel
|
08-03-2007 11:37 AM
Art S. Kagel | 4 | 31 |
