I have some big files (10+G and one 31+Gig file) that is being backed up.
Is there a query that I can use to find what the big files are and what
client they belong to?
PM
To: [EMAIL PROTECTED]
Subject: Question about sql-query to get IP-addresses
Hello,
Question about a sql-query to get IP-addresses from client-nodes associated
with a schedule:
select substr(A1.ADDRESS,1,posstr(address,':')-1) as IP_address,A1.entity as
Name from summary A1,
Hello,
Question about a sql-query to get IP-addresses from client-nodes associated
with a schedule:
select substr(A1.ADDRESS,1,posstr(address,':')-1) as IP_address,A1.entity as
Name from summary A1, nodes A2 where A1.entity=A2.node_name AND node_name in
(select node_name
from ASSOCIA
HI guys
I have a TSM question for you .
The output from "select * from events " and "q ev * * " seemd to be
different .
The q ev * * output is acuurate where as output from "select * from events
" does not show nodes backed up before 01:00 a.m.Therfore i am missing the
window of 00:00 a.m to 01
11/22/01 06:00 AM Subject:
Please respond to "ADSM: AW: transmitting the result of
an sql query to a script ? + loop
ut to stop it once it's started (impossible
on a copy stg pool, without a cancel command). Thanks anyway !
Regards.
Arnaud
-Original Message-
From: Martin Trcka [mailto:[EMAIL PROTECTED]]
Sent: Montag, 26. November 2001 14:38
To: [EMAIL PROTECTED]
Subject: Re: transmitting the result of an
can't be done, only that I don't know of a way.
Thanks,
Ben
-Original Message-
From: Baines, Paul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 4:01 AM
To: [EMAIL PROTECTED]
Subject: AW: transmitting the result of an sql query to a script ? +
loop struture ?
I
AM Re: transmitting the result of an sql query
to a script ? + loop
Please struture ?
respond to
"ADSM: Dist
Stor Manager"
Hi,
if you have RECLAIM parameter set on 100 in
On
> Behalf Of PAC Brion Arnaud
> Sent: Thursday, November 22, 2001 11:01 AM
> To: [EMAIL PROTECTED]
> Subject: transmitting the result of an sql query to a script ? +
> loop struture ?
>
>
> Hi TSM'ers !
>
> I already saw this in a thread, but can't find it
rts in O.S.
itself ?!!! :-((
Regards.
Arnaud
-Original Message-
From: Baines, Paul [mailto:[EMAIL PROTECTED]]
Sent: Donnerstag, 22. November 2001 12:01
To: [EMAIL PROTECTED]
Subject: AW: transmitting the result of an sql query to a script ? +
loop struture ?
I can't think how you
L PROTECTED]]
Gesendet: Donnerstag, 22. November 2001 11:01
An: [EMAIL PROTECTED]
Betreff: transmitting the result of an sql query to a script ? + loop
struture ?
Hi TSM'ers !
I already saw this in a thread, but can't find it again : I'm looking
for a convenient way to stop some reclamatio
Hi TSM'ers !
I already saw this in a thread, but can't find it again : I'm looking
for a convenient way to stop some reclamation processes in an automated
way (script).
As those reclamation processes are made on an offsite stg pool, no way
stopping them by increasing the reclamation threshold to
> on 24.09.2001 22:00:29
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject:Re: SQL query - GROUP on derived value?
Andy,
Thanks for the feedback. I may not have been clear in stating my original
question, and now th
Andy,
Thanks for the feedback. I may not have been clear in stating my original
question, and now that I've gone back and re-read your ADSM SQL reference,
I think what I'm looking for may not be possible within the syntax of the
SQL Query.
Just to clarify:
>But not my question be
24/2001 10:00
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:SQL query - GROUP on derived value?
Is it possible to group query output by a value that is *not* directly
present in a column in a table? What I'm
Stor Manager" <[EMAIL PROTECTED]>
09/24/2001 10:55
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Re: SQL query - GROUP on derived value?
I think there are a couple of problems that stand out:
1) For the p
Is it possible to group query output by a value that is *not* directly
present in a column in a table? What I'm trying to achieve is something
like producing a tally of volumes that are pending, grouped by day that
they went pending.
If I try something like this:
select count(*),cast(pen
Hi guys,
I have typed this query, which works fine, but I need to be able to do
more. First off here is the select command :
select distinct entity as Node, activity as Activity, start_time
as Start, end_time as End, affected as Files_Backed_up, bytes as
Total_Bytes fro
m summary where activity
uot;Good enough" is the enemy of excellence.
Yanki Yuksel <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
09/21/2001 10:59
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:
I would like to be able to produce some of the same information that is
currently found in the Accounting Records but so far I am unable to create
a SQL query that works and shows Restore information. I know that data is
there but I can't figure it out.
Does anyone have a query reporting o
: [EMAIL PROTECTED]
Kopie: (Blindkopie: Gerhard Wolkerstorfer/DEBIS/EDVG/AT)
Thema:SQL Query - what is wrong with this statement
A tape containing some 11 000 files has become unreadable. The I/O error was
discovered in a BACKUP STG process and these is no other backup of the data.
What I am
A tape containing some 11 000 files has become unreadable. The I/O error was
discovered in a BACKUP STG process and these is no other backup of the data.
What I am trying to ascertain / list is what data will be lost. As far as I can see
only "inactive" data is going to be lost permanently.
gt;@SMTP@Exchange
To: [EMAIL PROTECTED]@SMTP@Exchange
cc:
Subject:SQL query events
Adsm Group
In a previous Email from Jim Healy to the group, it was suggested
to use
the following WHERE statement: to get the prior day events.
Try addin
uitable on
01/03/2001 03:13 PM ---
James J Healy
12/29/2000 11:50 AM
To: Joseph M Marchesani/NYM/Equitable@AXA-Equitable
cc:
Subject: Re: SQL query for events
-- Forwarded by James J Healy/NYM/Equitable on
12/29/2000 1
ge
To: [EMAIL PROTECTED]@SMTP@Exchange
cc:
Subject:SQL query for events
Can anyone help with the sql query I could use to see events that
occurred
form yesterday to today?
Can anyone help with the sql query I could use to see events that occurred
form yesterday to today?
>Anyone who depends on data from volumeusage might consider opening a
>problem with IBM/Tivoli. Really bad performance can be reported and will sometimes
>be fixed instead of getting the dread 'working as designed' response.
>I have always used occupancy data to make reports. In version 1
>it wa
I have never been able to do a simple 'select * from volumeusage'. It will always
hang the server which is 3.7.3.8 on os/390 r6. I think the problem compared to
other tables is that volumeusage may not be a real table in the database.
Instead I think it is really just a select on the contents ta
We have a very bad performance for SQL queries
since we have upgraded the server (AIX 4.3.3)
to Version 3, Release 7, Level 4.0
I've only seen it on queries on the
occupancy table. Queries on other tables
seem to run fine, although I haven't
tried them all.
Every mornig at 8:00 I run
select stg
I am still on ADSM 3.1 with OS/390. I have found variants of this query
impossible to
run during normal hours, when other users (online business) seem to think
they are
more important than mere housekeeping functions.
Running out of hours, my query (select node_name from volumeusage where
stgpoo
the period.
John
Mark Brown <[EMAIL PROTECTED]> on 11/02/2000 04:31:34 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: Re: Really bad performance for a sql query after upgrading to v 3
Mark - Offhand I don't see any APARs relating to your SQL query, so maybe
you can isolate what the problem might be by using a spectral
approach, doing selects from simple "select * from volumeusage", with
increasing complexity through to your problem select statement.
It m
ist Stor Manager" <[EMAIL PROTECTED]>
>
> To: [EMAIL PROTECTED]
> cc:(bcc: John Naylor/HAV/SSE)
> Subject: Really bad performance for a sql query after upgrading to v 3.7
>
> Hello,
>
> We are currently running TSM Version 3, Release 7, Level 3.6 on OS
as Numvols from volum
eusage where stgpool_name='NT3590BACK' group by node_name order by
Numvols desc
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) yes
NOD
:45:05 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: John Naylor/HAV/SSE)
Subject: Really bad performance for a sql query after upgrading to v 3.7
Hello,
We are currently running TSM Version 3, Release 7, Level 3.6 on OS
Hello,
We are currently running TSM Version 3, Release 7, Level 3.6 on OS/390.
We upgraded from version 3.1. On the 3.1 version I used to run a select
command to show me how many tapes each node was using. Here is the
select
command:
select node_name, count (distinct volume_name) as Numvols from
> I am querying the adsm server backups table for a file space with a
> management class that specifies
> verexists = 7,verdeleted 1,rexextra 8,retonly 90.
>
> I am expecting to see 8 versions of the data outputted from the sql query,
> however only seem to get the latest ver
Hi,
I am querying the adsm server backups table for a file space with a
management class that specifies
verexists = 7,verdeleted 1,rexextra 8,retonly 90.
I am expecting to see 8 versions of the data outputted from the sql query,
however only seem to get the latest version.
Can anyone tell me
201 - 238 of 238 matches
Mail list logo