I should have said that I know how to convert the SMFSTAMP8 to RCF3339 format. The problem is determining the timezone offset for a specific date & time rendered in LOCAL time. Now, for my own shop, there is only one problem: the 1 hour overlap when converting from standard time to daylight saving time. I think I'm "dead in the water" on this point. I simply don't have any way to confirm which offset to use, W.06 or W.05, just based on the individual SMF record. <sigh>
-- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht > Sent: Tuesday, September 06, 2011 9:28 AM > To: IBM-MAIN@bama.ua.edu > Subject: Re: SMF timestamps > > McKown, John wrote: > > >The SMF timestamps in SMF records, such as reader start date > & time, where the date is PL4'0cyydddF' and the time is a > fullword binary number of 1/100ths of a second past midnight. > But what is confounding me is that this seems to be the LOCAL > time, not GMT/UTC (yes, I know GMT != UTC). > > This is indeed LOCAL. SMF doc is not that useful describing > LOCAL against GMT/UTC times. > > > > The problem that I am having is that I really want to > convert this to GMT/UTC and then format it to RFC3339 > encoding (yyyy-mm-ddThh:mm:ss.thZ). > > > Try this (from one of my live SMF type 30 extract jobs) > > MVC CONTIME,SMF30TME > MVC CONDATE,SMF30DTE > -------------------------- > CONVTOD CONVVAL=CONVVAL, > TIMETYPE=DEC, > DATETYPE=YYYYMMDD, > ETODVAL=ETODVAL > > CONVVAL DS 0F > CONTIME DC 2F'0' > CONDATE DS F > DC F'0' > ETODVAL DS 2F > > and try the OFFSET= keyword for your time. Of course you need > to do some editing to insert '-', ':' and '.'. > > > >Do I just "give up"? Or am I missing something simple? > > You may NOT 'give up' :-D > > > Groete / Greetings > Elardus Engelbrecht > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
