DB2 - IBM DB2 at UW (a mini-tutorial) David Toman School of...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: IBM DB2 at UW (a mini-tutorial) David Toman School of Computer Science University of Waterloo David Toman (University of Waterloo) IBM DB2 at UW 1 / 13 DB2: what is it? DB2 is a relational DBMS and a set of tools: a command-line interface to SQL an ESQL preprocessor for C language This tutorial covers (briefly): How do I run it? Useful hints What if something goes wrong? DB2 documentation: will be available on-line from the course web page David Toman (University of Waterloo) IBM DB2 at UW 2 / 13 First Steps DB2 is only available on rees your environment should be set up correctly: sh , bash , et al: rees$ source ~db2cs348/sqllib/db2profile csh , tcsh , et al: rees$ source ~db2cs348/sqllib/db2cshrc you dont need any DB2 password Every CS348 student must have a UNIX account on rees . David Toman (University of Waterloo) IBM DB2 at UW 3 / 13 First Steps (example) softbase.cs$ rlogin rees Last login: softbase.cs.uwat (pts/58) Sun Jul 27 07:04:22 2008 [...] rees$ source ~db2cs348/sqllib/db2profile rees$ db2 (c) Copyright IBM Corporation 1993,2001 Command Line Processor for DB2 SDK 7.2.0 [...] For more detailed help, refer to the Online Reference Manual. db2 => David Toman (University of Waterloo) IBM DB2 at UW 4 / 13 Commecting to a Database db2 => connect to cs348 Database Connection Information Database server = DB2/SUN 7.2.0 SQL authorization ID = DAVID Local database alias = CS348 db2 => cs348 is the name of a database managed by DB2 for this class David Toman (University of Waterloo) IBM DB2 at UW 5 / 13 Executing Queries SQL statements can be entered directly at the db2 => prompt....
View Full Document

This note was uploaded on 05/28/2011 for the course CS 338 taught by Professor I.i during the Winter '09 term at Waterloo.

Page1 / 13

DB2 - IBM DB2 at UW (a mini-tutorial) David Toman School of...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online