SUBJECT: APAR NUMBER: PK26312
REFERENCE: AREA: TPFDF CENTRAL DATABASE ROUTINES
SEGMENT: C$CRUDEF13 - RELEASE: TPFDF (C-Header)
SEGMENT: C$IRAIDF13 - RELEASE: TPFDF (C-Header)
SEGMENT: C$IRCHDF13 - RELEASE: TPFDF (C-Header)
SEGMENT: C$SW02SR13 - RELEASE: TPFDF (C-Header)
SEGMENT: C_IRAIDF13 - RELEASE: TPFDF (C-Header)
SEGMENT: DBCLS13 - RELEASE: TPFDF (Macro)
SEGMENT: DBDEF13 - RELEASE: TPFDF (Macro)
SEGMENT: DB15513 - RELEASE: TPFDF (Macro)
SEGMENT: IRAIDF13 - RELEASE: TPFDF (Dsect)
SEGMENT: IRCHDF13 - RELEASE: TPFDF (Dsect)
SEGMENT: SW00SR13 - RELEASE: TPFDF (Macro)
SEGMENT: SW02SR13 - RELEASE: TPFDF (Macro)
SEGMENT: UFA013 - RELEASE: TPFDF (Assembler)
SEGMENT: UFBG13 - RELEASE: TPFDF (Assembler)
SEGMENT: UFBM13 - RELEASE: TPFDF (Assembler)
SEGMENT: UFBW13 - RELEASE: TPFDF (Assembler)
SEGMENT: UFB313 - RELEASE: TPFDF (Assembler)
SEGMENT: UFB713 - RELEASE: TPFDF (Assembler)
SEGMENT: UFCN13 - RELEASE: TPFDF (Assembler)
SEGMENT: UFCP13 - RELEASE: TPFDF (Assembler)
SEGMENT: UFC913 - RELEASE: TPFDF (Assembler)
SEGMENT: UFHBG113 - RELEASE: TPFDF (C++)
SEGMENT: UFHB0413 - RELEASE: TPFDF (C++)
SEGMENT: UFHB0613 - RELEASE: TPFDF (C++)
SEGMENT: UFHOG213 - RELEASE: TPFDF (C++)
SEGMENT: UFI513 - RELEASE: TPFDF (Assembler)
SEGMENT: UWAH13 - RELEASE: TPFDF (Assembler)
SEGMENT: UWAJ13 - RELEASE: TPFDF (Assembler)
SEGMENT: UWA113 - RELEASE: TPFDF (Assembler)
SEGMENT: UWBC13 - RELEASE: TPFDF (Assembler)
SEGMENT: UWBO13 - RELEASE: TPFDF (Assembler)
SEGMENT: UWBQ13 - RELEASE: TPFDF (Assembler)
Pre-requisite APARs are (TPF only) :
FOR SEGMENT C$CRUDEF13 (C-Header) - REL TPFDF
PQ23489 PQ23871 PQ36341 PQ39571 PQ50941 PQ56744 PQ51955
PQ71548 PQ86693 PK14527 PK18532 PK24228
FOR SEGMENT C$IRCHDF13 (C-Header) - REL TPFDF
PQ23489 PQ23871 PQ36341 PQ41433 PQ51955 PQ74483 PQ86693
PK00917 PK24228
FOR SEGMENT C$SW02SR13 (C-Header) - REL TPFDF
PN84757 PQ08645 PQ23091 PQ42097 PQ94935
FOR SEGMENT DBCLS13 (Macro) - REL TPFDF
PQ32209
FOR SEGMENT DBDEF13 (Macro) - REL TPFDF
PN05393 PN35104 PN38092 PN45919 PN53446 PN57526 PN61834
PN62563 PN64313 PN71161 PN73989 PN78104 PN78908 PN87893
PN88662 PQ10797 PQ10084 PQ18690 PQ23091 PQ32209 PQ37827
PQ42097 PQ32210 PQ56724 PQ66921 PQ51955 PQ81077 PQ82656
PQ94935 PQ95818 PQ80726 PK09343 PK03317
FOR SEGMENT DB15513 (Macro) - REL TPFDF
PN83423 PQ13787 PQ32210 PQ74483 PQ75887 PQ80141 PQ88509
PK10077
FOR SEGMENT IRCHDF13 (Dsect) - REL TPFDF
PQ23489 PQ23871 PQ36341 PQ41433 PQ74483 PQ86693 PK00917
FOR SEGMENT SW00SR13 (Macro) - REL TPFDF
AN31299 PN05393 PN37569 PN38613 PN43714 PN46560 PN57526
PN61834 PN64313 PN71161 PN71348 PN73989 PN77016 PN76852
PN80488 PN83423 PN84757 PN87917 PN92097 PQ00790 PQ02145
PQ04911 PQ05189 PQ07995 PQ10797
PQ10084 PQ15475 PQ16897
PQ21506 PQ24625 PQ23091 PQ25824
PQ25825 PQ32209 PQ36911
PQ37963 PQ32210 PQ50275 PQ48551 PQ55601 PQ64252 PQ51955
PQ74483 PQ75887 PQ79066 PQ80141 PQ90430 PQ94935 PQ95818
PQ96246 PK02541 PK03608 PK06268 PK03317 PK20320 PQ59198
PK18246 PK16322
FOR SEGMENT SW02SR13 (Macro) - REL TPFDF
PN05393 PN39344 PN49536 PN57526 PN61834 PN64313 PN67252
PN71161 PN73989 PN78104 PN78908 PN92097 PQ05189 PQ10797
PQ10084 PQ23091 PQ26888 PQ32209
PQ42097 PQ32210 PQ74483
PQ94935 PK02541 PK03317
FOR SEGMENT UFA013 (Assembler) - REL TPFDF
PN05393 PN61834 PN62258 PN64313 PN73989 PN81188 PQ00977
PQ23091 PQ94935
FOR SEGMENT UFBG13 (Assembler) - REL TPFDF
PN05393 PN19872 PQ00810 PQ51955 PQ80075
FOR SEGMENT UFBM13 (Assembler) - REL TPFDF
PN42312 PN73989 PN75827 PN91649 PQ02170 PQ04563 PQ08743
PQ30389 PQ32209 PQ51955 PQ74483 PQ75887 PQ97721 PK03442
PK20320 PK15589 PK17083
FOR SEGMENT UFBW13 (Assembler) - REL TPFDF
PN73989 PN76765 PQ08078 PQ23091 PQ51339 PQ94935 PK02541
PK03317
FOR SEGMENT UFB313 (Assembler) - REL TPFDF
PN62258 PN64313 PN67252 PN92851 PQ00977 PQ04563 PQ34175
PQ32210 PQ46459 PQ51955 PQ74483 PK20320
FOR SEGMENT UFB713 (Assembler) - REL TPFDF
PN42312 PN57993 PN78904 PN83376 PN92851 PQ00810 PQ02090
PQ04563 PQ07900 PQ30389 PQ51955 PQ74483 PQ97721
FOR SEGMENT UFCN13 (Assembler) - REL TPFDF
PQ94935 PK03317
FOR SEGMENT UFC913 (Assembler) - REL TPFDF
PK10080
FOR SEGMENT UFHBG113 (C++) - REL TPFDF
PQ23871 PQ36341 PQ39571 PQ50941 PQ61673 PQ51955 PQ71548
PQ80141 PQ86693 PK14527
FOR SEGMENT UFHB0413 (C++) - REL TPFDF
PQ23489 PQ23871 PQ36341 PQ74483 PK18532
FOR SEGMENT UFHB0613 (C++) - REL TPFDF
PQ23489 PQ23871 PQ36341 PQ50941 PQ61671 PQ61673 PQ74483
PK02065 PK18132 PK24228
FOR SEGMENT UFHOG213 (C++) - REL TPFDF
PQ23871 PQ39571 PQ61673 PQ74483
FOR SEGMENT UFI513 (Assembler) - REL TPFDF
PQ23489 PQ23871 PQ33410 PQ36341 PQ53168 PQ65645 PQ51955
PQ74483 PQ75887 PQ78273 PQ82818 PQ81044 PQ90430 PQ86693
PQ94935 PQ96246 PK00917 PK14527
FOR SEGMENT UWAH13 (Assembler) - REL TPFDF
PQ32210 PQ51955 PQ90430 PQ94935 PQ96246 PK01432
FOR SEGMENT UWAJ13 (Assembler) - REL TPFDF
PQ32210 PQ51955 PQ74483 PQ90430 PQ94935 PQ96246 PK01432
FOR SEGMENT UWA113 (Assembler) - REL TPFDF
PQ32210 PQ94935 PQ95747
FOR SEGMENT UWBC13 (Assembler) - REL TPFDF
PQ32210 PQ48582 PQ48551 PQ51339 PQ53452 PQ61711 PQ51955
PQ74483 PQ75887 PQ80141 PQ94935 PQ90239 PQ91310 PK01852
PK03608 PQ59198 PK18246 PK17872
FOR SEGMENT UWBO13 (Assembler) - REL TPFDF
PQ46459 PQ96246 PK03317 PK13562 PK20320 PK24989
FOR SEGMENT UWBQ13 (Assembler) - REL TPFDF
1
PQ46459
To be applied in the order listed for each segment.
ABSTRACT OF PROBLEM
___________________
TPFDF applications have to track a database's indexes and algo-
rithm information to perform de-indexing. This can be cumber-
some. Also, a more readable method for setting DBDEF option
bits can be provided.
COMMENTS ON PROBLEM
___________________
o Today, TPFDF applications using basic indexing need to be
aware of a database's indexes and corresponding algorithm
information to perform de-indexing. Whenever a data subfile
becomes empty and is no longer needed, applications need to
explicitly de-index the subfile on all index paths and
request that the pool addresses be released. Functionality
should be provided to allow databases to be automatically
de-indexed and released when a subfile becomes empty.
o Also, the OP1=, OP2= and OP3= DBDEF parameters do not easily
convey what functionality is being controlled with the
option bit settings. It is also difficult to scan source
code for specific bit settings. New keyword parameters
should be made available to override the OP1=, OP2=, and
OP3= parameters.
SOLUTION
________
o APAR PK26312 introduces automatic (auto) de-indexing. Auto
de-indexing is an enhancement to basic indexing. With auto
de-indexing, the TPFDF product can automatically remove
(de-index) references in index files to empty or released
subfiles in a database, eliminating the need for applica-
tions to track algorithm information that was used when the
indexes were created. This is accomplished by storing index
information in an algorithm information file when indexes
are created. New auto de-indexing DBDEF parameters have
been introduced: AUTODEINDEX=, ALGINFOID= and ALGINFOFOR=.
During DBDEF table initialization (during restart or with
the ZUDFM DEF INIT command) a check has been added to ensure
that these parameters are used correctly. If an inconsist-
ency is detected, a message will be issued indicating what
the inconsistency is. CRUISE will also issue a message if
it detects that a detail file with an associated algorithm
information file has been captured, but an algorithm infor-
mation file was not captured.
o Also introduced are new DBDEF override parameters. Each OPx
bit setting now has a readable corresponding override param-
eter. For example, currently if you wanted to enable B+Tree
indexing using the DBDEF OPx= parameters, you would have to
code OP3=00000100. With APAR PK26312, instead of coding the
OP3= parameter, you can simply code BTREE=YES on the DBDEF.
DEPENDENCIES
____________
Related Segments Affected By This APAR.
_______________________________________
Segments to be assembled or compiled:
N/A
Segments to be link edited:
TPF only - UFHB, UFHD, UFHE, UFHF, UFHG, UFHM, UFHN and UFHO
ALCS only - TPFDFH3
Load Modules to be loaded:
Migration Considerations
========================
- The following CRUISE message has been introduced: FCRU0161W
- The following messages may occur during DBDEF table initialization
(initiated by either ZUDFM DEF INIT or TPF restart)
during the auto de-indexing DBDEF parameter consistency check:
UDFM0356W, UDFM0357W, UDFM0358W, UDFM0359I, UDFM0360I, and
UDFM0361I.
New Parameters:
- Auto de-indexing DBDEF parameters: ALGINFOFOR=, ALGINFOID=, and
AUTODEINDEX=.
- DBDEF override parameters: ADDCURR, BTREE, CHAINCOR, CHAINHLD,
CKPUKY, DBUKY, DB010C, DETAC, FIRSTCH, FIXINDEX, FULLBCH, INDEXCKP,
MOREPACK, NABVAL, PACKNEW, PRIMEHLD, PUSHDOWN, RSTNEW, SEQUPDT, TLDNEW,
and XTDLREC
See the TPFDF documentation for more information about automatic
de-indexing and the new DBDEF parameters.
-- END APAR PK26312
Click on Link(s) to Download File(s)
Download file(s):
Login once to access server, leave window open, then
click on link(s) below.
|
