Re: how to tell how my DB is being backed up

2008-04-01 Thread Choudarapu, Ramakrishna (GTI)
DB backup is normally done using admin schedules. Check with Q SCHED T=A F=D, you may find an admin sched which runs BACKUP DB command. Q VOLHIST T=DBB will display the database backup volumes. Q DB F=D will indicate when the last backup of DB was taken and how much of DB was changes since the las

Re: Getting rid of ghost REMOTE volumes

2008-03-05 Thread Choudarapu, Ramakrishna (GTI)
delete volhist todate=today type=remote vol=volname force=yes -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Wednesday, March 05, 2008 12:34 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Getting rid of ghost REMOTE volumes

Re: Question on TSM environment sizes

2008-02-07 Thread Choudarapu, Ramakrishna (GTI)
And how many TSM admins? How many tape/library alerts/pages a night?!?!? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sean English Sent: Wednesday, February 06, 2008 4:11 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Question on TSM environment si

Re: change copy destination

2008-02-05 Thread Choudarapu, Ramakrishna (GTI)
Please check the help of these commands: VALIDATE POLICYSET ACTIVATE POLICYSET -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Tuesday, February 05, 2008 12:05 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] change copy destination He

Re: Select statement

2008-01-04 Thread Choudarapu, Ramakrishna (GTI)
We use this to find out the scratch counts: select library_name, status, count(*) as VOL_COUNT from libvolumes group by library_name,status Is this the one, you are looking for? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ribeiro, Ricardo Sent:

Re: Versions Data Exist

2007-12-14 Thread Choudarapu, Ramakrishna (GTI)
Avy, There is no direct way of finding a node's management class bindings, as it is defined at the client's include-exclude list. Also, A node's data can be bound to multiple management classes. Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On B

Re: ANR8314E Library is Full Error

2007-12-07 Thread Choudarapu, Ramakrishna (GTI)
Mel, In case it needs to run an AUDIT LIBRARY, would it be with CHELKLABEL=YES or CHECKLABEL=BARCODE? Because, CHECKLABEL=YES may take hours to complete the audit as it mounts and checks the label of each volume... -Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PRO

Exporting the backupsets

2007-10-11 Thread Choudarapu, Ramakrishna (GTI)
Hi All, We were creating the backupsets using virtual volumes on z/os environment. Now, while migrating to z/linux, we are trying to export the backupset nodes... The source server reports that: 10/11/2007 05:17:05 ANR0986I Process 5 for EXPORT NODE running in the BACKGROU

Move data from a dbb vol

2007-10-11 Thread Choudarapu, Ramakrishna (GTI)
Hi All, How can I move the data off a DBB volume (not delete)? I have a volume listed under Q VOLHIST T=DBB, which I need to scratch. Thanks, Rama This message w/attachments (message) may be privileged, confidential or proprietary, and if

Re: Query actlog

2007-10-11 Thread Choudarapu, Ramakrishna (GTI)
Q ACTLOG can be searched using MSGno, Search string, nodename, client or server originated messages, by domain/sched/session... If you wish to search by multiple strings, I think it is better to dump it to a file and play around using your string handling capabilities... Cheers, Rama -Origina

Re: Volumes Private

2007-10-10 Thread Choudarapu, Ramakrishna (GTI)
Check the REUSEDELAY parameter on your storagepool. Set it to 0 if you wish to scratch your volumes immediately. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Boyer Sent: Tuesday, October 09, 2007 4:48 PM To: ADSM-L@VM.MARIST.EDU Subject: R

Deleting libvols from library manager

2007-08-03 Thread Choudarapu, Ramakrishna (GTI)
We have configured a TSM server as the library manager for the 3494 library and another TSM server as its client... While testing the setup, the library client had some private volumes and then crashed. Unfortunately, we didn't have the database backup and were forced to rebuild the library client

Re: TSM DB backup question

2007-07-26 Thread Choudarapu, Ramakrishna (GTI)
Help on UPDATE DEVCLASS -- FILE says about MAXCAPacity: "The value specified should be less than or equal to the maximum supported size of a file on the target file system." Check whether this condition is met... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[E

Re: Volumeusage plus occupancy equals shrug?

2007-07-19 Thread Choudarapu, Ramakrishna (GTI)
Dump the Q NODEDATA results for all the candidate nodes to a file and search for T9... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Thursday, July 19, 2007 12:32 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L]

Multi-session Backup

2007-06-22 Thread Choudarapu, Ramakrishna (GTI)
Hi All, What is the criterion to make sure that the backup will go to multiple tapes simultaneously...? We hv an AIX client with many large files to be backed up. Resourceutil=6, maxnummp=4, but the backup is not writing not more than 2 or 3 tapes in parallel. TIA, Rama

Re: TSM Error Log path:

2007-06-01 Thread Choudarapu, Ramakrishna (GTI)
The errorlogretention option specifies how many days to maintain error log entries before pruning, and whether to save the pruned entries. Place this option in the client options file (dsm.opt). ERRORLOGRetention 7 Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[

Re: Command-line admin client for windows question

2007-03-16 Thread Choudarapu, Ramakrishna (GTI)
dsmadmc.exe -tcpserveraddress=xxx.xxx.xxx.xxx -tcpport=150x -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lee, Gary D. Sent: Friday, March 16, 2007 10:27 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Command-line admin client for windows question

Re: Another probably newbie question!

2007-03-01 Thread Choudarapu, Ramakrishna (GTI)
Have you set MIGDelay (Migration Delay) for PACS_DISK_POOL (Q STG PACS_DISK_POOL F=D) to a value greater than 0? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Angus Macdonald Sent: Thursday, March 01, 2007 6:12 AM To: ADSM-L@VM.MARIST.EDU Subject:

Re: Recovery Log Pinned

2007-02-07 Thread Choudarapu, Ramakrishna (GTI)
al Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stapleton Sent: Wednesday, February 07, 2007 12:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Recovery Log Pinned From: ADSM: Dist Stor Manager on behalf of Choudarapu, Ramakrishna (GTI) We had a re

Recovery Log Pinned

2007-02-07 Thread Choudarapu, Ramakrishna (GTI)
Hi All, We had a recovery log pinning problem and the log was growing since last 4 days and currently is at 72% util... TSM Server 5.3.3.0 running on z/OS. Below is the SHOW LOGPINNED output: tsm>show logpinned Dirty page Lsn=1463720.82.404, Last DB backup Lsn=1463720.117.3419, Transaction table

Re: Getting and using time values with sql

2007-01-31 Thread Choudarapu, Ramakrishna (GTI)
Gary, How you are planning to run the script? If it is through an Admin Schedule, the schedule can be controlled based on time... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lee, Gary D. Sent: Wednesday, January 31, 2007 8:03 AM

Re: exporting scripts

2007-01-25 Thread Choudarapu, Ramakrishna (GTI)
Looks great! But where is it documented? I do not see f=macro on HELP QUERY SCRIPT!!! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: Thursday, January 25, 2007 12:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting

Re: Criteria for full DBbackup

2007-01-16 Thread Choudarapu, Ramakrishna (GTI)
Was the DB has been EXTENDed or REDUCEd? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Markus Engelhard Sent: Tuesday, January 16, 2007 8:28 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Criteria for full DBbackup Hi all, just a quick one we ju

Re: setting up TDPO / newbie help

2006-11-13 Thread Choudarapu, Ramakrishna (GTI)
Goran, What are the contents of your tdpo.opt, dsm.opt and dsm.sys? Also, where are they placed? Seems, there is some inconsistency in the option file path, while looking at the line in tdpoerror.log: "11/13/2006 14:41:34 TID<778564> ==> ANU2615E Options file '/usr/tivoli/tsm/oracle/bin64/tdpo.

Re: Actlog file location

2006-10-31 Thread Choudarapu, Ramakrishna (GTI)
QUERY ACTLOG Try HELP Q ACTLOG, for syntax... Regards, Ramakrishna -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: Tuesday, October 31, 2006 6:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Actlog file location Hi K

Re: Finding Volume Names

2006-10-12 Thread Choudarapu, Ramakrishna (GTI)
Srinath, SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='your_node' Regards, Ramakrishna -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: Thursday, October 12, 2006 10:41 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Finding

Re: Select Statement Syntax to view the schedule

2006-10-05 Thread Choudarapu, Ramakrishna (GTI)
Srinath, SELECT * FROM CLIENT_SCHEDULES SELECT * FROM ADMIN_SCHEDULES Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: Thursday, October 05, 2006 10:33 AM To: ADSM-L@VM.MARIST.EDU Subject

Re: Select Statement Syntax

2006-10-05 Thread Choudarapu, Ramakrishna (GTI)
dsmadmc -se= -id= -pa= -commad -outfile= select node_name,filespace_name,date(backup_start) as start_date,time(backup_start) as start_time,date(backup_end) as end_date,time(backup_end) as end_time from filespaces where node_name like 'NAS%' or node_name like 'SERVER%' Regards, Rama -Origi

Re: Select statements

2006-09-28 Thread Choudarapu, Ramakrishna (GTI)
Q EVENT * * Or the one provided by Stephen early today: select client_schedules.schedule_name,client_schedules.action,client_schedules. star ttime,associations.node_name - from client_schedules,associations where client_schedules.schedule_name=associations.schedule_name Regards, Rama -Ori

Re: TSM with SAN 5.3

2006-09-22 Thread Choudarapu, Ramakrishna (GTI)
This should help you: www.redbooks.ibm.com/redbooks/pdfs/sg246687.pdf Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Murugan_Pachamallayan Sent: Friday, September 22, 2006 4:55 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM with

Backing up Veritas Cluster using TSM

2006-08-25 Thread Choudarapu, Ramakrishna (GTI)
Hi All, Please share your experiences on backing up a Veritas Cluster client on Solaris to TSM. Also, any suggested readings... Thanks, Rama If you are not an intended recipient of this e-mail, please notify the sender, delete it and do n

Re: backup schedule question?

2006-08-04 Thread Choudarapu, Ramakrishna (GTI)
Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] **** "Choudarapu, Ramakrishna (GTI)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/03/2006 01:10 PM Please

Re: primary and copy storage pool comparisons

2006-08-04 Thread Choudarapu, Ramakrishna (GTI)
select stgpool_name,sum(num_files) as total_files, sum(logical_mb)as total_logical_mb from occupancy group by stgpool_name Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Whitlock, Brett Sent: Thursday, August 03, 2006 5:09 PM To: ADSM

Re: backup schedule question?

2006-08-03 Thread Choudarapu, Ramakrishna (GTI)
Use SCHEDStyle=Enhanced and DAYofweek=M,W,F Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Thursday, August 03, 2006 12:51 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] backup schedule question? Hey Everyone! I nee

Re: q event question

2006-07-10 Thread Choudarapu, Ramakrishna (GTI)
Luc, Try using a filter to exclude the schedule name, $ cat clientdone.txt|grep -v "schedname_to_be_excluded" > clientdone_new.txt (for unix) OR C:\> type clientdone.txt|find /v "schedname_to_be_excluded" > clientdone_new.txt (for windows) Thanks & Regards, Ramakrishna Choudarapu GTI

Re: weird quotes in script problem ...

2006-06-29 Thread Choudarapu, Ramakrishna (GTI)
Arnaud, Try this way: run new test_server 1 '/script/sap_inf_backup.sh ""PFR PAC PLC"" 1' But, your script should be only the first three lines. i.e, def scr test_1 upd scr test_1 'issue message i "variable 1: $1"' line=015 upd scr test_1 'issue message i "variable 2: $2"' line=010 upd scr test

Re: SQL Help

2006-06-05 Thread Choudarapu, Ramakrishna (GTI)
Bill, Try this instead: select * from summary where activity like 'BACKUP' and entity like 'DOCCM_DB2' and (current_timestamp - start_time) <= 72 hours Thanks & Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill

Re: Find what tape a particular backup resides on

2006-03-22 Thread Choudarapu, Ramakrishna (GTI)
SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name' Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, March 22, 2006 10:05 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Find what tape a particu

Re: schedule issue

2006-03-08 Thread Choudarapu, Ramakrishna (GTI)
Ashok, Please refer to SCHEDStyle=enhanced in Admin's Reference. Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vats.Ashok Sent: Wednesday, March 08, 2006 11:49 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] schedule issue I

Re: AW: [ADSM-L] Automating server scripts

2006-02-14 Thread Choudarapu, Ramakrishna (GTI)
Wait=yes option is not valid with "run" command. This can be used along with BACKUP/MIGRATE/RECLAIM STGPOOL commands. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Tuesday, February 14, 2006 9:06 AM To: ADSM-L@VM.MARIST.EDU Su

Re: Reporting Tool - Elapsed Time

2006-02-09 Thread Choudarapu, Ramakrishna (GTI)
A schedule can be associated with multiple nodes. Hence, one can rather attempt SELECT * FROM SUMMARY which may be filtered on SCHEDULE_NAME or ENTITY(node) and the elapsed time may be calculated using the start_time and end_time. Or Try processing the ANR2507I message from actlog: ANR2507I Sch

