Gienini Blog

API Type	DB2 API	Include File	Sample pgm C/C++	Sample Pgm COBOL
Table space and table management	sqluvqdp API - Quiesce table spaces for a table	sqlutil	tbmove.sqc	tload.sqb
Table space and table management	sqlbstpq API - Get information about a single table space	sqlutil		tabspace.sqb tspace.sqb
Table space and table management	sqlbftpq API - Fetch the query data for rows in a table space	sqlutil		tabspace.sqb tspace.sqb
Table space and table management	sqlbstsc API - Set table space containers	sqlutil	dbrecov.sqc	tabscont.sqb tspace.sqb
Table space and table management	sqlbotcq API - Open a table space container query	sqlutil		tabscont.sqb tspace.sqb
Table space and table management	sqlbftcq API - Fetch the query data for rows in a table space container	sqlutil		tabscont.sqb tspace.sqb
Table space and table management	sqlbctcq API - Close a table space container query	sqlutil		tabscont.sqb tspace.sqb
Table space and table management	sqlefmem API - Free the memory allocated by the sqlbtcq and sqlbmtsq API	sqlenv	dbrecov.sqc	tabscont.sqb tabspace.sqb tspace.sqb
Client/server management	sqlesact API - Set accounting string	sqlenv		setact.cbl
Application programming and preparation	sqlarbnd API - Rebind package	sql	dbpkg.sqc	rebind.sqb
Node directory management	sqlectnd API - Catalog an entry in the node directory	sqlenv	ininfo.c	nodecat.cbl
Node directory management	sqleuncn API - Uncatalog an entry from the node directory	sqlenv	ininfo.c	nodecat.cbl
Node directory management	sqlenops API - Start a node directory scan	sqlenv	ininfo.c	nodecat.cbl
Node directory management	sqlengne API - Get the next node directory entry	sqlenv	ininfo.c	nodecat.cbl
Node directory management	sqlencls API - End a node directory scan	sqlenv	ininfo.c	nodecat.cbl
Data movement	db2LoadQuery API - Get the status of a load operation	db2ApiDf	tbmove.sqc	loadqry.sqb
Data movement	db2Export API - Export data from a database	sqlutil	tbmove.sqc	expsamp.sqb impexp.sqb tload.sqb
Data movement	db2Import API - Import data into a table, hierarchy, nickname or view	db2ApiDf	dtformat.sqc tbmove.sqc	expsamp.sqb impexp.sqb
Database directory and DCS directory management	sqlegdad API - Catalog a database in the database connection services (DCS) directory	sqlenv	ininfo.c	dcscat.cbl
Database directory and DCS directory management	sqlegdel API - Uncatalog a database from the database connection services (DCS) directory	sqlenv	ininfo.c	dcscat.cbl
Database directory and DCS directory management	sqlegdsc API - Start a database connection services (DCS) directory scan	sqlenv	ininfo.c	dcscat.cbl
Database directory and DCS directory management	sqlegdgt API - Get database connection services (DCS) directory entries	sqlenv	ininfo.c	dcscat.cbl
Database directory and DCS directory management	sqlegdcl API - End a database connection services (DCS) directory scan	sqlenv	ininfo.c	dcscat.cbl
Database directory and DCS directory management	sqlegdge API - Get a specific entry in the database connection services (DCS) directory	sqlenv	ininfo.c	dcscat.cbl
Database control	db2DatabaseUpgrade API - Upgrade previous version of DB2 database to the current release	db2ApiDf	dbupgrade.c	dbupgrade.cbl
Database control	sqlefrce API - Force users and applications off the system	sqlenv	dbconn.sqc dbsample.sqc instart.c	dbstop.cbl
Table space and table management	db2Runstats API - Update statistics for tables and indexes	db2ApiDf	tbreorg.sqc	dbstat.sqb
Table space and table management	db2Reorg API - Reorganize an index or a table	db2ApiDf	tbreorg.sqc	dbstat.sqb
Instance control	sqlegins API - Get current instance	sqlenv	ininfo.c	dbinst.cbl
Instance control	sqleatin API - Attach to instance	sqlenv	inattach.c utilapi.c	dbinst.cbl
Instance control	sqledtin API - Detach from instance	sqlenv	inattach.c utilapi.c	dbinst.cbl
Instance control	sqleatcp API - Attach to instance and change password	sqlenv	inattach.c	dbinst.cbl
Database control	sqledrpd API - Drop database	sqlenv	dbcreate.c	dbconf.cbl
Database directory and DCS directory management	sqledcgd API - Change a database comment in the system or local database directory	sqlenv	ininfo.c	dbcmt.cbl
Client/server management	sqleisig API - Install signal handler	sqlenv		dbcmt.cbl
Application programming and preparation	sqleisig API - Install signal handler	sqlenv		dbcmt.cbl
Database directory and DCS directory management	db2DbDirOpenScan API - Start a system or local database directory scan	db2ApiDf	ininfo.c	dbcat.cbl dbcmt.cbl
Database directory and DCS directory management	db2DbDirGetNextEntry API - Get the next system or local database directory entry	db2ApiDf	ininfo.c	dbcat.cbl dbcmt.cbl
Database directory and DCS directory management	db2DbDirCloseScan API - End a system or local database directory scan	db2ApiDf	ininfo.c	dbcat.cbl dbcmt.cbl
Database directory and DCS directory management	sqlecadb API - Catalog a database in the system database directory	sqlenv	ininfo.c	dbcat.cbl
Database directory and DCS directory management	sqleuncd API - Uncatalog a database from the system database directory	sqlenv	ininfo.c	dbcat.cbl
Database control	sqlecrea API - Create database	sqlenv	dbcreate.c dbrecov.sqc dbsample.sqc	db_udcs.cbl dbconf.cbl ebcdicdb.cbl
Client/server management	sqlesetc API - Set client connection settings	sqlenv	cli_info.c dbcfg.sqc dbmcon.sqc	client.cbl
Client/server management	sqleqryc API - Query client connection settings	sqlenv	cli_info.c	client.cbl
Application programming and preparation	sqlogstt API - Get the SQLSTATE message	sql	utilapi.c	checkerr.cbl
Application programming and preparation	sqlaintp API - Get error message	sql	dbcfg.sqc utilapi.c	checkerr.cbl
Database monitoring	db2MonitorSwitches API - Get or update the monitor switch settings	db2ApiDf	utilsnap.c
Database monitoring	db2GetSnapshot API - Get a snapshot of the database manager operational status	db2ApiDf	utilsnap.c
Database health monitoring	db2GetSnapshot API - Get a snapshot of the database manager operational status	db2ApiDf	utilsnap.c
Instance control	db2InstanceStart API - Start instance	db2ApiDf	instart.c
Instance control	db2InstanceStop API - Stop instance	db2ApiDf	instart.c
Database partition management	sqlesdeg API - Set the maximum runtime intrapartition parallelism level or degree for SQL statements	sqlenv	ininfo.c
Data movement	db2Load API - Load data into a table	db2ApiDf	dtformat.sqc tbload.sqc tbmove.sqc
for obtaining concurrent access to a database	sqleAttachToCtx API - Attach to context	sql	dbthrds.sqc
for obtaining concurrent access to a database	sqleBeginCtx API - Create and attach to an application context	sql	dbthrds.sqc
for obtaining concurrent access to a database	sqleDetachFromCtx API - Detach from context	sql	dbthrds.sqc
for obtaining concurrent access to a database	sqleSetTypeCtx API - Set application context type	sql	dbthrds.sqc
Recovery	db2Backup API - Back up a database or table space	db2ApiDf	dbrecov.sqc
Recovery	db2Restore API - Restore a database or table space	db2ApiDf	dbrecov.sqc
Recovery	db2Rollforward API - Roll forward a database	db2ApiDf	dbrecov.sqc
Recovery	db2HistoryOpenScan API - Start a database history records scan	db2ApiDf	dbrecov.sqc
Recovery	db2HistoryGetEntry API - Get the next entry in the database history records	db2ApiDf	dbrecov.sqc
Recovery	db2HistoryCloseScan API - End the database history records scan	db2ApiDf	dbrecov.sqc
Recovery	db2Prune API - Delete the history file entries or log files from the active log path	db2ApiDf	dbrecov.sqc
Recovery	db2HistoryUpdate API - Update a database history records entry	db2ApiDf	dbrecov.sqc
Read log files	db2ReadLog API - Read log records	db2ApiDf	dbrecov.sqc
Application programming and preparation	sqlabndx API - Bind application program to create a package	sql	dbpkg.sqc dbsample.sqc
Application programming and preparation	sqlaprep API - Precompile application program	sql	dbpkg.sqc
Database manager and database configuration	db2CfgGet API - Get the database manager or database configuration parameters	db2ApiDf	dbinfo.c dbrecov.sqc ininfo.c tscreate.sqc
Database manager and database configuration	db2CfgSet API - Set the database manager or database configuration parameters	db2ApiDf	dbinfo.c dbrecov.sqc ininfo.c
Database control	db2DatabaseRestart API - Restart database	db2ApiDf	dbconn.sqc
Database manager and database configuration	db2AutoConfig API - Access the Configuration Advisor	db2AuCfg	dbcfg.sqc
Database manager and database configuration	db2AutoConfigFreeMemory API - Free the memory allocated by the db2AutoConfig API	db2AuCfg	dbcfg.sqc
Client/server management	sqleqryi API - Query client information	sqlenv	cli_info.c
Client/server management	sqleseti API - Set client information	sqlenv	cli_info.c
Database control	db2DatabaseQuiesce API - Quiesce the database	db2ApiDf
Database control	db2DatabaseUnquiesce API - Unquiesce database	db2ApiDf
Database control	sqlecran API - Create a database on a database partition server	sqlenv
Database control	sqledpan API - Drop a database on a database partition server	sqlenv
Database control	db2XaListIndTrans API - List indoubt transactions	db2ApiDf
Database control	sqle_activate_db API - Activate database	sqlenv
Database control	sqle_deactivate_db API - Deactivate database	sqlenv
Database control	sqlcspqy API - List DRDA indoubt transactions	sqlxa
Database control	db2SetWriteForDB API - Suspend or resume I/O writes for database	db2ApiDf
Instance control	db2InstanceQuiesce API - Quiesce instance	db2ApiDf
Instance control	db2InstanceUnquiesce API - Unquiesce instance	db2ApiDf
Instance control	db2UtilityControl API - Set the priority level of running utilities	db2ApiDf
Database monitoring	db2GetSnapshotSize API - Estimate the output buffer size required for the db2GetSnapshot API	db2ApiDf
Database monitoring	db2AddSnapshotRequest API - Add a snapshot request	db2ApiDf
Database monitoring	db2ResetMonitor API - Reset the database system monitor data	db2ApiDf
Database monitoring	db2ConvMonStream API - Convert the monitor stream to the pre-version 6 format	db2ApiDf
Database monitoring	db2Inspect API - Inspect database for architectural integrity	db2ApiDf
Database health monitoring	db2AddContact API - Add a contact to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2AddContactGroup API - Add a contact group to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2DropContact API - Remove a contact from the list of contacts to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2DropContactGroup API - Remove a contact group from the list of contacts to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2GetAlertCfg API - Get the alert configuration settings for the health indicators	db2ApiDf
Database health monitoring	db2GetAlertCfgFree API - Free the memory allocated by the db2GetAlertCfg API	db2ApiDf
Database health monitoring	db2GetContactGroup API - Get the list of contacts in a single contact group to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2GetContactGroups API - Get the list of contact groups to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2GetContacts API - Get the list of contacts to whom notification messages can be sent	db2ApiDf
Database health monitoring	db2GetHealthNotificationList API - Get the list of contacts to whom health alert notifications can be sent	db2ApiDf
Database health monitoring	db2ResetAlertCfg API - Reset the alert configuration of health indicators	db2ApiDf
Database health monitoring	db2UpdateAlertCfg API - Update the alert configuration settings for health indicators	db2ApiDf
Database health monitoring	db2UpdateContact API - Update the attributes of a contact	db2ApiDf
Database health monitoring	db2UpdateContactGroup API - Update the attributes of a contact group	db2ApiDf
Database health monitoring	db2UpdateHealthNotificationList API - Update the list of contacts to whom health alert notifications can be sent	db2ApiDf
Database health monitoring	db2GetSnapshotSize API - Estimate the output buffer size required for the db2GetSnapshot API	db2ApiDf
Database health monitoring	db2GetRecommendations API - Get recommendations to resolve a health indicator in alert state	db2ApiDf
Database health monitoring	db2GetRecommendationsFree API - Free the memory allocated by the db2GetRecommendations API	db2ApiDf
Data movement	db2Ingest API- Ingest data from an input file or pipe into a DB2 table	db2ApiDf
Recovery	db2Recover API - Restore and roll forward a database	db2ApiDf
Recovery	db2ArchiveLog API - Archive the active log file	db2ApiDf
High Availability Disaster Recovery (HADR)	db2HADRStart API - Start high availability disaster recovery (HADR) operations	db2ApiDf
High Availability Disaster Recovery (HADR)	db2HADRStop API - Stop high availability disaster recovery (HADR) operations	db2ApiDf
High Availability Disaster Recovery (HADR)	db2HADRTakeover API - Instruct a database to take over as the high availability disaster recovery (HADR) primary database	db2ApiDf
Database directory and DCS directory management	db2UpdateAlternateServerForDB API - Update the alternate server for a database alias in the system database directory	db2ApiDf
Client/server management	db2DatabasePing API - Ping the database to test network response time	db2ApiDf
Client/server management	sqleintr API - Interrupt application requests	sqlenv
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapRegister API - Register the DB2 server on the LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapUpdate API - Update the attributes of the DB2 server on the LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapDeregister API - Deregister the DB2 server and cataloged databases from the LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapCatalogNode API - Provide an alias for node name in LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapUncatalogNode API - Delete alias for node name from LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapCatalogDatabase API - Register the database on the LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapUncatalogDatabase API - Deregister database from LDAP server	db2ApiDf
Lightweight Directory Access Protocol (LDAP) directory management	db2LdapUpdateAlternateServerForDB API - Update the alternate server for the database on the LDAP server	db2ApiDf
Application programming and preparation	sqleintr API - Interrupt application requests	sqlenv
COBOL, FORTRAN and REXX application specific	sqlgaddr API - Get the address of a variable	sqlutil
COBOL, FORTRAN and REXX application specific	sqlgdref API - Dereference an address	sqlutil
COBOL, FORTRAN and REXX application specific	sqlgmcpy API - Copy data from one memory area to another	sqlutil
Node directory management	db2UpdateAlternateServerForDB API - Update the alternate server for a database alias in the system database directory	db2ApiDf
Satellite synchronization	db2GetSyncSession API - Get a satellite synchronization session identifier	db2ApiDf
Satellite synchronization	db2QuerySatelliteProgress API - Get the status of a satellite synchronization session	db2ApiDf
Satellite synchronization	db2SetSyncSession API - Set satellite synchronization session	db2ApiDf
Satellite synchronization	db2SyncSatellite API - Start satellite synchronization	db2ApiDf
Satellite synchronization	db2SyncSatelliteStop API - Pause satellite synchronization	db2ApiDf
Satellite synchronization	db2SyncSatelliteTest API - Test whether a satellite can be synchronized	db2ApiDf
Read log files	db2ReadLogNoConn API - Read the database logs without a database connection	db2ApiDf
Read log files	db2ReadLogNoConnInit API - Initialize reading the database logs without a database connection	db2ApiDf
Read log files	db2ReadLogNoConnTerm API - Terminate reading the database logs without a database connection	db2ApiDf
Indoubt transaction management	db2XaListIndTrans API - List indoubt transactions	db2ApiDf
Indoubt transaction management	sqlxhfrg API - Forget transaction status	sqlxa
Indoubt transaction management	sqlxphcm API - Commit an indoubt transaction	sqlxa
Indoubt transaction management	sqlxphrl API - Roll back an indoubt transaction	sqlxa
Indoubt transaction management	sqlcspqy API - List DRDA indoubt transactions	sqlxa
for obtaining concurrent access to a database	sqleEndCtx API - Detach from and free the memory associated with an application context	sql
for obtaining concurrent access to a database	sqleGetCurrentCtx API - Get current context	sql
for obtaining concurrent access to a database	sqleInterruptCtx API - Interrupt context	sql
Database partition management	sqleaddn API - Add a database partition to the partitioned database environment	sqlenv
Database partition management	sqledrpn API - Check whether a database partition server can be dropped	sqlenv
Database partition management	sqlecran API - Create a database on a database partition server	sqlenv
Database partition management	sqledpan API - Drop a database on a database partition server	sqlenv
Database partition management	sqlugtpi API - Get table distribution information	sqlutil
Database partition management	sqlugrpn API - Get the database partition server number for a row	sqlutil
Miscellaneous	db2AdminMsgWrite API - Write log messages for administration and replication function	db2ApiDf
Miscellaneous	db2XaGetInfo API - Get information for a resource manager	sqlxa

Origin: IBM Knowledge Center - DB2 APIs

Juan M.Gienini

DB2 APIs

Contacto: