====== DB2 Fixpack installation ======
**Offline backup of all databases **

**Backup configuration of Database manager and all Databases :**
<sxh bash>
db2 get dbm cfg > dbm_cfg.txt
db2set -all > db2set_all.txt
db2licm -l > db2licm.txt
db2level > db2level.txt
db2cfexp directory.txt backup
db2greg -dump -v > db2greg.txt
for db in `db2 list db directory | grep -p Indirect | grep alias | awk '{print $NF}'`; do db2look -d ${db} -td @ -a -e -x -l -o ddl_${db}.txt; db2 get db cfg for ${db} > dbcfg_${db}.txt; done
</sxh>

**Check invalid objects :**
<sxh bash>
db2 "select substr(objectschema,1,20) SCHEMA, substr(objectname,1,70) OBJECT, case objecttype when 'B' then 'Trigger' when 'F' then 'Routine' when 'R' then 'User datatype' when 'V' then 'View' when 'v' then 'Global var' when 'y' then 'Row perm.' when 2 then 'Col. mask' when 3 then 'Usage list' end as Type from syscat.invalidobjects with ur"
</sxh>

**Take full backup of all databases**

** Stop all instances and associated services : **
<sxh bash>
su - <instance>
db2stop

initctl stop db2fmcd
</sxh>

** Rotate db2diag log : **
<sxh bash>
db2diag -A
</sxh>

** Stop DAS (if exists & running) :**
<sxh bash>
su - <dasuser>
db2admin stop
</sxh>

**Stop Fault monitor :**
<sxh bash>
<DB2DIR>/bin/db2fm -i <DB2INSTANCE> -D
</sxh>

**Clean IPC : **
<sxh bash>
<DB2INSTANCEHOME>/sqllib/bin/ipclean
</sxh>

**Check if there aren't any libraries still loaded :**
<sxh bash>
<INSTALL_PATH>/instance/db2prechk -b -d;echo $? 

#AIX 
/usr/bin/genld -l | grep -p db2

#Linux
lsof +D <DB2DIR>
</sxh>

**Install the fixpack :**
<sxh bash>
</path/to/fixpack>/installFixpack -b <DB2DIR>
</sxh>

**Update the DB catalogs (all Indirect databases !) :**
<sxh bash>
db2updv9 -d <DBNAME> (9.1)
db2updv97 -d <DBNAME> (9.7)
db2updv10 -d <DBNAME> (10.x)
</sxh>

In case of errors, rebind the packages :
<sxh bash>
db2 connect to databasename
db2 bind sqllib/bnd/@db2cli.lst blocking all grant public sqlerror continue
db2 bind sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue
db2 bind sqllib/bnd/@db2ubind.lst blocking all sqlerror continue grant public
db2 commit
db2 terminate

#or 

db2rbind <DBNAME> -l </path/to/logfile> all 
</sxh>

**Check for inconsistent System catalog :**
<sxh sql>
db2 "SELECT TABSCHEMA, TABNAME 
FROM   SYSCAT.DATAPARTITIONS
WHERE  INDEX_TBSPACEID  = 0          AND 
       TBSPACEID       IS NOT NULL   AND
       TABSCHEMA NOT IN ('SYSIBM', 'SYSCAT', 'SYSSTAT',
                         'SYSIBMADM', 'SYSCATV82')
GROUP BY (TABSCHEMA, TABNAME)"

# run db2updv97 -d <DBNAME> -i 
</sxh>

**Check again invalid objects and try to recompile them :**
<sxh bash>
db2 "select substr(objectschema,1,20) SCHEMA, substr(objectname,1,70) OBJECT, case objecttype when 'B' then 'Trigger' when 'F' then 'Routine' when 'R' then 'User datatype' when 'V' then 'View' when 'v' then 'Global var' when 'y' then 'Row perm.' when 2 then 'Col. mask' when 3 then 'Usage list' end as Type from syscat.invalidobjects with ur"
</sxh>

**Recompile invalid objects :**
<sxh bash>
db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()"
</sxh>

**Post-fixpack script :**
<sxh bash>
#!/bin/ksh


echo "[`date`] POST-FIXPACK ACTIONS STARTED !"

# BIND & RECOMPILE
for db in `db2 list db directory | grep -p Indirect | grep alias | awk '{print $NF}'`
do

echo "[`date`] UPDATING DB ${db} TO LATEST FIXPACK :"
db2updv97 -d ${db}

echo "------------------------"

echo "[`date`] REBINDING DB ${db} :"
db2 connect to ${db}
db2 bind ~/sqllib/bnd/@db2cli.lst blocking all grant public sqlerror continue
db2 bind ~/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue
db2 bind ~/sqllib/bnd/@db2ubind.lst blocking all sqlerror continue grant public
db2 commit
db2 terminate

db2 connect to ${db}
db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS()"
db2 "select substr(objectschema,1,20) SCHEMA, substr(objectname,1,70) OBJECT, case objecttype when 'B' then 'Trigger' when 'F' then 'Routine' when 'R' then 'User datatype' when 'V' then 'View' when 'v' then 'Global var' when 'y' then 'Row perm.' when 2 then 'Col. mask' when 3 then 'Usage list' end as Type from syscat.invalidobjects with ur"
db2 terminate

db2rbind ${db} -l ./rebind_${db}.log all
echo "------------------------"
done

echo "[`date`] POST-FIXPACK ACTIONS FINISHED !"
</sxh>