IBM Support

Creating a RequisitePro schema in DB2 version 8.2 or later uses UTF-8 code set

Troubleshooting


Problem

When creating an IBM Rational RequisitePro schema in IBM DB2 9.5, the default code set (character set) used by version DB2 9.5 is UTF-8, which is not supported by IBM Rational.

Symptom

You might run into errors stating that the value being inserted is either too large or long for a column when:

  1. Transporting a existing project from another database (MS Access, SQL, Oracle) to DB2 9.5
  2. Creating a project from baseline/template into DB2 9.5
  3. Inserting new data into the project that is stored in DB2 9.5

Cause

The default code set used by the RequisitePro creation scripts for DB2 version 8.2 or later is UTF-8, which is not supported by IBM Rational.

Defect RATLC00426468 has been filed for this issue.

Resolving The Problem

The existing database already created in UTF-8 cannot be converted to use the proper code set.

A new database must be created with the proper code set specified.

To verify that your current DB2 database is using UTF-8 code set, have the DBA do the following:

  1. Open a DB2 command window (Start > Programs > IBM DB2 > Command Line Tools > Command Window)

  2. Type db2 get db cfg for <database name> > C:\Database_cfg.txt
  3. Open C:\Database_cfg.txt and it will state what code set is being used.

  4. If the current database is using UTF-8, follow the instructions below to create a new database using the proper code set.

To create a new DB2 version 8.2 or later database using the correct code set:
  1. Download, extract and save the new createdb file attached below
    • Microsoft Windows: createdb.bat
    • UNIX or Linux: createdb.sh

      Note: For 7.0.1.x users: Modify the createdb.bat file and add the following codeset:

      db2 -v CREATE DATABASE %database% USING CODESET IBM-1252 TERRITORY US >> createdb.log

  2. Rename the existing createdb file
    • Microsoft Windows: Rename the existing createdb.bat file to createdb.bat.old
      File located in C:\Program Files\IBM\RationalSDLC\RequisitePro\database\db2\windows\8.2\
    • UNIX or Linux: Rename the existing createdb.sh file to createdb.sh.old
      File located C:\Program Files\IBM\RationalSDLC\RequisitePro\database\db2\unix\8.2

  3. Place the new file you copied in step #1 into that directory

  4. Follow the instructions according to the rp_install.pdf guide on creating a new DB2 database and schema using the new file.

Disclaimer

All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.



createdb.zipcreatedb.zip

[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database: DB2","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"7.0.1;7.0.1.1;7.0.1.10;7.0.1.11;7.0.1.12;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.0.1.6;7.0.1.7;7.0.1.8;7.0.1.9;7.1;7.1.0.1;7.1.0.2;7.1.1;7.1.1.1;7.1.1.2;7.1.1.3;7.1.1.4;7.1.1.5;7.1.1.6;7.1.1.7;7.1.2;7.1.2.1;7.1.2.2;7.1.2.3;7.1.2.4;7.1.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21393272

Page Feedback