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

What is the difference between DBKEY and CALC in IDMS


IBM Mainframe Forums -> IDMS/ADSO
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
harkar
Warnings : 2

New User


Joined: 11 Nov 2006
Posts: 7
Location: Chennai

PostPosted: Fri Nov 24, 2006 11:59 am
Reply with quote

What is the difference between DBKEY and CALC in IDMS
Back to top
View user's profile Send private message
senthilarumugam

New User


Joined: 09 May 2006
Posts: 19
Location: chennai

PostPosted: Fri Nov 24, 2006 12:15 pm
Reply with quote

DBKEY, the database key is used to find and get the record from the database. It will have the Page number and line index number of the record. Whenever the OBTAIN CALC command is passed, this particular CALC key will converted to its equivalent page number(DBKEY) and the record will be retrieved.

correct me if i am wrong! expecting more comments!
Back to top
View user's profile Send private message
honestbharani

New User


Joined: 23 Nov 2006
Posts: 2
Location: chennai

PostPosted: Fri Nov 24, 2006 3:02 pm
Reply with quote

CALC uses one (or more) of the record fields as the key. The DB KEY uses the combination of page number and line number. Am I right?
Back to top
View user's profile Send private message
senthilarumugam

New User


Joined: 09 May 2006
Posts: 19
Location: chennai

PostPosted: Mon Nov 27, 2006 6:50 pm
Reply with quote

Yes. this conversion of CALC key to the DBKEY(page No + line index No) is done using some internal process
Back to top
View user's profile Send private message
mfarien

New User


Joined: 02 Mar 2007
Posts: 17
Location: USA

PostPosted: Sun Mar 04, 2007 1:34 am
Reply with quote

I am not sure weather CALC will use DBKEY to get the record.
For CALC storage and retrieval :
When the application program requests that record occurrences be stored into the database, IDMS/R uses the CALC-key value to calculate the page into which the record should be placed. IDMS/R uses a randomizing routine to distribute records evenly over its area. To retrieve a record later, the application program supplies IDMS/R with a CALC-key value, and IDMS/R uses the randomizing routine to locate the proper page and directly retrieve the record occurrence that has the supplied CALC-key value.
The randomizing unit make out the CALC and Hashing mechanism.
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 -> IDMS/ADSO

 


Similar Topics
Topic Forum Replies
No new posts Difference between joblib and steplib JCL & VSAM 2
No new posts Pull data using date difference betwe... DB2 6
No new posts Difference between PLT txn and schedu... CICS 3
No new posts Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
Search our Forums:

Back to Top