list tables

DB2 RazorSQL GUI DB2 is little bit complicated to use at command line. You can use it GUI by downloading RazorSQL. What…

DB2 Datatypes In DB2 Database tables, each column has its own data type depending on developer’s requirements. The data type is said…

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…

DB2 RazorSQL Copy The Copy option is used to copy your table into a new table. For example: Let’s copy thable “FRESHERS”…

DB2 RazorSQL QueryBuilder Open RazorSQL and then connect to the database. Now right click on the selected table. You will see query…