IBM Books

DB2 Query Patroller Administration Guide

Index

A B C D E F I J L M N O P Q R S T U V Z
A
  • adding users (1040), (1044)
  • administration (945)
  • data sources (1256)
  • nodes (1265)
  • result destinations (1269)
  • system parameters (1275)
  • user profiles (1260)
  • agent (876), (923)
  • agent processes (1377)
    • B
  • bar charts (1333)
    • C
  • canceling jobs (1062)
  • changing the date and time range (1324)
  • changing the report format (1341)
  • client configuration (1236)
  • client configuration options (1241)
  • clients, troubleshooting (1383)
  • columns
  • displaying (1252)
  • resizing (1253)
  • Columns Hit by User Y Hitting Table X report (1305)
  • Columns Hit in Table X report (1296), (1301), (1303)
  • command-line interface (882)
  • command-line interface environment (1074)
  • commands
  • EXCLUDE (1194)
  • INCLUDE (1195)
  • INTERVAL (1181)
  • iwm (1053), (1066)
  • iwm_cmd (1072), (1091)
  • iwm_submit (1073), (1085)
  • LOGFILE (1184)
  • MAILTO (1190)
  • common parameters (1092)
  • common QueryEnabler problems (1387)
  • common server problems (1381)
  • common Tracker problems (1398)
  • components (854)
  • agent (877), (931)
  • command-line interface (883)
  • cost analyzer (862), (1039)
  • executor (881), (930), (1220)
  • job scheduler (866), (921)
  • log monitor (875), (961), (1068), (1166)
  • node manager (879), (929)
  • notifier (872), (943), (1208), (1224)
  • QueryAdministrator (885)
  • QueryEnabler (887)
  • QueryMonitor (889)
  • request server (859)
  • server (857)
  • configuration
  • client (1237)
  • data warehouse (1234)
  • estimating and monitoring (1231)
  • monitoring (1233)
  • QueryEnabler (1240)
  • configuration file, log monitor (1179)
  • configuring DB2 Query Patroller server (1226)
  • configuring the DB2 Query Patroller client (1238)
  • connections, socket (912)
  • control command (1087)
  • control program (1064)
  • controlling
  • job execution (1057)
  • job flow (1054)
  • jobs, using iwm_cmd (1103)
  • nodes, using iwm_cmd (1110)
  • system parameters, using iwm_cmd (1143)
  • controlling data sources (1115)
  • conventions, syntax (852)
  • cost analysis (861), (917), (1029)
  • exit (1209)
  • cost analysis required (1028)
  • cost analyzer (860), (1038)
  • CPU utilization (922), (933)
    • D
  • data source administration (1255)
  • data source parameters (999)
  • data source status (1003), (1120)
  • job cost limit (1005), (1123)
  • job count limit (1007), (1126)
  • node CPU limit (1010), (1130)
  • node disk limit (1013), (1135)
  • data source status (1002), (1119)
  • data sources
  • controlling using iwm_command (1116)
  • editing (1258)
  • listing (1257)
  • listing using iwm_command (1117)
  • Data Sources table (904), (1000)
  • data warehouse configuration (1235)
  • date range (1323)
  • DB2 diagnostic log (1371)
  • DB2 failures (1368)
  • DB2 Query Patroller
  • components (856)
  • starting (1052)
  • stopping (1051)
  • system architecture (853)
  • tables (891)
  • DB2 Query Patroller failures (1367)
  • diagnostic log (1370)
  • disk space monitoring (950), (1134)
  • displaying columns (1251)
  • displaying data as a count (1288)
  • displaying data as a percentage (1290)
  • displaying job history data (1313), (1317)
  • drill path (1348)
  • drilling down (1345)
  • drilling up (1347)
    • E
  • e-mail (871), (942), (965), (1045), (1168) , (1191)
  • e-mail messages (1222)
  • environment variables (947)
  • IWMLOG (957), (1186), (1403)
  • IWM_DISKMON (949)
  • IWM_EXIT_AN (953), (1212)
  • IWM_INTERVAL (955)
  • IWM_LOGMON (960), (1175)
  • IWM_MAIL (964)
  • IWM_NET (967), (1079)
  • IWM_NOEXPLAIN (969)
  • IWM_RES_TBLSPC (971)
  • IWM_RUNTIME (973), (1077), (1187), (1404)
  • IWM_server (975)
  • PATH (1078)
  • error messages (1400)
  • estimating system configuration (1230)
  • EXCLUDE (1193)
  • executor (880), (928), (1219)
  • exiting Tracker (1361)
    • F
  • failures
  • DB2 (1366)
  • DB2 Query Patroller (1365)
  • process (1378)
  • filters
  • NUM (1199)
  • PGM (1201)
  • SEV (1197)
  • formats
  • bar charts (1334)
  • changing (1343)
  • lists (1337)
  • pie chart (1340)
  • formats, report (1329)
    • I
  • INCLUDE (1192)
  • installing QueryAdministrator (1245)
  • INTERVAL (1180)
  • iwm (1050), (1065)
  • iwm account (952)
  • IWMLOG (956), (1182), (1402)
  • iwm_cmd (1071), (1090)
  • controlling data sources (1113)
  • controlling jobs (1102)
  • controlling nodes (1109)
  • controlling system parameters (1140)
  • listing data sources (1112)
  • listing system parameters (1141)
  • monitoring jobs (1097)
  • monitoring nodes (1108)
  • IWM_DISKMON (948)
  • IWM_EXIT_AN (951), (1211)
  • IWM_INTERVAL (954)
  • IWM_LOGMON (958), (1172)
  • IWM_MAIL (962)
  • IWM_NET (966), (1076)
  • iwm_net (1375)
  • iwm_nodemgr (1374)
  • IWM_NOEXPLAIN (968)
  • IWM_RES_TBLSPC (970)
  • IWM_RUNTIME (972), (1075), (1185), (1401)
  • IWM_SERVER (974)
  • iwm_submit (1070), (1084)
    • J
  • job
  • accounting (1203)
  • execution (927)
  • scheduling (920)
  • submission (915)
  • Job Accounting
  • job accounting
  • status (996), (1162), (1207)
  • table (908), (939), (995), (1163)
  • table (869), (1202)
  • Job Activity over Time report (1310)
  • Job Cost Limit (1153)
  • job cost limit (982), (1004), (1031), (1122)
  • Job Count Limit (1125)
  • job count limit (985), (1006), (1033), (1155)
  • job execution
  • controlling (1056)
  • job flow (913)
  • controlling (1055)
  • cost analysis (916)
  • job execution (926)
  • job notification (940)
  • job scheduling (919)
  • job submission (914)
  • job history data (1312), (1316)
  • job purge days (988), (1158)
  • job queue parameters (1017)
  • maximum cost (1019)
  • maximum jobs (1021)
  • Job Queues table (906), (1016)
  • job scheduler (865), (918)
  • Job table (893)
  • jobs
  • canceling (1060)
  • controlling (1088), (1101)
  • controlling using iwm_cmd (1100)
  • monitoring (1089), (1096)
  • monitoring using iwm_cmd (1095)
  • releasing (1061)
    • L
  • listing
  • data sources, using iwm_cmd (1114)
  • system parameters, using iwm_cmd (1142)
  • Lists (1336)
  • log file (873), (1176), (1399)
  • log file monitoring (1177)
  • log monitor (874), (959), (1067), (1165), (1174)
  • configuration file (1178)
  • running (1173)
  • LOGFILE (1183)
    • M
  • mail (870), (941), (963), (1043), (1167) , (1188), (1221)
  • MAILTO (1189)
  • maintaining cost statistics (1037)
  • MaxElapsedTime (1244)
  • MaxResultRows (1243)
  • monitoring
  • CPU utilization (932), (1129)
  • disk space (1133)
  • jobs, using iwm command (1094)
  • jobs, using the control command (1086)
  • log file (1164)
  • nodes, using iwm_cmd (1107)
  • monitoring system configuration (1229), (1232)
    • N
  • navigating (1278)
  • node administration (1266)
  • node CPU limit (1009), (1128)
  • node disk limit (1012), (1132)
  • Node Information table (897)
  • node manager (878), (924)
  • nodes
  • controlling, using iwm_cmd (1106)
  • listing (1267)
  • monitoring, using iwm_cmd (1105)
  • notification (938)
  • notifier (867), (937), (1206), (1223)
  • NUM filter (1198)
    • O
  • opening a new report (1319)
  • operation (1046)
  • options, client configuration (1242)
    • P
  • panning on a pie chart (1354)
  • panning on a time chart (1358)
  • parameters
  • common for iwm_cmd (1093)
  • cost analysis required (1027)
  • data source (998)
  • data source status (1001), (1118)
  • data source, for iwm_cmd (1111)
  • DB2 Query Patroller (946)
  • iwm_submit (1082)
  • job accounting status (994)
  • job control, for iwm_cmd (1099)
  • job cost limit (980), (1121), (1150)
  • job count limit (984), (1124), (1151)
  • job monitoring for iwm_cmd (1098)
  • job purge days (987), (1149)
  • job queue (1015)
  • maximum cost (1018)
  • maximum jobs (1020)
  • mode disk limit (1131)
  • node control and monitoring, for iwm_cmd (1104)
  • node CPU limit (1008), (1127)
  • node disk limit (1011)
  • priorities (1036)
  • results purge days (1148)
  • system (979)
  • system, for iwm_cmd (1139)
  • user profile (1025)
  • PATH (1080)
  • pausing DB2 Query Patroller (1049)
  • PGM filter (1200)
  • pie chart, zooming and panning (1351)
  • pie charts (1339)
  • priorities (1035)
  • problems, common server (1380)
  • problems, QueryAdministrator (1393)
  • problems, QueryEnabler (1388)
  • process failures (1379)
  • processes, agent (1376)
  • processes, server (1372)
  • profiling queries (1228)
  • purging (1157)
  • jobs (935), (1147)
  • result tables (936)
  • purging, result tables (1146)
    • Q
  • queries
  • profiling (1227)
  • QueryAdministrator (884)
  • common problems (1394)
  • installing (1246)
  • starting (1247)
  • stopping (1249)
  • QueryEnabler (886)
  • configuring (1239)
  • troubleshooting (1385)
  • QueryEnabler, problems (1389)
  • QueryMonitor (888)
  • common problems (1392)
  • QueryMonitor, troubleshooting (1390)
    • R
  • refreshing report data (1327)
  • releasing (1059)
  • releasing jobs (1058)
  • report data (1326)
  • report formats (1331)
  • bar charts (1332)
  • changing (1342)
  • lists (1335)
  • pie chart (1338)
  • reports (1282)
  • changing the date and time range (1325)
  • closing a report window (1359)
  • Columns Hit by User Y Hitting Table X (1304)
  • Columns Hit in Table X (1297), (1300)
  • date range (1320)
  • displaying (1284)
  • displaying data as a count (1289)
  • displaying data as a percentage (1291)
  • drilling down for more information (1344)
  • drilling up (1346)
  • formats (1330)
  • Job Activity Over Time (1287)
  • Job Activity over Time (1311)
  • opening a new report (1318)
  • refreshing data (1328)
  • Rows Returned by Table (1286), (1309)
  • Tables Joined with Table X (1299), (1306)
  • time range (1321)
  • Total Table Hits (1285)
  • Total Table Hits report (1293)
  • Users That Hit Table X (1298), (1302)
  • viewing the drill path (1349)
  • zooming and panning on a pie chart (1352)
  • zooming and panning on a time chart (1356)
  • request server (858)
  • resizing columns` (1254)
  • result destination administration (1270)
  • result destination variables (1217)
  • result destinations (901), (1215)
  • creating (1272)
  • listing (1271)
  • piped (1218)
  • removing (1273)
  • Result Destinations table (902), (1214)
  • result tables (910), (925)
  • purging (1145)
  • result tables, purging (944)
  • results purge days (990), (1144)
  • Rows Returned by Table report (1308)
  • running the log monitor (1171)
    • S
  • server (855)
  • common problems (1382)
  • troubleshooting (1363)
  • server processes (1373)
  • server, configuring (1225)
  • SEV filter (1196)
  • socket connections (911)
  • starting
  • DB2 Query Patroller (1047)
  • log monitor (1170)
  • Tracker (1314)
  • starting QueryAdministrator (1248)
  • stopping
  • DB2 Query Patroller (1048)
  • log monitor (1169)
  • stopping QueryAdministrator (1250)
  • submit command (1081)
  • submitting (1083)
  • syntax conventions (851)
  • syserr.log (1369)
  • system administration (1274)
  • system monitoring (1063)
  • system parameters (978), (1138)
  • controlling using iwm_cmd (1137)
  • editing (1277)
  • job accounting status (993), (1161), (1205)
  • job cost limit (981), (1152)
  • job count limit (983), (1154)
  • job purge days (986), (1156)
  • listing (1276)
  • listing using iwm_cmd (1136)
  • results purge days (989), (1159)
  • System Parameters table (899), (976)
    • T
  • tables
  • Data Sources (903), (997)
  • DB2 Query Patroller (890)
  • Job (892)
  • Job Accounting (868), (907), (934), (1160), (1204)
  • Job Accounting Status (992)
  • Job Queues (905), (1014)
  • Node Information (896)
  • Result Destinations (900), (1213)
  • Results (909)
  • Results Purge Days (991)
  • System Parameters (898), (977)
  • User Profile (863), (895), (1022), (1042)
  • Tables Joined with Table report (1294)
  • Tables Joined with Table X report (1307)
  • time chart, zooming and panning (1355)
  • time range (1322)
  • tool bar (1280)
  • Total Table Hits report (1292)
  • Tracker
  • closing a report window (1360)
  • common problems (1397)
  • exiting (1362)
  • navigating (1279)
  • reports (1283)
  • starting (1315)
  • tool bar (1281)
  • troubleshooting (1395)
  • troubleshooting
  • DB2 Query Patroller clients (1384)
  • DB2 Query Patroller server (1364)
  • QueryEnabler (1386)
  • QueryMonitor (1391)
  • Tracker (1396)
    • U
  • user administration (1259)
  • user exits (1210)
  • user profile parameters (1024)
  • cost analysis required (1026)
  • job cost limit (1030)
  • job count limit (1032)
  • priorities (1034)
  • User Profile table (864), (894), (1023)
  • user profiles
  • changing node status (1268)
  • creating (1262)
  • editing (1263)
  • listing (1261)
  • removing (1264)
  • Users That Hit Table X report (1295)
  • users, adding (1041)
  • using the command-line interface (1069)
    • V
  • variables, result destination (1216)
  • viewing the drill path (1350)
    • Z
  • zooming on a pie chart (1353)
  • zooming on a time chart (1357)

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

    [ DB2 List of Books | Search the DB2 Books ]