Use of an RDBMS with the Infor System Console
The Infor System Console requires a database for storing information used by some of its features. This database can be an RDBMS or the Derby database. For information on installing the Derby database, see Installing the Derby Database.
For use of an RDBMS, you must follow the guidelines and requirements listed below. Be sure to note down the details for your database as you need to specify these values when running the installation program.
- The supported RDBMS are the same as those for Infor Lawson System Foundation, with the exception of IBM DB2 for z/OS.
- The Infor System Console must be a different database instance of the database you use for Infor Lawson System Foundation.
- A database administrator should perform all database creation and setup procedures for the Infor System Console.
IBM DB2 for IBM i
| Setting | Description |
|---|---|
| Database name |
Create a database for ISC use only.
|
| Schema | A schema within the database. The recommended schema name is ISCDB. |
| Table spaces |
Table spaces are not required. If used, create two tablespaces, one for the data and one for the indexes. Set AUTORESIZE to "yes". |
| User | A user for ISC use only. The user should be set as the database owner for the ISC database. |
| Authorities and privileges |
Grant the necessary authority to the user. Ideally, the user has database administrator authority or the least privileged authority. A sample list of the necessary authorities and privileges needed by the user are below:
|