Common DB2 Commands

Build Library

Create db vipface using CodeSet UTF-8 on

Build library to specified location

Create Database  on D:using codeset GBK Territory CN

List all databases

Database Directory

Granting Dbadm permissions to users

Grant  on Database  to User Db2admin

command line execution SQL file

- -CF d:\1-2. Log

Connecting to a database

 to Vip

Export Database DDL

- - - -o D:\VIP_TABLE_DB2.sql

Query schema for all Tables production DROP statement

Select  '  '| | || '  ; '   from where tabschema='db2admin'

Common DB2 Commands