Replication support for Boolean data type for IBM DB2 11.5.

[FrankBosh]

IBM introduced support for Booleans and we've discovered Replicate does not replicate them. If it is helpful, the support case number we opened is 00071411, but we were directed here to open a feature request.

Hopefully, this can find its way into a near-future update....

[john_wang]

Hello @FrankBosh ,
Thanks for you reporting this. There is not workaround for this behavior at the moment. 

There are several similar articles and FR requests, for easy to trace I'm summarizing them here:

1. Frank, This article

2. Frank, last week similar article

3. Frank , last year similar article

4. Frank, FR article

IBM introduces BOOLEAN data type in newer DB2 LUW 11.5  and DB2i V7R5. let's wait for PM Team approval. We may trace the PM update in the FR article.

Regards,

John.

[FrankBosh]

How long does PM Team approval typically take?

[john_wang]

Hello @FrankBosh ,

Let me check internally and get back to you later.

Regards,

John.

[john_wang]

Hello @FrankBosh ,

Got information from PM team that BOOLEAN data type for IBM DB2 LUW is in R&D consideration, hopefully we get it verified in Q2/Q3 this year (this is not commitment yet). We will keep you posted of any new progress.

Hops this helps.

Regards,

John.