Handling the Dreaded 00D70014 Abend in a Pinch

Quikfix for Datasets in 119 Extents

You can save the hassle of altering PRIQTY and SECQTY and doing a reorg for a convenient

time since our DB2 data is managed by SMS.

  1. Stop your tablespace/indexspace

    2. From TSO command line

    enter <TSO DB2 subystem_name>

    enter <-STOP DB(database_name) SPACENAM(tablespace/indexspace name)>

  2. Bring up the problem cluster dataset name in ISPF 3.4

    3. dataset names are in the format:

    dataset_high_level.DSNDBC.database_name.table/index spacename.I0001.A001

    ex. V9747.DSNDBC.DCO88001.SCO88001.I0001.A001

  3. Enter <HBACKDS> in the line command beside your problem dataset

    4. this will backup your dataset to HSM

  4. Enter <HMIGRATE> in the line command beside your problem dataset

    5. this will migrate your dataset to HSM

  5. Once it has migrated (you may need to exit 3.4 and come back in to tell if its been migrated)

    6. enter <HRECALL> in the line command beside your problem dataset

    This return your dataset to 1 or fewer extents

  6. Start your tablespace/indexspace

From TSO command line

enter <TSO DB2 subsystem name>

enter <-START DB(database_name) SPACENAM(tablespace/indexspace name)>

Note: You WILL need to alter the PRIQTY and SECQTY and reorg at a later time.

If you don't, your next reorg may fail with 119 extents.