Skip to main content
Delphix

Mainframe Masking NewLine/LineFeed conversion problems in EBCDIC (KBA7813)

 

KBA

KBA# 7813

 

Issue

When using a DB2 Z/OS JDBC connector, a CCSID37 newline (Hex value 15, 0x15) is converted to CCSID37 linefeed (Hex 25, 0x25) between reading data into the masking engine and writing it back to the database.

Prerequisites

Using a JDBC DB2 Z/OS connector for masking DB2 database columns on a mainframe (Z/OS).

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Resolution

This is due to the behaviour of the IBM DB2 type-4 JDBC driver.  Suitable options exist in the type-2 driver, but this cannot be used by the Delphix masking engine.

There is no resolution when using this driver with the Delphix masking engine.

The newline values must be changed by tools outside of the Delphix masking engine which do not use JDBC connections.

Troubleshooting

Locate 0x15 characters before masking; determine if these were converted into 0x25 characters

Example:

00 00 00 00 00 00 15
00 00 00 00 00 00 25