configure database on other system
Hi all, I want to configure a database on another system because of capacity problems. I want to store my customers data on that other machine. I'm am running on SuSe 10.1 with IDS 9.40. Is there anywhere some documentation about this topic? Met vriendelijke groeten / Sincères salutations / Kind regards, Danny De Koster <mailto:ddk@fidelity-soft.be> <http://www.fidelity-soft.be>; <http://www.fidelity-soft.be/>; <http://www.fidelity-soft.be>; <http://www.fidelity-soft.be>;
Create your table on the other system and load it. - set up these files on each server so that each instance can connect to each other - /etc/hosts - /etc/hosts.equiv - $INFORMIXDIR/etc/sqlhosts - in your current system, create a synonym to the new remote one: "create synonym table_name for rem_database@rem_server:table_name" (something like that!) Hope this helps, but be warned, there are arguments for and against using synonyms to remote servers. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Danny De Koster Sent: Tuesday, April 17, 2007 4:49 AM To: ids@iiug.org Subject: configure database on other system [8927] Hi all, I want to configure a database on another system because of capacity problems. I want to store my customers data on that other machine. I'm am running on SuSe 10.1 with IDS 9.40. Is there anywhere some documentation about this topic? Met vriendelijke groeten / Sincères salutations / Kind regards, Danny De Koster <mailto:ddk@fidelity-soft.be> <http://www.fidelity-soft.be>; <http://www.fidelity-soft.be/>; <http://www.fidelity-soft.be>; <http://www.fidelity-soft.be>; ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Danny,
The easiest way is for you to create the table on other machine and then on
the machine where you have your main database - create a synonym referring to
the table on other machine.
create synonym your_table_name for oth-mc-db-name@oth-mc-tcp:oth-mc-table-name;
Sunil.
________________________________
From: ids-bounces@iiug.org on behalf of Danny De Koster
Sent: Tue 4/17/2007 9:49 AM
To: ids@iiug.org
Subject: configure database on other system [8927]
Hi all,
I want to configure a database on another system because of capacity problems.
I want to store my customers data on that other machine.
I'm am running on SuSe 10.1 with IDS 9.40.
Is there anywhere some documentation about this topic?
Met vriendelijke groeten / Sincères salutations / Kind regards,
Danny De Koster <mailto:ddk@fidelity-soft.be>
<http://www.fidelity-soft.be <http://www.fidelity-soft.be/>; >
<http://www.fidelity-soft.be/>;
<http://www.fidelity-soft.be <http://www.fidelity-soft.be/>; >
<http://www.fidelity-soft.be <http://www.fidelity-soft.be/>; >
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
********************************************************************************
*******************
The information in this email is confidential and may be legally privileged
Access to this email by anyone other than the intended addressee is
unauthorized. If you are not the intended recipient of this message, any
review, disclosure, copying, distribution, retention, or any action taken or
omitted to be taken in reliance on it is prohibited and may be unlawful. If
you are not the intended recipient, please reply to or forward a copy of this
message to the sender and delete the message, any attachments, and any copies
thereof from your system.
********************************************************************************
*******************