Required DB2 for VM knowledge

Although QMF has been designed to be installed with a minimum of DB2 for VM knowledge, some knowledge of DB2 for VM is required.

General:

• Identifying programs and userids through the CONNECT command. Understand how the CONNECT command can be used to acquire DBA authority. For more details, see DB2 Server for VSE & VM Database Administration
• What a DBSPACE is and the meaning of a PUBLIC or PRIVATE DBSPACE. DBSPACEs are discussed briefly in QMF DBSPACE requirements. For more details, see DB2 Server for VSE & VM Database Administration
• CREATE, INSERT, and GRANT SQL statements. These SQL statements are used in the QMF installation procedure. Information on what these statements do and how to change them is found in DB2 Server for VSE & VM SQL Reference
• Preprocessing a program. All application programs that contain SQL commands must be preprocessed. Information about preprocessing a program is in DB2 Server for VSE & VM Application Programming
• Familiarity with the terms remote unit of work, application requester, and application server.

  remote unit of work

  QMF supports remote unit of work. With remote unit of work you can connect to locations that have QMF installed in either the DB2 or the DB2 for VM database system.

  application requester and server

  If you use remote unit of work support to access other remote databases, then each VM user machine that can be used to run QMF is known as an application requester for QMF. Each database that contains the QMF database objects is known as an application server for QMF.

• Understanding how CMS communications directories are used by DB2 for VM.