Image, Audio, and Video Extenders Administration and Programming
Enables a database for audio (DB2Audio data). This API is called
once per database. It defines a DB2 user-defined type, DB2Audio, to the
database manager. It also creates all UDFs that manipulate DB2Audio
data. It is recommended that after calling this API you issue an SQL
COMMIT statement.
Authorization
DBADM, SYSADM, SYSCTRL
Library file
OS/2 and Windows
| AIX, HP-UX, and Solaris
|
dmbaudio.lib
| libdmbaudio.a (AIX)
|
| libdmbaudio.sl (HP-UX)
|
| libdmbaudio.so (Solaris)
|
Include file
dmbaudio.h
Syntax
long DBaEnableDatabase(
char *tableSpace
);
Parameters
- tableSpace (in)
- The name of the table space, which is a collection of containers into
which administrative tables are stored. The table space specification
has three parts as follows: datats, indexts, longts, where
datats is the table space in which metadata tables are created;
indexts is the table space in which indexes on the metadata tables
are created; and longts is the table space in which values of
long columns in the metadata tables (such as those that contain LONG VARCHAR
and LOB data types) are stored. If you provide a null value for any
part of the table space specification, the default table space for that part
is used.
EEE Only: The tablespaces specified when enabling a
database for an extender should be defined on a nodegroup that includes all
the nodes in the partitioned database system.
Error codes
- MMDB_SUCCESS
- API call processed successfully.
- MMDB_RC_NO_AUTH
- Caller does not have the proper access authority.
- MMDB_WARN_ALREADY_ENABLED
- The database is already enabled.
- MMDB_RC_API_NOT_SUPPORTED_FOR_SERVER
- The server connected to does not support this command.
- MMDB_WARN_NOT_ALL_NODES
- Tablespace specified does not include all nodes for the extender.
(EEE Only)
- MMDB_RC_NOT_SAME_NODEGROUP
- Tablespaces specified are not in the same nodegroup. (EEE
Only)
-
-
Examples
Enable the current database for audio (DB2Audio data) in the table space
MYTS. Use defaults for the index and long table spaces:
#include <dmbaudio.h>
rc = DBaEnableDatabase("myts,,");
Enable the current database for audio (DB2Audio data); use default
table spaces:
#include <dmbaudio.h>
rc = DBaEnableDatabase(NULL);
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]