4.12. Review Questions

1:Which of the DB2 tools can be used to schedule SQL scripts in DB2?
2:The DB2 Command Window is only available on Windows. What is the equivalent tool on the Linux/UNIX platforms?
3:Which registry variable needs to be changed to set autocommit to off permanently for the CLP?
4:When is it handy to start the CLP in interactive mode with a different terminator character as in db2 -td!?
5:Which command is necessary to guarantee the CLP back-end process is terminated?
6:How can Visual Explain be invoked?
7:Which tool can be used to develop SQL user-defined functions?
8:Can the Control Center be used to administer DB2 for iSeries databases?
9:It's 9:00 a.m. and you would like to investigate a problem that happened at 3:00 a.m. Where ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.