DB2 database design (1)

This article introduces you to some suggestions for installing the DB2 database, including the language used during the installation process, the size and quantity of database objects, and so on.

When deploying a database in an enterprise, you must first install the database on the operating system. When installing the database, you need to select the language environment for installation. That is, the database is installed in Chinese or English. If the installation program is started, you can use the/ilanguage option to specify the language used during the installation. So far, the DB2 database has supported many languages. What language should the database be installed in?

1. Select the appropriate language and database Character Set

As long as the database administrator has a basic English language, it is recommended that you use an English language environment for installation. Although the Chinese language environment of the DB2 database has been well designed, I am still worried about some unknown vulnerabilities. Therefore, when installing the DB2 database, the author basically uses the English language environment for installation. Set the language to "EN" to English. Improve the efficiency of DB2 data backup and recovery.

In addition, if you want to save data other than English in the DB2 database, or you want to access the database using different character sets, you also need to select a specific database character set during database installation. All character data in the DB2 database, including data in the data dictionary, are stored in the database character set.

If you use different character sets to access the database, the database administrator needs to select a superset that contains the character sets of all these users. Only in this way can the system easily use replacement characters to complete character conversion, thus improving database performance. If the selected character set is incorrect, some inexplicable problems may occur. If a user does not select the appropriate character set during database installation.

Although there is no problem in storing Chinese characters during use. However, when the database is restored, it is found that some of the restored databases are originally Chinese characters, and garbled characters appear. This is mainly because the appropriate character set is not selected. Sometimes, if the character set is improperly selected, Chinese data cannot be imported smoothly when data is imported from an external data source (such as an Excel table. Therefore, when installing the database, the database administrator needs to select the appropriate character set based on the actual enterprise.