DB2 Server for VM: System Administration

Index

Numerics
A B C D E F G H I J K L M N O P Q R S T U V W
Numerics
  • 3370 storage device
  • directory size (4042)
  • production minidisk size (3938)
  • service minidisk size (3939)
  • work minidisk size (3937)
  • 3375 storage device
  • directory size (4041)
  • production minidisk size (3925)
  • service minidisk size (3926)
  • work minidisk size (3924)
  • 3380 storage device (4886)
  • directory size (4043)
  • production minidisk size (3928)
  • service minidisk size (3929)
  • work minidisk size (3927)
  • 3390 storage device
  • directory size (4044)
  • production minidisk size (3931)
  • service minidisk size (3932)
  • work minidisk size (3930)
  • 370 mode (4593)
  • 9332 storage device
  • directory size (4045)
  • production minidisk size (3941)
  • service minidisk size (3942)
  • work minidisk size (3940)
  • 9335 storage device
  • directory size (4046)
  • production minidisk size (3944)
  • service minidisk size (3945)
  • work minidisk size (3943)
  • 9345 storage device
  • directory size (4047)
  • production minidisk size (3934)
  • service minidisk size (3935)
  • work minidisk size (3933)
    • A
  • ABNEXIT
  • considerations (4575)
  • DB2 Server for VM usage (4572)
  • abnormal end
  • CICS code AEY9 (4656), (4722)
  • CICS code ASP7 (4723), (4729)
  • CICS code ASRA (4724)
  • exit (4570)
  • in a field procedure (5753)
  • log-full condition (4440)
  • SLOGCUSH (4439)
  • ACCESS
  • restriction (4754)
  • ACCOUNT initialization parameter (4350)
  • accounting facility
  • account numbers for users (5685)
  • accounting exits (5686)
  • dbspace (5287)
  • displaying statistics (4360)
  • enabling (4352), (4356)
  • exit (5695)
  • generating records (5269)
  • introduction (5260)
  • loading data (5292)
  • maintaining accounting data (5286)
  • OPTION statement (5263)
  • records (5274)
  • starting (5267)
  • tables (5288)
  • using (5262)
  • accounting record format
  • CMS user (5279)
  • initialization (5276)
  • operator/checkpoint (5277)
  • remote user (5282)
  • termination (5278)
  • VSE guest user (5284)
  • ACCT operand for accounting
  • directory entries
  • for accounting (5265)
  • acquiring dbspace
  • for packages (4843)
  • ADD DBSPACE operation
  • restarting after a failure (4829)
  • SQLADBSP EXEC (4811)
  • adding
  • dbextents
  • caution regarding (4917)
  • initialization parameters (4907)
  • dbspaces
  • initialization parameters (4821)
  • storage pools (4876)
  • additional databases (5421)
  • address
  • alternate tape drive (4499)
  • addressing type
  • AMODE initialization parameter (4293), (4525)
  • TRACEBUF initialization parameter (4477)
  • advanced program-to-program communication/virtual machine
  • application program usage (4644)
  • inter-machine communications (4635)
  • agent
  • priority (4411)
  • agent structures
  • description (4637)
  • allocating dbextent minidisks (4885)
  • ALT option
  • FILEDEF command (4506)
  • ALTER TABLE statement (5758)
  • altering
  • sorting sequence of a column (5747)
  • alternate tape drive
  • virtual device address (4500)
  • alternative character sets (5553)
  • AMODE(24) parameter
  • SQLSTART EXEC (4527)
  • AMODE(31) parameter
  • SQLSTART EXEC (4526)
  • AMODE parameter
  • in the SQLDBN file (5474)
  • SQLDBGEN (5442)
  • SQLDBINS (5429)
  • SQLLOG (5215)
  • SQLSTART (4292)
  • application program
  • eye-catcher usage (4577)
  • multiple user mode (4538)
  • running in single user mode (4540)
  • application requester
  • CCSID conversion (5598)
  • default CCSID (5629)
  • determining CCSID (5602)
  • setting DBCS option (5642), (5646)
  • setting default CHARNAME (5628), (5633)
  • application requester defaults
  • choosing CCSID after migration (4216)
  • choosing CHARNAME after migration (4215)
  • application server
  • CCSID conversion (5597)
  • default (4126)
  • default subtype
  • uses (4130)
  • name (4116)
  • setting DBCS option (5638)
  • setting default CCSID (5604)
  • setting default character subtype (5634)
  • setting default CHARNAME (5605)
  • application server defaults
  • choosing CCSID after migration (4177)
  • choosing CHARNAME after migration (4176)
  • archiving
  • after ADD DBEXTENT (4918)
  • after DELETE DBEXTENT (4919)
  • ARCHIVE command (5044)
  • ARCHPCT initialization parameter (4443), (5045)
  • caution regarding (4915)
  • commands (5042)
  • concurrently (4447)
  • database (5003), (5038), (5052)
  • default FILEDEF (4532)
  • device address (4619)
  • disk (5083)
  • before starting the application server (5094)
  • disadvantages (5087)
  • during an archive (5091)
  • maintaining (5096)
  • restoring (5144)
  • risks (5088)
  • with shared file system (SFS) (5089)
  • effects on nonrecoverable data (5245)
  • facilities (5005)
  • LARCHIVE command (5072)
  • log archive
  • disk (5082), (5093)
  • introduction (5011)
  • process (5064)
  • log continuity (5173)
  • log size impact (4057)
  • LOGMODE initialization parameter
  • description (4429)
  • of unallocated pages (5008)
  • procedures (5034)
  • processing (5006)
  • restart procedures (5104)
  • restore set and history area (5225)
  • restoring the database (5125)
  • shutdown (4617)
  • SQLEND ARCHIVE command (5041)
  • SQLEND LARCHIVE command (5065)
  • SQLEND UARCHIVE command (5057)
  • tape damage (5150)
  • tape requirements (3977)
  • user archive (5053)
  • using database manager facilities (4999)
  • using user facilities (5000)
  • ARCHPCT
  • initialization parameter
  • archiving (5046)
  • description (4442)
  • log archiving (5073)
  • log activity (4444)
  • ARIBFPPB mapping macro (5762)
  • ARIRCAN MACRO (5738)
  • ARISAVES EXEC
  • SQLDBA bootstrap (4959)
  • syntax (5913)
  • ARISCCS macro (4326)
  • ARISDBG MACRO V (5477)
  • ARISDBMA EXEC (5797), (5911)
  • ARISDTM MACRO (5703), (5722)
  • ARISFDEF EXEC (5467)
  • ARISFPKY EXEC (4218)
  • ARISNLSC MACRO (4940), (4989), (5676)
  • ARISPDFC (5918)
  • ARISPDFC EXEC (5375)
  • ARISQLLD LOADLIB (3911)
  • ARISSEGC MACRO (4972), (4975)
  • SQLBOOTS EXEC (5914)
  • arithmetic operator
  • in syntax diagrams (3826)
  • ARIUEXI
  • parameter list (5691)
  • ARIUEXI parameter list
  • associated areas (5694)
  • ARIUSRDD (4547)
  • ARIUXDT
  • IBM-supplied version (5719)
  • parameter list (5715)
  • ARIUXIT module
  • branching (5687)
  • example user version (5699)
  • IBM-supplied version (5698)
  • installing (5700)
  • service considerations (5701)
  • ARIUXTM
  • IBM-supplied version (5720)
  • parameter list (5716)
  • Assembler
  • preprocessor (3895), (5826)
  • release level (3867)
  • augmented OS QSAM support (4489)
  • automatic restart resynchronization (4673), (4687)
  • AVS session limit considerations (5320)
    • B
  • backout
  • nonrecoverable data (5239)
  • BALR instruction (4559)
  • bias of the dispatcher, adjusting (4406)
  • blank
  • in column with a field procedure (5752)
  • BLKSIZE option (4510)
  • blocking
  • specifying (4509)
  • bootstrap module, contents (4979)
  • bootstrap package
  • contents (4978), (4980)
  • copied to A-disk (4981)
  • creating (4977)
  • definition (4939)
  • buffer
  • data pages in storage (4385)
    • C
  • C
  • preprocessor (3893), (5824)
  • release level (3868)
  • calculations
  • resource utilization (5808)
  • storage space (5838)
  • CALL/RETURN protocols for application programs in single user mode (4568)
  • cancel exit (5729)
  • capacity planning (4012)
  • planning (4150)
  • catalog
  • row length (5871)
  • catalog table
  • average row lengths (5870)
  • modified by CHARNAME (4343)
  • catalog table rows (5872)
  • CEMT transaction (4731)
  • changing
  • the log (5185), (5193)
  • character data (5594)
  • character set
  • alternative (5554)
  • classification and translation (5907)
  • classification table (5904)
  • defining your own (5900)
  • ENGLISH (5564)
  • example (5561), (5903)
  • FRENCH (5566)
  • GERMAN (5567)
  • ITALIAN (5569)
  • PORTUGUESE (5901)
  • selection (4318)
  • SPANISH (5573)
  • starting application server (5577)
  • character sets
  • JAPANESE (Katakana) (5571)
  • character string
  • constants (5581), (5586), (5591)
  • character subtype
  • application server default (4135)
  • changing default (5509)
  • changing existing column attributes (5622)
  • CHARSUB (4132), (4136)
  • choosing default (4131)
  • setting application server default (5636)
  • CHARNAME
  • application requester default (5534)
  • application server default (5533)
  • catalog tables modified (4344)
  • change to catalog tables
  • SQLDBA.ROUTINE (4332)
  • SQLDBA.STORED QUERIES (4333)
  • SQLDBA.SYSLANGUAGE (4334)
  • SQLDBA.SYSTEXT2 (4335)
  • SQLDBA.SYSUSERLIST (4336)
  • changing (4346)
  • changing default (5508)
  • considerations (5544)
  • changing pre-Euro (5552)
  • choosing application requester default (4139)
  • choosing application requester default after migration (4213)
  • choosing application server default (4123)
  • choosing application server default after migration (4173)
  • default CCSIDs (4321)
  • differences between international and english code pages (5620)
  • initialization parameter (4317), (5575)
  • INTERNATIONAL (5603)
  • setting for application requester
  • all application requesters (5625)
  • an application requester (5630)
  • hierarchy used (5623)
  • using SQLGLOB EXEC (5626)
  • using SQLINIT EXEC (5631)
  • setting for application server (5606)
  • checklist for database generation (4148)
  • checkpoint
  • accounting (5275)
  • before an online log archive (5079)
  • caused by nonrecoverable storage pools (5235)
  • CHKINTVL initialization parameter (4435)
  • definition (4434)
  • log archive (5078)
  • records on the log (4996)
  • CHKINTVL
  • initialization parameter (4433)
  • choose
  • in syntax diagrams (3829)
  • choosing
  • application requester default CHARNAME (4141)
  • application server default CHARNAME (4125)
  • application server default coded character set identifier (CCSID) (4124)
  • default character subtype (4133), (4137)
  • default coded character set identifier (CCSID) (4140)
  • CIRA syntax (4671)
  • CIRA transaction (4678), (4682)
  • CIRB syntax (4660)
  • CIRB transaction (4679), (4683), (4698), (4707)
  • CIRC syntax (4694)
  • CIRC transaction (4699), (4708)
  • CIRD transaction (4701)
  • CIRR syntax (4696)
  • CIRR transaction (4664), (4714)
  • CIRT syntax (4720)
  • CIRT transaction (4665), (4715)
  • classification, character (5905)
  • classification table
  • character sets (5908)
  • coded character set identifier (CCSID) (5652)
  • identifying (4322)
  • clearing the log (5189), (5202)
  • CMS
  • abnormal end routine (4576)
  • file manipulation commands (5463)
  • FILEDEF, ALT option (4504)
  • files for initialization parameter (4586)
  • files for initialization parameters (4582)
  • HELP text files (5670)
  • initialization parameter files (4303)
  • OS QSAM (4487)
  • restrictions (4752)
  • CMS communications directory
  • installation process (3991)
  • reloading (3995)
  • CMS work unit (5731)
  • accounting exit (5692)
  • DB2 Server for VM tables (5290)
  • work unit ID (5280)
  • storage requirements (3892)
  • supported operating systems (3847)
  • VM/ESA features supported (3851)
  • COBOL
  • preprocessor (3896), (5827)
  • release level (3864)
  • code point (5595)
  • coded character set identifier (CCSID)
  • application requester default (4138), (5624)
  • application server default (4122), (4324), (5608)
  • catalog tables modified (4342)
  • changing CHARNAME
  • repreprocess (4345)
  • changing defaults
  • summary (5545)
  • CHARNAME change
  • SQLDBA.ROUTINE (4327)
  • SQLDBA.STORED QUERIES (4328)
  • SQLDBA.SYSLANGUAGE (4329)
  • SQLDBA.SYSTEXT2 (4330)
  • SQLDBA.SYSUSERLIST (4331)
  • CHARNAME mapping (5593)
  • choosing a national language (5535)
  • choosing application requester default after migration (4214)
  • choosing application server default after migration (4174)
  • conversion (5596)
  • DBCS conversion (5728)
  • default CCSIDs (4320)
  • defining character sets (5536)
  • determining for an application requester (5601)
  • identifying classification table (5648)
  • identifying translation table (5649)
  • loading information to CMS files (5910)
  • MCCSIDGRAPHIC (4183), (4207), (5614)
  • MCCSIDMIXED (4182), (4206), (5613)
  • MCCSIDSBCS (4181), (4193), (4205), (5612)
  • migration considerations (4175), (5618)
  • mixed (5600)
  • performance overhead (4134), (5539), (5619)
  • SBCS (5599)
  • setting for application server (5607)
  • differences between international and english code pages (5621)
  • uses (4127), (4128)
  • uses for application requester default (4142)
  • coding data by field procedures (5741)
  • coding your own exit
  • accounting (5696)
  • requirements (5717)
  • TRANSPROC (5724)
  • coexistence
  • considerations (4221)
  • VSE and VM (4230)
  • COLDLOG operation (5126), (5207)
  • log reconfiguration and reformatting (5190)
  • no recovery (5120)
  • restarting from a failure (5155)
  • coldstart (5471)
  • collection
  • national language support (5327), (5331), (5333)
  • service machines (5323)
  • COMDIR
  • definition (3999)
  • installation process (3992), (4000)
  • namefind (4001)
  • reloading (3996), (4002)
  • command
  • ARCHIVE (5043)
  • COMMIT WORK (5272)
  • COUNTER (4398)
  • DISCONN (4603), (4777)
  • FORCE (4693)
  • FORMAT (5458)
  • LARCHIVE (5070)
  • RESERVE (5457)
  • ROLLBACK WORK (5273)
  • SHOW ACTIVE (4692)
  • SHOW LOCK MATRIX (4402)
  • SHOW LOG
  • scheduling archives (5049)
  • scheduling log archives (5081)
  • scheduling user archives (5059)
  • SHOW USERS (4624), (4643)
  • SQLEND (4616)
  • SQLEND ARCHIVE (5040)
  • SQLEND DVERIFY (4613)
  • SQLEND LARCHIVE (5067)
  • SQLEND QUICK (4614)
  • SQLEND UARCHIVE (5056)
  • COMMIT WORK (4993), (5270)
  • committing changes, nonrecoverable data (5234)
  • common operator (4275)
  • communication protocol, specifying (4312)
  • concurrent
  • archive (4446)
  • specifying users (4371)
  • users, limit (4372)
  • configuration
  • concepts (5301)
  • database manager (5300)
  • multiple database machines and multiple databases (5308)
  • national language support (5330), (5332)
  • one database machine and one database (5304)
  • primary database machine (5351)
  • secondary database machine (5352)
  • secondary production minidisk (5344)
  • service machine and processor (5325)
  • VSE guest sharing (5523)
  • console, DB2 Server for VMoperator's (4272)
  • constant
  • data type, character string (5587), (5592)
  • CONTINUE response (5138)
  • continuity of log archives (5171)
  • controlling
  • access to ISQL (4782)
  • active user number (4670)
  • data location (4867)
  • device and channel utilization (4865)
  • conventions
  • syntax diagram notation (3821)
  • converting
  • packages (4168)
  • service machine to database machine (4249)
  • copying
  • production minidisk (5377)
  • count-key-data DASD storage
  • dbextent capacity (5846)
  • directory capacity (5852), (5853)
  • log capacity (5845)
  • COUNTER command (4397)
  • CP
  • commands
  • DISCONN (4602), (4778)
  • LINK in SQLFDEF (5470)
  • CREATE TABLE statement (5757)
  • creating
  • bootstrap package (4976)
  • CMS files containing initialization parameters (4583)
  • database archive (5037)
  • database machine (5299)
  • log archive (5062)
  • parameter file (4584)
  • SQLFDEF file (5465)
  • user archive (5050)
  • user machines (5397)
  • CSMT transaction (4730)
  • CUREXTNT
  • control statement
  • database generation (5489)
  • estimating (4081)
  • keyword control statement (5483)
  • Customer Information Control System (CICS)
  • CEMT transaction (4733)
  • CIRD transaction
  • active transactions (4725)
  • transaction information (4704)
  • CIRT transaction (4718)
  • CSMT transaction (4732)
  • DBDCCICS (4668)
  • customizing database manager (5682)
  • CVD (column value descriptor) (5763), (5776)
    • D
  • damaged minidisk
  • database (5016)
  • database and log (5030)
  • log (5022), (5031)
  • damaged minidisks
  • damaged
  • log (5163)
  • DASD
  • failures
  • damaged database (5013)
  • damaged database and log (5025)
  • damaged log (5018)
  • DASD Dump Restore (DDR)
  • optional software (3878)
  • utility (3877)
  • data
  • coding by a field procedure (5745)
  • data areas
  • RMXC (5735)
  • data location
  • controlling (4868)
  • data object (4787)
  • data pages
  • SYS0001 (5874)
  • data recovery (4790)
  • Data System Control (DSC) (4788)
  • data type
  • character string
  • constants (5583), (5588)
  • subtypes (5584), (5589)
  • constants (5585), (5590)
  • database
  • adding (5361), (5407)
  • dbextents (4877)
  • dbspaces (4807)
  • archiving (4998), (5007), (5075)
  • capacity planning (4011), (4149)
  • defining a log (4056)
  • deleting
  • dbextents (4891)
  • design (4794)
  • example (5134)
  • example storage estimate
  • for a production database (5882)
  • for a test database (5880)
  • for an application development database (5881)
  • extents (3960)
  • generation
  • additional databases (5296), (5422)
  • checklist (4146), (4147)
  • control statements (5481)
  • design considerations (4034)
  • keyword control statements (5487)
  • parameters (4020)
  • planning (4010)
  • process (5408)
  • regeneration (4144)
  • restarting from a failure (5156)
  • service minidisk (5393)
  • SQLDBINS EXEC (5378)
  • summary of parameters (4016)
  • summary of process (5512), (5513)
  • machine size (3884)
  • maximum size (4051)
  • maximums (4067), (5897)
  • migration (4152)
  • minidisks
  • replacement (5159)
  • minimum sizes (3955)
  • moving
  • dbextents (4921)
  • log disks (4929)
  • multiple (4222), (5306)
  • user implications (5310)
  • name (4117)
  • conversion (4239)
  • operator
  • description (4273)
  • parameters set at database generation time (4018)
  • physical
  • concept (4795)
  • design (4799)
  • recovery considerations (4992), (5259)
  • regeneration (4145)
  • renaming (4240), (4254)
  • restoring (5076), (5124), (5133)
  • sizes (4039)
  • starter (3962), (4015)
  • storage estimating (5833)
  • database machine (3854), (5302)
  • configuration (5305), (5355)
  • creating (5303)
  • defining (5298), (5381)
  • description (3880)
  • example control statements (5366), (5387)
  • in a TSAF collection (5312)
  • in an SNA network (5313)
  • AVS session limit considerations (5319)
  • initial storage requirements (5819)
  • minidisks (3905)
  • preparation (5371), (5388)
  • primary (5336), (5353), (5359)
  • adding (5362)
  • PROFILE EXEC (5373), (5392)
  • secondary (5338), (5354)
  • adding (5382)
  • size (3883)
  • types (5334), (5335)
  • database manager
  • environment (5348)
  • running in disconnect (4599)
  • startup using a CMS file (4301)
  • database manager archiving facilities
  • description (5002)
  • using to archive databases (5036)
  • using to archive logs (5061)
  • database services utility (DBS utility)
  • non-DB2 Server for VM application server (5802)
  • storage requirements (5830)
  • date
  • exit (5707), (5710)
  • DATE parameter of the VSE STDOPT JCC/JCS (4709)
  • datetime
  • exits (5702), (5714)
  • DB2 Server for VM database manager
  • database
  • design (4793)
  • physical design (4798)
  • DB2 Server for VM database manager
  • operator
  • VSE guest sharing (4653)
  • DB2 Server for VMdatabase manager
  • operator
  • console (4269)
  • description (4270)
  • DBCS (double-byte character set)
  • option (5582)
  • programming languages supported (3869)
  • requirements (3870)
  • DBCS conversion
  • CCSID to CCSID (5727)
  • TRANSPROC exit (5726)
  • DBCS option
  • setting by using SQLGLOB (5639)
  • setting by using SQLINIT (5643)
  • setting for all application requesters (5640)
  • setting for an application requester (5644)
  • setting for application server (5637)
  • dbextent (3959)
  • adding (4878)
  • capacities of IBM DASDs (5848)
  • caution regarding (4916)
  • defining minidisks (4880)
  • definition (5496)
  • deleting (4892)
  • determining initial requirements (4111)
  • estimating sizes (4870)
  • maximum number (4025)
  • MDISK statements for adding (4883)
  • moving (4925)
  • purpose (3961)
  • sizes (4017), (5412)
  • specifying initial (5493)
  • DBMODE parameter (4306)
  • DBNAME directory
  • guest sharing (4648)
  • DBNAME Directory format
  • incompatibilities (5971)
  • DBNAME parameter
  • specifying (4286)
  • SQLADBEX EXEC (4900)
  • SQLADBSP EXEC (4814)
  • SQLCDBEX EXEC (4841), (4926)
  • SQLDBGEN EXEC (5443)
  • SQLDBINS EXEC (5431)
  • SQLLOG EXEC (5211)
  • SQLSTART EXEC (4521)
  • starting the application server (4285)
  • DBS utility (Database Services utility)
  • storage requirements (3899)
  • dbspace
  • acquiring for packages (4844)
  • ADD DBSPACE operation (4813)
  • adding (4806)
  • concept defined (4801)
  • definition (5504)
  • determining internal dbspace requirements (4103)
  • determining requirements
  • initial (4083), (4099)
  • system dbspaces (4084)
  • user dbspace (4100)
  • index in (4803)
  • internal (4108)
  • maximum number (4026)
  • nonrecoverable (5231)
  • nonrecoverable storage pools (5255)
  • overcommitting storage (4862)
  • private (5501)
  • public (4096), (5500)
  • requirement (5868)
  • restarting the ADD DBSPACE operation after a failure (4831)
  • size for system dbspaces (4097)
  • special
  • catalog (4027)
  • HELP text (4029), (4160)
  • HELPTEXT (4092)
  • internal (4030), (5506)
  • ISQL (4094), (5886)
  • package (4028)
  • SYS0001 (4090)
  • SYS0002 (4091)
  • specifying initial (5499)
  • SQLADBSP EXEC (4812)
  • SQLADBSP file (4824)
  • system dbspace requirements (4085)
  • table in (4802)
  • undercommitting storage (4860)
  • user dbspace requirements (4101)
  • DCSSID parameter
  • EXECs (4943)
  • specifying (4289)
  • SQLADBEX EXEC (4902)
  • SQLADBSP EXEC (4816)
  • SQLDBINS EXEC (5445)
  • SQLLOG EXEC (5213)
  • SQLSTART EXEC (4523)
  • starting the application server (4288)
  • DDR (DASD Dump Restore)
  • optional software (3875)
  • utility (3876)
  • deadlock
  • problems (4396)
  • default
  • changing CCSID
  • summary (5547)
  • changing CHARNAME
  • summary (5546)
  • in syntax diagrams (3831)
  • multiple user mode parameters (4294)
  • single user mode parameters (4481)
  • default server (4661)
  • default server_name (4697), (4706), (4713)
  • default server-name (4695)
  • defining
  • a secondary production disk (5357)
  • additional database machines (5297)
  • database (3984)
  • log (4054)
  • minidisks (5410)
  • saved segments in VM/ESA ESA Feature operating system (4962)
  • user machines (5396)
  • DEFSEG
  • example
  • resource adapter above 16 megabytes (4967)
  • using (4961)
  • deleting
  • dbextents
  • from storage pools (4890)
  • initialization parameters (4908)
  • design
  • database generation considerations (4033)
  • determining
  • initial dbextent requirements (4110)
  • internal dbspace requirements (4104)
  • DIRBLK parameter
  • SQLDBINS (5430)
  • direct access storage device (DASD)
  • directory capacity (5855)
  • space requirements (3903)
  • storage capacities (5840)
  • dbextent capacity (5844)
  • directory capacity (5851)
  • log capacity (5843)
  • storage for the DB2 Server for VM production minidisk (3918)
  • storage for the DB2 Server for VM service minidisk (3919)
  • directing the log archive to disk (5086), (5090)
  • directory
  • additional database machine entries (5386)
  • allocation considerations (4049)
  • allocations and database size (4038)
  • capacities of IBM DASDs (5854)
  • CMS communications (3994)
  • delaying changes (4235)
  • example control statements (5365)
  • user machine (5400)
  • EXPAND DIRECTORY operation (4837)
  • expansion (4838)
  • minidisk (3964)
  • purpose (3957)
  • size (4023), (5411)
  • calculating (5863)
  • defining (4035)
  • space estimating (5862)
  • SQLCDBEX EXEC (4836)
  • verifying (4607)
  • volume considerations (4052)
  • disciplines of dispatching (4409)
  • DISCONN (4601), (4776)
  • disconnecting
  • security (4779)
  • disconnecting the database manager (4600)
  • discontiguous saved segment
  • defining components (4930)
  • discontiguous shared segment
  • defining components (4931)
  • disk
  • log archive (5084)
  • log archiving to (3975)
  • DISK LOAD
  • restriction (4768)
  • dispatcher (4405)
  • DISPBIAS initialization parameter (4404)
  • display terminal
  • requirements (3982)
  • displaying
  • transaction information (4702)
  • distributed relational database
  • restrictions (5930), (5933)
  • distributed relational database architecture
  • installing DRDA code (5793)
  • removing DRDA code (5794)
  • DMKSNT
  • example entries for saved segments (base code) (4963)
  • example entries for saved segments (DRDA) (4965)
  • double-byte character set (DBCS)
  • identifiers (5579)
  • DRDA protocol
  • benefits (5790)
  • checklist (5792)
  • DBS utility (5800)
  • installing DRDA code (5795)
  • ISQL (5803)
  • parameter (4314)
  • removing DRDA code (5796)
  • responsibilities (5791)
  • restrictions (5931), (5934)
  • drive
  • alternate tape (4498)
  • DSC (Data System Control) (4789)
  • DSPSTATS initialization parameter (4358)
  • dual copy (5180)
  • dual logging
  • placement of logs (4063)
  • using (5176)
  • DUALLOG initialization parameter (5178)
  • DUMPTYPE initialization parameter (4451)
  • DVERIFY parameter (4609)
    • E
  • END RESTORE response (5142)
  • ENGLISH character set (CCSID=37) (5563)
  • entry point of DB2 Server for VM user programs (4557)
  • environment considerations
  • VM/ESA operating system (5349)
  • equipment failures (5148)
  • ERASE
  • restriction (4756)
  • ESCALATE counter (4400)
  • escalation (4394)
  • estimating
  • catalog dbspace (SYSTEM.SYS0001) (5867)
  • CUREXTNT (4082)
  • dbextent sizes (4871)
  • dbspace size for routines (5887)
  • dbspace sizes for stored SQL statements (5890)
  • directory space requirement (5861)
  • internal dbspace requirements (4107)
  • ISQL dbspace requirements (5884)
  • MAXDBSPC parameter (4079)
  • MAXEXTNT parameter (4076)
  • MAXPOOLS parameter (4073)
  • storage for a database (5835)
  • storage pool requirements (5864)
  • storage pool sizes (4872)
  • EUC (Extended UNIX Code) (5647)
  • example
  • adding dbextents (4887)
  • adding dbspaces (4832)
  • DBS utility commands
  • creating accounting tables (5289)
  • loading accounting tables (5294)
  • DBS Utility commands
  • defining VM minidisks for a database (5416)
  • deleting dbextents (4894)
  • equivalent minidisk sizes on different devices (5857)
  • field procedure (5787)
  • initialization parameters in CMS file (4585)
  • starting the application server in single user mode (4545)
  • SYS0001 storage estimating formula (5878)
  • EXEC
  • ARISAVES (4960)
  • ARISDBMA (5912)
  • ARISFDEF (5468)
  • ARISFPKY (4219)
  • ARISMEX (5109)
  • ARISPDFC (5376), (5917)
  • SQLADBEX (4899), (5107)
  • example (4889), (4896)
  • SQLADBSP (4810), (5106)
  • example (4834)
  • SQLBINS (5112)
  • SQLBOOTS (5916)
  • SQLCDBEX (4840), (4923)
  • SQLCIREO (5108)
  • SQLDBGEN (5111), (5438), (5441)
  • SQLDBINS (5424), (5428)
  • SQLGENLD (4984)
  • SQLLOG (5113), (5209)
  • SQLSTART (5105)
  • STARTUP parameter (5110)
  • EXECIO
  • restriction (4758)
  • EXECS (5919)
  • description (5926)
  • SQLBOOTS (5920)
  • SQLGENLD (5925)
  • syntax (5921)
  • execution machine
  • description (3881)
  • exit
  • installation (5684)
  • exit point
  • for field procedures (5749)
  • exits
  • abnormal end (4571)
  • accounting (5697)
  • cancel (5730)
  • coding your own (5718)
  • date (5705), (5712)
  • time (5706), (5713)
  • EXPAND DIRECTORY operation
  • SQLCDBEX EXEC (4835)
  • EXTEND initialization parameter (4454)
    • F
  • failure
  • DASD
  • damaged database (5014)
  • damaged database and log (5026)
  • damaged log (5019)
  • equipment (5147)
  • restarting the ADD DBSPACE operation (4830)
  • system (5101)
  • fair-share auditing (4412)
  • fast DB2 Server for VM shutdown (4625)
  • field-decoding
  • definition (5743)
  • input and output (5786)
  • field-definition
  • definition (5744)
  • input and output (5784)
  • field-encoding
  • definition (5742)
  • input and output (5785)
  • field procedure
  • abnormal end (5755)
  • control blocks
  • CVD (5773)
  • FPIB (5768)
  • FPPL (5759)
  • FPPVL (5780)
  • FVD (5774)
  • description (5740)
  • example (5789)
  • exit point (5750)
  • value descriptors (5775)
  • field procedure information block (FPIB) (5770)
  • field procedure parameter list (FPPL) (5767)
  • field procedure parameter value list (FPPVL) (5782)
  • field procedures
  • data type considerations (5751)
  • FIELDPROC
  • clause of CREATE or ALTER TABLE (5748)
  • FIELDPROC clause (5756)
  • file support for DB2 Server for VM database manager (4511)
  • FILEDEF
  • ALT option (4505)
  • issued by SQLSTART (4546)
  • issued by SQLSTART EXEC (4534)
  • log archive to disk (4531), (5095)
  • tape (4482)
  • FILEDEF command (4502)
  • files
  • CMS
  • initialization parameters (4304)
  • CMS commands (5462)
  • loading DB2 Server for VM (3985)
  • SQLADBEX (4911)
  • SQLADBEX file (4913)
  • SQLADBSP (4822), (4826)
  • SQLDBN (5472), (5518)
  • SQLFDEF (4909), (5464), (5515)
  • FINDSYS
  • diagnose instruction (4554)
  • fixed-block architecture devices (3936)
  • dbextent capacity (5850)
  • log capacity (5849)
  • folding rules
  • coded character set identifier (CCSID) (5650)
  • SBCS character set (5537)
  • TRANSLATE scalar function (5555)
  • FORCE (4691)
  • format
  • data passed to a field procedure (FPPVL) (5783)
  • FPIB (5772)
  • restriction (4760)
  • value descriptors (CVDs) (5779)
  • FORMAT
  • formatting
  • database minidisks (5460)
  • FORTRAN
  • preprocessor (3897), (5828)
  • release level (3865)
  • FPIB (field procedure information block) (5769), (5771)
  • FPPL (field procedure parameter list) (5760), (5766)
  • FPPVL (field procedure parameter value list) (5765), (5781)
  • fragment of syntax
  • in syntax diagrams (3834)
  • FREEPCT column (4848)
  • SYSDBSPACES (4849)
  • FRENCH character set (5565)
  • FSERASE macro
  • restriction (4772)
  • FSWRITE macro
  • restriction (4774)
  • FVD (field value descriptor) (5764), (5777)
    • G
  • general file support (4512)
  • generating a database (4014)
  • additional database machines (5295)
  • planning (4013)
  • GERMAN character set (5568)
  • GLOBAL resource (4310)
  • guest sharing
  • accessing and operator responsibilities (4646)
  • DBNAME directory (4649)
  • starting (4647)
  • VM/ESA features supported (3850)
    • H
  • hardware requirements (3901)
  • header pages
  • SYS0001 (5876)
  • help text
  • CMS files (5671)
  • installation prompt (5380)
  • loading
  • SQLDBINS EXEC (5507)
  • multiple language (5543)
  • national language (5659), (5679)
  • service disk storage (3953)
  • Help text
  • HELP text
  • HELPTEXT dbspace (4089)
  • hexadecimal values of the sample character sets (5560)
  • history area (5222)
  • host variable
  • in syntax diagrams (3823)
    • I
  • identifiers
  • national language (5669)
  • immediate DB2 Server for VM shutdown (4626)
  • implicit CONNECT support (4667)
  • in-doubt logical units of work (4675), (4684), (4685), (4688)
  • incompatibilities, release to release
  • 2.1 and 1.3.5 (5938), (5940)
  • 2.2 and 2.1 (5942), (5944)
  • 3.1 and 2.2 (5946), (5948)
  • 3.2 and 3.1 (5950), (5952)
  • 3.3 and 3.2 (VM only) (5954), (5956)
  • 3.4 and 3.3 (VM only) (5958), (5960)
  • 3.5 and 3.4 (5962)
  • 5.1 and 3.5 (5964)
  • 6.1 and 5.1 (5966)
  • 7.1 and 6.1 (5969)
  • description (5936)
  • increasing the size of the logs (5195)
  • index
  • invalid (4165)
  • location in dbspaces (4805)
  • initial storage (5816)
  • initialization parameters
  • ACCOUNT (4349)
  • AMODE (4291)
  • ARCHPCT (4441)
  • CHARNAME (4316)
  • CHKINTVL (4432)
  • CMS file (4587)
  • DBMODE (4305)
  • DBNAME (4287)
  • DCSSID (4290)
  • DISPBIAS (4403)
  • DSPSTATS (4357)
  • DUMPTYPE (4450)
  • EXTEND (4455)
  • LOGMODE (4427)
  • LTIMOUT (4419)
  • maximums (5894)
  • multiple user mode (4284), (4530)
  • NCSCANS (4413)
  • NCUSERS (4370)
  • NDIRBUF (4388)
  • NLRBS (4391)
  • NLRBU (4390)
  • NPACKAGE (4379)
  • NPACKPCT (4381)
  • NPAGBUF (4383)
  • overriding (4299), (4578)
  • parameter file creation (4581)
  • PROCMXAB (4421)
  • PROTOCOL (4315)
  • PTIMEOUT (4424)
  • SECALVER (4361)
  • SECTYPE (4364)
  • single user mode application programs (4478)
  • SOSLEVEL (4448)
  • SQLADBEX EXEC (4906)
  • STARTUP (4297)
  • SYNCPNT (4353)
  • SYSMODE (4296)
  • TCPPORT (4367)
  • TRACCONV (4456)
  • TRACDBSS (4468)
  • TRACDRRM (4457)
  • TRACDSC (4470)
  • TRACEBUF (4475)
  • TRACRDS (4469)
  • TRACSTG (4459)
  • TRACWUM (4458)
  • installation
  • defaults
  • changing CCSID (5549)
  • changing CHARNAME (5548)
  • exit (5683), (5788)
  • installation process
  • CMS communications directory (3993)
  • defining a user machine (3989)
  • generating an database (3987)
  • loading DB2 Server for VM (3986)
  • planning (3836)
  • SNA NETID file (4007)
  • installation replaceable exits (5709)
  • inter-machine communications (4636)
  • Inter-User Communication Vehicle (IUCV) (4634)
  • CONNECT (4640)
  • syntax for *IDENT (4236)
  • syntax for IUCV (4238)
  • internal dbspace
  • format (5505)
  • requirements (4105)
  • invalid indexes (4164)
  • ISQL (Interactive Structured Query Language)
  • controlling access to (4783)
  • controlling active user number (4669)
  • dbspace (4093)
  • estimating dbspace requirements (5885)
  • non-DB2 Server for VM application server (5805)
  • routines
  • estimating dbspace size (5889)
  • stored SQL statements
  • estimating dbspace size (5891)
  • ITALIAN character set (5570)
  • IUCV
  • *IDENT statement (5370)
  • ALLOW (5369)
    • J
  • JAPANESE (Katakana) character set (5572)
    • K
  • key
  • language keys and language identifiers (5668)
  • keyword
  • in syntax diagrams (3822)
  • keyword control statements (5482)
  • formats (5488)
    • L
  • LABELDEF command (4503)
  • labeling
  • archive tapes (5097)
  • single-volume tapes (4495)
  • tapes (4492)
  • LANGKEY (5665)
  • language key (5664)
  • languages
  • choosing (5531), (5681)
  • messages (5658)
  • national (5657)
  • keys and identifiers (5667)
  • messages (4347)
  • SYSLANGUAGE table (5663)
  • LARCHIVE (5069)
  • LINK commands in SQLFDEF (5469)
  • LOAD
  • used by database manager (4556)
  • load point of DB2 Server for VM user programs (4558)
  • loading
  • accounting data (5293)
  • HELP text
  • SQLDBINS EXEC (5379)
  • message file (5675)
  • saved segments (4968)
  • sequence (4550)
  • LOADLIB
  • ARISQLLD (3912)
  • FILEDEF (4548)
  • LOADMOD (4552)
  • LOADSYS (4555)
  • LOCAL resource (4309)
  • lock escalation (4395)
  • lock wait timeout (4420)
  • LOCKLMT counter (4399)
  • log
  • activity when ARCHPCT is reached (4445)
  • allocation considerations (4059)
  • archive
  • checkpoint (5077)
  • continuity (5172)
  • creating (5063)
  • device address (4620)
  • example (5092)
  • FILEDEF needed (4535)
  • introduction (5010)
  • LARCHIVE command for (5071)
  • SQLEND LARCHIVE command (5068)
  • to disk (5085)
  • capacities of IBM DASDs (5847)
  • continuity (5174)
  • damaged minidisks (5161)
  • database information (4791)
  • defining (5413)
  • description (4995)
  • dual
  • defining (4055), (5414)
  • placing (4062)
  • using (5175)
  • failure
  • switching log data (5219)
  • full processing (4437)
  • history area (5221)
  • increasing the size of (5196)
  • log-full processing (4436)
  • maximum size by DASD type (5898)
  • mode switching (5169), (5205)
  • moving (5198)
  • placement of dual logs (4064)
  • purpose (3958)
  • reconfiguration (5183), (5191)
  • reformatting (5187), (5200)
  • replacing (5160)
  • damaged minidisk (5020), (5027)
  • size (4024), (4065)
  • space (4431)
  • switching log data (5218)
  • switching log modes (5168)
  • usage by DBS Utility loading (4058)
  • volume considerations (4060)
  • logical unit of work (LUW)
  • in-doubt (4689)
  • recovery
  • depending on STARTUP parameter (5121)
  • LOGMODE initialization parameter
  • archiving (4428), (4819)
  • restoring (5137)
  • switching log modes (5165)
    • M
  • macro
  • ARIRCAN (5739)
  • ARISCCS (4325)
  • ARISDBG (5478)
  • ARISDTM (5704), (5723)
  • ARISNLSC (4941), (4990), (5677)
  • ARISSEGC (4973), (4974)
  • SQLBOOTS EXEC (5915)
  • MACRO
  • maintaining
  • accounting data (5285)
  • storage pools (4875)
  • managing
  • storage pools (4855)
  • manipulation commands, CMS files (5461)
  • mapping macro
  • ARIBFPPB (5761)
  • MAXCONN parameter (5367)
  • controlling overloading (4378)
  • inter-machine communications (4638)
  • new databases (5420)
  • MAXDBSPC control statement
  • establishing database maximums (4070)
  • estimating (4078)
  • MAXDBSPC keyword control statement
  • default (5492)
  • SQLDBGEN (5485)
  • MAXEXTNT control statement
  • establishing database maximums (4071)
  • estimating (4075)
  • MAXEXTNT keyword control statement
  • default (5491)
  • SQLDBGEN (5486)
  • maximum values
  • database (4068)
  • database size (4050)
  • system (5896)
  • MAXPOOLS control statement
  • establishing database maximums (4069)
  • estimating (4072)
  • MAXPOOLS keyword control statement
  • default (5490)
  • SQLDBGEN (5484)
  • MCCSIDGRAPHIC (4186), (4196), (4210), (5617)
  • MCCSIDMIXED (4185), (4195), (4209), (5616)
  • MCCSIDSBCS (4184), (4194), (4208), (5615)
  • MDISK control statements
  • allocating dbextent minidisks (4884)
  • directory size (4037)
  • MDISK statements
  • adding dbextents (4882)
  • megabytes of data on 4-kilobyte pages (5859), (5860)
  • message
  • ARI0039E (4452)
  • ARI0041E (4453)
  • ARI0915I (4827)
  • choosing a national language for (5653)
  • loading message file (5674)
  • multiple language messages (5654)
  • multiple national languages (5541)
  • SET LANGUAGE command (4348)
  • methods of dispatching (4410)
  • migrating from a VSE operating system (4225)
  • migration
  • CCSID considerations (4169)
  • CHARNAME considerations (4170)
  • considerations (4154)
  • conversion of packages (4166)
  • databases
  • multiple (4223)
  • defaults
  • changing CCSID (5551)
  • changing CHARNAME (5550)
  • directory space verification (4162)
  • handling mixed data (4200)
  • handling SBCS data (4188)
  • HELPTEXT dbspace (4161)
  • invalid indexes (4163)
  • MCCSIDGRAPHIC (4180), (4199)
  • MCCSIDMIXED (4179), (4198)
  • MCCSIDSBCS (4178), (4187), (4197)
  • mixed primary keys (4217)
  • planning (3840), (4151)
  • resource names (4243)
  • setting an application requester default CCSID (4212)
  • setting an application requester default CHARNAME (4211)
  • setting an application server default CCSID (4172)
  • setting an application server default CHARNAME (4171)
  • VM/SP to a VM/ESA operating system (4245)
  • VM/XA operating system to a VM/ESA operating system (4233)
  • VSE guest sharing (4232)
  • VSE to a VM operating system (4155), (4228)
  • minidisk
  • 4 096-byte blocks (5841)
  • 512-byte blocks (5842)
  • damaged
  • database (5015)
  • database and log (5032)
  • log (5023), (5033)
  • DASD storage requirements for system minidisks (3916)
  • database (3954)
  • defining (5409)
  • dbextents (4881)
  • example (5417)
  • directory (3956)
  • formatting (5456)
  • log (5208)
  • passwords (4633), (5418)
  • primary production (5340)
  • production (3909)
  • protecting (4750)
  • replacing (5158)
  • required for a database machine (3904)
  • requirements for the user facility subset (3968)
  • reserving (5455)
  • secondary production (5342)
  • service (3913)
  • service machine (3965)
  • starter database (3963)
  • system (3908)
  • user machine (3970)
  • requirements (3972)
  • work (3915)
  • mixed data
  • handling after migration (4204)
  • MCCSIDGRAPHIC (4203), (5611)
  • MCCSIDMIXED (4202), (5610)
  • MCCSIDSBCS (4201), (5609)
  • using (5580)
  • mode switching for logs (5167), (5204)
  • module
  • bootstrap (4936)
  • SQLDBBT (4948)
  • SQLISBT (4949)
  • SQLRMBT (4950)
  • MOVEFILE
  • restriction (4762)
  • moving
  • dbextents (4924)
  • dbextents (4920)
  • log disks (4928)
  • Moving
  • moving a database
  • from one user ID to another (4247)
  • moving the logs (5197)
  • multiple database migration (4220)
  • multiple language HELP text (5542)
  • multiple language messages (5540), (5655)
  • multiple user access (5309)
  • multiple user mode
  • definition (4279)
  • initialization parameters (4283)
  • running application programs (4537)
  • startup using a CMS file (4302)
  • multiple virtual machine mode
  • definition (4280)
    • N
  • name
  • application server (4119)
  • changing (4241)
  • database (4118)
  • NAMEFIND
  • restrictions (4003)
  • storage fragmentation (4004)
  • NAMESYS macro
  • example SYSNAME values (4956)
  • national language (5530), (5680)
  • choosing (5529)
  • character set (5532)
  • keys and identifiers (5666)
  • messages
  • and HELP text (5656)
  • remote support (5329)
  • VSE guest sharing (5673)
  • support (5528)
  • SYSLANGUAGE table (5662)
  • NCSCANS initialization parameter (4414)
  • NCUSERS
  • limit (4373), (5895)
  • NCUSERS initialization parameter
  • guidelines (4374)
  • setting (4375), (4376)
  • VSE guest sharing (4377)
  • NDIRBUF initialization parameter (4389)
  • network
  • national language support (5328)
  • NLRBS initialization parameter (4393)
  • NLRBU initialization parameter (4392)
  • non-DB2 Server for VM application server
  • DBS utility (5801)
  • ISQL (5804)
  • nonrecoverable data (5243)
  • backing out (5240)
  • committing (5236)
  • dbspaces (5230)
  • restoring (5247)
  • rolling back (5237), (5241)
  • nonrecoverable storage pool
  • data placement (5252)
  • dbspaces (5254)
  • querying (5256)
  • normal DB2 Server for VM shutdown (4621)
  • NPACKAGE parameter (4380)
  • NPACKPCT parameter (4382)
  • NPAGBUF initialization parameter (4387)
  • NPAGBUF parameter (4384)
  • NUCEXT QUERY
  • used by database manager (4562)
  • NUCXDROP
  • used by database manager (4561)
  • NUCXLOAD
  • used by database manager (4553), (4560)
    • O
  • objects (4786)
  • one-phase commit (4676)
  • online resource adapter (4663), (4700), (4721), (4737)
  • online resource adapter data areas
  • RMXC (5734)
  • online support
  • implicit CONNECT support (4666)
  • operation (4655)
  • starting (4659)
  • stopping (4717)
  • online support for VSE guest sharing
  • considerations for stopping (4628)
  • operating
  • console (4271)
  • DB2 Server for VMoperator (4274)
  • multiple databases (4276)
  • online support (4654)
  • planning (4266)
  • VSE guest sharing (4652)
  • operating mode
  • changing (4597)
  • operating modes
  • modes supported
  • 370 mode (3842), (4594)
  • XA mode (3843), (4591), (4595)
  • XC mode (3844), (4592), (4596)
  • XA mode (5689)
  • XC mode (5690)
  • operating systems
  • overview (3841)
  • operator response during restore
  • CONTINUE (5139)
  • END RESTORE (5143)
  • STOP SYSTEM (5141)
  • OPTION statement for accounting (5264)
  • optional
  • default parameter
  • in syntax diagrams (3833)
  • item
  • in syntax diagrams (3828)
  • keyword
  • in syntax diagrams (3832)
  • OS QSAM
  • augmented by DB2 Server for VM database manager (4486)
  • overcommitting dbspace storage (4861)
  • override file
  • example (4958)
  • overriding initialization parameters (4300), (4579)
  • owning a database
  • definition (5307)
    • P
  • package (4088), (4845)
  • conversion (4167), (4229)
  • dbspace (4846)
  • unused (4853)
  • page
  • data
  • SYS0001 (5875)
  • dbspace storage (4800)
  • header
  • SYS0001 (5877)
  • megabytes and 4-kilobyte pages (5858)
  • storage buffers (4386)
  • parameter
  • ACCOUNT (4351)
  • adding dbspaces (4818)
  • AMODE(24)
  • SQLSTART EXEC (4529)
  • AMODE(31)
  • SQLSTART EXEC (4528)
  • CHARNAME (5576)
  • database parameters set at database generation time (4019)
  • DATE (4712)
  • DBMODE (4307)
  • DBNAME
  • specifying in SQLSTART (4308)
  • SQLADBEX EXEC (4901)
  • SQLADBSP EXEC (4815)
  • SQLCDBEX EXEC (4842), (4927)
  • SQLDBGEN EXEC (5444)
  • SQLDBINS EXEC (5432)
  • SQLLOG EXEC (5212)
  • SQLSTART EXEC parameter (4522)
  • dcssID
  • EXEC parameter (4944)
  • SQLADBEX EXEC (4903)
  • SQLADBSP EXEC (4817)
  • SQLDBINS EXEC (5446)
  • SQLLOG EXEC (5214)
  • SQLSTART EXEC (4524)
  • DCSSID
  • DSPSTATS (4359)
  • DVERIFY (4610)
  • LOGMODE (4820)
  • MAXCONN (5368)
  • MAXDBSPC (4080)
  • MAXEXTNT (4077)
  • MAXPOOLS (4074)
  • PARM (5454)
  • POOL (4905), (5450)
  • PROCMXAB (4423)
  • PTIMEOUT (4426)
  • ranges (4021)
  • RESID
  • SQLDBGEN EXEC (5452)
  • SQLDBINS EXEC (5434)
  • SECALVER (4363)
  • SECTYPE (4366)
  • STARTER (5448)
  • starter database (4022)
  • SYNCPNT (4355)
  • TCPPORT (4369)
  • parameter file
  • creation (4580)
  • parentheses
  • in syntax diagrams (3825)
  • PARM parameter (5453)
  • partial row updates (5250)
  • password
  • minidisk (4632), (5419)
  • password implications (4736)
  • performance
  • resource trade-offs (5811)
  • physical database (4796), (4797)
  • PL/I
  • preprocessor (3894), (5825)
  • release level (3866)
  • planning
  • database generation (4009)
  • database manager (3983)
  • DB2 Server for VM database machine (3837)
  • installation (3839), (4008)
  • migration (3838), (4153)
  • operation (4265)
  • POOL
  • keyword control statement (5497)
  • parameter (4904), (5449)
  • PORTUGUESE character set (5902)
  • preparing input for SQLDBGEN (5435)
  • preprocessor
  • storage requirements (3898), (5829)
  • primary database machine (5337), (5360)
  • primary production minidisk (5341)
  • priority dispatcher (4408)
  • privilege classes
  • user machine (5402)
  • processor storage requirements (5806)
  • PROCMXAB initialization parameter (4422)
  • product-supplied archiving facilities
  • description (5001)
  • using to archive databases (5035)
  • using to archive logs (5060)
  • production minidisk (3910)
  • primary (5347)
  • secondary (5356)
  • example (5346)
  • storage requirements (3949)
  • PROFILE EXEC
  • additional database machine (5391)
  • database machine (5372), (5389)
  • user machine (5403), (5404)
  • program products required by DB2 Server for VM database manager (3859)
  • programming languages
  • double-byte character set (DBCS) support (3871)
  • release level (3863)
  • protecting minidisks (4751)
  • PROTOCOL parameter (4311)
  • pseudo-agent structure (4639)
  • PTIMEOUT initialization parameter (4425)
  • public dbspace (4095), (5502)
  • punctuation mark
  • in syntax diagrams (3824)
    • Q
  • Q-disk
  • storage requirements (3952)
  • QSAM, as augmented by DB2 Server for VM database manager (4488)
  • querying
  • nonrecoverable storage pools (5257)
  • quick DB2 Server for VM shutdown (4627)
    • R
  • READCARD
  • restriction (4766)
  • READY/RECOVERY agent (4680)
  • real agents (4641)
  • real storage requirements
  • summary (3902)
  • RECEIVE
  • restriction (4770)
  • reconfiguring the log (5184), (5192)
  • records
  • spanned (4508)
  • recoverable
  • DBS utility command (5249)
  • SQL statements (5248)
  • recovery (5244)
  • abnormal end in a field procedure (5754)
  • considerations (4991), (5258)
  • DASD failures
  • damaged database (5012)
  • damaged database and log (5024)
  • damaged log (5017)
  • dual copy (5182)
  • dual logging (5179)
  • dual logs (5122)
  • history area (5223)
  • log reconfiguration (5194)
  • log reformatting (5203)
  • nonrecoverable data (5233)
  • nonrecoverable dbspaces (5232)
  • nonrecoverable storage pools (5228), (5229), (5253)
  • processing failures with nonrecoverable data (5242)
  • special topics (5164)
  • SQLEND (4631)
  • switching log data between logs (5220)
  • switching log modes (5170)
  • system failure (5099)
  • recovery list (4681)
  • reference information for storage space calculations (5836)
  • reformatting
  • log (5186), (5199)
  • regenerating a database (4143)
  • regular DB2 Server for VM shutdown (4622)
  • release level
  • coexistence (4224)
  • products required by DB2 Server for VM database manager (3860)
  • release to release incompatibilities
  • 2.1 and 1.3.5 (5939), (5941)
  • 2.2 and 2.1 (5943), (5945)
  • 3.1 and 2.2 (5947), (5949)
  • 3.2 and 3.1 (5951), (5953)
  • 3.3 and 3.2 (VM only) (5955), (5957)
  • 3.4 and 3.3 (VM only) (5959), (5961)
  • 3.5 and 3.4 (5963)
  • 5.1 and 3.5 (5965)
  • 6.1 and 5.1 (5967)
  • 7.1 and 6.1 (5970)
  • description (5937)
  • reloading
  • CMS communications directory (3997)
  • COMDIR (3998)
  • remote spooling communications subsystem (RSCS)
  • release required (3862)
  • remote unit of work
  • application server
  • renaming (4252)
  • Remote unit of work (3852)
  • renaming a database (4242)
  • renaming a resource identifier (4261)
  • repeat symbol
  • in syntax diagrams (3830)
  • replacing
  • database and log minidisk (5028)
  • database minidisk (5157)
  • log minidisk (5021), (5029)
  • log minidisks (5162)
  • repository
  • storage requirements (3891)
  • required item
  • in syntax diagrams (3827)
  • requirements
  • DB2 Server for VM database machine
  • software (3858)
  • RESERVE (5459)
  • restriction for (4764)
  • reserved words
  • SQL (3835)
  • resetting
  • the log (5188), (5201)
  • RESID (4115)
  • renaming (4253), (4260)
  • RESID NAMES file (4120), (4121), (4237), (4255), (4259)
  • RESID parameter
  • SQLDBGEN EXEC (5451)
  • SQLDBINS EXEC (5433)
  • resource adapter
  • cancel support (5737)
  • definition (5688)
  • resource adapter data areas
  • RMXC (5736)
  • resource and performance trade-offs (5812)
  • resource names migration (4244)
  • resource utilization calculations (5809)
  • restart recovery
  • definition (4997)
  • restarting
  • ARISMEX (5118)
  • from COLDLOG operation failure (5154)
  • from database generation failure (5153)
  • from database restore operation (5145)
  • from system failure while archiving (5152)
  • procedures (5102)
  • SQLADBEX (5116)
  • SQLADBSP (5115)
  • SQLCIREO (5117)
  • SQLSTART (5114)
  • STARTUP parameter (5119)
  • restore set (5224)
  • restoring
  • database
  • restarting from failure of (5146)
  • restore set and history area (5226)
  • starting the application server when restoring (5132)
  • STARTUP=R (5131)
  • nonrecoverable data (5246)
  • restoring a database
  • procedures (5123)
  • restriction
  • CMS (4753)
  • commands
  • ACCESS (4755)
  • DISK LOAD (4769)
  • ERASE (4757)
  • EXECIO (4759)
  • FORMAT (4761)
  • MOVEFILE (4763)
  • READCARD (4767)
  • RECEIVE (4771)
  • RESERVE (4765)
  • macros
  • FSERASE (4773)
  • FSWRITE (4775)
  • restrictions
  • DRDA protocol (5932), (5935)
  • RESYNCH command (4686)
  • resynchronization (4705)
  • resynchronization transaction (4677)
  • REXX (3873)
  • RMXC (5733)
  • ROLLBACK WORK (5271)
  • ROLLBACK WORK command (4994)
  • rolling back
  • nonrecoverable data (5238)
  • round-robin dispatcher (4407)
  • routine
  • estimating dbspace size (5888)
  • running
  • application programs
  • single user mode (4539)
  • multiple user mode (4536)
  • SQLLOG EXEC (5206)
  • RXSQL (3872)
    • S
  • sample
  • character sets (5562)
  • saved segment
  • defining (3990)
  • saved segments
  • defining (4952)
  • DMKSNT entries (base code) (4964)
  • DMKSNT entries (DRDA) (4966)
  • loading (4971)
  • overlaps (4957)
  • SEGMENT RESERVE command (4934), (4953), (4985)
  • stop using (4987)
  • saved segments (DCSS)
  • national language (5678)
  • saving
  • segments (4969)
  • SBCS character set
  • folding rules (5538)
  • SBCS data
  • handling after migration (4192)
  • MCCSIDGRAPHIC (4191)
  • MCCSIDMIXED (4190)
  • MCCSIDSBCS (4189)
  • scan control blocks (4415)
  • scan table (4416)
  • SECALVER initialization parameter (4362)
  • secondary database machine (5339)
  • secondary production minidisk (5343)
  • defining (5358)
  • example (5345)
  • SECTYPE initialization parameter (4365)
  • security
  • conversation level (4740)
  • distributed processing
  • administration (4748)
  • security (4747)
  • maintaining (4738), (4784)
  • session level (4739)
  • user ID translation (4749)
  • VM directory control statement
  • IUCV *IDENT (4746)
  • IUCV ALLOW (4742)
  • IUCV ANY (4744)
  • VM/ESA operating systems (4741), (4743), (4745)
  • SEGMENT FIND
  • used by database manager (4563)
  • SEGMENT LOAD
  • used by database manager (4564)
  • SEGMENT RESERVE command (4935), (4954), (4986)
  • segment saving (4970)
  • selecting
  • character sets (4319)
  • sequence of loading (4551)
  • server_names
  • on the CIRA transaction (4672)
  • on the CIRB transaction (4662)
  • service disk storage requirements (3950)
  • service machine
  • converting to a database machine (4248), (4250)
  • defining (3988)
  • example (5326)
  • in a collection (5324)
  • minidisks (3966)
  • size (3885)
  • service minidisk (3914)
  • session limit (AVS) (5321)
  • SET APPCVM (4651)
  • SET MACHINE command (4598)
  • setting
  • default character subtype (5635)
  • shadow paging (5866)
  • shared file system directory (SFS directory)
  • production minidisk size (3947)
  • service minidisk size (3948)
  • work minidisk size (3946)
  • shared segment (4932)
  • SHOW ACTIVE (4690)
  • SHOW LOCK MATRIX command (4401)
  • SHOW LOG
  • scheduling archives (5048)
  • scheduling log archives (5080)
  • scheduling user archives (5058)
  • SHOW USERS (4623), (4642)
  • shutdown of the application server (4606)
  • signing off the DB2 Server for VM system console (4604), (4780)
  • single console image facility (SCIF) (4277)
  • single user mode
  • AMODE(24) (4544), (4549)
  • CALL/RETURN protocols for application programs (4569)
  • definition (4281)
  • initialization parameters (4479), (4480)
  • running application programs (4541)
  • starting the application server (4543)
  • starting the application server and providing user parameters (4567)
  • single virtual machine mode
  • definition (4282)
  • single-volume tapes (4494)
  • size
  • database (4040)
  • directory (4031), (4036), (5415)
  • internal dbspaces needed (4106)
  • log (4032), (4066)
  • by DASD type (5899)
  • SLOGCUSH initialization parameter
  • description (4438)
  • freeing log space (5047), (5074)
  • slots
  • use of (4858)
  • SNA (see Systems Network Architecture) (5317)
  • SNA NETID file (4005)
  • software requirements (3857)
  • sorting sequence, altering by a field procedure (5746)
  • SOSLEVEL initialization parameter (4449)
  • space
  • DB2 Server for VM production minidisk (3922)
  • DB2 Server for VM service minidisk (3923)
  • space allocations
  • log and dbextent minidisks (5856)
  • SPANISH character set (5574)
  • spanned records (4507)
  • specifying
  • initial dbspace (5503)
  • user parameters (4565)
  • SPIE exit
  • considerations (4574)
  • SQLADBEX EXEC (4897), (4898)
  • example (4888), (4895)
  • SQLADBEX file (4912), (4914)
  • SQLADBSP EXEC (4102), (4808), (4809)
  • example (4833)
  • SQLADBSP file (4825)
  • SQLADBSP file (4823)
  • SQLBOOTS EXEC (4988)
  • SQLCDBEX EXEC (4839), (4922)
  • SQLCODE
  • -522 (4417)
  • -937 (4727), (4728)
  • -945 (4851)
  • -946 (4852)
  • SQLDBA
  • bootstrap package (4942)
  • password (5511)
  • SQLDBBT module (4945)
  • SQLISBT module (4946)
  • SQLRMBT module (4947)
  • user ID (5510)
  • SQLDBA.ROUTINE
  • CHARNAME change (4337)
  • SQLDBA SQLDBBT Q (5922), (5927)
  • SQLDBA SQLISBT Q (5923), (5928)
  • SQLDBA SQLRMBT Q (5924), (5929)
  • SQLDBA.STORED QUERIES
  • CHARNAME change (4338)
  • SQLDBA.SYSLANGUAGE
  • CHARNAME change (4339)
  • SQLDBA.SYSLANGUAGE table (5660)
  • SQLDBA.SYSTEXT2
  • CHARNAME change (4340)
  • SQLDBA.SYSUSERLIST
  • CHARNAME change (4341)
  • SQLDBGEN example (5479)
  • SQLDBGEN EXEC (5437), (5440)
  • files used by (5476)
  • format (5439)
  • preparing input for (5436)
  • SQLDBGEN file (4256), (5517)
  • renaming a resource identifier (4262)
  • SQLDBINS EXEC (5423), (5427)
  • format (5425)
  • running (5426)
  • SQLDBN file
  • contents (5473), (5475), (5520)
  • purpose (5519)
  • renaming a database (4257)
  • renaming a resource identifier (4263)
  • use of (4951)
  • SQLDS protocol (4313)
  • SQLEND
  • ARCHIVE (5039)
  • DVERIFY (4611)
  • LARCHIVE (5066)
  • QUICK (4612)
  • UARCHIVE (5055)
  • SQLEND operator command (4615)
  • SQLERRD2
  • -30 (4418)
  • SQLFDEF file (5514), (5516)
  • creating (5466)
  • renaming a database (4258)
  • renaming a resource identifier (4264)
  • single logging (5216)
  • updated by SQLADBEX (4910)
  • SQLGENLD EXEC (4937), (4982), (4983)
  • SQLGLOB EXEC
  • setting DBCS option (5641)
  • setting default CHARNAME (5627)
  • SQLINIT EXEC
  • issuing for a user (5406)
  • setting DBCS option (5645)
  • setting default CHARNAME (5632)
  • SQLLOG EXEC (5149), (5210)
  • SQLSTART EXEC (4520), (4828)
  • restoring the database example (5127)
  • STAE exit, considerations for (4573)
  • starter database
  • control statements (5480)
  • STARTER parameter (5447)
  • starting
  • accounting facility (5268)
  • online support (4658)
  • starting application server
  • after restoring the database (5136)
  • FRENCH character set example (5578)
  • restoring (5129)
  • STARTUP=R (5128)
  • starting the application server (4267), (4588)
  • multiple user mode (4519)
  • single user mode (4542)
  • STARTUP initialization parameter
  • restart procedures (5103)
  • restoring a database (5130)
  • STDOPT JCC/JCS (4711)
  • STOP SYSTEM response (5140)
  • stopping the application server
  • online support (4630), (4716)
  • recovery considerations (4618)
  • storage
  • capacity IBM DASD (5839)
  • concepts (4785)
  • devices (4048)
  • estimating (5834)
  • initial (5815)
  • initial storage formula (5814)
  • initial storage requirements (5820)
  • processor requirements (5810)
  • requirements
  • DB2 Server for VM production minidisk (3920)
  • DB2 Server for VM service minidisk (3921)
  • DBS utility (5832)
  • processor (5813)
  • virtual
  • recommended (3890)
  • virtual storage requirements
  • user machines (5821)
  • storage pool
  • adding dbextents (4879)
  • concepts (4792)
  • controlling
  • channel utilization (4864)
  • device utilization (4863)
  • controlling data location (4866)
  • definition (5495)
  • deleting dbextents (4893)
  • design considerations (4857)
  • estimating size (4869)
  • maintaining (4874)
  • management (4856)
  • monitoring (4873)
  • nonrecoverable (5227)
  • requirements (5865)
  • space (4430)
  • specifying initial (5494)
  • support
  • application dbspaces (4113)
  • internal dbspaces (4114)
  • system dbspaces (4112)
  • storage pools
  • definition (5498)
  • storage requirements
  • DBS utility (3900)
  • storage requirements (virtual and real) (5807)
  • storage space calculations (5837)
  • stored SQL statements
  • estimating dbspace size (5892)
  • subtype
  • application server uses (4129)
  • switching
  • log data between logs (5217)
  • log modes (5166)
  • SYNCPNT initialization parameter (4354)
  • SYNCPNT parameter
  • multiple-site read multiple-site update (5798)
  • multiple-site read single-site update (5799)
  • syntax diagram
  • notation conventions (3820)
  • SYS0001 dbspace (4086)
  • storage estimating (5869)
  • derivation of the formula (5873)
  • examples (5879)
  • modifying the formula (5883)
  • SYS0002 dbspace (4087)
  • allocation (4847)
  • SYS000n dbspace (4850)
  • SYSCCSIDS catalog table (5558)
  • SYSCHARSETS catalog table (5557)
  • SYSIN, valid assignments for (4513), (4516)
  • SYSLANGUAGE catalog table
  • example (5661)
  • SYSMODE initialization parameter (4295)
  • SYSNAME values for NAMESYS
  • example (4955)
  • SYSOPTIONS catalog table
  • updating (5721)
  • SYSPRINT, valid assignments for (4514), (4517)
  • SYSPUNCH, valid assignments for (4515), (4518)
  • SYSSTRINGS catalog table (5559)
  • system
  • code
  • description (4938)
  • dbspaces
  • size (4098)
  • failure (5100)
  • maximums (5893)
  • minidisk (3907)
  • DASD storage requirements (3917)
  • minidisks (3906)
  • signing off console (4605), (4781)
  • software requirements (3856)
  • virtual storage requirements (3879)
  • Systems Network Architecture (SNA)
  • AVS session limit considerations (5322)
  • database machines (5314)
  • definition (5316)
  • NETID file (4006)
    • T
  • table
  • character classification (5906)
  • location in dbspaces (4804)
  • tape
  • archiving (3976)
  • damage (5151)
  • DBS utility processing (3978)
  • FILEDEFs (4485)
  • LABELDEFs (4484)
  • labeled (4493)
  • labeling (5098)
  • requirements (3974)
  • single-volume (4496)
  • support (4483)
  • tracing (3979)
  • unlabeled (4491)
  • tape drive
  • alternate virtual device address (4501)
  • TCPPORT initialization parameter (4368)
  • terminal
  • requirements (3981)
  • terminal line-edit (5374)
  • symbols (5390)
  • terminating
  • online applications (4726)
  • the application server
  • starting (4268)
  • time
  • exit (5708), (5711)
  • TRACCONV initialization parameter (4463)
  • TRACCONV parameter
  • SQLSTART (4464)
  • TRACDBSS initialization parameter (4471)
  • TRACDRRM initialization parameter (4461)
  • TRACDRRM parameter
  • SQLSTART (4465)
  • TRACDSC initialization parameter (4473)
  • TRACEBUF initialization parameter (4474)
  • TRACEBUF parameter
  • SQLSTART (4476)
  • tracing
  • default FILEDEF (4533)
  • tape requirements (3980)
  • TRACRDS initialization parameter (4472)
  • TRACSTG initialization parameter (4460)
  • TRACSTG parameter
  • SQLSTART (4467)
  • TRACWUM initialization parameter (4462)
  • TRACWUM parameter
  • SQLSTART (4466)
  • transaction information
  • displaying (4703)
  • transactions
  • CEMT (4734)
  • CIRD (4657)
  • CIRT (4719)
  • CSMT (4735)
  • TRANSLATE function
  • folding rules (5556)
  • translation table
  • character sets (5909)
  • coded character set identifier (CCSID) (5651)
  • identifying (4323)
  • Transparent Services Access Facility (TSAF) (5315)
  • collection
  • database machines (5311)
  • definition (5318)
  • TRANSPROC exit
  • coding your own (5725)
  • two-phase commit (4674)
    • U
  • unallocated pages
  • archiving (5009)
  • undercommitting dbspace storage (4859)
  • unlabeled tapes (4490)
  • unused package (4854)
  • updating
  • partial rows (5251)
  • VM directory entries (5364), (5384)
  • user archive
  • creating (5051)
  • user facility subset
  • converting to a database (4251)
  • description (3855)
  • minidisk requirements (3967), (3969)
  • user free storage (4933)
  • user machine
  • additional (5394)
  • defining (5395)
  • example control statements (5401)
  • minidisk requirements (3973)
  • minidisks (3971)
  • PROFILE EXEC (5405)
  • size (3887)
  • virtual storage requirements (5823)
  • user parameters
  • in single user mode (4566)
  • user restore
  • definition (5135)
  • using (5181)
  • dual logging (5177)
  • using AMODE(24)
  • incompatibilities (5968)
    • V
  • V-disk
  • storage requirements (3951)
  • value
  • descriptors in field procedures (5778)
  • verifying
  • directory (4608)
  • virtual device address
  • alternate tape drive (4497)
  • virtual disk support
  • internal dbspaces (4109)
  • virtual machine
  • overview (3853)
  • size
  • DB2 Server for VM database manager (3882)
  • user (5398)
  • Virtual Machine (VM)
  • accounting (5261)
  • directory entries
  • for a user machine (5399)
  • for database machines (5385)
  • updating (5363), (5383)
  • single console image facility (SCIF) (4278)
  • virtual storage
  • initial requirements
  • database machines (5818)
  • recommended (3889)
  • requirements
  • DB2 Server for VM components (5817), (5831)
  • user machines (5822)
  • service machine (3886)
  • user machine (3888)
  • VM/ESA (Virtual Machine/Enterprise Systems Architecture)
  • considerations (5350)
  • DB2 Server for VM features (3845)
  • directory entries for accounting (5266)
  • migration from a VM/SP operating system (4246)
  • migration from a VM/XA operating system (4234)
  • running the database manager (4590)
  • VM/SP (Virtual Machine/System Product)
  • migration to VM/ESA operating system (4156)
  • VM/XA SP (Virtual Machine/Extended Architecture System Product)
  • migration from VM/SP operating system (4157), (4158)
  • migration from VM/XA operating system (4159)
  • migration from VSE (4226)
  • running the database manager (4589)
  • VMBACKUP (5004), (5054)
  • optional software (3874)
  • volume considerations
  • directory (4053)
  • log (4061)
  • VSE guest sharing (5521)
  • accessing and operator responsibilities (4645)
  • configuration (5522)
  • DBNAME directory (4650)
  • migration (4231)
  • national language messages (5672)
  • online support (4629)
  • release level of VSE (3861)
  • sample configurations (5524)
  • single processor (5525)
  • TSAF (5526)
  • VM/ESA features supported (3846)
  • VTAM product (5527)
  • VSE guest user accounting record (5283)
  • VSE operating system
  • migration to (4227)
  • VSE STDOPT JCC/JCS (4710)
    • W
  • warm start of the application server (4298)
  • work units
  • accounting exit
  • CMS (5291)
  • work unit ID (5281)
  • CMS (5732)
  • accounting exit (5693)
  • supported operating systems (3848)
  • VM/ESA features supported (3849)

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