Results 1 to 9 of 9

Thread: Server Restart

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Server Restart

    Hi Experts,

    Do we need to restart server regularly .

    Our hosted team said they are going to reboot every 90 days as a best practice.

    I've searched the web but can't find anything definitive.

    Here is our Server info.

    DB2 v9.5.0.808, Fix Pack 0.

    Operating System Information:

    OSName: WIN32_NT
    Version: 5.1
    Release: Service Pack 3


    TIA

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    No. DB2 can operate 24x7. It is not a database issue, it might be an O.S. issue and then you're asking in the wrong forum.

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    Thanks dr_te_z ,

    I have not mentioned about any issues here.

    What happens if restarted server at frequent intervals?

    TIA

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The point is that you shouldn't have to restart the server. Why do you think this is "best practice"? I'd call it "worst practice"...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    To have to schedule rebooting the server at regular intervals is not a good thing for DB2. It is strictly for the OS, which in your case is Windows which does seem to need periodic rebooting due issues/inadequacies of the OS. When you reboot a server, all of the bufferpool and caches are lost and will have to be rebuilt. The worst thing is the package cache that has to be rebuilt and thus all dynamic SQL will need to be reoptimized and have access plans regenerated.

    I have had (non-windows) DB2 servers up and running for 6 months or more without incident and without having to reboot the server. The only down time is scheduled maintenance (applying fixpacks, OS upgrades, etc).

    Andy

  6. #6
    Join Date
    Jan 2009
    Posts
    153
    Hi Stolze,

    There should be some credible reason or points to prove that you are right.

    DO you have any link for the same?

  7. #7
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    It can be a memory leak prob. with O.S. / DB2 or someother Application.

    I recall we had a memory leak problem on windows with fixpak 8.2.something which was resolved after IBM provided with a fix in 8.2.something+1 release.
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  8. #8
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    If you do re-start you system from time-to-time and if you do have a maintenance window:
    take some time, between O.S.boot and DB2-instance-start, to defrag your filesystem, escpecially your tablespacecontainers. I recommend "contig.exe" by sysInternals for this.
    In that case DB2 also benefits.

  9. #9
    Join Date
    Oct 2009
    Posts
    1
    b back l8er, bro, :-)

Posting Permissions

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