API Reference

Appendix J. Contacting IBM

This section lists ways you can get more information from IBM.

If you have a technical problem, please take the time to review and carry out the actions suggested by the Troubleshooting Guide before contacting DB2 Customer Support. Depending on the nature of your problem or concern, this guide will suggest information you can gather to help us to serve you better.

For information or to order any of the DB2 Universal Database products contact an IBM representative at a local branch office or contact any authorized IBM software remarketer.

Telephone

If you live in the U.S.A., call one of the following numbers:

1-800-237-5511 to learn about available service options.
1-800-IBM-CALL (1-800-426-2255) or 1-800-3IBM-OS2 (1-800-342-6672) to order products or get general information.
1-800-879-2755 to order publications.

For information on how to contact IBM outside of the United States, see Appendix A of the IBM Software Support Handbook. You can access this document by selecting the "Roadmap to IBM Support" item at: http://www.ibm.com/support/.

Note that in some countries, IBM-authorized dealers should contact their dealer support structure instead of the IBM Support Center.

World Wide Web

http://www.software.ibm.com/data/ http://www.software.ibm.com/data/db2/library/

The DB2 World Wide Web pages provide current DB2 information about news, product descriptions, education schedules, and more. The DB2 Product and Service Technical Library provides access to frequently asked questions, fixes, books, and up-to-date DB2 technical information. (Note that this information may be in English only.)

Anonymous FTP Sites

ftp.software.ibm.com

Log on as anonymous. In the directory /ps/products/db2, you can find demos, fixes, information, and tools concerning DB2 and many related products.

Internet Newsgroups

comp.databases.ibm-db2, bit.listserv.db2-l

These newsgroups are available for users to discuss their experiences with DB2 products.

CompuServe

GO IBMDB2 to access the IBM DB2 Family forums

All DB2 products are supported through these forums.

To find out about the IBM Professional Certification Program for DB2 Universal Database, go to http://www.software.ibm.com/data/db2/db2tech/db2cert.html

Index

Special Characters
A B C D E F G H I K L M N O P Q R S T U V W X

Special Characters

(AFIM_DATA) insert LOB data log record (1199)

abnormal termination

restart (840)

access path

creating new (979)

ACTIVATE DATABASE (sqle_activate_db) (755)

add long field record log record (1193)

ADD NODE (sqleaddn) (757)

AFIM_AMOUNT (insert LOB data log record) (1203)

alias

naming conventions (1061)

alter check pending log record (1166)

alter propagation log record (1165)

alter table add columns log record (1173)

APIs, directory of (725)

application design

code page values, allocating storage for (852), (882)

installing signal handler routine (822)

pointer manipulation (892)

providing pointer manipulation (897), (902)

setting collating sequence (774)

application migration (1262)

application program

access through database manager (729)

ASYNCHRONOUS READ LOG (sqlurlog) (970)

ATTACH (sqleatin) (758)

ATTACH TO CONTEXT (sqleAttachToCtx) (1110)

authentication ID

naming conventions (1073)

authorities

granting when creating a database (769)

authority level

direct, defined (914)

for creating databases, granting (771)

indirect, defined (915)

retrieving user's (912)

backup and restore with vendor products (1080)

BACKUP DATABASE (sqlubkp) (918)

backup end (1252)

BIND

to create new access path (980)

BIND (sqlabndx) (727)

bind option types and values (734)

binding

application programs to databases (730)

defaults (732)

errors during (768)

case sensitivity

in naming conventions (1055)

CATALOG DATABASE (sqlecadb) (759)

CATALOG DCS DATABASE (sqlegdad) (799)

CATALOG NODE (sqlectnd) (775)

CHANGE DATABASE COMMENT (sqledcgd) (778)

CHANGE ISOLATION LEVEL (REXX only) (983)

CLOSE DATABASE DIRECTORY SCAN (sqledcls) (780)

CLOSE DCS DIRECTORY SCAN (sqlegdcl) (804)

CLOSE NODE DIRECTORY SCAN (sqlencls) (824)

CLOSE RECOVERY HISTORY FILE SCAN (sqluhcls) (933)

CLOSE TABLESPACE CONTAINER QUERY (sqlbctcq) (743)

CLOSE TABLESPACE QUERY (sqlbctsq) (744)

COBOL

pointer manipulation (891)

providing pointer manipulation (896), (901)

collating sequence

user-defined (765)

user-defined, sample (773)

column

naming conventions (1068)

specifying for importing (948)

comment

database, changing (779)

COMMIT AN INDOUBT TRANSACTION (sqlxphcm) (1075)

compilers

supported (724)

concurrency

controlling (989)

configuration, database

checking (880)

resetting to default (857)

updating (868)

configuration, database manager

checking (886)

resetting to default (863)

updating (873)

conventions, naming

for aliases (1059)

for authentication IDs (1072)

for columns (1065)

for database manager objects (1053)

for databases (1058)

for tables (1066)

for views (1067)

in SNA (1054)

COPY MEMORY (sqlgmcpy) (898)

CREATE AND ATTACH TO AN APPLICATION CONTEXT (sqleBeginCtx) (1111)

CREATE DATABASE (sqlecrea) (763)

CREATE DATABASE AT NODE (sqlecran) (762)

create index log record (1143)

create table log record (1153)

data manager log records

alter check pending (1162)

alter propagation (1161)

alter table add columns (1169)

create index (1140)

create table (1145)

delete record (1180)

description (1127)

drop index (1141)

drop table (1146)

import replace (truncate) (1131)

initialize table (1128)

insert record (1179)

reorg table (1137)

rollback add columns (1170)

rollback check pending change (1164)

rollback create table (1147)

rollback delete record (1181)

rollback drop table (1148)

rollback insert (1134)

rollback propagation change (1163)

update record (1187)

data skew, redistributing data in nodegroup (920)

DATA structure (1106)

data structures

list of (990)

vendor product (1082)

database

binding application programs (731)

checking configuration (878)

concurrent request processing (986)

creating (766)

deleting, ensuring recovery with log files (793)

dropping (792)

importing file to table (940)

isolating data (985)

naming conventions (1060)

database configuration

checking (881)

file (877)

network parameter values (869)

resetting to default (856)

updating (867)

database configuration file

valid entries (1030)

Database Connection Services (DCS) directory

cataloging entries (800)

copy entries from (813)

retrieving entries from (810)

uncataloging entries (806)

database directory

retrieving next entry from (783)

database manager

starting (830)

stopping (835)

database manager configuration

checking (885)

file (887)

network parameter values (874)

resetting to default (862)

updating (872)

database manager configuration file

valid entries (1032)

DB2 Connect

supported connections to other systems (802)

DB2-INFO structure (1098)

DEACTIVATE DATABASE (sqle_deactivate_db) (756)

default

database configuration, resetting to (858)

database manager configuration, resetting to (864)

DELETE COMMITTED SESSION (sqluvdel) (1095)

delete record log record (1183)

DEREFERENCE ADDRESS (sqlgdref) (893)

DEREGISTER (sqledreg) (790)

DETACH (sqledtin) (796)

DETACH AND DESTROY APPLICATION CONTEXT (sqleEndCtx) (1113)

DETACH FROM CONTEXT (sqleDetachFromCtx) (1112)

directories

cataloging (777)

Database Connection Services

retrieving entries from (809)

Database Connection Services (DCS), cataloging entries (801)

Database Connection Services (DCS), uncataloging entries (807)

Database Connection Services, copy entries from (812)

deleting entries (850)

local database (788)

OPEN DCS DIRECTORY SCAN (816)

retrieving entries from (827)

retrieving next entry from (782)

system database (787)

system database, cataloging (761)

uncataloging (848)

discontinued APIs and data structures (1264)

DROP DATABASE (sqledrpd) (791)

DROP DATABASE AT NODE (sqledpan) (789)

drop index log record (1144)

DROP NODE VERIFY (sqledrpn) (795)

drop table log record (1154)

error message

restore (977)

error messages

database configuration file (853), (883)

database description block structure (772)

dropping remote database (794)

during binding (733)

during roll-forward (972)

invalid checksum, database configuration file (860), (870)

invalid checksum, database manager configuration file (865), (875)

retrieving from SQLCODE field (736)

return codes (738), (910)

ESTIMATE SIZE REQUIRED FOR sqlmonss() OUTPUT BUFFER (sqlmonsz) (905)

EXPORT (sqluexpr) (921)

exporting

choosing file formats for (928)

specifying column names (922)

to PC/IXF format (929)

FETCH TABLESPACE CONTAINER QUERY (sqlbftcq) (745)

FETCH TABLESPACE QUERY (sqlbftpq) (746)

FORCE APPLICATION (sqlefrce) (798)

FORGET TRANSACTION STATUS (sqlxhfrg) (1074)

FORTRAN

pointer manipulation (890)

providing pointer manipulation (895), (900)

FREE MEMORY (sqlefmem) (797)

GET ADDRESS (sqlgaddr) (888)

GET AUTHORIZATIONS (sqluadau) (911)

GET CURRENT CONTEXT (sqleGetCurrentCtx) (1114)

GET DATABASE CONFIGURATION (sqlfxdb) (876)

GET DATABASE CONFIGURATION DEFAULTS (sqlfddb) (851)

GET DATABASE MANAGER CONFIGURATION (sqlfxsys) (884)

GET DATABASE MANAGER CONFIGURATION DEFAULTS (sqlfdsys) (854)

GET DCS DIRECTORY ENTRIES (sqlegdgt) (811)

GET DCS DIRECTORY ENTRY FOR DATABASE (sqlegdge) (808)

GET ERROR MESSAGE (sqlaintp) (735)

GET INSTANCE (sqlegins) (817)

GET NEXT DATABASE DIRECTORY ENTRY (sqledgne) (781)

GET NEXT NODE DIRECTORY ENTRY (sqlengne) (825)

GET NEXT RECOVERY HISTORY FILE ENTRY (sqluhgne) (934)

GET ROW PARTITIONING NUMBER (sqlugrpn) (930)

GET SNAPSHOT (sqlmonss) (904)

GET SQLSTATE MESSAGE (sqlogstt) (907)

GET TABLE PARTITIONING INFORMATION (sqlugtpi) (931)

GET TABLESPACE STATISTICS (sqlbgtss) (747)

GET/UPDATE MONITOR SWITCHES (sqlmon) (903)

global pending list log record (1229)

heuristic aborts log record (1223)

heuristic commit log record (1211)

host systems

connections supported by DDCS (803)

IMPORT (sqluimpr) (939)

import replace (truncate) log record (1133)

importing

delimited ACSII file (923), (949)

file to database table (942)

Non-delimited ASCII file (924), (950)

PC/IXF

file (926), (952)

PC/IXF files (962)

prerequisites for (961)

to remote database (963)

WSF file (925), (951)

INIT-INPUT structure (1102)

INIT-OUTPUT structure (1104)

INITIALIZE AND LINK TO DEVICE (sqluvint) (1083)

initialize table log record (1130)

INSERT keyword

use in importing (957)

insert LOB data log record (AFIM_AMOUNT) (1202)

insert LOB data log record (AFIM_DATA) (1198)

insert record log record (1182)

INSERT_UPDATE CREATE keyword

use in importing (959)

INSTALL SIGNAL HANDLER (sqleisig) (820)

INTERRUPT (sqleintr) (818)

INTERRUPT CONTEXT (sqleInterruptCtx) (1115)

isolation level

changing (987)

keywords

CREATE, use in importing (946)

INSERT_UPDATE CREATE, use in importing (955)

INSERT_UPDATE, use in importing (944)

INSERT, use in importing (943), (953)

REPLACE_CREATE, use in importing (947), (956)

REPLACE, use in importing (945), (954)

LIST DRDA INDOUBT TRANSACTIONS (sqlcspqy) (754)

LIST INDOUBT TRANSACTIONS (sqlxphqr) (1076)

LOAD (sqluload) (964)

load pending list (1249)

LOAD QUERY (sqluqry) (965)

load start (1246)

LOB manager log records

description (1194)

insert LOB data log (AFIM_AMOUNT) (1201)

insert LOB data log (AFIM_DATA) (1197)

local database directory

open scan (786)

local pending list log record (1226)

locks

changing (988)

resetting maximum to default (859)

verifying maximum number (879)

log

file, use of in roll-forward (993)

recovery, allocating (764)

log record header (1125)

log records

add long field record (1191)

alter check pending (1158)

alter propagation (1157)

alter table add columns (1171)

backup end (1250)

create index (1142)

create table (1149)

data manager (1126)

DB2 logs (1118)

delete record (1176)

drop table (1150)

global pending list (1227)

header (1124)

heuristic aborts (1221)

heuristic commit (1209)

import replace (truncate) (1132)

initialize table (1129)

insert LOB data log (AFIM_AMOUNT) (1200)

insert LOB data log (AFIM_DATA) (1196)

insert record (1175)

load pending list (1247)

load start (1244)

LOB manager (1195)

local pending list (1224)

long field manager (1190)

migration begin (1238)

migration end (1241)

MPP coordinator commit (1212)

MPP subordinator commit (1215)

MPP subordinator prepare (1233)

normal abort (1218)

normal commit (1206)

reorg table (1138)

returned by sqlurlog (1117)

rollback add columns (1172)

rollback check pending change (1160)

rollback create table (1151)

rollback delete record (1177)

rollback drop table (1152)

rollback insert (1135)

rollback propagation change (1159)

rollback update record (1178)

tablespace roll forward to PIT begins (1256)

tablespace roll forward to PIT ends (1259)

tablespace rolled forward (1253)

transaction manager (1205)

