CRJAZ0265I The virtual storage or database resource is not a
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran the batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran the batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
15 answers
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
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?
Hi,
I had the same problem installing RQM as part of CLM 3.0.1. I received error -968, which as I found somewhere on the web indicates that there isn't enough storage on the disk that the database is to be installed on. Increasing the available disk space from about 1.5 gigs to 4.5 solved my problem.
Hope this helps.
I had the same problem installing RQM as part of CLM 3.0.1. I received error -968, which as I found somewhere on the web indicates that there isn't enough storage on the disk that the database is to be installed on. Increasing the available disk space from about 1.5 gigs to 4.5 solved my problem.
Hope this helps.
Comments
Hi,
I had the same problem installing RQM as part of CLM 3.0.1. I received error -968, which as I found somewhere on the web indicates that there isn't enough storage on the disk that the database is to be installed on. Increasing the available disk space from about 1.5 gigs to 4.5 solved my problem.
Hope this helps.
That fixed the problem for me. I had 2.5GB of free space but it wasn't enough. After I increased my free space, I did not see the error anymore.
increasing free space solved the issue.
freed some, but it only started to work when df -m showed more than 0 available on db2 logging partition, even though it showed 1GB free. in Linux, 5% is reserved for root so it claimed whole 1GB free for internal purposes. onlyw when free space raised to 5,5gig it started to work
amavila wrote:
server can you do a db2 connect to <dbname> ? I create my databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the db2
server can you do a db2 connect to <dbname> ? I create my databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
No not beacuse of that . there is no backup defined for this.
server can you do a db2 connect to <dbname> ? I create my databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the db2
server can you do a db2 connect to <dbname> ? I create my databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
On 2/8/2010 4:08 AM, amavila wrote:
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command ?
No not beacuse of that . there is no backup defined for this.
dmehaffywrote:
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran
the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not
available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the
db2
server can you do a db2 connect to<dbname> ? I create my
databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command ?
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
Yes I can connect to the Database. Connect to <DBName> user db2admin using <password> which connects me to the DB.
Database I have created using the GUI.
Is there any specific commands to be executed.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command ?
first thing you want to do. Also what is you database create command
Yes I can connect to the Database. Connect to <DBName> user db2admin using <password> which connects me to the DB.
Database I have created using the GUI.
Is there any specific commands to be executed.
On 2/8/2010 4:08 AM, amavila wrote:
No not beacuse of that . there is no backup defined for this.
dmehaffywrote:
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran
the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not
available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the
db2
server can you do a db2 connect to<dbname> ? I create my
databases
with trakmod on so I can do online backups and sometimes forget to do
the initial backup which gives the same error message when you try to
run repotools because the database is in backup pending and will not
allow you to connect.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command ?
amavila wrote:
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
?
Can you post your command for creating the database and when you get the
error on the RQM side can you also post the contents of db2diag.log at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
Yes I can connect to the Database. Connect to <DBName> user
db2admin using <password> which connects me to the DB.
Database I have created using the GUI.
Is there any specific commands to be executed.
dmehaffywrote:
On 2/8/2010 4:08 AM, amavila wrote:
No not beacuse of that . there is no backup defined for this.
dmehaffywrote:
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran
the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not
available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the
db2
server can you do a db2 connect to<dbname> ? I create my
databases
with trakmod on so I can do online backups and sometimes forget to
do
the initial backup which gives the same error message when you try
to
run repotools because the database is in backup pending and will
not
allow you to connect.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
?
Can you post your command for creating the database and when you get the
error on the RQM side can you also post the contents of db2diag.log at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
Hi,
I do not see the db2dump folder.
C:\Program Files\IBM\SQLLIB
and even the log file.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
?
Can you post your command for creating the database and when you get the
error on the RQM side can you also post the contents of db2diag.log at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
I do not see the db2dump folder.
C:\Program Files\IBM\SQLLIB
and even the log file.
amavila wrote:
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
Yes I can connect to the Database. Connect to <DBName> user
db2admin using <password> which connects me to the DB.
Database I have created using the GUI.
Is there any specific commands to be executed.
dmehaffywrote:
On 2/8/2010 4:08 AM, amavila wrote:
No not beacuse of that . there is no backup defined for this.
dmehaffywrote:
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran
the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not
available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the
db2
server can you do a db2 connect to<dbname> ? I create my
databases
with trakmod on so I can do online backups and sometimes forget to
do
the initial backup which gives the same error message when you try
to
run repotools because the database is in backup pending and will
not
allow you to connect.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
?
Can you post your command for creating the database and when you get the
error on the RQM side can you also post the contents of db2diag.log at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
On 2/11/2010 11:23 AM, amavila wrote:
Can you post your command for creating the database and when you get
the
error on the RQM side can you also post the contents of db2diag.log
at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
I forgot you are on windows. You can find it by opening a dos window
and from C: do a dir /s db2diag.log
Also please post your create command that you used on the db2 server to
create the rqm database.
Hi,
I do not see the db2dump folder.
C:\Program Files\IBM\SQLLIB
and even the log file.
dmehaffywrote:
amavila wrote:
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create
command
Yes I can connect to the Database. Connect to<DBName> user
db2admin using<password> which connects me to the DB.
Database I have created using the GUI.
Is there any specific commands to be executed.
dmehaffywrote:
On 2/8/2010 4:08 AM, amavila wrote:
No not beacuse of that . there is no backup defined for this.
dmehaffywrote:
amavila wrote:
Hi,
I tried to configure RQM version 2.0.0.1 with DB2 9.5 and when ran
the
batch file. repotools -createTables t is giving the error.
CRJAZ0265I The virtual storage or database resource is not
available
The table space size is set to 1024 already but still no luck.
Did anyone come accross this situation.
I assume you created a database on the db2 server? Also from the
db2
server can you do a db2 connect to<dbname> ? I create my
databases
with trakmod on so I can do online backups and sometimes forget to
do
the initial backup which gives the same error message when you try
to
run repotools because the database is in backup pending and will
not
allow you to connect.
Can you connect to the database on the db server side ? That is the
first thing you want to do. Also what is you database create command
?
Can you post your command for creating the database and when you get
the
error on the RQM side can you also post the contents of db2diag.log
at
that point which can be found at sqllib/db2dump/db2diag.log. I think
between those two I can help you solve the problem.
I forgot you are on windows. You can find it by opening a dos window
and from C: do a dir /s db2diag.log
Also please post your create command that you used on the db2 server to
create the rqm database.
page 1of 1 pagesof 2 pages