DB2 UDB Top Commands List: PPT

The DB2 available is in various flavors. Here is a list

  1. DB2 Personal Edition
  2. DB2 UDB Express Edition
  3. DB2 UDB Workgroup Server Edition
  4.  DB2 Workgroup Server Unlimited Edition
  5. DB2 UDB Enterprise Server Edition
  6. DB2 UDB  Personal Developer Edition

DB2 UDB Commands

  • CREATE DATABASE  dbname  AS alias_name 
  • Describe table ARTISTS
  • IMPORT, EXPORT, and LOAD Commands
  • CREATE TABLESPACE TS1 MANAGED BY SYSTEM USING (‘C:\SMS\MUSICKEG\TS1’)

Read more:

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.