DB2 LUW is supremely positioned and designed to inherently support multi-tenancy, whether or not the original designers intended it to be :). Since a database in DB2 is more like a system in SQL Server and Oracle, meaning databases in DB2 are physically separated in DB2. So you can use multiple databases per instance or more likely multiple database schemas in a DB2 database to implement multi-tenancy. With this design, multi-tenants can be assigned to separate bufferpools and even physical disk by by using multiple storage groups for tablespaces. There is a good paper on DB2 multi-tenancy in the cloud here, http://www.ibm.com/developerworks/data/library/techarticle/dm-1201dbdesigncloud/
and my friend in the IBM Toronto Lab, Enzo Cialini has a nice presentation on this. He presented this last year at the Central PA DB2 Users Group in Harrisburg. Stay tuned and secure.
Add this white paper to your toolkit for protecting your data from the folks at UNISYS. http://outreach.unisys.com/microsegmentation_UIS
TSAMP has been packaged with DB2 for sometime now. The last 3 – 4 years we have seen many implementations and have done quite a few ourself. Even though TSAMP is packaged with DB2, you still need to be aware of the TSAMP support resources. For PMRs working with IBM, you may deal with DB2 support or a combination of DB2 and TSAMP support. There are a few resources and utilities that you need to be aware of to properly implement and support a TSAMP High Availability implementation. There are DB2 commands, TSAMP commands and RSCT commands that you need to be familiar with to properly manage the TSAMP cluster resources. Here is a handy link to the IBM TSAMP resource page:
http://www-01.ibm.com/support/docview.wss?uid=swg27024950
Stay tuned, available and secure!
This is an old article but if you are just getting into Big Data, it is a great overview. While you are attending #ibminsight2015 #ibminsight don’t forget to attend those Big Data sessions I have blogged about previously.
http://www.ittoday.info/ITPerformanceImprovement/Articles/2014-07Raghupathi.html
Stay tuned and stay secure!
Came across a nice blog entry today on DeveloperWorks regarding SSL best practices. You can refer to this IBM Blog entry for a quick overview of setting up SSL instead of reading through the DB2 Security Guide and other manuals……Stay tuned and secure!
AIX 7.2 offers a Linux affinity capability, This enables you to migrate your linux applications with a recompile in many cases. Take a look at the AIX 7.2 data sheet.
Found this little VIO cheat sheet. Since most DB2 AIX implementations use VIO, it be hooves DBAs to be familiar with it and to know how it works so that you can properly support databases under your control.
http://www.ibm.com/developerworks/aix/library/au-viocheatsheet/
IBM Insight2015 is a power packed conference covering IBM Big Data, Analytics, DB2 for LUW, DB2 for z/OS and many other products. It is the pentultimate conference for Big Data professionals. Consider attending if you haven’t in the past. If you only have one conference a year that you can attend, this is the conference to attend on IBM’s Big Data and Analytics. Stay tuned and safe!
In addition to the -lastlines option that I previously blogged about, it was pointed out that the -lastrecords option provides similar results but returns the last n db2diag.log record entries instead of just lines. So depending on what you are looking for, you can choose from which of these to use…..Stay tuned, and Available!!!
FP6 was released 17 Aug 2015. This fixpak contains fixes for several security vulnerabilities and hiper APARS. You should review your requirements and apply this fixpak to harden vulnerabilities and or fix HIPER APARs that you might be exposed to. Download at the following link, you should also check the support page frequently.
http://www-01.ibm.com/support/docview.wss?uid=swg21647054
Stay tuned, and Available!
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 