SQL STATEMENT

2018-01-22 Thread Lepre, James
Hey Everyone - I am looking for a sql select statement that show completions, missed, and failures of daily schedules. This output should be similar to the q event command Thank you in advance for the assistance James Lepre

Re: SQL STATEMENT

2018-01-22 Thread Marc Lanteigne
Hi James, There is probably an example like you are looking for here: http://thobias.org/tsm/sql/ - Thanks, Marc... Marc Lanteigne Accelerated Value Specialist for Spectrum Protect 416.478.0233 | marclantei...@ca.ibm.com Office Hours: Mond

Re: SQL STATEMENT

2018-01-22 Thread Rick Adamson
You'll need to query the Events table for this info. Modify the current time stamp as needed but I strongly suggest using it when querying the Events (and Backups) table. Something along the lines of: select node_name,status from events where (scheduled_start>=current_timestamp - 24 hours) -Ri

Spectre & Meltdown patching in relation to Spectrum Protect

2018-01-22 Thread Stefan Folkerts
Hi, Has anybody seen any information from IBM in relation to Spectre & Meltdown patching for Spectrum Protect servers? We have a customer who has found that systems that do lot's of small IO's that performance can drop 50% on intel systems, these were seen with synthetic benchmarks, not actual loa