Databases (Magic xpi 4.13)
In the Database Support screen, select the Run the scripts to build the database tables now check box to create the database tablespace and tables during the installation. If you do not select this check box, the tables are not created during installation and you need to create them manually later on.
For information about supported databases, see the Compatibility Guide.
|
|
Only the MSSQL JDBC driver (JAR file) is provided as part of the Magic xpi installation. For any other DBMS, you must provide the JDBC driver jar.
To work with any of the other internal databases:
-
Copy the JDBC driver jar file to the following folder:
<Magic xpi installation>\Runtime\java\DatabaseDrivers
-
Configure the database settings in the datasource.xml file. Make sure that the driverClassName defined in the datasource.xml is compatible with the JDBC driver.
|
Then, select the database to be used as your internal Magic xpi database. Magic xpi supports the following databases:
After you select a database, click Next to enter the database information for the selected database. On this screen you can enable the partitioning support for Oracle and MS-SQL databases by selecting the DB Partition check-box. Once the database information is entered, click Next to create the database tablespace and tables in the selected database.
(Since version: 4.13)
|
|
-
Before selecting the DB Partition check-box, make sure that the database supports partitioning. In case of doubt, do not select it.
-
The installation creates a subfolder called db and within it nested sub-folders for each database supported by Magic xpi. If there was a problem creating the internal database during the installation, a log file will be created under the relevant database folder.
-
If you previously chose to install the database at a later stage, you can install it from these scripts (under the required database). A Read me file that explains how to run the scripts is included in the folder. Before doing the manual installation make sure that the references to the database in the Magic.ini file, Datasources.xml and other locations are correct.
|
To access IBM i data using a language other than English, you should add the following entries to the Magic.ini file's [MAGIC_DBMS] section:
-
DB2/400=7,NotAllowNull,10.3,DB2/400 Parameters,N,,NotLogSync,35,0,NotCheckExist,support\ACS400.[lng]
-
AS400=17,NotAllowNull,10.3,LANGUAGE=support\AS2EB.[lng] NAMING=*SQL NOMSGBOX,N,,NotLogSync,35,0,NotCheckExist,support\ACS400.[lng]
Here, [lng] represents the language that you want to use to access the IBM i data. For example, ger represents German, spn represents Spanish, and heb represents Hebrew.
The Magic xpi infrastructure is upgraded to support 64-bit runtime. This upgraded infrastructure is available as part of the previously released versions of Magic xpi 4.7.9 and above, Magic xpi 4.9.2 and above and Magic xpi 4.12.1 and above. If the user is upgrading from these versions to Magic xpi 4.13, the installation will be upgraded from the previously installed version. There will be no migration involved.
If the user is moving to Magic xpi from any other versions apart from the ones defined above, an additional migration step will be required. The installer will run the migration scripts automatically during the installation. The migration scripts will migrate the internal database to a newer setup.
This is applicable for all the supported internal databases, namely MS-SQL, Oracle, MySQL, DB2, and DB2/400.
(Since version: 4.13)
