首页 > 数据库 >Installation requirements for DB2 UDB 8.1 Enterprise Servers

Installation requirements for DB2 UDB 8.1 Enterprise Servers

时间:2023-02-07 16:14:38浏览次数:71  
标签:8.1 DB2 requirements system db2udb8 Servers db2 Click

UDB 8 Install

 

Home
Up
pre-UDB 8 Install
UDB 8 Install

Addendum

 

Steps to do before/after applying a DB2 Fixpak

DB2 8.2GA Itanium Installation

Installation requirements for DB2 UDB 8.1 Enterprise Servers

Hardware, operating system, software,  patch & kernel requirements for each platform are listed below:

Note: If you are installing on a st- boxes, remember to add the Application Development Tools.

For db2 8.1

            db2setup --> Install Product

                            --> DB2 UDB Enterprise Server Edition

                            --> 1. Introduction

                            --> 2. Software License Agreement. check Accept

                            --> 3. Installation Type. Check Custom

                            --> 4. Installation Action. Check Install DB2 UDB ESE on this computer.

                            --> 5. Features. Check Application Development Tools.

For db2 7.1

            db2setup --> To select products and their components, select Install. highlight Install and hit enter.

                            --> Select DB2 Application Development Client.

DB2 Version 8.1 Requirements for IBM AIX

Hardware Requirements:

bullet IBM RISC/6000
bullet eServer pSeries
bullet 256 MB of RAM

Operating System & Patch Level Requirements:

bullet AIX Version 4.3.3 with maintenance level 9 or later (32-bit)
bullet AIX Version 5.1.0 with maintenance level 3 or later (32 bit and 64 bit)

Software Requirements:

bullet JRE Version 1.3.1

 

DB2 Version 8.1 Requirements for HP-UX

Hardware Requirements:

bullet HP 9000 Series 700 or 800 system
bullet 256 MB of RAM

Operating System & Patch Level Requirements:

bullet HP-UX 11.i with December 2002 GOLDBASE11i & December 2002 GOLDAPPS11i
bullet HP-UX 11.i with

PHSS_26560 superceded by PHSS_28871
PHCO_29495
PHC0_27740
PHCO_24402
PHKL_28489 
( for problem cataloging database )
 

NOTE: If you have problems during the DB2 installation where the instance creation
          fails, you must make sure that you have the above patches installed.  That should
          solve the problem.  One thing you can also try if the instance creation still fails is
          to not select instance creation during the DB2 Installation and when the DB2 Software
          installation is complete then manually create the instance.

NOTE: If you are installing DB2 8.1 on an Itanium system running HP-UX 11.2X, use
         /repos1/HP/db2-udb-hpi-8.1.ga.tar.   After installing DB2 8.1, you MUST install Fixpak 4a
        and a special fix after that. Fixpak 4a is called /repos1/HP/db2-udb-hpi11.2x-8.1-FP4a.tar
        and the special fix is   /repos1/HP/db2-udb-hpi11.2x-8.1-9903.tar.Z. There is a readme file
        in the tar that explains how to apply the special fix.

Software Requirements:

bullet JRE Version 1.3.1

Kernel Requirements:

Before installing DB2 8.1 for HP-UX, you will need to modify the systems' kernel parameters and re-boot the system. The values below are IBM recommended values.

Kernel Parameter

Physical Memory

64 - 128 MB 128 - 256 MB 256 - 512 MB 512 MB +
nfile (4 * ninode) (4* ninode) (4* ninode) (4* ninode)
nflocks 2048 4096 8192 8192
ninode 512 1024 2048 2048
nproc 512 768 1024 2048
         
maxfiles 256 256 256 256
maxuprc 256 384 512 1500
         
msgmap 130 258 258 2050
msgmax 65535 65535 65535 65535
msgmnb 65535 65535 65535 65535
msgmni 128 256 256 1024
msgseg 8192 16384 32767 32767
msgssz 16 16 16 16
msgtql 256 512 1024 2048
         
semmap 130 258 514 2050
semmni 128 256 512 2048
semmns 256 512 1024 4096
semmnu 256 512 1024 1024
         
shmmax 67108864 134217728 268435456 268435456
shmmni 300 300 300 1,000

 

DB2 8.2GA Itanium Installation

  1. Uninstall any previous DB2 software on the HP IA64 machine.
  2. Untar the DB2 V8.2 GA (8.1 FP7) from /repos1/HP/db2-udb-ese-hpi-8.2ga-sbcs1.tar   to a file system with enough space.
  3. Copy the DB2 8.2 license file /repos1/Misc/db2-lic-hpi-11.2x-8.2_db2ese.lic to where you untarred the DB2 V8.2 GA software.
  4. Install the DB2 8.2 GA using db2setup that is located in the directory where you untarred the
    DB2 8.2GA software.
  5. Once the DB2 8.2GA installation completes then untar the DB2 8.2GA FP7p fixpak
    from /repos1/HP/db2-udb-hpi11.2x-8.2-ia64_FP7p.tar and follow the normal instructions
    to install the fixpak.

DB2 Version 8.1 Requirements for Solaris

Hardware Requirements:

bullet Solaris UltraSPARC based computer
bullet 256 MB of RAM

Operating System & Patch Level Requirements:

bullet Solaris 7 (32-bit) & patch 106327-10
bullet Solaris 7 (64-bit) & patch 106300-11
bullet Solaris 8 (32-bit) & patches 108434-03, 108528-12 & Maintenance Update 4
bullet Solaris 8 (64-bit) & patches 108434-03, 108528-12, 108827-35 & Maintenance Update 4

Software Requirements:

bullet JRE Version 1.3.1

Kernel Requirements:

Kernel Parameter

Physical Memory

1 - 2 GB RAM 2 - 4 GB RAM 4-16 GB RAM
msgsys:msginfo_msgmax 65535 65535 65535
msgsys:msginfo_msgmnb 65535 65535 65535
msgsys:msginfo_msgssz 32 32 32
msgsys:msginfo_msgseg 32767 32767 32767
msgsys:msginfo_msgmap 1794 2562 3586
msgsys:msginfo_msgmni 1792 2560 3584
msgsys:msginfo_msgtql 1792 2560 3584
semsys:seminfo_semmap 2050 3074 4098
semsys:seminfo_semmni 2048 3072 4096
semsys:seminfo_semmns 4300 6452 8602
semsys:seminfo_semmnu 2048 3072 4096
semsys:seminfo_semume 240 240 240
shmsys:shminfo_shmmax 966367641 1932735283 3865470566
shmsys:shminfo_shmmni 2048 3072 4096
shmsys:shminfo_shmseg 240 240 240

 

Refining kernel parameter settings after installation

After installation, the db2osconf utility can be used to recommend more accurate kernel parameters based on the size and configuration of your system.  NOTE: the db2osconf utility does not change the /etc/system file and the system must be restarted in order for any changes to the /etc/system file take place.

 

db2osconf - Utility for Kernel Parameter Values Command

Makes recommendations for kernel parameter values based on the size of a system. The recommended values are high enough for a given system that they can accommodate most reasonable workloads. This command is currently available only for DB2(R) on Solaris systems.

Authorization

To use this utility, you must have root access or be a member of the sys group.

Command Syntax

To get the list of currently supported options, simply enter db2osconf -h:

   db2osconf -h
Usage:
 -c                 # Client only
 -f                 # Compare to current
 -h                 # Help screen
 -l                 # List current
 -m <mem in GB>     # Specify memory in GB
 -n <num CPUs>      # Specify number of CPUs
 -p <perf level>    # Msg Q performance level (0-3)
 -s <scale factor>  # Scale factor (1-3)
 -t <threads>       # Number of threads
                      

The '-c' switch is for client only installations.

Command Parameters

 
-f
The '-f' switch can be used to compare the current kernel parameters with the values that would be recommended by the db2osconf utility. Only the kernel parameters that differ will be displayed. Since the current kernel parameters are taken directly from the live kernel, they may not match those in /etc/system, the Solaris system specification file. If the kernel parameters from the live kernel are different than those listed in the /etc/system, the /etc/system file might have been changed without a reboot or there might be a syntax error in the file.
-l
The '-l' switch simply lists the current kernel parameters
-m
The '-m' switch overrides the amount of physical memory in GB. Normally, the db2osconf utility will determine the amount of physical memory automatically.
-n
The '-n' switch overrides the number of CPUs on the system. Normally, the db2osconf utilities will determine the number of CPUs automatically.
-p
The '-p' switch sets the performance level for SYSV message queues. 0 (zero) is the default and 3 is the highest setting. Setting this value higher can increase the performance of the message queue facility at the expense of using more memory.
-s
The '-s' switch sets the scale factor. The default scale factor is 1 and should be sufficient for almost any workload. If a scale factor of 1 is not enough, then the system may be too small to handle the workload. The scale factor sets the kernel parameters recommendations to that of a system proportionally larger then the size of the current system. For example, a scale factor of 2.5 would recommend kernel parameters for a system that is 2.5 times the size of the current system.
-t
The '-t' switch provides recommendations for semsys:seminfo_semume and shmsys:shminfo_shmseg kernel parameter values. For multi-threaded programs with a fair number of connections, these kernel parameters may have to be set beyond their default values. They only need to be reset if the multi-threaded program requiring them is a local application:
semsys:seminfo_semume
Limit of semaphore undo structures that can be used by any one process
shmsys:shminfo_shmseg
Limit on the number of shared memory segments that any one process can create.

These parameters are set in the /etc/system file. The following is a guide to set the values, and is what the db2osconf tool uses to recommend them. For each local connection DB2 will use one semaphore and one shared memory segment to communicate. If we assume the multi-threaded application is a local application and has X number of connections to DB2, then that application (process) will need X number of shared memory segments and X number of the semaphore undo structures to communicate with DB2. So the value of the two kernel Parameters should be set to X + 10 (the plus 10 provides a safety margin).

Without the '-l' or '-f' switches, the db2osconf utility displays the kernel parameters using the syntax of the /etc/system file. To prevent human errors, the output can be cut and pasted directly into the /etc/system file.

The kernel parameters are recommended based on both the number of CPUs and the amount of physical memory on the system. If one is unproportionately low, the recommendations will be based on the lower of the two.

 

DB2 Version 8.1 Requirements for LINUX

Hardware Requirements:

bullet Intel 32 bit
bullet Intel 64 bit
bullet S/390 9672 Genertation 5 or higher, Multiprise 3000 or eServer z-Series
bullet 256 MB RAM
bullet 350 - 700 MB of Disk space

Operating System & Patch Level Requirements:

bullet For Intel 32 bit --> kernel level 2.49 or later, glibc 2.2.4 or later & RPM 3 or later
bullet For Intel 64 bit --> Red Hat Linux Advanced Server 2.1, gcc 3.0.2, gcc3 libstdc++ runtime libraries
bullet For z Series --> Red Hat Linux Advanced Server 2.1

For additional information on latest operating system and patch level
requirements, see IBM's website:

http://www-3.ibm.com/software/data/db2/linux/validate/

Software Requirements:

bullet JRE Version 1.3.1 o later

Kernel Requirements:

Systems using a 2.4.x series kernel have a default value for the message queue parameter(msgmni) and semaphore array parameters that must be changed for DB2 to run successfully. To check shared memory segment, semaphore array, and message queue limits, issue the ipcs -l command:

------ Shared Memory Limits ------
max number of segments = 4096    // SHMMNI
max seg size (kbytes) = 32768
max total shared memory (kbytes) = 8388608
min seg size (bytes) =1

------ Semaphore Limits ------
max number of arrays = 1024    // SEMMNI
max semaphores per aray =250
max semaphores system wide = 128000
max ops per semop call = 32
semaphore max value = 32767

------ Message Limits ------
max queue system wide = 1024                // MSGMNI
max size of message (bytes) = 65536  
default max size of queue (bytes) 16283  // MSGMAX

Modify the kernel parameters by adding the following entries to the default system control
configuration file /etc/sysctl.conf:

kernel.msgmni = 1024
kernel.msgmax = 65536
kernel.sem = 250 320000 32 1024
kernel.shmmax = 268435456 for 32 bit system; 1073741824 for 64 bit system
fs.file.max = 8192

Run sysctl -p to load in sysctl settings from the default file /etc/sysctl.conf. The entries from the
sysctl.conf file are read during startup by the network initialization script.

Reboot the system after modifying the kernel parameters.

Special note for RedHat AS3 and DB2 8.1

Install the Java 1.4.2 rpm from the repository:
    rpm -ivh /repos1/Lnx/j2sdk-1_4_2_03-linux-i586.rpm

After mounting the CD from the jukebox, extract the files from the CD into a temporary directory.
    mount tl-sun04:/data1/cdroms/Lnx/db2-udb-lin-8.1.2_32bit /mnt
    mkdir /ds1/tmp
    chmod 1777 /ds1/tmp
    cd /ds1/tmp
    tar xf /mnt/ese.tar

Remove the java directory, and symlink the Java 1.4.2 directory in its place.
    rm -r /ds1/tmp/ese/db2/linux/java
    ln -s /usr/java/j2sdk1.4.2_03 /ds1/tmp/ese/db2/linux/java

Start the installer:
    /ds1/tmp/ese/db2setup

Installing DB2 8.1:

IMPORTANT: After installing the DB2 8.1 GA software, always apply FixPak4
unless told otherwise.
 It can be applied on top of any previous FixPak or GA
Its readme are in /repos1/<platform>/db2-fixpak8.1-<platform>-FP4.tar.Z  Once the FixPak
installed, run the following as instance owner to make sure the remote access is enabled.

db2set DB2COMM=TCPIP

If you are installing DB2 8.1on an Itaniums system running HP-UX 11.2x, you must install
a special fix after installing FixPak 4a. The special fix which is located at
/repos1/HP/db2-ydb-hpi11.2x-8.1-9903.tar.Z. The installation instructions are in the
tar file.

NOTE: The cd in the jukebox1 for LINUX DB2 8.1 already has FIXPak 2 applied.

  • Login as root. Create the group db2grp with a gid of 900. (NOTE: Unlike version 2.1.2, DB2 user ids will be created during this installation process.)
  • Make sure the disk repository (/repos1) or (/jukebox1) is auto mounted. If not, manually mount the filesystem. Go to manual mounts for procedures.
    1. Make a copy of the nodelock file if it exists:
      bullet cd /var/ifor
      bullet cp nodelock SV.nodelock
  • Set your DISPLAY variable. DISPLAY=<yourworkstation>:0.0;export DISPLAY
  • For Sun & HP-UX systems, create an installation directory under products:

    mkdir -p /products/db2/V8.1
  • Create a symbolic link under /opt/IBM/db2 to point to the installation directory. If /opt/IBM/db2 does not exist, create it first.:

    # mkdir -p /opt/IBM/db2

    ln -s /products/db2/V8.1 /opt/IBM/db2
  • Make sure the /dbx/prod dirctory exists and create a symlink to it:

    mkdir -p /dbx/prod

    ln -s /products/db2/V8.1 /dbx/prod/8.1

    Note: For AIX systems the product will be installed under /usr/opt/db2_08_01 so create the symlink from there:

    ln -s /usr/opt/db2_08_01 /dbx/prod/8.1


  • If DB2 7.1 is installed on the system, you must shut down all instances  before attempting to install DB2 8.1 or the installation process will hang. Once DB2 8.1 is installed you can bring the instances back up.
  • The DB2 installation software is located under /jukebox1/db2-udb-<platform>-8.1.

Change to the directory where the CD-ROM is mounted by entering the following command:

    # cd /jukebox1/db2-udb-<platform>-8.1. 

Note: For AIX 4.3.3, please use: /repos1/Ibm/db2-udb-aix-4.3.3-8.1.tar file.

Note: For HP-UX 11.2x (Itanium systems), use /repos1/HP/db2-udb-hpi-8.1.ga.tar
                                

For HP-UX

Enter the ./db2setup command to start the DB2 Setup wizard. For Solaris Operating Environment
  • Copy ese.tar.Z, to a temporary filesystem.
  1. Enter the following command to start the DB2 Setup wizard:
    zcat ese.tar.Z | tar -xf - ; ./ese/db2setup
    
                                                                                                             
For AIX Operating Environment
  • Copy ese.sbcs.tar.Z, to a temporary filesystem.
  1. Enter the following command to start the DB2 Setup wizard:
    zcat ese.sbcs.tar.Z | tar -xf - ; ./ese/db2setup
                                                                                                             

After a moment, the IBM DB2 Setup Launchpad opens.
From this window, you can view installation prerequisites and the release notes, or you can proceed directly to the installation.

Once you have initiated the installation, proceed through the DB2 Setup wizard installation panels and make your selections.

Note: For AIX 4.3.3 DB2 Server installs, create db2udb8db2as8 and db2fenc8 users before the installation.  Make sure there is a .profile created in each user's home directory. 

Note: For Linux AS 2.1 and AS 3 DB2 Server installs, create db2udb8db2as8 and db2fenc8 users before the installation.  Make sure there is a .profile created in each user's home directory. 

From the IBM DB2 Setup Welcome, select the option Install Products.

bullet Click on the selection, DB2 UDB Enterprise Server Edition
bullet Click Next

Welcome Page

bullet Click Next
bullet Click to Accept License Agreement
bullet Click Next
bullet Select Installation Type as  Custom
bullet Click Next
bullet Select the Installation action as Install DB2 UDB Enterprise Server Edition on ths computer
bullet Click Next
bullet Select the features to install as default
DB2 UDB Enterprise Server Edition
Server Support
Client Support
Adminstration Tools
Getting Started
bullet Click Next
bullet Don't make any changes to the Languages screen
bullet Click Next

The next screen you will see is:

Set user Information for the DB2 Administrator

bullet Cick on New User

User Name: db2as8
UID: 251
GroupName: db2grp
Password: db2as8
Confirm Password: db2as8
Home Directory: ie: /ds1/home/db2as8

bullet Click Next

The next screen you will see is:

Setup a DB2 Instance.

bullet Click on Create a DB2 instance (32 bit or 64 bit)
bullet Click Next

Select how the instance will be used

bullet Click on Single partition instance
bullet Click Next

Set User information for the DB2 instance owner

bullet Click on New User
bullet Enter the following:

User Name: db2udb8
UID: 249
GroupName: db2grp
Password: db2udb8
Confirm Password: db2udb8
Home Directory: ie: /ds1/home/db2udb8

bullet Click Next

Set User information for the fenced User

bullet Click on New User
bullet Enter the following:

User Name: db2fenc8
UID: 250
GroupName: db2grp
Password: db2fenc8
Confirm Password: db2fenc8
Home Directory: ie: /ds1/home/db2fenc8

Click Next

Configure DB2 Instance TCP/IP Communication

bullet Configure Service Name db2c_db2udb8
bullet Port Number 50004
bullet Click Next


Set Instance Properties

bullet Select Authentication type Server
bullet Click  Autostart the instance at system startup
bullet Click Next


Prepare the DB2 Tools Catalog

bullet Click on Use a local database
bullet Click Next

Specify a local database to store the DB2 Tools Catalog

