DB004037: DROP File was not allowed.

[Sushil Joseph]

Hello, 

Good morning.

We have tried to update a few operations to ALTER Segments in one of the Segments GESRDICT to issue ALTER Segment successfully then after the DROP file throws the below error message. 

DROP FILE GESRDICT.FI-GESRLOGF;
Status = -4       SQLSTATE = 64000        Messages follow:
DB004037 T1714 C-4M6016: FILE GESRDICT.FI-GESRLOGF contains active definitions - DROP not allowed

Once we succeed in the DROP file, we coded Syntax to CREATE File and CREATE Area definition. But, we ended with the message DB004037 for the below reason.

A request to DROP the named occurrence is denied. The occurrence contains active definitions: FILE has been mapped to one or more AREA(s); AREA contains active TABLE, VIEW and/or INDEX definition(s).

Kindly have a look and if any thoughts really help us. 


Thanks,
Sushil Joseph

[Sushil Joseph]

Hello, 

Good morning.

We are able to fix the definition after adding DROP Physical Area <SegmentName.AreaName>; before the DROP file GESRDICT.FI-GESRLOGF; syntax works fine. 

It gets success the CREATE File and AREA definition follows. 


Thanks,
Sushil Joseph