Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is CICS?
- Correct Answer
- Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing
- 1. In a DB2-CICS program which acts as co-ordinator and which is the participant? Discuss
- 2. In terms of DB2 indexing, what is the root page? Discuss
- 3. What is QUIESCE? Discuss
- 4. When does the SQL statement gets executed when you use cursor in the application programming? Discuss
- 5. Why SELECT * is not preferred in embedded SQL programs? Discuss
- 6. What CICS command are used to read a VSAM KSDS sequentially in ascending order? Discuss
- 7. What happens when a CICS command contains the NOHANDLE option? Discuss
- 8. What are different ways of Initiating Transaction in CICS? Discuss
- 9. What are the CICS commands available for program control? Discuss
- 10. What is the difference between the INTO and the SET option in the EXEC CICS RECEIVE MAP command? Discuss
Technology problems
Search Results
Correct Answer: DB2 acts as the participant and CICS acts as a co-ordinator
Correct Answer: The simplest DB2 index is the B-tree and the B-tree's top page is called the root page The root page entries represent the upper range limits of the index and are referenced first in a search
Correct Answer: A QUIESCE flushes all DB2 buffers on to the disk This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency
Correct Answer: SQL statement gets executed when we open cursor
Correct Answer: - If the table structure is changed ( a field is added ), the program will have to be modified - Program might retrieve the columns which it might not use, leading on I/O over head - The chance of an index only scan is lost
Correct Answer: READNEXT reads the next record from a browse operation for any of the three VSAM files
Correct Answer: - NOHANDLE is an option that can be specified along with abnormal condition during program execution - When the exception occurs, no action is performed during execution of NOHANDLE command - The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist - The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested - The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option
Correct Answer: The following are the ways of initiating a CICS transaction 1 By entering Transaction Id 2 By Start command 3 By Return Trans Id (as in pseudo - conversation) 4 By Registering Tran ID in plt so that it will be automaticaly dusring CICS start 5 By ATI (Automatic task initiation) 6PF & PA keys as defined in PCT
Correct Answer: The following commands are available for the Program Control services: LINK: To pass control to another program at the lower level, expecting to be returned XCTL: To pass control to another program at the same level, not expecting to be returned RETURN: To return to the next higher-level program or CICS LOAD: To load a program RELEASE: To release a program
Correct Answer: The INTO option moves the information in the TIOA into the reserved specified area, while the SET option simply returns the address of the TIOA to the specified BLL cell or address of a linkage-section
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.