ql time
>
> How do you arrive at 86400 as the number to divide by?
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
> Hanover, Cameron
> Sent: Monday, May 04, 2015 11:20 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re:
Would a decimal work instead of a fraction?
This works in TSM7:
select cast((current_timestamp - backup_end)/86400 as decimal(3,2)) from
filespaces where node_name='MYSUPERNODE'
-
Cameron Hanover
chano...@umich.edu
It is better to be violent, if there is violence in our hearts, than to put on
t
RIST.EDU
> Subject: Re: [ADSM-L] finding possible values for a particular column
>
> Hmmm . . . Linux . . . We're on AIX and its date doesn't handle that. Have
> to see about getting gnu date for aix.
>
> Thanks!
>
> Rick
>
>
> -Original Message--
Rather than figure out all the possible conditions, I just scripted for the
ones I cared about and warned on the rest:
for STATUS in `tsm_run_command_as_admin $INSTANCE -tab "select status from
events where domain_name like upper('${PREFIX}%') and
scheduled_start>'${yesterday} 09:00' and schedu
This probably isn't completely right, but it might be a start:
select node_name,hl_name,min(backup_date) from backups group by
node_name,hl_name
--
Cameron Hanover
chano...@umich.edu
"Let's get dangerous."
--Darkwing Duck
On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) wrote:
> I am found a co
I've got these that I'll be putting in my daily report once we get onto 7.1.1:
select node_name from nodes where repl_state<>'ENABLED'
select node_name,fsname,state,phase,comp_state,comp_reason,end_time from
replicationview where comp_state<>'COMPLETE'
-
Cameron Hanover
chano...@umich.edu
"They
While I search for answers elsewhere, maybe someone already has an answer
floating around in their head.
TSM server 6.3.
I have a user that has about 2 weeks worth of TDP/SQL backups. They have
turned off backups on the node. They have a 60 day retention policy currently.
They want to retai
Have you looked at rtrim?
-
Cameron Hanover
chano...@umich.edu
"Our integrity sells for so little, but it is all we really have. It is the
very last inch of us, but within that inch, we are free."
--Valerie (V for Vendetta)
On Oct 2, 2014, at 10:29 AM, Lee, Gary wrote:
> Looked in the db2 man
