SHOW OPTIONS
Displays the active client options.
SHOW OPTTABLE
You can configure a client so it can get its option settings from either the client option file or from the server. This command will tell you which one is in use for this client.
SHOW SESSION
Displays capabilities that this client has for this connection to the server. The client and server report and negotiate the capabilities that each has when a session is started by a client to a server. This show command reports the capabilities available by this server and client.
SHOW TRACEFLAGS
Use this to determine which trace options could be used for this client.
SHOW VERSION
Use this command to find out what release and version of TSM is installed. Because (as you may have noticed) the TSM version info after running dmsc is from the server, not the client.
SHOW CLUSTER
Displays information about the disk mappings in a Windows or a Netware Cluster.
SHOW PLUGINS
If you want to use extra capabilities like image backup, then they are provided by 'plug-ins'. You use this command to find out what plug-ins are available for this client.
SHOW CACHE
TSM uses Subfile backups to backup only changed portions of files over slow network links. TSM knows what parts of a file have changed, by storing checksum information in a cache file on the client. This command will display information about the subfile cache, if the client is configured to use subfile backup.
The options below only applies to Windows OS:
SHOW SYSTEMOBJECT / SHOW SYSTEMSTATE
You use these commands to find out what system facilities are installed, and which ones can be backed up with TSM. SYSTEMOBJECT is used for Windows 2000 and XP clients, and SYSTEMSTATE for Windows 2003 clients.
SYSTEMSERVICES
For Windows 2003 clients, displays the SYSTEM SERVICES data that is available on this client. Useful to determine which SYSTEM SERVICES files are installed on this Windows client and those that could be backed up.
Server commands:
SHOW CONFIG
This issues a set of QUERY and SHOW commands and then uses these to build a quite comprehensive picture of the state of the server.
SHOW ASQUEUED
If you have a client session or process stuck, it may be waiting for a drive. You can use this command to see if there are sessions queued waiting for mount points.
SHOW DEVCLASS
Is also useful if you have problems with drives. It displays the status of each device class, including the status of allocated drives.
SHOW MP
Useful for determining which volume is in-use by a given mount point and other attributes for the assigned mount points.
SHOW ASVOL
If you are having problems with sessions or processes queued, or waiting for tape volumes, then this command will display the in-memory list of assigned volumes.
SHOW BUFSTATS
Use this command to see if you need to increase your database buffer pool size.
SHOW BUFVARS
This command will display the status of the buffer pool variables and can be used to check for dirty buffer pages.
You use another undocumented command 'FLUSH' to clear out the dirty buffers.
FLUSH
This causes a database buffer write to flush, which would be used to
test for buffer-writer starvation. Use this command when SHOW BUFVARS has
a dpDirty (dirty pages) value in the thousands. Then check log
utilization to see if it freed things up.
SHOW DBTXNT
Use this command to displays the database transaction table.
SHOW DBV
Displays database global attributes.
SHOW DBBACKUPVOLS
Use this command to get details on the latest full and incremental database backup volumes.
SHOW LOGPINNED
You can use this command if your logfile is running out of space. The oldest active record in the log is 'pinning' the log. This command will tell you what task owns that oldest record. You could follow this up with SHOW LOGPINNED CANCEL
which will cancel whatever is holding the pinned record.
SHOW LOGV
You can use this command to display the recovery log global attributes, but it is less obvious what they all mean.
SHOW LOGstats
Use this command to see statistics on log usage.
An associated command is SHOW LOGRESET This command will RESET the log statistics back to 0.
SHOW LOCK
If your TSM server is running very slow it is worth trying this command. A TSM server uses locks to serialise updates to prevent corruption. You use this command to see what resources are locked.
SHOW RESQUEUE
The TSM server monitors resource usage and will cancel any resource users that are holding onto resources for too long. You use the SHOW RESQUEUE command to display the resource queue and it will display information about transactions, locks, and other resources.
SHOW SESSION
Useful for diagnosing hangs or other general session problems while a session is still connected to the server. This is also useful in cases where a session is cancelled or terminated and still appears in QUERY SESSION.
SHOW TXNT
You use this command to get information about active server transactions. Transactions are the low level operations that actually read or update the database.
SHow INVObject 0 ObjectId
Use this command to show an inventory object, reporting its nodename, filespace, management class, and more. This command can be useful if you get errors with objects. For example, when exporting a server you may see a message like
ANR9999D xibf.c(664): Return code 87 encountered in writing
object 0.9041317 to export stream.
ANR0661E EXPORT SERVER: Internal error encountered in
accessing data storage.
The 0. 9041317 is the Object ID. If you use the SHOW command
SHow INVObject 0 9041317
The result below will tell you what the object is
OBJECT: 0. 9041317 (Backup):
Node: ACSN08 Filespace: /y2. /msg/rlds/ temp
Type: 2 CG: 1 Size: 0.0 HeaderSize: 0
BACKUP OBJECTS ENTRY:
State: 1 Type: 2 MC: 1 CG: 1
/y2 : / msg/rlds/ temp
This (MC: DEFAULT)
Active, Inserted 08/01/03 07:58:58
EXPIRING OBJECTS ENTRY:
Expiring object entry not found.
SHOW SSPOOL
Useful for displaying the states and attributes of defined storage pools.
SHow DAMAGED poolname
This command will list out all the files in a storage pool that are marked as damaged. Typ
Volume ID: 34281, Volume Name: QZ1720
Segment number: 1, Segment start: 1606,
Segment Size: 0.85470464
file_name
etc....
Found 4349 damaged bitfiles.
To fix them, run an audit command like
AUDIT VOL QZ1720 FIX=YES
SHOW TRANSFERSTATS poolname
You use this command to get statistics from the last migration process, for example -
SHOW TRANSFERSTATS BACKUPPOOL
terça-feira, 18 de setembro de 2012
DSMCUTIL - Criando Serviço Scheduler
dsmcutil install /name:"TSM Scheduler - SOFTWARE-BKP_FS_INC_30D" /node:SOFTWARE-BKP_FS_INC_30D /password:SOFTWARE-BKP_FS_INC_30D /optfile:"C:\Program Files\Tivoli\TSM\baclient\dsm_30D.opt" /clientdir:"c:\program files\tivoli\tsm\baclient" /schedlog:"C:\Program Files\Tivoli\TSM\baclient\logs\dsmsched_30D.log" /errorlog:"C:\Program Files\Tivoli\TSM\baclient\logs\dsmerror_30D.log" /autostart:yes /startnow:yes /clusternode:no
dsmcutil install /name:"TSM Scheduler - SOFTWARE-BKP_FS_INC_180D" /node:SOFTWARE-BKP_FS_INC_180D /password:SOFTWARE-BKP_FS_INC_180D /optfile:"C:\Program Files\Tivoli\TSM\baclient\dsm_180D.opt" /clientdir:"c:\program files\tivoli\tsm\baclient" /schedlog:"C:\Program Files\Tivoli\TSM\baclient\logs\dsmsched_180D.log" /errorlog:"C:\Program Files\Tivoli\TSM\baclient\logs\dsmerror_180D.log" /autostart:yes /startnow:yes /clusternode:no
Criando CLIENTOPT
DEFINE CLOPTSET HORST01BRN_ABSFS_WKY DESCR="Backup Incremental Absolute"
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY SCHEDMODE POLLING Force=yes SEQnumber=1
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY SUBDIR yes Force=yes SEQnumber=2
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY TAPEPROMPT no Force=yes SEQnumber=3
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY COMPRESSION no Force=yes SEQnumber=4
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY COMPRESSALWAYS yes Force=yes SEQnumber=5
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY MEMORYEFFICIENTBACKUP no Force=yes SEQnumber=6
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY TXNBYTELIMIT 25600 Force=yes SEQnumber=7
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY RETRYPERIOD 5 Force=yes SEQnumber=8
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY MAXCMDRETRIES 2 Force=yes SEQnumber=9
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY QUERYSCHEDPERIOD 1 Force=yes SEQnumber=10
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY CHANGINGRETRIES 2 Force=yes SEQnumber=11
DEFine CLIENTOpt HORST01BRN_ABSFS_WKY RESOURCEUTILIZATION 3 Force=yes SEQnumber=12
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY DIRMC MC_30D_DISK_ABS FORCE=YES SEQnumber=21
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "INCLUDE.SYSTEMSTATE ALL MC_30D_DISK_ABS' FORCE=YES SEQnumber=22
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "INCLUDE.SYSTEMOBJECT ALL MC_30D_DISK_ABS' FORCE=YES SEQnumber=23
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "INCLUDE * MC_30D_DISK_ABS' FORCE=YES SEQNUMBER=24
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\pagefile.sys'" SEQNUMBER=25
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\IBMBIO.COM'" SEQNUMBER=26
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\IBMDOS.COM'" SEQNUMBER=27
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\MSDOS.SYS'" SEQNUMBER=28
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\IO.SYS'" SEQNUMBER=29
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\system32\Perflib*.dat'" SEQNUMBER=30
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE.DIR '*:\System Volume Information'" SEQNUMBER=31
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE.DIR '*:\...\Temporary Internet Files'" SEQNUMBER=32
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE.DIR '*:\Recycled'" SEQNUMBER=33
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE.DIR '*:\Recycler'" SEQNUMBER=34
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.tmp'" SEQNUMBER=35
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\~*.*'" SEQNUMBER=36
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE 'c:\Program Files\UMS\Director\data\esntevt.dat'" SEQNUMBER=37
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\Documents and Settings\...\ntuser.dat.LOG'" SEQNUMBER=38
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\Documents and Settings\...\NTUSER.DAT'" SEQNUMBER=39
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\Documents and Settings\...\usrclass.dat.LOG'" SEQNUMBER=40
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\Documents and Settings\...\usrclass.dat'" SEQNUMBER=41
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE.DIR 'C:\adsm.sys'" SEQNUMBER=42
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.mdf'" SEQNUMBER=43
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.ldf'" SEQNUMBER=44
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.ndf'" SEQNUMBER=45
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.nsf'" SEQNUMBER=46
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.dbf'" SEQNUMBER=47
DEFINE CLIENTOPT HORST01BRN_ABSFS_WKY INCLEXCL "EXCLUDE '*:\...\*.edb'" SEQNUMBER=48
Script para criar politicas
## Script deve ser utilizada para library com drives LTO
## Os ambientes separados por DOMAIN: EXCHANGE / ORACLE / SQL / SAP / WINDOWS / UNIX
## Retenção:
7 DIAS PARA DISCO
7 DIAS PARA TAPE
7 DIAS PARA DISCO ABSOLUTE
7 DIAS PARA TAPE ABSOLUTE
15 DIAS PARA DISCO
15 DIAS PARA TAPE
15 DIAS PARA DISCO ABSOLUTE
15 DIAS PARA TAPE ABSOLUTE
30 DIAS PARA DISCO
30 DIAS PARA TAPE
30 DIAS PARA DISCO ABSOLUTE
30 DIAS PARA TAPE ABSOLUTE
60 DIAS PARA DISCO
60 DIAS PARA TAPE
60 DIAS PARA DISCO ABSOLUTE
60 DIAS PARA TAPE ABSOLUTE
90 DIAS PARA DISCO
90 DIAS PARA TAPE
90 DIAS PARA DISCO ABSOLUTE
90 DIAS PARA TAPE ABSOLUTE
365 DIAS PARA DISCO
365 DIAS PARA TAPE
365 DIAS PARA DISCO ABSOLUTE
365 DIAS PARA TAPE ABSOLUTE
5 ANOS DIAS PARA TAPE
5 ANOS DIAS PARA TAPE ABSOLUTE
Script faz:
* Registra Admin com senha STORAGEBR
* Define Library e device class
* Define Storage Pool's de disco e de Fita
* Define Policy Domain e Policy Set
* Define Management Class e Copy Group's BAckup e Archive
* Define Default Management Class
* Valida as Politicas
* Ativa as Politicas
set MINPWLENGTH 8
set PASSEXP 90
set INVALIDPWLIMIT 5
set AUTHENTICATION on
SET ACTLOGRETENTION 60
SET SUMMARYRETENTION 60
SET EVENTRETENTION 60
def library LIB01 libtype=scsi
def devcl devcl_lto library=lib01 devtype=lto
def stg TAPE_30D devcl_lto po=Primary desc='Storage Pool em fita - Armazenar dados de 7 a 30 dias' access=readw reclaim=80 maxsi=nol CRCD=no HIghmig=80 lowmig=30 reclaimpro=1 RECLAMATIONType=THRESHold COLlocate=no MAXSCRatch=9999 mIGDelay=0 MIGPRocess=1 MIGContinue=yes DATAFormat=native
def stg TAPE_365D devcl_lto po=Primary desc='Storage Pool em fita - Armazenar dados de 90 a 365 dias' access=readw reclaim=80 maxsi=nol CRCD=no HIghmig=80 lowmig=30 reclaimpro=1 RECLAMATIONType=THRESHold COLlocate=no MAXSCRatch=9999 mIGDelay=0 MIGPRocess=1 MIGContinue=yes DATAFormat=native
def stg TAPE_SAP devcl_lto po=Primary desc='Storage Pool em fita - Armazenar dados de SAP' access=readw reclaim=80 maxsi=nol CRCD=no HIghmig=80 lowmig=30 reclaimpro=1 RECLAMATIONType=THRESHold COLlocate=no MAXSCRatch=9999 mIGDelay=0 MIGPRocess=1 MIGContinue=yes DATAFormat=native
def stg TAPE_SAPLOG1 devcl_lto po=Primary desc='Storage Pool em fita - Armazenar dados de SAP' access=readw reclaim=80 maxsi=nol CRCD=no HIghmig=80 lowmig=30 reclaimpro=1 RECLAMATIONType=THRESHold COLlocate=no MAXSCRatch=9999 mIGDelay=0 MIGPRocess=1 MIGContinue=yes DATAFormat=native
def stg TAPE_SAPLOG2 devcl_lto po=Primary desc='Storage Pool em fita - Armazenar dados de SAP' access=readw reclaim=80 maxsi=nol CRCD=no HIghmig=80 lowmig=30 reclaimpro=1 RECLAMATIONType=THRESHold COLlocate=no MAXSCRatch=9999 mIGDelay=0 MIGPRocess=1 MIGContinue=yes DATAFormat=native
def stg DSK_30D disk desc='Storage Pool em Disco - Armazenar dados até 30 dias de retenção' nextstg=TAPE_30D
def stg DSK_365D disk desc='Storage Pool em Disco - Armazenar dados até 365 dias de retenção' nextstg=TAPE_365D
def stg DSK_SAPLOG1 disk desc='Storage Pool em Disco - Armazenar dados de SAPLOG1' nextstg=TAPE_SAPLOG1
def stg DSK_SAPLOG2 disk desc='Storage Pool em Disco - Armazenar dados de SAPLOG1' nextstg=TAPE_SAPLOG2
DEFINE domain PD_ORA desc="Policy Domain para ambientes ORACLE" BACKRET=365 ARCHRET=365
DEFINE domain PD_WIN desc="Policy Domain para ambientes WINDOWS" BACKRET=365 ARCHRET=365
DEFINE domain PD_SAP desc="Policy Domain para ambientes SAP" BACKRET=365 ARCHRET=365
DEFINE domain PD_NOTES desc="Policy Domain para ambientes NOTES" BACKRET=365 ARCHRET=365
DEFINE policyset PD_ORA PS_ORA desc="Policy Set para ambientes ORACLE"
DEFINE policyset PD_WIN PS_WIN desc="Policy Set para ambientes WINDOWS"
DEFINE policyset PD_SAP PS_SAP desc="Policy Set para ambientes SAP"
DEFINE policyset PD_NOTES PS_NOTESdesc="Policy Set para ambientes NOTES"
def mgm PD_ORA PS_ORA MC_RMAN_DISK migdest=TAPE_30D
def mgm PD_ORA PS_ORA MC_RMAN_TAPE migdest=TAPE_30D
def mgm PD_SAP PS_SAP MC_30D_TAPE migdest=TAPE_SAP
def mgm PD_SAP PS_SAP MC_SAPLOG1_30D_DISK dest=tape_SAPLOG1
def mgm PD_SAP PS_SAP MC_SAPLOG2_30D_DISK dest=tape_SAPLOG2
def mgm PD_WIN PS_WIN MC_15D_DISK migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_15D_DISK_ABS migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_15D_TAPE migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_15D_TAPE_ABS migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_30D_DISK migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_30D_DISK_ABS migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_30D_TAPE migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_30D_TAPE_ABS migdest=TAPE_30D
def mgm PD_WIN PS_WIN MC_365D_DISK migdest=TAPE_365D
def mgm PD_WIN PS_WIN MC_365D_DISK_ABS migdest=TAPE_365D
def mgm PD_WIN PS_WIN MC_365D_TAPE migdest=TAPE_365D
def mgm PD_WIN PS_WIN MC_365D_TAPE_ABS migdest=TAPE_365D
def mgm PD_NOTES PS_NOTES MC_15D_DISK migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_15D_DISK_ABS migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_15D_TAPE migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_15D_TAPE_ABS migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_30D_DISK migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_30D_DISK_ABS migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_30D_TAPE migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_30D_TAPE_ABS migdest=TAPE_30D
def mgm PD_NOTES PS_NOTES MC_365D_DISK migdest=TAPE_365D
def mgm PD_NOTES PS_NOTES MC_365D_DISK_ABS migdest=TAPE_365D
def mgm PD_NOTES PS_NOTES MC_365D_TAPE migdest=TAPE_365D
def mgm PD_NOTES PS_NOTES MC_365D_TAPE_ABS migdest=TAPE_365D
def co PD_ORA PS_ORA MC_RMAN_DISK dest=DSK_30D vere=1 verde=0 rete=1 reto=0 t=b
def co PD_ORA PS_ORA MC_RMAN_TAPE dest=TAPE_30D vere=1 verde=0 rete=1 reto=0 t=b
def co PD_SAP PS_SAP MC_30D_TAPE dest=TAPE_SAP retver=30 t=a
def co PD_SAP PS_SAP MC_SAPLOG1_30D_DISK dest=DSK_SAPLOG1 retver=30 t=a
def co PD_SAP PS_SAP MC_SAPLOG2_30D_DISK dest=DSK_SAPLOG2 retver=30 t=a
def co PD_NOTES PS_NOTES MC_15D_DISK dest=DSK_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b
def co PD_NOTES PS_NOTES MC_15D_DISK_ABS dest=DSK_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_15D_TAPE dest=TAPE_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b
def co PD_NOTES PS_NOTES MC_15D_TAPE_ABS dest=TAPE_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_30D_DISK dest=DSK_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b
def co PD_NOTES PS_NOTES MC_30D_DISK_ABS dest=DSK_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_30D_TAPE dest=TAPE_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b
def co PD_NOTES PS_NOTES MC_30D_TAPE_ABS dest=TAPE_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_365D_DISK dest=DSK_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b
def co PD_NOTES PS_NOTES MC_365D_DISK_ABS dest=DSK_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_365D_TAPE dest=TAPE_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b
def co PD_NOTES PS_NOTES MC_365D_TAPE_ABS dest=TAPE_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b mode=absolute
def co PD_NOTES PS_NOTES MC_15D_DISK dest=DSK_30D retver=15 t=a
def co PD_NOTES PS_NOTES MC_15D_TAPE dest=TAPE_30D retver=15 t=a
def co PD_NOTES PS_NOTES MC_30D_DISK dest=DSK_30D retver=30 t=a
def co PD_NOTES PS_NOTES MC_30D_TAPE dest=TAPE_30D retver=30 t=a
def co PD_NOTES PS_NOTES MC_365D_DISK dest=DSK_365D retver=365 t=a
def co PD_NOTES PS_NOTES MC_365D_TAPE dest=TAPE_365D retver=365 t=a
def co PD_WIN PS_WIN MC_15D_DISK dest=DSK_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b
def co PD_WIN PS_WIN MC_15D_DISK_ABS dest=DSK_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b mode=absolute
def co PD_WIN PS_WIN MC_15D_TAPE dest=TAPE_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b
def co PD_WIN PS_WIN MC_15D_TAPE_ABS dest=TAPE_30D vere=nolimit verde=nolimit rete=15 reto=15 t=b mode=absolute
def co PD_WIN PS_WIN MC_30D_DISK dest=DSK_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b
def co PD_WIN PS_WIN MC_30D_DISK_ABS dest=DSK_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b mode=absolute
def co PD_WIN PS_WIN MC_30D_TAPE dest=TAPE_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b
def co PD_WIN PS_WIN MC_30D_TAPE_ABS dest=TAPE_30D vere=nolimit verde=nolimit rete=30 reto=30 t=b mode=absolute
def co PD_WIN PS_WIN MC_365D_DISK dest=DSK_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b
def co PD_WIN PS_WIN MC_365D_DISK_ABS dest=DSK_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b mode=absolute
def co PD_WIN PS_WIN MC_365D_TAPE dest=TAPE_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b
def co PD_WIN PS_WIN MC_365D_TAPE_ABS dest=TAPE_365D vere=nolimit verde=nolimit rete=365 reto=365 t=b mode=absolute
def co PD_WIN PS_WIN MC_15D_DISK dest=DSK_30D retver=15 t=a
def co PD_WIN PS_WIN MC_15D_TAPE dest=TAPE_30D retver=15 t=a
def co PD_WIN PS_WIN MC_30D_DISK dest=DSK_30D retver=30 t=a
def co PD_WIN PS_WIN MC_30D_TAPE dest=TAPE_30D retver=30 t=a
def co PD_WIN PS_WIN MC_365D_DISK dest=DSK_365D retver=365 t=a
def co PD_WIN PS_WIN MC_365D_TAPE dest=TAPE_365D retver=365 t=a
assign defmgmtclass PD_NOTES PS_NOTES MC_15D_DISK
assign defmgmtclass PD_ORA PS_ORA MC_RMAN_DISK
assign defmgmtclass PD_WIN PS_WIN MC_15D_DISK
assign defmgmtclass PD_SAP PS_SAP MC_30D_TAPE MC_30D_TAPE
validate po PD_ORA PS_ORA
validate po PD_WIN PS_WIN
validate po PD_NOTES PS_NOTES
validate po PD_SAP PS_SAP
activate po PD_ORA PS_ORA
activate po PD_WIN PS_WIN
activate po PD_NOTES PS_NOTES
activate po PD_SAP PS_SAP
Tunning dsmserv.opt - TSM 5.X
Este documento tem como objetivo padronizar o arquivo de configuração do TSM SERVER DSMSERV.OPT de tal forma que obtenha o máximo de performance dos recursos de hardware e software.
ESTE DOCUMENTO TEM COMO OBJETIVO PADRONIZAR O ARQUIVO DE CONFIGURAÇÃO DO TSM SERVER (DSMSERV.OPT) DE TAL FORMA QUE OBTENHA O MÁXIMO DE PERFORMANCE DOS RECUROS DE HARDWARE E SOFTWARE DISPONIVEIS.
Dentre os parâmetros do DSMSERV.OPT que podem ser alterados, abaixo segue a relação dos que podem afetar na performance do TSM SERVER:
TCPWINDOWSIZE
LOGPOOLSIZE
TXNGROUPMAX
BUFPOOLSIZE
AIXASYNCIO
AIXDIRECTIO
TCPWINDOWSIZE
OBS.: Verificar no Sistema Operacional AIX como esta setado este valor. Segue o comando:
# no -a | grep 1323
rfc1323 = 1
Recomendação
TCPWINDOWSIZE 63
128 ( Gibabit Ethernet with Jumbo Frames - 9000 MTU)
Permite aprimoramentos de TCP conforme especificado pelo RFC 1323, TCP Extensions for High Performance (Extensões de TCP para Alto Desempenho). O padrão é 0. Um valor 1 especifica que todas as conexões de TCP tentarão negociar os aprimoramentos do RFC
LOGPOOLSIZE
Depende de como o "LogPool Percentage wait" está. Para verificar, execute o comando Q LOG F=D, como exemplo abaixo:
tsm: TSM_HOTSM003TM>q log f=d
Available Space (MB): 6,132
Assigned Capacity (MB): 6,132
Maximum Extension (MB): 0
Maximum Reduction (MB): 6,124
Page Size (bytes): 4,096
Total Usable Pages: 1,569,280
Used Pages: 417
Pct Util: 0.0
Max. Pct Util: 46.4
Physical Volumes: 3
Log Pool Pages: 1,024
Log Pool Pct. Util: 0.59
Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 95,015.12
Consumption Reset Date/Time: 01/18/2008 15:33:11
Se o valor estiver maior do que 0 (zero) deve-se incrementar o valor gradualmente dentre da faixa recomendada:
Recomendação
LOGPOOLSIZE 2048 - 8192 KB
OBS.: Se o valor recomendado acima for ultrapassado poderá causar queda de performance no TSM.
TXNGROUPMAX
É recomendado alterar este parametro no CLIENT, onde o backup contempla inumeros arquivos pequenos, como um FileServer. Se alterar no TSM SERVER poderá degradar a performance
Recomendação
TXNGROUPMAX 256 ( TSM SERVER)
256 - 4096 (CLIENT com muitos arquivos pequenos)
BUFPOOLSIZE
O valor do bufpoolsize deve variar em relação a quantidade de memória alocada para o servidor. A variação é de 1/8 podendo chegar no máximo a 1/4 da memória fisica do TSM SERVER. O unidade de medida utilizada é KBYTES.
Abaixo segue exemplos de como calcular o valor que deve ser utilizado para o BUFPOOLSIZE:
Servidor que possui 8Gb de memoria (comando prtconf | more)
8Gb X 1024 (para converter em megabyte) = 8192 Mb X 1024 (para converter em kbytes) = 8388608 Kb
1/8 de 8388608 kb = 1048576
1/4 de 8388608 kb = 2097152
Ou seja o BUFPOOLSIZE poderá variar entre 1048576 e 2097152
Servidor que possui 2Gb de memoria (comando prtconf | more)
2 Gb X 1024 (para converter em megabyte) = 2048 Mb X 1024 (para converter em kbytes = 2097152 Kb
1/8 de 2097152 Kb = 262144 kb
1/4 de 2097152 Kb = 524288 kb
Ou seja o BUFPOOLSIZE poderá variar entre 262144 e 524288
Recomendação
Memória do Servidor Recomendação Buffer Pool Size (KB)
256 32678
512 65536
1024 131072
2048 262144
3072 393216
4096 524288
8192 1048576
AIXASYNCIO
Parâmetro deve ser utilizado quando os volumes de Banco / Log / StgPool do tsm estiverem armazenados em FileSystem's do tipo JFS2.
OBS.: "AIO" deve estar habilitado no sistema operacional AIX. Esta opção não é default para o sistema operacional, antes de alterar o parâmentro no TSM deve ser solicitado ao especialista em AIX que altere o mesmo no sistema operacional. (para que a o opção seja habilitada o servidor deverá ser restartado)
Recomendação
AIXASYNCIO YES
AIXDIRECTIO
Parâmetro deve ser utilizado quando os volumes de Banco / Log / StgPool do tsm estiverem armazenados em FileSystem's do tipo JFS2. No sistema operacional o valor é habilitado por default. No tsm server o parâmetro já vem setado como YES
Recomendação
AIXDIRECTIO YES
Tunning AIX - TSM 5.X
ESTE DOCUMENTO TEM COMO OBJETIVO PADRONIZAR PARÂMETROS DO SISTEMA OPERACIONAL AIX QUE TERÁ A FUNCIONALIDADE DE TSM SERVER
Dentre os parâmetros que podem ser alterados, abaixo segue a relação dos que podem afetar na performance do TSM SERVER:
Alocação de volumes para o TSM (DB / LOG / STG)
Tuning IOO - MAXPGAHEAD
Tuning VMO - MINPERM / MAXPERM
Tuning NO - RFC1323 / THEWALL / SBMAX
OBS.: Toda alteração deverá ser feita pela competência que administra o sistema operacional
Alocação de volumes para o TSM (DB / LOG / STG)
A tivoli recomenda que todos os volumes de banco de dados, log e storagepool (disco) sejam criados em Raw Device. A padronização engloba desde a nomenclatura dos VG's e dos raw devices até o volume que deve ser alocado
Os vg's de db, log e stg devem ser criados separadamente e "estrapiados" na maior quantidade de discos possivel. Não deve-se utilizar discos grandes
Nomenclatura:
VG DB: TSMDBVG
VG LOG: TSMLOGVG
VG STG: TSMSTGVG
Raw device DB: rlvdbvol_01 / rlvdbvol_02 / ....
Raw device LOG: rlvlogvol_01 / rlvlogvol_02 / ...
Raw device STG: rlvstgvol_01 / rlvstgvol_02 / ...
Volume:
DB: Criar Raw Device de 10 Gb cada
LOG: Criar Raw Device de 02 Gb cada
STG: Criar Raw Device de 50 Gb cada ( ou valor menor, de acordo com a necessidade de ajustes nos storage pool)
Tuning IOO - MAXPGAHEAD
Recomendação para o MAXPGAHEAD = 256. Este valor é utilizado para calcular o MAXFREE e MINFREE
A equação deve respeitar:
minfree + maxpgahead <= maxfree
Segue a fórmula para calculo do MAXFREE e MINFREE:
- minfree: 120 X numero de processadores
- maxfree: 120 + maxpgahead X numero de processadores
Tuning VMO - MINPERM / MAXPERM
Valor default do MAXPERM do sistema operaciona é 80%. Deve ser alterado para 50%
Tuning NO - (RFC 1323 / THEWALL / SBMAX)
RFC 1323: Permite aprimoramentos de TCP conforme especificado pelo RFC 1323, TCP Extensions for High Performance (Extensões de TCP para Alto Desempenho). O padrão é 0. Um valor 1 especifica que todas as conexões de TCP tentarão negociar os aprimoramentos do RFC.
SB_MAX: Especifica o tamanho máximo do buffer permitido para um soquete. O padrão é 65536 bytes. Do ponto de vista de recomendações de desempenho, o valor sb_max deve corresponder à definição TCPWindowsize no arquivo de configuração do Tivoli Storage Manager dsm.sys e deve ser duas vezes o TCPWindowsize
Deve-se setar os valores:
THEWALL = 131072
SB_MAX = 1310720
RFC1323 = 1
OBS.: Verificar no Sistema Operacional AIX como esta setado este valor. Segue o comando:
# no -a | grep rfc1323
rfc1323 = 1
# no -a | grep sb_max
sb_max = 1310720
# no -a | grep thewall
thewall = 131072
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
Assinar:
Postagens (Atom)