db2 database

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…

DB2 RazorSQL Copy to another Database It is used to copy the table in another database. For example: Copy the table “FRESHER”.…

Install DB2 Download DB2 Server trial version or purchase the product license from www.ibm.com Here you see two separate DB2 servers available…

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

DB2 RazorSQL Copy to Local Database You can copy one or more than one table local to a database. Next TopicDB2 Backup

DB2 RazorSQL Import Data Choose the location from where you want to import data. Let’s import “FRESHERS.XML” file. You can see that…

DB2 Bufferpools What is Bufferpool in DB2 In DB2, bufferpool is a part of main memory space which is allocated by the…