Integrando TSM com DB2

Para fazer backup do DB2 via TSM, basta instalar o TSM CLIENT compativel com a versão do Banco de Dados.

Apos a instalação deve-se:

--> Criar arquivos de log:

> /usr/tivoli/tsm/client/ba/bin/dsmsched_db2.log
> /usr/tivoli/tsm/client/ba/bin/dsmerror_db2.log

--> Dar as permissões:

Chmod 777 /usr/tivoli/tsm/client/ba/bin/dsmsched_db2.log
chmod 777 /usr/tivoli/tsm/client/ba/bin/dsmerror_db2.log


chmod 777 /usr/tivoli/tsm/client/ba/bin

--> Criar os links no api/bin ou api/bin64 (conforme o tipo do banco se for 32 Bits, a path é /usr/tivoli/tsm/client/api/bin)

ln -s /usr/tivoli/tsm/client/ba/bin/dsm.sys dsm.sys
ln -s /usr/tivoli/tsm/client/ba/bin/dsm_db2.opt dsm_db2.opt

--> Testar conexão com banco de dados

--> Informar as variaves do DBA responsavel:

DSMI_DIR=/usr/tivoli/tsm/client/api/bin64            
DSMI_LOG=/usr/tivoli/tsm/client/api/bin64            
DSMI_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm_db2.opt

CRIAR ARQUIVOS DSM.SYS e DSM.OPT


DSM.SYS

#################### BACKUP DB2 #########################################

SERVERNAME  NODENAME_DB2
   COMMMETHOD           TCPIP
   TCPPORT              1500
   TCPSERVERADDRESS     10.176.12.7
   TCPCLIENTADDRESS     10.176.13.75
   TCPCLIENTPORT        1501
   NODENAME             NODENAME_DB2
   PASSWORD             NODENAME_DB2
   SCHEDMODE            POLLING
   QUERYSCHEDPERIOD     1
   TCPWINDOWSIZE        512
   TCPNODELAY           YES
   TCPBUFFSIZE          32
   TXNBYTE              25600
   LARGECOMMBUFFERS     YES
   RESOURCEUTILIZATION  2
   SCHEDLOGRET          30,D
   ERRORLOGRET          30,D
   SCHEDLOGNAME         /usr/tivoli/tsm/client/ba/bin/dsmsched_db2.log
   ERRORLOGNAME         /usr/tivoli/tsm/client/ba/bin/dsmerror_db2.log
   CHANGINGRET          2
   RETRYP               20


DSM_DB2.OPT

 SErvername              NODENAME_db2
 archsymlinkasfile       no
 Followsymbolic          yes
 subdir                  yes






Para backup do DB2 no TSM server 03 coisas devem ser modificadas.

--> Criação do NODE: quando criar o node o mesmo deve estar com a opção BACKUPDEL YES

exemplo:

reg node NODENAME _DB2 NODENAME _DB2 do=PD_DB2 maxnummp=10 backdel=yes


--> Management Class

Para o backup ONLINE deve-se usar MGMT com copy group BACKUP com as opções de versão VERE=1 VERDE=0 RETE=1 RETO=0
Para o backup dos ARCHIVES deve-se usar MGMT com copy group ARCHIVE com a opção de retenção RETVER=NOLIMIT









Verificar backup's ativos no TSM (Esse comando é utilizado para testar a comunicação com o TSM

db2adutl query db DB

db2admq@hodb018rdc:/db2/db2admq # db2adutl query db ICH_QAS

Query for database ICH_QAS


Retrieving FULL DATABASE BACKUP information.
    1 Time: 20091204040051  Oldest log: S0000012.LOG  DB Partition Number: 0    Sessions: 2


Retrieving INCREMENTAL DATABASE BACKUP information.
  No INCREMENTAL DATABASE BACKUP images found for ICH_QAS


Retrieving DELTA DATABASE BACKUP information.
  No DELTA DATABASE BACKUP images found for ICH_QAS


Retrieving TABLESPACE BACKUP information.
  No TABLESPACE BACKUP images found for ICH_QAS


Retrieving INCREMENTAL TABLESPACE BACKUP information.
  No INCREMENTAL TABLESPACE BACKUP images found for ICH_QAS


Retrieving DELTA TABLESPACE BACKUP information.
  No DELTA TABLESPACE BACKUP images found for ICH_QAS


Retrieving LOAD COPY information.
  No LOAD COPY images found for ICH_QAS


Retrieving LOG ARCHIVE information.
   Log file: S0000012.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 2009-12-02-07.31.56
   Log file: S0000013.LOG, Chain Num: 0, DB Partition Number: 0, Taken at: 2009-12-03-07.30.13


Verificar bancos

db2 list applications

db2admd@hodb018rdc:/db2/db2admd # db2 list applications

Auth Id  Application    Appl.      Application Id                                                 DB       # of
         Name           Handle                                                                    Name    Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
ICHADM   db2jccMessageL 9808       P58391D0.P063.091204100140                                     ICH_DEV  1
ICHADM   db2jccMessageL 9862       P58391D0.P467.091204120240                                     ICH_DEV  1


Verificar Versão do Banco

db2level


db2admq@hodb018rdc:/db2/db2admq # db2level
DB21085I  Instance "db2admq" uses "64" bits and DB2 code release "SQL09054"
with level identifier "06050107".
Informational tokens are "DB2 v9.5.0.4", "s090429", "U825478", and Fix Pack
"4".
Product is installed at "/opt/IBM/db2/V9.5".


Verificar Configurações do banco

db2 get db cfg for NOMEDOBANCO


db2admq@hodb018rdc:/db2/db2admq # db2 get db cfg for ICH_QAS

       Database Configuration for Database ICH_QAS

 Database configuration release level                    = 0x0c00
 Database release level                                  = 0x0c00

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = IDENTITY

.......

Alterar para que o DB2 envie automaticamente os ARCHIVES para o TSM, a partir de alguma MGMT ja definida no TSM SERVER


hotpcdbbng[/home/db2inst1]hotpcdbbng[/home/db2inst1]  db2 update db cfg for GFA using LOGARCHMETH1 TSM:MC_RET_30
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.


(LOGARCHMETH1) = TSM:30D_DSK


Comandos de Backup

db2 backup db IBMCDB online use tsm open 1 sessions with 10 buffers buffer 16384 PARALLELISM 2 UTIL_IMPACT_PRIORITY 90 INCLUDE LOGS WITHOUT PROMPTING

db2 backup db IBMCDB online use TSM
##### tamanho do DB######

Verificar o TAMANHO do BANCO (BYTES)

db2 connect to DBNAME
db2 "call get_dbsize_info(?,?,?,-1 ) "


db2admq@hodb018rdc:/db2/db2admq # db2 connect to ICH_QAS

   Database Connection Information

 Database server        = DB2/AIX64 9.5.4
 SQL authorization ID   = DB2ADMQ
 Local database alias   = ICH_QAS

db2admq@hodb018rdc:/db2/db2admq # db2 "call get_dbsize_info(?,?,?,-1 ) "

  Value of output parameters
  --------------------------
  Parameter Name  : SNAPSHOTTIMESTAMP
  Parameter Value : 2009-12-04-09.26.20.055692

  Parameter Name  : DATABASESIZE
  Parameter Value : 105989541888

  Parameter Name  : DATABASECAPACITY
  Parameter Value : 207111782385