24 April 2014

Quick Steps to configure TSM for Database (TDPOracle & TDPSQL) and TSM for Mail (TDPExchange & TDPDomino) Servers

What is IBM Tivoli Data Protection (TDP) and why we need it ?

How to configure Tivoli Data Protection (TDP)
IBM Tivoli Data Protection (TDP) is one of the family products of IBM Tivoli Storage Manager (TSM) which is used specifically for application level backup and restore functions. It allows us to take the backup of the applications even when the application is in running state, it offers both online and offline application level backups. Through TSM Backup-Archive client we can take only flat file level backup but using TDP’S we can communicate directly with any of the application servers like SQL, ORACLE, R3 SAP, EXCHANGE, DOMINO thorough TSM API and configure the backup, this type of backup is generally considered as a consistent and reliable backup for restoring the application data. In addition, we can also configure TDP clients to take the archive log backups for database and mail applications for point in time restore. You need a separate licenses from IBM to use these TDP products.

Below steps will help you to quickly configure TDP clients and start taking the backup of your applications. It is required to install and configure TSM BAclient software on all the application servers before installing/configuring any TDP Clients.

Quick steps to configure Tivoli Storage Manager (TSM) for Database Servers

With TSM for Database software package you can protect Microsoft SQL Database and Oracle Database servers. Use the following steps to quickly configure TDP clients to protect your databases.

Steps to configure TDP for SQL Databases

  • First,we have to install the TDP SQL Software in SQL application client. After that we will get TDP SQL folder (Program Files/Tivoli/Tsm/Tdpsql). This is the default installation path for TDP SQL. In this folder we will have all the required configuration files. They are TDPSQL.CFG, DSM.SMP (dsm.smp rename it as dsm.opt).
  • Next, we have to edit these file (dsm.opt) with default parameters which are tcpserveraddress, tcpport, nodename, commmethod, include, exclude, passwordaccess generate options.
  • After installation and configuration we will go to TSM server side and we have to create  a new policy domain (or) new management class in the existing domain with the required retention settings.
  • Then we come back to client side and trigger the following command to check the status of the TDPSQL as shown below. 
                Cd C:\Program Files\Tivoli\Tsm\Tdpsql >Tdpsqlc
  • Now we have to check the communication between TDPSQL and TSM Server by using the following command. This command will show all the policy and destination setting of the SQL database backups.
          Cd C:\Program Files\Tivoli\Tsm\Tdpsql >Tdpsqlc q tsm
  • Next step is to authenticate and store the password of the TDP SQL node. You have to register two separate nodes on TSM Server, one for BA-client node and another for TDPSQL. Run the following command to authenticate and store the password for future backup schedules. It will ask old password, new password and verification password. You can skip this step if you have already authenticated it through TDPSQL GUI before.
         Cd C:\Program Files\Tivoli\Tsm\Tdpsql >tdpsqlc changetsmpassword
  • Finally,  we can take backup of the SQL application database. To take the backup you can either use GUI or commandline.  On the commandline run the following command to start the SQL DB backup.
         Cd C:\Program Files\Tivoli\Tsm\Tdpsql>Tdpsqlc backup databasename full

Steps to configure TDP for ORACLE Databases

  • First,we have to install the TDP ORACLE software in Oracle application client. After that we will get TDP oracle folder (Program Files/Tivoli/Tsm/AgentOba). This is the default TDP Oracle installation path in windows OS. In this folder we will have all the required configuration files. They are TDPOCONF.CFGDSM.SMP.
  • Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and copy the tdpo.opt.smp file to tdpo.opt. Edit the tdpo.opt file to include these options:
dsmi_orc_config C:\Program Files\Tivoli\TSM\AgentOBA\dsm.opt 
dsmi_log C:\Program Files\Tivoli\TSM\AgentOBA
  • In this same directory, copy the dsm.smp file to dsm.opt. Edit the dsm.opt file to include these options:

COMMMethod TCPip 
TCPServeraddress x.x.x.x 
PASSWORDAccess generate 
NODename TDPnodename
  • Register the node to the Tivoli Storage Manager server with the following command:

