DB2 Server for VSE & VM: Database Administration

Index

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

ABNEXIT macroinstructions (2657)

abnormal end (2655), (2656), (2665)

accessing

checking which application server (3315)

accounting facility (3147)

ACQUIRE DBSPACE (2054)

acquiring dbspace

for use (2008)

PRIVATE dbspace (2022)

PUBLIC dbspace (2021)

activate

all keys and constraints on a table (2369)

primary key (2374)

unique constraint (2373)

adding

a new DB2 user

to DB2 Server for VSE & VM application server (2432)

to non-DB2 Server for VSE & VM application server (2433)

alternate HELP text languages (2752)

column to a table (2351), (3059)

dbspace (2007)

HELP text topic (2765)

index to a table (3070)

ALLUSERS (2586)

authorization ID (2587)

ALTER

restriction for view (2199)

ALTER TABLE

activating keys and constraints (2364)

adding column to a table (3058)

inactive key, table, constraint (2355)

altering

table

activating keys and constraints (2368)

authorization (2349)

deactivate primary/foreign key (2375)

design (2346)

inactive key, table, constraint (2358)

application considerations

database (2905)

development

database support (2908)

PRIVATE dbspace (2912)

PUBLIC dbspace (2913)

maintenance (3015)

application development

support in DB2 Server for VSE (3140)

use of synonyms (2991)

application program

backing out data (2715)

building source code files (2898)

capability (2862)

checking code (3006)

code development (2895)

database consideration (2906)

DB2 Server for VSE & VM implementation (2786)

design

implementation alternatives (2787)

implementation considerations (2939)

prototyping (2865)

development capability (2864)

development consideration (2981)

function prototyping (2884)

maintenance consideration (3016)

privilege (2538)

recovery from failure (2651)

report writing (2847)

runner (2607)

application requester

description (1953)

application server

access protocols (3212), (3271)

connecting implicitly (2548)

connecting to (2540), (2568)

controlling access to (2485)

default (2445), (2541)

description (1954)

switching (2562), (2589)

ARINEWUS (2440)

ARISISBT MODULE (3248)

ARISPRC utility (3155)

ARISRMBT MODULE (3247), (3262)

ARISRMKC TEXT Q (3261)

arithmetic operation

binary (3038)

date/time arithmetic

performing operations (3050)

rules (3048)

using labeled duration expressions in (3049)

decimal (3029)

floating point (3040)

arithmetic operator

in syntax diagrams (1858)

atomic operation (2645), (2718)

auditing security

loading information into a table (2619)

printing information (2627)

through the catalog tables (2608)

tracing (2610)

authority

changing (3076)

CREATE TABLE (2491)

granting (2503)

revoking (2511)

type

CONNECT (2486)

DBA (2166), (2483), (2501), (2925)

RESOURCE (2167), (2489), (2922)

SCHEDULE (2495)

authorization

change (3078)

check (2613)

retrieving catalog information about (2282)

authorization ID

ALLUSERS (2588)

AUTOCOMMIT (2709)

AVGCOLLEN (3184)

AVGROWLEN (3177)

back-up copy of a database (2736)

backing out data during an ISQL session (2707)

batch/interactive

application consideration (2941)

application processing (3129)

application security (2943)

capability (2789)

error handling (2948)

recovery (2945)

batch job (2790)

batch partition (2795)

binary arithmetic operation (3039)

BIT data

choosing subtype (2111)

blocking

backouts initiated by application programs (2719)

preprocessor BLOCK option (2696)

bootstrap module (3259)

building source code files (2899)

CANCEL (2700), (2711)

CASCADE

DELETE considerations (1931)

cascading REVOKE (2531)

catalog

used in database design (1977), (2265)

catalog table

authorities and privileges (2475), (2497)

information about privileges (2284)

reorganizing the indexes on (2422)

securing (2602)

support (3020)

SYSCATALOG (2270)

used in database design (2266), (2877)

view (2280)

CCSID (coded character set identifier)

application programming for distributed data (1962)

moving data between application servers (2384)

performance overhead (1963)

specifying for a column (2077), (2113)

changing

data relationships (3073)

referential integrity relationships (3074)

table design (2347), (2352)

unique contraints (3075)

user passwords (2599)

users of data (3084)

CHAR

choosing rather than VARCHAR (2099)

character data

choosing between VARCHAR and CHAR (2098)

character subtype

choosing BIT (2106)

choosing MIXED (2105)

choosing SBCS (2107)

specifying for a column (2078)

CHARNAME parameter of exec (3222), (3281)

CHECK option of preprocessor (3008)

checking

application code (3005)

choose

in syntax diagrams (1861)

CICS (Customer Information Control System)

CISQ transaction (2686)

CONNECT considerations (2573)

CSSN transaction (2577)

DFHPCT macroinstruction (2678)

DFHSIT macroinstruction (2674)

dynamic transaction backout program (2649), (2977)

GCBE abend code (2688)

implicit CONNECT support (2576)

interactive application support (3141)

ISQL support (3146)

multiple application servers (2670)

option (3134)

pseudoconversational transaction (2979)

recovery processing (2976)

sign on (2964)

synchronization points (2672)

SYNCPOINT (2970)

transaction processing (2808), (3132)

transaction program (2810)

user identification and verification (2963)

CICS macroinstruction

DFHPCT (2676)

DFHSIT (2680)

CICSUSER default user ID (2583)

CISQ transaction (2685)

CLUSTERED index (2242) See also clustering index

clustering index

description (2045), (2243)

when to create (2259)

CMS (Conversational Monitor System)

subset mode (2827)

work unit (2644)

code development (2896)

collection (3097)

column

adding (3056)

changing name in a view (2183)

data storage (3181)

data types for (2086)

dropping (3061)

maximum number in a query (3351)

more than 254 bytes (2254)

multicolumn key (1903)

naming (1889)

naming convention (2081)

null value (1893)

overhead (3178)

primary key (1898)

retrieving catalog information (2272)

specifying

CCSID (2075), (2114)

character subtype (2076)

data type (2073)

field procedure (2079)

name (2072)

valid data type (1892)

command

AUTOCOMMIT (2708)

CANCEL (2699), (2710)

DBS SET LINEWIDTH (2802)

FORCE (2738)

FORMAT (2839)

INPUT (2206), (2323)

length maximum in ISQL (3352)

PRINT (2842)

REPRO (VSAM) (2331)

SET ERRORMODE (2956)

SHOW DBSPACE (2425)

comment

retrieving from catalog tables (2293)

storing (2289)

COMMENT ON statement (2292)

COMMIT WORK (2642)

in application programs (2975)

configurations of the DB2 Server for VM system (3091), (3126)

CONNECT (2560), (2967)

explicit (2479)

implicit (2477)

to switch databases (3115)

CONNECT authority (2487)

connecting

to an application server (2539), (2567)

to application server

CICS transactions (2574)

explicitly (2558)

implicitly (2549), (2556)

connecting to the DB2 Server for VSE & VM system (2965)

considerations for

application database (2907)

creating a table (2146)

creating indexes (2247)

deferred constraint enforcement (2381)

DELETE, INSERT, UPDATE (1932)

normalization (2066)

referential integrity (2142)

row size (2068)

unique constraints (2141)

constraint

unique (1906)

comparison to unique index (2136)

considerations in defining (2139)

description (2135)

instead of unique index (2228)

controlling access to

application server (2484)

data (2920)

conventions

highlighting (1850)

syntax diagram notation (1853)

Conversational Monitor System See CMS (Conversational Monitor System)

converting

data types (3026)

converting data types (2988)

copying

a table (2337)

data from one table to another (2334)

CREATE INDEX

PCTFREE clause (2233)

using the statement (2217)

CREATE TABLE (2062), (2493), (3022)

CREATE VIEW

using the statement (2170)

WITH CHECK OPTION (2171)

creating

back-up copy of a database (2735)

HELP text table (2767)

indexes

considerations (2248)

free space considerations (2239)

general information (2210), (2216)

key (2249)

ordering columns in key (2224)

to implement design (1976)

unique (2227)

primary key (2133)

restrictions in creating (2186)

restrictions on using (2185)

table

description (2059)

foreign key (2149)

primary key (2147)

referential constraints (2143)

referential integrity (2144)

to implement design (1972)

view

description (2169)

for multiple tables (2177)

for one table (2175)

new column names (2184)

restrictions on (2189)

to implement design (1974)

using several tables (2180)

CSSN transaction (2578)

data

access change (3051)

administration (3019)

authorization change (3077)

independence (3018), (3023)

moving (2383)

object (1980)

prototyping (2867)

recovery (1983)

structure change (3052)

supported conversions (3025)

data stream trace (3232)

Data System Control (DSC) (1981)

data type

choosing between CHAR and VARCHAR (2100)

choosing between VARGRAPHIC and GRAPHIC (2104)

conversion supported by the DB2 Server for VSE & VM system (2987)

DATE (2124)

DECIMAL (3031)

default (3032)

OVERFLOW error (3033)

precision and scale of result (3037)

defining, for columns (2085)

numeric data (2089)

specified when defining a column (2074)

supported conversions (3024)

TIME (2125)

TIMESTAMP (2126)

database

back-up copy creation (2737)

column (1891)

configurations

one machine, one database (3107)

one machine, two databases (3110)

several machines, different processors (3117)

several machines, many databases (3112)

defining (1890)

definition (3092)

design

analysis (2875)

documentation (2876)

generating test data (2871)

loading test data (2870)

modeling (2868)

normalizing a table (1940)

planning for distributed data (1951)

relationship (1876)

table (1875)

terminology (1869)

designing using DB2 Server for VSE & VM catalog (2267)

entity (1872)

example configuration (3105)

example configurations

accessing from another processor (3120)

one machine, one database (3106)

one machine, two databases (3109)

several machines, different processors (3116)

several machines, many databases (3111)

generation (1969), (2002)

implementing the design (1968)

logical design (3042)

machine (3094)

