Troubleshooting Guide

Index

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

abends, responding to (628)

about this guide (602)

access plan, viewing with Control Center (692)

adapter number (NetBIOS) (864)

adm subdirectory, tools (702)

administration of databases (673)

administrative tools (DB2)

description (678)

logging (1015)

tracing (1043)

administrative tools (Windows NT) (1133)

administrator authority (753)

agent (963)

agent pool (967)

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

alert

overview (1022)

SNA (1059)

SNA, routing (OS/2) (1125)

alias (812)

APPC protocol (873)

application requesters (AR) (882)

application servers (AS) (881)

applications

CLI and ODBC (916)

determining status (640)

for Extended Enterprise Edition (953)

Java (904)

slow or hanging because of locking (780)

suspended (Extended Enterprise Edition) (951)

suspended (TCP/IP) (843)

suspended or looping (applications) (908)

troubleshooting (900)

architectural integrity, checking (713)

AS/400, connections (883)

authentication

DB2 for Windows NT (789)

host connections (893)

AutoLoader (Extended Enterprise Edition) (940)

backup

plan (677)

troubleshooting (758)

using Control Center (690)

bin subdirectory, tools (703)

binary data, loading (Extended Enterprise Edition) (943)

boldface type (605)

call stack (1011)

CLI trace (1051)

client

APPC connections (875)

host (899)

host connections (877)

IPX/SPX connections (847)

named pipe connections (871)

NetBIOS connections (862)

TCP/IP connections (839)

troubleshooting (621), (809)

Client Configuration Assistant (825)

Client Setup tool (Windows 3.x) (826)

code page conversions (905)

collecting data for DB2 customer service (669)

command line processor, unable to use (773)

commands, DB2

db2_call_stack (1013)

db2autold (Extended Enterprise Edition) (942)

db2bfd (705), (706)

db2cat (707)

db2ckmig (741)

db2dart (710)

db2drdat (1057)

db2evmon (739)

db2expln (802)

db2fmt (803)

db2look (716)

db2recr (722)

db2resdb (724)

db2set (816)

db2snmpd (1030)

db2start (935)

db2tbst (727)

db2trc (1032)

db2untag (729)

db2_all (Extended Enterprise Edition) (1103)

ddcstrc (DB2 Connect) (1055)

dynexpln (804)

list applications (639)

load (766)

monitoring (736)

netstat (Extended Enterprise Edition) (1107)

rah (Extended Enterprise Edition) (1104)

reorg (799)

reorgchk (798)

runstats (800)

troubleshooting (704)

commands, OS/2

cmtrace (SNA trace) (1063)

epw (1121)

epwinst (1120)

epwrout (1124)

pstat (1129)

syslog (1118)

commands, UNIX-based

cmtrace (SNA trace) (1062)

correct syntax (777)

dbx (1072)

df (1086)

errpt (AIX) (1078)

iostat (644), (1096)

ipcrm (643)

ipcs (642)

kill (641)

lsattr (AIX) (1082)

lsps (AIX) (1080)

netstat (1098)

ps (1074)

pstack (Solaris) (1092)

spmon (Extended Enterprise Edition) (1106)

truss (SVR4) (1088)

vmstat (1094)

xmperf (1084)

communicating with IBM (670)

compiling (906)

configuration parameters

DB2_RR_TO_RS (787)

diaglevel (982)

diagpath (983)

dlchktime (784)

locklist (782)

locktimeout (783)

logfilsiz (749)

logprimary (748)

logsecond (747)

maxagents (968)

maxlocks (781)

nname (NetBIOS) (865)

num_poolagents (969)

sheapthres (805)

sortheap (806)

configuring clients (823)

connection

analyzing events (700)

changing number for DRDA (891)

testing on the server (828)

troubleshooting (810)

unsuccessful (833)

Control Center (684)

conventions (604)

coordinator agent (964)

core files (DB2) (1003)

core files (UNIX) (1069)

corruption, checking for (712)

