August 2, 2019 posted by

Posted by Craig S. Mullins at AM No comments: . The tool offers dozens of masking algorithms implemented as Db2 user-defined functions (UDFs). Craig Mullins. You may know Craig from his popular books: Db2 Developer’s Guide, 6th edition and Database Administration: The Complete Guide to DBA. Craig S Mullins is president & principal consultant of Mullins Consulting, Inc., is an IBM Information Champion, and an IBM Gold Consultant for DB2. Craig has.

Author: Mazukora Nazahn
Country: Iraq
Language: English (Spanish)
Genre: Technology
Published (Last): 21 April 2012
Pages: 476
PDF File Size: 12.89 Mb
ePub File Size: 16.58 Mb
ISBN: 326-4-96988-763-6
Downloads: 29505
Price: Free* [*Free Regsitration Required]
Uploader: Taugul

Customer and end- user expectations for interacting with computerized systems have changed—and technology changes to accommodate these requirements. What do we mean by Database Scalability? TDANApril 18, Order DB2 Developer’s Guide6th edition. A time to put down the work that consumes us most of the year and to celebrate and enjoy This is desirable for several reasons: You can avoid all of the problems and hassles of data masking by using a product like BCV5 to mask your data effectively and accurately.

With all that history aside, I am just looking mullin to celebrating with family and eating a nice, juicy turkey! The Mainframe Does Big Data.

Mullins for knowledge of DB2 and clear presentation style. If the bank gives you the money but does not debit the account, the bank will be unhappy.


Craig Mullins, Author at IBM IT Infrastructure Blog

What type of data should be masked? At any point within the transaction, the decision can be made to stop and roll back the effects of all changes since the last COMMIT. The results of running a transaction will record the effects of a business process—a d2 business process.

Monday, November 12, Data Masking: Planet MainframeApril 6, Well, now there is! Craib masking is applied using a set of rules that indicate which columns of which tables should be masked. For example, credit card numbers pass validity checks, addresses have matching street names, zip codes, cities, and states, and so on In “real life,” though, true read only data is rare.

Craig S Mullins

The book is designed for ease of use both as a learning tool and a reference. Wouldn’t it be nice if there were a place to turn for advice?

TDANJanuary 3, Alternately, a dirty read can cause no rows to be returned when one or more actually exists. Crzig Masking Tool comes with several pre-defined lookup tables that contain thousands of names and millions of addresses in many different languages.

If a unique constraint is defined on the data different input values will result in different hashed values… and likewise, repeated input values will result in the same hashed output values in other words, duplicates. Database Trends and ApplicationsSeptember 4, SQL Performance, Part 4: The number is calculated using the hashing algorithm, it is not a random number.


Craig Mullins

Craig’s no-nonsense approach to DB2 topics could only come from the knowledge of having worked in the pits in-depth with DB2. The following two queries can be used to find the applications using uncommitted reads. bd2

But how to make the decision to change jobs? An Imperative for D2 and Governance For those who do not know, data masking is a process that creates structurally similar data that is not the same as the values used in production.

Craig S. Mullins – DB2 Developer’s Guide

Data masking protects the actual data but provides a functional substitute for tasks that do not require actual data values. If you’ve bought a…. Or you can mask data in-place enabling you to mask the contents of an existing set of tables without making another copy. Monday, December 24, Happy Holidays