maintaining consistency under ISQL (3001)

maintenance

altering the design (2297)

procedure (2417)

removing (2308)

removing tables (2394)

manager (3093)

multiple (3089)

operating mode (3102)

physical

concept (1991)

recovery considerations (2631), (2745)

recovery from user logic error (2731)

relationship (1874)

resetting data (2741)

resource adapter (3100)

service machine (3096)

support

for application development (2909)

for query/report writing (2916)

user machine (3098)

database administrator (DBA)

authority (2924)

Database Services utility (DBS utility)

application

error handling (2954)

recovery (2952)

security (2950)

connecting implicitly (2555)

copying a table (2336)

DATALOAD (2989)

DATAUNLOAD (2990)

failure (2691)

interactive processing (2804)

loading test data (2984)

maintenance of a database (2419)

message file (2693)

overview of uses (2797), (2805)

printing the HELP text (2778)

report writing (2845)

restriction for view (2203)

termination (2690)

testing SQL functions (2893)

to load data (2315)

under VSE/ICCF (2319)

UNLOAD/RELOAD

reorganizing data (2801)

resetting data (2729)

DATE data type (2121)

date duration

description (3044)

DATE parameter of exec (3283)

date/time arithmetic (3047) See also arithmetic operation

performing date/time arithmetic operations (2129)

rules for date/time arithmetic (2127)

using labeled duration expressions in arithmetic operations (2128)

DATEFORMAT parameter of exec (3224)

DB2 Server for VM facility, used by EXEC (2855)

DBA authority

description (2500)

introduction (2482)

to ALTER DBSPACE (2407)

DBCS parameter of exec (3220), (3279)

DBEXTENT

description (1988)

DBNAME parameter of exec (3206), (3268), (3309)

dbspace

acquiring

identifying characteristics (2019)

identifying requirements (2009)

restricted (2057)

adding (2006), (2017)

altering the design (2395)

application development (2911)

back-up (2722)

consideration for query user (2931)

defining (1970), (2004)

description (1995)

estimating sizes of (3170)

free space, estimating (2043)

indexes (1997), (3192)

mapping table to (2010)

pages (3172)

PRIVATE (2011), (2490), (2926)

PUBLIC (2012), (2915), (2923)

referential integrity (1998)

removing (2412)

reorganizing to free storage pool pages (2411)

requirement (2005)

resetting data (2727)

size estimating (2023), (3171)

special

HELPTEXT (2769), (2937)

ISQL (2934)

SAMPLE (2938)

SYS000n (2726), (2734)

system (2932)

table in (1996), (2165)

tables in (2014)

type (2020)

usage parameter (2003), (2018)

use in testing (2983)

DCSSID parameter of exec (3209), (3311)

DECIMAL

in column definition (2093)

storage (3182)

decimal arithmetic operation (3030)

default

in syntax diagrams (1863)

default application server (2542)

delete rule

CASCADE (1930)

dependent table (1933)

parent table (1925)

RESTRICT (1926)

SET NULL (1928)

deleting

a user (2453)

restriction for view (2195)

stored query (2465)

table (2390)

dependent table

description (1920)

dependently inactive table (2362)

designing DB2 databases

documentation and analysis (2878)

terminology (1868)

developing application program (2897)

DFHPCT CICS macroinstruction (2679)

DFHSIT CICS macroinstruction (2675)

directory

description (1984)

distributed data

application programming (1961)

description (1952)

implications (1966)

limitations and restrictions (1964)

planning (1948)

DRDA protocol

access to application server (1956)

DATALOAD, DATAUNLOAD (2385)

EXTLUWID (2614), (2622)

logical unit of work identifier (2615)

DROP DBSPACE (2309), (2460)

DROP INDEX (2463)

DROP PACKAGE (2464)

DROP TABLE (2307), (2461), (3063)

DROP VIEW (2462)

dropping

column (3064)

dbspace (2413)

index for a table (3072)

resource adapter code (3318)

table (2389), (3065)

DSC (Data System Control) (1982)

DUALLOG initialization parameter (2743)

dynamic

application backout (2647)

recovery from user errors (2705)

dynamic statement

extended (2834), (2853)

support (2832), (2851)

dynamic transaction backout program of the CICS subsystem (2648)

editing

PRIVATE table (2856)

routine (2860)

entity (1871)

equijoin (1909)

error handling

batch and VSE/ICCF applications (2949)

DBS Utility application (2955)

estimating

calculating PCTINDEX (3194)

dbspace size (2025), (3169)

index size (3195)

length of a stored row (3176)

number of data pages in a dbspace (3189)

number of header pages for dbspace (3188)

storage for a table (3174)

storage pool size (2027)

example

accessing a database on another processor (3119)

adding a column to a table (2353)

altering design of a table (2350)

changing parameters of a dbspace (2402)

changing user passwords (2600)

connecting to default application server (2546)

connecting under authorization ID (2591)

copying tables (2338)

establishing a default application server (2545)

estimating the number of data pages for a table (3190)

granting access to VSE guests (2510)

