SQLCODE = -20016, ERROR when creating ACM tables

Document ID : KB000013319
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

I am using line command 'M' (MAKETAB) from the 'Alternate Catalog Mapping' panel  to generate DDL for the shadow tables.

However, during execution the job fails with  SQL-20016 on e.g. SYSIBM.SYSPACKSTMT

 

DSNT408I SQLCODE = -20016, ERROR: THE VALUE OF THE INLINE LENGTH 

ASSOCIATED WITH TABLE IS TOO BIG OR THE INLINE LENGTH CLAUSE 

IS NOT ALLOWED IN THE CONTEXT 

Answer:

This can happen if reordered row format (RRF) is disabled in DSNZPARM.

Additional Information:

You can check the settings of Reordered row format in DSNZPARM from 'Thread Term/Dynam DSNZPARM'

- Select option TT - Thread Term/Dynam DSNZPARM 

- Select option VZ - View DSNZPARM Data  

- Look for keyword 'RRF' and check the value (ENABLE/DISABLE)