| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
Running a 32 bit esql compiled program on a 64 bit AIX 5.3 host.
Program runs fine on original compiled 64 bit host.
Program was originally...
joseph_freemaker@yahoo.com
|
04-03-2008 09:59 AM
Jonathan Leffler  | 2 | 3 |
| | | Hi
I need some help with alter table. We have a table with about 1.500.000.000
rows. The table is growing fast.
dbschema:
"xxx.sql" 95 lines, 3483...
Habichtsberg, Reinhard
|
04-03-2008 04:47 AM
Habichtsberg, Reinhard | 4 | 5 |
 | | LOL!
First, I guess Mark never bothered to honor the terms of an NDA.
There seems to be a bit of a misunderstanding about IBM. IBM doesn't...
mark.scranton@gmail.com
|
04-02-2008 10:26 PM
Serge Rielau | 67 | 68 |
| | | Did as you suggested but the distributions for the table remained in
sysdistrib. Could it be that only distributions for the specified column
would...
Habichtsberg, Reinhard
|
04-02-2008 06:06 PM
Fernando Nunes | 1 | 2 |
| | | howdy
does informix have system views/meta data that indicates the last time
an index was used?
thanks
tom
tomcaml@gmail.com
|
04-02-2008 10:54 AM
tomcaml@gmail.com | 4 | 5 |
| | | Does anyone, anywhere, use the dsnmigrate.exe utility that is supplied
with the Informix Client SDK, in any way, at all?
Would you miss it if it...
Guy Bowerman
|
04-02-2008 09:27 AM
Everett Mills | 1 | 2 |
| | | This may have been gone over before, though I have found little about it
in my searches. If so, I apologize.
We use a proprietary administrative...
Goldrick, Jim
|
04-02-2008 09:16 AM
Jonathan Leffler | 1 | 2 |
| | | Hi.
After upgrading from IDS 9.40.FC4W2 to 9.40.FC9W2 some queries run extremly
slow and I'm under the impression that the optimizer chooses the...
Habichtsberg, Reinhard
|
04-02-2008 08:11 AM
Jack Parker | 9 | 10 |
| | | IDS Price Promotion
End of Support dates for earlier versions of IDS are approaching and
starting April 2nd, 2008, IBM is offering price incentives...
ibmsoftwarequestions@bellmicro.eu
|
04-02-2008 05:35 AM
ibmsoftwarequestions@bellmicro.eu | 0 | 1 |
| | | Hi Jack
controlling the btree cleaner with onstat -C you could see one cleaner
working on one table all the time with type leaf. Informix support...
Habichtsberg, Reinhard
|
04-02-2008 03:05 AM
Habichtsberg, Reinhard | 0 | 1 |
| | | Yup.
Thats right folks.
Someone put enough lipstick on that blue pig to make it attractive enough that I would actually want to rejoin the IBM Borg...
Ian Michael Gumby
|
04-01-2008 11:09 PM
Ian Michael Gumby | 4 | 5 |
| | | Am I being a bit stupid with this......
Informix 9.40.FC8X3
Solaris 9
I have a table
create table stathist
(
Colin Dawson
|
04-01-2008 04:57 PM
Paul Watson (Oninit) | 9 | 10 |
| | | Hello,
Does anyone know of or have any success using any third party products
to replicate an Informix instance across two servers with...
Clancy
|
04-01-2008 04:13 PM | 3 | 4 |
| | | Hi,
I found a beautiful link for PeopleSoft Application Engine and
PeopleSoft Performance Tuning. The articles are really worth reading..
Have a...
Gungun
|
04-01-2008 10:12 AM
Gungun | 0 | 1 |
| | | Hello,
Im having those errors:
Summaries Failed Reason...
Paul
|
04-01-2008 09:44 AM
TBP | 2 | 3 |
| | | hi all
if there is a possibility that hadr is not 100%, what checks are there
that can be run besides the usual onstat -g dri, etc?
thanks
tomcaml@gmail.com
|
04-01-2008 03:46 AM
Ben Thompson | 3 | 4 |
| | | I'm pleased to announce another release of Ruby/Informix, a Ruby
library for connecting to IBM Informix.
In this release you'll find support for the...
Gerardo Santana
|
04-01-2008 01:15 AM
Gerardo Santana | 0 | 1 |
| | | dcruncher4 (AT) aim (DOT) com wrote:
between process and threads appears to be the most pronounced.
The true benefit of multi-threading (which btw...
Serge Rielau
|
03-31-2008 07:09 AM
Serge Rielau | 0 | 1 |
| | | --------------------------------------------------------------------
Washington Area Informix User Group meeting - Thursday April 3,...
Lester Knutsen
|
03-30-2008 11:09 PM
Lester Knutsen | 0 | 1 |
| | | Hi,
Dear Friends,
Enclosed is the Teradata Requirement, Client is MNC Client.
Position: 4 Teradata Consultants
Job Location: ...
zainab
|
03-28-2008 08:39 AM
zainab | 0 | 1 |
| | | Hi,
Does anyone know which table in sysmaster or some other easy way to get the number of seconds an instance has been up ?
The onstat commands give...
Floyd Wellershaus
|
03-28-2008 08:30 AM
iiug@perrior.net | 3 | 4 |
| | | Hi,
I would like to be able to default all database to create with logging
enabled (unbuffered).
We have a number of historical scripts with "CREATE...
Jarrod Teale
|
03-28-2008 03:33 AM
Marco Greco | 3 | 4 |
| | | Laurie Gustin wrote:
If AIO how many AIO VPs are defined? How many "active" chunks have you got?
TBP
|
03-27-2008 09:21 PM
John Carlson | 3 | 4 |
| | | IDS10 on AIX 5.3.
Sorry if this has been asked before, but I still don't have a satisfactory answer.
We are trying to determine exactly how much...
Floyd Wellershaus
|
03-27-2008 06:45 PM
Paul Watson (Oninit) | 7 | 8 |
| | | http://www.internetnews.com/software/article.php/3736336
I guess IBM doesn't have enough on its plate just differentiating IDS and
DB2, huh?
--
Bye...
Obnoxio The Clown
|
03-27-2008 05:06 PM
eric@herber-consulting.de | 2 | 3 |
| | | Hello everybody!
Please help me or my boss will kill me :(
What do we have:
HP-UX 11.11 (PA-RISC)
Informix IDS 9.3 FC6 with ~4TB database
And date...
pavel-lechenko@yandex.ru
|
03-27-2008 11:16 AM
pavel-lechenko@yandex.ru | 4 | 5 |
| | | sorry i am a new babie in INFORMIX sql
can i ask you guys help me to convert this?
select MyLocationStatus as...
vchu via DBMonster.com
|
03-27-2008 10:57 AM
Paul Watson (Oninit) | 8 | 9 |
| | | I want to know
- How to measure/estimate the Network Bandwidth for a HDR pair
over a WAN ?
- What will happen to the performance of the Primary...
tc
|
03-27-2008 10:30 AM
tc | 2 | 3 |
| | | Has anyone experimented with DBTEMP spaces in a Solaris tmpfs filesystem
and has this helped boost performance for sorts/merges ?
Lello, Nick
|
03-27-2008 07:15 AM
Clive Eisen | 1 | 2 |
| | | Hello,
I need to see what disk informix uses and how is it memory usage..
df -k dont list because are Raw devices, so how can i see it?
tks
Paul
|
03-27-2008 06:41 AM
Art S. Kagel (Oninit) | 5 | 6 |
| | | When using dbaccess from the command line to run a query, is there any
way to tell it to omit column headers?
Also, is there any way to only return...
KStahl
|
03-27-2008 03:29 AM
Claus Samuelsen | 3 | 4 |
| | | Plan to buy a book on informix sql programming
so that i can learn not just the synatx, but the cursor, store procedure....
etc
any...
vchu via DBMonster.com
|
03-26-2008 07:19 PM
Fernando Nunes | 4 | 5 |
| | | Try the following:
create table test(id serial, dd INTERVAL DAY(9) TO DAY);
insert into test values(0, INTERVAL(99) DAY TO DAY);
insert into test...
Gerardo Santana
|
03-26-2008 03:43 PM
Gerardo Santana | 6 | 7 |
| | | http://money.cnn.com/news/newsfeeds/articles/marketwire/0378885.htm
To cut to the chase....
IBM is now an investor in to Postgress.
If Informix is...
Ian Michael Gumby
|
03-26-2008 11:40 AM
DA Morgan | 6 | 7 |
| | | But how about Novell? (Novell OS and Linux OS)
Then there's Cisco (Cisco product line and Linksys product line overlap)
I'm sure if we think about...
Ian Michael Gumby
|
03-26-2008 09:49 AM
Ian Michael Gumby | 64 | 65 |
| | | All,
Could someone please send me an Informix .db file? I am trying to
debug something that is translating Informix .db's to text. I do not
have...
bill
|
03-26-2008 01:51 AM
Jonathan Leffler | 4 | 5 |
| | | do we have something like
select format(create_dt, "yyyy-mm-dd"),
format(create_dt,"hh:mm") from anInformaixTable;
Thanks
Victor
--
Message posted...
vchu via DBMonster.com
|
03-25-2008 11:32 AM
vchu via DBMonster.com | 10 | 11 |
| | | what will a quantum program look like?
for instance shores algorithm
mvdbms@googlemail.com
|
03-21-2008 07:55 PM
mvdbms@googlemail.com | 8 | 9 |
| | | We are planning to upgrade from Informix 7.30 to 7.31 (I Know!!!). after the upgrade if we encounter any problems and if we need to go back to 7.30,...
navdeep virk
|
03-20-2008 06:28 PM
Art S. Kagel (Oninit) | 3 | 4 |
| | | Yes,
But remember, if you're getting frustrated with a level 1 or level 2 support person (level 3 is the lab engineer), always ask to speak to a...
Paul Watson (Oninit)
|
03-20-2008 10:59 AM
Ian Michael Gumby | 16 | 17 |
| | | My box is aix 5.3 , ids 10 FC3R1.
I start my ids and run 'onstat -d'
700000031d801c8 14 10 0 512000 0 PD-B ...
roger@star2000.com.tw
|
03-20-2008 06:47 AM
Art S. Kagel (Oninit) | 1 | 2 |
| | | Chessington, Surrey - March 17th 2008: Specialist value-added
distributor, Bell Micro today announced that it has won the inaugural
IBM VAD Software...
ibmsoftwarequestions@bellmicro.eu
|
03-20-2008 06:29 AM
ibmsoftwarequestions@bellmicro.eu | 0 | 1 |
| | | --
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby (AT)...
Neil Truby
|
03-20-2008 06:23 AM
Martin Fuerderer | 5 | 7 |
| | | Hi Family,
This is your errant, infrequently writing relative with a question
that seemed to stump my tech support guy.
My users had a minor scare...
Beau Nanaz
|
03-20-2008 12:49 AM
Beau Nanaz | 2 | 6 |
| | | Ian Michael Gumby wrote:
Sounds like a job for XPS!
Art S. Kagel
Oninit
InDeep
|
03-19-2008 11:39 AM
Art S. Kagel (Oninit) | 15 | 23 |
| | | Gregory House wrote:
Sorry Greg, missed the reference in the Subject. You should be able to
shutdown the instance with onmode -ky to shutdown the...
G.House72@gmail.com
|
03-19-2008 09:49 AM
Art S. Kagel (Oninit) | 4 | 6 |
| | | http://www.channelinsider.com/c/a/Surveys/CIPOY-DB/
PS You should be voting for IDS, yeah? :o)
--
Bye now,
Obnoxio
"There were a myriad of...
Obnoxio The Clown
|
03-19-2008 04:41 AM
Obnoxio The Clown | 0 | 5 |
| | | Hello! Does any body know how I can to calculate users IDLE time in informix
9.3 on Win2000serv?
--
Message posted via...
mostv via DBMonster.com
|
03-19-2008 03:07 AM
mostv via DBMonster.com | 2 | 6 |
| | | Hello! If I have one chunk corrupted - how I can restore it? I have arhive 0
level and I don't want to restore all. Thanks.
--
Message posted via...
mostv via DBMonster.com
|
03-19-2008 02:54 AM
mostv via DBMonster.com | 3 | 6 |
| | | When I run onstat -g dis, it shows "There are 5 servers found".
However, there are only 2 unique Server Numbers and 2 unique onconfigs.
There...
Joe Armenta
|
03-19-2008 01:46 AM
Joe Armenta | 3 | 7 |
