Hi Henry, Do I need to purchase a separate licence to use the DJRA ? Thanks & Regards, Shirley.
"Henry J. Cobb" <[EMAIL PROTECTED]>@Lugwash.org on 02/01/2003 12:57:00 Please respond to "Henry J. Cobb" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: [DB2EUG] failover database > 1. There is about 400 tables in the database. If I need to replicate the > whole database, is there an easy > way to set up the subscription for the entire database. Currently I > have to set up the replication at > the table level. It will be very tedious to set up 400 tables. With DJRA, you just define the replication parameters, select all the table names from the list and let it rumble. (Good time for a coffee break while you wait for it to ping back and forth between the two databases as it copies the table configurations over one at a time.) Make sure you get a recent DJRA version and you may want to tinker with the tablespace configuration ReXX scripts. > 2. In order to set up a standby database at the DR site, I need to prepare > some scripts > to move archive logs, ftp and applying at standby. I do not have much > experience on > writing scripts, can someone give me some sample scripts to be used at > the NT platform ? You will know Perl by the time you've got your database backup scripts running, regardless of the language you start out in. The best part about using Perl on NT is that it can monitor the perfmon entries over a group of servers and then mail you when the database is bogging down. You have a VPN to allow direct NT file sharing between the two sites rather than depending on a third party FTP or SSH addon I hope? After six months without sleep, post your hardware configuration here and I'll help you upgrade the database servers to Linux. (Due to the performance jump, I strongly suspect that DB2/UDB is programmed to a Unix I/O model and then has a clumsy adaption layer dragging it down on eNp-Ty, but it could just be the internal file cache handling inside the OS.) -HJC - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
------------------------------------------------------------------------This email is intended for the named recipient only. The informationcontained in this message may be confidential, or commerciallysensitive. If you are not the intended recipient you must not reproduceor distribute any part of the email, disclose its contents to any otherparty, or take any action in reliance on it. If you have received thisemail in error, please contact the sender immediately. Please deletethis message from your computer.------------------------------------------------------------------------
