Cannot create tables - "Error querying tablespace size&
Hello,
I recently installed BETA3 (server and client). However, when attempting to create tables for my DB2 database (using "repotools createTables"), I get the error below (see page bottom). So I tried doing some investigation from the DB2-side, and discovered that when I execute the createTables option, repotools actually successfully logs into the intended database. So that tells me that it is aware of the DB2 instance and database. Therefore I do not doubt that the utility is able to access the DB2 db. I also granted the db user full access, but to no avail. Has anyone run into and resolved a similar problem? If so, please could you advise? Thanks ============================================================= C:\jazz\Beta3-Platform\server>repotools createTables Repo Tools, Version 1.0 Beta 3 Provisioning using "./provision_profiles". Rational Jazz Team Server - Standard (Early Access) Loading configuration from "file:teamserver.properties". Fulltext Index Location: workitemindex\fulltext_index\ Initial database connection successful Db Product Name: DB2/SUN64 Db Product Version: SQL09010 Db Name/Location: //QSRVER:50000/JAZZCOBI:fullyMaterializeLobData=false;user= xxxxxxxx;password=xxxxxxxx; Creating the tables for the database "//QSRVER:50000/JAZZCOBI:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;" with indices. CRJAZ0258I Error querying tablespace size C:\jazz\Beta3-Platform\server> |
2 answers
I had a similar problem that I fixed by reinstalling the DB2 database making sure I was logged into Windows as db2admin when I did it.
I had previously installed DB2 logged in as my own user which meant that the permissions were all incorrect. Comments
Alastair Beadle
commented Jun 25 '13, 8:49 a.m.
I know this is an old thread but for reference: this was the solution for me too - uninstall DB2 and reinstall making sure to "run as administrator" on the installer.
|
This problem can occur when the DB2 server running on UNIX style platforms if any directory that is in the path to any database file on server that has permissions that are less permissive than 775.
For example, let us say you have a datfile /db2/db2inst1/jazzdb/contentts.dbf. All the directories /db2, /db2/db2inst1 and /db2/db2inst1/jazzdb must have permissions for the group to modify their contents. |
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.
Comments
Was this ever resolved. I too am getting this exact same error with DB2 9.7.6 on AIX 6.1 TL7. I have made sure the permissions are 775 recursive on the directories containing the databases (JTS, CCM and DW). Using the jts/setup ui this fails on the JTS database setup create tables. I have noticed that after it fails one directory NODE0000/JTS/T0000001 has it permissions changed to 711.