DB2 v9.7 Installation


Open DB2 Setup Launchpad to install the DB2 Enterprise Server Edition v9.7 , it will install the DB2 copy with name "DB2COPY1






Selected Typical installation type



Give a path to save the installation settings in response file



Select the installation folder


Provide DB2 admin user and password


Default instance ("DB2") will be created during the installation (it stores application data)




You can configure this DB2 instance like port numbers ,named pipes and run as windows service



Named pipes are disabled by default but I have changed to NOT start DB2 service at system startup(Changed the auto start to manual)



DB2 Tools catalog must be created in order to use the Task center and scheduler. These tools allows you to schedule common tasks such as backups and this information stores in the DB2 database created above.



Unchecked or disabled the DB2 server automatic health notifications to alert admins (Need to provide the unauthenticated SMTP server details to enable these notifications)



Enabled the Operating System security for the DB2 files , folders and other objects . This step will create DB2ADMNS and DB2USERS groups in operating system.



Review all inputs before click finish.

Product to install
DB2 Enterprise Server Edition - DB2COPY1
Installation type
Typical
DB2 copy name
DB2COPY1
Set as default DB2 copy
Yes
Set as default IBM database client interface copy
Yes
Selected features
DB2 Update Service                    
Base application development tools    
Base client support                   
Configuration Assistant               
Connect support                       
Control Center                        
IBM Data Server Provider for .NET     
First Steps                           
Spatial Extender client               
JDBC Support                          
IBM Software Development Kit (SDK) for Java(TM)  
DB2 LDAP support                      
ODBC Support                          
OLE DB Support                        
Replication tools                     
Sample database source                
SQLJ Support                          
DB2 WMI Provider                      
               
Languages
English 
Target directory
C:\IBM\DB2
Space required
966 MB
Installation specific driver details   

IBM Data Server Driver for ODBC and CLI name
 IBM DB2 ODBC DRIVER - DB2COPY1
New instances
                         
Instance name
DB2
Start instance on reboot
No
TCP/IP configuration
             
Service name
 db2c_DB2
Port number
5OOOO
Instance user information
        
User name
db2admin
                                       

DB2 Administration server
             
Instance user information
            
User name
db2admin
                                                                              

DB2 tools catalog
                     
    Name
TOOLSDB
    Schema
SYSTOOLS
    Instance
DB2
    Location
Local
                                       

Response file name
C:\Users\Siva\Documents\PROD_ESE.rsp




Successfully installed or copied the required files .



Need to make sure the following once the installation finished

  1. DB2 Users and Groups
    1. As we have enabled the DB2 security , need to make sure that all users ids(all users ids that interact with db2) are members of "DB2ADMNS" or "DB2USERS" group.
  2. DB2 Installation Validation
    1. Optionally to validate the DB2 installation files , instance and database functionality,  run the " C:\IBM\DB2\bin\db2val.exe"
    2. Make sure run as administrator (if using the different user other than db2admin)
C:\IBM\DB2\BIN>db2val

DBI1379I  The db2val command is running. This can take several minutes.
DBI1333I  Installation file validation for the DB2 copy DB2COPY1 was successful.
DBI1337I  The partitioned database environment validation for the instance DB2 was successful.
DBI1339I  The instance validation for the instance DB2 was successful.
DBI1343I  The db2val command completed successfully. For details, see
      the log file C:\Users\Siva\DOCUME~1\DB2LOG\db2val-Wed Mar 06 17_03_21 2012.log.

  1. Check the response file for any exception during the installation (C:\Users\Siva\Documents\PROD_ESE.rsp)
  2. Install DB2 License ( import db2ese_o.lic file)


References
  1. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.wn.doc/doc/c0052035.html

No comments:

Post a Comment