It looks like an accurate conversion of you input value. Since
'0000000100000000' as a STCK TOD value is close to one second, the
value in WORK4 looks like it's is around 3/4 of a second.
Gary Weinhold
Senior Application Architect
DATAKINETICS | Data Performance & Optimization
Phone +1.613.523.5500 x216
Email: [email protected]
Visit us online at www.DKL.com
E-mail Notification: The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.
__________
On 2016-08-03 05:26, Ward Able, Grant wrote:
I read a value from DB2 into my program. This original value was inserted into
DB2 by another program doing:
LG R14,ASSBPHTM LOAD PREEMTABLE TIME
LG R15,ASCBEJST LOAD ACCUMULATED ADSP TIME
ALGR R14,R15 ADD TIMES
STG R14,DOUBLE SAVE TOTAL ACCUMULATED TIME
This is then stored in a column in a DB2 as an hourly interval of CPUTIME.
I need to get the difference between each accumulated interval, then work out
the time used.
To do this I subtract Hour(n+1) from Hour(n) and then use STCKCONV.
STCKCONV STCKVAL=WORK4,CONVVAL=WORK5,TIMETYPE=DEC,DATETYPE=MMDDYYYY
WORK4 = x'00000000BCEB4772' INPUT
WORK5 = x'00000077381200000101190000000000' OUTPUT
Am I reading this correctly to state that the value is 0.773812 seconds? It
just seems a very low value for an hour's CPUTIME.
Regards – Grant.
If you don't have time to do it right, when will you have the time to do it
over? - John Wooden
DTCC DISCLAIMER: This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error, please notify us
immediately and delete the email and any attachments from your system. The
recipient should check this email and any attachments for the presence of
viruses. The company accepts no liability for any damage caused by any virus
transmitted by this email.