customer service, contacting (667)

data

architectural integrity, checking (714)

backups (759)

binary, loading (Extended Enterprise Edition) (944)

format (Extended Enterprise Edition) (946)

importing (769)

indexing (Extended Enterprise Edition) (947)

loading (764)

restoring (762)

splitting and loading (Extended Enterprise Edition) (939)

database

administration troubleshooting (674)

alias (813)

consistency (742)

creating (Extended Enterprise Edition) (938)

design (676)

objects, displaying with Control Center (685)

production, mimicking (718)

recovery (Extended Enterprise Edition) (949)

remote (815)

system catalog statistics, mimicking (719)

database directory (811)

database manager

monitoring (733)

monitoring with Control Center (697)

database partition (926)

DB2

administrative tools (681) See also administrative tools (DB2)

Extended Enterprise Edition (924)

host connections (879)

information, finding (647)

maintaining (656)

DB2 Connect

tracing (1054)

troubleshooting (880)

DB2 customer service, contacting (668)

DB2COMM registry value (832)

db2dart tool (711)

db2diag.log file

additional information in syslog (UNIX) (1068)

diagnosing if listeners are up (962)

dump files (1000)

example with DB2 trace (1042)

examples (997)

header (990)

inconsistent data (750)

interpreting (988)

NetBIOS entries (868)

pruning (989)

relationship to Windows NT event viewer (1136)

SQLCA structures (992)

tracing if insufficient (1034)

trap files (1005)

troubleshooting client connections (829)

DB2MNBCKCTLR profile variable (Windows NT) (794)

deadlocks (779)

Desktop Management Interface (DMI) service layer (1026)

diaglevel, setting (984)

diagnostic tools

Macintosh (1138)

OS/2 (1108)

UNIX (1064)

Windows NT (1132)

Windows Version 3.1 and Windows 95 (1130)

diagpath, setting (985)

directories

changing with Control Center (687)

Distributed Relational Database Architecture (DRDA)

tracing (1058)

troubleshooting (888)

domain controller (Windows NT) (793)

domain security (Windows NT) (796)

Dr. Watson (Windows) (1131)

dump files (1002)

core file (UNIX) (1071)

OS/2 alerts (1127)

traces (1036)

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

environment variables (818)

error code (996)

error log (OS/2) (1117)

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

Event Analyzer (699)

event snapshots (738)

event viewer (Windows NT) (1135)

exceptions

responding to (631)

trap file (1010)

explain facility (801)

export message files (1020)

Extended Enterprise Edition

commands (1102)

determining failing nodes (932)

developing applications (954)

monitoring applications (912)

processes (972)

severe error (927)

starting (934)

troubleshooting (923)

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

FFST/2 implementation (OS/2) (1119)

files

autoexec.bat (OS/2) (855)

config.sys (854)

core (UNIX) (1070)

db2alert.log (1023)

db2cc.log (1016)

db2cli.ini (820), (921)

db2diag.log (986) See also db2diag.log file

dbttrc.trc (1045)

dump (1001)

net.cfg (OS/2) (853), (856)

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

odbc.ini (821)

services (TCP/IP) (842)

size limit (768)

syslog (UNIX) (1066)

system (Solaris) (1100)

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

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

trap (1006)

firewall (960)

first failure data capture (FFDC)

alerts (1021)

collecting on OS/2 (1141)

configuration parameters (981)

db2diag.log file (987)

dump files (999)

first failure data capture (978)

introduction (664)

overview (980)

SQLCA structures (991)

stack traceback (1014)

tracing if insufficient (1035)

trap files (1004)

fix packs, applying (657)

format of data (Extended Enterprise Edition) (945)

forums (651)

free space, identifying (UNIX) (1087)

ftp sites (663)

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

graphical user interface (GUI)

administrative tools (682)

tracing (1048)

group names (Windows NT) (791)

groups (Windows NT) (795)

hangs, responding to (633)

hardware errors

identifying (AIX) (1079)

