Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: db and dbm parameters

    We have built a QA server from production. Does anyone have script / document on how to sync db and dbf parameters of QA server with production. We want the db and dbm parameters same as Production.

    Thanks
    j

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: db and dbm parameters

    Originally posted by jfkuser
    Does anyone have script / document on how to sync db and dbf parameters of QA server with production.
    db2look does that (use "-f" switch).

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: db and dbm parameters

    -f switch captures parameters relevent to SQL optimization only (correct me if I'm wrong) ..

    Get the shells.zip from ftp://www.redbooks.ibm.com/redbooks/SG246012/

    There is a script(ksh) which is dependent on an awk script .. these scripts should do what you want

    It worked well with V7, but have not tried with V8 yet ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: db and dbm parameters

    Originally posted by sathyaram_s
    -f switch captures parameters relevent to SQL optimization only
    Well, I assumed that was the idea.

Posting Permissions

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