Hi Kurt!
Your SQL does indeed return the output I'm looking for, but how dow I embed it
in the following SQL statement?
select actlog.date_time, actlog.nodename as "Nodename", actlog.message as
"Message", nodes.node_name, nodes.contact from nodes,actlog where nodes.contact
like 'Component Team
Hi Eric,
It's always fun to play and calculate with timestamps in db2, here is one of
the solutions to get the desired format:
tsm: TSMLABO3>select date_time from actlog fetch first 2 rows only
DATE_TIME
---
2015-03-27 07:06:10.00
2015-03-27 07:06
Hi guys!
Now that I have my SQL statement working I noticed that a select date_time from
actlog returns the following format:
2015-06-29 23:27:04.00
What is the proper way to remove the trailing .00?
Again, thanks for your help!!!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
*
Hello Erwann, thank you for replying.
I am not using VCB -- but instead, VADP. It's ridiculous that IBM can't
offer the same off-host file-level backup of for Linux VMs that they do for
Windows VMs - now I have to deploy and manage an in-guest BA client for
every VM?
According to this link, it l
Hi Remco!
How could I be so stupid... :-(
Thank you very much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco
Post
Sent: woensdag 1 juli 2015 13:19
To: ADSM-L@VM.MARIST.
you’re missing the from clause of your sql statement.
> Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM
> het volgende geschreven:
>
> Hi guys!
> I'm trying to select all ANE4987E messages for all nodes with the text
> 'Component Team Windows' in the contact field. For some reason I
Hi guys!
I'm trying to select all ANE4987E messages for all nodes with the text
'Component Team Windows' in the contact field. For some reason I cannot get the
SQL statement to work. What am I doing wrong?
select actlog.date_time, actlog.nodename, actlog.message, nodes.node_name,
nodes.contact
Hello Mike,
I guess you're using the old VCB backup modes (with filelevel option).
VCB allows image level (fullvm) for any guest operating system, but file-level
is limited to Windows guest operating system.
See this datasheet from VMware :
http://www.vmware.com/files/pdf/consolidated_backup_
