ssh to IPv6 address

I had this guest OS in vm on window which I regularly used to connect via IPV4, but suddenly that network interface stopped working and I had IPV6 in place. So I started thinking how do I connect to IPV6 address via ssh !

I came across this post: http://serverfault.com/questions/234711/how-do-i-add-ipv6-address-into-system32-drivers-etc-hosts

Basically you need to run below command on your windows host to get the VMnet8's segment id


netsh interface ipv6 show addresses

assuming your IPV6 is - fe80::20c:29ff:feea:a19c

so your ssh command will be as follows

ssh -6 oracle@fe80::20c:29ff:feea:a19c%16

You can also make same entry in your "System32\drivers\etc\hosts" file so that you can connect to your IPV6 guest by name as well.

Netezza Query Elapsed time

Even wanted to know or monitor the elapsed time of a currently running query ? - here is the query to do so

Here in this query are trying to figure out if there is any active query (status = 'active') that is running for long than 15 minutes ('00:15:00' ::INTERVAL DAY TO MINUTE)


select
CURRENT_TIMESTAMP - QS_TSTART ElapsedTime,
B.USERNAME,B.DBNAME, B.COMMAND
from _v_qrystat A
join _v_session B on A.QS_SESSIONID = B.id
where B.status = 'active'
and ( CURRENT_TIMESTAMP - A.QS_TSTART ) > '00:15:00' ::INTERVAL DAY TO MINUTE ;


This above query also show how to use "INTERVAL" data types which I discovered first in Oracle than in any other RDBMS.


This you can further extend for monitoring and alerting purposes, using shell and cron.