Can not perform the #3 DB2 Catalog Customization Tasks - Job ***0001 fails -666
search cancel

Can not perform the #3 DB2 Catalog Customization Tasks - Job ***0001 fails -666

book

Article ID: 135375

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

Upgrading the CA-DB2Tools to R19.

 Running the option #3 Tasks for one of the subsystems fails  with a -666  

 

 ALTER INDEX PTI.PTGL700_RESTART_X1

   BUFFERPOOL BP0;

 DSNT408I SQLCODE = -666, ERROR:  ALTER INDEX CANNOT BE EXECUTED BECAUSE

         

       

 

 

Environment

Release :

Component : CA Insight Database Performance Monitor for DB for z/OS

Cause

The PTDB database structures were in a UTRW status. 

Resolution

The PTDB database structures were in a UTRW status. 

Changed status to RW resolved the problem.