WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


SQL Server - Installing stored procedures for Java Transaction API

The stored procedures for Java Transaction API (JTA) must be installed in addition to the JDBC drivers for WebSphere® Process Server or WebSphere Enterprise Service Bus to work with the Microsoft® SQL Server.

About this task

To install stored procedures for JTA:
Procedure
  1. Copy the sqljdbc.dll and instjdbc.sql files from the SQLServer JTA directory to SQL_Server_Root\Binn directory, where SQL_Server_Root is the directory of the Microsoft SQL Server instance, typically C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL.
    Note: If you are installing stored procedures on a database server with multiple Microsoft SQL Server instances, each running SQL Server instance must be able to locate the sqljdbc.dll file. Therefore the sqljdbc.dll file needs to be anywhere on the global PATH or on the application-specific path. For the application-specific path, place the sqljdbc.dll file into the C:\Program Files\Microsoft SQL Server\MSSQL.instance\MSSQL\Binn directory of each instance.
  2. From the database server, use the ISQL or OSQL utility or MS SQL Server Management Studio to run the instjdbc.sql script. The system administrator should back up the master database before running instjdbc.sql. At a command prompt, use the following syntax to run instjdbc.sql:

    ISQL -Usa -Psa_password -Sserver_name -ilocation\instjdbc.sql

    Where:

    sa_password is the password of the system administrator.

    server_name is the name of the server on which SQL Server resides.

    location is the full path to instjdbc.sql. (You copied this script to the SQL_Server_Root\bin directory in step 1.)

  3. Repeat these steps for each Microsoft SQL Server installation that will be involved in a distributed transaction.

Results

The instjdbc.sql script generates many messages. In general, these messages can be ignored; however, the system administrator should scan the output for any messages that may indicate an execution error. The last message should indicate that instjdbc.sql ran successfully. The script fails when there is insufficient space available in the master database to store the JDBC XA procedures or to log changes to existing procedures.

Steps to install Data Direct are located at: http://media.datadirect.com/download/docs/jdbc/jdbcig/wwhelp/wwhimpl/js/html/wwhelp.htm

More information on Microsoft SQL Server is located at: http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.nd.doc/info/ae/ae/rtrb_dsaccess4.html


task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.zseries.doc/doc/tins_install_jta_sqlserver.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).