Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the difference between DBKEY and CALC in IDMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
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    Post subject: What is the difference between DBKEY and CALC in IDMS
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    Post subject: Re: DBKEY and CALC in IDMS
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    Post subject:
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    Post subject: Re: What is the difference between DBKEY and CALC in IDMS
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    Post subject: Re: What is the difference between DBKEY and CALC in IDMS
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    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm
No new posts ADS 3270 Batch simulator for IDMS rel... gpowell382 IDMS/ADSO 1 Thu May 05, 2016 8:02 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us