SQLCODE = -20016 ERROR when creating ACM tables for Database Management Solutions
search cancel

SQLCODE = -20016 ERROR when creating ACM tables for Database Management Solutions

book

Article ID: 13319

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

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

Resolution

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)