PI07713: SUPPORT FOR SQL SERVER 2012 NOT ADDED FOR SIBDDLGENERATOR

8.5.5.3: WebSphere Application Server V8.5.5 Fix Pack 3
8.5.5.4: WebSphere Application Server V8.5.5 Fix Pack 4
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
8.5.5.21: WebSphere Application Server V8.5.5.21

APAR status

• Closed as program error.

Error description

• sibDDLGenerator command does not provide the option to specify
  SQL Server 2012 version
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of the default messaging provider     *
  *                  for                                         *
  *                  IBM WebSphere Application Server V8.5       *
  ****************************************************************
  * PROBLEM DESCRIPTION: If the database used is SQLServer       *
  *                      2012, sibDDLGenerator command fails     *
  *                      with CWSIS1595E                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In a WebSphere Application Server using the Service
  Integration Bus, the sibDDLGenerator command is used to
  generate the DDL statements that the messaging engine needs.
  It takes in the system, version, platform and so on as input
  parameters.
  Currently, If the database used is SQLServer 2012,
  sibDDLGenerator command fails with the following message -
  "CWSIS1595E: An invalid combination of parameters has been
  specified, Database: sqlserver, version: 2012, platform:
  windows . Refer to the documentation for the correct
  parameters for your database."
  The SQLServer 2012 is a supported database version for V8.0
  and above, and is mentioned in the support page. However, when
  the command sibDDLGenerator is used, it fails with the
  previous exception.
  

Problem conclusion

• Enabled the database version SQLServer 2012 for the command
  sibDDLGenerator.
  
  The fix for this APAR is currently targeted for inclusion in
  fix pack 8.5.5.3.  Please refer to the Recommended Updates
  page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

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

• Fixed component name

  WAS SIB & SIBWS

• Fixed component ID

  620800101

Applicable component levels

• R850 PSY

     UP