Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Applying a Fixpack - Do we need migration of DB

    Hi Guys,

    DB2 V9.1.3 on Win 2k3 Server

    I need to apply Fixpack 9.5 FP 3b on existing 9.1. FP3

    Will the database need MIGRATION ??

    Last time I upgraded same size DB from 8.2 to 9.5 FP 3b, it took 40 mins to migrate DB (216GB).

    Will it be same or much less b/c major ver is 9.

    Thanks in advance. Not enough time to test. An emergency situation.

    DBFinder

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The migration will only take a minute or less from 9.5.3 to 9.5.3b (it will not actually change anything and is not necessary).

    From 8.2 to 9.5 I beleive that DB2 had to change the page layouts of the data and indexes.
    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
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by DBFinder
    Not enough time to test. An emergency situation.
    And how do you know that it will solve your problem if you do not test it first?

    Or you are following the principal that by trowing enough sh%t at the wall, some will stick and fills the whole?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks Marcus

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by Cougar8000
    And how do you know that it will solve your problem if you do not test it first?

    Or you are following the principal that by trowing enough sh%t at the wall, some will stick and fills the whole?
    As per IBM software Support !!

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by Cougar8000
    sh%t at the wall
    People like to talk about this thing a lot. Not sure why ?

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by DBFinder
    As per IBM software Support !!
    I understand what you are saying, but does IBM have an inside link to your box and was able to test on YOUR system? If answer is No, then how can they or you guaranty that it will work? Or you are subscribing to the notion that IBM is always right?

    Sorry, maybe I am just a bit more old fashioned and like to check things first myself.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    No problem,
    This is good that you are saying -- A goo quality.

    IBM was responsible for crashes that we were havin for last 15 days.
    PMR !

    They have hot fix for same problem but for ver 9.5 fp 3b
    HotFix can be run after Fixpack upgrade.

    So the told this morning 3:30 am that this is the fastest way.
    since then I am trying to get a time window for testing on mirror. Did not get approval yet. Still I dare to do that.

    Marcus_A has relieved me confirming that migration does not take much time. Still this will be tested tonight at 12:00am if i do not get window during day.

    Thanks for your concern, please note that I did not have this much time to write even this much. Thanks to pepople who underrstand

    DBFinder

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by DBFinder
    Marcus_A has relieved me confirming that migration does not take much time. Still this will be tested tonight at 12:00am if i do not get window during day.
    There is really no need to migrate database if going from 3 to 3a.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Marcus_A
    There is really no need to migrate database if going from 3 to 3a.
    I think the author of the original post goes from 9.1.3 to 9.5.3, so I suspect some migration might be involved. However, if I were him I would be addressing this question to IBM support instead of asking a bunch of strangers on some web forum...
    ---
    "It does not work" is not a valid problem statement.

  11. #11
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by n_i
    I think the author of the original post goes from 9.1.3 to 9.5.3, so I suspect some migration might be involved. However, if I were him I would be addressing this question to IBM support instead of asking a bunch of strangers on some web forum...
    My mistake. I thought it was 9.5 for both. The fixpack instructions indicate whether the database migration program needs to be run depending on the release of the current instance. For some release upgrades the migration program changes the data and index page layouts, but usually it just adds some optional administrative stored procedures, views, etc.

    I would trust the doc more than a IBM support person on the phone.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  12. #12
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Marcus_A
    I would trust the doc more than a IBM support person on the phone.
    I feel your pain, but at the severity level where DBFinder apparently is, often the opposite is true...
    ---
    "It does not work" is not a valid problem statement.

  13. #13
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    My personal opinion is that I would also listen to the support guys, then check the manuals, then do at least some smoke screen testing (even better yet run some real test scenarios), before finally going into production - with anything. And since you had problems for 15 days already, the question is if you could live with the problems for a couple more days. If the fix doesn't work, I haven't lost anything. If it does work, you have some confidence that it doesn't break a whole lot else. It gives you some piece of mind; even if you consider that the IBM support folks do know very well what they are doing - at least L2/L3 support.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  14. #14
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by n_i
    I feel your pain, but at the severity level where DBFinder apparently is, often the opposite is true...
    If you ask an IBM support person, they will look at the fixpack install instructions. I would rather read it for myself.

    I have received several wrong answers from IBM support in the past, although I admit that I tend to only ask the tough questions.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  15. #15
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Finally

    There was migration involved. this was not long (12 mins for 216GB db).
    Don't worry guys I asked IBM guys, the answer came after real migration.
    I was really in tough situation. However my team did not stress me. They were working together.
    Everybody was fetching info as possible, Manager, CIO , and even Developers were asking db2 ques from their friends and other contacts.

Posting Permissions

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