Personal tools
You are here: Home DB2 How To's Shell script to rebuild an entire database.
Navigation
Log in


Forgot your password?
 
Document Actions

Shell script to rebuild an entire database.

The script creates a tar files with the export output and the necessary loads command.

Example:

Our environment:

db name: DAN_PROD


Run the rebuiddb.ksh script on the source server like:

./rebuiddb.ksh dan_prod

 

A tar file will be created:

file name has the following syntax:  <db name>._rebuild.tar.gz

In this case the file name will be: dan_prod_rebuild.tar.gz

 

 

Move this files to the target server, uncompress it and run the following script like:

script name syntax: <db name>.rebuld_onTarget.ksh

In this case the script name will be: dan_prod.rebuld_onTarget.ksh

 

Run it as follow:

 

./dan_prod.rebuld_onTarget.ksh dan_prod

 

 

 

Note: When migrating a database to case insensitive ( for example, version v8 or v9.1 to v9.5 ) letters with accent will use the double of length. This script increase 30% of length to all char, varchar and character.

 

Script links:

Shell script to rebuild an entire database - part 1. 

Shell script to rebuild an entire database - part 2.

 

 

 

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls