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

    Basic DB2 commands

    Hi all,

    Does anyone have list of basic DB2 commands which are essential on day to day basic for a DBA.

    Thanks in advance,
    jfkuser

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,649

    Re: Basic DB2 commands

    Command Reference is my bible for commands ...

    db2 ? <command>

    gives you the syntax on the command line
    Eg:

    db2 ? restore

    Cheers
    Sathyaram
    Originally posted by jfkuser
    Hi all,

    Does anyone have list of basic DB2 commands which are essential on day to day basic for a DBA.

    Thanks in advance,
    jfkuser
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Posts
    369

    some useful db2 commands as a dba

    I use the following quite a bit as a DB2 DBA:

    list database and database manager parameters:
    ==================================
    db2 get db cfg for database
    db2 get dbm cfg

    list applications running on system:
    ============================
    db2 list applications

    show tablespaces
    ============================
    db2 list tablespaces

    cat /home/db2inst/sqllib/db2dump/db2diag.log
    shows error log output for db2

    db2 list history
    quite useful

    db2cc starts the control center tool


    this should get you started
    I recommend the DB2 manuals or any of the good DB2 DBA books

  4. #4
    Join Date
    Jan 2003
    Location
    Schaumburg, IL
    Posts
    79
    You may want to go through the v7-dbacert.pdf on the http://redbooks.ibm.com.

    This is a PDF for getting dba certification on UDB for version 7. I am suggesting this book b'cos it considers you are new to UDB and teaches you from ground up.

    Naveen.
    Naveen Urs
    DBA Manager
    IBM Certified Solutions Expert - DB2 LUW V7, V9

  5. #5
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141

    Re: Basic DB2 commands

    You can get a quick reference for DB2 on the following adress:
    http://www7b.software.ibm.com/dmdd/l.../0211yip2.html

    HTH.
    Rodney Krick

  6. #6
    Join Date
    Jun 2007
    Posts
    66
    Found this good one for commands.. Although it does not have full list of commands looks like it is growing slowly

    www.db2commands.net

  7. #7
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

Posting Permissions

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