473,383 Members | 1,929 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

db2/UDB replication problems (maybe ...?) - Help needed

Hi ,

I have an existing database (on a Linux Red Hat ES3) where the
replication function exists but does not work because the target
database has been shutdown months ago .

My question is what will happens if i start the target database ?

Will there be problems with the source database or the target database
(decreasing performance or other kinds of problem )?

For info , the database is 6,7 Go (or 6.7 Go in US measure) . The
source database is on a server and the target database on an another
server (physically) . The target database is shutdown .

Any help is welcome .

Andy the beginner in DB2 .

ps1 : is there any possibilities to setup a replication processus
without the DB2 control center ? (it seems to be no after the
documents I have read but who knows ... )

ps2 : that control center seems to be quite annoying especially if the
linux server has been secured and doesn't allow graphical screening !
Nov 12 '05 #1
7 1987
Andy K wrote:
Hi ,

I have an existing database (on a Linux Red Hat ES3) where the
replication function exists but does not work because the target
database has been shutdown months ago .

My question is what will happens if i start the target database ?

Will there be problems with the source database or the target database
(decreasing performance or other kinds of problem )?
Seems to me they will be sync-ed, but I could be wrong.
Since this is what replication is intended for, there shouldn't be too
much performance problems. But to be sure you better wait for a response
from someone who actually knows what's he's talking about.
For info , the database is 6,7 Go (or 6.7 Go in US measure) . The
source database is on a server and the target database on an another
server (physically) . The target database is shutdown .

Any help is welcome .

Andy the beginner in DB2 .

ps1 : is there any possibilities to setup a replication processus
without the DB2 control center ? (it seems to be no after the
documents I have read but who knows ... )
It seems to me that everything that can be done with CC can also be done
commandline.
ps2 : that control center seems to be quite annoying especially if the
linux server has been secured and doesn't allow graphical screening !


Try to use trusted X forwarding over SSH (ssh -Y). (Need to activate X
forwarding in SSHD_CONFIG though). Works for me.

PS. I'm not that familiar with Replication, so alas, I can't help on the
other topics.
Nov 12 '05 #2
Hi Andy,

Andy K wrote:
I have an existing database (on a Linux Red Hat ES3) where the
replication function exists but does not work because the target
database has been shutdown months ago .

My question is what will happens if i start the target database ?
Nothing bad will happen by just starting the database. If you start the
apply-process and there is remaining (not pruned) data in the cd-tables,
this data will be applied.
Will there be problems with the source database or the target database
(decreasing performance or other kinds of problem )?
as usual...it depends (amount of data to be applied, other applications
running against the database)....

Was the capture-process on the source-database running all the time?
Then you should have a reasonable amount of data in the cd-tables. If
you have stopped the capture-process you would need to have all logfiles
written by the source database since capture has been shut down. Else,
capture will not work properly and you would need to do a
(manual/automatic) full refresh.
ps1 : is there any possibilities to setup a replication processus
without the DB2 control center ? (it seems to be no after the
documents I have read but who knows ... )
1. Learn by the scripts, Replication Center creates for you. You can
easily modify them or write your own wrappers around them.
2. "SQL-Replication Guide and Reference" is the source you are looking for.
3. short list of commands you need to look up to run replication from
the command-line: asncap, asnapply, asnacmd, asnccmd, asnanalyze.
ps2 : that control center seems to be quite annoying especially if the
linux server has been secured and doesn't allow graphical screening !


I understand you are running the control center on the server where the
database resides. This is not optimal in many ways.

If the Administration Server is running on the server you should be able
to run the graphical tools on your client without any X-forwarding at all.

Yes, control center _is_ annoying like any other graphical java
interface that I have seen so far, but it is getting better from release
to release . Fortunately there are many ways to run and monitor DB2 UDB
without running a gui at all. ;-)

regards,

Norbert
Nov 12 '05 #3
Hi again,

Norbert Munkel wrote:
Nothing bad will happen by just starting the database. If you start the

^^^^^^^^^^^

If your replication is set up to do allow automatic full refreshs, full
loads/imports of the replicated tables may occur including possible
performance issues (fullselect on the source-tables, network-activity....).

regards,

Norbert
Nov 12 '05 #4
Hi Norbert ,

Thanks for the insight . I'm going to do my homework for DB2 (glups !)
..

Btw is there catalog view for replication ?

In Oracle (1st love) , there is a couple of dynamic views like
dba_snapshots or ALL_SNAPSHOT_REFRESH_TIMES that can be really helpful
.. Something similar with DB2 ?

Regards,
Andy

Nov 12 '05 #5
In article <11*********************@g44g2000cwa.googlegroups. com>,
Andy K (ak****@yahoo.com) says...
Hi Norbert ,

Thanks for the insight . I'm going to do my homework for DB2 (glups !)
.

Btw is there catalog view for replication ?

In Oracle (1st love) , there is a couple of dynamic views like
dba_snapshots or ALL_SNAPSHOT_REFRESH_TIMES that can be really helpful
. Something similar with DB2 ?

Regards,
Andy


Hi Andy,

If you want to create the replication definitions from the
commandline you can use the asnclp command. You can download the
manual from http://publibfp.boulder.ibm.com/epubs/pdf/c1894100.pdf
Nov 12 '05 #6
Hi Gert ,

Thanks for the documentation . But asnclp is not available on "v7" for
DB2 .

Any suggestion is HIGHLY welcome ! :-D

Regards,
Andy

Gert van der Kooij a écrit :
In article <11*********************@g44g2000cwa.googlegroups. com>,
Andy K (ak****@yahoo.com) says...
Hi Norbert ,

Thanks for the insight . I'm going to do my homework for DB2 (glups !) .

Btw is there catalog view for replication ?

In Oracle (1st love) , there is a couple of dynamic views like
dba_snapshots or ALL_SNAPSHOT_REFRESH_TIMES that can be really helpful . Something similar with DB2 ?

Regards,
Andy


Hi Andy,

If you want to create the replication definitions from the
commandline you can use the asnclp command. You can download the
manual from http://publibfp.boulder.ibm.com/epubs/pdf/c1894100.pdf


Nov 12 '05 #7
In article <11**********************@g47g2000cwa.googlegroups .com>,
Andy K (ak****@yahoo.com) says...

Hi Andy,

If you want to create the replication definitions from the
commandline you can use the asnclp command. You can download the
manual from http://publibfp.boulder.ibm.com/epubs/pdf/c1894100.pdf

Hi Gert ,

Thanks for the documentation . But asnclp is not available on "v7" for
DB2 .

Any suggestion is HIGHLY welcome ! :-D

Regards,
Andy


Hi Andy,

I've created my own batch scripts by tracing the DJRA tool output.
The DJRA tool is written in REXX so I created my own scripts which
(after specifying all needed variables) generates replication
definitions automatically for over 300 tables.
But because DJRA isn't available on V8 anymore it's the wrong choice
if you need to use it on V8 some day. I have to 'migrate' my own
script and start using asnclp when our client migrates to V8.
Nov 12 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Eirik Tryggeseth | last post by:
During deployment of an application using distributed transactions managed under COM+ on an Oracle 9i RAC database, we encounter situations where the load balancing mechanisms in the RAC result in...
0
by: Dathan Vance Pattishall | last post by:
------=_NextPart_000_0022_01C347A5.67020F30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit mysql-max-3.23.57-pc-linux-i686 I notice that slaves which never went...
2
by: Simon B. Nielsen | last post by:
I have set up a server with a publication of a very large database. A backup server needs to retrieve the data and do some massive calculations (which isn't really relevant). On the backup server...
0
by: Marko Damaschke | last post by:
Hello alltogether, i'm working on a database-plattform which should work with fail-over-technics. Therefor 2 identic machines with internal RAID are available, which work in...
2
by: carl.davis | last post by:
I am experiencing problems replicating (transactional) from SQL Server 2000 sp3 to DB2 v8.2 (running on Red Hat Linux). I have created an OLE-DB linked server to DB2. The connection connects...
0
by: Tek | last post by:
I have the following scenario: Box 1 is running Informix 7.31.UD4 on hpux 11i (Source DB) Box 2 is running IBM DB2 UDB 8.2 on hpux 11i (Apply and Target DB) After creating a new DB2 instance...
2
by: James dean | last post by:
I am using Graphics path in my application and i have located the slow areas in my rogram and it seems that the graphics path consistently is slow when doing any operation like adding another...
0
by: Harmeet Singh | last post by:
Hi I am trying to install Visual C# 2003 on my computer. But when I insert Disk#1, it asks me to insert the "Pre-requisits" CD. When I insert the "Pre-requisits" CD, it does nothing. I am stuck....
3
by: waheed azad | last post by:
Hi, I have a been developing an accounting system for a non-profit organization. I had decided to to divide the solution, in three layers, presentation, business layer and database layer. ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.