IBM Books

Administrative API Reference


Chapter 3. Data Structures

This section describes the data structures used to access the database manager. The following data structures are provided:

db2HistData
Used by the recovery history file APIs to return information from the recovery history file

RFWD-INPUT
Transfers rollforward information between an application and the database manager

RFWD-OUTPUT
Transfers rollforward information between an application and the database manager

SQL-AUTHORIZATIONS
Returns authorizations information

SQL-DIR-ENTRY
Passes Database Connection Services directory information

SQLA-FLAGINFO
Holds flagger information

SQLB-TBS-STATS
Returns additional table space statistics to an application program

SQLB-TBSCONTQRY-DATA
Returns container data to an application program

SQLB-TBSPQRY-DATA
Returns table space data to an application program

SQLCA
Returns error information to an application

SQLCHAR
Transfers variable length data between an application and the database manager

SQLDA
Transfers collections of data between an application and the database manager

SQLDCOL
Passes column information to the IMPORT and EXPORT APIs

SQLE-ADDN-OPTIONS
Passes information to sqleaddn - Add Node

SQLE-CLIENT-INFO
Passes information to the client information APIs (see sqleseti - Set Client Information and sqleqryi - Query Client Information)

SQLE-CONN-SETTING
Specifies connection setting types and values

SQLE-NODE-APPC
Passes information for cataloging APPC nodes

SQLE-NODE-APPN
Passes information for cataloging APPN nodes

SQLE-NODE-CPIC
Passes information for cataloging CPIC nodes

SQLE-NODE-IPXSPX
Passes information for cataloging IPX/SPX nodes

SQLE-NODE-LOCAL
Passes information for cataloging LOCAL nodes

SQLE-NODE-NETB
Passes information for cataloging NetBIOS nodes

SQLE-NODE-NPIPE
Passes information for cataloging named pipe nodes

SQLE-NODE-STRUCT
Passes information for cataloging nodes

SQLE-NODE-TCPIP
Passes information for cataloging TCP/IP nodes

SQLE-REG-NWBINDERY
Passes information for registering/deregistering the DB2 server in/from the bindery on the NetWare file server

SQLE-START-OPTIONS
Holds the database manager start-up options

SQLEDBCOUNTRYINFO
Transfers country information between an application and the database manager

SQLEDBDESC
Passes creation parameters to the CREATE DATABASE API

SQLEDBSTOPOPT
Holds the database manager stop options

SQLEDINFO
Returns a copy of a single directory entry from the system or local database directory

SQLENINFO
Returns a copy of a single directory entry from the node directory

SQLFUPD
Passes configuration file information

SQLM-COLLECTED
Transfers Database System Monitor collection count information between an application and the database manager

SQLM-RECORDING-GROUP
Transfers Database System Monitor monitor group information between an application and the database manager

SQLMA
Sends database monitor requests from an application to the database manager

SQLOPT
Transfers bind parameters to the BIND API and precompile options to the PRECOMPILE PROGRAM API

SQLU-LSN
Contains the definition of the log sequence number used by the ASYNCHRONOUS READ LOG API

SQLU-MEDIA-LIST
Holds a list of target media (BACKUP) or source media (RESTORE) for the backup image. Also used for the import, export and load APIs

SQLU-RLOG-INFO
Contains information regarding a call to the ASYNCHRONOUS READ LOG API

SQLU-TABLESPACE-BKRST-LIST
Provides a list of table space names

SQLUEXPT-OUT
Transfers export information between an application and the database manager

SQLUIMPT-IN
Transfers import information between an application and the database manager

SQLUIMPT-OUT
Transfers import information between an application and the database manager

SQLULOAD-IN
Transfers load information between an application and the database manager

SQLULOAD-OUT
Transfers load information between an application and the database manager

SQLUPI
Contains partitioning information, such as the partitioning map and the partitioning key of a table

SQLXA-RECOVER
Used by the transaction APIs to return a list of indoubt transactions

SQLXA-XID
Used by the transaction APIs to identify a transaction.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]