IBM DB2 z/OS Extract Abends With OGG-00551 Database Operation Failed Due To SQL Error With SQLSTATE=42803 (Doc ID 3041998.1)

Last updated on AUGUST 19, 2024

Applies to:

Symptoms

DB2 z/OS Extract Abended with below error

ERROR OGG-00551 Database operation failed: Retrieving reorg timestamp for XXX.XXXX using >SELECT MIN(XXXXXX), CREATEDTS, FORMAT FROM XXXX.XXXXXXXX WHERE DBNAME = 'XXXX ' AND TSNAME = 'XXXXX ' AND CREATEDTS < 'NNNN-NN-NN NN:NN:NN.NNNNN' AND ( XXX_XXXX > '0001-01-01-00.00.00.000000' OR FORMAT = 'X' ) FOR READ ONLY <. ODBC error: SQLSTATE 42803 native database error -122. [XXX][CLI Driver][DB2] SQL0122N A SELECT statement with no GROUP BY clause contains a column name or expression and a column function in the SELECT clause, or a column name or expression is contained in the SELECT clause but not in the GROUP BY clause. SQLSTATE=42803.

Changes

 N/A

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.