It's all about the answers!

Ask a question

DB2 9.1 Problem on a new server


Mark Parry (31121711) | asked Sep 25 '07, 9:21 a.m.
Has anyone run into the following error while running the repotools
-createTable command on 0.6M2a on Red Hat? I think its a problem with
DB2 not Jazz as it fails no matter what location I specify for the
tablespace.



Syntax error or access rule violation
SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file
/data/databases/jazz/db2inst1/NODE0000/JAZZ/tablespaces' 250000)
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -298, SQLSTATE: 428B2, SQLERRMC: null
SQL State: 428B2
Error Code: -298


I am running the repotools.sh as db2inst1 (the instance owner) and the
directory permission are as follows...

drwxr-xr-x 2 db2inst1 db2grp1 4096 Sep 24 16:46 tablespaces

Not that it should matter, but /data is a LVM volume.

3 answers



permanent link
Mark Parry (31121711) | answered Sep 27 '07, 11:08 a.m.
Tadayuki YOSHIDA wrote:
Hello, have you solved the problem?

Mark D. Parry wrote:
Yeah, I thought of that after my post. So I tried creating /tmp/tspace
using the db2inst1 user id and it still fails with the same error
message. It would appear that the location I'm specifying doesn't
matter. I'm at a complete loss.

I'm using Ubuntu feisty and also ran into the same tablespace problem.

The solution that works for me is to use relative path for
db.db2.content.tablespace.location instead of absolute path.
For example, I set the value as follows:
db.db2.content.tablespace.location=content_tablespace

Then repotools created a 1GB file "content_tablespace" under
/home/db2inst1/db2inst1/NODE0000/SQL00001/

Dropping the current "JAZZ" db and recreating it may be required.
Hope this helps.

Leaving the tablespace.location set to 'content_tablespace' did work.
End result is it created the tablespace under the directory where I
created the database. It would appear that one doesn't have to modify
this property so long as your happy with the tablespace name being
content_tablespace. Should this be written up as bug? I'm not convinced
it still isn't a issue with the DB2 setup.

-Mark

permanent link
Aaron Cohen (8207851) | answered Sep 25 '07, 1:57 p.m.
JAZZ DEVELOPER
I had the same problem and indeed it was permissions. The easiest way to determine if it is indeed permissions is point to a subdirectory of /tmp with the repotools and see if you get the same problem.

permanent link
Mark Parry (31121711) | answered Sep 25 '07, 3:27 p.m.
amcohen.us.ibm.com wrote:
I had the same problem and indeed it was permissions. The easiest way
to determine if it is indeed permissions is point to a subdirectory
of /tmp with the repotools and see if you get the same problem.



Yeah, I thought of that after my post. So I tried creating /tmp/tspace
using the db2inst1 user id and it still fails with the same error
message. It would appear that the location I'm specifying doesn't
matter. I'm at a complete loss.

Syntax error or access rule violation
SQL: CREATE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file
'/tmp/tspace' 2
50000)
SQL Exception #1
SQL Message: DB2 SQL error: SQLCODE: -298, SQLSTATE: 428B2, SQLERRMC: null
SQL State: 428B2
Error Code: -298

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.