DB2 reorg fails after restoring database on Infoscale 8.0

book

Article ID: 100060996

calendar_today

Updated On:

Description

Error Message

SQL1034C The database is damaged. All applications processing the database have been stopped. SQLSTATE=58031

Cause

vx_parallel_dio is a Veritas FileSystem (VxFS) kernel module parameter to enable the Parallel Direct I/O.  Parallel Direct I/O is a VxFS feature which can improve the performance of Direct I/O with some specific I/O workloads. Under normal circumstances, vx_parallel_dio will not improve performance significantly and is not required.

This feature is disabled by default in previous Infoscale releases on or below 7.4.2 and is enabled by default from Infoscale 8.0 onward.

Resolution

Disable VxFS Parallel Direct IO feature.

NOTE: The below procedure requires downtime as it requires reboot of the node

1) Disable Parallel DIO.

#vi /etc/modprobe.d/local.conf

options vxfs vx_parallel_dio=0

2) Reboot the system.

3) Check the feature status.

#cat /sys/module/vxfs/parameters/vx_parallel_dio

0

4) Perform Database restore and reorg

Issue/Introduction

DB2 reorg reports errors after restoring the database on Infoscale 8.0 from the lower version of Infoscale.

Additional Information

JIRA: STESC-8395