PI46910: DDL STORAGE MANAGEMENT OPTIMIZATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Improve internal storage consumption to allow more DDL
  statements to be processed
  

Local fix

• Limit the number of DDL statements to no more than 40 per
  commit.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IMS V14 users who define databases through Data Definition   *
  * Language (DDL)                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND878 occurs when submitting DDL CREATE statements with   *
  * more than approximately 40 COMMIT DDL statements. Many other *
  * symptoms of insufficient storage are possible.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * INSTALL CORRECTIVE SERVICE FOR APAR/PTF.                     *
  ****************************************************************
  A separate online ACBGEN was done for the DDL CREATE statements
  preceding each COMMIT DDL statements. For each such ACBGEN the
  bootstrap data set was opened, used to find the directory
  staging data set, and closed. Closing the data set failed to
  free the storage for the buffer pools needed for QSAM access,
  and this storage eventually overwhelmed the DLI address space.
  

Problem conclusion

• In the BSCLOSE routine of DFS3DDSM a FREEPOOL macro instruction
  was added to free the buffer pool.
  
  Other changes include:
  DFSDDL10 was changed to not calculate the database data set
  block size if the SIZE PRIMARY clause was provided on the CREATE
  TABLESPACE statement for a HDAM or HIDAM database.  It was also
  changed to recognize that if the LCHILD clause on the CREATE
  TABLE statement does not provide the name of a database, then it
  is implied that the database in which the table resides in is
  the name it should use.
  
  DFSDDL20 was changed to set the database name from the LCHILD
  clause only if it was provided.
  
  DFSDDL40 was changed to set the correct PCB name and external
  name from the CREATE PROGRAMVIEW statement.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI33093

Modules/Macros

• DFS3ACBG DFS3ACBM DFS3ACMD DFS3RLM  DFS3DL10 DFS3DL60 DFS3DSSM
  DFSDSSM0 DQFDHNOD DFSDDL10 DFSDDL20 DFSDDL40
  

Fix information

• Fixed component name

  IMS V14

• Fixed component ID

  5635A0500

Applicable component levels

• R400 PSY UI33093

     UP15/12/02 P F511

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.