DB2 Server for VSE & VM: Control Center Operations Guide for VM

Index

A B C D E F G I J L M O P Q R S T V W
A
  • access modules See DB2 package maintenance (SQLRBIND)
  • adding dbextents (1296), (1299)
  • adding dbspaces (1320), (1324)
  • application server See database virtual machine
  • ARCHHIST file
  • example (1224)
  • architecture
  • authorization (914), (928)
  • code disk types (899), (905)
  • communication types (880), (895)
  • communications (878)
  • breaking SCIF connection (886)
  • database connection (893)
  • message and file (891)
  • number of service machines required (889)
  • operator (892)
  • types (879)
  • Control Center Administration tools on service and support machines (875)
  • database admin tools on support and user machines (871)
  • managing support machines (873)
  • why not on service machines? (874)
  • why support machines? (872)
  • database machine (861)
  • interrupt processing (987)
  • machine types (856), (864)
  • machines tools run on (865), (876)
  • minidisk layout (897)
  • Control Center code disk (898)
  • database production code disk (902)
  • tape manager code disk (903)
  • overview (855)
  • owner machine (863)
  • SCIF (882), (890)
  • service machine (858)
  • support machine (860)
  • System Administration tools on the service machine (866)
  • asynchronous processing (869)
  • how they work (867)
  • scheduled processing (868)
  • support of multiple database versions (870)
  • tape management (907)
  • multivolume tapes (909)
  • tape management products (911)
  • tape mount procedure (910)
  • tools overview (839), (853)
  • user machine (862)
  • archiving See also archiving
  • archive log (1227), (1229)
  • archiving to disk (1207)
  • canceling (1218)
  • examples of (959), (961)
  • history (1222)
  • initiating (1215)
  • options (1213)
  • panel interface (1212), (1217)
  • scheduling (1220)
  • user archiving (1209), (1590)
  • authorization
  • adding a new user (1003), (1005)
  • architecture (915), (927)
  • customizing tool authorizations (1588), (1589)
  • database administrator (920), (1172)
  • database machines (917), (918)
  • operator (922), (1173)
  • SFS databases (1595), (1599)
  • user (924), (1174)
  • AUTOLOG (1000)
    • B
  • backup (1262)
  • Backup (see also, Data Restore)
  • authorization (1272)
  • BACKUPS to disk (1270)
  • invocation (1271)
  • media types (1269)
    • C
  • CA-DYNAM/T See tape management
  • coldlog (1328), (1331)
  • communications
  • architecture (877), (896), (985)
  • command mode interface (1591), (1603)
  • database access (1593)
  • DBINIT CONTROL file (963)
  • panel interface (1029), (1033), (1051), (1054)
  • paths (887), (1045), (1049)
  • SCIF (884)
  • breaking the connection (885)
  • number of service machines required (888)
  • SQLMSTR DIRECTRY file (964)
  • types (881), (894)
  • with DB2 Server for VM (827)
  • with local CPU (805)
  • with remote CPU (804)
  • concurrent processing
  • example (832)
  • with Database System Administration Tools (846)
  • console management
  • issuing commands (1555), (1562)
  • viewing messages (1547), (1554)
  • Control Center
  • and DB2 Server for VM (826)
  • general description (795)
  • history (820)
  • product benefits (800)
  • access control (801)
  • automated archiving (807)
  • automated database recovery (808)
  • database monitoring (811)
  • database operator command interface (806)
  • DBSPACE reorganization (813)
  • DBSPACE reorganization candidate selection (815)
  • externalized database startup parameters (802)
  • index reorganization (817)
  • job scheduling (819)
  • local/remote user interface capability (803)
  • logmode changes (809)
  • object search/list (818)
  • table reorganization/redefinition (816)
  • product overview (796)
  • requirements (821)
  • running (982)
  • Control Center Administration Tools
  • database tape management (1103), (1119)
  • before you begin (1104)
  • the database tape management tool (1105)
  • general description (849)
  • Issue Database Commands Tool (1556)
  • how it works (1559)
  • overview (1557)
  • scheduling (1561)
  • the Database Command entry panel (1560)
  • who can use it (1558)
  • job schedule list (1077), (1084)
  • job scheduling (1071), (1076)
  • List Control Center Database Files (1564)
  • how it works (1567)
  • List Control Center VM Database Files panel (1568)
  • overview (1565)
  • who can use it (1566)
  • list of (851)
  • overview (1548)
  • Query DBEXTENTS/STORPOOL Mapping (1572)
  • how it works (1575)
  • overview (1573)
  • the Query DBEXTENTS/STORPOOL Mapping report (1576)
  • who can use it (1574)
  • the View Message Log tool (1549)
  • how it works (1551)
  • sample display (1553)
  • View Message Log Panel (1552)
  • who can use it (1550)
  • Control Center Administrators (916)
  • Control Center command mode communications (SQM) (1602)
  • Control Center Database Administrators (921)
  • Control Center Database Operators (923)
  • Control Center Database Users (925)
  • Control Center environment
  • example (833), (836)
  • multi-CPU (837)
  • multi-database (835)
  • single-CPU (834)
  • with Control Center support machine (838)
  • Control Center service machine
  • deadlock (848)
  • general description (857)
  • running System Administration Tools (845)
  • SCIF interface (842)
  • starting/stopping (988), (997)
  • Control Center support machine
  • general description (859)
  • starting/stopping (998)
  • work distribution (829)
  • Control Center Tools See tools, Control Center
  • copy/expand database directory (1314)
  • copy/move database data disk (1309), (1312)
  • copy/move database log disk (1317)
  • corrective service (934)
    • D
  • Data Restore
  • applylog (1293)
  • invocation (1295)
  • passwords (1294)
  • listlog (1290)
  • invocation (1292)
  • passwords (1291)
  • parameters (1188), (1189)
  • reload (1281)
  • control and output files (1283)
  • invocation (1285)
  • passwords (1284)
  • tape passwords (1286)
  • restore (1273)
  • authorization (1275)
  • invocation (1274)
  • setup (968)
  • parameters file (970)
  • SDRESTOR DIRECTORY (971)
  • SQLMSTR Profile (972)
  • translate (1287)
  • invocation (1288)
  • tape passwords (1289)
  • unload (1277)
  • invocation (1280)
  • passwords (1279)
  • UNLTAPES File (1278)
  • database
  • adding dbextents (1297), (1300)
  • adding dbspaces (1321), (1325)
  • archiving (1214)
  • authorization, notification (1171), (1175), (1176)
  • changing database name (1581)
  • coldlogging (1329), (1332)
  • copy/expand database directory (1315)
  • copy/move database data disk (1310), (1313)
  • copy/move database log disk (1318)
  • database access (1592)
  • deleting dbextents (1303), (1305)
  • listing related Control Center files (1563), (1569)
  • parameters (PARMS)
  • sample file (1024)
  • query DBEXTENT/STORPOOL mapping (1571), (1578)
  • reorganizing catalog indexes (SQLCIREO) (1335), (1338)
  • starting/stopping (1196), (1200)
  • startup and termination tools (1160)
  • archive/trace parameters (1183)
  • authorization/notification parameters (1170)
  • before you begin (1164)
  • overview (1161), (1194)
  • startup parameters (1186)
  • tape parameters (1180)
  • the Database Parameters file (1167)
  • the Database Parameters tool (1165)
  • the storage pool specification file (1168)
  • the termination tool (1198)
  • utility parameters (1177)
  • TAPES File (1267)
  • Database Administration tools
  • Automated DBSPACE Reorganization (1481), (1493)
  • criteria selection screen (1485)
  • how it works (1482)
  • list reorg candidates (1490)
  • run reorg (1492)
  • run reorg prior (1491)
  • table list screen (1488)
  • work space (1496)
  • Automated Update Statistics (1469), (1479)
  • how it works (1472)
  • list statistics (1475)
  • update statistics (1478)
  • Column List (1537), (1540)
  • DBSPACE Reload SUM (1387), (1389)
  • DBSPACE Reorganization (SQLREORG) (1370), (1385)
  • DBSPACE Reorganization SUM (1391), (1398)
  • DBSPACE Search and List (1513), (1515)
  • general description (850)
  • Index List (1531), (1534)
  • list of (852)
  • Package Search and List (1516), (1521)
  • Rebind Package (1499), (1507)
  • Table Reorganization and Redefinition (SQLTABLE) (1421), (1447)
  • Table Search and List (1526), (1530)
  • Database and Support Machines (919)
  • DATABASE MESSAGES file maintenance (1018)
  • database PARMS (1023)
  • database TAPES (1021)
  • database TAPES file format (1113)
  • database virtual machine
  • DBPROF EXEC (965)
  • naming convention (956)
  • parameters file (PARMS) (958)
  • setup (955), (967)
  • starting/stopping (1001)
  • VM directory example (957)
  • DATE/TIME format, changing (1012)
  • DB2 Operator Command Interface See operator command interface
  • DB2 package maintenance (SQLRBIND) (1498), (1506)
  • command mode interface (1597)
  • introduction (1502)
  • panel interface (1503)
  • entry fields (1504)
  • sample output (1505)
  • dbextent mapping (1570), (1577)
  • DBINIT CONTROL (901)
  • file format (1017)
  • file maintenance (1014)
  • location (947)
  • DBSPACE
  • dbspace See DBSPACE, reorganization
  • adding dbspaces (1322), (1326)
  • maintenance
  • automated reorganization (1480), (1494)
  • before you begin (1460)
  • command mode interface (1594)
  • criteria selection screen (1484)
  • determining reorganization candidates (1468), (1483), (1489)
  • how SQLMAINT works (1461)
  • installing SQLMAINT (1463)
  • list/update statistics (1467), (1473), (1476)
  • overview (1459)
  • panel interface (1466)
  • space requirements (1495)
  • SQLMAINT control table (1465)
  • statistics tool (1470)
  • table list screen (1487)
  • who can use SQLMAINT (1462)
  • reorganization
  • backup (1376), (1380)
  • DDL capture (1381)
  • general description (814)
  • how it works (1366)
  • introduction (1365), (1367), (1392)
  • migration (1375)
  • multiple user mode reorganization (1371)
  • single user mode DBSPACE reload (1386), (1388)
  • single user mode DBSPACE reorganization (1390), (1397)
  • unloading to tape (1382), (1396)
  • using tape (1394)
  • who can use it (1368)
  • reorganization driver
  • command mode (1417)
  • failure analysis (1420)
  • how it works (1402)
  • overview (1400)
  • the panel interface (1407)
  • unloading to tape (1412)
  • unloading to temp disk (1414)
  • who can use it (1404)
  • search, list, manipulate (1512)
  • deleting dbextents (1304), (1307)
  • determining reorganization candidates See DBSPACE, maintenance, determining reorganization candidates
  • distributing work with support machines (830)
  • DYNAM/T See tape management
    • E
  • EPIC See tape management
  • EXPLAIN
  • running on a package QUERY (1524)
  • running on a QMF QUERY (1125)
    • F
  • Fast Path Navigation
  • help and hints (1039)
  • how to use it (1035)
  • primary designators (1041)
  • secondary designators (1043)
  • where its not available (1037)
  • files
  • tapes series and history files (1264)
  • full backup
  • ARCHHIST file (1226)
    • G
  • getting started
  • communication path and database settings (1046)
  • communication path (1047)
  • database (1048)
  • fast path navigation (1034)
  • help and hints (1040)
  • how to use it (1036)
  • primary designators (1042)
  • secondary designators (1044)
  • where its not available (1038)
  • list panels (1050)
  • response panels (1053)
  • starting a session (1030)
  • the Control Center main menu (1031)
  • using Control Center (1028)
  • Group Authorization
  • add a group (1128)
  • add/drop objects (1130)
  • drop a group (1129)
  • functions (1132)
  • grant/revoke privileges (1131)
  • installation (1127)
  • invocation (1133)
    • I
  • implicit archives (1263)
  • incremental backup (960), (1282)
  • ARCHHIST file (1225)
  • tape rotation (1265)
  • incremental backup
  • recovery sets (1276)
  • index reorganization
  • command mode (1453)
  • features (1451)
  • how it works (1452)
  • Index Maintenance Utility Screen (1454)
  • files and reports (1457)
  • functions (1455)
  • options (1456)
  • overview (1450)
  • installation
  • corrective service (933)
  • data restore setup (969)
  • database setup (954), (966)
  • minidisk requirements (942), (952)
  • optional steps (930)
  • Control Center Support Machine (932)
  • multiple databases (931)
  • overview (929)
  • prerequisite programs (937)
  • processor requirements (935)
  • virtual machine requirements (940), (953)
    • J
  • job scheduling
  • architecture (1085), (1098)
  • related files (1088)
  • before you begin (1058)
  • concepts (1062)
  • dependencies (1063)
  • execution windows (1069), (1070)
  • HOLIDAYS file (1066), (1097)
  • how it works (1060)
  • how you might use it (1057)
  • job list panel (1078)
  • options (1079)
  • pfkeys (1080)
  • job output list panel (1081)
  • options (1082)
  • pfkeys (1083)
  • jobname RUNTIMES file (1089), (1095)
  • jobname SQMJOB file (1090)
  • master job scheduler (1584), (1586)
  • overview (1056), (1061)
  • panel (1072), (1074)
  • parameters (1073), (1075)
  • priority (1067)
  • problem resolution (1099)
  • problem resolution (1101)
  • reset average runtime (1102)
  • scheduling intervals (1064)
  • SQMJOBS file (1092)
  • TIMES file (1086), (1093)
  • who can use it (1059)
    • L
  • logmode, changing (810)
    • M
  • managing Control Center
  • adding new users (1004)
  • Control Center Administrator (983)
  • maintenance (1006)
  • control file (1009)
  • disk (1008)
  • routine (1007)
  • problem resolution (1026)
  • starting and stopping a database machine (1002)
  • starting and stopping a service machine (989)
  • automatic startup (993)
  • manual startup (991)
  • stopping Control Center (996)
  • starting and stopping a support machine (999)
  • understanding communications (984)
  • understanding interrupts (986)
  • messages (1579), (1580)
  • minidisk password support (1582), (1583)
  • minidisks
  • code minidisk (946)
  • system minidisk (945)
  • monitoring See monitors, database
  • monitors, database
  • active users (1350), (1353)
  • analysis activity (1343)
  • connected users (1351)
  • counters (1356)
  • DBSPACE usage (1354)
  • deactivating (1361)
  • general description (812)
  • how they work (1342)
  • locking (1352)
  • log usage (1348)
  • monitor types (1345)
  • overview (1340)
  • panel interface (1346), (1347), (1362)
  • pool usage (1355)
  • reset counters (1357)
  • scheduling (1360), (1363)
  • up and running verification (1349)
  • VMDSS counter internal (1358)
  • VMDSS counter pool (1359)
  • who can create (1344)
    • O
  • Object Search and List
  • columns (1539)
  • DBSPACES (1514)
  • indexes (1533)
  • invocation (1509)
  • navigation (1510)
  • overview (1508)
  • packages (1517)
  • running EXPLAIN on a package QUERY (1525)
  • tables (1528)
  • view packages (1519)
  • views (1536)
  • who can use it (1511)
  • operator command interface
  • advantages of use (1142)
  • before issuing SQLREX (1146)
  • before you begin (1136)
  • DB2 tracing (1141)
  • direct operator command tool (1144)
  • overview (1134), (1140)
  • panel interface (1138)
  • SQLREX (1147)
  • VMDSS panel interface (1139)
  • overview
  • before you begin (1202)
  • database archiving
  • cancel archive (1219)
  • history (1223)
  • initiate/schedule archiving (1216)
  • log (1228)
  • tape maintenance (1231)
  • view job schedule (1221)
  • view tapes (1230), (1232)
  • database recovery
  • cancel recovery (1247)
  • failure restart (1248)
  • filtered log recovery (1260)
  • history (1251)
  • how it works (1238)
  • initiate/schedule recovery (1240)
  • introduction (1236)
  • log (1253)
  • log reconfiguration (1258)
  • manual recovery (1257)
  • tape maintenance (1256)
  • view job schedule (1249)
  • view tapes (1255)
  • log archiving to disk (1208)
  • media types (1206)
  • telling Control Center how to manage (1203)
  • user archiving (1210)
    • P
  • package
  • Rebind Package Tool (1501)
  • running EXPLAIN on a package QUERY (1523)
  • view packages (1520)
  • panel interface (1032), (1052), (1055)
  • parameters (PARMS)
  • archive/tracing (1184), (1185)
  • ARISPOOL (VMDSS) (1169), (1191), (1192)
  • overriding startup parameters (1606)
  • single user mode startup parameters (1605)
  • startup (1187), (1190)
  • tape (1181), (1182)
  • utility (1178), (1179)
  • PARMS file, database (1022)
  • prerequisite programs (938)
  • problem resolution (1025), (1027), (1100)
  • processor requirements (936), (939)
  • Product Benefits (799)
  • Product Overview (797)
  • PROFILE EXEC (990), (994)
    • Q
  • QMF Tools (1121)
  • QMF Tools Setup (1122)
  • QMFINIT $CONTROL sample control file (1123)
  • running EXPLAIN on a QMF QUERY (1126)
  • scheduling a PROC (1124)
    • R
  • rebind package (1500)
  • recovery
  • canceling (1246)
  • filtered log recovery (1259)
  • history (1250)
  • initiating (1239)
  • log mode considerations (1242), (1243)
  • panel interface (1237), (1241), (1244)
  • recovery log (1252), (1254)
  • scheduling (1245)
  • referential integrity
  • considerations (1442)
  • Stand-Alone Referential Integrity Tool (1545)
  • Table Referential Integrity Tool (1542)
  • Referential Integrity Tool (Stand-Alone) (1543)
  • reorganization criteria (1486)
  • reorganizing catalog indexes (SQLCIREO) (1334), (1337)
  • running EXPLAIN on a package QUERY (1522)
    • S
  • scheduling non-Control Center jobs (1585), (1587)
  • SCIF interface See Single Console Interface Facility
  • scratch tape acquisition (1233)
  • scratch tapes (912)
  • service machine (828) See also Control Center service machine
  • SFS databases (1015)
  • authorization (1596), (1600)
  • Shared File System support (1016)
  • Single Console Interface Facility
  • database to service machine (883)
  • with database virtual machine (843)
  • with service machine (844)
  • SQLMAINT (1458), (1464), (1497)
  • SQLMSTR CONTROL file maintenance (1011)
  • SQLMSTR DIRECTRY (900)
  • file maintenance (1013)
  • location (948)
  • SQLMSTR EXEC (992), (995)
  • SQLMSTR HOLIDAYS (1019), (1065), (1096)
  • SQLMSTR JOBS (1091)
  • SQLMSTR PROFILE (926), (1010)
  • SQLMSTR TIMES (1020), (1087), (1094)
  • SQLREORG
  • command mode interface (1598)
  • failure restart (1383)
  • features (1372)
  • minidisk requirements (1377)
  • overview (1369)
  • panel interface (1373)
  • parameters (1374), (1378)
  • problem determination (1384)
  • SUM Reorganization features (1393)
  • usages (1379)
  • SQLREORG Driver
  • command mode (1418)
  • failure analysis (1419)
  • features (1405)
  • how it works (1401)
  • overview (1399)
  • panel interface (1406)
  • Job Control panel (1409)
  • List panel (1408)
  • Tape Control panel (1410)
  • SQLREORG files (1416)
  • unloading to tape (1413)
  • unloading to temp disk (1415)
  • who can use it (1403)
  • SQMOUNT EXEC (1204)
  • when executed (908)
  • SQMREORG (1395)
  • SQMSTAPE EXEC (1205)
  • SQREODR (1411)
  • Stand-Alone Referential Integrity Tool (1544)
  • statistics maintenance tool
  • how it works (1471)
  • list statistics (1474)
  • update statistics (1477)
  • status
  • changing (1154), (1156)
  • displaying (1150), (1152)
  • panel interface (1151), (1153), (1155)
  • resetting DBSTATUS and SQMODE (1158)
  • SQMODE and DBSTATUS (1157)
  • support machine See Control Center support machine
  • support machines (831)
  • System Administration tools
  • Add DBEXTENTS (1298), (1301)
  • Add DBSPACE (1323), (1327)
  • Copy/Expand Database Directory (1316)
  • Copy/Move Database Data Disk (1308), (1311)
  • Copy/Move database Log Disk (1319)
  • Database Archiving (1211), (1234)
  • Database Coldlog (1330), (1333)
  • Database Monitoring (1341), (1364)
  • Database Parameters (1166), (1193)
  • Database Recovery (1235), (1261)
  • Database Startup (1162), (1195), (1197)
  • Database Status (1149), (1159)
  • Database Termination (1163), (1199), (1201)
  • Delete DBEXTENTS (1302), (1306)
  • Direct Operator Command Tool (1135), (1145), (1148)
  • general description (841)
  • list of (847)
  • Operator Command Interface (1137), (1143)
  • Reorganize Catalog Indexes (1336), (1339)
    • T
  • table See also table reorganization and redefinition (SQLTABLE)
  • column list (1538)
  • index list (1532)
  • search, list, manipulate (1527)
  • view list (1535)
  • Table Create Utility (1449)
  • table list panel (1529)
  • table referential integrity (1541)
  • Stand-Alone Referential Integrity Tool (1546)
  • table reorganization and redefinition (SQLTABLE)
  • adding columns (1438)
  • backup (1426)
  • before you begin (1423)
  • column redefinition (1432), (1434), (1437), (1440)
  • command mode interface (1601)
  • ddl capture (1431)
  • failure restart (1444)
  • features (1428)
  • how it works (1425)
  • migration (1433)
  • overview (1422)
  • panel interface (1429), (1435), (1439)
  • parameters (1430), (1436)
  • pause option (1445)
  • problem determination (1446), (1448)
  • processing flow (1427)
  • unloading long varchar fields (1441)
  • unloading to tape (1443)
  • who can use it (1424)
  • tape hopper support (pre-attached tapes) (1604)
  • tape management
  • architecture (906), (913)
  • CA-DYNAM/T (823)
  • EPIC (824)
  • interfaces (904)
  • panel interface (1107), (1111), (1120)
  • requirements (822)
  • scratch tape acquisition (1117)
  • scratch tapes (962), (1118)
  • tape maintenance (1109)
  • adding a record (1114)
  • deleting a record (1115)
  • view tapes file (1108), (1116)
  • VMTAPE (825)
  • tape rotation
  • incremental backup (1266)
  • TAPES File (1268)
  • TAPES file format (1106), (1110), (1112)
  • tools, Control Center
  • overview (840), (854)
  • tools See System Administration tools, Control Center Administration Tools, System Administration tools, System Administration tools, Database Administration tools, Database Administration tools, Control Center Administration Tools, System Administration tools, Database Administration tools
  • tools, Control Center See tools, Control Center
    • V
  • Version Tool
  • command format (975)
  • general options (976)
  • non-Control Center files (978)
  • PTF List Options (977)
  • SQLMSTR PROFILE validation reports (980)
  • system reports (979)
  • features (973)
  • invocation (974)
  • PTF Report (981)
  • view packages (1518)
  • virtual machine requirements
  • Control Center Owner Machine (950)
  • Control Center Service Machine (944)
  • Control Center Support Machine (949)
  • Control Center User Machine (951)
  • database machines (943)
  • MAINT machine (941)
  • VM/ESA (798)
  • VMTAPE See tape management
    • W
  • windows, execution (1068)

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