bullet Instance: db2udb8
bullet Database: New: TOOLSDB
bullet Schema: New: SYSTOOLS
bullet Click Next

Setup the Administration contact list

bullet Administration contact list location select Local - Create a contact list on this system.
bullet Notification SMTP Server select enable Notification
bullet Notificaton SMTP Server: <hostname>
bullet Click Next

Spcecify a contact for health monitor notification

bullet Click New Contact

Name: db2udb8
Email Address: db2udb8@<hostname>

bullet Click Next

A message displays "Copying files", when complete click on Finish.

10. When the installation has completed, remove the temporary directory created for the installation.

11. Add license information:

# cd /dbx/prod/8.1/adm

# ./db2licm -a /repos1/Misc/db2-lic-all-8.1_db2ese.lic

# ./db2licm -a /repos1/Misc/db2-lic-all-8.1_db2conee.lic

Note: For Redhat 3.0, use the following two license files.

/repos1/Misc/db2-lic-as3.0-8.1_db2ese.lic

/repos1/Misc/db2-lic-as3.0-8.1_db2conee.lic

We've found that this license only covers one processor. In order to avoid license errors in the log, IBM suggests that we do the following after installing the licenses. You can determine how many processors your system has by checking in SETI.

./db2licm -n db2ese <number of processors>

Example: ./db2licm -n db2ese  4

 

12. NOTE: If a manual mount was performed, please unmount the filesystem now.

13. Create entries in /etc/dbmap and /etc/dbxtab for db2udb8. These files may need to be created, with permissions 777:

In /etc/dbmap, add the following:
     dbx:db2udb8:db2udb8

In /etc/dbxtab, add the following:
     db2udb8:/<homedir>/db2udb8:N

Then chown db2udb8:db2grp /etc/dbxtab.

14. Change to the db2udb8 home directory and then to sqllib. Edit the /sqllib/db2profile file to reflect the following:

