Mainframe DB2, JCL, and Utility Commands
Covers mainframe topics including DB2 database operations, JCL job control, batch processing, MAGIC BMX/VMX macros, and utility command syntax.
Questions
Which command should be used to disable the time out period?
- @@TOUT D
- @@TOUT E
- @@TOUT F
- DISABLING TIME OUT IS NOT POSSIBLE
IDENTIFY WHICH IS NOT A VALID COMMAND
- @FREE,D
- @FREE,I
- @FREEM
- @FREEALL
- NONE OF THE ABOVE
@DELETE,C IS A VALID DELETE STATEMENT
- True
- False
WHICH OF THE BELOW IS A VALID STATEMENT
- @PRT,T
- @PRT,P
- @PRT,I
- @PRT,F
- ALL THE ABOVE
What is used to identify the impact to all related components before construction/delivery/deployment
- BMX/VMX
- PPM
- MAGIC BMX/VMX
- NONE OF THIS
If a validation indicator from DB2 is retrieved and validated,the program should handle it for values
- yes/no
- invalid values
- row not found
- all of the above
Error passed to java Screens need to contain what information
- variables with abend codes
- only error codes
- variables with error code
- none of the above
Select query for a date field should be
- SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO
- SELECT DATE(tablename.Date_variable, ISO)
- SELECT (tablename.Date_variable AS DATE)
- ALL OF THEM
For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
- (0000-00-00 and 0000-00-00-00.00.00.000000)
- (0001-01-01 and 0001-01-01-01.01.01.000001)
- (0001-01-01 and 0001-01-01-00.00.00.000000)
- (0001-01-01 and 0000-00-00-00.00.00.000000)
The proc coded in all the last technical job in a JCL is
- PMYPX075
- PMYPX077
- PMYPX074
- PMYPX076
What parameter is used for technical jobs that use DB2 check-point restart
- CHECKPOINTDB2
- CHKPNTDB2
- CKPT_DB2
- CKPTDB2
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
- DIOAPLCK
- DIOJCLCK
- JCLUTLCK
- DIOAPLCHK
For calling the batch routines what is used
- XCTL
- CALL
- LINK
- none of the above
In case of new defects what needs to be done
- raise new defect,retest,close
- raise new defect,retest
- raise new defect,fix the defect,retest,close
- Retest to eliminate the defect
Incase of batch,While executing test cases where the output file needs to be mentioned
- Q04
- Q01
- PRD
- DEV
What is the only statement in the EXIT para
- EXIT
- 1000-EXIT
- 1000_EXIT
- BOTH 1 and 2
What macro is used to identify the impact to all related components before construction/delivery/deployment
- BMX/VMX
- SERCHFOR
- MAGIC BMX/VMX
- NONE OF THIS
What macro is used to identify the impact to all related components before construction/delivery/deployment
- MAGIC BMX/VMX
- BMX/VMX
- SERCHFOR
- NONE OF THIS
If a validation indicator from DB2 is retrieved and validated,the program should handle it for values
- y,n
- invalid values
- row not found
- all of the above