A fix is available
APAR status
Closed as program error.
Error description
In V8, CREATE TABLESPACE and CREATE INDEX will preformat up to 2 cylinders of space. This is not necessary for LOAD REPLACE processing since the pageset is opened format-write. This APAR will retrofit V9 function to avoid preformat of format-write pagesets. Regarding additional symptom RC00C90101 DSNITLPE ERQUAL501F: ----------------------------------------------------------- PK70866 is a retrofit from V9 base code for utility format write preformat enhancement. It also includes the code to initialize IHURP in the PNOT control block from the corresponding field in PB0. Without the fix, there is a chance that PB1IHURP will be reset to 0 at the end of the extend when the secondary quantity is really small and reaches the maximum extent number 123 on a single volume.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All v8 DB2 for z/OS users using utilities * * that create or reset underlying data sets. * **************************************************************** * PROBLEM DESCRIPTION: DB2 preformats data sets during * * CREATE TABLESPACE, CREATE INDEX and * * certain utility operations. This * * improves performance for subsequent * * inserts into the data set but is not * * necessary for utility operations that * * will immediately overwrite the data * * set. * * * **************************************************************** * RECOMMENDATION: * **************************************************************** Preformat by DSM is not necessary for utility operations that creates or resets the data set since utility will do its own formatting.
Problem conclusion
DB2 V9 enhanced preformatting so that for utility operations that will overwrite the dataset, a single page is performatted. This enhancement is made available in DB2 V8 with this PTF.
Temporary fix
Comments
APAR Information
APAR number
PK70866
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-20
Closed date
2009-01-06
Last modified date
2009-08-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK42884
Modules/Macros
DSNPIPP DSNPXTN0 DSNPXTN1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R810 PSY UK42884
UP09/01/21 P F901
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 August 2009