我常用的DB2 for z/OS DBA面试题及答案

Q:how to check the version of DB2?
A:use DB2 command, -DIS GROUP

Q:what are the share levels of DB2 COPY utility, what's the difference?
A:SHRLEVEL NONE, REFERENCE, CHANGE. NONE-no user access to tables. REFERENCE-read access only. CHANGE-all access allowed.

Q:What is necessary before you run a REORG?
A:make a backup.

Q:What would you do if a REORG utility abend at RELOAD phase?
A:Try restart the utility from phase or current. If still abend, recovery to the RBA point prior to the reorg, and rerun the reorg.

Q:what would you do if a REORG utility abend at UNLOAD phase?
A:Try restart the utlity from phase or current. if still abend, terminate utility and rerun.

Q:What would you do if a COPY utility abended with B37?
A:B37 measn insufficient space. Try identify if it's no available space on DASD/