I mostly like and use DB2’s Self Tuning Memory Memory Manager (STMM) for my OLTP databases where I have only one DB2 Instance/Database on a database server. I do have some areas that I do not let it set for me.… Read the restContinue reading »
Basic Perl Encryption for DBAs
One of my specialties and passions is scripting. I play a major role in writing or maintaining just about every DB2 maintenance, DB2 build, and DB2 data pruning script that my company writes/uses.
One thing I’ve found a need to do is to encrypt and decrypt a single value.… Read the restContinue reading »
Scripting for DB2 LUW – Best Practices for Perl and Other Languages – Part 3
This is my own set of basic scripting standards and practices. I’d love to hear criticisms, suggestions and comments from readers on these. Some of these would be basic “duh” moments for a developer, but for a DBA from a different background, may be more enlightening.… Read the restContinue reading »