DB2 DBA(Z/os) Interview questions - Part 2(utilities)

Q1)What are all the Reorg varieties ?
Ans: Online reorg and offline reorg.
Offline reorg: To run an offline reorg we need to mention SHRLEVEL NONE in the utility cntl card. In offline reorg other users/processes will not be having any access to the tablespace.
Online reorg: SHRLEVEL REFERENCE or SHRLEVEL CHANGE will give other users/processes read access or read-write access respectively.

Q2) What are all the reorg phases explain them?
Ans: UTILINIT-UNLOAD-RELOAD-SORT-BUILD-LOG-SWITCH-BUILD2-UTILTERM
you need to tell what happens in each phase.

Q3) What is the difference between LOAD RESUME YES and LOAD RESUME NO ?
Ans:

DB2 DBA(Z/os) interview questions -Part 1 (General)

I have attended quite a number of interview calls , I am listing those questions with answers.....

Q1)What is the DB2 version you are working on?
Ans: To know the Db2 version issue -DIS GROUP command from your SPUFI main panel command option.
Q2)What is the Z/OS version you are working on?
Ans: I don't know a command to know this , but you should be knowing your Z/os version ..the versions are like V1.8 ,v1.9, v1.10
Q3)How do you restart a job from a particular step in a proc?
Ans: add a paramater RESTART=procname.stepname in the job card and submit the job.
Q4)What are all versions you have worked on? Can you list some differences between the versions you have worked on?
Ans: Here you need to tell the versions and few advancements in latest versions.

I will keep on adding here..........