These are the database files. If you delete them manually your tablespaces will become inaccessible and you will lose data in the tables. Check which tablespace this file belongs to using "db2pd -d <dbname> -tab" Then check which tables are in that tablespace and see if you can delete some data from any of the tables in that tablespace. Then finally you can do this "alter tablespace <tablespace name> reduce max" and this should reduce the file size and release the space back to OS.
------------------------------
Bujji Phanikiran V
------------------------------
Original Message:
Sent: Wed September 04, 2024 04:24 AM
From: Raul Gomez Agun
Subject: Clean data from db2 database in docker
I have in my local system (windows) an image of DB2 in docker, I have some files in C:\UtilesSTL\Docker\data\db2inst2\NODE0000\ISTL\T0000002 with too much space and this is fulling my local disc. How I can purge this files. For example, I have C0000000.LRG with 50 gb and growing. are there some command for reduce that files?
------------------------------
Raul Gomez Agun
------------------------------