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.

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Which command should be used to disable the time out period?

  1. @@TOUT D
  2. @@TOUT E
  3. @@TOUT F
  4. DISABLING TIME OUT IS NOT POSSIBLE
Question 2 Multiple Choice (Single Answer)

IDENTIFY WHICH IS NOT A VALID COMMAND

  1. @FREE,D
  2. @FREE,I
  3. @FREEM
  4. @FREEALL
  5. NONE OF THE ABOVE
Question 3 True/False

@DELETE,C IS A VALID DELETE STATEMENT

  1. True
  2. False
Question 4 Multiple Choice (Single Answer)

WHICH OF THE BELOW IS A VALID STATEMENT

  1. @PRT,T
  2. @PRT,P
  3. @PRT,I
  4. @PRT,F
  5. ALL THE ABOVE
Question 5 Multiple Choice (Multiple Answers)

What is used to identify the impact to all related components before construction/delivery/deployment

  1. BMX/VMX
  2. PPM
  3. MAGIC BMX/VMX
  4. NONE OF THIS
Question 6 Multiple Choice (Multiple Answers)

If a validation indicator from DB2 is retrieved and validated,the program should handle it for values

  1. yes/no
  2. invalid values
  3. row not found
  4. all of the above
Question 7 Multiple Choice (Multiple Answers)

Error passed to java Screens need to contain what information

  1. variables with abend codes
  2. only error codes
  3. variables with error code
  4. none of the above
Question 8 Multiple Choice (Multiple Answers)

Select query for a date field should be

  1. SELECT CHAR(CAST (tablename.Date_variable AS DATE), ISO
  2. SELECT DATE(tablename.Date_variable, ISO)
  3. SELECT (tablename.Date_variable AS DATE)
  4. ALL OF THEM
Question 9 Multiple Choice (Multiple Answers)

For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp

  1. (0000-00-00 and 0000-00-00-00.00.00.000000)
  2. (0001-01-01 and 0001-01-01-01.01.01.000001)
  3. (0001-01-01 and 0001-01-01-00.00.00.000000)
  4. (0001-01-01 and 0000-00-00-00.00.00.000000)
Question 10 Multiple Choice (Multiple Answers)

The proc coded in all the last technical job in a JCL is

  1. PMYPX075
  2. PMYPX077
  3. PMYPX074
  4. PMYPX076
Question 11 Multiple Choice (Multiple Answers)

What parameter is used for technical jobs that use DB2 check-point restart

  1. CHECKPOINTDB2
  2. CHKPNTDB2
  3. CKPT_DB2
  4. CKPTDB2
Question 12 Multiple Choice (Multiple Answers)

DD names for FB and VB input files are

  1. INPF,INPV
  2. INPFB,INPVB
  3. INFN,INVN
  4. none of the above
Question 13 Multiple Choice (Multiple Answers)

What is the JCL checker utility for error correction

  1. DIOAPLCK
  2. DIOJCLCK
  3. JCLUTLCK
  4. DIOAPLCHK
Question 14 Multiple Choice (Multiple Answers)

For calling the batch routines what is used

  1. XCTL
  2. CALL
  3. LINK
  4. none of the above
Question 15 Multiple Choice (Multiple Answers)

In case of new defects what needs to be done

  1. raise new defect,retest,close
  2. raise new defect,retest
  3. raise new defect,fix the defect,retest,close
  4. Retest to eliminate the defect
Question 16 Multiple Choice (Multiple Answers)

Incase of batch,While executing test cases where the output file needs to be mentioned

  1. Q04
  2. Q01
  3. PRD
  4. DEV
Question 17 Multiple Choice (Multiple Answers)

What is the only statement in the EXIT para

  1. EXIT
  2. 1000-EXIT
  3. 1000_EXIT
  4. BOTH 1 and 2
Question 18 Multiple Choice (Multiple Answers)

What macro is used to identify the impact to all related components before construction/delivery/deployment

  1. BMX/VMX
  2. SERCHFOR
  3. MAGIC BMX/VMX
  4. NONE OF THIS
Question 19 Multiple Choice (Multiple Answers)

What macro is used to identify the impact to all related components before construction/delivery/deployment

  1. MAGIC BMX/VMX
  2. BMX/VMX
  3. SERCHFOR
  4. NONE OF THIS
Question 20 Multiple Choice (Multiple Answers)

If a validation indicator from DB2 is retrieved and validated,the program should handle it for values

  1. y,n
  2. invalid values
  3. row not found
  4. all of the above