identifying (HP-UX) (1091)

hexadecimal values in db2diag.log file (994)

history of problems, maintaining (612)

host

troubleshooting connections to (878)

HPS switch, checking (Extended Enterprise Edition) (1105)

hung applications (911)

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

IBM, contacting (666)

ICLUI trace (1047)

idle agent (966)

import message files (1018)

importing data (770)

index

architectural integrity, checking (715)

failing in Extended Enterprise Edition (948)

inconsistent, re-creating (723)

indoubt transactions (Extended Enterprise Edition) (955)

Information Center (683)

information on DB2, finding (646)

Internet Engineering Task Force (IETF) (1027)

IPX/SPX protocol (845)

isolation levels (CS, RS) (786)

italic type (607)

JDBC trace (1050)

job scheduling, using Control Center (688)

keepalive settings (TCP/IP) (844)

kernel debugging (OS/2) (1113)

kernel, updating (UNIX) (757)

LAN, determining availability (834)

Lana number (Windows 95) (866)

link time (907)

listeners

definition (961)

testing (827)

load message files (1019)

loading data, troubleshooting tips (765)

location of problem, determining (618)

locking (778)

log space (746)

logging, all platforms (976)

logs

increasing space for importing data (771)

system log (OS/2) (1116)

loops

in applications (909)

responding to (635)

Lotus Approach (915) See also ODBC applications

maintaining DB2 (661)

Management Information Base (MIB) (1028)

media management with Control Center (689)

memory, identifying (AIX) (1083)

message files, import, export and load (1017)

messages, responding to (622)

Microsoft Access (914) See also ODBC applications

Microsoft Query (913) See also ODBC applications

migration

troubleshooting (740)

Version 1 of DB2 for OS/2 (726)

misc subdirectory, tools (701)

monitor switches (735)

monitoring database manager with Control Center (696)

monospace type (606)

MVS, connections (884)

named pipes (869)

NetBIOS protocol (860)

network traffic, identifying (UNIX) (1099)

newsgroups (650)

next key locking (785)

node directory (814)

nodes (Extended Enterprise Edition)

definition (925)

failing (931)

slow (936)

won't start (937)

ODBC applications

16-bit (917)

configuring driver (920)

tracing (1052)

troubleshooting tips (918)

online help (649)

optimizer, viewing access plans (693)

origins of problems, determining (614)

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

OS/390, connections (887)

packed descriptors for tables, viewing (708)

page rate, monitoring (UNIX) (1095)

paging space, identifying (AIX) (1081)

passwords (752)

patches, applying (662)

performance

data, displaying (UNIX) (1085)

improving (797)

monitoring with Control Center (698)

using the database monitor (734)

performance monitor (Windows NT) (1134)

point-in-time monitoring (737)

problem description, determining (617)

problem determination (609) See also troubleshooting

Problem Determination Tools folder (1139)

process model

differences between Intel and UNIX (973)

displaying threads (OS/2) (1128)

overview (958)

ps command (UNIX) (1075)

viewing (975)

process status command (1073)

PTFs, applying (658)

rebinding (776)

recovery

DB2 server (760)

Extended Enterprise Edition (950)

operating system (638)

redbooks (654)

registry values (817), (819)

remote debugging (OS/2) (1114)

resources, increasing (IPX/SPX) (851)

responding to DB2 users (615)

restoring data (763)

restoring Version 1 database image (DB2 for OS/2) (725), (730)

return codes

byte-reversal (995)

example (998)

list (1144)

roadmaps

logging, tracing, and alerts (957)

Part 1 (608)

Part 2 (956)

troubleshooting tasks (603)

SAM tool (HP-UX) (1090)

schema names, considerations during migration (743)

screen captures (Windows) (1137)

security service (Windows NT) (792)

segmentation violation

logs (1008)

responding to (629)

server

administrative tools (680) See also administrative tools (DB2)

client connections (830)

collecting data for DB2 Customer Service (807)

failure (744)

