Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 1342

A database storage unit that groups related logical structures together.

2
votes
table to the new table. Drop the old table. While you can associate tablespaces with different bufferpools using the ALTER TABLESPACE statement, tables can only be associated with one tablespace. You …
answered Feb 12 '13 by Chris Aldrich
3
votes
like LONG VARCHAR) into their own tablespaces. Main reason is for maintenance and support. If the data is in different tablespaces you can backup/restore based on your needs. For example, table data is …
answered Aug 15 '12 by Chris Aldrich
1
vote
Check out the general answer I gave to you on your other question. If you are storing your XML as a LOB, then I guess I'd see what is the common average size per table. If the average size is 4MB or …
answered Aug 15 '12 by Chris Aldrich
1
vote
First I'd say you want to know what tablespace it is. A lot of times I connect to the database and use LIST TABLESPACES SHOW DETAIL to figure out what is happening. Look at each tablespace and see … ) as TBSP_STATE from TABLE(MON_GET_TABLESPACE('',-2)) with ur This gets all tablespaces with a human readable state. Found this off of Ember Crooks' blog, which I follow. Very useful. Anyway first …
answered Mar 12 '13 by Chris Aldrich
3
votes
Use the TBSP_UTILIZATION administrative view - Retrieve table space configuration and utilization information. See the "Essential DB2 Health Check" for a recommendation on how to use it, especially th …
answered Feb 8 '12 by Chris Aldrich