How to spool output in Goldengate

We were just trying to get ready for patching and one task is going to be noting down the SCN after we stop the extracts. So, that made me to think about saving this information in some automated way so that we don’t make mistake when making a note of SCN. Here are two examples on how to save output from GG commands:

Here are two quick examples about how this script works:

Example #1: using commands only. Without Obey

./ggsci <<EOF >> $LOGDIR/gg_ext_scn_status.log info E* send *,status exit EOF

Example #2: Using obey​

./ggsci <<EOF >> $LOGDIR/gg_ext_scn_status.log obey $SCRIPTDIR/gg_ext_scn_status.oby exit EOF​