(Craig S. Mullins) Static SQL is rigidly formed and usually provides a known access path to data. Dynamic SQL is more flexible, but this flexibility comes with some trade-offs. For example, dynamic SQL brings the potential for more accurate access paths but at the cost of not knowing what that acces
Tag: IBM
WebSphere Commerce Performance Tests with Rational Performance Tester, Part 2: WebSphere Commerce test scenario – Random browse
(Noureddine Brahimi and Charek Chen) Part 2 of this three-part article series describes the ways to implement browsing an IBM WebSphere Commerce catalog with Rational Performance Tester. Throughout this part, a full example from the design to the implementation of the test is presented. The example
The DB2Night Show z47: What’s New in DB2 11 SQL Coding and Tuning
(Martin) 100% of our studio audience learned something!Dave provided a wide variety of recovery options and strategies for taking backups for disaster recovery.
How to check DB2 SYSADM or SYSCTRL authorization for a user with AUTH_LIST_AUTHORITIES_FOR_AUTHID
(Jack Vamvas) Question: How can I determine if a user has SYSADM or SYSCTRL authorization?
DB2 Tips n Tricks Part 34 – Remotely Start Stop DB2 Instance from Client Machine
(Harishkumar Baburao Pathangay) How to Remotely Start Stop DB2 Instance from Client Machine Solution:
3 Reasons Your DB2 Environment Is Becoming Partly Cloudy
(Dave Beulke) Existing traditional data models are going through transformations as Big Data, NoSQL, and Cloud Database as a Service capabilities rapidly take business to new heights.
Convert row-organized tables to column-organized tables in DB2 10.5 with BLU Acceleration
(Jim Seeger, Tan Jin Xu and Prashanthini Shivanna) With IBM DB2 10.5, you can easily convert row-organized tables to column-organized tables by using command-line utilities or IBM Optim Data Studio 4.1.
IBM Integration Bus Patterns
(Eric Berg) IBM Integration Bus version 9 includes many capabilities that set it apart from the competition, but recently while comparing it to Software AG webMethods and SAP PI one item in particular stood out – Patterns and Pattern Authoring.
Do You Really Need to Tune Big Data Applications?
(Lockwood Lyon) Big data applications are here to stay. Most large IT enterprises have implemented one or more large data stores, hybrid hardware/software solutions and high-speed business analytics packages. The promise of this technology is the ability to quickly and easily analyze large amounts o
Advancing Internet of Things Opportunity
(Kevin Brown, Fred Ho and Stephanie Pettinos) Industry and commerce are entering a new era of computing marked by the expansion of cloud computing, analytics, mobile technologies, and the emergence of the Internet of Things. Evolving beyond just another buzzword, the Internet of Things has become a