REG NODE TDPnodename password maxnummp=n
  • Make sure the Oracle user has the read and write permission to the C:\Program Files\Tivoli\TSM\AgentOBA directory.
  • Change to the C:\Program Files\Tivoli\TSM\AgentOBA directory and run the tdpoconf password command as Oracle user to generate the password file. You will be prompted to enter the password from Step 4 three times.
  • Run the tdpoconf showenvironment command to confirm proper configuration.
  • As Oracle user, run your RMAN backup script with the parameter as specified.

    ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt) 


            For example:

run {
                             allocate channel t1 type ’sbt_tape’ parms
                                 ’ENV=(TDPO_OPTFILE=C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt)’;
                             backup
                                filesperset 5
                                format ’df_%t_%s_%p’
                                (database);
}

Quick steps to configure Tivoli Storage Manager for Mail Servers

With TSM for Mail software package you can protect Microsoft Exchange and IBM Lotus Domino Mail Servers. Use the following steps to quickly configure TDP clients to protect your mail servers

Steps to Configure TDP for EXCHANGE

  • First, we have to install the TDP Exchange Software in Exchange application client.. After that we will get TDP Exchange folder (Program Files/Tivoli/Tsm/TdpExchange. This is the default installation path for TDP Exchange. In this folder we will have all the required configuration files. They are TDPEXC.CFGDSM.SMP (dsm.smp rename it as dsm.opt).
  • Next, we have to edit these file (dsm.opt) with default parameters which are tcpserveraddress, tcpport, nodename, commmethod, include, exclude, passwordaccess generate options.
  • After installation and configuration we will go to TSM server side and we have to create a new policy domain (or) new management class in the existing domain with the required retention settings.
  • Then we come back to client side and trigger the following command to check the status of the TDPExchange as shown below. 
                Cd C:/Program Files/Tivoli/Tsm/TdpExchange >Tdpexcc
  • Now we have to check the communication between TDPExchange and TSM Server by using the following command. This command will show all the policy and destination settings of the Exchange backups.
          Cd C:/Program Files/Tivoli/Tsm/TdpExchange >Tdpexcc q tsm
  • Next step is to authenticate and store the password of the TDP Exchange node. You have to register two separate nodes on TSM Server, one for BA-client node and another for TDPExchange. Run the following command to authenticate and store the password for future backup schedules. It will ask old password, new password and verification password. You can skip this step if you have already authenticated it through TDPExchange GUI before
         Cd C:/Program Files/Tivoli/Tsm/TdpExchange>tdpexcc changetsmpassword 
  • Finally,  we can take backup of the Exchange mail server. To take the backup you can either use GUI or commandline.  On the commandline run the following command to start the Exchange mail server backup.
         Cd C:/Program Files/Tivoli/Tsm/Tdpexchange>Tdpexcc backup storagegroupname full
  • Three backup types which are commonly used for taking backup of SQL DB are FULL, DIFFERENTIAL and INCREMENTAL backups. 

Steps to Configure TDP for DOMINO Mail servers

  • First,we have to install the TDP Domino Software in Domino application client. After that we will get TDP Domino folder (Program Files/Tivoli/Tsm/Domino). This is the default installation path for TDP Domino.  In this folder we will have all the required configuration files. They are DOMDSM.CFGDSM.SMP (dsm.smp rename it as dsm.opt).
  • Next, we have to edit these file (dsm.opt) with default parameters which are tcpserveraddress, tcpport, nodename, commmethod, include, exclude, passwordaccess generate options.
  • After installation and configuration we will go to TSM server side and we have to create  a new policy domain (or) new management class in the existing domain with the required retention settings.
  • Then we come back to client side and trigger the following command to check the status of the TDPDOMINO as shown below. 
                Cd C:/Program Files/Tivoli/Tsm/Tdpsql >domdsmc
  • Now we have to check the communication between TDP Domino and TSM Server by using the following command. This command will show all the policy and destination settings of the Lotus Domino backups.
          Cd C:/Program Files/Tivoli/Tsm/domino >domdsmc q adsmserv
  • Next step is to authenticate and store the password of the TDP Domino node. You have to register two separate nodes on TSM Server, one for BA-client node and another for TDP Domino. Run the following command to authenticate and store the password for future backup schedules.  It will ask old password, new password and verification password. You can skip this step if you have already authenticated it through TDP Domino GUI before and stored the         password.
         Cd C:/Program Files/Tivoli/Tsm/domino >domdsmc changetsmpassword
  • Finally,  we can take backup of the Domino Mail server. To take the backup you can either use GUI or commandline.  On the commandline run the following command to start the Domino Mail server backup.
         Cd C:/Program Files/Tivoli/Tsm/domino>Domdsmc sel mail/* -subdir=yes

21 April 2014

Does TSM client encrypt or decrypt the client data which is already been encrypted before taking backup or restore ?

The Tivoli Storage Manager client makes no special provisions for data on a machine that has been previously encrypted, such as from third party vendor programs or NTFS EFS. From the perspective of Tivoli Storage Manager there is no difference between the encrypted data and plain text. Tivoli Storage Manager will take the data as it exists and store it in Tivoli Storage Manager Server storage. Tivoli Storage Manager makes no attempts to decrypt the data prior to storing it in the Tivoli Storage Manager server. 

Then when it is restored, Tivoli Storage Manager puts the data back as it was on the disk. If that was previously encrypted, then the third party program will be needed to decrypt that and bring it back to it's plain format.

Starting with the Tivoli Storage Manager V5.5 Client, the EFSDECRYPT parameter was introduced for AIX Client's only. This can allow the client to decrypt JFS2 encrypted files to plain format before having them stored into the Tivoli Storage Manager Server. The default is EFSDecrypt=NO to not decrypt the files. 

Efsdecrypt option

The efsdecrypt option allows you to control whether or not files encrypted by an AIX Encrypted File System (EFS) are read in encrypted or decrypted format. The efsdecrypt option default is no, which is to back up the encrypted or raw data. If you specify yes, the files are backed up as clear text, which means that they are backed up as normal files, as if the files existed in unencrypted form on the file system.

Another important point to remember if you want to use this options for your backups. Whenever you run a backup that includes any files encrypted on an EFS, you must ensure that you use the correct specification of the efsdecrypt option. If the efsdecrypt option value changes between two incremental backups, all encrypted files on EFS file systems are backed up again, even if they have not changed since the last backup. For example, if you are running an incremental backup of encrypted files that were previously backed up as "raw," then ensure that efsdecrypt is specified as no. If you change efsdecrypt to yes, all the files are backed up again in clear text even if they are unchanged, so ensure that you use this option carefully.

efsdecrypt syntax


                                     .-No--.   
>>-EFSDecrypt-------+-----+-----------------------------------------><
                                    '-Yes-' 


Suppose if the Tivoli Storage Manager client configuration is setup to encrypt it's own data stream to the Tivoli Storage Manager server. In this case Tivoli Storage Manager will take the data as it exists on the client and encrypt it and store it in the Tivoli Storage Manager server in it's own encrypted format. This means that if the data has been previously encrypted, Tivoli Storage Manager will encrypt the data again using it's own encryption method, and store this in the server. Then when it is restored, Tivoli Storage Manager decrypts the data back to it's original form as it was on the disk. If that was previously encrypted, then the third party program will be needed to decrypt that and bring it back to it's plain format. 

19 April 2014

How to rebalance the TSM Server database tablespaces after adding the new db filesystem

When the Tivoli Storage Manager server database (TSMDB1) is created using dbdirs on multiple file systems, for example "/TSM/db1, /TSM/db2", the database will use all file systems equally. When additional file systems need to be added to the database space with the "extend dbs" command, the newly added tablespaces will not be used equally.

After adding the /TSM/db3 file system to the database space, DB2 will not rebalance the file systems utilization equally. For example 

/dev/tsmdblv021 10412032 10411804 228 100% /TSM/db1
/dev/tsmdblv022 10412032 10411812 220 100% /TSM/db2
/dev/tsmdblv033 10403840 1333136 9070704 13% /TSM/db3

The 100% full /TSM/db1 and /TSM/db2 will stay 100% full and may cause the Tivoli Storage Manager to stop because of a DISK FULL condition. To prevent this condition you have to rebalance the TSM Database tablespaces. If the Database was initially created by a Tivoli Storage Manager Server V6.2 or above, there are is a way to do this online using the steps below.

Steps to rebalance the TSM Database Tablespace after adding new DB filesystem

  • Prepare a filesystem the same size as the initial filesystem. For example /TSM/db4 size : 10403840
  • Add /TSM/db4 to tablespace via Tivoli Storage Manager server admin command :
    extend DBs /fs/db4
  • Perform the rebalance activity during a quiet time. Logon as the server instance owner and execute the DB2 commands below. (on Windows, you need to run these commands from a DB2 Command Window and "set db2instance=server1).
    db2 connect to tsmdb1
    db2 set schema tsmdb1
    db2 alter tablespace SYSCATSPACE rebalance
    db2 alter tablespace USERSPACE1 rebalance
    db2 alter tablespace LARGESPACE1 rebalance
    db2 alter tablespace LARGEIDXSPACE1 rebalance
    db2 alter tablespace IDXSPACE1 rebalance
    db2 alter tablespace SYSTOOLSPACE rebalance
  • Depending on the size of the tablespace, the rebalance can take some time to finish. For a large tablespace, the rebalance can take about 30 minutes. Run the following command to check the rebalance status
    db2 "select * from SYSIBMADM.TBSP_UTILIZATION " |grep -i progress
  • If the rebalance is still active, the above command will return the tablespace still in active resizing. Wait until all tablespaces have done the rebalance and execute the following commands to reduce the tablespaces 
    db2 alter tablespace SYSCATSPACE reduce max
    db2 alter tablespace USERSPACE1 reduce max
    db2 alter tablespace LARGESPACE1 reduce max
    db2 alter tablespace LARGEIDXSPACE1 reduce max
    db2 alter tablespace IDXSPACE1 reduce max
    db2 alter tablespace SYSTOOLSPACE reduce max
  • After the rebalance/reduce, the file systems should be equally utilized and there are should be no more file systems in 100% full condition.
Note: If you are not sure on how to do these steps, open an IBM PMR and IBM support should be able to do these steps for you. 

How to add a new filesystem to the existing TSM DB when the TSM server is down or unable to startup

It is possible to add extra filesystems to the existing TSM server to increase the TSM database size. You can increase the TSM database size while the TSM server is in both online and offline state. Use the extend dbspace command when the TSM server is in online state after making sure that filesystem is mounted and available for use.

Otherwise, if you have enough down time available you can also halt the TSM server and add the TSM DB filesystem entry in the dsmserv.opt file and then restart the TSM server. This will pick the new added filesystem and add it to the TSM database directory list.  Once the new filesystem is added you need to rebalance the DB2 so that all the DB filesystems have the same utilization. 

But the above two procedures can be done only if the TSM server is in good condition, i.e having enough space in TSM DB to do the other server activities. With the Tivoli Storage Manager Server up and running it is possible to assign a new filesystem to the DB using extend dbspace command. But when the Tivoli Storage Manager Server is down this command is not available.

Lets imagine a situation where one of the TSM DB filesystem size reached to 100% and your TSM server is now down. The above discussed steps cannot be done since TSM server instance cannot start. In these situations follow the below steps to add new DB filesystem and increase the TSM DB size.

How to add TSM DB space to an offline TSM Server

Usually this situation should not occur and the DB filesystem usage needs to be monitored in regular intervals. This situation might occur during high peak backup activity. So make sure you always check the TSM DB size and its corresponding filesystem sizes. To assign additional space to the DB2 when the server is down follow these steps
  • Add a new filesystem to the Operating System with the same size of the existing assigned filesystems.
  • For the following steps at least 200 MB need to be available in the existing DB filesystems.
  • Login as the Tivoli Storage Manager instance owner and run
- db2 connect to TSMDB1
- db2 ALTER DATABASE TSMDB1 ADD STORAGE ON <path_new_filesystem>
  • After completing the previous commands start the Tivoli Storage Manager Server.
  • Use the following command to verify whether the new filesystem was added successfully
- query dbs
  • When the new path is shown in the "q dbs" output you have to rebalance the DB. This means that the DB containers get distributed to all available paths. 

18 April 2014

How to troubleshoot TSM DB backup failure (ANR2983E DSMI_DIR - DB2 sqlcode -2033 sqlerrmc) in TSM V7.1

While taking TSM Database backup, the db backup might fail with the following error code  "ANR2983E Database backup terminated due to environment or setup issue related to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168". This error is mainly seen in Tivoli Storage Manager V7.1 on all the platforms. The following error codes will be seen in the TSM activity log. 

ANR2983E Database backup terminated due to environment or setup issue related to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168. (SESSION: 108, PROCESS: 3)
ANR1361I Output volume /tsm/fsname/94712603.DBV closed.(SESSION: 108, PROCESS: 3)
ANR0515I Process 3 closed volume /tsm/fsname/94712603.DBV. (SESSION: 108, PROCESS: 3)
ANR0985I Process 3 for Database Backup running in the BACKGROUND completed with completion state FAILURE at 01:10:04 PM. (SESSION: 108, PROCESS: 3) 

Troubleshooting ANR2983E (TSM DB backup failure) error

In Unix & Linux platforms, starting with Tivoli Storage Manager V7.1, it is no longer necessary to set the API password during a manual configuration of the server. If you set the API password during the manual configuration process, the TSM database backup might fail.

If you use the Tivoli Storage Manager configuration wizard to create a Tivoli Storage Manager server instance, you do not have to complete these steps. If you are configuring an instance manually, complete the following steps before you issue either the BACKUP DB or the RESTORE DB commands.

The values and directory paths given below might be different in your TSM environment. Replace the example values with your actual values of server instance user ID, Tivoli Storage Manager server instance directory, and the server instance users home directory. 

Steps to do on AIX & Linux Operating Systems

Step 1: First, set the Tivoli Storage Manager API environment-variable configuration for the database instance:
  • Log in using the tsminst1 user ID.
  • When user tsminst1 is logged in, ensure that the DB2 environment is properly initialized. The DB2 environment is initialized by running the /home/tsminst1/sqllib/db2profile script, which normally runs automatically from the profile of the user ID. Ensure the .profile file exists in the instance users home directory, for example, /home/tsminst1/.profile. If .profile does not run the db2profile script, add the following lines:

    if [ -f /home/tsminst1/sqllib/db2profile ]; then
          . /home/tsminst1/sqllib/db2profile
      fi
  • For the instance_directory/sqllib/userprofile file, add the following lines:

    DSMI_CONFIG=server_instance_directory/tsmdbmgr.opt
    DSMI_DIR=server_bin_directory/dbbkapi
    DSMI_LOG=server_instance_directory
    export DSMI_CONFIG DSMI_DIR DSMI_LOG 
  • For the instance_directory/sqllib/usercshrc file, add the following lines:

    setenv DSMI_CONFIG=server_instance_directory/tsmdbmgr.opt
    setenv DSMI_DIR=server_bin_directory/dbbkapi
    setenv DSMI_LOG=server_instance_directory

Step 2: Log out and log in again as tsminst1, or issue this command:

   . ~/.profile

Ensure that you enter a space after the initial dot (.) character.

Step 3: Create a file that is called tsmdbmgr.opt in the server_instance directory, which is in the /tsminst1 directory in this example, and add the following line:

SERVERNAME TSMDBMGR_TSMINST1

The SERVERNAME that you use must be consistent in the tsmdbmgr.opt and dsm.sys files.

Step 4: As root user, add the following lines to the Tivoli Storage Manager API dsm.sys configuration file. The dsm.sys configuration file is in the following default location server_bin_directory/dbbkapi/dsm.sys

servername TSMDBMGR_TSMINST1 
commmethod tcpip 
tcpserveraddr localhost 
tcpport 1500 
errorlogname /tsminst1
nodename $$_TSMDBMGR_$$ 

Steps to do on  Windows Operating Systems

Step 1: Create a file that is called tsmdbmgr.env in the d:\tsmserver1 directory with the following contents:

DSMI_CONFIG=server_instance_directory\tsmdbmgr.opt
DSMI_LOG=server_instance_directory 

Step 2: Set the DSMI_ api environment-variable configuration for the database instance:

Open a DB2 command window. One method is to go to the C:\Program Files\Tivoli\TSM\db2\bin directory, or if you installed Tivoli Storage Manager in a different location, go to the db2\bin subdirectory in your main installation directory. Then, issue this command:

    db2cmd 

Issue this command:

    db2set -i server1 DB2_VENDOR_INI=d:\tsmserver1\tsmdbmgr.env 

Step 3: Create a file that is called tsmdbmgr.opt in the d:\tsmserver1 directory with the following contents:

nodename $$_TSMDBMGR_$$ 
commmethod tcpip 
tcpserveraddr localhost
tcpport 1500
passwordaccess generate
errorlogname d:\tsmserver1 

6 April 2014

TSM V6.3 Implementation Certification (IBM 000-590) Questions and Answers- Part 4

QUESTION NO: 76
User IDs and passwords are required for the installation and configuration of IBM Tivoli Storage Manager V6.3. Which two user IDs and passwords conform to the IBM DB2 standard? (Choose two.)
A. sqladm 
B. ibminst1 

C. tsminst1 
D. db2user1 
E. sysadmin
Answer: C,D 

QUESTION NO: 77
Output from scheduled commands goes to a log file. What is the default name of this log file? 
A. dsmerror.log 
B. schedule.log 
C. schedlog.out 
D. dsmsched.log
Answer: D 

QUESTION NO: 78
Which two network protocols are supported by the IBM Tivoli Storage Manager V6.3 client? (Choose two.)

A. UDP

B. HTML
C. CHAP
D. TCP/IP
E. Named Pipes

Answer: D,E 

QUESTION NO: 79
Which command scans the IBM Tivoli Storage Manager V6.3 Server activity log for server errors in the last 12 hours?

A. query actlog search= ‘E:’

B. q actlog begintime=-12 type=error
C. select from actlog beginday=-l type=error
D. q actlog begintime=now-12 search=ANR????E:

Answer: D 

QUESTION NO: 80
An IBM Tivoli Storage Manager administrator must restore the most recent backup version of MYVM node to a new system that is created with the name Test. Which command completes this

A. dsmc restore -vmname="Test"

B. dsmc restore ltiyvm -vmname = "Test" 
C. dsmc restore vm myvm -host="Test"
D. dsmc restore vm myvm -vmname="Test"

Answer: D 

QUESTION NO: 81
An IBM Tivoli Storage Manager (TSM) administrator has been informed that a NIC card has been replaced in the TSM Server. Since the replacement, there have been issues with connectivity. What might be the cause of the problem?

A. The SCSI bus driver is out of date.

B. The NIC card set to RENEGOTIATE.
C. The NIC card set to AUTONEGOTIATE. 
D. The IP address is not in the address book.

Answer: C 

QUESTION NO: 82
When running multiple server instances on the same physical system, which option will help distribute the memory needed for the database?

A. DBSHAREDMEM

B. DBMEMPERCENT 
C. DSMSHAREDMEM 
D. DSMMEMPERCENT

Answer: B 

QUESTION NO: 83
Using the client performance monitor function, an administrator has the capability to gather and analyze performance data about backup and restore operations for an IBM Tivoli Storage Manager client. What data can be analyzed?
A. storage pool, occupancy, and retention 
B. processor, disk, and network utilization 
C. memory, user, and tape drive utilization 
D. policy domains and management classes
Answer: B 

QUESTION NO: 84
Which authority level is needed to perform all IBM Tivoli Storage Manager tasks?

A. Root

B. System
C. super user 
D. administrator

Answer: C 

QUESTION NO: 85
A tape volume marked destroyed is found in the IBM Tivoli Storage Manager V6.3 Server. After auditing the volume, non-recoverable items are found? What is the next step to fix this problem?

A. check the tape out and send it to the manufacturer

B. restore the volume using the restore volume command 
C. issue a fix volume command to fix the destroyed areas 
D. delete the volume using delete volume discard data=yes

Answer: B 

QUESTION NO: 86
What should the installation planner consider when upgrading an IBM Tivoli Storage Manager (TSM) client to V6.3?

A. install both the server and client at the same time

B. upgrade the client to V6.3 before upgrading the server to V6.3
C. verify the new client level is supported by the current server level
D. upgrade the TSM Server first to V6.3 before upgrading the TSM client

Answer: C

QUESTION NO: 87
There is limited space for the activity log and it has to be pruned based on available space. Which command accomplishes this?

A. set actlogsize 12

B. set actlogsize 12 MB
C. set actlogretention 12
D. set actlogretention 12 mgmtstyle=size

Answer: D 

QUESTION NO: 88
The IBM Tivoli Storage Manager (TSM) V6.3 Server on AIX must be installed. The installation process will be performed using the dsmicfgx module. What is the benefit of the GUI installation method?

A. TSM OPT is set automatically

B. TSM Setup is set automatically.
C. TSM DB2 instance ID is set automatically.
D. TSM DB2 environmentals are set automatically.

Answer: D 

QUESTION NO: 89
Which two values for PASSWORDACCESS are correct inside an IBM Tivoli Storage Manager client option file? (Choose two.)

A. GRANT

B. DIRECT
C. PROMPT 
D. INDIRECT 
E. GENERATE

Answer: C,E 

QUESTION NO: 90
The IBM Tivoli Storage Manager (TSM) administrator is trying to log into a Windows TSM Server but it fails. What should be checked to correct the problem?

A. use telnet to open a TSM admin session to the TSM Server

B. check the TCP WindowSize in the dsmserv.opt and dsm.opt files
C. confirm the TSM Server process is running and check TCPPort in the dsm.sys file
D. confirm the TSM Server process is running and ensure the TCPPort matches the option files

Answer: D 

QUESTION NO: 91
A company has different network attached storage (NAS) filers. Some of them are NetAPP- systems, some are IBM N-Series and some are EMC Celerra. What must be configured to run a network data management protocol (NDMP) backup?

A. The data mover and storage pool must fit the appropriate dump format of the filer.

B. The data mover and storage pool can be defined generically with format NDMPDUMP.
C. The data mover must be defined with data format Netappdump for NetApp and N-Series and with NDMPDUMP for the rest.
D. For Celerra the data mover format must be Celerra dump, for N-Series it must be NDMPDUMP, and for NetApp it must be NETAPPDUMP.
Answer: A

QUESTION NO: 92
An IBM Tivoli Storage Manager installation has failed very early in the process. The administrator suspects this could t due to the deployment engine. Where would the administrator find information to confirm this?

A. DepEng.log

B. dep_engin.err 
C. DE_lnstall.log 
D. Engineroom.log

Answer: C 

QUESTION NO: 93
The IBM Tivoli Storage Manager V6.3 (TSM) Server is running but the expiration is running very slow. The process of the expiration has slowed down in three week intervals. What should be investigated?

A. The IBM DB2 reorganization is running every 21 days.

B. The IBM DB2 data optimizer is doing this work automatically.
C. Set the value db2set -i db2_parallel_io=*: 24 to gain maximum performance from the disk. D. The TSM IBM DB2 database directory must be divided into more than one directory path to gain maximum performance.

Answer: A 

QUESTION NO: 94
The IBM Tivoli Storage Manager V6.3 active log was defined. How is the log located and resized?

A. Use the administrative command line and issue the command set active log size.

B. Use the administrative command line and issue the command define active log size.
C. In the dsmserv.optfile, use the DB2LOGSIZE server option and the DB2LOGDIR server option.
D. In the dsmserv.optfile, use the ACTIVELOGSIZE server option and the ACTIVELOGDIR server option.
Answer: D 

QUESTION NO: 95
An IBM Tivoli Storage Manager (TSM) administrator has set up and enabled Disaster Recovery Manager. The administrator wants to keep offsite tapes in the vault 5 days after the data on the tapes has expired. What accomplishes this goal?

A. Set REUSEDELAY=5

B. Set OFFSITERECLAIM=5
C. SET DRMDBBACKUPEXPIREDAYS=5 
D. UPDATE VOLUME * access=offsite

Answer: A 

QUESTION NO: 96
An IBM Tivoli Storage Manager administrator wants to list all defined backup sets for the node LONDON for the past 6 months. Which command provides this information?

A. Query BACKUPSET * * BEGIN Date=-180

B. LIST BACKUPSET LONDON * BEGIN Date=TODAY-180
C. Query BACKUPSET LONDON * BEGIN Date=TODAY-180 
D. SELECT BACKUPSET LONDON * BEGIN Date=TODAY-180

Answer: C 

QUESTION NO: 97
Where is the most current IBM Tivoli Storage Manager V6.3 documentation found? 
A. operating system vendor

B. IBM Tivoli Storage Manager V6.3 Information Center website

C. IBM DB2 Universal Database V6.3 Information Center website
D. IBM Tivoli Storage Manager V6.3 Concepts - IBM Redbook publication

Answer: B 

QUESTION NO: 98
When backing up a very large IBM Tivoli Storage Manager database, which option could be specified on the command line to increase backup speed?

A. nums

B. numthr
C. threads
D. maxsession

Answer: A 

QUESTION NO: 99
Disaster Recovery Manager provides default settings for the preparation of the recovery plan file and for the management of offsite recovery media. Which command queries the recovery plan file settings?

A. query drmtable

B. query drmstatus 
C. query infostatus 
D. query dsmserv.opt

Answer: B 

QUESTION NO: 100
An administrator must restore the IBM Tivoli Storage Manager V6.3 database. Which file is required in addition to dbbackup?

A. dsm.opt

B. vothist.out
C. dsrnserv.opt 
D. devconfig.out

Answer: B