Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: how to copy dbm cfg parameters?

    If I created a new instance and want to have dbm cfg parameters same as of other instances, how to I do it? Or to update every parameter one by one is the only way?

    Thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    AFAIK, that is the only way.
    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
    Dec 2008
    Posts
    59
    hope that will help you...
    Code:
    mysql> CREATE TABLE demo(id_no INTEGER NOT NULL PRIMARY KEY,val DECIMAL(10,2));
    Code:
    mysql> INSERT INTO demo VALUES (5,200.00),(6,100.00),(5,000.00),(5,700.00),(2,100.00);

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by hkp819
    hope that will help you...
    I think you have had one too many beers.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No, I think he has no clue what DB2 dbm cfg parameters are.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I have to agree with Marcus on this one ... Have a look at his other response:

    http://www.dbforums.com/db2/1637804-...ement-db2.html



    Quote Originally Posted by stolze
    No, I think he has no clue what DB2 dbm cfg parameters are.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    No, I think he's on the wrong forum

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Marcus_A
    AFAIK, that is the only way.
    "db2look -f" retrieves _some_ instance configuration parameters. Also, Configuration Assistant can be used to export and import DBM configuration.
    ---
    "It does not work" is not a valid problem statement.

  9. #9
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thank you, gentleman
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Take a look at db2cfexp and db2cfimp. For example;

    db2cfexp <output file name> backup -> this will export your config info
    db2cfimp <output file name> -> this will import your config info

    db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.

  11. #11
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2girl
    Take a look at db2cfexp and db2cfimp. For example;

    db2cfexp <output file name> backup -> this will export your config info
    db2cfimp <output file name> -> this will import your config info

    db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.
    I thought that program is for exporting the client config, and not the server config?
    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
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I use it on the server (ie. prior to dropping/recreating the instance). Here is an example:

    db2cfexp db2cfexpt.out backup

    From db2cfexpt.out:

    [DBM_CONFIG]
    NODETYPE=3
    RELEASE=0xa00
    DIAGLEVEL=3
    RQRIOBLK=32767
    DOS_RQRIOBLK=0
    AUTHENTICATION=0
    DIR_CACHE=1
    DISCOVER=2
    TP_MON_NAME=
    DIAGPATH=
    SYSADM_GROUP=BUILD
    SYSCTRL_GROUP=
    SYSMAINT_GROUP=
    SYSMON_GROUP=
    TM_DATABASE=1ST_CONN
    .....

  13. #13
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by db2girl
    Take a look at db2cfexp and db2cfimp. For example;

    db2cfexp <output file name> backup -> this will export your config info
    db2cfimp <output file name> -> this will import your config info

    db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.
    So should I remove params I don't want to change in the destination instance cfg and then import?

    I noticed some params are not there/do not get exported (e.g., JDK_PATH, DIAGPATH). And there is database info I don't need. So I just remove those lines from export file?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  14. #14
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Yes, you can edit the file to remove what you don't need. some dbm cfg parameters are NULL by default so they won't contain any value. diagpath is one of them.
    Last edited by db2girl; 02-06-09 at 15:51.

  15. #15
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    thanks, dear
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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