Updates to DSNZPARM PREVENT_NEW_IXCTRL_PART not reflected in Thread Terminator

Products

• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• 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
• Batch Processor
• Thread Terminator for DB2 for z/OS

Issue/Introduction

Batch Processor job failing for CREATE INDEX with following error messages.

DSNT408I SQLCODE = -876, ERROR:  INDEX CANNOT BE CREATED OR ALTERED, REASON 6.

BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED. RETCODE =     8

Tried to change the DSNZPARM  PREVENT_NEW_IXCTRL_PART=NO, DSNTIJUZ job completed successfully but the change does not reflect on Thread Terminator (PTT).

Cause

After specifying PREVENT_NEW_IXCTRL_PART=NO and executing DSNTIJUZ,  -SET SYSPARM RELOAD command to reload the DSNZPARM module is required.

Resolution

Change DSNZPARM PREVENT_NEW_IXCTRL_PART=NO followed by following reload command to reload the DSNZPARM module

-SET SYSPARM RELOAD