Hello All,
I'm new to DB2, so apologies in advance for any stupid comments I
might make on this replication problem.
Using Information integrator and DB2 8.2 I managed to create a
nickname that references a table sitting on an Oracle 10g Database on
a different server.
I can reference the nickname and retrieve all the information on that
table from my DB2 instance.
The plan now is to have a replica of that table on my DB2 instance. I
decided to set-up a cached table as per DB2 documentation and this
process also created a Materialized Query Table which gets refreshed
using the nickname I had created earlier.
This process also created a replication schedule, capture control
server and control tables, apply control server and control tables on
the source and target databases.
All seemed to be going well but the replication was not working. After
an inspection into IBMSNAP_APPLYTR ACE I found the following error
message:
ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply
program encountered an SQL error. The ERRCODE is "BF0103". The
SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is
"GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "".
The table name is ""ASN".IBMSNAP_ REGISTER".
However I was unable to find a reference that would explain what
ERRCODE BF0103 is and now I haven't got a clue how to fix this
replication problem.
Any help or ideas would be greatly appreciated. 5 5286
Rafael,
you can look for the sqlcode. In your case it is 1101: db2 '? sql1101'
SQL1101N Remote database "<name>" on node "<node-name>" could
not be accessed with the specified authorization id
and password.
Explanation:
A connection to the remote database "<name>" on node
"<node-name>" was requested, and the remote node does not accept
the authorization ID and password combination specified for this
node (either in the remote authorization tables or at runtime).
The request cannot be processed.
User Response:
Resubmit the request with a valid authorization ID and password
combination for the remote system.
sqlcode : -1101
sqlstate : 08004
best regards,
Joachim Müller
"Rafael Faria" <rp******@hotma il.com> schrieb im Newsbeitrag
news:4b******** *************** ***@posting.goo gle.com... Hello All,
I'm new to DB2, so apologies in advance for any stupid comments I might make on this replication problem. Using Information integrator and DB2 8.2 I managed to create a nickname that references a table sitting on an Oracle 10g Database on a different server. I can reference the nickname and retrieve all the information on that table from my DB2 instance. The plan now is to have a replica of that table on my DB2 instance. I decided to set-up a cached table as per DB2 documentation and this process also created a Materialized Query Table which gets refreshed using the nickname I had created earlier. This process also created a replication schedule, capture control server and control tables, apply control server and control tables on the source and target databases. All seemed to be going well but the replication was not working. After an inspection into IBMSNAP_APPLYTR ACE I found the following error message:
ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply program encountered an SQL error. The ERRCODE is "BF0103". The SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is "GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "". The table name is ""ASN".IBMSNAP_ REGISTER".
However I was unable to find a reference that would explain what ERRCODE BF0103 is and now I haven't got a clue how to fix this replication problem.
Any help or ideas would be greatly appreciated.
Rafael Faria wrote: Hello All,
I'm new to DB2, so apologies in advance for any stupid comments I might make on this replication problem. Using Information integrator and DB2 8.2 I managed to create a nickname that references a table sitting on an Oracle 10g Database on a different server. I can reference the nickname and retrieve all the information on that table from my DB2 instance. The plan now is to have a replica of that table on my DB2 instance. I decided to set-up a cached table as per DB2 documentation and this process also created a Materialized Query Table which gets refreshed using the nickname I had created earlier. This process also created a replication schedule, capture control server and control tables, apply control server and control tables on the source and target databases. All seemed to be going well but the replication was not working. After an inspection into IBMSNAP_APPLYTR ACE I found the following error message:
ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply program encountered an SQL error. The ERRCODE is "BF0103". The SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is "GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "". The table name is ""ASN".IBMSNAP_ REGISTER".
However I was unable to find a reference that would explain what ERRCODE BF0103 is and now I haven't got a clue how to fix this replication problem.
Any help or ideas would be greatly appreciated.
BF must be th3 error code from replication...
SQLCODE 1101 complains about an autthorisation problem trying to access
GCTST01 on node GCTST01.
I leaning far out of the window here, but this is what I would investigate:
You knwo that teh regular II stuff is sane since you can use it.
So it boils down to the fact that this "daemon" uses another id for
which you don't have a user mapping.
Just a guess....
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Hello Rafael,
Rafael Faria wrote: ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply program encountered an SQL error. The ERRCODE is "BF0103". The SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is "GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "". The table name is ""ASN".IBMSNAP_ REGISTER".
As others have mentioned before, this seems to be a connection error.
Check the following things:
password-file: defaults to "asnpwd.aut " (this should be somewhere in the
instance-directory).
Database Catalog: Is the capturing database cataloged and reacheable
from the apply-control-servers side?
You can create the password-file with "asnpwd" and check your
configuration with "asnanalyze ".
Example:
"asnanalyze -pw $PATH_TO_PASSWO RD_FILE/asnpwd.aut -db db1 db2 dbn -la
DETAILED"
would create a file called "asnanalyze.htm " containing a lot of
information about the current status of your replication environment in
the current directory including possible connection probs.
Hope this helps a litle bit.
Regards,
Norbert
Thanks guys for your help. Where do you look for ERRCODES and SQL
error codes for DB2? We bought the product but we haven't received the
official CD's and doco. Is there a on-line reference? I coulldn't find
it.
I'll investigate further into the authentication problem and let you
know if it worked.
I wasn't aware that you had to specify a password file for the
replication process to use. I thought it would use the same AuthId and
password I specified when I created the user mapping (when defining
the source server definition in my "Federated Database Objects"
folder. If the replication process is not using that mapping to
connect to the source server it will not connect.
Thanks very much for your time and help.
Rafael
Norbert Munkel <nm@acoreus.d e> wrote in message news:<aQ******* *******@se2-cb104-9.zrh1.ch.colt. net>... Hello Rafael,
Rafael Faria wrote:
ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply program encountered an SQL error. The ERRCODE is "BF0103". The SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is "GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "". The table name is ""ASN".IBMSNAP_ REGISTER".
As others have mentioned before, this seems to be a connection error. Check the following things:
password-file: defaults to "asnpwd.aut " (this should be somewhere in the instance-directory).
Database Catalog: Is the capturing database cataloged and reacheable from the apply-control-servers side?
You can create the password-file with "asnpwd" and check your configuration with "asnanalyze ".
Example:
"asnanalyze -pw $PATH_TO_PASSWO RD_FILE/asnpwd.aut -db db1 db2 dbn -la DETAILED"
would create a file called "asnanalyze.htm " containing a lot of information about the current status of your replication environment in the current directory including possible connection probs.
Hope this helps a litle bit.
Regards,
Norbert
Rafael,
welcome to the DB2 Information Center: http://publib.boulder.ibm.com/infoce...help/index.jsp
that's for Tivoli: http://publib.boulder.ibm.com/infoce...help/index.jsp
and for pSeries/AIX: http://publib.boulder.ibm.com/infoce...ries/index.jsp
best regards,
Joachim Müller
"Rafael Faria" <rp******@hotma il.com> schrieb im Newsbeitrag
news:4b******** *************** ***@posting.goo gle.com... Thanks guys for your help. Where do you look for ERRCODES and SQL error codes for DB2? We bought the product but we haven't received the official CD's and doco. Is there a on-line reference? I coulldn't find it. I'll investigate further into the authentication problem and let you know if it worked. I wasn't aware that you had to specify a password file for the replication process to use. I thought it would use the same AuthId and password I specified when I created the user mapping (when defining the source server definition in my "Federated Database Objects" folder. If the replication process is not using that mapping to connect to the source server it will not connect.
Thanks very much for your time and help.
Rafael
Norbert Munkel <nm@acoreus.d e> wrote in message news:<aQ******* *******@se2-cb104-9.zrh1.ch.colt. net>... Hello Rafael,
Rafael Faria wrote:
> ASN1001E APPLY "DEPARTMENT_MQT _AQ" : "WorkerThre ad". The Apply > program encountered an SQL error. The ERRCODE is "BF0103". The > SQLSTATE is "08004". The SQLCODE is "-1101". The SQLERRM is > "GCTST01˙GCTST0 1". The SQLERRP is "SQLQ003b". The server name is "". > The table name is ""ASN".IBMSNAP_ REGISTER". >
As others have mentioned before, this seems to be a connection error. Check the following things:
password-file: defaults to "asnpwd.aut " (this should be somewhere in the instance-directory).
Database Catalog: Is the capturing database cataloged and reacheable from the apply-control-servers side?
You can create the password-file with "asnpwd" and check your configuration with "asnanalyze ".
Example:
"asnanalyze -pw $PATH_TO_PASSWO RD_FILE/asnpwd.aut -db db1 db2 dbn -la DETAILED"
would create a file called "asnanalyze.htm " containing a lot of information about the current status of your replication environment in the current directory including possible connection probs.
Hope this helps a litle bit.
Regards,
Norbert This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Amy |
last post by:
Hello All,
We are currently looking into archiving our production system. I have
looked into several different options to accomplish this, and Oracle
Replication is one of them.
Can anyone give me any info on Oracle Replication? We currently have
Oracle 8i, and it comes with the GUI interface Replication Manager,
which we would be using. We are running on a Windows environment. I
have read issues about having to monitor too...
|
by: Cherrish Vaidiyan |
last post by:
Hello,
I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.
1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication Management Tool in OEM.
What are the steps to be taken initailly for using Replication
Management Tool ?
|
by: Cherrish Vaidiyan |
last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>...
> Cherrish Vaidiyan wrote:
> > Hello,
> >
> > I have certain doubts regarding replication of Oracle 9i in Red Hat
> > Linux 9.
> >
> > 1) I want to implement asynchronous/synchronous multimaster
> > replication.I have heard about Replication Management Tool in OEM.
> > What are the steps to be taken initailly for using Replication
|
by: Cherrish Vaidiyan |
last post by:
hello,
Thanx for replying to my earlier Google group query about Replication
of Oracle 9i on RH9.IF the query followed is being repeated by me I am
sorry for it..
I want to implement replication by means of SQL commamnd prompt.Can u
help me with the sample script that you own.I can change the schema,
tables according to my need...Here is my situation of replication
requirement...
|
by: Cherrish Vaidiyan |
last post by:
Sir,
I have implemented asynchronous replication on 2 database located in 2
different system. I did it with Replication Management GUI Tool.
Before explaining the error i will explain my replication environment.
The details of the systems are
Hostname1- node2 Hostname2- node3
ip address- 192.168.0.232 id adress- 192.168.0.236
DB name- apple DB name- ibm
| |
by: Andras Kovacs |
last post by:
We have a performance problem to replicate our environnement.
Our java code is able to insert 100 000 rows in a table within 3
seconds using Batch Statement. For two oracle sites it takes 6 seconds
the inserts. When we enable oracle's advanced replication the time
falls to 44 seconds for the two replicated sites. So the transactions
took 7 times more time. It is normal Oracle states that Adv
replication takes around 6 times more resource...
|
by: RYAN |
last post by:
Hi All,
I am new to Oracle and I have some question that I hope that someone out
there can help me.
I have heard the Oracle Rman can do replication of Archives logs. In this
way, one can setup some sort or Oracle Instances replication accross 2
machine at different sites.
1. Does amyone know how is the performance of this method of replication as
|
by: steve |
last post by:
Hi,
several years ago , I implemented the oracle replication system.
At that time our database was ported from an old Fox pro application. ( K ,
no laughing at the back).
As the foxpro did not use "primary keys", I set up a replication column
|
by: mjan |
last post by:
Hello,
could you please advice on how to measure replication performance
in Oracle, DB2 & MS SQL Server RDBMS installed in Windows servers ?
I've got two servers with databases installed and configured,
I prepared set of data using DBGEN from TPC and I already imported them
into databases.Also, I configured the replication.
Now I have to do a test with a few kind of replications method
implemented in these RDMBS, but I don't know which...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |