Question & Answer
Question
Why do DROP and TRUNCATE commands appear to be hanging?
Answer
If you run the DROP or TRUNCATE command on a table and it is taking an unusually long time to complete, check whether a backup of the database is in progress. While a backup is running on a database, you cannot drop or truncate a table in that database until the backup completes. The DROP TABLE and TRUNCATE TABLE commands will appear to hang until the backup finishes.
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ794145
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21567442