UDB 8.1 replication

[Mag]

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

[Mark A]

"Mag" <ma******@gmail.com> wrote in message
news:11*********************@c74g2000cwc.googlegro ups.com...

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

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.

[Larry]

Mag wrote:

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

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

[Mag]

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.<clin it>(Unknown Source)
at CC.<init>(Unknown Source)
at CC.main(Unknown Source)
DB2JAVIT : RC = 1

Larry wrote:

Mag wrote:

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

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

[Mark A]

"Mag" <ma******@gmail.com> wrote in message
news:11*********************@c74g2000cwc.googlegro ups.com...

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.<clin it>(Unknown Source)
at CC.<init>(Unknown Source)
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.

[Larry]

Mag wrote:

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.<clin it>(Unknown Source)
at CC.<init>(Unknown Source)
at CC.main(Unknown Source)
DB2JAVIT : RC = 1

Larry wrote:

Mag wrote:

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

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

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

[Shashi Mannepalli]

You can use ASNCLP

cheers...
Shashi Mannepalli

Larry wrote:

Mag wrote:

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.<clin it>(Unknown Source)
at CC.<init>(Unknown Source)
at CC.main(Unknown Source)
DB2JAVIT : RC = 1

Larry wrote:

Mag wrote:
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
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

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

[Mag]

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!

Shashi Mannepalli wrote:

You can use ASNCLP

cheers...
Shashi Mannepalli

Larry wrote:

Mag wrote:

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.<clin it>(Unknown Source)
at CC.<init>(Unknown Source)
at CC.main(Unknown Source)
DB2JAVIT : RC = 1

Larry wrote:

>Mag wrote:
>
>
>>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
>>
>
>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

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