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
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: TSMLABO3select date_time from actlog fetch first 2 rows only
DATE_TIME
---
2015-03-27 07:06:10.00
2015-03-27
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:
you’re missing the from clause of your sql statement.
Op 1 jul. 2015, om 09:49 heeft Loon, EJ van (ITOPT3) - KLM
eric-van.l...@klm.com 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.
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
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
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 :
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