granting authorities (2508)

merging data from multiple tables (2344)

monitoring privileges (2535)

moving data between dbspaces (2340)

printing the HELP text (2783)

reloading the HELP Text (2774)

removing a dbspace (2415)

removing user from application server (2459)

restricting access using views (2592), (2597)

revoking authorities (2515)

running the DBS Utility (2621)

set up a new ISQL user (2441)

switching application server (2564), (2590)

synonym usage in application program development (2993)

typical security audit queries (2625)

unloading the "PUBLIC"."HELPTEXT" dbspace (2773)

EXEC

ARISDBHD (3324)

ARISDBLD (3326)

authorization (3329)

SQLCIREO (3307)

SQLDBID (3316)

SQLGLOB (3266)

SQLINIT (2544), (3202)

SQLLEVEL (3328)

SQLRMEND (2658), (3320)

SQLSTART (3253)

syntax (3203), (3325), (3327), (3330)

using DB2 Server for VM facility (2854)

using ISQL (2824)

EXPLAIN (2881)

explanation table (2879)

explicit

connect (2561)

CONNECT (2478)

extended dynamic statement (2833), (2852)

EXTLUWID

DRDA protocol (2616), (2623)

failure (2629) See also recovery

application (2632)

DASD (2635)

DBS Utility processing (2692)

ISQL session (2684)

online application (2669)

preprocessor (2695)

subsystem (2636)

system (2634)

user logic error (2633)

fast restore (2747)

field procedure

in comparisons (2130)

specified by FIELDPROC clause (2117)

specified when defining a column (2080)

using null values (2084)

when creating a table (2118)

FIELDPROC

clause of ALTER TABLE statement (2116)

clause of CREATE TABLE statement (2115)

parameters (2120)

file maintenance and reporting (2798)

filtered log recovery (2702)

fixed-length

rows (2069)

FLOAT data type of column (2092)

floating point arithmetic operation (3041)

FORCE (2566), (2739)

foreign key

CREATE TABLE (2150)

description (1915)

planning for (1917)

FORMAT (2840)

fragment of syntax

in syntax diagrams (1866)

free space

for index entries (2234)

in a dbspace (2044)

function

RETRIEVE (2325)

GCBE abend code (2687)

generation/loading of test data (2873)

GRANT (2505), (2528)

GRANT SCHEDULE (2499)

granting

authority (2502), (2506)

privilege (2526)

remote user (2507)

GRAPHIC

choosing rather than VARGRAPHIC (2102)

in column definition (2096)

guest sharing, VSE (3124)

hardcopy output of HELP text

using DBS Utility (2779)

using ISQL (2784)

header page in a dbspace (2039), (3187)

HELP text

adding a topic (2764)

creating your own tables (2768)

dbspace (2936)

enlarging the HELPTEXT dbspace (2771)

in alternate languages (2753)

modification (2750)

moving to another dbspace (2776)

printing the text (2782)

table (2763)

high-level-language program (2793)

highlighting

conventions (1851)

host variable

in syntax diagrams (1855)

hypothetical change to data (3085)

implicit

connect (2547)

CONNECT (2476)

CONNECT support (2575)

inactive key

description (2354)

implicit (2357)

inactive table

description (2360)

INCLUDE (2902)

index

adding (3069)

avoiding on frequently updated columns (2260)

CLUSTERED (2241)

CLUSTERING (2240), (2246), (2258)

creating (1975), (2208), (2215)

description (2214)

dropping (3071)

duplicate key value (2261)

estimating size of (3196)

key

column order (2219), (2223)

considerations (2220), (2250)

location in dbspaces (2001)

maintenance (2237)

migration considerations (2263)

nonunique (2264)

pages in a dbspace (2048), (3191)

PCTFREE consideration (2238)

performance considerations (2257)

primary key (2153)

reorganizing on catalog tables (2423)

restriction for view (2197)

retrieving catalog information about (2275)

unique

creating (2209)

general description (2226)

when to use (2255)

index key

description (2222)

initializing a user machine

setting system defaults (3264)

INPUT (2324)

insert

restriction for view (2193)

rule

dependent table (1935)

for foreign key (2159)

for primary key (2158)

parent table (1934)

with subselect (2986), (3068)

INSERT

INSERT with subselect (3067)

INTEGER data type of column (2091)

interactive application (2791)

Interactive Structured Query Language (ISQL)

affected by implicit CONNECT (2554)

backing out (2706)

CONNECT considerations (2571)

database consistency (2999)

dbspace (2935)

EXEC using (2825)

FORMAT (2841)

INPUT (2322)

INPUT restrictions for views (2205)

maximums (3350)

PRINT (2844)

report writing (2837)

routine (2823)

testing SQL statements (2889), (3004)

routines (2929)

session termination (2683)

setting up a new user (2436)

stored query (2997)

stored query to test SQL statement (3003)

testing SQL statements (2996)

training new users (2450)

internal dbspaces

DASD needs for sorting (3200)

estimating size (3199)

ISQL EXEC (2826)

join

equijoin (1908)

path (1907)

kanji

language key (2758)

KEEP option

of preprocessor (3082)

key

language (2756)

multicolumn (1901), (2252)

primary (1896), (2132)

unique (1897), (1902)

key-level locking (2052)

keyword

ALLUSERS (2585)

in syntax diagrams (1854)

labeled duration

description (3043)

LANGKEY (2757)

language key (2755)

reserved ranges (2759)

when adding HELP text (2766)

LASTING GLOBALV file (3250)

LDATELEN parameter of exec (3287)

description (1959)

loading data

for new users (2447)

from a terminal (2320)

from CMS file (2316)

from other table (2332)

from sequential file (2326)

from virtual reader file (2317)

from VSAM file (2327)

into tables (2312)

using a test dbspace (2982)

using DBS Utility (2872)

using the DBS Utility (2314)

loading security audit information into a table (2618)

local

definition (1955)

LOCK (2406)

LOCK parameter (2050)

locking

key-level (2049)

log

database information (1985)

description (1986)

recovery (filtered) (2703)

logical data design

index (2213)

logical data maximum (3333)

logical unit of work (LUW)

CICS considerations (2580)

description (2643)

general rules (2653)

recovery (2638)

logical unit of work identifier (LUWID)

DRDA protocol (2617), (2624)

logical unit type 6.2 (LU 6.2)

security (2435)

LOGON procedure for implicit connect (2550)

long field (2253)

long-field value

overhead (3185)

storage (3186)

LONG VARCHAR

in column definition (2095)

LONG VARGRAPHIC

in column definition (2097)

LTIMELEN parameter of exec (3289)

LUW See logical unit of work (LUW)

macroinstruction, CICS

DFHPCT (2677)

DFHSIT (2681)

maintenance

application program (3017)

database (2298), (2420)

database consistency (3000)

dbspace (2393)

procedure for a database (2418)

table (2310)

making the HELPTEXT dbspace larger (2770)

managing stored procedure servers (3160)

many-to-many relationship (1887)

many-to-one relationship (1886)

maximum

column

index (3344)

ISQL query (3345)

SELECT-list (3343)

table (3342)

view (3341)

foreign keys per table (3340)

indexes per database (3335)

indexes per table (3339)

length

index key (3347)

ISQL command (bytes) (3348)

row (3346)

logical data limits (3349)

programs per database (3337)

tables per database (3334)

tables per dbspace (3338)

values for ISQL (3353)

views per database (3336)

merging data from multiple tables (2342)

migration

index considerations (2262)

MIXED data subtype (2109)

modeling data designs (2869)

modifying

the online HELP in the database (2748)

moving the HELP text to another dbspace (2775)

multicolumn key (1900), (2221)

considerations (2251)

multiple

database (3088)

tables in a view (2179)

user mode (3103)

Multiple Language HELP Text Support (2751)

NACTIVE column

of SYSDBSPACES (2772)

naming a table (2063)

new user support (2429)

NHEADER

changing (2401)

determining (2038)

nonrecoverable storage pool (2030), (2036)

normal form

first (1942)

fourth (1945)

second (1943)

third (1944)

normalization guidelines (2067)

normalizing a table (1939)

NOT NULL option

of CREATE TABLE (2083)

null

foreign key (1936)

value (1894), (2082)

NUMERIC

numeric data types (2087)

object

in a database (1979)

security (2474)

occurrence of an entity (1873)

one-time query (2814)

one-to-many relationship (1885)

one-to-one relationship (1881)

online

application recovery (2667), (2968)

application security (2960)

HELP (2749)

transaction consideration (2958)

transaction processing (2806), (3131)

operating mode (3101)

operator ID (2581)

optional

default parameter

in syntax diagrams (1865)

item

in syntax diagrams (1860)

keyword

in syntax diagrams (1864)

overflow (3027)

OVERFLOW error in decimal arithmetic operation (3034)

owner

description (2524)

package

performance of (3053)

page

DASD space (1994)

header, in a dbspace (2040)

parameter

CHARNAME (3221), (3280)

DATE (3282)

DATEFORMAT (3223)

DBCS (3219), (3278)

DBNAME (3207), (3267), (3308)

DCSSID (3208), (3310)

LDATELEN (3286)

list for a field procedure (2119)

LOCK (2051), (2404)

LTIMELEN (3288)

NHEADER (2037), (2398)

PARM (3312)

PCTFREE (2041), (2403)

PCTINDEX (2046), (2396)

PROTOCOL (3213), (3272)

QRYBLKSIZE (3217), (3276)

QUERY (3242), (3303)

RESET (3244), (3305)

SSSNAME (3239), (3300)

STACK (3240), (3301)

STORPOOL (2028), (2397)

SYNCHRONOUS (3210), (3269)

TIME (3284)

TIMEFORMAT (3225)

TRACECONV (3235), (3296)

TRACEDRRM (3233), (3294)

TRACERA (3229), (3231), (3292)

WORKUNIT (3227), (3290)

parent table

description (1919)

parentheses

in syntax diagrams (1857)

