wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{::under_construction.jpg?150}}

Create a smple database, test connection, and delete (drop):
<cli prompt='$'>
[db2inst1@dev-tpc ~]$ db2sampl

  Creating database "SAMPLE"...
  Connecting to database "SAMPLE"...
  Creating tables and data in schema "DB2INST1"...
  Creating tables with XML columns and XML data in schema "DB2INST1"...

  'db2sampl' processing complete.
[db2inst1@dev-tpc ~]$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.4
 SQL authorization ID   = DB2INST1
 Local database alias   = SAMPLE

[db2inst1@dev-tpc ~]$ db2 "select * from staff where dept = 20"

ID     NAME      DEPT   JOB   YEARS  SALARY    COMM     
------ --------- ------ ----- ------ --------- ---------
    10 Sanders       20 Mgr        7  98357.50         -
    20 Pernal        20 Sales      8  78171.25    612.45
    80 James         20 Clerk      -  43504.60    128.20
   190 Sneider       20 Clerk      8  34252.75    126.50

  4 record(s) selected.

[db2inst1@dev-tpc ~]$ db2 list database directory show detail 

 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = SAMPLE
 Database name                        = SAMPLE
 Local database directory             = /home/db2inst1
 Database release level               = d.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

db2inst1@dev-tpc ~]$ db2 connect reset 
DB20000I  The SQL command completed successfully.
[db2inst1@dev-tpc ~]$ db2 drop database sample
DB20000I  The DROP DATABASE command completed successfully.
</cli>


To verify that the TPCDB database
  db2 list db directory
  
Are the tables and views present in the TPCDB database?\\
To verify that the tables and views are present, run the following DB2 commands:
  db2 connect to TPCDB
  db2 list tables for schema TPC
  db2 disconnect TPCDB
wiki

User Tools

Site Tools

Page Tools
