本文列举了一些常见的DB2 for z/OS DBA面试问题及其答案，涉及DB2版本检查、COPY实用程序的共享级别、REORG前的准备、异常处理策略、SQL错误代码解析、绑定包与重新绑定包的区别、数据库恢复选项、表空间类型等关键知识点。
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/
最低0.47元/天 解锁文章
4276
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
