DB2 for i5/OS: SQL Server Mode Primer

Web Doc

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


Published on August 03, 2007

  1. View in HTML

Share this page:   

IBM Form #: TIPS0658

Authors: Scott Forstie

    menu icon


    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



    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.