DB2 Server for VM: System Administration

Software Requirements

The database manager for VM requires an environment provided by IBM Virtual Machine/Enterprise Systems Architecture (VM/ESA operating system), Version 2 Release 3 or later either by itself, or as the base of any VM package. Depending on your intended use of the database manager, you may need other licensed program products, as follows:

• For VSE guest sharing, VSE is required.
• For remote printing by ISQL you need the remote spooling communications subsystem (RSCS) Version 2 Release 3 or later.
• To develop DB2 Server for VM application programs, you can use one or more of the following compilers:
  • A PL/I compiler
  • A COBOL compiler
  • A VS FORTRAN compiler
  • A C Compiler
  • An Assembler.
• The database manager supports some of the enhancements of COBOL II Release 3. You can take advantage of these enhancements if you have a COBOL II Release 3 compiler. For information on using COBOL II Release 3 with the database manager, see the DB2 Server for VSE & VM Application Programming manual.
• To use double-byte character set (DBCS) characters in application programs, you need the following compilers:
  • COBOL II Release 2 compiler

    For COBOL II Release 2 programs, SQL identifiers, SQL host variables, and SQL labels with DBCS characters can be used in SQL statements. The COBOL Kanji preprocessor is not required.

  • PL/I compiler

    For PL/I Release 2.1 programs, SQL identifiers, SQL host variables, and SQL labels with DBCS characters can be used in SQL statements.

  • VS FORTRAN Version 2 Release 3 compiler

    VS FORTRAN Version 2 Release 3 programs support DBCS symbolic names and DBCS characters in character constants.

  • C compiler

    For C programs, SQL identifiers, SQL host variables, and SQL labels with DBCS characters can be used in SQL statements.

  • Assembler compiler

    DBCS variables and constants are not supported in Assembler programs. You can still use DBCS characters in dynamically defined SQL statements.

• If you want to use REXX, you need RXSQL.

  When using RXSQL, you cannot use DBCS characters in cursor names and statement names.

• To provide remote unit of work access between application requesters and application servers in an SNA network, you need VTAM* Version 3 Release 2 or later. If you want to use either partner LU verification or SECURITY=SAME conversations that are routed through AVS, you must have VTAM Version 3 Release 3 and RACF* Version 1 Release 9, or an equivalent security manager product.

  For more information about remote unit of work in a DRDA environment, see the Distributed Relational Database Connectivity Guide manual.

• To archive the database using user facilities, consider using the DASD Dump Restore (DDR) utility included with your VM operating system.

Note:

All references to above programs apply to equivalent non-IBM products.