Re: AW: [ADSM-L] Automating server scripts

2006-02-08 Thread Choudarapu, Ramakrishna (GTI)
Multiple scripts inside an admin schedule? I believe each schedule can contain one cmd/script... You may have to create multiple schedules, one for each server script. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Wednesday,

Re: AW: [ADSM-L] Import Node

2006-02-06 Thread Choudarapu, Ramakrishna (GTI)
the import command and everything went fine. Thomas -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Choudarapu, Ramakrishna (GTI) Gesendet: Montag, 06. Februar 2006 14:08 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] Import Node Hi All, We are

Import Node

2006-02-06 Thread Choudarapu, Ramakrishna (GTI)
Hi All, We are trying an IMPORT NODE which is estimated to complete in 15 days. In case, the process is broken intermittently due to any reason (server recycled), Do we need to re-run the IMPORT with all the input tapes OR we can skip the tapes that were already processed? Thanks, Rama --

Re: redirect output in readable format

2006-01-31 Thread Choudarapu, Ramakrishna (GTI)
Dave, You can try -commad (or -tabd) -dataonly=YES options alongwith you $TSMCMD. Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: Tuesday, January 31, 2006 8:28 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] redire

Re: Concurrent primary and copy pool backup

2006-01-04 Thread Choudarapu, Ramakrishna (GTI)
Please refer to COPYSTGPOOLS option in HELP UPDATE STGPOOL. Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Levi, Ralph Sent: Wednesday, January 04, 2006 8:13 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Concurre

Which script is running?

2005-12-02 Thread Choudarapu, Ramakrishna (GTI)
Hi All, How to identify which server script(s) are currently running on TSM server? And, How to stop a running script? Regards, Rama If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read,

Encryption Question

2005-11-08 Thread Choudarapu, Ramakrishna (GTI)
While restoring a file from an encrypted backup, How does the authentication of the encryption key password takes place? And where does the encryption key password read from? Could anybody please suggest some docs/links which elaborate the TSM encryption/decryption process? Thanks & Regards, Rama

Re: Encryption Question

2005-11-04 Thread Choudarapu, Ramakrishna (GTI)
encryption. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Choudarapu, Ramakrishna (GTI) Sent: Friday, November 04, 2005 11:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Encryption Question HI All, When "ENCryptkey Save" option is used, as the p

Encryption Question

2005-11-04 Thread Choudarapu, Ramakrishna (GTI)
HI All, When "ENCryptkey Save" option is used, as the password is stored in the registry, does the same encryption key password is taken for all the backups performed on the filespace mentioned at include.encrypt? Thanks, Rama If you are n

Re: Question regarding Administration user ADMIN_CENTER

2005-09-29 Thread Choudarapu, Ramakrishna (GTI)
I got this from : Tivoli Storage Manager Administration Center: Frequently Asked Questions When you install a Tivoli Storage Manager Version 5.3 server, an administrator named ADMIN_CENTER with the password ADMIN_CENTER is automatically created. The health monitor uses this administrator to access

Re: Dual write to multiple copy storage pools

2005-09-06 Thread Choudarapu, Ramakrishna (GTI)
copy storage pools When using simultaneous write to backup to primary pool and multiple copy pools. The initial backups does not go to primary and copy pools at the same time correct? "Choudarapu, Ramakrishna (GTI)" wrote: > Instead, Please have a look at DEF STG or UPD STG with

Re: Dual write to multiple copy storage pools

2005-09-02 Thread Choudarapu, Ramakrishna (GTI)
You can write to 1 primary *and* upto 10 copy storage pools concurrently. Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stapleton, Mark Sent: Friday, September 02, 2005 9:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re:

Re: Dual write to multiple copy storage pools

2005-09-02 Thread Choudarapu, Ramakrishna (GTI)
Instead, Please have a look at DEF STG or UPD STG with COPYSTGpools option which allows you to write backup to primary pool and multiple copy pools simultaneously. Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jon E

Re: server 5.1.9.0 rec log problem - multiple servers?

2005-08-23 Thread Choudarapu, Ramakrishna (GTI)
This could be because of the typo: dsmserv extend log extrareeclogspace 8000 Correct it to: dsmserv extend log extrareclogspace 8000 Regards, Ramakrishna Choudarapu -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Lazarevich Sent: Tuesda