My Oracle Support Banner

STATS Command For OGG 12.2 DB2 Gives Returned With An Empty Response Message (Doc ID 2405928.1)

Last updated on MARCH 08, 2019

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 <EXT NAME>

Sending STATS request to EXTRACT <EXT NAME> ...

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

 

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

Ex:

STATS EXTRACT <EXT NAME> - Warning is Returned
STATS EXTRACT <EXT NAME> DAILY - Output is Fine
STATS EXTRACT <EXT NAME> HOURLY - Output is Fine
STATS EXTRACT <EXT NAME> - Warning is Returned
STATS EXTRACT <EXT NAME> TABLE <SCHEMA.TABLE NAME> - 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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