Data Virtualization jobs that start at 1PM UTC fail

Data Virtualization jobs that start at 1PM UTC fail because the Db2database restarts at that time in the Data Virtualization head pod.

Symptoms

Data Virtualization virtualization jobs that run at 1PM UTC fail.

Diagnosing the problem

Run the following command to log in to the Data Virtualization head pod:
```
oc -n ${PROJECT_CPD_INSTANCE} rsh c-db2u-dv-db2u-0 bash
```
Run the following command to switch to the db2inst1 user:
```
su - db2inst1
```
Run the following command to connect to the database:
```
db2 connect to bigsql
```

Run the following command to confirm if there is a DIAGPATH_CLEANUP stored procedure enabled as a DB2 ATS job and is scheduled to run daily at 1PM:

db2 "select varchar(name,30)name,BEGIN_TIME,END_TIME,MAX_INVOCATIONS,varchar(SCHEDULE,20)
SCHEDULE,varchar(PROCEDURE_NAME,40) PROCEDURE_NAME from systools.ADMIN_TASK_LIST with ur" | grep -i DIAGPATH_CLEANUP

If this command returns a row with - 0 13 * * * in it, similar to the following example, proceed to complete the steps to resolve the problem:

[db2inst1@c-db2u-dv-db2u-0 - Db2U ~]$  db2 "select varchar(name,30) name,BEGIN_TIME,END_TIME,MAX_INVOCATIONS,varchar(SCHEDULE,20) SCHEDULE,varchar(PROCEDURE_NAME,40) PROCEDURE_NAME from systools.ADMIN_TASK_LIST with ur" | grep -i cleanu
DIAGPATH_CLEANUP               2025-04-02-19.56.41.235521 -                                        - 0 13 * * *            diagpathCleanup

Resolving the problem

Complete the following steps for each Data Virtualization instance:

Run the following command to log in to the Data Virtualization head pod:
```
oc -n ${PROJECT_CPD_INSTANCE} rsh c-db2u-dv-db2u-0 bash
```
Run the following command to switch to the db2inst1 user:
```
su - db2inst1
```
Run the following command to connect to the database:
```
db2 connect to bigsql
```

Run the following command:

db2 -v "CALL SYSPROC.ADMIN_TASK_UPDATE('DIAGPATH_CLEANUP',null,null,0,'0 13 * * *',null,null)"

Run the following command to remove the ATS job:

db2 -v "call SYSPROC.ADMIN_TASK_REMOVE('DIAGPATH_CLEANUP',NULL)"