IDMS Interview Questions
What is the meaning of the return codes 0307 and 0326?
0307 is end-of-set and 0326 is record not found.
0307- end of set
0326- rec not found
Error code is 4 Bytes.
MAMI---> MA indicates the major command that was executing like 03 means for OBTAIN.
MI- Minor code associated with the command.
How can we debug cobol pgm containig idms using xpeditor
Following link may help you.
http://www.mainframegurukul.com/srcsinc/XPEDITER.html
You need to compile the program by selecting xpeditor option 'Y".
Then you need to enter XP-->3 in ISPF menu.
Specify the JCL and select the step which you want to debug by placing "I" before that step then give the RUN command
Is it possible to obtain a record from idms database without mentioning the record-name itself?
Sure. Obtain next with AREA. As is an AREA sweep.
Yes, by using the OBTAIN FIRST/NEXT within area/set name command. However if you have more than one record type in the area, or a multi-member set you won't know what you have. You should only use thi...
WORKING-STORAGE SECTION. 01 WS-REC-DATA. 10 VAL1 PIC X(..). 10 ... 10 ... 10 EMP-NAME PIC X(...). 15 EMP-FIRST-NAME PIC X(..). 15 EMP-LAST-NAME PIC X(..). PROCEDURE DIVI. SA. ** AFTER BIND,READY SET F...
01 WS-EMPLOYEE-NAME. 05 FIRST-INITIAL PIC X. ...
An ook-rec is a one of a kind record set, used to get to another record set
One Of a Kind Record is a usually a CALC record with only one occurrence of the record type in the entire database
OOK-REC - it is IDD metaschema record. IDD metaschema is generating during installiation time
Explain the difference between record occurrence and record type?
A record occurrence is the instances of a record; it is the smallest addressable unit of data. A type is the description of a record; there need not be any occurrences.
Record type is like template of record.
Record occurance will contains the data
What is the purpose of a ready?
The ready prepares a database area for access by dml functions.
The Ready statement performs an equivalent function as an OPEN statement for a conventional file.
It makes the required area of the database available to the program.
This statement begins a run-unit.
What is an area sweep and when is it used?
An area sweep accesses records on the basis of the physical location in a database area. It can be total, meaning a record by record search of the area, or it can be of occurrences of records of a specific type.
In performing an area sweep, IDMS/R scans through all the records in an area in physical sequence. The order in which records are retrieved will generally have little relationship to the logical seque...
What is the difference between local and central version operating modes?
In local there is no idms system running above the DBMS. It is the more efficient mode but lacks the recovery and integrity facilities of the central version (cv) control program. In cv many application programs access the database through a single copy of the DBMS.
Local Mode A batch program that operates in local mode has its own copy of IDMS DBMS loaded into its partition, region or address space Good for Batch Retrieval programs Local mode operates...
A page is the smallest unit of storage in an idms database.
You are current on the owner.
The Owner Record Occurrence becomes the Current
In idms which of following is true for any set of occurances?1. It may have zero owner instances.2. It must have one and only one owner instance.3. It must have atleast one member instance.4. None
Does disconnect and connect creates page lock in idms ?
Yes, All Store , Erase , Connect , Disconnect do page lock.
Modify only lock the instance of the record currently modified.
What does a commit statement do?
It writes a checkpoint to the journal file and releases any record locks.
It completes a LUW. In case of DB2 changes made to database will not take effect untill a COMMIT statement is encountered.
How can you submit a job through cobol program?
Hi,You can submit a job from a cobol pgm. Write JCL cards to a dataset with //xxxxxxx SYSOUT= (A,INTRDR) where 'A' is output class, and dataset should be opened for output in the program. Defi...
you can not submit job (batch or online) thru cobol program.
but u can use cobol pgm in either batch or online applications.
How does idms insure data integrity?
Idms uses record locks to prevent another run-unit from updating the same record.
All objects and relations beween them are 100% "described" in IDMS IDD. So all tranzactions of any user or programmer are 100% documented. Advanced IDD administrator knows everytning about any user task or development step (about programmers mistakes also).
What is a set? What pointers are required, what are possible? How may sets be ordered?
A set is an owner record and, optionally, its member records. There are three types of pointers: next, prior and owner, but only next is required. There are five possible orders for arrangements of sets; they are: first - insert at beginning, last - insert at end of set, next - insert after current...
A.By Codasyl conception SET is data chain between Owner and Member record. B.Pointers: NEXT,PRIOR,OWNER(direct adresation to OWNER_RECORD from MEMBER).At least NEXT pointer is requered to navigate via set.
C. Number of sets really is unlimited.
Idd is the integrated data dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.
Integrated Dictionary Directory. IDD - it is metaschema where are stored other "entities" of IDMS components - elements, records, maps,dialogs,areas, subschemas, schemas.
Name and explain the three location modes?
Calc is based on a symbolic value which is used to determine the target page. Via mode is for members only. Via records are stored near to their owners. In direct mode the target is specified by the user and is stored as close as possible to that page.
three modes calc,via,direstcalc: here any fileld value in the record is converted into a combination of page no and line no by means of a hashing algo... to be staright one can access the record...
User Panel
Categories
Ads
Interview Coaching
Connect
Ads
Interview Question
Career Counselling
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".
This isnt a feature provided with the IDMS product. Wish it were!
The idms-restart is a record which will keep track of the number of records(& its data) processed before a particular program abends.The restart record has a calc key which is nothing but the...