Mainframe Systems: CICS, JCL, and DB2 Fundamentals
Test your knowledge of IBM mainframe technologies including CICS transaction processing, JCL job control, COBOL batch programming, and DB2 database operations.
Questions
Select query for a date field should be
- SELECT DATE(tablename.Date_variable, ISO)
- SELECT (tablename.Date_variable AS DATE)
- SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO)
- ALL OF THEM
For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
- 0001-01-01 and 0000-00-00-00.00.00.000000
- 0001-01-01 and 0001-01-01-01.01.01.000001
- 0000-00-00 and 0000-00-00-00.00.00.000000
- 0001-01-01 and 0001-01-01-00.00.00.000000
The proc coded in all the last technical job in a JCL is:
- PMYPX074
- PMYPX075
- PMYPX076
- PMYPX077
What parameter is used for technical jobs that use DB2 check-point restart
- CKPTDB2
- CHKPNTDB2
- CKPT_DB2
- CHECKPOINTDB2
DD names for FB and VB input files are
- INPF,INPV
- INPFB,INPVB
- INFN,INVN
- none of the above
What is the JCL checker utility for error correction
- DIOJCLCK
- DIOAPLCK
- JCLUTLCK
- DIOAPLCHK
For calling the batch routines what is used
- XCTL
- CALL
- LINK
- none of the above
Incase of batch,While executing test cases where the output file needs to be mentioned
- Q01
- Q04
- PRD
- DEV
What is the only statement in the EXIT para
- 1000-EXIT
- EXIT
- 1000_EXIT
- BOTH a and b
After inclusion/deletion/modification of a technical job what needs to done
- Refresh OPC scheduleby TOP
- Build the modified components
- Both 1 and 2
- nothing needds to changed
Through which of the following the cics intercommunication can be achieved?
- MRO
- ISC
- ISO
- Neither MRO nor ISC
- ISA
- Both ISO and ISA
In MRO, each of the CICS runs by depending on each other?
- True
- False
CEBR is an CICS supplied temporary storage browse transaction?
- True
- False
All cics transaction abends starts with A?
- True
- False
Within one processor there could be more than one CICS's each of which runs independently under the same OS. Such communication is called as ____?
- Multi Region Operation
- Inter System Communication
- Both the above
- None of the above
One CICS in one processor can communicate with other CICS in other processor or other non-cics systems regardless of where the other processor or non-cics systems are physically located. Such communication is called as _____?
- Multi Region Operation
- Inter System Communication
- Both the above
- None of the above