Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2009
    Posts
    18

    Unanswered: DB2 Slow Startup on RHEL

    Hey Guys,

    I've setup DB2 9.5 on RHEL 5.10 and it's autostart at boot time with instructions in the link below! Through db2fmcd
    IBM How to use fault monitors to automatically restart DB2 UDB instances - United States

    But the DB2 startup is very slow! DB2 starts 5 minutes after server boot...

  2. #2
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    check server might be busy initializing some other services and processes too besides db2sysc . only db2 is deployed on the server or something else is also consuming CPU there ? what is memory conf. for instance ? available memory?
    ssumit

  3. #3
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    what hardware-resources do you have CPUs and RAM and disks?
    What other application(s) or services are starting along with db2?
    Are you starting a single db2-instance or multiple db2-instances.

  4. #4
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Check whether there is any setup to shutdown database properly before OS shutdown. If database is not shutdown properly before OS shutdown, it will take time to startup due to recovery process.

    We use custom service for DB2 to start instance and activate database during OS start and deactivate database and stop instance before OS shutdown.

    Satya...

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by stiruvee View Post
    Check whether there is any setup to shutdown database properly before OS shutdown. If database is not shutdown properly before OS shutdown, it will take time to startup due to recovery process.
    Yes indeed, check your db2diag.log. And another thing: check the amount & size of your logprimary's (and the filesystem used for them).
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  6. #6
    Join Date
    Nov 2009
    Posts
    18
    This is a HP DL G6 server with 64GB RAM. This is a one instance DB2 9.5 Plus WAS!
    Based on what's written in the link in my first post there is nothing about shutting down DB2 before server shutdown!

    Quote Originally Posted by stiruvee View Post
    We use custom service for DB2 to start instance and activate database during OS start and deactivate database and stop instance before OS shutdown.

    Satya...
    Do you mind sharing it with us? And do you activate db2fmcd beside your script?

  7. #7
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    5 minutes is too long, I do have fmcd configured (with WAS and HTTP on same server) but its always works correctly. OS is RHEL 6. Certainly there is some hindrance from WAS.

    Sometime some bg processes related to WAS java cause upto 100% cpu utilization, in that case DB2 also goes slow.

    thanks
    sumit
    ssumit

  8. #8
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Quote Originally Posted by OSSGeek View Post

    Do you mind sharing it with us? And do you activate db2fmcd beside your script?
    see the attachement. We use db2fmcd to restart instance in case of db2 crash (never happenned, so do not know whether it works or not). We do not use db2iauto, our custom service takes care of starting instance during OS startup.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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