Our company sells a software package that uses many different RDBMS for storage. Shown below is the default storage objects for DB2. This software package could require large database storage, but ...
http://www.experts-exchange.com/Database/DB2/Q_22055064.html
Zones:
DB2Date Answered: 01/30/2007 Rating: 8.2 Views: 0
We encountered this issue:
[DB2]A temporary table space with sufficient page size does not exist.
By default, we create a temporary tablespace defines as User temporary tablespace. We were able...
http://www.experts-exchange.com/Database/DB2/Q_24389268.html
Zones:
DB2,
DatabasesDate Answered: 05/12/2009 Rating: 9.1 Views: 47
1) We have db2 7.1 EE server installed on AIX 5.2 midrange.
2) We need to estimate table tablespaces, index tablespaces and temporary tablespace sizes for the tables into we which we will be mig...
http://www.experts-exchange.com/Database/DB2/Q_20728958.html
Zones:
DB2Date Answered: 05/17/2004 Rating: 7.4 Views: 8
Is this possible? I'm using DB2 5.1 running in mainframe.
http://www.experts-exchange.com/Database/DB2/Q_21553400.html
Zones:
DB2Date Answered: 01/16/2006 Rating: 8.6 Views: 0
In DB2, how do I assign a default tablespace to a user? User MYUSER should have a default tablespace of MYDATA.
In other words, when a CREATE TABLE statement is executed by MYUSER and the IN TAB...
http://www.experts-exchange.com/Database/DB2/Q_22052595.html
Zones:
DB2Date Answered: 11/08/2006 Rating: 9.2 Views: 8
Dear all,
Is there any method to know the DB2 tablespace during runtime? I am using Java application and SQLJ to access IBM DB2 V7. My table is partitioned and I want my program to know if one ...
http://www.experts-exchange.com/Database/DB2/Q_20805618.html
Zones:
DB2Date Answered: 04/26/2004 Rating: 7.8 Views: 0
What is the command in DB2 to move an index from tablespaceA to tablespaceB?
http://www.experts-exchange.com/Databases/IBM_UDB/Q_22052277.html
Zones:
DB2Date Answered: 11/08/2006 Rating: 7.4 Views: 103
Hi!
I have a DB2 v.8.2. on AIX that has several SMS tablespaces with lots of tables and data in them.
I have a full offline backup of the db.
Now I want to create a DMS tablespaces and mo...
http://www.experts-exchange.com/Database/DB2/Q_22661706.html
Zones:
DB2Date Answered: 06/29/2007 Rating: 7.6 Views: 4
Hi all,
We install DBv9.5 64-bit on a Linux server. While creating user tablespaces (e.g., TS0004k regular) we find that DB2 control center does not allow us to add the container location for the ...
http://www.experts-exchange.com/Database/DB2/Q_23501545.html
Zones:
DB2,
LinuxDate Answered: 06/23/2008 Rating: 9.9 Views: 0
