PERFORMANCE IMPROVEMENT FOR DATE DATA TYPE

[John Carr <74711.77@xxxxxxxxxxxxxx>]

RE:     PERFORMANCE IMPROVEMENT FOR DATE DATA TYPE

I don't wanna say I told you so,  but ... 

About six months ago when everyone was crying about the performance hit
on Date Data types,  I said, 

What happens when IBM makes a low level SLIC change and increases the 
performance?  Those people who use date data types will see a increase
in performance in their processing and will have native dates,  
Those people who didn't use dates just because of performance will still 
not have native dates,  Their users who use Query won't be able to use 
date math, They won't be able to use date math in OPNQRYF etc. 


-------------------------------------------------------------

Hey Bob, Charlie, anyone. 
 
Has anyone tried these Hallowe'en PTF's and re-tested performance with
DATE fields to see if there's a significant improvement ?   :-)


Item MA16930

  APAR Identifier ...... MA16930       Last Changed..97/11/03  
  OSP-PERFM PERFORMANCE IMPROVEMENT FOR DATE DATA TYPE
  
  Symptom ...... PR PERFM             Status ........... CLOSED  PER
  Severity ................... 3      Date Closed ......... 97/10/09
  Component .......... 9400DG300      Duplicate of ........
  Reported Release ......... 360      Fixed Release ............ 999
  Component Name 5763 5769 5716       Special Notice
  Current Target Date ..              Flags
  SCP ...................
  Platform ............
 
  Status Detail: SHIPMENT - Packaged solution is available for
                            shipment.
 
  PE PTF List:
 
  PTF List:
  Release 360   : MF17090 available 97/11/03 (1000 )
  Release 370   : MF17104 available 97/10/31 (1000 )
  Release 410   : MF17113 available 97/10/30 (1000 )
  Release 414   : MF17125 available 97/10/30 (1000 )
  
  Parent APAR:
  Child APAR list:
 
   ERROR DESCRIPTION:
  Customer stated that once they started to use our date code for
  date calculations that their batch job run time increased from
  20 hours to 40 hours. The application that they were running
  previously is no longer supported. They must continue to use
  our date code. They requested that we provide enhancements to
  the date code to decrease the amount of time that it takes to
  run their batch
  
  LOCAL FIX:
  
  PROBLEM SUMMARY:
  We found areas in date/time code where the date conversion
  performance could be enhanced.
 
  PROBLEM CONCLUSION:
  The date code was changed so that it takes less instructions to
  convert dates.


... Neil Palmer                                     AS/400~~~~~      
... NxTrend Technology - Canada     ____________          ___  ~     
... Thornhill, Ontario,  Canada     |OOOOOOOOOO| ________  o|__||=   
... Phone: (905) 731-9000  x238     |__________|_|______|_|______)   
... Cell.: (416) 565-1682  x238      oo      oo   oo  oo   OOOo=o\   
... Fax:   (905) 731-9202         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
... mailto:NPalmer@NxTrend.com          http://www.NxTrend.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---