• In order to utilize intra-mart Accel Platform, at least the authority of [CONNECT], [RESOURCE], [CREATE VIEW] and [UNLIMITED TABLESPACE]

  should be given.

  In addition to the above, there are necessary authorities depending on the applications and extension series to be used.

  Please refer to the release note and setup guide of each product for details.

• For the default matching sequence of the database to be created, please check the Windows system locale name on the

  Control Panel-[Region and Language Option] -[Detail Setting] tab of the platform (OS) to which Database is installed.

  Matching sequence specifier that corresponds to the matching sequence setting in the existing Windows locale should be specified.
  Each Windows matching sequence can be combined as a series of suffixes that define capital/small letters, accentation, character width, and KANA type.

  It is necessary to set the combination of suffixes in the operations environment.

  Note

  On intra-mart Accel Platform it is recommended to create the database with a setting that differentiates capital and small letters.

  Recommended setting value is [Japanese_90_CS_AS_KS_WS].

  Warning

  In case IM-Workflow is used, there is a possibility that [Lock Wait by Table Scan] may occur.

  One of the ways to avoid the Lock Wait is the use of [READ_COMMITTED_SNAPSHOT].

  Please assess the use of it, and utilize it as required.

  <*> For the [Lock Wait by Table Scan] and [READ_COMMITTED_SNAPSHOT],

  please refer to the document of Microsoft SQL Server for detail.

  
  

  [ How to Use READ_COMMITTED_SNAPSHOT ]

  In order to use it, you should set READ_COMMITTED_SNAPSHOT to ON for the database as below.

  • ALTER DATABASE {data_base_name} SET READ_COMMITTED_SNAPSHOT ON;

  <*> Please execute it when all the connections to the database have been finished.

• When the database is created, it is necessary to set [32k] to

  [Default Buffer Pool and Table Space Page Size].

• You can download PostgreSQL from the URL below.

  Please download the one that is suitable for your environment, and install it.
  http://www.enterprisedb.com/products-services-training/pgdownload

1. Launch pgAdmin tool.

2. Create Log-in Role

   On the [Object Browser], right click on [Log-in Role], and click [New Log-in Role].

   Sub-window is displayed.

   

   Enter the items below and click [OK].

   Property Tab
      [Role Name](optional)
   
   Definition Tab
      [Password](optional)
   

   Note

   In this document the items below are specified as an example.

   Role Name [imart]

   Password [imart]

3. Create Database

On the [Object Browser], right click on [Database] and click [New Database].

Sub-window is displayed.

Enter the items below and click [OK].

Property Tab
   [Name](optional)
   [Owner](Log-in Role which was created in [2. Create Log-in Role] above)

Note

In this document following items are specified as an example.

Name[iap_db]

Owner[imart]