DB2

- DB2 First steps

  • db2fs as user root

- Start / Stop DB2

  • Login as dasusr1 sudo su - dasusr1
  • db2admin [start | stop]

- Create an instance

  • db2

- Validate DB

  • db2level
  • db2licm -l
  • db2val as user db2inst1

- Run a script (file.sql)

  • db2 -tvf file.sql

- Sample SQL

  1. List Tables
    • db2 list tables for schema “EPAS”

* Back to Database

db2info.txt · Last modified: 2014/10/26 01:52 (external edit)
CC Attribution-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0