Description of the correct procedure for getting started with DB2

Using with Instances and Databases) the correct operation process. If you are interested in the correct operation process of the DB2 getting started Experiment Working with Instances and Databases, it will be of great help in future studies or work.

Working, Databases, Instances, getting started, Experiment Working, Databases, Instances, DB2 getting started, experiment

Follow these steps to use db 2 express 9

 
 

  
  
DB2 Migration Workshop  
  
  
LAB 1 – Working with Instances and Databases (Solution)  
  
  
Expected duration: 45 mins  
  
  
This lab will help you solidify concepts of instances and databases. It is to be completed BEFORE the presentation “DB2 Instances and Databases”.  
  
  
The following commands are demonstrated:  
  
  
DB2icrt ACTIVATE DB FORCE APPLICATION  
  
  
DB2idrop DEACTIVATE DB GET CONNECTION STATE  
  
  
DB2ilist CONNECT LIST APPLICATIONS  
  
  
DB2start CONNECT RESET LIST DB DIRECTORY  
  
  
DB2stop CREATE DATABASE LIST TABLES  
  
  
DB2admin start DROP DATABASE   
  
  
DB2admin stop DESCRIBE TABLE   
  
  
Prerequisites:  
  
  
· DB2 Version 8 Server has been installed  
  
  
Highly Recommended: Before each step in this lab, locate the demonstrated command in the CLP quick reference and mark it with an asterix (*).   
  
  
This will help you get familiar with the DB2 CLP cheat sheet.  
  
  
Note: On Linux/UNIX, you can switch users (su) without logging out by using:  
  
  
su – .. to switch to root user (dash is important!)  
  
  
su – [userid] .. to switch to non-root user (dash is important!)  
  
  
exit .. to exit switch back  
 
 

1. Windows: Launch the DB2 Command Window. Start the Command line Window of DB2)

In this experiment, I used the DB2admin account automatically created during the installation of DB2 express 9)

 
 

  
  
Start> Programs> IBM DB2> Command Line Tools> Command Window
  
  
(Or simply, DB2cmd)
  
  
Linux: Login to the operating system as user DB2inst1linux, you need to use DB2inst1 for Login)
  
  
 
 
 

2. When DB2 is installed, no database exists. Create the SAMPLE database provided by DB2.

 
 

  
  
DB2sampl 
 
 

In DB2 express9, the database already exists)

3. Verify that a database now exists. Show the contents of the database directory:

Show all database commands

 
 

  
  
DB2 list db directory
  
  
Fill in the following information from the database directory:
  
  
Database alias SAMPLE
  
  
Directory entry type Indirect Directory entry type: Indirect)
 
 

4. DB2 does not have database users. instead, DB2 uses userIDs and passwords defined at the operating system (or network authentication facilities) to authenticate users. connect to the SAMPLE database using the userID logged into the operating system.

It seems that DB2 9 has been able to automatically create a system account as its own database account.

Connect to database simple:

 
 

  
  
DB2 connect to sample 
 
 

5. See all connections that currently exist for the current instance

Display All the DB2 entry-level applications running on the current database instance

 
 

  
  
DB2 list applications  
  
  
Fill in the following information:  
  
  
Application name: DB2bp.exe  
  
  
Application handle: 2 (your answer may vary)  
  
  
Database name: SAMPLE  
 
 

6. Disconnect from the database:

Disconnect

 
 

  
  
DB2 connect reset 
 
 

7. Connect to the SAMPLE database using a specific userID and password.

 
 

  
  
DB2 connect to sample user <userid> using <password> 
 
 

8. View the tables that currently exist in the SAMPLE database

 
 

  
  
DB2 list tables: displays the tables created by the user)
  
  
Or
  
  
DB2 list tables for all show all tables including user and System)
 
 

9. From the output of list tables, you shocould see that a table called EMPLOYEE exists. Find out the structure of EMPLOYEE

 
 

  
  
DB2 describe table employee does not exist)
  
  
What is the maximum length of JOB column? 8 characters
  
  
What is the data type for the Salary Column? DECIMAL (9, 2)
  
  
The above two questions are indented to show how data type lengths from the output
Describe table are interpreted differently for numeric and character types.
 
 

10. Attempt to stop the instance. You shocould get an error because connections still exist.

 
 

  
  
DB2stop  
  
  
What is the SQLCODE associated with the error message? SQL1025N  
 
 

11. To stop the instance, we have to get rid of the current connections. In this step, forcibly disconnect all applications.

 
 

  
  
DB2 force applications all  
  
  
DB2stop  
  
  
note: you can also force applications by application handle using:  
  
  
force application ( 
 

12. By using force application, you have terminated your own connection. Attempt to SELECT from the employee table.

 
 

  
  
DB2 “select * from employee”  
  
  
You should get the error code SQL1224N. Check your connection state.  
 
 

Get connection status

 
 

  
  
DB2 get connection state 
 
 

Can be connected and has been closed. The above content is an introduction to the DB2 getting started Experiment Working with Instances and Databases. I hope you will gain some benefits.