Results 1 to 12 of 12
  1. #1
    Join Date
    Jun 2011
    Posts
    39

    Unanswered: Db2 9.7 Fixpack question

    I installed DB2 9.7 ESE on RHEL 5.6 Linux successfully

    I performed the validation and applied the license key, both successfully

    I wanted to install the fixpack, so I went to the folllowing site:

    https://www-304.ibm.com/support/docv...id=swg27007053

    (Note: This site does not specify either ESE or AESE)

    I selected 9.7, Fix pack 4, then on the next page Linux 64 bit, DB2 Server Fix Pack.

    I download the file, unzip and tar, and run db2setup, The GUI comes up in the X Window. The GUI says

    "DB2 Advance Enterprise Server Edition Version 9.7 Fix pack 4"

    I hit the "Work with eXISTING" BUTTON

    It brings up a screen that says

    Select the DB2 copy to work with

    Code:
    Installation Path                Action
    ------------------            -----------------
    /opt/ibm/db2/V9.7             Not available
    No other actions are allowed to be selected

    I highlight the /opt/ibm/db2/V9.7 line, but the "Launch DB2 Startup Wizard" button stays Greyed out.

    1> Is this happening because I am trying to install an AESE FP onto ESE ?

    2> If so, could someone please send me a link to where I can download an ESE FP of 9.7 for Linux ?

    3> If no, what should I do from this point ?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would run the installfixpack script from the command line instead of db2setup. Did you read the Fixpack Install instructions?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    1. No.
    2. N/A
    3. Show the output from db2level and db2licm -l. Make sure you are running as root and all DB2 processes are stopped before launching db2setup.

  4. #4
    Join Date
    Jun 2011
    Posts
    39
    Below is the validation:

    Code:
    [root@HX20-12 bin]# ./db2val
    DBI1379I  The db2val command is running. This can take several minutes.
    
    
    DBI1335I  Installation file validation for the DB2 copy installed at
          /opt/ibm/db2/V9.7 was successful.
    
    
    
    DBI1343I  The db2val command completed successfully. For details, see
          the log file /tmp/db2val-07_19_11:12:22.log.
    Below is the license install

    Code:
    [root@HX20-12 bin]# su - db2inst1
    [db2inst1@HX20-12 ~]$  db2licm -a /tmp/lic/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: "/opt/ibm/db2/V9.7/license/en_US.iso88591"
    I looked to see what processes were running:


    Code:
    [root@HX20-12 bin]# ps -ef | grep db2
    root     16197     1  0 11:18 pts/1    00:00:00 db2wdog 0                       
    db2inst1 16199 16197  1 11:18 pts/1    00:00:00 db2sysc 0                       
    root     16200 16199  0 11:18 pts/1    00:00:00 db2ckpwd 0                      
    root     16201 16199  0 11:18 pts/1    00:00:00 db2ckpwd 0                      
    root     16202 16199  0 11:18 pts/1    00:00:00 db2ckpwd 0                      
    db2inst1 16217 16197  0 11:18 pts/1    00:00:00 db2acd 0 ,0,0,0,1,0,0,0,1,0,8a65b0,14,1e014,2,0,1,11fc0,0x210000000,0x210000000,1600000,11c8011,2,e00014
    root     16245 10705  0 11:18 pts/1    00:00:00 grep db2
    dasusr1  26720     1  0 Jul18 ?        00:00:00 /home/dasusr1/das/adm/db2dasrrm
    root     27156     1  0 Jul18 ?        00:00:10 /opt/ibm/db2/V9.7/bin/db2fmcd
    dasusr1  27194     1  0 Jul18 ?        00:00:00 /opt/ibm/db2/V9.7/das/bin/db2fmd -i dasusr1 -m /opt/ibm/db2/V9.7/das/lib/libdb2dasgcf.so.1
    So I logged into db2inst1 and performed a db2stop

    THen I stopped the DAS as follows:

    Code:
    [root@HX20-12 bin]# su - db2usr1
    su: user db2usr1 does not exist
    [root@HX20-12 bin]# su - dasusr1
    [dasusr1@HX20-12 ~]$ . das/dasprofile
    [dasusr1@HX20-12 ~]$ db2admin stop
    SQL4407W  The DB2 Administration Server was stopped successfully.
    After that I went to see what processes were running:


    Code:
    [root@HX20-12 bin]# ps -ef | grep db2
    root     16492 10705  0 11:21 pts/1    00:00:00 grep db2
    root     27156     1  0 Jul18 ?        00:00:10 /opt/ibm/db2/V9.7/bin/db2fmcd
    dasusr1  27194     1  0 Jul18 ?        00:00:00 /opt/ibm/db2/V9.7/das/bin/db2fmd -i dasusr1 -m /opt/ibm/db2/V9.7/das/lib/libdb2dasgcf.so.1
    I do not know how to turn these processes off. What should I do from this point ?

    Thanks

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    As Marcus said, it's all in the manual.

    Applying fix packs - IBM DB2 9.7 for Linux, UNIX, and Windows

  6. #6
    Join Date
    Jun 2011
    Posts
    39
    I read the documentation, and completed all the steps to stop db2

    I stopped the instance:

    Code:
    [root@HX20-12 instance]# cd /opt/ibm/db2/V9.7/instance
    [root@HX20-12 instance]#
    [root@HX20-12 instance]# ./db2ilist
    db2inst1
    [root@HX20-12 instance]# su - db2inst1
    [db2inst1@HX20-12 ~]$ . sqllib/db2profile
    [db2inst1@HX20-12 ~]$ db2 force applications all
    DB20000I  The FORCE APPLICATION command completed successfully.
    DB21024I  This command is asynchronous and may not be effective immediately.
    
    [db2inst1@HX20-12 ~]$ db2 terminate
    DB20000I  The TERMINATE command completed successfully.
    [db2inst1@HX20-12 ~]$ db2stop
    07/19/2011 13:17:57     0   0   SQL1064N  DB2STOP processing was successful.
    SQL1064N  DB2STOP processing was successful.
    [db2inst1@HX20-12 ~]$ db2licd -end
    [db2inst1@HX20-12 ~]$ cd sqllib/bin
    [db2inst1@HX20-12 bin]$ ./ipclean
    ./ipclean: Removing DB2 engine and client's IPC resources for db2inst1.
    [db2inst1@HX20-12 bin]$ exit
    I stopped the DAS

    Code:
    [root@HX20-12 instance]#
    [root@HX20-12 instance]#
    [root@HX20-12 instance]# su - dasusr1
    [dasusr1@HX20-12 ~]$ . das/dasprofile
    [dasusr1@HX20-12 ~]$ db2admin stop
    SQL4407W  The DB2 Administration Server was stopped successfully.
    [dasusr1@HX20-12 ~]$ exit
    I checked the FMC:

    Code:
    [root@HX20-12 instance]# cd /opt/ibm/db2/V9.7/bin
    [root@HX20-12 bin]#
    [root@HX20-12 bin]# ./db2fmcu
    FMC: up: PID = 27156
    [root@HX20-12 bin]# cd /opt/ibm/db2/V9.7/instance
    [root@HX20-12 instance]# ./db2iset -i db2inst1 -all
    [i] DB2COMM=tcpip
    [g] DB2SYSTEM=HX20-12
    [g] DB2INSTDEF=db2inst1
    [g] DB2ADMINSERVER=dasusr1
    [root@HX20-12 instance]#
    However, I still have some db2 instances running:

    Code:
    [root@HX20-12 instance]# ps -ef | grep db2
    root     27156     1  0 Jul18 ?        00:00:11 /opt/ibm/db2/V9.7/bin/db2fmcd
    dasusr1  27194     1  0 Jul18 ?        00:00:00 /opt/ibm/db2/V9.7/das/bin/db2fmd -i dasusr1 -m /opt/ibm/db2/V9.7/das/lib/libdb2dasgcf.so.1
    root     29389 10705  0 13:23 pts/1    00:00:00 grep db2
    ....and I can not get the install to work, specifically, the "Launch" button referenced above is stilled greyed out

    DId I do any thing wrong

    What should I do from this point ?

  7. #7
    Join Date
    Jun 2011
    Posts
    39
    Any ideas what I should do Next ?

  8. #8
    Join Date
    Oct 2004
    Posts
    268
    Those are DB2 fault monitors. See instructions here to stop them.

    http://publib.boulder.ibm.com/infoce...c/t0024969.htm

    After that, go to directory where you have the fixpack files unpacked and enter the following command,

    ./installFixPack

    Now it will ask you where you installed the DB2 instance. Enter,

    /opt/ibm/db2/V9.7

    wait until the setup finishes. Make sure you have no errors. Follow up with post installation tasks.

    start the fault monitors you previously stopped.

    Calvin.
    Last edited by mdx34; 07-20-11 at 16:08.

  9. #9
    Join Date
    Jun 2011
    Posts
    39
    It works great

    Thanks

  10. #10
    Join Date
    Jun 2011
    Posts
    39
    The installation log said to go to the fixpack readme file to perform the post installation steps

    There are no read me files in the fixpack I downloaded (DB2 9.7 FP4). How can I determine the post installation steps ?

  11. #11
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Check step #4 in the link provided by n_i yesterday.

  12. #12
    Join Date
    Jun 2011
    Posts
    39
    The doc says:

    If the DB2 Administration Server (DAS) belongs to the DB2 copy where you installed the fix pack, issue the command:

    DB2DIR/instance/dasupdt
    How do I determine if the DAS belongs to the DB2 copy where I installed the FP ?

    (I only installed a single copy on a single machine) Can a DAS be on another machine ?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •