PK70446: INFOCENTER INSTRUCTIONS FOR MS SQL 2005 JDBC DRIVER CONFIG ARE MISSING STEPS AND REFER TO INCORRECT DLL

APAR status

• Closed as documentation error.

Error description

• The Portal 6.1 instructions for SQL 2005 are located here:
  
  http://publib.boulder.ibm.com/infocenter/wpdoc/v6r1m0/topic/com.
  ibm.wp.ent.doc/config/stdalone_win_sql2005_inst.html
  
  Step 8 refers to sqljdbc.dll, which is actually sqljdbc_xa.dll.
  
  
  Step 5 refers to running instjdbc.sql, which does not exist.
  This is a repetition of the procedure that is described in step
  6 above it.
  
  The steps are also missing this info:
  
   Enable XA Transactions in Windows Component Services:
  
  a. Navigate to: Start -> Settings -> Administrative Tools -->
  Component Services.
  
  b. Expand the tree view to locate the computer where you want to
  turn on support for XA transactions (for example, My Computer).
  
  c. Right click the computer name, and then click Properties.
  
        d. Click on Options tab and tune Transaction Timeout that
  suits your environment (Recommended minimum is 180 seconds).
        e. Click the MSDTC tab, and then click Security
  Configuration.
  
        f. Under Security Settings, select the check box for XA
  Transactions to turn on this support.
  
       g. Click OK, and then click OK again.
  

Local fix

• DCF Technote submitted with proper procedure details.
  

Problem summary

• Infocenter documentation was incorrect/lacking info on
  configuring the MS SQL 2005 jdbc driver.
  

Problem conclusion

• Created technote to deliver missing/incorrect content.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels