(Harishkumar Baburao Pathangay) How to Find Routine Name from Package Name Types of Routines – UDF or Stored Procedure Admin View : SYSCAT.ROUTINEDEP

(Ember Crooks) I monitor HADR closely, and want to be paged out if HADR goes down. Why? Because any subsequent failure would then be a serious problem. Once HADR has a problem, I suddenly have a single point of failure. That said, for some clients we have to tell our monitoring tools not to alert on

(Troy Coleman) In our industry it seems people are being asked to do more with less, while our employers focus on the present and near-term. Businesses aren’t planning for the long-term when it comes to making employees productive and ensuring that the data being used to make critical business decis

(Scott Hayes) 100% of our studio audience learned something! During this episode of The DB2Night Show™, Martin offered many valuable suggestions for tuning SAP in a DB2 LUW environment based on his experiences at several clients.

(Harishkumar Baburao Pathangay) How to Enable a user for multiple Authorization Ids GRANT setsessionuser Privilege by SECADM

(José De Jesús, Michael Nassar and Apurv Johar) This article continues our discussion from Part 1 on how to build and configure your own cloud sandbox using a Workload Deployer virtual appliance. If you successfully completed the steps outlined in Part 1, which cover a complete installation up to

(Ember Crooks) Recently, I needed to do some SQL profiling – discovering exactly what SQL a web application was executing against the database. I learned a lot, and when I learn a lot, I try to share with my readers.

(Craig S. Mullins) Being prepared means analyzing, documenting, and testing your DBA policies and procedures. Creating procedures in a vacuum without testing will do little to help you run an efficient database environment. Moreover, it will not prepare you to react rapidly and effectively to proble

(Mark Jacobsen) If you run a select statement and get the following error…

(Thuan Bui) The preponderance and variety of data available to today’s enterprises open up tremendous opportunities across many industries. Organizations increasingly have access to a treasure trove of structured and unstructured data that can lead to keen insights on aspects of the business to help