Unanswered: How to reduce the size of my DB2 database?
I have a test DB2 in my VM, now my C:\DB2 folder has 19G, but I don't think I have this much of data in it. Can anyone tell me how to reduce the size this DB2 folder occupies? I am not an DBA don't know how to deal with it, but I need to free some spaces.
Suggest you determine how much database data IS IN the folder/database before attempting to reduce the space used.
I find out I have three database, each file (C:\DB2\ccm\content_tablespace) has 4G. For sure, I don't have this much data in these database.
How can I determine how much database data IS IN the folder/database? I know I can Alert Tablespace to reduce the size.