DB2 for i5/OS: SQL Server Mode Primer

Web Doc

Note: This is publication is now archived. For reference only.

thumbnail 

Published on August 03, 2007

  1. View in HTML

Share this page:   

IBM Form #: TIPS0658


Authors: Scott Forstie

    menu icon

    Abstract

    SQL Server Mode is a database application environment that is unique to the IBM System i platform. When SQL Server Mode is used, database connections establish a one-to-one relationship with a QSQSRVR server job. When SQL statements are executed in the client job, the corresponding QSQSRVR server job does the work. SQL Server Mode is generally used by multi-threaded applications to achieve better performance and to separate transaction management between connections.

    SQL Server Mode is an environment that can be enabled programmatically or can be implicitly started when using native JDBC. When the connection is disconnected, the associated QSQSRVR job is returned to the QSYSWRK prestart job pool where it waits until it is used by a different connection.

    In this Technote, we explain the benefits and restrictions of SQL Server Mode. We also explain how to enable SQL Server Mode on DB2 for i5/OS.

    By Scott Forstie

    SQL Development Team Leader

    IBM Rochester

    Contents

     

    Special Notices

    This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a client responsibility and depends upon the client's ability to evaluate and integrate them into the client's operational environment.