Deprecated functionality
Functionality gets marked as deprecated when a specific function or feature is supported in the current release but might be removed in a future release. In some cases, it might be advisable to plan to discontinue the use of deprecated functionality.
For example, a registry variable might be deprecated in this release because the behavior triggered by the registry variable has been enabled by default in this release, and the obsolete registry variable will be removed in a future release.
Review the details for each deprecation and plan how to manage future changes.
The following Db2® Big SQL functionality is deprecated.
| Deprecated capability | Details | Resolution |
|---|---|---|
| TABLE keyword for the CREATE INDEX (HBASE) statement | The TABLE keyword is deprecated and was removed in Big SQL 5.0.1. | Specify a table name without using the TABLE keyword. For more information, see CREATE INDEX (HBASE) statement. |
| High availability (HA) managed by Tivoli® System Automation (TSA) | HA that is managed by Tivoli System Automation (TSA) is deprecated and was removed in Db2 Big SQL 5.0.4. | HA is now managed through Python scripts that interact with Apache ZooKeeper, a hierarchical key-value store that is used by several other Hadoop services for HA solutions, such as HDFS and YARN. For more information, see ZooKeeper-automated failover. |
| <data type> STORED AS <data type> in CREATE TABLE (HADOOP) and ALTER TABLE (HADOOP/HBASE) statements. | This support is deprecated in Db2 Big SQL 5.0.4 and will be removed in a future release. | Do not use the syntax. For example, when creating a table in Db2 Big SQL before DATE data type was supported by Hive, DATE STORED AS TIMESTAMP could be used to provide some capability of DATE support. Now DATE is supported natively, so this construct should not be used. |
| C++ I/O interface | The Big SQL C++ I/O interface is deprecated and was removed in Db2 Big SQL 6.0. | In Db2 Big SQL 5.0.3 and above, all input and output processing is driven by the Java™ I/O interface by default. For more information, see Db2 Big SQL readers and writers. |
| COMPATIBILITY_MODE special register | This support is deprecated in Db2 Big SQL 7.0 and will be removed in a future release. | Do not use this global variable. |
| HMETA_TAB_BACKUP | This support is deprecated in Db2 Big SQL 7.0 and will be removed in a future release. | Do not use this table function. |