Changed APIs and data structures
This section provides information about the changed APIs and data structures.
Note: Db2 offers binary
compatibility for existing application, as well as compatibility with earlier versions of scripts,
SQL queries, and other supported interfaces. However, there might be compatibility issues with
source code files, as API structures and values might change.
| API or Data Structure (Version) | Descriptive Name | New API, Data Structure, or Table Function (Version) |
|---|---|---|
| sqlbftsq (V2) | Fetch Table Space Query | sqlbftpq (V5) |
| sqlbstsq (V2) | Single Table Space Query | sqlbstpq (V5) |
| sqlbtsq (V2) | Table Space Query | sqlbmtsq (V5) |
| sqlectdd (V2) | Catalog Database | sqlecadb (V5) |
| sqledosd (V8.1) | Open Database Directory Scan | db2DbDirOpenScan (V8.2) |
| sqledgne (V8.1) | Get Next Database Directory Entry | db2DbDirGetNextEntry (V8.2) |
| sqledcls (V8.1) | Close Database Directory Scan | db2DbDirCloseScan (V8.2) |
| sqlepstart (V5) | Start Database Manager | db2InstanceStart (V8) |
| sqlepstp (V5) | Stop Database Manager | db2InstanceStop (V8) |
| sqlepstr (V2) | Start Database Manager (Db2 Parallel Edition Version 1.2) | db2InstanceStart (V8) |
| sqlestar (V2) | Start Database Manager (Db2 Version 2) | db2InstanceStart (V8) |
| sqlestop (V2) | Stop Database Manager | db2InstanceStop (V8) |
| sqlerstd (V5) | Restart Database | db2DatabaseRestart (V6) |
| sqlfddb (V7) | Get Database Configuration Defaults | db2CfgGet (V8) |
| sqlfdsys (V7) | Get Database Manager Configuration Defaults | db2CfgGet (V8) |
| sqlfrdb (V7) | Reset Database Configuration | db2CfgSet (V8) |
| sqlfrsys (V7) | Reset Database Manager Configuration | db2CfgSet (V8) |
| sqlfudb (V7) | Update Database Configuration | db2CfgSet (V8) |
| sqlfusys (V7) | Update Database Manager Configuration | db2CfgSet (V8) |
| sqlfxdb (V7) | Get Database Configuration | db2CfgGet (V8) |
| sqlfxsys (V7) | Get Database Configuration | db2CfgGet (V8) |
| 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 | db2ResetMonitor (V7) |
| sqlubkp (V5) | Backup Database | db2Backup (V8) |
| sqlubkup (V2) | Backup Database | db2Backup (V8) |
| sqluexpr | Export | db2Export (V8) |
| 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) |
| sqluimpr | Import | db2Import (V8) |
| sqluload (V7) | Load | db2Load (V8) |
| sqluqry (V5) | Load Query | db2LoadQuery (V6) |
| sqlureot (V7) | Reorganize Table | db2Reorg (V8) |
| sqlurestore (V7) | Restore Database | db2Restore (V8) |
| sqlurlog (V7) | Asynchronous Read Log | db2ReadLog (V8) |
| sqluroll (V7) | Rollforward Database | db2Rollforward (V8) |
| sqlursto (V2) | Restore Database | sqlurst (V5) |
| sqlustat (V7) | Runstats | db2Runstats (V8) |
| 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) |
| SQLE-START-OPTIONS (V7) | Start Database Manager data structure | db2StartOptionsStruct (V8) |
| SQLEDBSTOPOPT (V7) | Start Database Manager data structure | db2StopOptionsStruct (V8) |
| SQLEDBSTRTOPT (V2) | Start Database Manager data structure (Db2 Parallel Edition Version 1.2) | db2StartOptionsStruct (V8) |
| SQLEDINFO (v8.1) | Get Next Database Directory Entry data structure | db2DbDirInfo (V8.2) |
| SQLUEXPT-OUT | Export output structure | db2ExportOut (V8.2) |
| SQLUHINFO and SQLUHADM (V5) | History file data structures | db2HistData (V6) |
| SQLUIMPT-IN | Import input structure | db2ImportIn (V8.2) |
| SQLUIMPT-OUT | Import output structure | db2ImportOut (V8.2) |
| SQLULOAD-IN (V7) | Load input structure | db2LoadIn (V8) |
| SQLULOAD-OUT (V7) | Load output structure | db2LoadOut (V8) |
| db2DbDirInfo (V8.2) | Get Next Database Directory Entry data structure | db2DbDirInfoV9 (V9.1) |
| db2DbDirNextEntryStruct (V8.2) | Get Next Database Directory Entry data structure | db2DbDirNextEntryStructV9 (V9.1) |
| db2gDbDirNextEntryStruct (V8.2) | Get Next Database Directory Entry data structure | db2gDbDirNextEntryStrV9 (V9.1) |
| sqlbctsq | Close a table space query | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbotsq | Open a table space query | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbftpq | Fetch the query data for rows in a table space | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbgtss | Get table space usage statistics | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbmtsq | Get the query data for all table spaces | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbstpq | Get information about a single table space | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| sqlbtcq | Get the query data for all table space containers | MON_GET_TABLESPACE and the MON_GET_CONTAINER table functions (V9.7) |
| Name | Descriptive Name | Replacement API, data structure or table function |
|---|---|---|
| sqlufrol/sqlgfrol | Roll Forward Database (Db2 Version 1.1) | db2Rollforward |
| sqluprfw | Rollforward Database (Db2 Parallel Edition Version 1.x) | db2Rollforward |
| sqlurfwd/sqlgrfwd | Roll Forward Database (Db2 Version 1.2) | db2Rollforward |
| sqlurllf/sqlgrfwd | Rollforward Database (Db2 Version 2) | db2Rollforward |
| sqlxphqr | List an Indoubt Transaction | db2XaListIndTrans |
| SQLXA-RECOVER | Transaction API structure | db2XaRecoverStruct |
| sqluadau | Get current user's authorities | AUTH_LIST_AUTHORITIES_FOR_AUTHID table function |
| SQL-AUTHORIZATIONS | Authorizations structure | none required |