Hi Folks,
I am writing a simple script that captures some daily activity from the system log, using arsdoc query.
In dealing with the system log storing the date in UTC format so here's a quick snippet of my plan:
YESTERDAY=`something that generates yesterdays date`
2DAYSAGO=`somethinh that generates 2 days ago`
Now, throwing it into arsdoc query, my plan is this, example is - capturing 88 records for 11/29/21 Server Time-
"-i "where ODDAT_LOAD_DATE BETWEEN '$2DAYSAGO.16.59.59' and $YESTERDAY.16.59.59'"
Trying that approach and I am getting this error
DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007 -- SQLSTATE=22007, SQLCODE=-180, File=arsdoc.c, Line=3563
Does anyone have a handy way of getting things from the system log for the previous day, from a monitoring script, report, etc..?
Thanks!