Solution : https://service.sap.com/sap/support/notes/376746 (SAP Service marketplace login required)
Summary :
This SAP Note explains that incorrect sorting sequences in DB2 databases can disrupt SAP system operations, particularly during data selection queries. The issue traces back to the database creation phase where specific parameters (COLLATE_INFO) define the collating sequence. The 'db6util' tool, requiring a kernel version 4.6D or higher, checks these parameters. Solutions include rebuilding the database with correct settings or, temporarily and riskily, bypassing sort sequence checks via specific profile or environment settings. This note emphasizes the risks of using systems with incorrect database sorting sequences, which could lead to unsupported operations.
Key words :
command db6util -dg collate_infoshould deliver, dbs/db6/dbsl_ignore_collate_info=1caution, ensure error-free operation, symptom character data, f1returns data records, wrong collating sequence, collating sequence reason, collate_info x'000102030405060708090a0, database select f1, create database <sapsid>
Related Notes :
| 1074030 | R3trans: "Duplicate key" composite SAP note (as of Rel 6.10) |
| 88656 | R3trans: Duplicate key composite SAP note (Release 4.0-4.6) |