Scribd
Upload
25 views1 page

db2 Intro Commands, Backp and Restore

This document provides instructions for backing up and restoring a database called "meer" in DB2. It includes commands to create and activate the database, backup the data, restore from backup, and deactivate or drop the database. The summary outlines the key steps of creating a database, taking an offline backup, restoring from that backup, and reconnecting to the database.

Uploaded by

MeerShahrukh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
25 views1 page

db2 Intro Commands, Backp and Restore

This document provides instructions for backing up and restoring a database called "meer" in DB2. It includes commands to create and activate the database, backup the data, restore from backup, and deactivate or drop the database. The summary outlines the key steps of creating a database, taking an offline backup, restoring from that backup, and reconnecting to the database.

Uploaded by

MeerShahrukh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

From Mir Shahrukh BurkiTechmate

1. #create database meer


- This is a comment indicating the intention to create a database.
2. #activate database meer
- Another comment, suggesting the activation of a database.
3. #connect to database meer
- Yet another comment, indicating the intention to connect to a database.

4. #create and insert into table


-creation of tables and inserting data into them

5. offline backup

6. ~db2 terminate`
- This command terminates any active DB2 command line sessions.

7. ~db2 force application`


- This command forces the termination of applications connected to the database,
following for a clean shutdown.

8. ~db2 deactivate database <db_name>`


- This command deactivates a specified database, preparing it for backup.

9. ~db2 backup database test tp /u01/db2_bkp/`


- This command initiates the backup of the specified database ("test") to the
directory "/u01/db2_bkp/".

10. ~db2 drop database <db_name>`


- ~db2 drop database <db_name>", this command drops the specified database.

11. ~db2 restore database <meer<db_name> from /u01/db2_bkp/ taken at <timestamp>`


- This command restores a backup of a database with the specified name ("meer")
from the directory "/u01/db2_bkp/" and at a specific timestamp.

12. ~db2 activate database <db_name>`


- This command activates the specified database after a restore operation.

13. ~db2 connect to meer<db_name>`


- This command connects to the "meer" database.

14. ~db2 list tables.`


- This appears to be a partial command or a typo. The correct command might be
"~db2 list tables" to list the tables in the connected database.

15. ~db2 terminate`


- Terminates any active DB2 command line processor sessions.

16. ~db2 force application all`


- Forces the termination of all applications connected to the database.

17. ~db2 deactivate db <db_name>`


- Deactivates the specified database.

18. ~db2 drop datbase <db_name>`


This command drops the specified database.

You might also like