(Brad Patterson) Xtivia has a client who runs an old Informix database product, Standard Engine (SE) version 5.01.UD3, on SCO UNIX version 5.0.5. Both have been running well for at least twenty years without much in the way of outages. Over the years Xtivia has assisted the client with small datab
Author: SSWUG Research
Video: Interview with IBM Fellow Tim Vincent about DB2 with BLU Acceleration
(Henrik Loeser) This interesting video showing Paul Z. (you can ignore his real last name… š interviewing Tim Vincent about BLU Acceleration in DB2 10.5 was posted yesterday.
ADF BC Locking Lifetime and Application Module Pooling
(Andrejus Baranovskis) ADF BC API provides method to lock current row, but lock lifetime can be short. Lock method issues SQL lock and locks the record for current user. If your use case is to keep lock for longer period of time, in other words to reserve record by the user until commit or rollback
DB2 10.5 Certified for SAP
(Chris Eaton) For those of you not following me on twitter and may have missed this, DB2 10.5 was officially certified for use with SAP as of August 8, 2013. SAP has certified DB2 10.5 for SAP NetWeaver 7.0 SR 3 and higher. (see SAP Note: 1851853 for all the details).
dbms_metadata and consumer_group Feature or Bug ???
(mdinh) So there I was, working a simple request. Drop user and recreate which sound simple enough. Use dbms_metadata.
Log Jam: Be careful with local syslog
(Josh Williams) All they really wanted to do is log any query that takes over 10 seconds. Most of their queries are very simple and fast, but the application generates a few complicated queries for some actions.
About SQLT Repository
(Carlos Sierra) SQLTXPLAIN maintains a repository of metadata associated to a SQL statement being analyzed. A subset of this SQLT repository is automatically exported every time one of the main methods (like XTRACT) is used. A question sometimes I get is: what do you do with this SQLT repository?
Using HTML5 Date Input Type Inside GridView
(Bipin Joshi) HTML5 provides several new input types such as email, URL and Date. While using Date input type a textbox is displayed as a date-picker by browsers such as Chrome and Opera. Such a textbox uses dates in yyyy-MM-dd format (ISO format) and this formatting can lead to some problems as dis
SQL Server ā Script to get Service Account for all local instances
(Vishal Gajjar) Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a single instance. If you multiple instances of SQL Server installed on a server you can use below script to get SQL Server and SQL Server Agent service account information for all local i
SqlDev PowerShell 102: Working with Data and Variables
(Michelle Ufford) In my previous post, SqlDev PowerShell 101: Getting Started with PowerShell, I walked through how to configure and use PowerShell to run basic commands. This post will cover working with data and variables in PowerShell. Specifically, Iām going to demonstrate how to connect to a da