DB2 Server for VM: System Administration


V3R5 and V3R4 Incompatibilities

  1. SQL/DS Database Archive Incompatibilities

    Archives that were created on prior releases of SQL/DS cannot be restored by the SQL/DS V3R5 database manager. If this is attempted, the database manager will issue message ARI2038E and terminate. See the DB2 Server for VM Messages and Codes or DB2 Server for VSE Messages and Codes manual for more details on this message.

  2. SQL/DS VSAM Shareoptions Changes under VSE

    In prior releases of SQL/DS (VSE), the VSAM SQL/DS directory, data and log data sets were defined with SHAREOPTIONS(1). In SQL/DS V3R5, these VSAM files must now be defined with SHAREOPTIONS(2).

  3. SQLSTATE Values Changes

    Many SQLSTATE values have changed in SQL/DS V3R5. The new SQLSTATE values and their former values can be found in the DB2 Server for VM Messages and Codes or DB2 Server for VSE Messages and Codes manuals. Changing SQLSTATEs is an incompatible change since many SQLSTATE values that are returned from diagnostic situations will be different from previous releases of SQL/DS. Application programmers should review any programs that use SQLSTATE in the SQLCA each time an SQL statement is executed.

  4. Messages and Codes Changes

    Some SQL/DS messages and codes have changed, and some new ones have been added in SQL/DS V3R5. See the DB2 Server for VM Messages and Codes and DB2 Server for VSE Messages and Codes manuals for details.

  5. Display CICS Information on SHOW CONNECT

    If the package that the connected user is running was created in SQL/DS Version 2 Release 2 or earlier, the CICS information will not be displayed by the SHOW CONNECT command because the RDIIN for V2R2 or earlier does not contain the RDIIN extension area. The package must be reprepped with SQL/DS V3R5 and recompiled to make the CICS information available.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]