IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBaEnableDatabase


Image Audio Video
  X  

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 ]