STATS Command For OGG 12.2 DB2 Gives Returned With An Empty Response Message

(Doc ID 2405928.1)

Last updated on JUNE 07, 2018

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

When we execute stats command in OGG 12.2 version, no output is reported and it gives Warning OGG-01742

GGSCI (CPUI) 1> stats extract e2a01

Sending STATS request to EXTRACT E2A01 ...

2017-11-20 13:15:46 WARNING OGG-01742 Command sent to EXTRACT E2A01 returned with an empty response.

 

Warning could be seen for some of below stats command and not all.

Ex:

STATS EXTRACT E2A01 - Warning is Returned
STATS EXTRACT E2A01 DAILY - Output is Fine
STATS EXTRACT E2A01 HOURLY - Output is Fine
STATS EXTRACT E2A01 - Warning is Returned
STATS EXTRACT E2A01 TABLE IRDB20.IRAPVSMD - Output is Fine

 

Also, In Previous Version of OGG the output for Stats command would have returned Incomplete Results with message Results Truncated at End of output.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms