in0de

// 설치 전 필요사항 체크 루틴

INODE:/sw/db2/FixPak # ./db2prereqcheck

// FixPak 4 를 tar 해제한 후 db2_install 실행
INODE:/sw/db2/FixPak # ./db2_install
 
Default directory for installation of products - /opt/IBM/db2/V9.5
***********************************************************
Do you want to choose a different directory to install [yes/no] ?
yes
Enter full path name for the install directory -
------------------------------------------------
/sw/db2/V9.5.0.4
 
 
Specify one of the following keywords to install DB2 products.
  ESE
  CONSV
  WSE
  CLIENT
  RTCL
 
Enter "help" to redisplay product names.
Enter "quit" to exit.
***********************************************************
ESE
DB2 installation is being initialized.

 Total number of tasks to be performed: 44
Total estimated time for all tasks to be performed: 2092

Task #1 start
Description: Enabling Asynchronous I/O
Estimated time 2 second(s)
Task #1 end

Task #2 start
Description: Checking license agreement acceptance
Estimated time 1 second(s)
Task #2 end


Task #43 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #43 end

Task #44 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #44 end

A minor error occurred while installing "DB2 Enterprise Server Edition " on
this computer. Some features may not function correctly.

For more information see the DB2 installation log at
"/tmp/db2_install.log.835722".

// minor error의 내용은 다음과 같음
// SA MP는 현 시스템에서는 사용하지 않는 모듈로, 무시해도 됨
Space required:                            1271 MB
Install SA MP Base Component:              No


DBI1130E  The SA MP Base Component could not be installed or updated
      because system prerequisites were not met. See the log file
      /tmp/prereqSAM.log.876590 for details.

Explanation:

There are system prerequisites for installing or updating the IBM Tivoli
System Automation for Multiplatforms Base Component (SA MP Base
Component). These prerequisites have not been met.

The mentioned log file has the details for the unsatisfied
prerequisites.

To find out more about the system prerequisites for the SA MP Base
Component, see the Installation and Configuration Guide at
http://publib.boulder.ibm.com/tividd/td/IBMTivoliSystemAutomationforMultiplatforms2.2.html.

The SA MP Base Component cannot be installed or updated.

User response:

Modify your system to meet the prerequisites; and use the installSAM
utility to manually install the SA MP Base Component.

INODE:/sw/db2/V9.5.0.4/instance # ./db2iupdt -u testfenc testinst
DBI1070I  Program db2iupdt completed successfully.

// 여기까지는 root 유저로 진행,
// 여기서부터는 instance 유저로 진행
INODE:/sw/db2/V9.5.0.4/instance # su - testinst



// FixPak 설치 후 라이선스가 초기화 되기 때문에 다시 업데이트 해주어야 함
INODE:/sw/db2/license $ db2licm -l
Product name:                     "DB2 Enterprise Server Edition"
License type:                     "Trial"
Expiry date:                      "09/06/2009"
Product identifier:               "db2ese"
Version information:              "9.5"

Product name:                     "DB2 Connect Server"
License type:                     "Trial"
Expiry date:                      "09/06/2009"
Product identifier:               "db2consv"
Version information:              "9.5"



INODE:/sw/db2/license $ db2licm -a db2ese_c.lic

LIC1402I  License added successfully.
LIC1426I  This product is now licensed for use as outlined in your License Agreement.  USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/sw/db2/V9.5.0.4/license/ko_KR.eucKR"

INODE:/sw/db2/license $ db2licm -a db2so.lic

LIC1402I  License added successfully.
LIC1426I  This product is now licensed for use as outlined in your License Agreement.  USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/sw/db2/V9.5.0.4/license/ko_KR.eucKR"


// 라이선스 업데이트 완료
INODE:/sw/db2/license $ db2licm -l
Product name:                     "DB2 Enterprise Server Edition"
License type:                     "CPU Option"
Expiry date:                      "Permanent"
Product identifier:               "db2ese"
Version information:              "9.5"
Enforcement policy:               "Soft Stop"
Features:
DB2 Database Partitioning:        "Not licensed"
DB2 Performance Optimization ESE: "Not licensed"
DB2 Storage Optimization:         "Licensed"
DB2 Advanced Access Control:      "Not licensed"
DB2 Geodetic Data Management:     "Not licensed"
IBM Homogeneous Replication ESE:  "Not licensed"

Product name:                     "DB2 Connect Server"
License type:                     "Trial"
Expiry date:                      "09/06/2009"
Product identifier:               "db2consv"
Version information:              "9.5"




// CLI, 원격 DB 유틸리티, 시스템 스키마에 대해서 다시 바인드 수행
INODE:/db2/testinst # db2 "bind ./sqllib/bnd/@db2cli.lst blocking all grant public sql error continue"
INODE:/db2/testinst # db2 "bind ./sqllib/bnd/@db2ubind.lst blocking all grant public sql error continue"
INODE:/db2/testinst # db2 "bind ./sqllib/bnd/db2schema.bnd blocking all grant public sql error continue"

// DB를 재기동하면 FixPak 적용이 완료됨
INODE:/db2/testinst # db2stop force
INODE:/db2/testinst # db2start

INODE:/db2/testinst # db2level
DB21085I  Instance "testinst" uses "64" bits and DB2 code release "SQL09054"
with level identifier "06050107".
Informational tokens are "DB2 v9.5.0.4", "s090429", "U825478", and Fix Pack "4".
Product is installed at "/sw/db2/V9.5.0.4".