Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

DB2 for Linux, UNIX, and Windows

DB2 for Linux, UNIX, and Windows

The following table describes the operations that you can perform on data types in DB2 database for Linux, UNIX, and Windows operating systems:
Data Types
Data Movement
Data Masking
Data Discovery
Comments
Bigint
Yes
Yes
Yes
Blob (N)
Yes
Yes
No
You can perform nullification masking.
Char for bit data
Yes
Yes
No
Char varying (Length)
Yes
Yes
Yes
To run a profile, you must keep the field length less than or equal to 255.
Character (N)
Yes
Yes
Yes
Clob (N)
Yes
Yes
No
You can perform nullification masking.
Date
Yes
Yes
Yes
Dbclob (N)
Yes
Yes
No
You can perform nullification masking.
Dec
Yes
Yes
Yes
Decfloat (16)
Yes
Yes
No
Decfloat (34)
Yes
Yes
No
Decimal
Yes
Yes
Yes
Double
Yes
Yes
Yes
Double Precision
Yes
Yes
Yes
Float
Yes
Yes
Yes
You can enter a precision value up to 28.
Graphic (N)
Yes
Yes
Yes
Integer
Yes
Yes
Yes
Long Varchar
Yes
Yes
No
Long Vargraphic
Yes
Yes
No
Num
Yes
Yes
Yes
Numeric
Yes
Yes
Yes
Real
Yes
Yes
Yes
Smallint
Yes
Yes
Yes
Time
Yes
Yes
Yes
Timestamp
Yes
Yes
Yes
Varchar for Bit Data
Yes
Yes
No
Varchar (N)
Yes
Yes
Yes
To run a profile, you must keep the field length less than or equal to 255.
Vargraphic (N)
Yes
Yes
Yes
XML
Yes
No
No