DB2v10.1 for ZOS. THE MAXIMUM EXTENTS IS 251. RC=00D70014

Oleg Dayneko

DB2v10.1 for ZOS. THE MAXIMUM EXTENTS IS 251. RC=00D70014

Hi! I meet the following error in SYSLOG:

...

DSNP011I - DSNPXTN0 - MEDIA MANAGER SERVICES ERROR 053
FOR
SAPE.DSNDBC.DSN06832.FBICFAZU.J0001.A001
MMRC=8 DSMRC=00D70014
CONNECTION-ID=SERVER, CORRELATION-ID=B04BTC052

...

I alter implicity table space from DSSIZE 64 G to 16 then start reorg.  In this case instead of 1 old vsam dataset created 3 datasets with smaller space. The trouble successful complete. 

The problem don't happen again if, when creating a new table space, set the default DSSIZE = 16. But where set this param?  In ZPARM? 

Attachments

  • Capture.PNG (36.5k)

kapil mathur

RE: DB2v10.1 for ZOS. THE MAXIMUM EXTENTS IS 251. RC=00D70014
(in response to Oleg Dayneko)

For implicitly created TS:-
see ZPARM IMPDSSIZE 

For explicitly created TS :-
The default DSSIZE value depends on the NUMPARTS value and the buffer pool page size.

See CREATE TABLESPACE syntax in IBM DB2 SQL reference for details

Oleg Dayneko

RE: DB2v10.1 for ZOS. THE MAXIMUM EXTENTS IS 251. RC=00D70014
(in response to kapil mathur)

I correct IMPDSSIZE from 64 to 16 in ZPARM. I hope that this mistake will not happen again.

Thank you very much for your help!