Hi,
I am using Q Replication, I need to set to logging to capture changes on a
table but the table has more than 18 characters for the name, I looked at
the docs, it mentioned that table names with more than 18 characters are
allowed in DB2 V8 but when you turn on logging, it will not turn on logging.
Is there a work around to this?
Thanks 11 2525
RdR wrote: Hi,
I am using Q Replication, I need to set to logging to capture changes on a table but the table has more than 18 characters for the name, I looked at the docs, it mentioned that table names with more than 18 characters are allowed in DB2 V8 but when you turn on logging, it will not turn on logging. Is there a work around to this?
What exactly did you do and what's the error message you got?
Have a look at the doc for ALTER TABLE. It states that the DATA CAPTURE
option is not supported if the schema name is longer than 18 characters.
Maybe that's the case for you?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Hi Knut,
Thank you for your email.
This is the message I am getting when I set one of those tables with a name
with >18 characters to be propagated. I am sure you know that DATA CAPTURE
needs to be turned on to be able to replicate data using Q Replication (or
for that matter SQL Replication (DPROP) as well).
Other than renaming the table to something with 18 or less than an 18
character name, are there other work arounds, is there a switch somewhere
that I can use to turn DATA CAPTURE ON without going through the ALTER TABLE
command?
What I do is define this table to be replicated and I think QReplication
sends an ALTER TABLE command to DB2 and encounters the more than 18
character limit for turning DATA CAPTURE on. Seems like DB2 Version 8 does
not have the 18 character name limitation but in terms of setting DATA
CAPTURE on, still has this limitation. One reason that DATA CAPTURE is not
on is that this cannot be done manually as well.
It is just a bit of work to rename about 100 or so table with this case.
Knowing a work around will save me lots of time. Appreciate any sugestions.
Again, all my thanks.
RdR
"Knut Stolze" <st****@de.ibm. com> wrote in message
news:dj******** **@lc03.rz.uni-jena.de... RdR wrote:
Hi,
I am using Q Replication, I need to set to logging to capture changes on
a table but the table has more than 18 characters for the name, I looked
at the docs, it mentioned that table names with more than 18 characters are allowed in DB2 V8 but when you turn on logging, it will not turn on logging. Is there a work around to this?
What exactly did you do and what's the error message you got?
Have a look at the doc for ALTER TABLE. It states that the DATA CAPTURE option is not supported if the schema name is longer than 18 characters. Maybe that's the case for you?
-- Knut Stolze DB2 Information Integration Development IBM Germany
In article <cs************ ********@rogers .com>, ro*@delrosario. ca
says... This is the message I am getting when I set one of those tables with a name with >18 characters to be propagated. I am sure you know that DATA CAPTURE needs to be turned on to be able to replicate data using Q Replication (or for that matter SQL Replication (DPROP) as well).
I assume you are not using DB2 LUW, but DB2 AS/400 or DB2 OS390?
RdR wrote: Hi Knut,
Thank you for your email.
This is the message I am getting when I set one of those tables with a name with >18 characters to be propagated. I am sure you know that DATA CAPTURE needs to be turned on to be able to replicate data using Q Replication (or for that matter SQL Replication (DPROP) as well).
Other than renaming the table to something with 18 or less than an 18 character name, are there other work arounds, is there a switch somewhere that I can use to turn DATA CAPTURE ON without going through the ALTER TABLE command?
What I do is define this table to be replicated and I think QReplication sends an ALTER TABLE command to DB2 and encounters the more than 18 character limit for turning DATA CAPTURE on. Seems like DB2 Version 8 does not have the 18 character name limitation but in terms of setting DATA CAPTURE on, still has this limitation. One reason that DATA CAPTURE is not on is that this cannot be done manually as well.
Well, what exactly have you done manually and what exactly was the error
message that you got?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Knut,
you are quite right.
when choosing to enable a table for replication in the control center,
it does a
'alter table ... data capture on'
so that is not supported for tablenames longer than 18 character.
Funny, I guess, the replication system tables where not updated for
longer table names ... :-)
Hi Knut,
I ran the ALTER TABLE command to turn on DATA CAPTURE for that table with
characters with more than 18 characters and the error message I got was the
mesage you pointed to that table schemas with more than 18 characters for
the name cannot be enabled for DATA CAPTURE.
This is on a UDB V8 for AIX.
Seems like UDB allows for table names more than 18 characters but if you use
QReplication or DPROP to replicate tables with more than 18 characters for
the name, it is not supported for replication. Hmmmmmmm.
RdR
"Knut Stolze" <st****@de.ibm. com> wrote in message
news:dj******** **@lc03.rz.uni-jena.de... RdR wrote:
Hi Knut,
Thank you for your email.
This is the message I am getting when I set one of those tables with a name with >18 characters to be propagated. I am sure you know that DATA CAPTURE needs to be turned on to be able to replicate data using Q Replication (or for that matter SQL Replication (DPROP) as well).
Other than renaming the table to something with 18 or less than an 18 character name, are there other work arounds, is there a switch
somewhere that I can use to turn DATA CAPTURE ON without going through the ALTER TABLE command?
What I do is define this table to be replicated and I think QReplication sends an ALTER TABLE command to DB2 and encounters the more than 18 character limit for turning DATA CAPTURE on. Seems like DB2 Version 8
does not have the 18 character name limitation but in terms of setting DATA CAPTURE on, still has this limitation. One reason that DATA CAPTURE is
not on is that this cannot be done manually as well.
Well, what exactly have you done manually and what exactly was the error message that you got?
-- Knut Stolze DB2 Information Integration Development IBM Germany
juliane26 wrote: Knut,
you are quite right. when choosing to enable a table for replication in the control center, it does a 'alter table ... data capture on'
so that is not supported for tablenames longer than 18 character.
The thing is that the documentation only talks about schema names that must
not be longer than 18 characters. It doesn't say anything about the
unqualified table name. Therefore, I really would like to see the _exact_
SQL statement and the _exact_ output that was produced by DB2. So far, we
only got some verbose descriptions of the scenario, which makes it more
complicated to reproduce and verify. Thus, I would not make a call whether
this works as documented (and is actually a user error) or if the
documentation is wrong and there is an additional restriction. So please,
post the complete ALTER TABLE SQL statement and the complete error message.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Hi Knut,
I will get you the actual commands and the result, only thing is, I have
already renamed the tables as my workaround so I cannot readily run it right
now, I would either have to sift through the logs or create another table
with the same characteristics to get you what you mentioned, once I
implemented this, I will get you these and post it here. I just need to beat
my implementation date before I can do further troubleshooting .
But it is easy to recreate the issue, create a table that has a schema name
that has more than 18 characters for the name and do an ALTER TABLE on the
schema name to set full logging to ON. I might also have column names with
names greater than 18 characters, table is just a simple table composed of
chars, varchars, etc. (no BLOBS, CLOBS and the like).
My question was not whether the documentation was correct or not, it is more
if there is a workaround other than renaming the tables concerned. In my
situation, the issue was trivial to open a PMR with IBM with this issue if
ever it was really an issue.
Thanks for all the ideas though.
RdR
"Knut Stolze" <st****@de.ibm. com> wrote in message
news:dj******** **@lc03.rz.uni-jena.de... juliane26 wrote:
Knut,
you are quite right. when choosing to enable a table for replication in the control center, it does a 'alter table ... data capture on'
so that is not supported for tablenames longer than 18 character. The thing is that the documentation only talks about schema names that
must not be longer than 18 characters. It doesn't say anything about the unqualified table name. Therefore, I really would like to see the _exact_ SQL statement and the _exact_ output that was produced by DB2. So far, we only got some verbose descriptions of the scenario, which makes it more complicated to reproduce and verify. Thus, I would not make a call
whether this works as documented (and is actually a user error) or if the documentation is wrong and there is an additional restriction. So please, post the complete ALTER TABLE SQL statement and the complete error
message. -- Knut Stolze DB2 Information Integration Development IBM Germany
I did some digging. Replication does support 128 character table names.
This is plain and simple an outdated restriction in ALTER TABLE (aka a
bug).
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: baustin75 |
last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie
only when debugging in php designer 2005
--------------------------------------------------------------------------------
Hello,
I have a very simple problem but cannot seem to figure it out. I have a
very simple php script that sends a test email to myself. When I debug
it in PHP designer, it works with no problems, I get the test email. If
|
by: Christoph Sticksel |
last post by:
Hi,
I'm having problems with attaching two tables stored in an SQL Server
2000 to an Access 97 database. It worked well for all other tables
except those two.
This is what I did: Choose the data source from the ODBC dialog, choose
the database on SQL Server login, select all tables in the SQL Server
database. All tables were attached except the two, it says something
like "database module can't find 'dbo_<tablename>'".
|
by: Krish |
last post by:
I have created 2 tables, both tables have the same column names (property
ColumnName) it is priceDate,priceTime and priceValue
I get an error saying that Column priceDate already belongs to another datatable .
Is it correct that the 2 tables cannot have the same column names.
I am trying to create a data relation to get the common dates.
|
by: Fergus Cooney |
last post by:
Hi Everyone,
I finished playing newgroupie this morning and went to bed. When I came
back, I couldn't get any new messages for this group. I'm using Outlook
Express. It showed the newsgroup highlighted in the Folder View with the
number of new messages in brackets. When I went into the folder, however, it
just sat there and wouldn't go get the new messages. The other newsgroups,
eg csharp, were business as usual.
After a loads of...
|
by: Chris Smith |
last post by:
Hola, pythonisas:
The documentation for the logging module is good, but a bit obscure.
In particular, there seems to be a lot of action at a distance.
The fact that getLogger() can actually be a call to Logger.__init__(),
which is mentioned in para 6.29.1, also bears stressing on 6.29. I
grasp _why_ you'd implement it that way, but I may not be the only
coder who feels queasy with the word 'get' being used both to fetch
an instance and...
| |
by: robert |
last post by:
As more and more python packages are starting to use the bloomy
(Java-ish) 'logging' module in a mood of responsibility and as I am not
overly happy with the current "thickener" style of usage, I want to put
this comment and a alternative most simple default framework for
discussion.
Maybe there are more Python users which like to see that imported
(managed) logging issue more down-to-earth and flexible ? ...
Vinay Sajip wrote:
>...
|
by: Patrick F |
last post by:
I keep getting this error message and i don't know whats the problem is and
how to solve it. I have a webproject with 2 components (dll) added to it. One
is called PhotoGallery and one is called Photo. Any suggestions on how to
solve this? i can't do much at the moment.
Server Error in '/PhotoGallery' Application.
--------------------------------------------------------------------------------
Cannot create/shadow copy 'Photo' when...
|
by: Patrick F |
last post by:
I keep getting this error message and i don't know whats the problem is and
how to solve it. I have a webproject with 2 components (dll) added to it. One
is called PhotoGallery and one is called Photo. Any suggestions on how to
solve this? i can't do much at the moment.
Server Error in '/PhotoGallery' Application.
--------------------------------------------------------------------------------
Cannot create/shadow copy 'Photo' when...
|
by: Chrom_ |
last post by:
Mysql is filling my /var partition because the log limit doesn't seem
to be respected.
I've tried many different settings in /etc/mysql/my.cnf but nothing
works.
Logrotate is not enabled/configured. I just want mysql to use a maximum
of, let's say, 1GB of my /var partition
The log is /var/log/mysql/
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: 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
| |