Tuesday 5 January 2016

In DB2 listing all the tables in a schema

Type db2cmd, connect to a database and type - db2 list tables for schema <name>

Creating a database in DB2

To create a database in DB2 you open a DB2 Command Line Processor using the command db2cmd, and enter the command - db2 create database <name> automatic storage yes