Sometimes DBA or Developer need to import huge number of data in database in bulk which is difficult if foreign key constraint is enable in schema which create conflict between...

Database restore can very fast through below shell script which is more easier then enter manually all commands. Note : Modify location of backup, email address, database name as per...

Database backup can take through below shell script which is more easier then enter manually command. Note : Modify location of backup & email address as per requirement in script....

After restore the database sometimes face error during the connect the database. SQL1117N A connection to or activation of database   "<DBNAME>" cannot be made because of         ...

Some application need multiple databases for different module to vary purpose so DBA created multiple database on same server and it's very difficult to identify difference between the databases because...

Developer develop script for db2 which is sometimes take huge load so need to take necessary action which is tuned the script. For tuning purpose DBA has to generate the...

In DB2 offline database backup can be taken through below command  $db2 backup database <database name> Backup successful. The timestamp for this backup image is : <snapshot id> In DB2...