timing out (NetBIOS) (867)

troubleshooting (620), (672)

service tools (1140)

services file (TCP/IP) (841)

Setup Communications tool (824)

signal (1009)

Simple Network Management Protocol (SNMP) (1024)

SmartGuides (691)

Snapshot Monitor (695)

SNMP subagent, starting (1029)

software fixes, applying (659)

splitting data (Extended Enterprise Edition) (941)

SQL messages

definition (625)

getting help for (627)

responding to (624)

SQL0294N (732)

SQL0805N (775)

SQL0818N (774)

SQL0902C (761)

SQL0911N (788)

SQL0984C (745)

SQL1003N (919)

SQL1015N (929)

SQL1016N (755)

SQL1018N (756)

SQL1034C (928)

SQL1042C (754)

SQL1061W (952)

SQL1109N (857)

SQL1224N (930)

SQL1402N (896)

SQL1403N (836), (895)

SQL30073N (898)

SQL30081N (IPX/SPX) (848)

SQL30081N (NetBIOS) (863)

SQL30081N (TCP/IP) (840)

SQL30082N (897)

SQL30082N (NetBIOS) (872)

SQL3805N (767)

SQL5043N (831)

SQL state (626)

SQL statement

syntax conventions for (1146)

SQLCA (SQL communication area) (1142)

Extended Enterprise Edition nodes (933)

interpreting (993)

stack traceback

displaying (Solaris) (1093)

for suspended system (645)

gathering (1012)

starting a trace (1039)

stored procedure

developing (903)

fenced (971)

subagent (965)

suspended applications (910)

suspensions, responding to (634)

symptom record, FFST for OS/2 (1123)

syntax diagrams, reading (1145)

syslog (UNIX) (1067)

system calls, tracing (UNIX) (1089)

system catalog statistics, mimicking (720)

system configuration, using Control Center (686)

system file (Solaris) (1101)

system log (SYSLOG)

OS/2 (1115)

UNIX (1065)

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

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

Systems Network Architecture (SNA)

overview (889)

routing alerts (OS/2) (1126)

tracing (1060)

troubleshooting (890)

SystemView agent (1025)

table

system catalog tables, mimicking (721)

viewing packed descriptors (709)

table space

container, using again with db2untag (731)

state, getting description of with db2tbst (728)

TCP/IP protocol (837)

test tool to mimic production databases (717)

threads (959)

tools

client connectivity (822)

database administration (679) See also administrative tools (DB2)

trace facility, DB2 (1031)

traces

administration tools (DB2) (1044)

CLI/JDBC/ODBC (1049)

DB2 (1033)

DB2 Connect (1053)

DRDA (1056)

dumping (DB2) (1037)

examples (DB2) (1041)

graphical interface (ICLUI) (1046)

SNA (1061)

turning off (DB2) (1038)

verifying (DB2) (1040)

trap (1007)

troubleshooting

abends, responding to (632)

APPC protocol (874)

applications (901)

clients (808)

contacting IBM (665)

database administration (675)

db2diag.log (979)

Extended Enterprise Edition (922)

getting started (610)

history of problems, maintaining (611)

host connections (876)

information, finding (648)

IPX/SPX protocol (846)

loops, responding to (637)

maintaining products (655)

messages, responding to (623)

named pipes (870)

NetBIOS protocol (861)

origins and symptoms of problems, determining (613)

problem description, determining (616)

return codes (1143)

servers (671)

suspensions, responding to (636)

TCP/IP protocol (838)

where to find a problem (619)

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

updates to DB2, applying (660)

user forums (653)

user name

authentication on host (892)

case sensitivity (894)

not valid on Windows 95 (835)

Windows NT (790)

user names (751)

user-defined functions (UDFs)

developing (902)

fenced (970)

utilities, unable to use (772)

Visual Explain (694)

VM, connections (885)

VSE, connections (886)

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

watchdog process (974)

World Wide Web (652)

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

[ DB2 List of Books | Search the DB2 Books ]