In FanRuan applications, you (the admin) typically configure users, mount directories, assign permissions, and set scheduling plans. All the configuration is stored in a configuration database.
In production environments, you can prepare an IBM Db2 database to connect it with FanRuan applications for configuration storage. A stable external database ensures the reliable operation of FanRuan applications under high load.
This document explains how to connect a FanRuan project to an IBM Db2 database to store project configuration information:
You can prepare a tablespace in an IBM Db2 database and tune parameters.
After a project is deployed, you can connect the project to this configuration database.
You must prepare and deploy the Db2 database and tablespace by yourself.
FanRuan does not provide detailed guidance on database deployment. Only essential requirements are specified. Refer to the official Db2 documentation for additional assistance.
The following table lists FanRuan-tested environments.
Databases of earlier versions not mentioned are generally not supported or contain known issues; thus, they are not recommended.
You can test databases of higher versions that are not mentioned. If issues arise, premium customers can contact technical support. For details about how to contact technical support, see Technical Support Channel Introduction.
It refers to the memory allocated to the configuration database, not total server memory.
A dedicated server for the configuration database is recommended.
If resources are limited, ensure that no content other than the FanRuan application is deployed on the server hosting the configuration database, and ensure sufficient memory is allocated to the configuration database.
The configuration database, application, and other components should be on the same network segment to avoid network instability.
Ensure network connectivity and accessible ports between the configuration database, application, and other components.
Adjust it based on usage.
Allocate 1 to 2 times the recommended size of space.
Different FanRuan projects cannot share the same database tablespace as the configuration database. Otherwise, data corruption may occur.
Therefore, you are advised to create a new tablespace in the database to store configuration data.
The standard tablespace creation statement is as follows:
CREATE SCHEMA FINEDB
You are advised to use an all-English tablespace name. The tablespace name supports only letters, numbers, underscores (_), and dots (.).
Do not store any other data (such as business data and logs) in this tablespace.
If the data volume in the configuration database is high and log space is insufficient, errors may occur during configuration (SQLCODE=-964, SQLSTATE=57011).
Therefore, ensure that the Db2 database has sufficient log space in advance.
Prepare the following tablespace information to connect it to the project as the configuration database.
Name of the tablespace created in the "Creating a Tablespace" section
IP address of the database server
The host name supports only letters, numbers, underscores (_), hyphens (-), and dots (.).
Database username
The user must have CREATE, DELETE, ALTER, UPDATE, SELECT, INSERT, and INDEX privileges to support configuration table structure changes and configuration updates.
Since the database schema is usually named after the user, you are advised to use only letters and numbers. Special characters are not recommended.
Database user password
After the configuration database is successfully connected, do not change the username or password. Otherwise, the project will fail to start.
Choose the appropriate connection method based on the actual conditions.
You can configure a self-prepared Db2 database as the configuration database in FineOps’s Cluster Management.
Uploading a Driver for the FanRuan Project
By default, Db2 drivers are not built into FanRuan projects. You need to upload them manually. You must perform operations in this section. Otherwise, the connection will fail.
1. Go to the IBM website and download the driver package that matches your database version: IBM Official Website.
2. Upload the driver to the project. For details, see Driver Management.
Verifying the FineOps Version
This document provides instructions based on FineOps of the latest version. Ensure FineOps is of V2.31.0 or later versions.
For projects requiring no configuration data migration, FineOps of V2.30.0 and earlier versions cannot restart projects automatically.
For multi-application projects, FineOps of V2.29.0 and earlier versions require ensuring only one application node is active during configuration service connection or migration.
For details, see Extranet-Based FineOps Upgrade and Intranet-Based FineOps Upgrade.
Configuring the External Configuration Database
1. Log in to FineOps as the admin. Select the target project.
2. Choose Maintenance > Cluster Management, and configure External Configuration Database.
3. Enter the database information:
Database Type: Select Db2.
Driver: No change is required. Keep com.ibm.db2.jcc.DB2Driver.
Database Name, Host, Port, Username, Password: Enter the information prepared in the "Preparing the Configuration Database Information" section.
4. Set Schema:
After filling in all the above information correctly, click Click to Connect Database in the drop-down list of Schema. The system will automatically connect to the database and read the schema.
Prefer the schema that matches the database username.
5. Database Connection URL:
Generally, no manual modification is needed. It is generated from other configuration and preset parameters.
6. Choose whether to tick Migrate Data to Database to Be Enabled:
1. Migrate Data to Database to Be Enabled must be ticked.
2. After a successful connection, the existing configuration data of the project will be migrated to the tablespace.
3. Any existing data in the new Db2 tablespace will be cleared and cannot be recovered.
1. Upload the prepared configuration data to the new Db2 tablespace.
Ensure the JAR package version of the source project exactly matches the JAR package version of the current project.
2. Do not tick Migrate Data to Database to Be Enabled.
3. After a successful connection, the project will use the data in the tablespace as its configuration.
4. Original connection information will be backed up to the db.properties.bak file in the config directory of the project.
5. Historical configuration cache exists in the project. Restart the project after a successful configuration database switchover to clear the cached configuration.
7. Click Enable Database.
Restarting the Project (with Migrate Data to Database to Be Enabled Unticked)
If Migrate Data to Database to Be Enabled is unticked, the historical configuration cache will remain in the project after the configuration database switchover. You must restart the project to clear the cache.
FineOps-deployed projects: FineOps automatically restarts the project after a successful configuration database switchover.
Projects not deployed via FineOps: Manually restart the project after the switchover. For details, see Closing or Restarting the FineBI Project.
You can configure a self-prepared Oracle database as the configuration database under System Management > System Setting > General of the FanRuan application.
Ensuring a Single Active Application (Required for Multi-application Projects)
For multi-application projects, ensure only one application node is active during configuration service connection or migration.
Log in to FineOps as the admin. Select the target project and choose Maintenance > Component Management. Check if multiple bi-web/fr/fdl containers are active.
If multiple containers exist, click the icon of each container to stop other containers, leaving only one in active status.
1. Log in to the FanRuan application as the admin. Choose System Management > System Setting > General.
2. Locate External Database and configure it.
Database Type: Select db2.
7. Click Enable New Database. The message “Migrated successfully” indicates a normal connection.
Ensuring Multi-application Configuration Synchronization (Required for Multi-application Projects)
1. Copy the db.properties file.
Navigate to the server hosting the single active bi-web/fr/fdl container and copy the db.properties file in the component mounting path /config.
Paste the file to the same location on all other bi-web/fr/fdl container servers.
2. Stop all applications.
Log in to FineOps as the admin and choose Maintenance > Component Management.
Click Stop on all FineBI - Application Node/FineReport/FineDataLink components. Ensure all bi-web/fr/fdl containers are in the exited status.
3. Restart all applications.
Click Start on all FineBI - Application Node/FineReport/FineDataLink components under Maintenance > Component Management. Ensure all bi-web/fr/fdl containers are in the running status.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy