(Hemant K Chitale) Here is a simple way to “drop” an Index Partition using the 11.2 behaviour of DEFERRED_SEGMENT_CREATION by dropping the segment for the Index Partition.
Author: SSWUG Research
Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS
(Paolo Bruni, Felipe Bortoletto, Adrian Burke, Cathy Drummond and Yasuhiro Ohmori) This IBM Redbooks publication discusses in detail the facilities of DB2 for z/OS, which allow complete monitoring of a DB2 environment. It focuses on the use of the DB2 instrumentation facility component (IFC) to prov
SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys
(Pinal Dave) A very cool trick which I have previously not shared on my blog regarding how to list all the foreign key relationship of table with the help of Stored Procedure sp_fkeys.
The DB2Night Show #127: DB2’s GOT TALENT Contestant Search #4
(Scott Hayes) 100% of our studio audience learned something! We had some good presentations today on DB2 LUW! Learn how to tune DB2 LUW memory including bufferpools and configuration parameters, a clever way to save yourself a lot of typing for DB2 commands, and a method of transferring DB2 database
Azure SQL DB to support page and row compression capabilities
(Tara Shankar Jana) Recent additions to SQL Azure- we have updated Azure SQL DB to support page and row compression capabilities. This functionality is often used by SQL enterprise customers to improve performance by reducing data size and IO.
A new approach to XML – Part 1: Data projection with XMLBeam
(Sven Ewald) The industry standard XML is so pervasive that it may surprise you to discover something new. The Java library XMLBeam implements a new approach in dealing with DOM trees. Instead of coupling the Java world with XML via data binding, it allows you to “project” objects from one world int
Downloading GridView Data Into Excel and XML Format in a Web Application With Mater Pages
(Dhirendra Misra) This article shows how to download GridView data into Excel and XML format in a web application using Master Pages. This article starts by giving brief details on populating the grid that has paging and sorting functionalities and then describes the challenges of a master page whil
Why Aren’t All Data Immutable?
(Robert Hodges) Over the last few years there has been an increasing interest in immutable data management. This is a big change from the traditional update-in-place approach many database systems use today, where new values delete old values, which are then lost.
Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization
(Fabiano Amorim) Imagine it. You’ve been asked to fix a dire performance problem with a SQL Server database. You find a severe case of ‘Cache Bloat’ due to ad-hoc queries, but you can’t fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use gu
A new look for .NET Reference Source
(Alok Shriram) Today I’m very excited to announce we’ve an awesome new experience to use the .NET Framework reference source.