ECTED] Behalf Of
Richard Sims
Sent: Sunday, 6 March 2005 1:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: LTO Volume
Akash -
I term this "Tape leak", as I summarize in
http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of
this about 6 months ago on ADSM-L. One member was pursu
ACCESS: READWRITE
LAST_WRITE_DATE: 2005-03-08 05:57:28
Regards
Akash
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Richard Sims
Sent: Sunday, 6 March 2005 1:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: LTO Volume
Akash -
I term this "Tape
Yeah thanks guys. 8mb did the trick.
I've just been trying out some of these things as the pass by, see if
they're any use to me.
One thing I'm struggling on just now is:
I've got an NDMP job scheduled for our NetApp filers:
The monthly is a full backup, I've got:
versions data exists 12
versio
Hi Iain
tsm: ABZBKUP001>SELECT STGPOOL_NAME AS "STORAGE POOL ",
-
cont> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", -
cont> DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
"ACCESS", -
cont> LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE" -
Cheers Andy, I just kinda thought that what you'd put would work. I
never realised there were variables that might need
adjusting.
Anyway, Richard Sims was good enough to point out that the dec value
should be increased.
Regards,
Iain Barnetson
IT Systems Administrator
UKN Infras
If you look up message ANR2948E, it will tell you what the trouble is. You
can either look it up in the Messages manual, or type "HELP ANR2948E" (or
just "HELP 2948") from the Admin CLI.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail
Richard,
Sorry.
The error msg was:
tsm: ABZBKUP001>SELECT STGPOOL_NAME AS " STORAGE POOL ",
CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PC
T UTIL", DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
"ACCESS", LEFT(CHAR(LAST_WRITE_DATE),19)
AS "LAST_WRITE_DATE" FROM VOLUMES WHERESTA
Good suggestion, Andreas, now that we're getting into "terrorbytes".
thanks, Richard Sims
On Mar 7, 2005, at 8:28 AM, Andreas Priebe wrote:
Hi Richard,
The Select is tried-and-true, and works well.
On one of my TSM servers it gives me an SQL error due
to the formmating:
ANR2948E The value '381468
Hi Richard,
The Select is tried-and-true, and works well.
On one of my TSM servers it gives me an SQL error due
to the formmating:
ANR2948E The value '381468.0' can not be assigned or converted to SQL
data type
DECIMAL(6,1).
|
V.
On Mar 7, 2005, at 6:25 AM, Iain Barnetson wrote:
Ruichard,
I tried the SQL query below that you gave, but got an error "where
status='filling'" at the '=' bit
And the error was... ?
The Select is tried-and-true, and works well.
Perhaps you tried to string the whole command out on one line,
rather
Ruichard,
I tried the SQL query below that you gave, but got an error "where
status='filling'" at the '=' bit
Regards,
Iain Barnetson
IT Systems Administrator
UKN Infrastructure Operations
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard S
Akash -
In analyzing problems, get into the habit of acquiring the complete
information available about the ingredients of the problem scenario so
that it becomes more understandable. In this case, problem analysis is
handicapped by not employing the Format=Detailed option of Query
commands, in par
ailto:[EMAIL PROTECTED] Behalf Of
Richard Sims
Sent: Sunday, 6 March 2005 1:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: LTO Volume
Akash -
I term this "Tape leak", as I summarize in
http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of
this about 6 months ago on ADSM-L. On
Akash -
I term this "Tape leak", as I summarize in
http://people.bu.edu/rbs/ADSM.QuickFacts . We had a good discussion of
this about 6 months ago on ADSM-L. One member was pursuing it with IBM
as a problem.
For administration at my site, I created a macro called "filling",
which does the follo
14 matches
Mail list logo
