Description:
Informix database management software discussions.
|
|
|
On Dropping chunks
|
| |
Hi there. I have the following question. Can I drop a chunk which is not the initial for dbspace, but it's not the last one either? Because I am in this situation: the second of three chunks on the same dbspace is empty according with Server Studio, but with TBLSpace entries on it. When I try to drop it using Server Studio or onspaces send me a chunk not empty message. Since I am reorganizing storage in order to reclaim some space for another dbspace with lack of space, what should I do to reclaim that empty chunk? Should I drop chunks in order and then I would drop last chunk in dbspace first? Or I should to clean up entire dbspace and drop everything?... more »
|
|
|
indexing with partition question(s)
|
| |
Hello, We are going to have a long denormalized table soon. It will be filled with records that get marked deleted ( rec_type=d ), and of course other rec_types. But the largest part of the table that I want to eliminate in queries are the deleted records. So I was thinking of fragmenting the table by rec_type.... more »
|
|
|
IBM's market share in databases on unix
|
| |
And I thought professional whiners in cdi claim that Oracle is more than IBM + Microsoft combined after IBM took over Informix. Taken from today's WSJ article Larry Ellison, chief executive of software giant Oracle Corp., has recently suggested his company's acquisition of Sun Microsystems—a major player in Unix... more »
|
|
|
LinkedIn discussion
|
| |
Friends: I just posted a new topic to the LinkedIn Database Developers and Architects group (DDAG) along with a first post. I invite the entire Informix User community to join the discussion. State why you love IDS, why others would love it if they had the chance to use it, what IDS's best old and new... more »
|
|
|
A special shout out to Jerry K.
|
| |
Yo! Jerry K! I'm hurt that you don't call or write. Where's the love? The reason I'm dropping you this line is that as things move forward, people are starting to see that if IBM wanted their opinion on things, IBM would have told them what to think. Meaning that IBM doesn't really want feedback from the Informix community.... more »
|
|
|
catch exception within a foreach loop and move to the next row
|
| |
I am trying to populate a table (B )based with some data from another table (A) but at the same time should not override what it is in there. So I created a stored procedure that has a foreach loop similiar to this FOREACH cs_insert FOR SELECT cust_num INTO v_cust_num FROM A INSERT INTO B(cust_num) VALUES(v_cust_num)... more »
|
|
|
STDIO L0 restore plus logical log restore with ontape
|
| |
Hi, I need to restore a gzipped ifx level zero backup pluss some logical logs. However I can't ungzip the file first because of lack of big storage for the uncompressed file and the performance and time penalty of writing 50+ GB to disk and then reading it during a restore. The CPU is much faster at decompressing the gzip on the fly.... more »
|
|
|
Suspending HDR temporarily?
|
| |
I would like to populate a bunch of tables in database 'B" with consistent data from similar tables in database 'A'. Database 'A' is the secondary of an HDR pair, whose primary is a production database. To get consistent data, I could stop replication, and extract from database 'A' while no other users are connected. That way I could use... more »
|
|
|
Informix Mirroring
|
| |
Hello, I was reading up on Informix Disk/Chunk Mirroring and was wondering if anyone has any experience using Informix mirroring versus O/S or Hardware mirroring relating to performance? Also, is this a typo in the Informix documentation for mirroring? See the sentences, "On the other hand, when an mirrored chunk goes... more »
|
|
|
|