PARM parameter of exec (3313)

password

changing user's (2598)

PCTFREE

changing (2405)

clause of CREATE INDEX statement (2232)

creating an index (2235)

default for index (2236)

determining (2042)

reserved for an index (2231)

PCTINDEX (2047), (2399), (3193)

peparing a sored pocedure to run (3162)

performance management

application programs (1965)

CLUSTERED index (2244)

multiple database considerations (3122)

periodic

back-up of critical data (2724)

query (2816)

physical database concept (1992)

placing table in dbspace (2163)

planning

distributing data (1949)

DRDA protocol (1950)

precision of decimal result (3035)

preprocessing programs

re-preprocessing (3079)

under development (2900)

with unauthorized statement (3054)

preprocessor

CHECK option (3007)

coding your own (2792)

KEEP option (3081)

termination (2694)

primary key

clause of CREATE TABLE statement (2131)

CREATE TABLE (2148)

description (2134)

identifying (1895)

index (2154)

multicolumn (1904)

planning for (1912)

reorganizing index (2371)

PRINT (2843)

printing

report writing support (3136)

security audit information (2626)

the HELP text

using ISQL (2785)

using the DBS utility (2777)

PRIVATE dbspace

description (2015)

in application development (2910)

private query user data (2918)

PRIVATE table, editing (2857)

privilege

application program (2536)

GRANT option (2523)

granting (2525)

monitoring (2534)

remote user (2530)

revoking (2457), (2529), (2604)

table (2519)

user (2517)

view (2520)

PROCMXAB parameter (3167)

program

affected by implicit CONNECT (2551)

creator (2552)

privilege (2537)

runner (2553), (2606)

programmed query (2829)

programmed report (2848)

PROTOCOL parameter of exec

AUTO (3215), (3274)

DRDA (3216), (3275)

SQLDS (3214), (3273)

prototyping

application function (2883)

of data (2866)

pseudo-conversational transactions (2978)

PTIMEOUT parameter (3166)

PUBLIC dbspace (2914)

description (2016)

punctuation mark

in syntax diagrams (1856)

QRYBLKSIZE parameter of exec (3218), (3277)

query

cost estimate (2882)

one-time (2815)

periodic (2817)

programmed (2830)

stored (2819), (2885), (3002)

to test (2994)

user data control (2919)

user identification (3014)

QUERY parameter of exec (3243), (3304)

query/report writing (3145)

database support (2917)

implementation considerations (3012)

query/report writing capability (2813)

querying the status of an application

SQLQRY command (3332)

recoverable storage pool (2029), (2035)

recovery

application design (2652)

application failure (2650)

multiple user mode (2654), (2661)

single user mode (2663)

batch and VSE/ICCF application (2947)

concept (2637)

considerations (2630), (2744)

DBS Utility application (2953)

DBS Utility failure (2689)

dynamic application backout (2646)

filtered log (2701)

ISQL failure (2682)

online application (2668), (2969)

user error (2697), (2704), (2720)

within application program (2714)

referential constraint

description (2151)

referential integrity

activate foreign key (2366)

activate primary key (2365)

CREATE TABLE (2145)

dbspace (1999)

deactivate foreign key (2377)

deactivate primary key (2376)

deferred constraint enforcement (2379)

delete rule (2156)

dependently inactive table (2363)

description (1918)

explicitly inactive key (2356)

explicitly inactive table (2361)

foreign key (1916)

immediate constraint enforcement (2378)

implicitly inactive key (2359)

insert rule (2157)

performance considerations (2380)

planning for (1910)

primary key (1911)

primary key index (2155)

repairing violations (2382)

storage pool (1990), (2033)

unique constraint (1914)

update rule (2160)

referential structure

description (2152)

relationship

many-to-many (1888)

many-to-one (1884)

multivalued (1878)

one-to-many (1883)

one-to-one (1882)

single-valued (1877)

table definition (1879)

REMARKS

column of SYSCATALOG (2271)

remote

access to DB2 Server for VSE & VM (1947)

application server

administration (1967)

connecting implicitly (2557)

definition (1957)

distributed database (1946)

Remote Server Name

resolving to target database (2593)

removing

a user (2452), (2468)

a user from a VSE guest (2470)

table (2392)

user machines (2467)

reorganize

dbspace (2409), (3173)

index, primary key (2370)

indexes on the catalog tables (2421)

repeat symbol

in syntax diagrams (1862)

report writing

capability (2836)

printer support (3137)

through application program (2849)

through ISQL (2838)

through the DBS Utility (2846)

REPRO (VSAM) (2330)

request

SYNCPOINT (2972)

required item

in syntax diagrams (1859)

reserved words

SQL (1867)

RESET parameter of exec (3245), (3306)

resetting

a database (2742)

a dbspace from a backup copy (2730)

data using DBS RELOAD processing (2728)

database (2746)

resource adapter

ARISRMBT module (3249)

bootstrap module (3260)

dropping code (2660), (3319)

for communication (3099)

keeping code (3322), (3323)

RESOURCE authority (2488), (2921)

RESTRICT (1927)

restriction

ACQUIRE DBSPACE (2058)

creating a view (2188)

using a view (2187)

retrieving

catalog information

authorization (2283)

on columns (2273)

on indexes (2276)

on tables (2269)

on views (2279)

comments in catalog tables (2294)

REVOKE (2513), (2533)

REVOKE option

of preprocessor (3083)

revoking

a user's password (2454)

CONNECT authority (2455)

privilege (2458), (2605)

remote user (2514)

ROLLBACK

Batch/ICCF recovery (2946)

hyothetical question support (3087)

work in application programs (2974), (3010)

ROLLBACK WORK (2641), (2713) See also ROLLBACK

routine

ARINEWUS (2438)

editing (2861)

ISQL (2822), (2888), (2928)

ROUTINE table (2820), (2930)

row

overhead (3183)

pointer (3180), (3198)

RUN authority (3080)

SBCS data

subtype (2108)

scale of decimal result (3036)

SCHEDULE authority (2494)

securing the database catalog table (2603)

security

auditing

loading information into a table (2620)

printing information (2628)

through the catalog table (2609)

tracing (2611)

authority (2472), (2481)

batch and VSE/ICCF applications (2944)

database catalog table (2601)

DBS Utility application (2951)

online application (2961)

privilege (2473)

providing (2471)

self-referencing table (1923)

service machine (3095)

SET ERRORMODE (2957)

SET NULL (1929)

SET RUNMODE (2892)

setting up

a new DB2 Server for VSE & VM user (2431) See also new user support

new ISQL user (2437)

setting up a stored procedure server (3158)

sharing, VSE guest (3125)

SHOW DBSPACE (2056), (2426)

size of dbspace, estimating (2024), (3168)

size parameter (2026)

SMALLINT data type of column (2090)

SQL dynamic statement support (2850)

SQLCIREO EXEC (2427)

SQLDBA.ARINEWUS (2439)

SQLDBID EXEC (3314)

SQLDBN file

content (3255)

SQLDBN files

definition of (3251)

updating DCSSID (3256)

used by SQLINIT (3257)

SQLDS protocol (1958)

SQLEND ARCHIVE (2740)

SQLGLOB EXEC (3265)

SQLGLOB Parameters (VSE Only) (3354)

SQLHX (2565)

SQLINIT EXEC (3113), (3121)

default application server (2543)

default database (3108)

description (3201)

parameters (3205)

reasons to reissue (3246), (3263)

resource adapter bootstrap module (3258)

syntax (3204)

SQLQRY command

querying the status of an application (3331)

SQLRMEND (2659)

SQLRMEND EXEC (3317), (3321)

SQLSTART EXEC

accessing SQLDBN file (3254)

description (3252)

SSSNAME parameter of exec (3237), (3298)

STACK parameter of exec (3241), (3302)

statement

ACQUIRE DBSPACE (2053)

ALTER DBSPACE (2408)

ALTER TABLE (2348), (3057)

COMMIT WORK (2640)

CONNECT (2480), (2559), (2966), (3114)

CREATE INDEX (2218)

CREATE TABLE (2061), (2492), (3021)

DBS job control (2803)

DROP DBSPACE (2414)

DROP TABLE (2306), (2391), (3062)

EXPLAIN (2880)

extended dynamic (2835)

GRANT (2504), (2527)

GRANT SCHEDULE (2498)

INCLUDE (2901)

INSERT with subselect (2985), (3066)

REVOKE (2456), (2512), (2532)

ROLLBACK (3086)

ROLLBACK WORK (2639), (2712), (2973), (3009)

SHOW DBSPACE (2055)

WHENEVER (2716)

status shared segment, name (3238), (3299)

storage concept (1978)

storage of ISQL routine (2927)

storage pool

description (1987)

nonrecoverable (2032)

recoverable (2031)

referential integrity (1989), (2034)

reorganizing a dbspace to free pages (2410)

stored procedure

altering (3164)

ARISPRC (3154)

concepts (3151)

dropping (3163)

handler (3153)

managing servers (3159)

parameters affecting execution (3165)

preparing to run (3161)

server (3152)

server groups (3156)

setting up a server (3157)

stored query

deleting (2466)

description (2818)

testing SQL statements (2886)

testing SQL statements using ISQL (2998)

storing information in dbspaces (1993)

STORPOOL (2400) See also storage pool

string data types (2088)

Structured Query Language (SQL)

configuration (3090)

dynamic statement support (2831)

STXIT macroinstructions (2666)

subset mode of CMS (2828)

subtype

BIT (2112)

character (2110)

supporting your users

authorizing access (2443)

loading initial table (2446)

new user support (2430)

removing a user (2451)

specifying a default application server (2444)

training (2448)

switching between application servers (2563)

synchronization point

request in CICS (2671)

SYNCHRONOUS parameter of exec (3211), (3270)

SYNCPOINT See also synchronization point

requests in the CICS subsystem (2971)

synonym

used in application development (2992)

syntax diagram

notation conventions (1852)

SYS0001, reorganizing indexes within (2424)

