by XTIVIA | Apr 16, 2019 | Blog, Databases
Information Security and Regulatory Compliance are among the top priorities of CEOs and CIOs today. PCI DSS (Payment Card Industry Data Security Standard) is one of the popular Information Security standards that, when implemented, protects cardholder data against...
by Kathleen Long | Mar 19, 2019 | Blog, Databases
The end is near for Microsoft’s servicing of SQL Server 20082008 R2; by July 9, 2019 Microsoft will have ended all support for 20082008 R2. It may seem unsettling, but there’s a lot you can do to prepare for the end of service (and increase your database...
by Kathleen Long | Jul 5, 2018 | Azure, Blog, Databases
Azure SQL has introduced the ability to set firewall rules at the database level. A database firewall is different than a server firewall which can be configured via the Azure Portal. The database firewall gives you the ability to not only limit connections at the...
by XTIVIA | May 5, 2016 | Blog, Databases
Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said “What’s wrong with DB2? my query is running long! Are there lock timeouts happening?”...
by XTIVIA | Apr 21, 2016 | Blog, Databases
What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When there is not enough room in the lock list to store additional locks that an application needs to continue processing,...
by XTIVIA | Apr 20, 2016 | Blog, Databases
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There is going to be times when you are going to need to run maintenance on your server. The tricky part is trying to...
by XTIVIA | Apr 13, 2016 | Blog, Data Management, Databases
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine...
by XTIVIA | Apr 7, 2016 | Blog, Databases
It may be something that’s not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a schema and all of the objects in that schema used to be tedious and time-consuming. We used to have to look for a...
by XTIVIA | Mar 31, 2016 | Blog, Databases
When taking a backup of a DB2 LUW database, there are a lot of options to choose from. I like to specify as many as possible to make it clear exactly what I want, even if I am specifying the defaults. Though I very rarely specify the number or size of backup buffers,...
by XTIVIA | Mar 17, 2016 | Blog, Databases
I can’t remember the last time a ulimit bit me, but the time has come again. Everyone is used to removing all the limits for the instance ID at this point, I hope, but have you ever considered the ulimits for your fenced user id? The Problem In the DB2...
