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!
For those of us used to using the tail command in UNIX to tail the end of a file or the number of lines of interest, there is a little known option on the db2diag command to enable you to do the same thing. By using the lastlines option you can do this with the db2diag command. See below example:
C:\Users\Administrator>db2diag -lastlines 20
2015-09-24-01.39.36.909000-240 E114014F431 LEVEL: Info
PID : 2424 TID : 11528 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GTS_PROD
APPHDL : 0-7834 APPID: *LOCAL.DB2.150924053010
AUTHID : DB2ADMIN
EDUID : 11528 EDUNAME: db2agent (GTS_PROD)
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:906
MESSAGE : Backup complete.
2015-09-24-02.00.31.707000-240 I114447F308 LEVEL: Error
PID : 13484 TID : 3784 PROC : db2dasstm.exe
INSTANCE: DB2 NODE : 000
EDUID : 3784
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : signed integer, 4 bytes
-204
Gunning Technology Solutions, LLC. THE WORLD LEADER IN Db2 LUW CONSULTING! 