Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2011
    Posts
    27

    Red face Unanswered: performance delay between restored Database and fresh database

    i am using db2 database of level db2 v9.7.200.358
    Recently i found out that there is performance delay between standard database and restored database.
    what is the reason behind this?
    how can i improve restored database performance speed?
    Last edited by manuavaran; 02-24-12 at 02:46.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if the question/statement would be more specific it might be possible that someone would reply..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2011
    Posts
    27
    hi,
    sorry for the generalized question,let me be specific more.
    i created database in db2 using two methods
    1. Using IBM DB2 -> Command Line Tools ->command widow(admin).
    Executed the .bat file by typing the file name along with the database name and location where the datatbase is to be stored
    create_db.bat <Database_Name> <Location> <Location of .bat file>
    2. Using common database from backup - restore method
    the 2nd one generated is comparatively slow in performance.

    why this performance delay is occurring?
    how can i improve 2nd one's speed?

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    still no detail ..
    restored on same machine or other ?
    same resources on new machine ?? memory ? cpu ? disk ?
    is all slow ? how is this noticed ?
    all details can help
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    You are talking about the database fundaments:
    When you install a new database server and you create new bufferpools & tablespaces (that's what I call the fundament) and then use something like punching the ddl with "db2look" and populate you tables with "db2move". Yeah, you spend time and effort to create a fresh new database (when you set it up with codeset UTF-8 you are XML ready as well).

    And you compare that with a restore. If the source-database has a crappy/oldfashioned (SMS tablespaces and so on) fundament you will inherit that same fundament in your new server. You might notice that...

  6. #6
    Join Date
    Dec 2011
    Posts
    27
    The restored db was taken from another machine, with same configurations.
    Only the restored db is slow,standard one is working well.
    The delay is highly noticeable in restored one.

  7. #7
    Join Date
    May 2010
    Location
    India
    Posts
    84
    Provided Answers: 2
    Check for differences between two databases.
    * dbm configuration
    * db configuration

    Satya...

Posting Permissions

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