Blog : What’s On Our Mind?

Sharing Our Point of View
By Pinal Dave | On February 20th 2015
SQL Server In-Memory tables - Where is data stored?
SQL Server 2014 introduced the concept of InMemory OLTP which has been a lesser explored topic for many. Previously we saw how these InMemory tables can be created and how one can access the same. Once the table is created, the syntax, TSQL construct and access seems to be almost similar to how a normal table is created. The interesting aspect of using InMemory OLTP is that it can be configured to be purely an in-memory tables or…
By Craig Mullins | On February 19th 2015
DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements. It is sometimes referred to as “Batch SPUFI” because it allows you to submit SQL in batch similar to how SPUFI allows online SQL execution. The following sample JCL demonstrates the capability of DSNTEP2 to issue DCL, DDL, and DML dynamically. The DNSTEP2 program is written in the PL/I programming language. Prior to DB2 V6, you needed to have a PL/I compiler to use DSNTEP2. However, as of V6 IBM now provides both the source code and an object code version of DSNTEP2 with DB2. So,…
By Pinal Dave | On February 10th 2015
SQL Server: In-Memory and Durable. How is That Possible?
One of the major myths about SQL Server In-Memory OLTP is that since the data resides in memory, it would be lost once SQL Server is restarted. Well, as we mentioned – it is a myth. In reality, SQL Server guarantees changes made to durable tables are permanent and can survive a database or SQL Server restart. To understand the durability of data in SQL Server, we need to recall the concept of transaction logging. Whenever there is a…
By Craig Mullins | On February 2nd 2015
VSAM is used “under the covers” of every DB2 for z/OS page set. VSAM is also used as the storage mechanism by some IMS databases. It is also used to store a lot of mainframe data outside the control of any DBMS. But there is a lot of confusion about what exactly VSAM is, how it can be used, and how it differs from a DBMS. I wrote an article for IDUG Solutions Journal titled On VSAM and DB2 that offers some high-level details on the differences…