All problems went away as soon as we began to let DSMCAD
start the scheduler.
Regards
Thomas Rupp
Hallo,
I am using the following select statement;
select entity,((sum(bytes)/1024)/1024) as MB from summary where entity
in (select node_name from nodes where domain_name like 'DM%') and
start_time>timestamp(current_date - 1 days) and activity='BACKUP'
group by entity
I would
Hi Matthew,
something like this may help you:
where cast((current_timestamp - start_time)hours as integer) <= 4
Cheers,
Paul.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Warren, Matthew (Retail)
Sent: 08 January 2004 11:24
To: [EMAIL PROTECTE
Hi Guys
Would like to know if anyone has seen or wriiten a SQL Query in TSM to get info
relating
to what management class, node name, cart/tape, how much of data for each node has
been backed up.
The info much be joined together for each node within TSM.
I require for example :
nodenam
Query I use this for an events report that need a window of time, maybe you could use something like this;
Q EV * * BEGIND=TODAY-1 ENDD=TODAY BEGINT=04:00 -
BEGINT=16:00 ENDT=07:30 -
F=D
Shannon
Madison Gas & Electric Co.
Operations Analyst - Data Center Ser
Here is a query to get all volumes used by 1 node :
select distinct -
cast(volumeusage.volume_name as char(6)) as Volume, -
cast(volumes.est_capacity_mb as decimal(6,0)) as "Capacity",-
cast(volumes.pct_utilized as decimal(4,1)) as "% used", -
cast(volumes.status as char(7)) as Sta
To automate it if you have many tsm client backup schedulers on the same
server you can use the: "mkssys" command to setup a subsystem, this way you
can use the: "startsrc" and "stopsrc" commands to get the schedulers
started and stopped. Thanks!.
--Justin Richard Bleistein
Unix/TSM Systems Admini
Thanks for the replies, although it has now become a fairly pointless
exercise as large swathes of client backup info seems not to be logged
in the summary table...
Dsmaccnt.log it is then...
-Original Message-
From: Shannon Bach <[EMAIL PROTECTED]>@EME
This works...
...and start_time>current_timestamp- 4 hours
-Original Message-
From: Warren, Matthew (Retail) [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 5:24 AM
To: [EMAIL PROTECTED]
Subject: timestamps in select
Hallo,
I am using the following select sta
Hello everybody,
I try to configure a tsm-server running with a non-root user-id.
It's TSM 5.1 with a 3494 library shared from another TSM 5.1 library manager
Starting dsmserv as non-root the server crashes with a core when
trying to make a database backup.
With starting dsmserv as root this works
...
>ANR0252E Error writing logical page 250880 (physical page 251136) to
>database volume /tsm/volumes/o00tsmtoe2-
>/stg01/dbvol00b.TSMTOFF00.
>ANRD Error writing to database logical volume.
>ANR7838S Server operation terminated.
>ANR7837S Internal error BUF087 detected.
Paul - The probably r
This isn't exactly a solution but I have the very same problem as yourself
in finding the best way of doing this, and as you have pointed out, there is
no easy way that we have found. It is lookin very much like we will have to
make our TSM service unavailable for a "long-weekend" to be able to car
Try EXPORT.
You can specify all data, or only ACTIVE data.
It has NO impact on your TSM DB, as an archive will.
And you don't have to move the data across the network again.
You can re-import it to ANY TSMDB, not necessarily the one you have now.
You can specify more than 1 client per EXPORT com
...
>What I want to do is to take an snapshot of our TSM data as it was at end
>of year 1/1/04 and archive it away for 10 years. ...
This kind of requirement begs a lot of questions, as it tends to be one of those
very vague management ideas which receives too little thought from the decision
make
Am I right in finding that backup data transferred via a lan-free backup
does not show up in the dsmaccnt.log in field 17, total number of backup
data in kilobyes sent to the tsm server?
Thanks,
Matt.
___ Disclaimer Notice __
This message and any
Thanks to all that responded including Justin, Thomas, Dan, Wanda,
Steven, Patrick, Dave, Matthew, David, and Bob. Sorry if I missed anyone.
The solution I needed and used for now is:
nohup dsmc sched /dev/null 2>&1 &
It is already setup to start on reboot, but I just couldnot seem to
I should stick with what the FAQ tells me to do :-)
Searching the archives I see it is kept on the client for lan-free.
Matt.
-Original Message-
From: Warren, Matthew (Retail)
Sent: Thursday, January 08, 2004 4:01 PM
To: 'ADSM: Dist Stor Manager'
Subject: dsmaccnt.log and lan-free trans
Matt,
You have to enable accounting on the storage agent and then look it's
dsmaccnt.log file.
Bill
"Warren, Matthew (Retail)" <[EMAIL PROTECTED]>@VM.MARIST.EDU>
on 01/08/2004 11:01:25 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by:"ADSM: Dist Stor Manager"
Hi,
I have exactly the same problem but my environment is a little different:
TSMSERVER - 5.2.1.2 on Windows 2000 server
TDP for Exchange - 5.1.5
Exchange 5.5
TSM BA Client and API - 5.2.0.6
Any help will be appreciated.
Thanks / Regards
Henry Aranda
Hi All,
Anybody has solution to following er
Henry,
This is not enough information to be able to help you.
The RC=418 indicates a TSM API error.
What appears in the DP for Exchange log file?
What appears in the DSIERROR.LOG file?
Thanks,
Del
> I have exactly the same problem but my env
Mark,
Thanks for the explanation! I did a q stat and found that TSM was set
with a password expiration of 999 days and the clients in question would've
expired recently. Thanks for pointing out that parameter! I hadn't
configured the TSM environment and I wasn't aware of it.
THANK YOU
somewhat of a newbie question - but on TSM 5.2 on Win2k Server - is there
a command I can run from the browser command line interface to obtain
information about the hardware being used in a site - or do I need
physical access to the Win2k server - the wizards, or Win2k devices to get
an idea of wh
Hi,
show config gives it (almost) all.
Regard,
Karel
-Oorspronkelijk bericht-
Van: jonlists [mailto:[EMAIL PROTECTED]
Verzonden: donderdag 8 januari 2004 18:53
Aan: [EMAIL PROTECTED]
Onderwerp: TSM 5.2 - hardware overview from web?
somewhat of a newbie question - but on TSM 5.2 on W
Hi Del,
I get the following messages in the dsierror.log:
01/03/2004 16:49:12 TcpOpen: TCP/IP error connecting to server.
01/03/2004 16:49:12 sessOpen: Failure in communications open call. rc: -50
01/03/2004 16:49:12 ANS1017E Session rejected: TCP/IP connection failure
01/04/2004 00:07:14 sessSen
Just installed and ran a backup with my first 5.2.2.0 client on a W2K box
and have the following issues/questions:
ANR0440W Protocol error on session 18813 for node () - invalid verb
header received.
Any clue what causes this and why ?
01/08/2004 12:58:21 ANS4987E Error processing
'\\ibm5196-23
Henry,
Make sure you have COMMTIMEOUT on the TSM Server set to a
high enough number to accomodate any Exchange activity
that may need to happen during backups. I would try setting
COMMTIMEOUT to 600 to see if that helps.
If that doesn't help... many times, "-50" errors mean there are
network prob
ANS1330S This node has a pending restartable restore session
Question:
- How do you determine if a node has a restartable session?
- How do you cancel it is it doesn't appear on a 'q sess'
>From the server:
q restore
to cancel:
cancel restore
You can also set the duration of the restart period from the server with the
setopt command.
hope this helps.
bob
On Thu, Jan 08, 2004 at 01:39:10PM -0500, Lawrence Clark wrote:
> ANS1330S This node has a pending restartable restore sess
1. Query RESTore
2. CANcel RESTore
--
Mark Stapleton
-Original Message-
From: Lawrence Clark [mailto:[EMAIL PROTECTED]
Sent: Thu 1/8/2004 12:39
To: [EMAIL PROTECTED]
Cc:
Subject: Cancel session
ANS1330S This
> ANS1330S This node has a pending restartable restore session
>
> Question:
>
> - How do you determine if a node has a restartable session?
> - How do you cancel it is it doesn't appear on a 'q sess'
The message description fully explains this.
Thanks for those who provided useable info.
Never encountered a restartable restore before and they don't print
hardcopy ref manuals anymore.
>>> [EMAIL PROTECTED] 1/8/2004 1:51:19 PM >>>
> ANS1330S This node has a pending restartable restore session
>
> Question:
>
> - How do you determine if a n
>Thanks for those who provided useable info.
>Never encountered a restartable restore before and they don't print
>hardcopy ref manuals anymore.
You may not be aware that IBM provides manuals for all of its products in
the form of PDFs, available on their web site. For TSM, the following is
a goo
I've been hit with this 'requirement' twice.
I've let the powers-that-be know that there are two options:
1) We *will* shut down *all* operations for 30 to 60 days while all
databases are converted to flat-files (with ALL binary fields converted to
ascii WITH all redundant data on each record to a
thanks. Got them on CD, but few people do perusal reading at
terminals.just a gimmick to save the vendors the cost of printing.
Can't 'thumb through' a pc based doc, especially a 700 page one.
>>> [EMAIL PROTECTED] 1/8/2004 2:05:00 PM >>>
>Thanks for those who provided useable info.
>Never encou
Mark,
Possibly one of the least intrusive ways of actually doing this would be to
define a new copypool, say "SNAPSHOT_2004", and backup all your storagepools
into that storagepool. If you start this at the beginning of November, you
can probably do each primary pool one at a time. Then just do
I just installed TSM 5.2.2.0 on a test server - Windows 2003. This was
upgraded from 5.1.6 something.
The default activity log query from the web browser is not working. I get:
ANR2020E QUERY ACTLOG: Invalid parameter - DOMAINNAME.
A help query actlog reveals:
DOmainname
Specifi
And by the "message description" Richard means the built in help in TSM.
Even the client has it. For my 5.1.5.15 Win32 client, it's the online help
section 222:
ANS1330S This node currently has a pending restartable re
37 matches
Mail list logo
