DB 2 Tutorial

DB2 RazorSQL Alter The Alter command is used to make a change in the table. For example: Add new column Add primary…

DB2 RazorSQL All Functionalities Open RazorSQL and click on the Tables folder. You will see all the created tables. Now click on…

Verify Bufferpools One bufferpool is automatically created at the time of database creation and one bufferpool we have created above. Now you…

DB2 RazorSQL Backup You can create a backup of the table by using RazorSQL tool. Right click on the table name and…

DB2 RazorSQL Generate DDL Generate DDL is used to create the SQL command which was used to create that table. You can…

Verify Databases Once you have run the create database command, you can check if the databases are created or not by using…

DB2 RazorSQL Compare Tool Compare Tool is used to compare to tables. Let’s take two tables “FRESHERS” and “STUDENTS” to compare. FRESHERS:…

DB2 RazorSQL Generate SQL Generate SQL is used to do operations like SELET, INSERT, UPDATE, DELETE and DELETE ALL. You can select…

What is DB2? DB2 is a database server developed by IBM. It is a Relational Database Management Syatem which is designed to…

Activate Database The “activate db” command is used to activate the database you have created once. It makes database available for the…