db2DatabaseQuiesce API - Quiesce the database
Forces all users off the database,
immediately rolls back all active transactions or waits for them to
complete their current units of work within the number of minutes
specified (if they cannot be completed within the specified number
of minutes, the operation will fail), and puts the database into quiesce
mode.
db2DatabaseUnquiesce API - Unquiesce database
Restores user access to databases which have been quiesced
for maintenance or other reasons. User access is restored without
necessitating a shutdown and database restart.
db2GetDistMap API - Get distribution map
Allows an application to obtain the distribution information
for a table. The distribution information includes the distribution
map and the column definitions of the distribution key.
db2GetRowPartNum API - Get the database partition server number for a row
Returns the database partition number and the database
partition server number based on the distribution key values. An application
can use this information to determine on which database partition
server a specific row of a table is stored.
db2InstanceQuiesce API - Quiesce instance
Forces all users off the instance,
immediately rolls back all active transaction, and puts the instance
into quiesce mode.
db2Load API - Load data into a table
Loads data into a DB2 table. Although faster than the import utility,
the load utility does not support loading data at the hierarchy level
or loading into a nickname.
db2Reorg API - Reorganize an index or a table
Reorganizes a table or all indexes defined on a table by
compacting the information and reconstructing the rows or index data
to eliminate fragmented data.
db2Restore API - Restore a database or table space
Recreates a damaged or corrupted database that has been
backed up using the db2Backup API. The restored
database is in the same state it was in when the backup copy was made.
db2Runstats API - Update statistics for tables and indexes
Updates statistics about the characteristics
of a table or any associated indexes or statistical views. This command
can also update statistics about the characteristics of both a table
and any associated indexes or statistical views.
sqlaintp API - Get error message
Retrieves the message associated with an error condition
specified by the sqlcode field of the sqlca structure.
sqlaprep API - Precompile application program
Processes an application program source file containing
embedded SQL statements. A modified source file is produced containing
host language calls for the SQL statements and, by default, a package
is created in the database.
sqlarbnd API - Rebind package
Allows the user to re-create a package stored in the database
without the need for a bind file.
sqlbstsc API - Set table space containers
Facilitates the provision of a redirected
restore, in which the user is restoring a database, and a different
set of operating system storage containers is required.
sqlbtcq API - Get the query data for all table space containers
Provides a one-call interface to the table space container
query data. The query data for all containers in a table space, or
for all containers in all table spaces, is returned in an array.
sqle_activate_db API - Activate database
Activates the specified database and starts up all associated
database services, so that the database is available for connection
and use by any application.
sqleatin API - Attach to instance
Enables an application to specify
the node at which instance-level functions (CREATE DATABASE and FORCE APPLICATION, for example) are to be
executed.
sqlecrea API - Create database
Initializes a new database with an optional user-defined
collating sequence, creates the three initial table spaces, creates
the system tables, and allocates the recovery log.
sqledrpd API - Drop database
Deletes the database contents and all log files for the
database, uncatalogs the database, and deletes the database subdirectory.
sqledtin API - Detach from instance
Removes the logical instance attachment, and terminates
the physical communication connection if there are no other logical
connections using this layer.
sqleisig API - Install signal handler
Installs the default interrupt (usually Control-C or Control-Break, or both) signal handler.
When this default handler detects an
interrupt signal, it resets the signal and calls sqleintr.
sqlengne API - Get the next node directory entry
Returns the next entry in the node directory after sqlenops - Open Node Directory Scan is called. Subsequent
calls to this API return additional entries.
sqleqryc API - Query client connection settings
Returns current connection settings for an application
process. The sqle_conn_setting data structure is
populated with the connection setting types and values.
sqlesetc API - Set client connection settings
Specifies connection settings for the application. Use
the sqle_conn_setting data structure to specify
the connection setting types and values.
sqleseti API - Set client information
Permits an application to set client information (by setting
the fields in the sqle_client_info data structure)
associated with a specific connection, provided a connection already
exists.
sqlgdref API - Dereference an address
Copies data from a buffer that is
defined by a pointer, into a variable that is directly accessible
by the application.
sqlugrpn API - Get the database partition server number for a row
Beginning with
Version 9.7, this API is deprecated. Use the db2GetRowPartNum (Get the database partition server number for a row) API to return
the database partition number and database partition server number
for a row.