Troubleshooting Guide

Index

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

abends, responding to (722)

access plan, viewing with Control Center (786)

adapter number (NetBIOS) (961)

adm subdirectory, tools (795)

Administering Satellites Guide and Reference (1311)

Administration Guide (1291)

administration of databases (767)

Administrative API Reference (1292)

administrative tools (DB2)

description (772)

logging (1142)

tracing (1170)

administrative tools (Windows NT) (1265)

administrator authority (852)

agent (1089)

agent pool (1093)

AIX commands (1209) See also commands, UNIX-based

alert

overview (1149)

SNA (1182)

SNA, routing (OS/2) (1257)

alias (910)

APPC protocol (970)

APPC, CPI-C and SNA Sense Codes (1294)

Application Building Guide (1293)

Application Development Guide (1295)

application errors and warnings (1021)

application requesters (AR) (979)

application servers (AS) (978)

applications

CLI, ODBC and JDBC (1012)

determining status (734)

for DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT (1054)

slow or hanging because of locking (887)

suspended (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1052)

suspended (TCP/IP) (940)

suspended or looping (applications) (1004)

troubleshooting (997)

architectural integrity, checking (807)

AS/400, connections (980)

authentication

host connections (990)

AutoLoader (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1041)

backup

plan (771)

troubleshooting (857)

using Control Center (784)

bin subdirectory, tools (796)

binary data, loading (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1046)

call stack (1138)

CLI Guide and Reference (1296)

CLI trace (1188)

CLI/ODBC/JDBC (1189)

client

APPC connections (972)

host (996)

host connections (974)

IPX/SPX connections (944)

named pipe connections (968)

NetBIOS connections (959)

TCP/IP connections (936)

troubleshooting (716), (907)

Client Configuration Assistant (923)

code page conversions (1001)

collecting data for DB2 customer service (763)

command line processor, unable to use (879)

Command Reference (1297)

commands, DB2

db2atld (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1043)

db2bfd (799), (800)

db2cat (801)

db2ckmig (839)

db2dart (804)

db2drdat (1180)

db2evmon (837)

db2expln (900)

db2fexmt (902)

db2flsn (810)

db2ipxad (811)

db2level (812)

db2look (813)

db2recr (819)

db2resdb (821)

db2set (914)

db2snmpd (1157)

db2sql92 (824)

db2start (1035)

db2tbst (825)

db2trc (1159)

db2untag (827)

db2_all (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT;) (1235)

db2_call_stack (1140)

ddcstrc (DB2 Connect) (1178)

dynexpln (901)

list applications (733)

load (872)

monitoring (834)

netstat (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT;) (1239)

rah (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT;) (1236)

reorg (897)

reorgchk (896)

runstats (898)

troubleshooting (798)

commands, OS/2

cmtrace (SNA trace) (1186)

epw (1253)

epwinst (1252)

epwrout (1256)

pstat (1261)

syslog (1250)

commands, UNIX-based

cmtrace (SNA trace) (1185)

correct syntax (883)

dbx (1203)

df (1218)

errpt (AIX) (1210)

iostat (738), (1228)

ipcrm (737)

ipcs (736)

kill (735)

lsattr (AIX) (1214)

lsps (AIX) (1212)

netstat (1230)

ps (1205)

pstack (Solaris) (1224)

spmon (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT;) (1238)

truss (SVR4) (1220)

vmstat (1226)

xmperf (1216)

communicating with IBM (764)

compiling (1002)

configuration parameters

DB2_RR_TO_RS (894)

diaglevel (1108)

diagpath (1109)

dlchktime (891)

locklist (889)

locktimeout (890)

logfilsiz (847)

logprimary (846)

logsecond (845)

maxagents (1094)

maxlocks (888)

nname (NetBIOS) (962)

notifylevel (1110)

num_poolagents (1095)

sheapthres (903)

sortheap (904)

configuring clients (921)

connection

analyzing events (794)

changing number for DRDA (988)

testing on the server (925)

troubleshooting (908)

unsuccessful (930)

Connectivity Supplement (1301)

Control Center (778), (1278)

search utility (1279)

coordinator agent (1090)

core files (DB2) (1130)

core files (UNIX) (1200)

corruption, checking for (806)

customer service, contacting (761)

data

architectural integrity, checking (808)

backups (858)

binary, loading (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1047)

format (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1045)

importing (875)

indexing (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1048)

loading (869)

restoring (864)

splitting and loading (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1039)

Data Movement Utilities Guide and Reference (1298)

database

administration troubleshooting (768)

alias (911)

consistency (840)

creating (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1038)

design (770)

objects, displaying with Control Center (779)

production, mimicking (815)

recovery (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1050)

remote (913)

system catalog statistics, mimicking (816)

database directory (909)

database manager

monitoring (831)

monitoring with Control Center (791)

database partition (1026)

Database System Monitor (1270)

Event Monitor (1274)

Snapshot Monitor (1272)

datalinks (1060)

datalinks, backup data links manager environment (1066)

datalinks, data access token (1062)

datalinks, general (1058)

datalinks, import operation (1070)

datalinks, load considerations (1072)

datalinks, migration considerations (1074)

datalinks, recovery data links manager environment (1064)

datalinks,export operation (1068)

DB2

administrative tools (775)

DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT (1024)

host connections (976)

information, finding (741)

maintaining (750)

DB2 Connect

tracing (1177)

troubleshooting (977)

DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (1318)

DB2 Connect Enterprise Edition for UNIX Quick Beginnings (1319)

DB2 Connect Personal Edition Quick Beginnings (1299)

DB2 Connect User's Guide (1300)

DB2 customer service, contacting (762)

DB2 Data Links Manager for AIX Quick Beginnings (1320)

DB2 Data Links Manager for Windows NT Quick Beginnings (1321)

DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (1316)

DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (1317)

DB2 Index Advisor (1282)

DB2 library

books (1290)

Information Center (1328)

language identifier for books (1325)

late-breaking information (1326)

online help (1289)

ordering printed books (1333)

printing PostScript books (1332)

searching online information (1331)

setting up document server (1329)

SmartGuides (1288)

structure of (1287)

viewing online information (1327)

DB2 Personal Edition Quick Beginnings (1312)

DB2 Query Patroller Administration Guide (1322)

DB2 Query Patroller Installation Guide (1323)

DB2 Query Patroller User's Guide (1324)

DB2 Satellite Edition (1077)

DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT

commands (1234)

determining failing nodes (1032)

developing applications (1055)

monitoring applications (1008)

processes (1098)

severe error (1027)

starting (1034)

troubleshooting (1023)

DB2COMM registry value (929)

db2dart tool (805)

db2diag.log file

additional information in syslog (UNIX) (1199)

diagnosing if listeners are up (1088)

dump files (1127)

example with DB2 trace (1169)

examples (1124)

header (1117)

inconsistent data (848)

interpreting (1115)

NetBIOS entries (965)

pruning (1116)

relationship to Windows NT event viewer (1268)

SQLCA structures (1119)

tracing if insufficient (1161)

trap files (1132)

troubleshooting client connections (926)

deadlocks (885)

Desktop Management Interface (DMI) service layer (1153)

diaglevel, setting (1111)

diagnostic tools

OS/2 (1240)

UNIX (1195)

Windows 95 and Windows 98 (1262)

Windows NT (1264)

diagpath, setting (1112)

directories

changing with Control Center (781)

Distributed Relational Database Architecture (DRDA)

tracing (1181)

troubleshooting (985)

Dr. Watson (Windows) (1263)

dump files (1129)

core file (UNIX) (1202)

OS/2 alerts (1259)

traces (1163)

dump utility, standalone (OS/2) (1244)

environment variables (916)

error code (1123)

error log (OS/2) (1249)

error record, FFST for OS/2 error log (1254)

Event Analyzer (793)

Event Monitor (1273)

matching records with their application (1276)

Output Records (1275)

reading an event monitor trace (1277)

event snapshots (836)

event viewer (Windows NT) (1267)

exceptions

responding to (725)

trap file (1137)

explain facility (899)

export message files (1147)

FFDC (1103) See also first failure data capture (FFDC)

FFST/2 implementation (OS/2) (1251)

files

autoexec.bat (OS/2) (952)

config.sys (951)

core (UNIX) (1201)

db2alert.log (1150)

db2cc.log (1143)

db2cli.ini (918), (1016)

db2diag.log file (1113)

dbttrc.trc (1172)

dump (1128)

net.cfg (OS/2) (950), (953)

nwcalls.dll (Win-OS/2) (955)

odbc.ini (919)

services (TCP/IP) (939)

size limit (874)

syslog (UNIX) (1197)

system (Solaris) (1232)

TLI*.DLL (Novell IPX/SPX) (946)

tli_spx.dll (Win-OS/2) (956)

trap (1133)

firewall (1086)

first failure data capture (FFDC)

alerts (1148)

collecting on OS/2 (1336)

configuration parameters (1107)

db2diag.log file (1114)

dump files (1126)

first failure data capture (1104)

introduction (758)

overview (1106)

SQLCA structures (1118)

stack traceback (1141)

tracing if insufficient (1162)

trap files (1131)

fix packs, applying (751)

format of data (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1044)

forums (745)

free space, identifying (UNIX) (1219)

ftp sites (757)

general protection faults (GPF), responding to (724)

Glossary (1302)

graphical user interface (GUI)

administrative tools (776)

tracing (1175)

hangs, responding to (727)

hardware errors

identifying (AIX) (1211)

identifying (HP-UX) (1223)

hexadecimal values in db2diag.log file (1121)

history of problems, maintaining (707)

host

troubleshooting connections to (975)

HPS switch, checking (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT;) (1237)

hung applications (1007)

I/O activities, monitoring (UNIX) (1229)

IBM, contacting (760)

ICLUI trace (1174)

idle agent (1092)

import message files (1145)

importing data (876)

index

architectural integrity, checking (809)

failing in DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT (1049)

inconsistent, re-creating (820)

Index SmartGuide (1283)

indoubt transactions (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1056)

Information Center (777)

information on DB2, finding (740)

Installation and Configuration Supplement (1303)

Internet Engineering Task Force (IETF) (1154)

IPX/SPX protocol (942)

isolation levels (CS, RS) (893)

job scheduling, using Control Center (782)

keepalive settings (TCP/IP) (941)

kernel debugging (OS/2) (1245)

kernel, updating (UNIX) (856)

LAN, determining availability (931)

Lana number (Windows 95) (963)

link time (1003)

listeners

definition (1087)

testing (924)

load message files (1146)

LOAD utility (1040)

loading data, troubleshooting tips (870)

location of problem, determining (713)

locking (884)

log space (844)

logging, all platforms (1102)

logs

increasing space for importing data (877)

system log (OS/2) (1248)

loops

in applications (1005)

responding to (729)

Lotus Approach (1011) See also ODBC applications

maintaining DB2 (755)

Management Information Base (MIB) (1155)

media management with Control Center (783)

memory, identifying (AIX) (1215)

message files, import, export and load (1144)

Message Reference (1304)

messages, responding to (717)

Microsoft Access (1010) See also ODBC applications

Microsoft Query (1009) See also ODBC applications

migration

troubleshooting (838)

Version 1 of DB2 for OS/2 (823)

misc subdirectory, tools (797)

mobile (1079)

monitor switches (833)

monitoring database manager with Control Center (790)

MVS, connections (981)

named pipes (966)

NetBIOS connections lost (863)

NetBIOS protocol (957)

NetQuestion (1082)

network traffic, identifying (UNIX) (1231)

newsgroups (744)

next key locking (892)

node directory (912)

nodes (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT)

definition (1025)

failing (1031)

slow (1036)

won't start (1037)

ODBC application messages (1020)

ODBC applications

configuring driver (1015)

mixed case problems (1017)

troubleshooting tips (1013)

online help (743)

optimizer, viewing access plans (787)

origins of problems, determining (709)

OS/2 commands (1241) See also commands, OS/2

OS/390, connections (984)

packed descriptors for tables, viewing (802)

page rate, monitoring (UNIX) (1227)

paging space, identifying (AIX) (1213)

passwords (851)

patches, applying (756)

performance

data, displaying (UNIX) (1217)

improving (895)

monitoring with Control Center (792)

using the database monitor (832)

Performance Monitor (789)

performance monitor (Windows NT) (1266)

pervasive computing (1080)

point-in-time monitoring (835)

problem description, determining (712)

problem determination (704) See also troubleshooting

Problem Determination Tools folder (1334)

process model

differences between Intel and UNIX (1099)

displaying threads (OS/2) (1260)

overview (1084)

ps command (UNIX) (1206)

viewing (1101)

process status command (1204)

PTFs, applying (752)

Quick Beginnings for OS/2 (1313)

Quick Beginnings for UNIX (1314)

Quick Beginnings for Windows NT (1315)

rebinding (882)

recovery

DB2 server (859)

DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT (1051)

operating system (732)

redbooks (748)

registry values (915), (917)

remote debugging (OS/2) (1246)

replication (1075)

DpropR (1076)

Replication Guide and Reference (1305)

resources, increasing (IPX/SPX) (948)

responding to DB2 users (710)

restoring data (865)

restoring Version 1 database image (DB2 for OS/2) (822), (828)

return codes

byte-reversal (1122)

example (1125)

list (1339)

roadmaps

logging, tracing, and alerts (1083)

ROLLFORWARD PENDING (867)

SAM tool (HP-UX) (1222)

satellite control database (1081)

Satellite Edition (1078)

schema names, considerations during migration (841)

screen captures (Windows) (1269)

segmentation violation

logs (1135)

responding to (723)

server

administrative tools (774)

client connections (927)

collecting data for DB2 Customer Service (905)

failure (842)

timing out (NetBIOS) (964)

troubleshooting (715), (766)

service tools (1335)

services file (TCP/IP) (938)

setting up document server (1330)

Setup Communications tool (922)

signal (1136)

Simple Network Management Protocol (SNMP) (1151)

SmartGuides (785)

Snapshot Monitor (1271)

SNMP subagent, starting (1156)

software fixes, applying (753)

Solaris OS commands (useful for debugging) (1207) See also commands, UNIX-based

splitting data (DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT) (1042)

SQL Advise Facility (1284)

SQL Getting Started (1306)

SQL messages

definition (720)

responding to (719)

SQL0204N (1018), (1019)

SQL0294N (830)

SQL0805N (881)

SQL0818N (880)

SQL0902C (860), (866)

SQL0911N (886)

SQL0984C (843)

SQL1003N (1014)

SQL1015N (1029)

SQL1016N (854)

SQL1018N (855)

SQL1034C (1028)

SQL1042C (853)

SQL1061W (1053)

SQL1109N (954)

SQL1224N (1030)

SQL1277N (868), (871)

SQL1402N (993)

SQL1403N (849), (933), (992)

SQL2419N (862)

SQL30073N (995)

SQL30081N (IPX/SPX) (945)

SQL30081N (NetBIOS) (960)

SQL30081N (TCP/IP) (937)

SQL30082N (994)

SQL30082N (NetBIOS) (969)

SQL3805N (873)

SQL4908N (861)

SQL5043N (928)

SQL Reference (1307)

SQL state (721)

SQLCA (SQL communication area) (1337)

DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT nodes (1033)

interpreting (1120)

stack traceback

displaying (Solaris) (1225)

for suspended system (739)

gathering (1139)

starting a trace (1166)

stored procedure

developing (1000)

fenced (1097)

Stored Procedure Builder (1281)

subagent (1091)

suspended applications (1006)

suspensions, responding to (728)

symptom record, FFST for OS/2 (1255)

syslog (UNIX) (1198)

system calls, tracing (UNIX) (1221)

system catalog statistics, mimicking (817)

system configuration, using Control Center (780)

system file (Solaris) (1233)

system log (SYSLOG)

OS/2 (1247)

UNIX (1196)

System Monitor Guide and Reference (1308)

System Performance Monitor for OS/2 (SPM/2) (1242)

system resources, increasing (IPX/SPX) (949)

Systems Network Architecture (SNA)

overview (986)

routing alerts (OS/2) (1258)

tracing (1183)

troubleshooting (987)

SystemView agent (1152)

table

recovery (1285)

system catalog tables, mimicking (818)

viewing packed descriptors (803)

table space

container, using again with db2untag (829)

recovery (1286)

state, getting description of with db2tbst (826)

TCP/IP protocol (934)

test tool to mimic production databases (814)

threads (1085)

tools

client connectivity (920)

database administration (773)

datalinks (1059)

datalinks, backup data links manager environment (1065)

datalinks, data access token (1061)

datalinks, export operation (1067)

datalinks, general (1057)

datalinks, import operation (1069)

datalinks, load considerations (1071)

datalinks, migrations considerations (1073)

datalinks, recovery data links manager environment (1063)

trace (1187)

trace facility, DB2 (1158)

TRACE, keyword (1190)

TRACECOMM, keyword (1191)

TRACEFILENAME, keyword (1192)

TRACEFLUSH, keyword (1193)

TRACEPATHNAME, keyword (1194)

traces

administration tools (DB2) (1171)

DB2 (1160)

DB2 Connect (1176)

DRDA (1179)

dumping (DB2) (1164)

examples (DB2) (1168)

graphical interface (ICLUI) (1173)

SNA (1184)

turning off (DB2) (1165)

verifying (DB2) (1167)

trap (1134)

troubleshooting

abends, responding to (726)

APPC protocol (971)

applications (998)

clients (906)

contacting IBM (759)

database administration (769)

DB2 Universal Database Enterprise - Extended Edition for the Solaris Operating Environment and DB2 Universal Database Enterprise - Extended Edition for Windows NT (1022)

db2diag.log file (1105)

getting started (705)

history of problems, maintaining (706)

host connections (973)

information, finding (742)

IPX/SPX protocol (943)

loops, responding to (731)

maintaining products (749)

messages, responding to (718)

named pipes (967)

NetBIOS protocol (958)

origins and symptoms of problems, determining (708)

problem description, determining (711)

return codes (1338)

servers (765)

suspensions, responding to (730)

TCP/IP protocol (935)

where to find a problem (714)

Troubleshooting Guide (1309)

Troubleshooting Page (1280)

UNIX-based commands (1208) See also commands, UNIX-based

updates to DB2, applying (754)

user forums (747)

user name

authentication on host (989)

case sensitivity (991)

not valid on Windows 95 and Windows 98 (932)

user names (850)

user-defined functions (UDFs)

developing (999)

fenced (1096)

utilities, unable to use (878)

Visual Explain (788)

VM, connections (982)

VSE, connections (983)

WarpCenter (OS/2 Warp Version 4) (1243)

watchdog process (1100)

What's New (1310)

World Wide Web (746)

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

[ DB2 List of Books | Search the DB2 Books ]