Search dba-db2.com
*Use the Comments section for questions
Recent Posts
DB2 – How to check if autoresize is enabled
14 January,2013 by Tom Collins
Creating a tablespace with Autoresize enabled is straightforward. An example:
CREATE TABLESPACE TBLDMS4 MANAGED BY DATABASE USING (FILE '/db2db/TBLDMS4' 10 M) AUTORESIZE YES
If the tablespace is already created how can you identify if autoresize is enabled?
Use the tablespace monitor snapshot output monitor output.
db2 get snapshot for tablespaces on MYDB
For Automatic Storage check “Using automatic storage” – if it’s “1” than it’s enabled for Automatic Storage.For automatic resize check “Auto-resize enabled” and if it’s “Yes”
Read More
SQL0286N A default table space could not be found - DBA DB2
How to check for DB2 Direct IO and FILE SYSTEM CACHING - DBA ...
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |