I have had to redefine all the paths to drives & from storage agents to
each drive in the past, when I get reservation conflicts it generally
takes a path offline for that server, I found that running tapeutil -f
/dev/rmtx reset would reset the state of the device at the o/s level
then removing and
Hi,
I need to restore a hugh number of files. I would like to give the TSM client a
list with the filenames.
Does somebody know if "dsmc restore -filelist " will replace the
existing files? That what I need to do in
this case.
Thanks
On Jun 4, 2010, at 6:01 AM, Alexander Födisch wrote:
> Hi,
>
> I need to restore a hugh number of files. I would like to give the TSM client
> a list with the filenames.
> Does somebody know if "dsmc restore -filelist " will replace the
> existing files? That what I need to do in
> this case.
I am trying to download the latest fixpack for TDP for SQL, but the given link
to the ftp site doesn't exist.
ftp://public.dhe.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v554
The latest entry is v553.
Is there any other place to download it ?
Regards,
T
On Jun 3, 2010, at 10:59 PM, M KIRAN KUMAR wrote:
> Can u tell me if we export a node directly to a server will that exported
> node be visible in the client node list with file spaces on the target
> server for data retrivals?
Providing that the export-import was successful, the target server sh
Hi TSM-ers!
I'm trying to create a SQL query to check whether all Oracle files
(Oracle databases are backed up by the TDP client) are excluded from the
standard BA client backup.
Our database admins recommends the follow exclude statements to be added
to the BA client:
/mount/data*/ora_*/log
/moun
We've had some similar type problems, althought not that bad!
At times it's as through someone (aix, san, lib/drives) looses track of
things and starts fighting itself. It showed up as mount failures, reserve
conficts, and lib manager hanging. We never did figure out what happened
or why, but I
I worked with Eric on this. In case anyone else runs into similar...
File system directory and file names may well contain underscore (_)
characters, which is fine. What may not be realized, however, is that in a
Select LIKE, an underscore is a wildcard for any single character.
An example of
Wow... Richard, respect!
This one works, you again saved my day
Here is the final working statement, so it's 'logged' on the ADSM-L
list:
select node_name, filespace_name, hl_name, ll_name from backups where
(upper(ll_name) like '%LOG%' or upper(ll_name) like '%ARCHIVE%' or
upper(ll_name) like
Ow.
Richard, do you know if it works this way still in V6?
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Richard Sims
Sent: Friday, June 04, 2010 10:36 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement
I worked with Eric on thi
On Jun 4, 2010, at 10:41 AM, Prather, Wanda wrote:
> Ow.
> Richard, do you know if it works this way still in V6?
Hi, Wanda -
We remain a v5 shop, pending a lot of infrastructure decisions to be made by a
new VP, so I haven't that experience. I would expect DB2 to be much more
conformant to
Hello,
Could anyone provide me a sql statement which can check if any copy storage
pool volume is mounted in tape drive at the moment? I need this to configure
script for my DRP.
Thanks in advance.
--
Best Regards
Ashish Sharma
ST Microelectronics Ltd.
919717003853
Connecting directly to DB2:
Database Connection Information
Database server= DB2/AIX64 9.7.1
SQL authorization ID = TSMTEST1
Local database alias = TSM1
select tabschema,tabname,owner from syscat.tables where
tabname='STGPOOLS'
TABSCHEMA
TABNAME
OWNER
--
Storage Management Server for AIX - Version 6, Release 2, Level 0.0
(AIX v5.3)
tsm: TSMTEST1>select stgpool_name from stgpools where stgpool_name like
'%\_%' escape '\'
STGPOOL_NAME
TEST_POOL
tsm: TSMTEST1>select stgpool_name from stgpools where stgpool_name like
Ooh, cool! Thanks!
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Cowen, Richard
Sent: Friday, June 04, 2010 11:31 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] SQL statement
Connecting directly to DB2:
Database Connection Information
You don't say of ALL tape drives are refusing to mount, or if only
certain ones are experiencing the problem.
The "Reservation conflict" is the interesting part. Rick talked about
deleting all the devices, and recreating everything, but it may just
turn around and happen again if you don't get to
You don't say what type of drives; but check that when the library firmware was
upgraded, the drive firmware was upgraded to a compatible level. Rare, but
I've seen cases where mismatched library/drive firmware will cause weird
behavior.
-Original Message-
From: ADSM: Dist Stor Manage
-Ashish Sharma wrote: -
>Could anyone provide me a sql statement which can check if any copy
>storage pool volume is mounted in tape drive at the moment? I need
>this to configure script for my DRP.
select volume_name from drives where volune_name in
(select volume_name from stgpools wh
Wanda,
I almost mentioned that too, but since IBM service did the upgrades
of the library, I sort of assumed they would check the drive firmware,
too. But maybe not all of IBM's CEs are as thorough as the one we have.
I also thought of another strange circumstance that caused a simila
> mount. But if Library Client's tape paths are in error, and his path
> definition for DRIVE1 is actually pointing to the logical device for
> DRIVE2, and DRIVE2 is already in use by somebody else, he will get an
> error trying to open DRIVE2, and that will cause a Reservation Conflict.
>
> S
Richard,
"dyntrk" is set to "no" on our systems. I am not familiar with this
setting; what does this have to do with this problem?
And I have always been told that SANDISCOVERY should be NO on AIX.
Of course, things like that change, and I remember reading an APAR where
the default set
21 matches
Mail list logo
