Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    77

    Unanswered: How to get most objects with db2look

    DB2 11.1 WSE for LUW
    Windows Server 2012

    I want to know which parameters yield the best results for db2look.
    I am using now
    Code:
    db2look -d db_name -createdb -printdbcfg -a -e -l -x -c -f -td !
    What can I add?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,540
    Provided Answers: 11
    just to say : it depends on what you need
    you can specify all settings or limit yourself to what is needed
    -e -l -x -o is in most cases enough (even -x can be skipped if grants are not needed)
    see infocenter for options of db2look and pick the ones needed...
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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