update record (1186)

utility (1237)

XA prepare (1230)

log sequence number (LSN) (1119)

long field manager log records

add long field record (1192)

description (1189)

LSN (log sequence number) (1120)

MIGRATE DATABASE (sqlemgdb) (823)

migration

application (1263)

migration begin log record (1240)

migration end log record (1243)

MPP coordinator commit log record (1214)

MPP subordinator commit log record (1217)

MPP subordinator prepare log record (1235)

multiple concurrent requests

changing isolation level to control (984)

naming conventions

for aliases (1057)

for authentication IDs (1071)

for columns (1062)

for database manager objects (1051)

for databases (1056)

for tables (1063)

for views (1064)

in SNA (1052)

node

directory (776)

directory entries, retrieving (826)

OPEN DCS DIRECTORY SCAN (815)

node, SOCKS (1015), (1020)

non-propagatable (1123)

normal abort log record (1220)

normal commit log record (1208)

OPEN DATABASE DIRECTORY SCAN (sqledosd) (784)

OPEN DCS DIRECTORY SCAN (sqlegdsc) (814)

OPEN NODE DIRECTORY SCAN (sqlenops) (828)

OPEN RECOVERY HISTORY FILE SCAN (sqluhops) (935)

OPEN TABLESPACE CONTAINER QUERY (sqlbotcq) (749)

OPEN TABLESPACE QUERY (sqlbotsq) (750)

optimization (968)

package

creating with BIND (728)

force new access paths, after running statistics (981)

recreating (742)

partitioning information, table, obtaining (932)

performance, improving

by reorganizing tables (969)

pointer

manipulation (889)

pointers

manipulation of (894), (899)

precompile option types and values (740)

PRECOMPILE PROGRAM (sqlaprep) (739)

privileges

direct, defined (916)

granting when creating a database (770)

indirect, defined (917)

retrieving user's (913)

propagatable (1122)

PRUNE RECOVERY HISTORY FILE (sqluhprn) (936)

QUERY CLIENT (sqleqryc) (837)

QUIESCE TABLESPACES FOR TABLE (sqluvqdp) (982)

READING DATA FROM DEVICE (sqluvget) (1086)

REBIND (sqlarbnd) (741)

recovering a database (975)

REDISTRIBUTE NODEGROUP (sqludrdt) (919)

reorg table log record (1139)

REORGANIZE TABLE (sqlureot) (966)

REPLACE keyword

use in importing (958)

REPLACE_CREATE keyword

use in importing (960)

RESET DATABASE CONFIGURATION (sqlfrdb) (855)

RESET DATABASE MANAGER CONFIGURATION (sqlfrsys) (861)

RESET MONITOR (sqlmrset) (906)

RESTART DATABASE (sqlerstd) (839)

RESTORE DATABASE (sqlurst) (973)

restore set (937)

restoring earlier versions of DB2 databases (974)

RETURN-CODE structure (1108)

RFWD-INPUT structure (991)

RFWD-OUTPUT structure (992)

ROLL BACK AN INDOUBT TRANSACTION (sqlxphrl) (1077)

rollback add columns log record (1174)

rollback check pending change log record (1168)

rollback create table log record (1155)

rollback delete record log record (1184)

rollback drop table log record (1156)

rollback insert log record (1136)

rollback propagation change log record (1167)

rollback update record log record (1185)

ROLLFORWARD DATABASE (sqluroll) (971)

RUNSTATS (sqlustat) (978)

sample programs, directory of (726)

schema

created when creating a database (767)

SET ACCOUNTING STRING (sqlesact) (842)

SET APPLICATION CONTEXT TYPE (sqleSetTypeCtx) (1116)

SET CLIENT (sqlesetc) (844)

SET RUNTIME DEGREE (sqlesdeg) (843)

SET TABLESPACE CONTAINERS (sqlbstsc) (752)

SIGALRM signal (832)

starting the database manager (833)

SIGINT signal, starting database manager (831)

signal handling

INSTALL SIGNAL HANDLER (821)

INTERRUPT (819)

SINGLE TABLESPACE QUERY (sqlbstpq) (751)

SOCKS node (1014), (1019)

SQL-AUTHORIZATIONS structure (994)

SQL-DIR-ENTRY structure (995)

SQL-UEXPT-OUT structure (1042)

SQLA-FLAGINFO structure (996)

SQLB-TBS-STATS structure (997)

SQLB-TBSCONTQRY-DATA structure (998)

SQLB-TBSPQRY-DATA structure (999)

SQLCA structure (1000)

retrieving error messages from (737), (909)

SQLCHAR structure (1001)

SQLDA structure (1002)

