473,320 Members | 1,969 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,320 software developers and data experts.

Cannot turn on logging for tables with names > 18 chars

RdR
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
Nov 12 '05 #1
11 2501
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
Nov 12 '05 #2
RdR
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

Nov 12 '05 #3
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?
Nov 12 '05 #4
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
Nov 12 '05 #5
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 ... :-)

Nov 12 '05 #6
RdR
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

Nov 12 '05 #7
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
Nov 12 '05 #8
RdR
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

Nov 12 '05 #9
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
Nov 12 '05 #10
RdR
Hi Serge,

Thanks for the information. I was wondering if there was a work around other
than renaming the table names to less than 18 characters?

Thanks,

RdR

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3s************@individual.net...
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

Nov 12 '05 #11
RdR wrote:
Hi Serge,

Thanks for the information. I was wondering if there was a work around other
than renaming the table names to less than 18 characters?

Try and see if CREATE TABLE works. If it does, there is another
workaround which may or may not be more feasible than renaming.

Again, it's a bug in the DDL check. If you open an APAR you can receive
a fix.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #12

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

Similar topics

8
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 -------------------------------------------------------------------------------- ...
5
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...
3
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...
15
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...
3
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...
0
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...
0
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...
1
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...
0
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.