Category: DB2

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); IBM Cloud with Bluemix: DB2, Db2, dashDB This week I am going to acknowledge that I have been with IBM for 16 years. Looking back, everything might seem brighter and better than it was. However, I remember working in great teams, interesting and challenging projects, many successes and some failures to learn from, and the constant changes. During the time with IBM I got used to those many ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); DB2 Security Today's blog entry is about an old topic: Who I am, why I am and what I am (allowed) to do? Users and their privileges are at the core of database security. Information about them are stored in the IBM DB2 catalog (or IBM ashDB catalog) which can be queried. Thus, it is good to know your way around and being able to extract that information. Kind of as a reference for myself, here ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); DB2 Security Question Recently, I was contacted regarding an older blog entry discussing the DB2 security feature of surrogates. During an audit a strange entry was found in the catalog table SYSCAT.SURROGATEAUTHIDS. Whether I could take a look. So, let us take the security-themed tour through some DB2 catalog tables together. What is the strange entry? In a new database, created as regular ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Are you ready for a new DB2 quiz? Here is a tricky question for you. It is about DB2 security, it is (kind of) hardware-related and deals with a relatively new DB2 feature. Curious...? The following shows the output of a DB2 tool, shipped with your regular DB2 LUW these days: Keystore Password: Password successfully stashed to db2_pkcs11_pwd.sth  xxxxx completed sucessfully. Have a clue? ( ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Manage Watson Conversation Workspaces I am a big fan of using the command line as most of you know by now. This applies to interacting with IBM Bluemix cloud and its services and for database systems like DB2 or dashDB. Thus, I was excited when the IBM Watson Conversation service added API functions to manage workspaces. To test the new API I wrote a small Python-based tool to manage my ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Data Privacy and Security Right now we are in the hot phase of the carnival season. Many people are wearing masks. Some move into other characters, some just hide their real identity. Did you know that DB2 is also in the mood for carnival and wears a mask? Here is what my DB2 is doing these days... With carnival around and April Fools' Day approaching quickly, one of my recent DB2 ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Did you know...? I hope you had a good start into 2017. I am already up and running and accomplished some important tasks. I submitted my presentation proposals for the IDUG DB2 Tech Conference 2017 in Lisbon, Portugal. The Call for Papers is still open until February 20th. The IDUG Conference is always a great place to learn new stuff and meet great people. Speaking of learning new stuff. Do ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); New DB2 Fix Pack and Mod Pack available Over the past years I blogged about new fixpacks and features in DB2. This is the first time I have to mention "Mod Packs" because for DB2 V11 a new Mod Pack and Fix Pack was released. DB2 changed to distinguish between fixes to existing features and adding new features in interim releases. The terminology of version, release, modification and fix pack ... Read More

Feed: Database Trends and Applications : All Articles. Quest Software, a global systems management and security software provider, is announcing enhancements to its portfolio of SQL Server database management and performance monitoring solutions.“We are announcing multiple enhancements to address the Microsoft SQL Server community and customer base,” said Greg Davoll, software products leader, Quest Software. Quest as a company is focused on three sets of capabilities for customers: database performance monitoring; database replication; and database development and management tooling, and these new product enhancements reflect that focus, he added.While this round of enhancements is focused on the Microsoft community, Davoll ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . The Database Administrator (DBA) is usually a technical professional who supports one or more hardware and software platforms that provide application solutions. However, technical details such as SQL tuning, hardware and software upgrades, and database designs tend to be tactical in nature.  It is essential that the DBA also maintain a strategic outlook in order to get ahead of potential problems. This article addresses two of these strategies: knowing application breaking points and preparing for future enhancements to big data applications. Big Data Applications The database administrator is usually an expert on ... Read More