By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

What is the min container size for DMS?

P: 1
We are getting this error message in the AIX-BCU environment with DB2 V9.
SQL1422N The size of the container is invalid. SQLSTATE=54039...

What we specified is this:

the page size = 16384 MANAGED BY DATABASE
extent size = EXTENTSIZE 16

and we are using

USING (FILE '/edw/.......' 32) ON
according to the manual, "The container size should be 2*extensize

Here is the problem: based on the table size, we need no more 10 pages per container (we have 62 conatiner in total) for this table. If I go up to 100 pages/conatiner DB2 is happy. So what is the min pages required and how is it decided?
Oct 16 '07 #1
Share this Question
Share on Google+
1 Reply

P: 1
Atleast 6 extents are required in each container to get started.
With your extentsize that means 96 pages......
Nov 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.