Optimization Guide for Mainframe App and Data recompiled to NET and SQL Server

This guide offers optimization advice for executing point-lookups against SQL Server from .NET as efficiently as possible. Customers wishing to migrate from mainframe databases to SQL Server may desire to migrate existing mainframe-optimized design patterns, especially when using 3rd party tools (such as Raincode Compiler) to automatically migrate mainframe code (COBOL/JCL etc) to T-SQL and C# .NET. Mainframe data accesses commonly employ Point-Lookups (AKA ‘Singleton Reads’) to loop through and join multiple large tables. This data access pattern is optimal for mainframe, but is suboptimal for querying SQL Server via .NET, where batching is recommended.

Supported Operating Systems

Windows 10, Windows Server 2016

Microsoft Word

To start the download, click Download, click Go, and then do one of the following: To start the installation immediately, click Open or Run this program from its current location. To copy the download to your computer for installation at a later time, click Save or Save this program to disk.