SAP DBTech JDBC: [2]: general error: Shrink canceled, probably because of snapshot pages

[former_member100438]

Monthly we execute this command in order to Shrink the memory used and normally it works, from 800GB goes to 350GB.

ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT;

Erros Message: Could not execute 'ALTER SYSTEM RECLAIM DATAVOLUME 120 DEFRAGMENT' in 8 ms 73 µs .

SAP DBTech JDBC: [2]: general error: Shrink canceled, probably because of snapshot pages

Once I got the same message and after a complete stop/stat I could run this command and Shrink the memory.

This time did not work at all,

Any one has a comment or already know the solution?

Marcelo Ramos

BasisGBS@br.ibm.com

[Former Member]

Hi

Had the same issue today and found the solution, so I'll post it:

Snapshots can be viewed  by: "SELECT  * FROM "SYS"."M_SNAPSHOTS".

"Be aware that this command fails if snapshots exist

(“general error: Shrink canceled, probably because of

snapshot pages”). In this case you can proceed

according to SAP Note 1999880 (“How can

RECLAIM DATAVOLUME be executed when system

replication is active?”)."