DB2 – UDB Basic Commands – PPT

 DBA JOBS USA

Db2 is available in different flavors:

  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:

DB2UDB_the_Basics

  • 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’)
Advertisements

Author: Srini

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