CRJAZ0265I The virtual storage or database resource is not a

Hello,

I am getting the same error when trying to create tables for RPC, using DB2 9.5.

The database was created using the command :

db2 create database JAZZ on c: using codeset UTF-8 territory en PAGESIZE 8192

The command was successful. I can connect to the database, using the db2admin user and password. But as soon as I start creating tables using

repotools -createTables

I get the error:

Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)
IBM Rational Project Conductor, Version 1.0 (I20091103_1356)

Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jazz\provisi
on_profiles".
Rational Jazz Team Server (RPC) - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09053
Db URL: jdbc:db2://localhost:50000/JAZZ
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//localhost:50000/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ0256I An exception occurred creating content tablespace.

The database tables were not created.

Can Anyone help please?

atimsal wrote:

Hello,

I am getting the same error when trying to create tables for RPC,
using DB2 9.5.

The database was created using the command :

db2 create database JAZZ on c: using codeset UTF-8 territory en
PAGESIZE 8192

The command was successful. I can connect to the database, using the
db2admin user and password. But as soon as I start creating tables
using

repotools -createTables

I get the error:

Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)
IBM Rational Project Conductor, Version 1.0 (I20091103_1356)

Provisioning using "C:\Program
Files\IBM\JazzTeamServer\server\conf\jazz\provisi
on_profiles".
Rational Jazz Team Server (RPC) - Standard
CRJAZ1363I Loading configuration from
"file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location:
//localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09053
Db URL: jdbc:db2://localhost:50000/JAZZ
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database
"//localhost:50000/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ0256I An exception occurred creating content tablespace.

The database tables were not created.

Can Anyone help please?

That looks right for RTC - for RQM the pagesize should be 16384. You

will need to look at the repotools log and the db2diag.log - they will
probably give clues as to what went wrong.

The Db2user has got all the necessary privileges on the Database.

When did a directory searching for the db2 log file C: do a dir /s db2diag.log

Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\mavilaa>cd\

C:\>ir /s db2diag.log
'ir' is not recognized as an internal or external command,
operable program or batch file.

C:\>dir /s db2diag.log
Volume in drive C has no label.
Volume Serial Number is D095-6491

Directory of C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2CO
PY1\DB2

02/12/2010 11:54 PM 220,840 db2diag.log
1 File(s) 220,840 bytes
The directory name C:\Documents and Settings\All Users\Application Data\IBM\Inst
allation Manager\adapters\native\IBM Rational SDLC\com.ibm.rational.clearquest.e
c.cqec.eclipse.installContext\com.ibm.rational.clearquest.rcp.app.feature.produc
t.win32.win32.x86_7.1000.0.v200811102215-BTIh8EEnFR4UhZvVdvYxogMz-yiQ is too lon
g.
The directory name C:\Documents and Settings\All Users\Application Data\IBM\Inst
allation Manager\adapters\native\IBM Rational SDLC\com.ibm.rational.clearquest.e
c.designer.eclipse.installContext\com.ibm.rational.clearquest.designer.app.featu
re.product.win32.win32.x86_7.1.0.v200811102144-82EEUA5EHdV-SX3t90b9z0EjmqN6 is t
oo long.
The directory name C:\Documents and Settings\All Users\Application Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery Platform\com.ibm.sdp.ecli
pse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R342
_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.
The directory name C:\Documents and Settings\All Users\Application Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery Platform_1\com.ibm.sdp.ec
lipse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R3
42_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.

Total Files Listed:
1 File(s) 220,840 bytes
0 Dir(s) 2,509,193,216 bytes free

the output is as above.

This usually occurs when the the DB2 user does not have enough permissions. The DB2 user must have permissions to create tables, tablespaces, and modify the database configuration.

You might want to verify that before you run repotools again :-)

good luck

Sudhir

Hello,

I am getting the same error when trying to create tables for RPC, using DB2 9.5.

The database was created using the command :

db2 create database JAZZ on c: using codeset UTF-8 territory en PAGESIZE 8192

The command was successful. I can connect to the database, using the db2admin user and password. But as soon as I start creating tables using

repotools -createTables

I get the error:

Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)
IBM Rational Project Conductor, Version 1.0 (I20091103_1356)

Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jazz\provisi
on_profiles".
Rational Jazz Team Server (RPC) - Standard
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09053
Db URL: jdbc:db2://localhost:50000/JAZZ
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//localhost:50000/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ0256I An exception occurred creating content tablespace.

The database tables were not created.

Can Anyone help please?

amavila wrote:

The Db2user has got all the necessary privileges on the Database.

When did a directory searching for the db2 log file C: do a dir /s
db2diag.log

Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\mavilaa>cd\

C:\>ir /s db2diag.log
'ir' is not recognized as an internal or external command,
operable program or batch file.

C:\>dir /s db2diag.log
Volume in drive C has no label.
Volume Serial Number is D095-6491

Directory of C:\Documents and Settings\All Users\Application
Data\IBM\DB2\DB2CO
PY1\DB2

