Thursday, November 13, 2008

Job seems not executing for longer period of time

Sometimes after submitting the database refresh job, you find that, this job is not getting CPU and idle for many times..

One of the reason may be.. the underlying VSAM datasets of the target tablespaces/indexspaces are migrated due to not being accessed for long time. DB2 will try to HRECALL the required datasets. In the same time you can recall the datasets so that your job will have the datasets and move forward.

IBM Certified DB2 DBA

No comments: