References to the CURRENT DATE, CURRENT TIME, or CURRENT TIMESTAMP special registers in SQL calls return real time instead of the virtual time configured for the calling application in the ATF VCD.
The required ZAP to the DSNXVCTS CSECT in the DSNXGRDS load module is not being used by the DBM1 address space associated with this DB2 region.
Resolving the problem
Apply the required ZAP as documented in the ATF for z/OS Installation and Customization Guide chapter on Using ATF with DB2. See TechNote 1438030 for the list of the latest list of members required for the different DB2 releases. If this step has already been performed, make sure that the resultant module is in the search order (typically, the STEPLIB DD) for the DBM1 address space.
NOTE: This ZAP may need to be reapplied after any maintenance or DB2 release upgrades. See TechNote 1318022 for more information on this topic.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.