Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Exclamation Unanswered: Post fixpack upgradition

    DB2 8.1 FP 7
    Windows 2000

    we are planning to upgrade our servers to FP 14
    post installation i need to run bind for each DB
    i have to bind
    db2ubind.lst
    and
    db2schema.bnd
    does binding these two files would be sufficient or i have to bind others also ?? i am on *windows*
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You should read the readme/release notes, which explains the detailed steps that you have to perform as part of the FP install.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    When you are on windows platform, all those things are done automatically, because you can only have one verssion at a time installed on windows (unlike Linux or UNIX).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    [QUOTE=Marcus_A] because you can only have one verssion at a time QUOTE]
    i dont get that
    you can have 2 different copies(version ) on same server even on windows
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    With Version 9 you can have 2 different versions of DB2 on Windows, but not in version 8.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Correct, V9 allows multiple DB2 installations on the same Windows system. But that is completely irrelevant to the fact that FP installation procedures are all described in the README/release notes that accompany the FP.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    i upgraded 1 of my server successfully and bind files as given in readme.txt
    however i am having one confusion

    i was having a DB at FP 7
    i upgraded it to FP14, now when i run
    select procname from syscat.procedures where procschema='SYSPROC'
    it gives me 56 records.
    however a newly created DB at FP14 returns 58 records with new procedure like admin_cmd()

    Question:
    If after applying fixpack my existing DB will not recieve new Procedures present in FP14
    or
    only new DB will be having procedures like admin_cmd()??
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  8. #8
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    Did you also run the 'db2updv8' command?

  9. #9
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    thanks GertK
    now its ok.
    i was under wrong impression that 'db2updv8' is only used for upgrading from v7 to v8
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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