search cancel

ZLB0005E TS IS EMPTY, DICTIONARY IS CORRUPT

book

Article ID: 54306

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction

Description:

The following error occurs during extract procedure statistics collection processing. What is wrong?
ZLB0005E: DICTIONARY CORRUPTED BY DB2. TS IS EMPTY. DICTIONARY WILL BE DROPPED.

Solution:

This indicates Database Analyzer detected a dictionary page failed a validation test. To correct this, run a REORG without the KEEPDICTIONARY clause on the tablespace to rebuild the compression dictionary.

Environment

Release:
Component: DBA