search cancel

PDT unload job taking longer to run

book

Article ID: 188691

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Detector for DB2 for z/OS

Issue/Introduction

For some reason, a PDT Job that unloads data from Detector Datastore and loads into Db2 PDT Tables is running for very long time and apparently is doing nothing. Not able to find what can be holding the job. This job normally runs at each 4 hours; Any suggestion to resolve this problem? 

 
 
 

Environment

Release : 19.0

Component : CA Detector for DB2 for z/OS

Resolution

Breaking down the interval from 4 hours to 1 hour, resolved UNLOAD/LOAD problem.