Data Virtualization automatically restarts at 1PM UTC

An automatically scheduled job is failing and causing Db2 to restart once a day at 1PM UTC.

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)"