DB2COMM=TCPIP
export DB2COMM
LIBPATH=$LIBPATH:[db2udb's-home-directory]/sqllib/lib
export LIBPATH

15. Check the /etc/services file. It should have five entries for the DB2 instance, created automatically during the installation:
 
     For db2udb8   (version 8.1):

    DB2_db2udb8      60000/tcp

    DB2_db2udb8_1   60001/tcp

    DB2_db2udb8_2   60002/tcp

    DB2_db2udb8_END 60003/tcp

    db2c_db2udb8    50004/tcp

16.
During the db2setup, DB2 user ids were created, each with a .profile. For the user id db2udb8 move its .profile so that /etc/profile will be used:

cd [db2udb's-home-directory]

NOTE: We should not be moving DB2's .profile because during the creation of DB2 Instance the .profile gets updated with db2 commands, ie: executing the db2profile or dasprofile for the db2as8 admin server.

(mv .profile SV.profile) do not do this step.

17. Login as user id db2udb8. Source the db2profile, located in the sqllib directory, to set the environment variables:

. sqllib/db2profile

18. Now execute the db2 command and check that the service name has been added by the install process. If the service name is incorrect, that is, is not db2c_db2udb8, then execute the following command to change it:

db2=> UPDATE DATABASE MANAGER CONFIGURATION USING SVCENAME db2c_db2udb8

db2=> get dbm cfg
db2=> terminate

19. Now stop and restart the instance you created during db2setup:

db2 force application all 

(This will shutdown the TOOLSDB database that was created during the installation.  You cannot issue a db2stop with databases running.)

db2stop

db2set DB2_REDUCED_OPTIMIZATION=YES ( This should be done on every instance. It fixes some performance issues )

NOTE: At this point, if installing db2 v8.1 on HP Itanium, update the instance
and Administrative Server as follows (otherwise the instance will crash when
creating a database):

bullet Be sure all db2 v8.1 processes are down, including db2as8 (via "db2admin stop").
bullet cd /dbx/prod/8.1/instance
bullet ./db2iupdt db2udb8
bullet ./dasupdt db2as8

db2start (should get "DB2START processing was successful.")

Be sure you don't get warning messages about having a temporary license....this must be fixed.

20. Then execute the db2 command again to create a database and table and to test connectivity:

NOTE: Instead of executing db2 and then entering each command while within db2, you may type db2 "[command]" for each command. This allows you to use ksh to correct typing errors easily if needed.

$ db2
db2=> create database db2test
DB20000I the CREATE DATABASE command completed sucessfuly
db2=> connect to db2test
Database Connection Information Database server = DB2/6000 5.2.0
SQL authorization ID = DB2UDB1
Local database alias = DB2TEST
db2=> create table t1 (name char(20))
DB20000I The SQL command completed successfully
db2=> insert into t1 values ('Viva Nina')
DB20000I The SQL command completed successfully.
db2=> select * from t1
NAME -------------------- Viva Nina 1 record(s) selected.
db2=> commit
DB20000I The SQL command completed successfully.
db2=> disconnect db2test
DB20000I The SQL command completed successfully.
db2=> drop database db2test
DB20000I The SQL command completed successfully.

db2=>list applications
The system should echo "No data was returned by Database System Monitor."

db2=> force application all
db2
=> quit

Terminate the db2 server and agents:

db2 => terminate
db2stop
 


The installation of DB2 is complete.

Remove ese.sbcs directory from the temporary installation directory.

Steps to do before/after applying a DB2 Fixpak

NOTE: Applying FP4 on AIX:

bullet The installFixPak script requires the following filesets to be at 6.0.0.5.
The installFixPak script will fail if these filesets are not at 6.0.0.0 or above.

If the filesets are at 6.0.0.0 the script will continue, it will only fail if
the filesets are below 6.0.0.0.

xlC.adt.include 6.0.0.0

xlC.aix50.rte 6.0.0.0

xlC.rte 6.0.0.0

Run the following commands for each instance:

bullet su - [instance name], ie: db2udb8
. $HOME/sqllib/db2profile
bullet db2 force applications all
bullet db2 terminate
bullet db2stop
bullet db2licd -end # run at each physical node
bullet exit
bullet su - [admin name], ie: db2as8
bullet . $HOME/das/dasprofile
bullet db2admin stop
bullet exit

On Aix systems run the following command:

bullet /usr/sbin/slibclean

On Aix systems, Clean up all the IPCs owned by the instance owner.

bullet Use ipcs and ipcrm

Start the Fixpak installation by doing the following:

bullet Follow the readme file on how to install a DB2 patch, ie:
Copy DB2 Fixpak to a temporary location and untar.
bullet Run - ./installFixPak

Post Installation Steps, update instances to use the new level of DB2:

bullet cd DB2HOME/instance
bullet ./db2iupdt [instance name], ie: db2udb8
bullet ./dasupdt [admin name], ie: db2as8

You should now start up the instances.

bullet su - [instance name], ie: db2udb8
bullet cd sqllib
bullet . ./db2profile
bullet Special note for DB2 8.1FP4 on RedHat AS3 -- Run the following command:
   db2set DB2_SCATTERED_IO=ON 
  -- This is fixed in FP5
bullet db2start
bullet db2level  (Make sure that the db2 level shows the correct Fixpak Level), ie:

$ db2level
DB21085I Instance "db2udb8" uses "32" bits and DB2 code release "SQL08014"
with level identifier "02050106".
Informational tokens are "DB2 v8.1.0.32", "s031027", "U488487", and FixPak "4".
Product is installed at "/opt/IBM/db2/V8.1".

 

 

Send mail with questions or comments about this site. Copyright © 1999-2004, PeopleSoft, Inc. For internal use only.

标签:8.1,DB2,requirements,system,db2udb8,Servers,db2,Click
From: https://www.cnblogs.com/z-cm/p/17098805.html

相关文章