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. DB2 Developer’s Guide [Craig S. Mullins] on *FREE* shipping on qualifying offers. DB2 Developer’s Guide, Fourth Edition is completely revised.

Author: Dailar Mazragore
Country: Albania
Language: English (Spanish)
Genre: Politics
Published (Last): 11 September 2012
Pages: 496
PDF File Size: 16.28 Mb
ePub File Size: 2.46 Mb
ISBN: 261-9-57935-523-6
Downloads: 66909
Price: Free* [*Free Regsitration Required]
Uploader: Meztilrajas

It draws upon the author’s day-to-day experiences as a DB2 system administrator, database administrator, and database analyst.

Craig Mullins, Author at IBM IT Infrastructure Blog

Or you can mask data in-place enabling you to mask the contents of an existing set of tables without making another copy. So the point of this blog post is just to commemorate the occasion, as t his month, Novembermarks the 30th anniversary of the first tip, which was mailed out to Db2 users in November Posted by Craig S.

Just a quick post today to wish all of my readers in the US and everywhere, really a very Happy Thanksgiving. In a mailbox and delivered by a postal worker. Wild carding of the rules is allowed, so you can apply a rule to all tables that match a pattern. If the bank gives you the money but does not debit the account, the bank will be unhappy.

Read it to save yourself an enormous amount of pain and suffering. Our m odern idea of Thanksgiving was first officially called for in all states in by a presidential proclamation made by Abraham Lincoln.


The DBMS maintains a transaction log or journal to track database changes.

Terms of Service Privacy Policy Contact. From the earliest days of the country until Lincoln, the mulins Thanksgiving was observed differed from st… Data Masking: 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.

With all that history aside, I am just looking forward to celebrating with family and eating a nice, juicy turkey! There are many methods of masking data, some better than others.

A transaction is an atomic unit of work with respect craiv recovery and consistency. Well, now there is! And here is what that tip was: And importantly, it is also time to wind down … Dirty Reads In either case the resulting condition of the database will be a consistent state. So let me explain. The general idea is to create reasonable test data that can be used like the production data, but without using, and therefore exposing the sensitive information.

Data masking is applied using a set of rules that indicate which columns of which tables should be masked.

Really, d2b makes sense to mask anything that should not be public information. Because the hashing algorithm will always generate the same number for the same input value you can be sure that referential constraints are taken care of.

A general rule of thumb is to avoid dirty reads whenever the results of your queries must be percent accurate.

It is chock full of DB2 technical information, design and tuning approaches and database administration guidelines. You can have a separate set of rules for each Db2 subsystem that you work with.


Craig Mullins

Consider the following sequence of events: Mullins for knowledge of DB2 and clear presentation style. Such a capability is important to be in…. It is hard to believe that yet another year has come and gone well, almost and that the holiday season is once again upon us. If you’ve bought a… Published and Available to be Ordered: Take a look at the data masking capabilities of BCV5 and decide for yourself what you need to protect your valuable data and comply with the industry and governmental regulations on that data.

Another bad approach is shifting the data, for example A — B, B — C, etc. The result of the CASE expression is returned in place of the column value in a row.

The book is designed for ease of use both as a learning tool and a reference. What type of data should be masked?

Read what the experts say about DB2 Developer’s Guide: Personal information like name, address, social security number, payment card details; financial data like account numbers, revenue, salary, transactions; confidential company information like blueprints, product roadmaps, acquisition plans.