This section describes issues that should be considered before migrating an application to Version 7.
There are four possible operating scenarios:
The first and the fourth are consistent operating environments that do not require qualification.
The second, in which only the databases have been migrated, should work without changes to any application, because back-level applications are supported. However, as with any new version, a small number of incompatibilities can occur, and these are described in the Administration Guide.
For the third scenario, in which applications are to be updated with Version 7 APIs, the following points should be considered:
APIs that are not listed do not require changes following migration of an application.
Note that an application may contain the generic version of an API call, depending on the application programming language being used. In all cases, the generic version of the API name is identical to the C version of the name, with the exception that the fourth character is always g.
Table 142. Back-level Supported APIs
| API (Version) | Descriptive Name | New API (Version) |
|---|---|---|
| sqlbftsq (V2) | Fetch Tablespace Query | sqlbftpq (V5) |
| sqlbstsq (V2) | Single Tablespace Query | sqlbstpq (V5) |
| sqlbtsq (V2) | Tablespace Query | sqlbmtsq (V5) |
| sqlectdd (V2) | Catalog Database | sqlecadb (V5) |
| sqlepstr (V2) | Start Database Manager (DB2 Parallel Edition Version 1.2) | sqlepstart (V5) |
| sqlestar (V2) | Start Database Manager (DB2 Version 2) | sqlepstart (V5) |
| sqlestop (V2) | Stop Database Manager | sqlepstp (V5) |
| sqlerstd (V5) | Restart Database | db2DatabaseRestart (V6) |
| sqlmon (V6) | Get/Update Monitor Switches | db2MonitorSwitches (V7) |
| sqlmonss (V5) | Get Snapshot | db2GetSnapshot (V6) |
| sqlmonsz (V6) | Estimate Size Required for sqlmonss() Output Buffer | db2GetSnapshotSize (V7) |
| sqlmrset (V6) | Reset Monitor | db2ResetMonitorData (V7) |
| sqlubkup (V2) | Backup Database | sqlubkp (V5) |
| sqlugrpi (V2) | Get Row Partitioning Information (DB2 Parallel Edition Version 1.x) | sqlugrpn (V5) |
| sqluhcls (V5) | Close Recovery History File Scan | db2HistoryCloseScan (V6) |
| sqluhget (V5) | Retrieve DDL Information From the History File | db2HistoryGetEntry (V6) |
| sqluhgne (V5) | Get Next Recovery History File Entry | db2HistoryGetEntry (V6) |
| sqluhops (V5) | Open Recovery History File Scan | db2HistoryOpenScan (V6) |
| sqluhprn (V5) | Prune Recovery History File | db2Prune (V6) |
| sqluhupd (V5) | Update Recovery History File | db2HistoryUpdate (V6) |
| sqluqry (V5) | Load Query | db2LoadQuery (V6) |
| sqlursto (V2) | Restore Database | sqlurst (V5) |
| sqlxhcom (V2) | Commit an Indoubt Transaction | sqlxphcm (V5) |
| sqlxhqry (V2) | List Indoubt Transactions | sqlxphqr (V5) |
| sqlxhrol (V2) | Roll Back an Indoubt Transaction | sqlxphrl (V5) |
| SQLB-TBSQRY-DATA (V2) | Table space data structure. | SQLB-TBSPQRY-DATA (V5) |
| SQLEDBSTRTOPT (V2) | Start Database Manager data structure (DB2 Parallel Edition Version 1.2) | SQLE-START-OPTIONS (V5) |
| SQLUHINFO and SQLUHADM (V5) | History file data structures. | db2HistData (V6) |
Table 143. Back-level Unsupported APIs
| Name | Descriptive Name | APIs Supported in V7 |
|---|---|---|
| sqlufrol/sqlgfrol | Roll Forward Database (DB2 Version 1.1) | sqluroll |
| sqluprfw | Rollforward Database (DB2 Parallel Edition Version 1.x) | sqluroll |
| sqlurfwd/sqlgrfwd | Roll Forward Database (DB2 Version 1.2) | sqluroll |
| sqlurllf/sqlgrfwd | Rollforward Database (DB2 Version 2) | sqluroll |