Tagged Questions
2
votes
1answer
110 views
DB2 Server Table Space Locked
At work we keep receiving the following DataException seemingly at random when one of our processes tries to write/access a table for one of our clients:
com.ibm.db.DataException: A database manager ...
2
votes
1answer
132 views
How to create Buffer Pool in Database dedicated only for ONE BIG table?
I have table TICKET with 400K records in database (DB2).
I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it?
...
3
votes
1answer
389 views
DB2: Is it good to create the index table space to use 32 KB data page
I found our DB2 server configs all the index into one table space. And it then defines the table space to use 32kb data page. Is this good? How to judge it? Any advice is welcome.
2
votes
1answer
100 views
DB2: Is it good to create the LONG table space to use 32 KB data page
Our DB2 database(V9.7) has only defined one table space to store all the big object like xml.
And xml size could be different. Some are about 2kb average. And some are 7kb average.
So does it make ...
3
votes
1answer
790 views
DB2 9.5 How to get tablespace monitor information?
How can I get information about tablespace in DB2 9.5?
I need to review information about if the autoresize option is enabled or disabled.
