t; backed up in over 5 days, but that's another battle.
>
> Thanks again!
>
>
> Joni Moyer
> Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
> *
-9966
Fax: (717) 302-9826
[EMAIL PROTECTED]
"Andrew Raibeck" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
10/05/2006 01:03 PM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Se
Highmark
> Storage Systems, Senior Systems Programmer
> Phone Number: (717)302-9966
> Fax: (717) 302-9826
> [EMAIL PROTECTED]
>
>
>
>
> "Andrew Carlson" <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager"
Joni,
Run the command using dsmadmc executable and pass the command as a parameter
dsmadmc -id=admin -PASSWORD=admin -DISPL=LIS select
node_name,filespace_name,backup_start,backup_end from filespaces where
node_name like 'NAS%' or node_name like 'SERVER%'
Aravind
-Original Message-
From:
t by: "ADSM: Dist Stor Manager"
10/05/2006 10:45 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Select Statement Syntax
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depen
Srinath,
SELECT * FROM CLIENT_SCHEDULES
SELECT * FROM ADMIN_SCHEDULES
Regards,
Ramakrishna Choudarapu
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: Thursday, October 05, 2006 10:33 AM
To: ADSM-L@VM.MARIST.EDU
Subject
Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Gopinathan, Srinath
Sent: Thursday, 05 October, 2006 16:33
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Select Statement Syntax to view the schedule
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
Howe
Try
select tabname, remarks from tables
to get information about available tables you can query. You should see
some table names that might be suitable.
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
Int
I went through this same problem. Never got a satisfactory answer,
totally. It behaves differently depending on if you do it from a terminal,
or disconnected, like from cron. Also it depends on the setting of
sqldisplaymode. Try the command `set sqldisplaymode wide` and see if that
makes it lo
On Oct 5, 2006, at 9:00 AM, Joni Moyer wrote:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
...
Joni -
Explore the capabilities of SQL in order to use it effectively, and
dsmadmc -se= -id= -pa= -commad
-outfile= select
node_name,filespace_name,date(backup_start) as
start_date,time(backup_start) as start_time,date(backup_end) as
end_date,time(backup_end) as end_time from filespaces where node_name
like 'NAS%' or node_name like 'SERVER%'
Regards,
Rama
-Origi
Joni,
Try this and see if it makes any difference, it will manipulate the
returned backup_start and backup_end to only be 16 chars and thus loose
the ".00"
I feel sure that there is tidier way to do this, but I have yet to find
it. Suggestions gladly appreciated. In the meantime this might he
Use:
select node_name as "NODE_NAME ",
filespace_name as "FILESPACE_NAME", ...
padding the quoted titles with enough blank spaces to achieve what you
want.
Alternatively, consider using a Windows spreadsheet or database program to
access the TSM
Joni,
Node_name column is wrapping because the overall length of the output is
too long : you should try to reduce it.
You where on the right track for doing this while trying to reduce the
output for backup_start/end fields.
To achieve this, try to use :
select node_name,filespace_name,time(ba
Hi All,
I am able to see the node info using the following command
TSM>Select * from nodes
However, the same doesn't work as
TSM>Select * from schedules
Can anybody let me know the right command for getting info about
schedules using select statement
Regards,
Srinath G
This e-mail has been s
Joni Moyer said the following on 10/5/06 9:00 AM:
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
Here is the statement I am issuing:
select node_name,filespace_name,backup_s
Hi Joni,
The timestamp format is:
'-mm-dd hh:mm:ss.nn'
where:
= year
mm = month
dd = day
hh = hours
mm = minutes
ss = seconds (optional)
nn = fraction of a second (optional)
When referring to a timestamp, put it in single quotes and use the above
format, i.
This command looks very familiar.
Here's ya go. try this
select with duration
select left(entity,10) as node_name, date(start_time) as date,-
cast(activity as varchar(8)) as activity, time(start_time) as start, -
time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb, -
cast(substr(c
Joni,
Using a calculated timestamp value in a query against the events table does
not work as you would expect. It boils down to an issue with when TSM
constructs the events table to run the query against. The default for "q
event" and "SELECT xxx,yyy,zzz from EVENTS..." is for the current day
Try using the BETWEEN for the where clause. I saw that the TSM Operations
Reporting package uses this:
select node_name, scheduled_start, schedule_name, status -
from events -
where (node_name like 'HM%' or node_name like 'PA%') -
and scheduled_start between current_timestamp - 1 day and
Joni, this is a known limitation/restriction of using the EVENTS table:
you can not use "calculated" dates when comparing start times. You need to
code a specific date/time value. For example:
select node_name, scheduled_start, schedule_name, status -
from events -
where (node_name like 'HM%
21 matches
Mail list logo
