DB2 backup procedure

By -
The below script-let will backup the DB2 config , DB and DB Config by getting the DB names dynamically.

Here
<BACKUP_DIR> can be any folder where you want to place the backups.
<INSTANCE_NAME> is db instance name.

for DB_NAME in `db2 list db directory |grep -ip indirect |grep -i alias |awk '{print $4}'`
do
            echo "DB_NAME: ${DB_NAME}"
            db2 connect to ${DB_NAME}
            db2 backup database ${DB_NAME} to <BACKUP_DIR>
            db2 list tablespaces show detail > <BACKUP_DIR>/tablespaces.out
            db2 get db cfg for ${DB_NAME} show detail > <BACKUP_DIR>/dbcfg.out
            db2support <BACKUP_DIR> -d ${DB_NAME}
done
       
db2 force applications all
db2 terminate
db2stop
/home/${INSTANCE_NAME}/sqllib/bin/ipclean

db2set -all > <BACKUP_DIR>/db2set.out
set > <BACKUP_DIR>/set_env.out
env >> <BACKUP_DIR>/set_env.out
db2licm -l > <BACKUP_DIR>p/licm_level.out
db2level >> <BACKUP_DIR>/licm_level.out
db2 get dbm cfg show detail> <BACKUP_DIR>/dbmcfg.out
db2 list db directory > <BACKUP_DIR>/dbdirectory.out
db2 list node directory > <BACKUP_DIR>/dbnodedirectory.out
   



Comments

Post a Comment

Popular posts from this blog

Jenkins Dynmaic Parameter - List All Branches in a Git Repository

By -
The below code lists all the branches from a Git Repo as a drop down in jenkins. proc1 = ['/bin/bash', '-c', "git ls-remote -h ssh://ssh@<GitURL>/<projectkey>/<RepoName>.git"].execute() proc2 = ['/bin/bash', '-c', "awk '{print \$2}'"].execute() proc3 = ['/bin/bash', '-c', "sed s%^refs/heads%origin%"].execute() all = proc1 | proc2 | proc3 String result = all.text def values = result.tokenize() return values Steps to Add this code. 1. Login to Jenkins 2. Go to your Job Configuration 3. Select this Project is Parameterized 4. Select Active Choices Reactive Parameter 5. Click on Radio Button Groovy Script 6. Add the above code. 7.Save the Job. Examples: <GitURL> :  ssh://ssh@ bitbucket.com:7999 <projectkey>:  sm <RepoName>: MyTestRepo
Read more

JMSWMQ2013: The security authentication was not valid that was supplied for QueueManager 'XYZ' with connection mode 'Client' and host name 'x.x.x.x(1415)'. Please check if the supplied username and password are correct on the QueueManager to which you are connecting.

By -
Check the corresponding user has following permissions dspmq -t qmgr -m <QMGR_NAME> -p <USER> connect inq set altusr crt dlt chg dsp setid setall ctrl system If not set the authentication permissions by running the below command setmqaut -t qmgr -m <QMGR_NAME> -p <USER>  +connect +inq +set +altusr +crt +dlt +chg +dsp +setid +setall +ctrl +system
Read more