UDB 8.1 replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mag - 04 Jun 2006 20:34 GMT

Hello,

I am new, and trying to learn DB2. I am trying to setup a simple
master-slave replication. Is there a way around using Replication
center? I want to stay away from the GUIs much as possible.

TIA

Reply to this Message

Mark A - 04 Jun 2006 21:40 GMT

> Hello,
>
[quoted text clipped - 3 lines]
>
> TIA

Use the GUI to create the scripts and save them for execution. Some of the
stuff is a bit too complicated to do from scratch unless you want to spend
many days reading the manual.

Reply to this Message

Larry - 04 Jun 2006 22:12 GMT

> Hello,
>
[quoted text clipped - 3 lines]
>
> TIA

I don't know why you would want to do something like this and NOT use
the GUI ... it will greatly simplify your effort.

Larry Edelstein

Reply to this Message

Mag - 04 Jun 2006 22:55 GMT

Thanks for all of your kind replies.

The reason why I would like to do it via command line is because, my
db2cc is not working.

When I try to start db2cc

export DB2USELOCALJRE=TRUE
export JAVA_HOME=/opt/IBMJava2-142
db2 update dbm cfg using JDK_PATH /opt/IBMJava2-142

I keep getting :

Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't find
library db2jcmn (libdb2jcmn.so) in sun.boot.library.path or
java.library.path
sun.boot.library.path=/opt/IBMJava2-142/jre/bin
java.library.path=/opt/IBMJava2-142/jre/bin:/opt/IBMJava2-142/jre/bin/classic:/opt/IBMJava2-142/jre/bin:/usr/lib
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:2044)
at java.lang.Runtime.loadLibrary0(Runtime.java:824)
at java.lang.System.loadLibrary(System.java:910)
at
com.ibm.db2.common.objmodels.dbobjs.DB2Level.<clinit>(Unknown Source)
at CC.<init>(Unknown Source)
at CC.main(Unknown Source)
DB2JAVIT : RC = 1

> > Hello,
> >
[quoted text clipped - 8 lines]
>
> Larry Edelstein

Reply to this Message

Mark A - 04 Jun 2006 23:42 GMT

> Thanks for all of your kind replies.
>
[quoted text clipped - 22 lines]
> at CC.main(Unknown Source)
> DB2JAVIT : RC = 1

I had a little trouble using the Replication GUI running on Windows in an
early release of an 8.1 remote database running on AIX. So I set up the
replication a local DB2 database running on Windows and created the scripts
using the GUI, then ran the scripts on AIX.

Reply to this Message

Larry - 04 Jun 2006 23:55 GMT

> Thanks for all of your kind replies.
>
[quoted text clipped - 35 lines]
>>
>>Larry Edelstein

Perhaps someone can help you here, but have you tried opening a case
with IBM?

Someone that I found who had a similar problem corrected it by finding
that LIBPATH was being unset in his profile. Someone else corrected a
similar problem by extending ld_library_path_64 with with ..
/sqllib/lib. Otherwise, have you checked your Sun patch levels and have
you applied the latest DB2 fixpak?

Larry Edelstein

Reply to this Message

Shashi Mannepalli - 05 Jun 2006 00:42 GMT

You can use ASNCLP

cheers...
Shashi Mannepalli

> > Thanks for all of your kind replies.
> >
[quoted text clipped - 46 lines]
>
> Larry Edelstein

Reply to this Message

Mag - 05 Jun 2006 13:39 GMT

Got it "working". On the local system still the same message, however
on a remote system, I export DISPLAY, and all is working well.

Thanks everyone for their help!

> You can use ASNCLP
>
[quoted text clipped - 51 lines]
> >
> > Larry Edelstein

Reply to this Message