Results 1 to 4 of 4

Thread: db config file

  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Unanswered: db config file

    When I change the database configuration and db manager config in db2 where are they stored? are they stored in some files. Suppose I shift the database to anothar machine or I restore the database from a backup, do I have to tune all the db and dbm config parameters all over again
    ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You'll have to reconfigure the instance/database .. You cannot copy the config files from one db/instance to another ...

    When you build a new db/instance, remember to copy the db2 registry variables (db2set -all) also across ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2003
    Posts
    35
    The values that we change must be physically stored somewher onthe db server.Where is the physical location of this configuration file ?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The configuration parameters and registry variables that affect the DB2 query optimizer can be extracted with db2llook -f option.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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