02/12/2010 11:54 PM 220,840 db2diag.log
1 File(s) 220,840 bytes
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Rational
SDLC\com.ibm.rational.clearquest.e
c.cqec.eclipse.installContext\com.ibm.rational.clearquest.rcp.app.feature.produc
t.win32.win32.x86_7.1000.0.v200811102215-BTIh8EEnFR4UhZvVdvYxogMz-yiQ
is too lon
g.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Rational
SDLC\com.ibm.rational.clearquest.e
c.designer.eclipse.installContext\com.ibm.rational.clearquest.designer.app.featu
re.product.win32.win32.x86_7.1.0.v200811102144-82EEUA5EHdV-SX3t90b9z0EjmqN6
is t
oo long.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery
Platform\com.ibm.sdp.ecli
pse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R342
_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery
Platform_1\com.ibm.sdp.ec
lipse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R3
42_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.

Total Files Listed:
1 File(s) 220,840 bytes
0 Dir(s) 2,509,193,216 bytes free

the output is as above.


sudhir.balusuwrote:
This usually occurs when the the DB2 user does not have enough
permissions. The DB2 user must have permissions to create tables,
tablespaces, and modify the database configuration.
You might want to verify that before you run repotools again :-)

good luck

Sudhir

atimsalwrote:
Hello,
I am getting the same error when trying to create tables for RPC,
using DB2 9.5.
The database was created using the command :

db2 create database JAZZ on c: using codeset UTF-8 territory en
PAGESIZE 8192
The command was successful. I can connect to the database, using the
db2admin user and password. But as soon as I start creating tables
using
repotools -createTables

I get the error:

Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)
IBM Rational Project Conductor, Version 1.0 (I20091103_1356)

Provisioning using "C:\Program
Files\IBM\JazzTeamServer\server\conf\jazz\provisi
on_profiles".
Rational Jazz Team Server (RPC) - Standard
CRJAZ1363I Loading configuration from
"file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location:
//localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09053
Db URL: jdbc:db2://localhost:50000/JAZZ
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database
"//localhost:50000/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ0256I An exception occurred creating content tablespace.

The database tables were not created.

Can Anyone help please?

Well what are the contents of db2diag.log - you need to open it and see
if there are clues of why you can not create the tables, etc.

Hi,

Did the contents which I have posted from db2diag.log was helpful to find out what caused the issue.

amavila wrote:

The Db2user has got all the necessary privileges on the Database.

When did a directory searching for the db2 log file C: do a dir /s
db2diag.log

Microsoft Windows XP
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\mavilaa>cd\

C:\>ir /s db2diag.log
'ir' is not recognized as an internal or external command,
operable program or batch file.

C:\>dir /s db2diag.log
Volume in drive C has no label.
Volume Serial Number is D095-6491

Directory of C:\Documents and Settings\All Users\Application
Data\IBM\DB2\DB2CO
PY1\DB2

02/12/2010 11:54 PM 220,840 db2diag.log
1 File(s) 220,840 bytes
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Rational
SDLC\com.ibm.rational.clearquest.e
c.cqec.eclipse.installContext\com.ibm.rational.clearquest.rcp.app.feature.produc
t.win32.win32.x86_7.1000.0.v200811102215-BTIh8EEnFR4UhZvVdvYxogMz-yiQ
is too lon
g.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Rational
SDLC\com.ibm.rational.clearquest.e
c.designer.eclipse.installContext\com.ibm.rational.clearquest.designer.app.featu
re.product.win32.win32.x86_7.1.0.v200811102144-82EEUA5EHdV-SX3t90b9z0EjmqN6
is t
oo long.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery
Platform\com.ibm.sdp.ecli
pse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R342
_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.
The directory name C:\Documents and Settings\All Users\Application
Data\IBM\Inst
allation Manager\adapters\native\IBM Software Delivery
Platform_1\com.ibm.sdp.ec
lipse.ide\org.eclipse.equinox.p2.bootstrap.repository.win32.win32.x86_3.4.200.R3
42_v20090122-989JESTEbig-SVaL8UJHcYBr4A63-1253080472616 is too long.

Total Files Listed:
1 File(s) 220,840 bytes
0 Dir(s) 2,509,193,216 bytes free

the output is as above.


sudhir.balusuwrote:
This usually occurs when the the DB2 user does not have enough
permissions. The DB2 user must have permissions to create tables,
tablespaces, and modify the database configuration.
You might want to verify that before you run repotools again :-)

good luck

Sudhir

atimsalwrote:
Hello,
I am getting the same error when trying to create tables for RPC,
using DB2 9.5.
The database was created using the command :

db2 create database JAZZ on c: using codeset UTF-8 territory en
PAGESIZE 8192
The command was successful. I can connect to the database, using the
db2admin user and password. But as soon as I start creating tables
using
repotools -createTables

I get the error:

Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)
IBM Rational Project Conductor, Version 1.0 (I20091103_1356)

Provisioning using "C:\Program
Files\IBM\JazzTeamServer\server\conf\jazz\provisi
on_profiles".
Rational Jazz Team Server (RPC) - Standard
CRJAZ1363I Loading configuration from
"file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location:
//localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09053
Db URL: jdbc:db2://localhost:50000/JAZZ
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database
"//localhost:50000/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ0256I An exception occurred creating content tablespace.

The database tables were not created.

Can Anyone help please?

Well what are the contents of db2diag.log - you need to open it and see
if there are clues of why you can not create the tables, etc.