db2pdcfg -flushbp

db2pd -db  mydb  -dirtypages summary | awk -v RS='\n\n' '{if ($0 ~ /pages %/) print $0;}'

set -x;

SnapshotSuffix=$1;

suspend_db()
{
        Name=$1;
        Sleep=$2;

        echo "===== Suspending database $Name";
        db2 terminate;
        db2 connect to $Name;
        db2pdcfg -flushbp; sleep $Sleep"s";

#       db2 flush bufferpools all;

        db2 set write suspend for database;
        Result=$?;

        db2pdcfg -flushbp q;
#       db2 disconnect $Name;
        echo;

        return $Result;
}

resume_db()
{
        Name=$1;
                                                                                                                                                                                                                                            
        echo "===== Resuming database $Name";                                                                                                                                                                                               
                                                                                                                                                                                                                                            
        db2 terminate;                                                                                                                                                                                                                      
        db2 connect to $Name;                                                                                                                                                                                                               
                                                                                                                                                                                                                                            
        db2 set write resume for database;                                                                                                                                                                                                  
        Result=$?;                                                                                                                                                                                                                          
                                                                                                                                                                                                                                            
#       db2 disconnect $Name;                                                                                                                                                                                                               
        echo;                                                                                                                                                                                                                               
                                                                                                                                                                                                                                            
        return $Result;                                                                                                                                                                                                                     
}                                                                                                                                                                                                                                           
                                                                                                                                                                                                                                            
zfs_snapshot()                                                                                                                                                                                                                              
{                                                                                                                                                                                                                                           
        FullSnapName=$1;                                                                                                                                                                                                                    
                                                                                                                                                                                                                                            
        timeout 30s ssh z1 "/xxx/create_snapshot2.sh $FullSnapName";                                                                                                                                                             
        Result=$?;                                                                                                                                                                                                                          
                                                                                                                                                                                                                                            
        return $Result;
}


db2 archive log for db Base3;
db2 archive log for db Base2;
db2 archive log for db Base1;

if (suspend_db Base1 5) && (suspend_db Base2 1) && (suspend_db Base3 2); then
{
        SuspendResult="safe_suspended";
} 
else
{
        SuspendResult="___WARNING_UNSAFE___NOT_suspended___";
} fi;

/xxx/flush.sh;

SnapName=$(date +\%Y_\%m_\%d__\%H_\%M_\%S)_$SuspendResult"_$SnapshotSuffix";

zfs_snapshot "nvram/xxx-temp@$SnapName";
SnapshotResult1=$?;

zfs_snapshot "data/xxx-database2@$SnapName";
SnapshotResult2=$?;

SnapshotResult3=0;


resume_db Base3;
resume_db Base2;
resume_db Base1;

timeout 5m /utils/backup/xxx_log.sh;
timeout 30s ssh backup2 "/xxx/create_snapshot.sh data/backup/xxx-log $SnapName; sync";

echo `date` >> /download/snapshot_log.txt;

if [ $SnapshotResult1 == 0 ] && [ $SnapshotResult2 == 0 ] && [ $SnapshotResult3 == 0 ]; then
{
        if [ "$SuspendResult" == "safe_suspended" ]; then
        {
                echo "============ SUCCESSFUL SUSPEND & SNAPSHOT.";
                exit 0;
        }
        else
        {
                echo "============ ERROR: BAD SUSPEND! but a SNAPSHOT CREATED ...";
                exit 1;
        } fi;
}
else
{
        echo "============== ERROR: COULD NOT CREATE SNAPSHOTS! SUSPEND STATUS was: $SuspendResult";
        exit 2;
} fi;

exit 3; # shall not reach here!