IBM’s Data Studio holds a lot of features that are not commonly known by the DB2 audience. Many regard it as the replacement of the old Control Center. IBM Data Studio has got a lot of goodies not included in Control Center. In this article we will focus on the usage of physical data models.
Come take a look at the next generation tooling platform that IBM® rolled out in March 2015 to help optimize database performance, detect and solve performance problems, easily administer instances, database objects, and manage data server configurations.
April 2015 “Fun with SQL” third Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
Some DBAs end up creating dozens of views on the same table just to manage the security requirements. It can be difficult to track the purpose of all these views and manage them accordingly. Row and column access control may be used as an alternative to views to manage security requirements.
When using LDAP in DB2 to check who had access to a database and which items are available to a user works fine even though looking at db2diag.log you might wonder. The number of messages passing by in that file makes you aware how many checks are done while going thru the data in your databases.