IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Did IBMZPLI R7 compiler change how DB2 timestamp is written?


IBM Mainframe Forums -> PL/I & Assembler
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Steve Little

New User


Joined: 11 Sep 2008
Posts: 2
Location: Tampa

PostPosted: Fri Sep 12, 2008 11:04 pm
Reply with quote

Not sure if it's called the timestamp but this is the field following the member name field in the DBRM. To verify that a DBRM and LOAD match to prevent 805’s in the field we verify that the TS in the 8 byte field following the 8 byte name field in the precompiled DBRM can be found in the LOADLIB and MATCHES before shipping it out. After going to R7 if we take that HEX timestamp and search for it in the LOAD we don’t find a match. Even when searching for only 4 bytes we don’t find a match.

BSSPS36 F ý
CEEDEFF4151C0218
222723608F96966D

The above might not have lined up correctly. Sorry.

If I then go to the LOAD and turn HEX on and do the find command F x’185F19C6’ no HEX string like that is found. Prior to R7 it was found.

Anyone have any idea if maybe compile parms need to be changed or even if IBM has changed how we can verify a DBRM matches the LOAD that went through the IBMZPLI compiler? Thanks!!!
Back to top
View user's profile Send private message
Steve Little

New User


Joined: 11 Sep 2008
Posts: 2
Location: Tampa

PostPosted: Mon Sep 15, 2008 11:07 pm
Reply with quote

I found out the field I called the timestamp is actually the "consistency token" which starts in column 25. Hope that helps get me an answer. Thanks.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Sep 15, 2008 11:39 pm
Reply with quote

Hello Steve and welcome to the forums,

You might look at this previous topic (the last entry) and see if it helps:
ibmmainframes.com/viewtopic.php?t=33400

If you use the forum SEARCH in the db2 part of the forum, there are several topics that mention the consistency token.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PL/I & Assembler

 


Similar Topics
Topic Forum Replies
No new posts How I Found a Bug in a FORTRAN Compiler All Other Mainframe Topics 4
No new posts To get the count of rows for every 1 ... DB2 3
No new posts 3270 personal communications. Can't c... TSO/ISPF 2
No new posts Insert system time/date (timestamp) u... DFSORT/ICETOOL 5
No new posts Timestamp difference and its average ... DB2 11
Search our Forums:

Back to Top