Control Center Operations Guide for VSE

Index

Special Characters
A B C D F G H I J K L M N O P Q R S T U V W
Special Characters
  • Controlling access (476)
    • A
  • adding a monitor (767), (783)
  • adding objects to a group (744)
  • adding users to a group (749)
  • Analysis
  • of DBSPACEs (492)
  • Application Group
  • adding objects to (746)
  • defining (742)
  • Architecture
  • database connection (518)
  • invocation (519)
  • overview (471)
    • B
  • backup (802)
  • processing flow (803), (823)
  • Batch jobs
  • deleting (503)
  • holding (502)
  • releasing (501)
  • Benefits
  • automation (464)
  • DDL generation (465)
  • jobscheduling (468)
  • QMF (469)
  • reorganization (466)
  • statistics updating (467)
    • C
  • CEMS transaction ID (556)
  • changing monitor settings (789)
  • changing to a new database
  • overview (569)
  • CICS
  • report controller interface (499)
  • TRANSIDs (522)
  • CICS ID (574)
  • CICS Report Controller Interface
  • a sample session (729)
  • highlights (498)
  • overview (728)
  • CLUSTERRATIO (677)
  • commitcount on reload (609)
  • console message monitoring (758)
  • Control Center Packages
  • rebinding (488)
  • Controlling access (475)
    • D
  • DATA CAPTURE (812)
  • database (460)
  • DATABASE DEFINITION PROC parameter (630), (631)
  • DATE tape file parameter (719)
  • DBA (461)
  • DBSPACE Analysis Tools
  • additional topics (692)
  • initial execution (693)
  • reorganization work space (694)
  • before you begin (647)
  • DBSPACE reorganization analysis tool (681)
  • highlights (491)
  • how they work (648)
  • job options (686)
  • overview (646)
  • reorg criteria (675)
  • Submit screen (682)
  • the DBSPACE Analysis Utility screen (661)
  • functions (662)
  • reorg criteria (676)
  • selection options (670)
  • the SQLMAINT table (649)
  • update statistics analysis tool (680)
  • DBSPACE Reorganization
  • before you begin (585)
  • scheduling (587)
  • single user mode (622)
  • when to reorg (586)
  • DBSPACE REORGANIZATION screen
  • optional parameters (605)
  • options (805)
  • options (598)
  • DBSPACE REORGANIZATION Screen (596)
  • DBSPACE Reorganization Tool
  • about the tool (582)
  • benefits (583)
  • failure restart (641)
  • features (589)
  • highlights (483)
  • how it works (590)
  • processing flow (591)
  • related files (842)
  • problem analysis (643)
  • scheduling (638)
  • single user mode reorganization (624)
  • before you choose it (626)
  • parameters (629)
  • special considerations (636)
  • failure restart (642)
  • problem analysis (644)
  • scheduling (639)
  • submit screen (618)
  • optional parameters (619)
  • unloading to tape (635)
  • use (611), (813)
  • generate DDL (612), (613)
  • reload DBSPACE (617)
  • reorganize DBSPACE (616)
  • unload DBSPACE (615)
  • DBSPACES
  • analyzing (490)
  • DDL to recreate (489)
  • listing reorganization candidates (668)
  • listing update statistics candidates (666)
  • reloading (485)
  • reorganizing (486), (584)
  • unloading (484)
  • DDL (462)
  • DDL STMTS (610)
  • deleting a monitor (771)
  • DEVICE CLASS (720)
  • displaying monitor definitions (774)
  • DISPosition
  • job card parameter (821)
    • F
  • FILE # (691)
  • FILE SEQUENCE NUMBER (716)
  • function keys (576)
    • G
  • Generate DDL (599), (801), (814)
  • GENERATION NUMBER (717)
  • granting
  • authority to a user group (752)
  • Group Authorization Tool
  • adding objects to a group (745)
  • adding users to a group (750)
  • defining a user group (747)
  • defining an application group (743)
  • granting authority to a user group (753)
  • highlights (493)
    • H
  • Help Facility
  • highlights (504)
  • overview (730)
  • TRANSID (535)
    • I
  • Initializing the SQLMAINT Control Table (663)
  • Installation
  • before you begin... (562)
  • overview (563)
  • placement of code (565)
  • prerequisite programs (513)
  • preventive service planning (568)
  • production library (566)
  • Interfaces
  • CICS report controller (500)
  • operator command (482)
  • Invocation
  • using panels (520)
  • using TRANSID (521)
    • J
  • Job Scheduling
  • highlights (505)
  • parameters (620)
  • repetitive DBSPACE reorganizations (637)
  • job submission
  • monitor report (780)
    • K
  • kernal monitor (763)
    • L
  • Listing DBSPACE Reorganization Candidates (667)
  • Listing Update Statistics Candidates (665)
  • LOGFULL condition (645)
  • LOGMODE parameter (632)
    • M
  • Main Menu (571)
  • MODE (721)
  • modifying a monitor (769)
  • monitor
  • adding (766), (781)
  • changing settings (788)
  • console messages (761)
  • database monitor (754)
  • deleting (770)
  • display definition (772)
  • kernel (755)
  • modifying (768)
  • print report (778)
  • reset (756)
  • resetting data (776)
  • specifying thresholds (784)
  • starting (786)
  • starting the kernel (762)
  • stopping (792)
  • stopping the kernel (764)
  • threshold (760)
  • view collected data (773), (790)
  • Monitor Utilities
  • highlights (494)
  • Moving DBSPACEs (487)
  • Multiple database support (480)
    • N
  • NDIRBUF parameter (633)
  • NOVERFLOW ROWS > n% (679)
  • NPAGBUF parameter (634)
  • NUMBER OF TRACKS/BLOCKS (705)
    • O
  • Operation
  • function keys (575)
  • getting started (570)
  • operator command tool (578)
  • Operator Commands
  • COUNTER (581)
  • highlights (481)
  • menu (579)
  • SHOW (580)
  • Overview
  • of architecture (472)
  • of installation (564)
  • product (463)
    • P
  • Package Utilities
  • highlights (495)
  • package migration (735)
  • rebind package (733)
  • reload package (732)
  • unload package (731)
  • view package (734)
  • Parameters
  • DAYS SINCE (672)
  • DBSPACE analysis (671)
  • DBSPACE analysis jobs (685)
  • DBSPACE migration (603)
  • DBSPACE reorganization (604)
  • disk work file label definition (702)
  • FILE # (597), (804)
  • job scheduling (621)
  • rebinding (607), (689), (811)
  • REORG CRITERIA (674)
  • single user mode (479), (627)
  • TABLE migration (808)
  • TABLE reorganization (809)
  • tape work file label definition (713)
  • TLBL (497)
  • WITH REFRESH (669)
  • printing monitor reports (779)
  • Product
  • benefits (470), (474)
  • description (517)
  • software requirements (508)
  • Production library (567)
    • Q
  • QMF (511), (573), (577)
    • R
  • Rebind Package (606), (810)
  • REBIND PACKAGES (688)
  • RELATIVE TRACK/BLOCK (704)
  • Reload DBSPACE (602)
  • reload TABLE (818)
  • Reorg Criteria (673)
  • REORG_DATE (654)
  • REORG_ELAPSED (656)
  • REORG_FREEPCT (657)
  • REORG_PCTINDX (658)
  • REORG_STATUS (659)
  • REORG_TIME (655)
  • REORG_WEIGHT (660)
  • Reorganize DBSPACE (601)
  • reorganize table (817)
  • Requirements
  • program (514)
  • software (507)
  • reset monitor (757)
  • resetting monitor data (777)
    • S
  • Scheduling
  • DBSPACE analysis jobs (683)
  • DBSPACE reorganizations (588)
  • UPDATE STATISTICS jobs (684)
  • Scheduling jobs (506)
  • setting monitor thresholds (759)
  • Single User Mode
  • before you choose it (625)
  • DBSPACE reorganization (623)
  • reorganization parameters (628)
  • startupparameters (478)
  • Software requirements (510)
  • specifying monitor thresholds (785)
  • SQB01, example using (614), (830), (832), (835), (840)
  • SQB02, example using (831), (833), (834), (836), (841)
  • SQB60, example using (815), (837), (838)
  • SQB62, example using (839)
  • SQDR transaction ID (548), (593)
  • SQFM transaction ID (554)
  • SQGA transaction ID (544), (741)
  • SQHM transaction ID (558)
  • SQL/DS
  • and Control Center for VSE (516)
  • SQL Master for VSE
  • and DB2 (515)
  • highlights (473)
  • SQLMAINT
  • updated during reorgs (592)
  • SQLMAINT table
  • description (650)
  • initializing (664)
  • SQM transaction ID (542)
  • SQMDAT (851), (853)
  • SQMDDL (847), (858), (859)
  • definition (850)
  • SQMDDLn (852)
  • SQMM transaction ID (550)
  • SQMMESG (855)
  • SQMPARM (640), (844), (849)
  • definition (843), (848)
  • SQMRDAT (845)
  • definition (846)
  • SQMTAPE (854)
  • SQMWORK (696), (700), (706), (707), (710) , (711), (722), (723), (856), (857)
  • SQOM transaction ID (546)
  • SQPM transaction ID (552), (738)
  • SQTU transaction ID (560)
  • starting a monitor (787)
  • Startup parameters (477)
  • stopping a monitor (793)
  • stopping the kernal monitor (765)
  • stored procedures (829)
  • System
  • software (509)
    • T
  • table job submission
  • optional parameters (826), (828)
  • required parameters (820)
  • table reorganization
  • submit screen (819)
  • Table REORGANIZATION screen (806)
  • optional parameters (807)
  • table utility
  • CREATE TABLE function (822)
  • creating table parameters (825)
  • description (794)
  • DROP TABLE function (799)
  • inserting and deleting data (824)
  • invocation (795)
  • LIST TABLES function (798)
  • REORGANIZE TABLE function (800)
  • UPDATE STATISTICS function (827)
  • table utility tool (512)
  • TAPE FILE NAME (690)
  • transactions
  • CEMS (533), (557)
  • for CICS report controller (534)
  • for dbspace analysis menu (530)
  • for dbspace reorganization (528)
  • for group authorization tool (539)
  • for help facility (537)
  • for main menu (524)
  • for operator commands menu (526)
  • for package utility tool (541)
  • for work file label definition (532)
  • SQDR (527), (549), (594), (595)
  • SQFM (531), (555)
  • SQGA (538), (545), (739), (740)
  • SQHM (536), (559)
  • SQM (523), (543)
  • SQMM (551)
  • SQMM1 (529)
  • SQOM (525), (547)
  • SQPM (540), (553), (736), (737)
  • SQTU (561), (796), (797)
    • U
  • UNCLUSTERED INDEX (678)
  • Unload DBSPACE (600)
  • unload table (816)
  • UPDATE ALL STATISTICS (687)
  • update statistics (608)
  • UPSTAT_DATE (651)
  • UPSTAT_ELAPSED (653)
  • UPSTAT_TIME (652)
  • User Group
  • adding users to (751)
  • defining (748)
  • User ID (572)
  • using monitors (782)
    • V
  • VERSION NUMBER (718)
  • view monitor collected data (775), (791)
  • VOLUME SEQUENCE NUMBER (715)
  • VOLUME SERIAL NUMBER (703), (714)
    • W
  • Work File Label Definition
  • disk work file label definition fields (701)
  • disk work file label definition screen (699)
  • highlights (496)
  • how it works (698)
  • overview (695)
  • package messages work file (725)
  • package work file (724)
  • special considerations (726)
  • size of defined files (727)
  • tape work file label definition fields (709), (712)
  • tape work file label definition screen (708)
  • Work File Label Definition screen (697)

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