Question & Answer
Question
Why do I have big '*.LRG' files under 'db2' directory, like:
$SCAPI_HOME/ db2/db2inst1/db2inst1/NODE0000/SCAPIDB/T0000004
rw------- 1 db2inst1 db2iadm1 422718734336 Aug 1 07:32 C0000000.LRG
Answer
We can apply the following 'DB2' commands to reduce table-space size:
db2 connect to SCAPIDB
db2 alter tablespace TSAA_LARGE reduce max;
db2 alter tablespace TSAA_HUGE reduce max;
db2 alter tablespace TSAA_SMALL reduce max;
db2 alter tablespace TSAA_RDF reduce max;
db2 terminate
-- these commands can be run against an active database.
-- they might take up to 20 minutes to take full effect.
-- the effect can have be small or large - depends on the churn/usage on the system
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSJQQ3","label":"IBM Operations Analytics - Predictive Insights"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Historical Number
TS002560472
Was this topic helpful?
Document Information
Modified date:
28 August 2019
UID
ibm11071972