Re: Inclexcl help

2008-12-10 Thread Choudarapu, Ramakrishna (GTS)
nough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 12/10/2008 09:41:12 AM: > [image removed] > > Inclexcl help > > Choudarapu, Ramakrishna (GTS) > > to: > > ADSM-L > > 12/10/2008 09:43 AM > > Sent by: > > "ADSM: Dist

Inclexcl help

2008-12-10 Thread Choudarapu, Ramakrishna (GTS)
Hi, Here is the "q inclexcl" output for one of the nodes. The node is still attempting to backup the "/.../oradata/.../*.dbf" files. What is wrong with the inclexcl and how to stop /.../oradata/.../*.dbf from being backed up? tsm> q inclexcl *** FILE INCLUDE/EXCLUDE *** Mode Function Pattern (m

Re:

2008-11-25 Thread Choudarapu, Ramakrishna (GTS)
Farren, Haa, I was about to send you the same content...! That was an excerpt from "HELP DEFINE STGPOOL"... (refer to COLLocate option of DEFINE STGPOOL -- primary sequential access section). Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Beha

Define Clientaction

2008-10-15 Thread Choudarapu, Ramakrishna (GTS)
The DEFINE CLIENTACTION command runs as DEFINE CLIENTACTION * domain=* action=incremental as default parameters. We had an instance where all the clients started their incrementals when a DEFINE CLIENTACTION (with no parameters) was run accidentally... Is this command syntax reasonable? Regards,

Re: select statement to detail a filespace

2008-08-13 Thread Choudarapu, Ramakrishna (GTS)
http://www-1.ibm.com/support/docview.wss?rs=1019&context=SSSQWC&context= SSGSG7&q1=ACTIVE+Data+pool+size&uid=swg21267260&loc=en_US&cs=utf-8&lang= en Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: Wednesday, August 13,

Re: select statement for active sessions based on policy domain

2008-06-04 Thread Choudarapu, Ramakrishna (GTS)
select session_id,client_name from sessions where session_type='Node' and client_name in (select node_name from nodes where domain_name='DOMAIN_NAME') -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: Tuesday, June 03, 2008 4:48 PM To:

Re: CHECKIN problom

2008-05-21 Thread Choudarapu, Ramakrishna (GTS)
Jeff, May be SHOW SLOTS lib-name would get you more information on your problem... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jeff White Sent: Wednesday, May 21, 2008 9:19 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] CHECKIN pro

Re: Speeding up my SQL query

2008-05-16 Thread Choudarapu, Ramakrishna (GTS)
Richard meant to say to update ur query to: select - actlog.nodename as "Node Name", - substr(char(actlog.date_time), 1, 16) as "Date/Time", - substr(actlog.message, 26) as "Message" - from actlog,nodes - where - actlog.nodename=nodes.node_name - and actlog.msgno in (4005,4007,4018,40

Re: Speeding up my SQL query

2008-05-16 Thread Choudarapu, Ramakrishna (GTS)
Eric, Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME and ENDTIME parameters, which may be faster than the select, but the resluts may not be as straight and detailed as your select... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL