drop bufferpool

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 Instance A DB2 instance is a logical Database Manager environment for DB2. It is used to manage databases. You can create…

DB2 RazorSQL Export Table DB2 Export utility is used to export the table data in the following different file format. DEL :…

DB2 Tutorial DB2 Tutorial provides basic and advanced concepts of DB2. Our DB2 Tutorial is designed for beginners and professionals both. DB2…

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…