







Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
This course answers three main questions. Why do we use Databases? (Functionality provided by a DBMS. Models of databases: Network, Relational, OO.) How do we use a DBMS? (Relational model, logic-based query languages. SQL and dirty tricks. Embedding of query languages and applications. Relational Algebra and Query execution. Transactions and Recovery.) How do we design databases? Data Modeling: The Entity-Relationship model. Data anomalies and Normal forms. Basic physical design). IBM DB2 at UW
Typology: Slides
1 / 13
This page cannot be seen from the preview
Don't miss anything!
School of Computer Science University of Waterloo
softbase.cs$ rlogin rees Last login: softbase.cs.uwat (pts/58) Sun Jul 27 07:04:22 2008 [...] rees$ source ~db2cs348/sqllib/db2profile rees$ db (c) Copyright IBM Corporation 1993, Command Line Processor for DB2 SDK 7.2.
[...]
For more detailed help, refer to the Online Reference Manual.
db2 =>
db2 => connect to cs
Database Connection Information
Database server = DB2/SUN 7.2. SQL authorization ID = DAVID Local database alias = CS
db2 =>
db2 => list tables
Table/View Schema Type Creation time
ARTICLE DAVID T 2008-05-08-15.53. AUTHOR DAVID T 2008-05-08-15.53. BOOK DAVID T 2008-05-08-15.53. JOURNAL DAVID T 2008-05-08-15.53. PROCEEDINGS DAVID T 2008-05-08-15.53. PUBLICATION DAVID T 2008-05-08-15.53. WROTE DAVID T 2008-05-08-15.53. 7 record(s) selected.
db2 => list tables for all
Table/View Schema Type Creation time
ARTICLE DAVID T 2008-05-08-15.53. AUTHOR DAVID T 2008-05-08-15.53. COLCHECKS SYSCAT V 1999-09-10-10.55. ... SYSTABLES SYSIBM T 1999-09-10-10.55. ... SYSVIEWS SYSIBM T 1999-09-10-10.55. COLDIST SYSSTAT V 1999-09-10-10.55. COLUMNS SYSSTAT V 1999-09-10-10.55. FUNCTIONS SYSSTAT V 1999-09-10-10.55. INDEXES SYSSTAT V 1999-09-10-10.55. TABLES SYSSTAT V 1999-09-10-10.55.
146 record(s) selected.
db2 => blah blah DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0104N An unexpected token "blah" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "
db2 =>? DB21034E
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
Explanation: This message is displayed before the SQL error message. The error may be caused by a syntax error in a non-SQL command.
User Response: Correct the error and resubmit the command.
rees$ db2 list tables
Table/View Schema Type Creation time
ARTICLE DAVID T 2000-05-08-15.53. AUTHOR DAVID T 2000-05-08-15.53. BOOK DAVID T 2000-05-08-15.53. JOURNAL DAVID T 2000-05-08-15.53. PROCEEDINGS DAVID T 2000-05-08-15.53. PUBLICATION DAVID T 2000-05-08-15.53. WROTE DAVID T 2000-05-08-15.53.
7 record(s) selected.
rees$ ps -ef | grep db db2cs348 2799 1 0 Jun 14? 0:00 db2jd 50348 db2cs348 2746 2743 0 Jun 14? 0:00 db2sysc db2cs348 2748 2744 0 Jun 14? 0:00 db2sysc db2cs348 18696 2744 0 07:32:05? 0:00 db2sysc db2cs348 2743 2742 0 Jun 14? 0:00 db2sysc db2cs348 2745 2743 0 Jun 14? 0:00 db2sysc db2cs348 2747 2744 0 Jun 14? 0:00 db2sysc db2cs348 18694 2745 0 07:32:03? 0:01 db2sysc db2cs348 18697 2744 0 07:32:05? 0:00 db2sysc db2cs348 18695 2744 0 07:32:05? 0:00 db2sysc db2cs348 18699 2744 0 07:32:05? 0:00 db2sysc db2cs348 18700 2744 0 07:32:05? 0:00 db2sysc db2cs348 18698 2744 0 07:32:05? 0:00 db2sysc david 18693 1 0 07:30:47 pts/58 0:00 db2bp 18529 5