Hi Del!
That's clear, but I found no way to overrule the NODENAME, which is
specified in the option file, through the GUI. How can one do that?
Thank you very much for you reply!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-Original Message-
From: Del Hoobler [mailto:[EMAIL
Hallo TSMers,
I think I've mentioned before, my SQL's not so hot. I'm practising all I
can, although, I can't seem to crack this one, or others like it;
I would like to find out (with SQL if possible, I could do it via script
etc.. easy enough) ;
For every stgpool that has a device class of
Hi All,
Why is't only the full version of TDP SQL backup,
there is deleted after expiration???
All the log backups, 30 days back, is still available, when I query the TSM
server.
The full exist version match the MC - 15 1 15 60.
TSM server z/os version until last monday 5.1.6.5 now 5.2.1.3,
TDP
Hi Matt!
Im not sure what you looking for.
But maybe this helps you...
Replace YOUR LTOCLASS NAME with the real Device class name.
select stgpool_name,count(*) as Maxscratch from volumes where
devclass_name='YOUR LTOCLASS NAME'
/Christian
-Ursprungligt meddelande-
Fran: ADSM: Dist
Hi Christian,
Sorry, I may not have worded my problem very clearly. Using the
follwing tables and columns;
TABLENAMECOLNAME
-- --
STGPOOLS STGPOOL_NAME
STGPOOLSDEVCLASS
STGPOOLS MAXSCRATCH
Eric,
The only way I've found to do this is to create another options file for
each sql node that needs to be restored. Then enter TDPSQL with the
/tsmoptfile= switch. For example:
On nodea:
dsm_nodeb.opt
...
nodename nodeb_sql
...
Create a shortcut for your users with an appropriate name
Hi Matt!
I try your last select command but just only add stgpools.maxscratch in
the end of your line.
select stgpools.stgpool_name, stgpools.maxscratch,count(*) from
volumes,stgpools where volumes.stgpool_name in (select stgpool_name from
stgpools where devclass='ULTRIUM1') group by
Hello,
can anybody tell me where to find interesting information about nearline
storage.
Is anybody using nearline storage for novell by tsm?
TSM = Novell
Thx,
Peter Schrijvers
BASF-IT-Services NV
I'm about to restore a tsm database from one physical site to
another. Now on the source/current site the tsm and database log volumes
are on AIX raw logical volumes/lv's/non-fs. Now I want to restore this
database to the target tsm server at the target site. I assume that all I
have to do
Thanks for the help :-), although the volumes count (unnamed[3] in your
example output) is a total volume count, rather than a count of the
volumes in that storage pool.
But.. as I was reading your reply a friendly DBA came over with this
piece of SQL;
select
You can use raw devices for DB, log or stg volumes and there is
no dsmserv format command needed. Just create the raw devices and then
start to use them. No long wait to do format them...
Ben
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
We have a situation where we are trying to use a single node name to
access two differerent servername stanzas in dsm.sys. Both stanzas
specify passwordaccess generate and use the same tcpserveraddress.
This works fine until the password is automatically updated. Apparently
there is a different
Not sure if you noticed or not...
you are trying to select columns in the stgpool table from the volumes table.
select stgpools.stgpool_name, stgpools.maxscratch, count(*) from volumes where
stgpool_name in (select stgpool_name from
stgpools where devclass='ULTRIUM1') group by stgpool_name
try
Thank you very much for the ideas on how to tackle this. Group admins would
work best in our environment.
On 1/15/04 1:54 PM, Prather, Wanda [EMAIL PROTECTED] wrote:
The userid is not part of the client definition. (If you don't believe me,
try: q node xxx, f=d).
When you specify a
Hi
what issue with drive state =UKNOWN ?
all checkin and checkout operations failed
(TSM V5.1 library 3583)
please help me
b.rds
Joseph
*
Ce message et toutes les pieces jointes (ci-apres le message) sont
confidentiels et
Mohan!
Just to verify that your registry password has not expired, can you go
to the command line and from the TSM prompt do:
tsm q fi
If it prompts you for a password or comes back with an error that would
at least get this piece out of the way.
HTH
-- Aamir
Subbu, Mohan (OFT) wrote:
One
David!
On UNIX clients there is a PASSWORDDIR directive which can be used in
the dsm.sys to specify the location of the generated password. That way
you will have files of your choice to store the generated password as
opposed to using the default /etc/adsm/TSM.PWD file.
HTH
-- Aamir
David E
I'm probably missing something obvious, but I can't figure out how to
retrieve a file to a new directory while retaining the full path name,
when the beginning of the path name is a mount point. (I don't know if
my terminology is right--I'm new to the unix world).
For example, I want to retrieve
Hi,
I am taking backup from tdp client of Oracle database,RMAN type should be sbt_tape?
is it possible to I can specify type DISK.I want backup should go to diskpool and then
data should migrate to tapepool.My copygroup- copy distination is pointing
diskpool,but at the time of backup,it is
You can set it type DISK but you will not get the results that you desire.
Rman has no concept of TSM diskpool vs. tape - if you were to use type
DISK the backup would go to your local disk (probably not what you want).
I would recheck your management class settings for Oracle backups and make
I have two mgmt class in one policy domain,one is use for tdp for oracle(1,0,0,0)other
mgmt is use for backup-archive client(7,1,60,90).
If I change copygroup copy destination to tapepool,tdp backup works fine.but if i
points it to diskpool,it still looks for tape and backup dont go on diskpool.
21 matches
Mail list logo
