Nun auch APPEND Modus fÃ¼r DB2 for OS/390
5. Juli 2004 um 19:40 #2416Teilnehmer
Wichtige News: (Quelle: IBM)
.GS TAG OFF
++ HOLD(UQ86868) SYS FMID(HDB7710) REASON(ACTION) DATE(04091)
Â Â (New support is being implemented to provide the ability to [glb][/glb]
Â Â Insert-At-End without exhaustive search for tablespaces defined
Â Â as MEMBER CLUSTER. To invoke this behavior, specify PCTFREE=0
Â Â and FREEPAGE=0 for CREATE or ALTER TABLESPACE DDL.).
.GS TAG ON
[glb]APAR PQ86037 status [/glb]
Closed as program error.
Insert performance suffers on a member cluster pageset when anexhaustive search for space is driven prior to extending thepageset.
USERS AFFECTED: Users of MEMBER CLUSTER tablespaces. Â Â Â Â
PROBLEM DESCRIPTION: Insert preformance suffers if the need to extend a tablespace is detected for a MEMBER CLUSTER tablespace. Â Â Â Â Â Â
RECOMMENDATION: Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
A exhaustive search from the beginning of the tablespace is performed prior to issuing an extend request. This exhaustive search could require reading of thousands of space map pages before space is found for the insert. A method is needed to specify that the exhaustive search is to be bypassed, and an Insert-at-End action is to be taken.
Code is changed to allow the Insert-at-End action te be triggered by specifying PCTFREE=0 and FREEPAGE=0 on the definition of a MEMEBER CLUSTER tablespace. Current tablespacescan achieve this action by ALTER TABLESPACE to change the twoparameters.
APAR number PQ86037
Reported component name 5740 IBM DATABA
Reported component ID 5740XYR00
Reported release 710
Status CLOSED PER
Submitted date 2004-03-12
Closed date 2004-03-31
Last modified date 2004-05-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
DSNISMPI Â Â Â Â Â
Fixed component name 5740 IBM DATABA
Fixed component ID 5740XYR00
Applicable component levels
R710 PSY UQ86868 Â Â UP04/04/16 P F404
You must be logged in to reply to this topic.