SYS000n dbspace (2725), (2733)

SYSLANGUAGE table (2754)

system

dbspace considerations for query users (2933)

SYSTEM tables

SYSCATALOG (2296)

SYSCOLAUTH (2285)

SYSCOLUMNS (2274), (2295)

SYSINDEXES (2277)

SYSPROGAUTH (2286)

SYSUSERAUTH (2287), (2288)

SYSVIEWS (2281)

SYSTEXT1 (2761)

SYSTEXT2 (2762)

table

altering (2345), (3055)

backing up (2723)

clustering rows on an index (2245)

copying (2335)

copying data (2333)

creating (1971), (2060)

creator (2161)

customized for specific user (2173)

defining a relationship (1880)

deleting (2388)

dependent (1922)

design

normalizing (2065)

dropping (2387), (3060)

editing (2858)

estimating storage for (3175)

in dbspace (2013)

limiting access to (2174)

loading (2799)

loading data (2313)

location in dbspaces (2000)

maintaining (2311)

maintenance

altering (2303)

copying (2300)

loading data (2299)

merging data (2302)

moving (2301)

referential integrity (2304)

removing (2305)

merging data from multiple tables (2341)

moving (2339)

naming (2064)

normalizing (1941)

owner (2162)

parent (1921)

placement in dbspace (2164)

primary key (1899)

privilege (2521)

removing (2386)

retrieving catalog information (2268)

ROUTINE (2821)

self-referencing (1924)

space-wasting table designs (2071)

storing comments on (2290)

SYSTEXT1 and SYSTEXT2 (2760)

unloading (2800)

terminal

operator id (2582)

printer (3138), (3143), (3149)

used to load data into a database (2321)

termination

CICS transaction (2673)

multiple user mode batch application (2662)

single user mode applications (2664)

terminology for database design (1870)

test data

loading (2874)

testing

application code under VSE/ICCF (2903)

testing SQL functions

SET RUNMODE (2891)

using ISQL (2995)

using ISQL routines (2890)

using stored queries (2887)

using the DBS Utility (2894)

TID (row pointers) (3179), (3197)

TIME data type (2122)

time duration

description (3045)

TIME parameter of exec (3285)

TIMEFORMAT parameter of exec (3226)

TIMESTAMP date type (2123)

timestamp duration

description (3046)

TRACECONV parameter of exec (3236), (3297), (3357)

TRACEDRRM parameter of exec (3234), (3295), (3356)

TRACERA parameter of exec (3230), (3293), (3355)

tracing, CICS and Batch Resource Adapter (3358)

tracing, security audit (2612)

training new ISQL users (2449)

transaction processing (2809), (3133)

transaction program (2811)

truncation

on output (3028)

TSAF (3118)

unique constraint

activating (2367)

considerations in defining (2140)

description (1905), (2137)

implicit (2229)

instead of unique index (2230)

referential integrity (1913)

reorganizing index (2372)

when creating a table (2138)

unique index

creating (2211)

general description (2225)

when to use (2256)

unlike

description (1960)

UPDATE

restriction for view (2191)

update rule

dependent table (1938)

parent table (1937)

UPDATE STATISTICS (2343)

usage environment

application development (2863), (2980), (3139)

batch/interactive (2570), (2788), (2940), (3128)

cics/vse online (2569)

description (3127), (3150)

online transaction processing (2572), (2807), (2959), (3130)

query/report writing (2812), (3011), (3144)

user assistance (2428) See also supporting your users

user error (2698), (2721), (2732)

user ID (3013)

CICS default rules for (2579)

special

CICSUSER (2584)

DBDCCICS (2496)

user identification and verification (2962)

user machine (2434), (2442), (3104)

user privilege (2518)

using indexing in logical data design (2212)

VARCHAR

choosing rather than CHAR (2101)

in column definition (2094)

VARGRAPHIC

choosing rather than GRAPHIC (2103)

varying-length rows (2070)

view

addressing selected columns (2595)

addressing selected rows (2596)

catalog information about (2278)

creating (1973), (2168)

for multiple tables (2178)

materializing (2207)

new column names (2182)

on a single table (2176)

privilege (2522)

reasons for using (2172)

restriction on access (2594)

restrictions on

ALTER (2198)

DBS DATALOAD (2202)

DBS RELOAD (2201)

DBS UNLOAD (2200)

DELETE (2194)

INDEX (2196)

INSERT (2192)

ISQL INPUT (2204)

UPDATE (2190)

storing comments on (2291)

using several tables (2181)

VSAM

file used to load database (2328)

REPRO (2329)

restriction (2416)

VSE batch partition (2794)

VSE guest sharing

configuration (3123)

granting access (2509)

removing access (2469)

revoking access (2516)

VSE/ICCF

application (2796)

application program (2942)

DBS Utility usage (2318)

testing application code (2904)

VSE/POWER (3135), (3142), (3148)

WHENEVER (2717)

WORKUNIT parameter of exec (3228), (3291)

XEDIT, as used with DB2 Server for VM (2859)

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