USERSPACE8K state

[Retho]

Hello everybody,

I'm just trying to create a table within a DB2 database that already exists within another Schema.
But both ways (using the CREATE LIKE statement resp. using the full CREATE statement) leads to the following result:

SQLSTATE=55039 Access to tablespace is not allowed (or similar text).

The table has to be created within the USERSPACE8K. That one exists and does not seem to have anything that should not be (well I'm not sure where to check this exactly, I only looked on the USERSPACE8K using the server tool).

Within the db2diag.log the following error (between " and " ) occurs:
"Tablespace USERSPACE8K (3) is in state x4000.
Starting it failed. rc=1ec1 ffff .Áÿÿ "

A few lines above I can read the following:
"Error checking container 0 (E:\db2\node0000\sql00005\userspace8k) for tbsp 3. Rc = FFFFF611"
But the file userspace8k does not exist.

A few more lines above the following is mentioned (it's my own translation, 'cause I'm getting all these messages in german):
"DIA9999E An internal error occured. Please report the following error code:
"FFFFC11E"."

Does anybody know why I cannot create that particular table?

Many thanks in advance
Kind regards

 

[sathyarams]

Looks like your tablespace container path is missing .,..

Check if E:\db2\node0000\sql00005\userspace8k is accessible

Cheers
sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[Retho]

Thank you for your answer.

I already wondered myself 'cause a file/dir with that name does not exist in that particular place. But I'm not an admin (neither server nor DB2) so I did not create a directory there and I also do not know what measures should be taken within the DB2 server control in order to fix that.

Does a copy of antoher userspace8k dir or a creation of such a dir solve this problem?