Question & Answer
Question
Why does db2 alter tablespace fail with SQL0290N Table space access is not allowed. SQLSTATE=55039?
Cause
The error occurs because there is another alter tablespace command running in the background.
Answer
Issue the following command as the instance owner to check the status on the command:
db2 connect to tsmdb1
db2 set schema tsmdb1
db2 "select num_extents_left from table(sysproc.MON_GET_EXTENT_MOVEMENT_STATUS('TABLESPACENAME',-1)) "
When num_extents_left changes to 0 or -1, the command is finished. Rerun the failing command after the first one completes.
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.3;7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Product Synonym
TSM ITSM ADSM IBM Spectrum Protect
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21961200