Skip to Content
0
Mar 26, 2011 at 02:00 PM

DB21005E An error occurred while accessing the file ccms_XXXXXXXXX.sql

2916 Views

Hi Guys

Im facing an odd issue when performing some DB Administration tasks like tablespace alter using DBACOCKPIT

i.e When im trying to increase the size of a tablespace container, SAP generates a SQL statement named ccms_xxxxxxxxxx.sql, where xxxxxxxx is the date and system when you are performing the update

But after submitting Execute, its showing an error occurred accessing the file, which is temporarily staged under work directory.

Its showing Command DB6CLP failed on server etgrws01

DB21005E An error occurred while accessing the file

"ccms_D0120110326085542.sql".

Im able to access that file at OS level using either SAPSID or DB2SID so not sure why while using DBACOCKPIT, im unable to execute the SQL sentence

-rw-rw---- 1 d01adm sapsys 148 Mar 26 08:55 ccms_D0120110326085542.sql

As a workaround I have to perform the command using DB2 commands.

If you can shed some light on what kind of permission error im getting here would be appreciated.

PS: As additional information, this transaction was working fine over the last few weeks, and the last activity that might have some impact on this, was a server move.

Thanks!

Martin