SQLDCOL structure (1003)

SQLE-ADDN-OPTIONS structure (1004)

SQLE-CONN-SETTING structure (1005)

SQLE-NODE-APPC structure (1006)

SQLE-NODE-APPN structure (1007)

SQLE-NODE-CPIC structure (1008)

SQLE-NODE-IPXSPX structure (1009)

SQLE-NODE-LOCAL structure (1010)

SQLE-NODE-NETB structure (1011)

SQLE-NODE-NPIPE structure (1012)

SQLE-NODE-STRUCT structure (1013)

SQLE-NODE-TCPIP structure (1017)

SQLE-REG-NWBINDERY structure (1021)

SQLE-START-OPTIONS structure (1022)

SQLEDBCOUNTRYINFO structure (1023)

SQLEDBDESC structure (1024)

SQLEDBSTOPOPT structure (1026)

SQLEDINFO structure (1027)

SQLENINFO structure (1028)

SQLETSDESC structure

field descriptions (1025)

SQLFUPD structure (1029)

SQLFUPD token element

valid database configuration file entries (1031)

valid database manager configuration file entries (1033)

SQLM-COLLECTED structure (1034)

SQLM-RECORDING-GROUP structure (1035)

SQLMA structure (1036)

SQLOPT structure (1037)

SQLSTATE messages

retrieving from SQLSTATE field (908)

SQLU-LSN structure (1038)

SQLU-MEDIA-LIST structure (1039)

SQLU-RLOG-INFO structure (1040)

SQLU-TABLESPACE-BKRST-LIST structure (1041)

SQLUHINFO structure (1043)

SQLUIMPT-IN structure (1044)

SQLUIMPT-OUT structure (1045)

SQLULOAD-IN structure (1046)

SQLULOAD-OUT structure (1047)

SQLUPI structure (1048)

SQLXA-RECOVER structure (1049)

SQLXA-XID structure (1050)

START DATABASE MANAGER (sqlepstart) (829)

STOP DATABASE MANAGER (sqlepstp) (834)

storage

physical (967)

system database directory

cataloging (760)

open scan (785)

uncataloging (846)

table

importing file to (941)

naming conventions (1069)

TABLESPACE CONTAINER QUERY (sqlbtcq) (753)

TABLESPACE QUERY (sqlbmtsq) (748)

tablespace roll forward to PIT begins (1258)

tablespace roll forward to PIT ends (1261)

tablespace rolled forward (1255)

TCP/IP using SOCKS (1016), (1018)

termination

abnormal (841)

normal (836)

transaction identifier

log records (1121)

transaction manager log records

description (1204)

global pending list (1228)

heuristic aborts (1222)

heuristic commit (1210)

local pending list (1225)

MPP coordinator commit (1213)

MPP subordinator commit (1216)

MPP subordinator prepare (1234)

normal abort (1219)

normal commit (1207)

XA prepare (1231)

UNCATALOG DATABASE (sqleuncd) (845)

UNCATALOG DCS DATABASE (sqlegdel) (805)

UNCATALOG NODE (sqleuncn) (849)

uncataloging

system database directory (847)

UNLINK THE DEVICE (sqluvend) (1092)

UPDATE DATABASE CONFIGURATION (sqlfudb) (866)

UPDATE DATABASE MANAGER CONFIGURATION (sqlfusys) (871)

update record log record (1188)

UPDATE RECOVERY HISTORY FILE (sqluhupd) (938)

utility log records

backup end (1251)

description (1236)

load pending list (1248)

load start (1245)

migration begin (1239)

migration end (1242)

tablespace roll forward to PIT begins (1257)

tablespace roll forward to PIT ends (1260)

tablespace rolled forward (1254)

vendor products

backup and restore (1079)

DATA structure (1107)

DB2-INFO structure (1099)

DELETE COMMITTED SESSION (1097)

description (1078)

INIT-INPUT structure (1103)

INIT-OUTPUT structure (1105)

INITIALIZE AND LINK TO DEVICE (1085)

operation (1081)

READING DATA FROM DEVICE (1088)

RETURN-CODE structure (1109)

sqluvdel (1096)

sqluvend (1093)

sqluvget (1087)

sqluvint (1084)

sqluvput (1090)

UNLINK THE DEVICE (1094)

VENDOR-INFO structure (1101)

WRITING DATA TO DEVICE (1091)

VENDOR-INFO structure (1100)

view

naming conventions (1070)

warning message

exporting columns (927)

restore (976)

WRITING DATA TO DEVICE (sqluvput) (1089)

XA prepare log record (1232)

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

[ DB2 List of Books | Search the DB2 Books ]