Installing dSeries Server and received an error regarding database collation
search cancel

Installing dSeries Server and received an error regarding database collation

book

Article ID: 110979

calendar_today

Updated On:

Products

DSERIES- SERVER ESP dSeries Workload Automation ESP dSeries Workload Automation - Scheduler (dSeries)

Issue/Introduction

Encountering an error during a dSeries Server installation related to database collation. Our current servers use `SQL_Latin1_General_CP1_CI_AS`, but the error message suggests using `<LANGUAGE>_100_CI_AS`. Is it okay to use the existing collation?

Environment

Workload Automation DE (dSeries)

Resolution

For DE (dSeries) installation, the collation setting for the Microsoft SQL Server database should be case insensitive (denoted by CI). If the collation setting is 'SQL_Latin1_General_CP1_CI_AS', then you can use it.

Additional Information

Database Requirements

  • If you use a Microsoft SQL Server database, verify that the collation setting is case insensitive and set to a UTF8-supported collation.