Home Database Mysql Tutorial DB2 V9.7 Installation on RHEL5

DB2 V9.7 Installation on RHEL5

Jun 07, 2016 pm 03:49 PM
db db2

DB2安装前需要修改配置内核参数,修改/etc/sysctl.conf shmall默认是8G,建议将此参数设置为DB2服务器物理内存的90%,如果内存是16G,就是(16*0.9*1024*1024)/4=3774873,当前环境的物理内存是2G,也就是(2*0.9*1024*1024)/4=471859 shmmax建议和系统物理内存

DB2安装前需要修改配置内核参数,修改/etc/sysctl.conf

shmall默认是8G,建议将此参数设置为DB2服务器物理内存的90%,如果内存是16G,就是(16*0.9*1024*1024)/4=3774873,当前环境的物理内存是2G,也就是(2*0.9*1024*1024)/4=471859

shmmax建议和系统物理内存相等,在64位系统上必须至少设置为1G,即1073741824

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 1024
kernel.shmmax = 2147483648
kernel.shmall = 471859
kernel.sem = 250 256000 32 1024

kernel.randomize_va_space = 0

 

创建libpam.so软链接,具体参考IBM DB2解决方案 

IC87092: DB2PREREQCHECK GIVES WARNING "THE 32-BIT LIBRARY FILE LIBPAM.SO IS NOT FOUND ON THE SYSTEM." WHEN THE REQUIRED LIBPAM.SO.0 EXIST

[root@db2test server]# ln -s /lib/libpam.so.0.81.5 /lib/libpam.so

 

安装DB2软件

[root@db2test server]# ./db2setup 
DBI1190I  db2setup is preparing the DB2 Setup wizard which will guide

      you through the program setup process. Please wait.

DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5


DB2 V9.7 Installation on RHEL5

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Comparison and differences of SQL syntax between Oracle and DB2 Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

Comparative analysis of Oracle and DB2 database technology Comparative analysis of Oracle and DB2 database technology Mar 11, 2024 am 09:54 AM

Oracle and DB2 are two well-known relational database management systems (RDBMS) that are widely used in enterprise applications. In this article, we will compare the two database technologies of Oracle and DB2 and analyze them in detail, including analysis of their characteristics, performance, functions and usage examples. 1. Overview of Oracle database technology Oracle is a relational database management system developed by Oracle Corporation of the United States. It is widely used in enterprise-level applications and has strong performance and stability.

Comparative analysis of Oracle and DB2 database performance Comparative analysis of Oracle and DB2 database performance Mar 09, 2024 pm 10:00 PM

Oracle and DB2 databases are two leading relational database management systems that are widely used in enterprise-level applications. In practical applications, database performance is often one of the important indicators for evaluating the quality of a database system. This article will conduct a comparative analysis of the performance of Oracle and DB2 databases, and use specific code examples to demonstrate the differences between them. 1. Oracle database performance analysis Oracle database is a powerful database management system with good scalability and stability.

What is the difference between db2 and oracle syntax What is the difference between db2 and oracle syntax Jul 05, 2023 am 10:39 AM

Differences in syntax between db2 and oracle: 1. SQL syntax differences. Although db2 and oracle both use structured query language, they have some differences in syntax; 2. db2 and oracle have different data types; 3. Foreign key constraint definition, db2 can be defined when creating the table or added after using the "ALTER TABLE" statement. Oracle needs to be defined together when creating the table; 4. There are also some differences in the syntax of db2 and oracle stored procedures and functions.

What file format is db? What file format is db? May 19, 2021 am 11:56 AM

db is the abbreviation of "datebase", which is a format of "database file". It is a file used by software to store data, which is equivalent to a database. Each software has its own storage format. For example, "Thumbs.db" under Win7 system is a thumbnail data file, so the db file is not a specific file format.

What is the file format of db? What is the file format of db? Mar 07, 2023 pm 05:27 PM

db is a database file format, which is a file used by software to store data. It is equivalent to a database. Each software has its own storage format, that is, the way the data is arranged; the suffix of some software data files is DB. For example, Thumbs.db under Win7 system is a thumbnail data file; therefore, the db file is not a specific file format.

Comparison of features between Oracle and DB2 database management systems Comparison of features between Oracle and DB2 database management systems Mar 11, 2024 am 08:57 AM

Oracle and DB2 are two common relational database management systems, each with their own unique characteristics and advantages. This article will compare the characteristics of Oracle and DB2, and provide specific code examples to illustrate the differences between them. 1. Characteristics of Oracle database management system: Storage engine: Oracle database uses its own unique storage engine, called Oracle Database Engine (OracleDatabaseEngine), which can handle large-scale data storage.

How to assess and reduce the risks of MySQL to DB2 technology transformation? How to assess and reduce the risks of MySQL to DB2 technology transformation? Sep 08, 2023 pm 04:10 PM

How to assess and reduce the risks of MySQL to DB2 technology transformation? Overview: As enterprise business develops and needs change, there may be a need to migrate the MySQL database to a DB2 database. However, database migration inherently carries certain risks, especially when different database technologies are involved. This article will explore how to assess and reduce the risks of MySQL to DB2 technology transformation, and provide some code examples to help readers better understand this process. 1. Risk assessment: Technical transformation from MySQL to DB2

See all articles