A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E70005 AT DSNXIATS P168 OCCURRED FOR AN ALTER TABLESPACE OF AN INDEX-CONTROLLED PARTITIONING TABLE SPACE CREATED PRIOR TO V8. LOAD REPLACE or RESUME of PBG running at M500 or higher that needs an additional partition for a table created pre-M500 can fail with a S04E REASON=X'00E40347' CAUSE=X'00E40405' and DSNT500I DSNUGRAR RESOURCE UNAVAILABLE REASON 00000072 TYPE 00000000 LOCAL FIX: For the LOAD failure, ALTER TS PRIQTY nnnn (same PRIQTY as initial PRIQTY) or ALTER TABLE xxxxxx.xxxxxxx ADD PARTITION. Only needs to be run once if the problem is encountered. Doesn't need to be rerun even if additional partitions are needed for subsequent LOADs.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Db2 12 for z/OS users of ALTER TABLESPACE * * BUFFERPOOL and LOAD utility who have * * applied PI86123/UI53246. * **************************************************************** * PROBLEM DESCRIPTION: * * Users might receive an ABEND04E * * RC00E70005 at DSNXIATS P168 on ALTER * * TABLESPACE with BUFFERPOOL option. * * * * LOAD REPLACE or RESUME of partition-by * * -growth table space running at * * function level 500 or higher might * * fail with a S04E RC00E40347 * * CAUSE=X'00E40405' and DSNT500I. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Users might receive an ABEND04E RC00E70005 on ALTER TABLESPACE with the BUFFERPOOL option on an index-controlled partitioning table space created prior to V8. The same abend might also occur with other options of ALTER TABLESPACE statement. LOAD REPLACE or RESUME of partition-by-growth table spaces running at function level 500 or higher that needs an additional partition for a table created prior to function level 500 might fail with a S04E RC00E40347 CAUSE=X'00E40405' and DSNT500I DSNUGRAR RESOURCE UNAVAILABLE REASON 00000072 TYPE 00000000. The same issue might occur on INSERT with concurrent Utility on the same table space or REORG that does not materialize pending definition changes. This APAR also handles an existing issue on ALTER TABLESPACE with ERASE option of work file table space, where users get ABEND0C4 RC00000010 or RC00000038 in DSNGDADP. This existing issue is exposed when Db2, via PI86123/UI53246, populates the missing values of table space's new attributes (including SYSTABLESPACE.ERASERULE) to a migrated work file table space. In this case, users get o ABEND0C4 RC00000010 or RC00000038 in DSNGDADP on ALTER TABLESPACE of work file table space with allowed options. o ABEND04E RC00C90101 in DSNGD001.DSNGDADP ERQUAL500A when growing a new part of work file table space.
Problem conclusion
Db2 has been modified to avoid the following: o ABEND04E RC00E70005 at DSNXIATS P168 on ALTER TABLESPACE statement of an index-controlled partitioning table space created prior to V8. o S04E RC00E40347 CAUSE=X'00E40405' with LOAD REPLACE or RESUME, or INSERT, or REORG without pending change materialization in function level 500 (or higher) when a partition is grown in a partition-by-growth table space created prior to function level 500. o ABEND04E RC00C90101 in DSNGD001.DSNGDADP ERQUAL500A when growing a new part of a migrated work file table space. o ABEND0C4 RC00000010 or RC00000038 in DSNGDADP on ALTER TABLESPACE of - a work file table space with ERASE option. - a migrated work file table space with allowed options. Additional keywords: SQLALTER RC00E70005 RC00C90101 RC00000010 RC00000038 RC00E40347 RC00E40405 DSNGDADP ERQUAL500A MSGDSNT500I
Temporary fix
Comments
APAR Information
APAR number
PI96853
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-17
Closed date
2018-07-16
Last modified date
2018-09-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI56192
Modules/Macros
DSNXIPG2 DSNGDAII DSNXISB6 DSNXIATS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI56192
UP18/08/02 P F808 {
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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 September 2018