Db2

 View Only

  • 1.  db cfg changes

    Posted Tue May 02, 2023 09:17 AM

    db2 11.5.7 on redhat
    is there a command - tool that could show the dbcfg settings that are not the default
    so we can see what has changed



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------


  • 2.  RE: db cfg changes

    IBM Champion
    Posted Tue May 02, 2023 03:25 PM

    1. Long way:

    Browse Db2 Infocentre and note default values for database configuration. Compare with current values.

    2. Shorter way:

    a) save current database configuration in db2_current.cfg

    b) reset database configuration

    c) save new database configuration in db2_reset.cfg

    d) Diff both .cfg files



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 3.  RE: db cfg changes

    Posted Wed May 03, 2023 01:25 AM

    Best way I've found is to "db2 reset db cfg for sample" then use "select * from sysibmadm.dbcfg with ur;" to get the defaults.  Still needs work as there are parameters that are managed by the database that you need to eliminate




    ------------------------------
    Regards Robert Clow
    ------------------------------

    Original Message


  • 4.  RE: db cfg changes

    Posted Wed May 03, 2023 02:32 AM

    thanks for the update

    I created a sample db and compared with diff the current db cfg

    Many thanks..

    --
    Best Regards, ????????Beste Groeten, ???????? Meilleures Salutations
    Guy Przytula
    ??
    Tel. GSM??: +32 (0)475-33.81.86

    Email : Guy Przytula



    Original Message


  • 5.  RE: db cfg changes

    IBM Champion
    Posted Wed May 03, 2023 08:08 AM

    But keep in mind that when you create a new database - not all default settings are being applied - during creation of a new database some heuristic tuning takes place based on your current environment.

    Best approach is:

    • for a given environment (OS, hardware configuration etc):
      - create an empty database - called it an EMPTY. 
      - Save DBM and DB configuration in files dbm_create.cfg and db_create.cfg
      - reset DB and DBM cfg
      - save them as dbm_reset.cfg and db_reset.cfg
    • Now you have some settings you can refer to
      - DBM.CFG for your environment
      - DB.CFG for your renvironment
      - DBM.CFG default configuration
      - DB.CFG default configuration
    • Remember that when restoring database you restore settings as stored in your backup



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


  • 6.  RE: db cfg changes

    Posted Thu May 04, 2023 09:34 AM

    Hello I'm interested in the future please



    ------------------------------
    Sajid Sajid
    ------------------------------

    Original Message


  • 7.  RE: db cfg changes

    IBM Champion
    Posted Thu May 04, 2023 10:07 AM

    I am also interested in the future - specially in the winning lottery tickets



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message