db2 instances

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…

Deactivate a Database The “deactivate db” command is used to stop the database services. Syntax: db2 deactivate db Here, db_name specifies the…

DB2 RazorSQL Drop Table This is used to delete the total tables in a schemas. Next TopicExport Data

DB2 RazorSQL View Contents (Limit Results) View Contents limit result is used to see limited results only. You can see first 10…

Drop Bufferpool You can drop a bufferpool by using “drop bufferpool” command. It is suggested to check if any tablespace is assigned…

DB2 RazorSQL Drop The Drop command is used to delete tables from databases and different schemas. Let’s drop the table “STUDENTS” from…

DB2 RazorSQL View A view is used to define an alternative way of representing the data stored in a table. A view…

Drop Database The drop database command is used to remove your database from instant database directory. It will delete all its objects,…

DB2 RazorSQL Edit Edit is used to see the complete table . It also facilitates you to edit the records within the…